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