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);
}
