static internal QueryResult Get(HubbleConnection conn, string sql,
out DateTime expireTime, out int hitCount, out string tableTicks)
{
DataCache dataCache;
tableTicks = "";
lock (_LockObj)
{
string key = conn.DataSource.ToLower().Trim() + ":" + conn.TcpPort.ToString() + "\\" + conn.Database.ToLower().Trim();
if (!_DataCacheDict.TryGetValue(key, out dataCache))
{
expireTime = default(DateTime);
hitCount = 0;
return(null);
}
}
QueryResult result;
object tag;
if (dataCache.TryGetValue(sql.Trim(), out result, out expireTime, out hitCount, out tag))
{
tableTicks = (string)tag;
return(result);
}
else
{
return(null);
}
}
public TableSynchronization(HubbleConnection conn, string tableName, int step,
OptimizeOption option, bool fastestMode, string flags)
{
_Conn = conn;
_TableName = tableName;
_Step = step;
_Option = option;
_FastestMode = fastestMode;
_Flags = flags;
}
static internal void OnConnect(HubbleConnection conn)
{
lock (_LockObj)
{
string key = conn.DataSource.ToLower().Trim() + ":" + conn.TcpPort.ToString() + "\\" + conn.Database.ToLower().Trim();
if (!_DataCacheDict.ContainsKey(key))
{
_DataCacheDict.Add(key, new DataCache(_Mgr));
}
}
}
static internal void Insert(HubbleConnection conn,
string sql, QueryResult qResult, DateTime expireTime, string tableTick)
{
DataCache dataCache;
lock (_LockObj)
{
string key = conn.DataSource.ToLower().Trim() + ":" + conn.TcpPort.ToString() + "\\" + conn.Database.ToLower().Trim();
if (!_DataCacheDict.TryGetValue(key, out dataCache))
{
return;
}
}
dataCache.Insert(sql.Trim(), qResult, expireTime, tableTick);
}
static internal void ChangeExpireTime(HubbleConnection conn,
string sql, DateTime expireTime)
{
DataCache dataCache;
lock (_LockObj)
{
string key = conn.DataSource.ToLower().Trim() + ":" + conn.TcpPort.ToString() + "\\" + conn.Database.ToLower().Trim();
if (!_DataCacheDict.TryGetValue(key, out dataCache))
{
return;
}
}
dataCache.ChangeExpireTime(sql.ToLower().Trim(), expireTime);
}
public TableSynchronization(HubbleConnection conn, string tableName, int step,
OptimizeOption option, bool fastestMode)
: this(conn, tableName, step, option, fastestMode, null)
{
}
/// <summary>
/// Constractor
/// </summary>
/// <param name="conn">hubble connection</param>
/// <param name="tableName">table name</param>
/// <param name="step">number of record synchronized every time</param>
/// <param name="option">optimize option</param>
public TableSynchronization(HubbleConnection conn, string tableName, int step,
OptimizeOption option)
: this(conn, tableName, step, option, false)
{
}
public HubbleCommand(string sql, HubbleConnection sqlConn, params object[] parameters)
{
_Sql = sql;
_SqlConnection = sqlConn;
_ObjParameters = parameters;
}
public HubbleCommand(string sql, HubbleConnection sqlConn)
{
_Sql = sql;
_SqlConnection = sqlConn;
_ObjParameters = null;
}
public HubbleCommand(HubbleConnection sqlConn)
: this("", sqlConn)
{
}