public bool HasChanged(cds_MYSQLMultiKonektor multiCon, string database, string table, uint checkIntervalSeconds = 0)
{
if (checkIntervalSeconds > 0)
{
if ((DateTime.Now - lastCheck).TotalSeconds < checkIntervalSeconds)
{
return(false);
}
else
{
lastCheck = DateTime.Now;
}
}
Tuple <string, string> tuple = new Tuple <string, string>(database, table);
long checksum = GetChecksum(multiCon, database, table);
if (!dictCheckSumData.ContainsKey(tuple))
{
dictCheckSumData.Add(tuple, checksum);
return(true);
}
bool changed = dictCheckSumData[tuple] != checksum;
if (changed)
{
dictCheckSumData[tuple] = checksum;
return(true);
}
return(false);
}
public bool HasChanged(cds_MYSQLMultiKonektor multiCon, string database, string table, uint checkIntervalSeconds = 0)
{
if (checkIntervalSeconds > 0)
{
if ((DateTime.Now - lastCheck).TotalSeconds < checkIntervalSeconds)
return false;
else
lastCheck = DateTime.Now;
}
Tuple<string, string> tuple = new Tuple<string, string>(database, table);
long checksum = GetChecksum(multiCon, database, table);
if (!dictCheckSumData.ContainsKey(tuple))
{
dictCheckSumData.Add(tuple, checksum);
return true;
}
bool changed = dictCheckSumData[tuple] != checksum;
if (changed)
{
dictCheckSumData[tuple] = checksum;
return true;
}
return false;
}
private long GetChecksum(cds_MYSQLMultiKonektor multiCon, string database, string table)
{
return multiCon.GetColumn<long>("CHECKSUM TABLE `" + database + "`.`" + table + "` EXTENDED", 1, false).First();
}
private long GetChecksum(cds_MYSQLMultiKonektor multiCon, string database, string table)
{
return(multiCon.GetColumn <long>("CHECKSUM TABLE `" + database + "`.`" + table + "` EXTENDED", 1, false).First());
}
