public void TestMigrateMultipleFiles3()
{
SqlDatabaseHelper.ClearDatabase();
Sql2008Migrator migrator = new Sql2008Migrator(SqlDatabaseHelper.DefaultConnectionString);
var files = new IMigrationFile[] {
new MigrationFile_03_DropTable(),
new MigrationFile_01_CreateTable(),
new MigrationFile_02_AlterTable(),
new MigrationFile_04_AddColumn(),
new MigrationFile_07_RenameColumn(),
new MigrationFile_05_AlterColumn(),
new MigrationFile_06_DropColumn(),
new MigrationFile_08_TableExists(),
new MigrationFile_10_CreatePrimaryKey(),
new MigrationFile_09_RenameTable(),
new MigrationFile_13_DropConstraint(),
new MigrationFile_11_CreateForeignKey(),
new MigrationFile_12_CreateUnique()
};
string s = migrator.Migrate(files).EndId;
Assert.AreEqual("13_01", s);
migrator.Dispose();
}
public void Test_01_CreateTable()
{
SqlDatabaseHelper.ClearDatabase();
Sql2008Migrator migrator = new Sql2008Migrator(SqlDatabaseHelper.DefaultConnectionString);
string s = migrator.Migrate(new MigrationFile_01_CreateTable()).EndId;
Assert.AreEqual("01_03_CreateTable3", s);
s = migrator.Migrate(new MigrationFile_01_CreateTable()).EndId;
Assert.AreEqual("01_03_CreateTable3", s);
migrator.Dispose();
}
public void TestMigrateAssembly()
{
SqlDatabaseHelper.ClearDatabase();
Sql2008Migrator migrator = new Sql2008Migrator(SqlDatabaseHelper.DefaultConnectionString);
var assembly = this.GetType().Assembly;
string s = migrator.Migrate(assembly, "DatabaseAutoMigrator.Tests.TestFiles").EndId;
Assert.AreEqual("13_01", s);
s = migrator.Migrate(assembly, "DatabaseAutoMigrator.Tests.TestFiles").EndId;
Assert.AreEqual("13_01", s);
migrator.Dispose();
}
public void TestMigrateResult()
{
SqlDatabaseHelper.ClearDatabase();
Sql2008Migrator migrator = new Sql2008Migrator(SqlDatabaseHelper.DefaultConnectionString);
var result = migrator.Migrate(new MigrationFile_MigrateResult());
Assert.AreEqual("", result.StartId);
Assert.AreEqual("99_Error2", result.EndId);
Assert.IsTrue(result.Duration.Ticks > 0);
Assert.AreEqual(3, result.Executed.Count);
Assert.AreEqual(1, result.NotExecuted.Count);
Assert.IsTrue(result.Executed[0].Duration.Ticks > 0);
Assert.IsTrue(result.Executed[0].Success);
Assert.IsNull(result.Executed[0].Error);
Assert.AreEqual("DatabaseAutoMigrator.Tests.TestFiles.MigrationFile_MigrateResult", result.Executed[0].File);
Assert.AreEqual("Migrate_99_Error1", result.Executed[0].MethodName);
Assert.IsTrue(result.Executed[2].Duration.Ticks > 0);
Assert.IsFalse(result.Executed[2].Success);
Assert.IsNotNull(result.Executed[2].Error);
Assert.AreEqual("DatabaseAutoMigrator.Tests.TestFiles.MigrationFile_MigrateResult", result.Executed[2].File);
Assert.AreEqual("Migrate_99_Error3", result.Executed[2].MethodName);
Assert.IsFalse(result.NotExecuted[0].Success);
Assert.IsNull(result.NotExecuted[0].Error);
Assert.AreEqual("DatabaseAutoMigrator.Tests.TestFiles.MigrationFile_MigrateResult", result.NotExecuted[0].File);
Assert.AreEqual("Migrate_99_Error4", result.NotExecuted[0].MethodName);
result = migrator.Migrate(new MigrationFile_MigrateResult());
Assert.AreEqual("99_Error2", result.StartId);
Assert.AreEqual("99_Error2", result.EndId);
Assert.IsTrue(result.Duration.Ticks > 0);
Assert.AreEqual(1, result.Executed.Count);
Assert.AreEqual(1, result.NotExecuted.Count);
migrator.Dispose();
}