public void TestCleanupRedundantOldData(string description,
string oldColumns, string oldTables, string oldSchemas,
string expectedDeletedColumns, string expectedDeletedTables, string expectedDeletedSchemas)
{
var mockSqlExecuter = new MockSqlExecuter(oldColumns, oldTables, oldSchemas);
var databaseCleaner = new DatabaseCleaner(new ConsoleLogProvider(), mockSqlExecuter);
databaseCleaner.RemoveRedundantMigrationColumns();
Assert.AreEqual(expectedDeletedColumns, TestUtility.DumpSorted(mockSqlExecuter.DroppedColumns), description + ": Deleted columns.");
Assert.AreEqual(expectedDeletedTables, TestUtility.DumpSorted(mockSqlExecuter.DroppedTables), description + ": Deleted tables.");
Assert.AreEqual(expectedDeletedSchemas, TestUtility.DumpSorted(mockSqlExecuter.DroppedSchemas), description + ": Deleted schemas.");
}
public void TestCleanupOldData(string description,
string oldTables, string oldSchemas,
string expectedDeletedTables, string expectedDeletedSchemas)
{
var mockSqlExecuter = new MockSqlExecuter("", oldTables, oldSchemas);
var databaseCleaner = new DatabaseCleaner(new ConsoleLogProvider(), mockSqlExecuter);
Console.WriteLine("Report: " + databaseCleaner.DeleteAllMigrationData());
Assert.AreEqual("", TestUtility.DumpSorted(mockSqlExecuter.DroppedColumns), description + ": Deleted columns.");
Assert.AreEqual(expectedDeletedTables, TestUtility.DumpSorted(mockSqlExecuter.DroppedTables), description + ": Deleted tables.");
Assert.AreEqual(expectedDeletedSchemas, TestUtility.DumpSorted(mockSqlExecuter.DroppedSchemas), description + ": Deleted schemas.");
}
public void GetDatabaseTimeTest()
{
var sqlExecuter = new MockSqlExecuter();
SqlUtility.GetDatabaseTime(sqlExecuter); // First run, might not be cached.
var getNonCachedTime = typeof(SqlUtility).GetMethod("GetDatabaseTimeFromDatabase", BindingFlags.NonPublic | BindingFlags.Static );
Assert.IsNotNull(getNonCachedTime);
var notCachedDatabaseTime = (DateTime)getNonCachedTime.Invoke(null, new[] { sqlExecuter });
var cachedTime = SqlUtility.GetDatabaseTime(sqlExecuter);
Console.WriteLine(notCachedDatabaseTime.ToString("o"));
Console.WriteLine(cachedTime.ToString("o"));
Assert.IsTrue(notCachedDatabaseTime - cachedTime <= TimeSpan.FromSeconds(0.01));
Assert.IsTrue(cachedTime - notCachedDatabaseTime <= TimeSpan.FromSeconds(0.01));
}
public void GetDatabaseTimeTest()
{
var sqlExecuter = new MockSqlExecuter();
SqlUtility.GetDatabaseTime(sqlExecuter); // First run, might not be cached.
var getNonCachedTime = typeof(SqlUtility).GetMethod("GetDatabaseTimeFromDatabase", BindingFlags.NonPublic | BindingFlags.Static);
Assert.IsNotNull(getNonCachedTime);
var notCachedDatabaseTime = (DateTime)getNonCachedTime.Invoke(null, new[] { sqlExecuter });
var cachedTime = SqlUtility.GetDatabaseTime(sqlExecuter);
Console.WriteLine(notCachedDatabaseTime.ToString("o"));
Console.WriteLine(cachedTime.ToString("o"));
Assert.IsTrue(notCachedDatabaseTime - cachedTime <= TimeSpan.FromSeconds(0.01));
Assert.IsTrue(cachedTime - notCachedDatabaseTime <= TimeSpan.FromSeconds(0.01));
}
public void GetDatabaseTimeTest()
{
// More detailed tests are implemented in the DatabaseTimeCacheTest class.
// This is only a smoke test for SqlUtility.
var sqlExecuter = new MockSqlExecuter();
Enumerable.Range(0, 4).Select(x => SqlUtility.GetDatabaseTime(sqlExecuter)); // Caching initialization.
var notCachedDatabaseTime = MsSqlUtility.GetDatabaseTime(sqlExecuter);
var cachedTime = SqlUtility.GetDatabaseTime(sqlExecuter);
Console.WriteLine(notCachedDatabaseTime.ToString("o"));
Console.WriteLine(cachedTime.ToString("o"));
Assert.IsTrue(notCachedDatabaseTime - cachedTime <= TimeSpan.FromSeconds(0.01));
Assert.IsTrue(cachedTime - notCachedDatabaseTime <= TimeSpan.FromSeconds(0.01));
}
public void TestCleanupOldData(string description,
string oldTables, string oldSchemas,
string expectedDeletedTables, string expectedDeletedSchemas)
{
var mockSqlExecuter = new MockSqlExecuter("", oldTables, oldSchemas);
var databaseCleaner = new DatabaseCleaner(new ConsoleLogProvider(), mockSqlExecuter);
Console.WriteLine("Report: " + databaseCleaner.DeleteAllMigrationData());
Assert.AreEqual("", TestUtility.DumpSorted(mockSqlExecuter.DroppedColumns), description + ": Deleted columns.");
Assert.AreEqual(expectedDeletedTables, TestUtility.DumpSorted(mockSqlExecuter.DroppedTables), description + ": Deleted tables.");
Assert.AreEqual(expectedDeletedSchemas, TestUtility.DumpSorted(mockSqlExecuter.DroppedSchemas), description + ": Deleted schemas.");
}
public void TestCleanupRedundantOldData(string description,
string oldColumns, string oldTables, string oldSchemas,
string expectedDeletedColumns, string expectedDeletedTables, string expectedDeletedSchemas)
{
var mockSqlExecuter = new MockSqlExecuter(oldColumns, oldTables, oldSchemas);
var databaseCleaner = new DatabaseCleaner(new ConsoleLogProvider(), mockSqlExecuter);
databaseCleaner.RemoveRedundantMigrationColumns();
Assert.AreEqual(expectedDeletedColumns, TestUtility.DumpSorted(mockSqlExecuter.DroppedColumns), description + ": Deleted columns.");
Assert.AreEqual(expectedDeletedTables, TestUtility.DumpSorted(mockSqlExecuter.DroppedTables), description + ": Deleted tables.");
Assert.AreEqual(expectedDeletedSchemas, TestUtility.DumpSorted(mockSqlExecuter.DroppedSchemas), description + ": Deleted schemas.");
}
