public void EnsureDatabase(bool isTestMode)
{
DatabaseManager.EnsureDatabase(isTestMode);
if (isTestMode)
{
CreateTestMatches();
}
DatabaseCache.EnsureDatabaseCache();
LineSr.EnsureFromCache();
}
public void ClearDatabase()
{
ConfigurationManager.AppSettings["CreateDatabase"] = "1";
StationSettingsUtils.m_sStartupPath = Path.GetDirectoryName(Assembly.GetAssembly(typeof(DatabaseTests)).Location);
DatabaseManager.EnsureDatabase(false);
DatabaseCache.EnsureDatabaseCache();
LineSr.EnsureFromCache();
UpdateFileEntrySr updateFileEntrySr = new UpdateFileEntrySr();
updateFileEntrySr.DataSyncCacheType = eDataSyncCacheType.Statistic.ToString();
UpdateFileEntrySr updateFileEntrySr2 = new UpdateFileEntrySr();
updateFileEntrySr2.DataSyncCacheType = eDataSyncCacheType.Match.ToString();
updateFileEntrySr.Save();
updateFileEntrySr2.Save();
long count;
var sql = "select count(" + UpdateFileEntrySr.TableSpec.IdentityNames.First() + ") FROM " + UpdateFileEntrySr.TableSpec.TableName + " where DataSyncCacheType = '" + eDataSyncCacheType.Statistic.ToString() + "'";
long.TryParse(DataCopy.ExecuteScalar(sql).ToString(), out count);
Assert.IsTrue(count > 0);
sql = "select count(" + UpdateFileEntrySr.TableSpec.IdentityNames.First() + ") FROM " + UpdateFileEntrySr.TableSpec.TableName + " where DataSyncCacheType = '" + eDataSyncCacheType.Match.ToString() + "'";
long.TryParse(DataCopy.ExecuteScalar(sql).ToString(), out count);
Assert.IsTrue(count > 0);
DbManager.Instance.DeleteOldObjects();
sql = "select count(" + UpdateFileEntrySr.TableSpec.IdentityNames.First() + ") FROM " + UpdateFileEntrySr.TableSpec.TableName + " where DataSyncCacheType = '" + eDataSyncCacheType.Statistic.ToString() + "'";
long.TryParse(DataCopy.ExecuteScalar(sql).ToString(), out count);
Assert.IsTrue(count > 0);
sql = "select count(" + UpdateFileEntrySr.TableSpec.IdentityNames.First() + ") FROM " + UpdateFileEntrySr.TableSpec.TableName + " where DataSyncCacheType = '" + eDataSyncCacheType.Match.ToString() + "'";
long.TryParse(DataCopy.ExecuteScalar(sql).ToString(), out count);
Assert.AreEqual(0, count);
DatabaseManager.DropDatabase(false);
}