static public List <MylistItemIdContainer> GetItemIdList(string mylistGroupId, IEnumerable <string> videoIds) { var db = HohoemaLiteDb.GetTempLiteRepository(); HashSet <string> s = new HashSet <string>(videoIds); return(db.Fetch <MylistItemIdContainer>(x => x.MylistGroupId == mylistGroupId && s.Contains(x.VideoId))); }
static MylistDb() { var db = HohoemaLiteDb.GetTempLiteRepository(); var col = db.Database.GetCollection <MylistItemIdContainer>(); col.EnsureIndex(x => x.VideoId); col.EnsureIndex(x => x.MylistGroupId); }
public static void AddOrUpdateFeedResult(Models.Subscription.Subscription subscription, Models.Subscription.SubscriptionSource source, IEnumerable <string> items) { var db = HohoemaLiteDb.GetTempLiteRepository(); var feedResult = db.SingleOrDefault <SubscriptionFeedResult>(x => x.SubscriptionId == subscription.Id) ?? new SubscriptionFeedResult() { SubscriptionId = subscription.Id } ; feedResult.AddOrUpdateFeedResultSet(source, items); db.Upsert(feedResult); }
public static SubscriptionFeedResult GetEnsureFeedResult(Models.Subscription.Subscription subscription) { var db = HohoemaLiteDb.GetTempLiteRepository(); var feedResult = db.SingleOrDefault <SubscriptionFeedResult>(x => x.SubscriptionId == subscription.Id); if (feedResult == null) { feedResult = new SubscriptionFeedResult() { SubscriptionId = subscription.Id, FeedResultItems = new List <FeedResultSet>() }; db.Insert(feedResult); } return(feedResult); }
static public bool RemoveItemId(MylistItemIdContainer item) { var db = HohoemaLiteDb.GetTempLiteRepository(); return(db.Delete <MylistItemIdContainer>(x => x.VideoId == item.VideoId && x.MylistGroupId == item.MylistGroupId) > 0); }
static public MylistItemIdContainer GetItemId(string mylistGroupId, string videoId) { var db = HohoemaLiteDb.GetTempLiteRepository(); return(db.SingleOrDefault <MylistItemIdContainer>(x => x.VideoId == videoId && x.MylistGroupId == mylistGroupId)); }
static public void AddItemId(IEnumerable <MylistItemIdContainer> items) { var db = HohoemaLiteDb.GetTempLiteRepository(); db.Upsert <MylistItemIdContainer>(items); }
static public void AddItemId(MylistItemIdContainer item) { var db = HohoemaLiteDb.GetTempLiteRepository(); db.Upsert <MylistItemIdContainer>(item); }
static public void Clear() { var db = HohoemaLiteDb.GetTempLiteRepository(); db.Delete <MylistItemIdContainer>(Query.All()); }
static public void Clear(string mylistGroupId) { var db = HohoemaLiteDb.GetTempLiteRepository(); db.Delete <MylistItemIdContainer>((x) => x.MylistGroupId == mylistGroupId); }
public static bool DeleteFeedResult(Models.Subscription.Subscription subscription) { var db = HohoemaLiteDb.GetTempLiteRepository(); return(db.Delete <SubscriptionFeedResult>(x => x.SubscriptionId == subscription.Id) > 0); }