public static async Task RemoveAsync(NicoVideoInfo nicoVideoInfo)
{
using (var releaser = await _AsyncLock.LockAsync())
using (var db = new NicoVideoDbContext())
{
db.VideoInfos.Remove(nicoVideoInfo);
await db.SaveChangesAsync();
}
}
public static async Task UpdateAsync(NicoVideoInfo info)
{
using (var releaser = await _AsyncLock.LockAsync())
using (var db = new NicoVideoDbContext())
{
info.LastUpdated = DateTime.Now;
db.VideoInfos.Update(info);
await db.SaveChangesAsync();
}
}
public static async Task UpdateNicoVideoInfo(NicoVideoInfo info, WatchApiResponse watchApiRes)
{
info.DescriptionWithHtml = watchApiRes.videoDetail.description;
info.ThreadId = watchApiRes.ThreadId.ToString();
info.ViewCount = (uint)watchApiRes.videoDetail.viewCount.Value;
info.MylistCount = (uint)watchApiRes.videoDetail.mylistCount.Value;
info.CommentCount = (uint)watchApiRes.videoDetail.commentCount.Value;
info.PrivateReasonType = watchApiRes.PrivateReason;
await UpdateAsync(info);
}
public static async Task UpdateNicoVideoInfo(NicoVideoInfo info, DmcWatchResponse watchApiRes)
{
info.DescriptionWithHtml = watchApiRes.Video.Description;
info.ThreadId = watchApiRes.Thread.Ids.Default;
info.ViewCount = (uint)watchApiRes.Video.ViewCount;
info.MylistCount = (uint)watchApiRes.Video.MylistCount;
info.CommentCount = (uint)watchApiRes.Thread.CommentCount;
//info.PrivateReasonType = watchApiRes.;
await UpdateAsync(info);
}
public static async Task UpdateNicoVideoInfo(NicoVideoInfo info, ThumbnailResponse thumbnailRes)
{
info.VideoId = thumbnailRes.Id;
info.HighSize = (uint)thumbnailRes.SizeHigh;
info.LowSize = (uint)thumbnailRes.SizeLow;
info.Length = thumbnailRes.Length;
info.MovieType = thumbnailRes.MovieType;
info.PostedAt = thumbnailRes.PostedAt.DateTime;
info.UserId = thumbnailRes.UserId;
info.UserType = thumbnailRes.UserType;
info.Description = thumbnailRes.Description;
info.ThumbnailUrl = thumbnailRes.ThumbnailUrl.AbsoluteUri;
info.Title = thumbnailRes.Title;
info.ViewCount = thumbnailRes.ViewCount;
info.MylistCount = thumbnailRes.MylistCount;
info.CommentCount = thumbnailRes.CommentCount;
info.SetTags(thumbnailRes.Tags.Value.ToList());
await UpdateAsync(info);
}
public static async Task <NicoVideoInfo> GetEnsureNicoVideoInfoAsync(string rawVideoId)
{
using (var db = new NicoVideoDbContext())
{
var info = db.VideoInfos.SingleOrDefault(x => x.RawVideoId == rawVideoId);
if (info == null)
{
info = new NicoVideoInfo()
{
RawVideoId = rawVideoId,
LastUpdated = DateTime.Now
};
using (var releaser = await _AsyncLock.LockAsync())
{
db.VideoInfos.Add(info);
await db.SaveChangesAsync();
}
}
return(info);
}
}