public IActionResult UpdateProposeSongs() { using (var db = new SongRecommendContext()) { var count = 0; foreach (var song in db.ProposeSong) { //--------------------------- // 좋아요 가져오기 //--------------------------- HttpClient client = new HttpClient(); var jsonString = client.GetStringAsync($"https://www.melon.com/commonlike/getSongLike.json?contsIds={song.SongId}").Result; var like = 0; try { like = JObject.Parse(jsonString).Value <IEnumerable <JToken> >("contsLike").First().Value <int>("SUMMCNT"); } catch { } song.Like = like; song.Rate = AnalyzeRateSvc.Execute(song.Lyric).Rate; count++; } db.SaveChanges(); return(Ok(count)); } }
public IActionResult CalcSongsRate() { using (var db = new SongRecommendContext()) { foreach (var song in db.ProposeSong) { song.Rate = AnalyzeRateSvc.Execute(song.Lyric).Rate; } db.SaveChanges(); return(Ok()); } }
public IActionResult CalcWordsRate() { using (var db = new SongRecommendContext()) { var totalPositive = db.BaseWord.Sum(x => x.PositivePoint * 100); var totalNegative = db.BaseWord.Sum(x => x.NegativePoint * 100); foreach (var word in db.BaseWord) { word.Rate = AnalyzeRateSvc.GetAdjustedRate(word.PositivePoint * 100, word.NegativePoint * 100, totalPositive, totalNegative); } db.SaveChanges(); return(Ok()); } }