public static CacheInvalidationTable GetUnprocessedData(int commandTimeout = -1) { var cmdText = GetSelectCommandText(CacheInvalidationTable.ColumnSet.All) + " WHERE IsCommonCacheInvalidated=0" + " ORDER BY Id"; var cmd = VoteCacheDb.GetCommand(cmdText, commandTimeout); return(FillTable(cmd, CacheInvalidationTable.ColumnSet.All)); }
public static int DeleteExpiredTransactions( DateTime expiration, int commandTimeout = -1) { const string cmdText = "DELETE FROM CacheInvalidation WHERE CacheTimeStamp<@Expiration"; var cmd = VoteCacheDb.GetCommand(cmdText, commandTimeout); VoteCacheDb.AddCommandParameter(cmd, "Expiration", expiration); return(VoteCacheDb.ExecuteNonQuery(cmd)); }
public static CacheInvalidationTable GetNewTransactions( int lastId, int commandTimeout = -1) { var cmdText = GetSelectCommandText(CacheInvalidationTable.ColumnSet.All) + " WHERE IsCommonCacheInvalidated=1" + " AND Id > @LastProcessedId" + " ORDER BY Id"; var cmd = VoteCacheDb.GetCommand(cmdText, commandTimeout); VoteCacheDb.AddCommandParameter(cmd, "LastProcessedId", lastId); return(FillTable(cmd, CacheInvalidationTable.ColumnSet.All)); }
public static CachePagesTable GetUnexpiredPageImage(string pageType, string pageKey, DateTime minDateStamp, int commandTimeout = -1) { var cmdText = SelectAllCommandText + " WHERE PageType=@PageType AND PageKey=@PageKey AND DateStamp>=@DateStamp"; var cmd = VoteCacheDb.GetCommand(cmdText, commandTimeout); VoteCacheDb.AddCommandParameter(cmd, "PageType", pageType); VoteCacheDb.AddCommandParameter(cmd, "PageKey", pageKey); VoteCacheDb.AddCommandParameter(cmd, "DateStamp", minDateStamp); return(FillTable(cmd, CachePagesTable.ColumnSet.All)); }
public static void Upsert(string pageType, string pageKey, DateTime dateStamp, byte[] pageImage, int commandTimeout = -1) { const string cmdText = "INSERT INTO CachePages (PageType,PageKey,DateStamp,PageImage)" + " VALUES (@PageType,@PageKey,@DateStamp,@PageImage)" + " ON DUPLICATE KEY UPDATE DateStamp=VALUES(DateStamp),PageImage=VALUES(PageImage)"; var cmd = VoteCacheDb.GetCommand(cmdText, commandTimeout); VoteCacheDb.AddCommandParameter(cmd, "PageType", pageType); VoteCacheDb.AddCommandParameter(cmd, "PageKey", pageKey); VoteCacheDb.AddCommandParameter(cmd, "DateStamp", dateStamp); VoteCacheDb.AddCommandParameter(cmd, "PageImage", pageImage); VoteCacheDb.ExecuteNonQuery(cmd); }