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