public void Test_Create_Multiline_Script_With_Error_Must_Rollback()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string sqlFileName = "Test_Single_Run_Failed_Script_Must_Rollback";
string sqlObjectName1 = TEST_DBOBJECTS.DB_OBJECT_1;
string sqlObjectName2 = TEST_DBOBJECTS.DB_OBJECT_2;
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v0.00"), $"{sqlFileName}.sql"), _testDataService.GetSqlForMultilineWithError(sqlObjectName1, sqlObjectName2));
//act
try
{
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
}
catch (Exception ex)
{
//used try/catch this instead of Assert.ThrowsException because different vendors
//throws different exception type and message content
ex.Message.ShouldNotBeNullOrEmpty();
}
//assert
_testDataService.GetCurrentDbVersion(_testConfiguration.ConnectionString).ShouldBeNull();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{sqlObjectName1}").ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{sqlObjectName2}").ShouldBeFalse();
}
public void Test_Run_All_Version_Scripts_Executed()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_00"));
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.01"), $"test_v1_01.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_01"));
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.02"), $"test_v1_02.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_02"));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_00").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_01").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_02").ShouldBeTrue();
}
public void Test_Create_Multiline_Script_With_Terminator_Inside_Statements()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string sqlFileName = "Test_Single_Run_Single_Standard";
string sqlObjectName1 = TEST_DBOBJECTS.DB_OBJECT_1;
string sqlObjectName2 = TEST_DBOBJECTS.DB_OBJECT_2;
string sqlObjectName3 = TEST_DBOBJECTS.DB_OBJECT_3;
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"{sqlFileName}.sql"), _testDataService.GetSqlForMultilineWithTerminatorInsideStatements(sqlObjectName1, sqlObjectName2, sqlObjectName3));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{sqlObjectName1}").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{sqlObjectName2}").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{sqlObjectName3}").ShouldBeTrue();
}
public void Test_Run_With_Parameterized_Tokens(string versionFolder, string scriptName)
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, versionFolder), $"{scriptName}.sql"), _testDataService.GetSqlForCreateDbObjectWithTokens(TEST_DBOBJECTS.DB_OBJECT_1));
//act
List <KeyValuePair <string, string> > tokens = new List <KeyValuePair <string, string> >
{
new KeyValuePair <string, string>("Token1", "Token1Value"),
new KeyValuePair <string, string>("Token2", "Token2Value"),
new KeyValuePair <string, string>("Token3", "Token3Value"),
};
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.Tokens = tokens;
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{TEST_DBOBJECTS.DB_OBJECT_1}_Token1Value_Token2Value_Token3Value").ShouldBeTrue();
}
public void Test_Bulk_Import_Destination_Table_Does_Not_Exist_Throws_Error()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
//we simulate a importing data into TestCsvBulkTable that doesnt exist
string v000Directory = Path.Combine(_testConfiguration.WorkspacePath, "v0.00");
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Data"), "TestCsv.csv"), Path.Combine(v000Directory, "TestCsv.csv"));
//act - bulk load csv files
try
{
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TargetVersion = "v1.00";
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
}
catch (Exception ex)
{
//assert
ex.Message.ShouldNotBeEmpty();
}
}
public void Test_Verify()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.01"), $"test_v1_01.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_2));
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.02"), $"test_v1_02.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_3));
//act
configuration.IsVerifyOnly = true;
configuration.IsAutoCreateDatabase = false;
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_1).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_2).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_3).ShouldBeFalse();
}
public void Test_Run_Draft_Always_Executed()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v0.00"), $"test_v0_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));
//act, run with _draft is empty at this point
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_1).ShouldBeTrue();
//arrange
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.DRAFT), $"test_draft_01.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_2));
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.DRAFT), $"test_draft_02.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_3));
//act - runs again with _draft holding two script files
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_2).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_3).ShouldBeTrue();
}
public void Test_Run_Dash_Character_In_Database_Name()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v0.00"), $"test_v0_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));
//use database name with dash
var databaseName = "yuniqldb-raw-dev";
_testConfiguration.ConnectionString = _testConfiguration.ConnectionString.Replace(_testConfiguration.DatabaseName, databaseName);
_testConfiguration.DatabaseName = databaseName;
//act
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_1).ShouldBeTrue();
}
public void Test_Run_With_Target_Version_Skipped_Versions_Higher_Than_Target_Version()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.01"), $"test_v1_01.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_2));
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.02"), $"test_v1_02.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_3));
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v2.00"), $"test_v2_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_4));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TargetVersion = "v1.01";
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_1).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_2).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_3).ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_4).ShouldBeFalse();
}
public void Test_Bulk_Import_Mismatch_Columns_But_Not_Nullable()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
string v000Directory = Path.Combine(_testConfiguration.WorkspacePath, "v0.00");
_testDataService.CreateScriptFile(Path.Combine(v000Directory, $"test_v0_00.sql"), _testDataService.GetSqlForCreateDbObject($"test_v0_00"));
_testDataService.CreateScriptFile(Path.Combine(v000Directory, $"test_v0_00_TestCsvMismatchColumnNotNullable.sql"), _testDataService.GetSqlForCreateBulkTable("test_v0_00_TestCsvMismatchColumnNotNullable"));
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Data"), "TestCsvMismatchColumnNotNullable.csv"), Path.Combine(v000Directory, "test_v0_00_TestCsvMismatchColumnNotNullable.csv"));
//act - bulk load csv files
try
{
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TargetVersion = "v1.00";
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
}
catch (Exception ex)
{
ex.Message.ShouldNotBeEmpty();
//asset all changes were rolled back
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v0_00").ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v0_00_TestCsvMismatchColumnNotNullable").ShouldBeFalse();
}
}
public void Test_Run_Database_Already_Updated()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
//act
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TargetVersion = "v1.01";
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
var versions = _testDataService.GetAllDbVersions(_testConfiguration.ConnectionString);
versions.Count.ShouldBe(3);
versions[0].Version.ShouldBe("v0.00");
versions[1].Version.ShouldBe("v1.00");
versions[2].Version.ShouldBe("v1.01");
migrationService.Run();
migrationService.Run();
versions.Count.ShouldBe(3);
versions[0].Version.ShouldBe("v0.00");
versions[1].Version.ShouldBe("v1.00");
versions[2].Version.ShouldBe("v1.01");
}
public void Test_Run_Transaction_Mode_None()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.01"), $"test_v1_01.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_2));
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.02"), $"test_v1_02.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_3));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TransactionMode = TRANSACTION_MODE.NONE;
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_1).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_2).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_3).ShouldBeTrue();
}
public void Test_Init()
{
//act
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
//assert
Directory.Exists(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.INIT)).ShouldBe(true);
File.Exists(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.INIT), "README.md")).ShouldBe(true);
Directory.Exists(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.PRE)).ShouldBe(true);
File.Exists(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.PRE), "README.md")).ShouldBe(true);
Directory.Exists(Path.Combine(_testConfiguration.WorkspacePath, "v0.00")).ShouldBe(true);
File.Exists(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v0.00"), "README.md")).ShouldBe(true);
Directory.Exists(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.DRAFT)).ShouldBe(true);
File.Exists(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.DRAFT), "README.md")).ShouldBe(true);
Directory.Exists(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.POST)).ShouldBe(true);
File.Exists(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.POST), "README.md")).ShouldBe(true);
Directory.Exists(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.ERASE)).ShouldBe(true);
File.Exists(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.ERASE), "README.md")).ShouldBe(true);
File.Exists(Path.Combine(_testConfiguration.WorkspacePath, "README.md")).ShouldBe(true);
File.Exists(Path.Combine(_testConfiguration.WorkspacePath, "Dockerfile")).ShouldBe(true);
File.Exists(Path.Combine(_testConfiguration.WorkspacePath, ".gitignore")).ShouldBe(true);
}
public void Test_Run_Without_AutocreateDB_Throws_Exception()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
//act and assert
try
{
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.IsAutoCreateDatabase = false;
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
}
catch (Exception ex)
{
//used try/catch this instead of Assert.ThrowsException because different vendors
//throws different exception type and message content
ex.Message.ShouldNotBeNullOrEmpty();
}
}
public void Test_Run_Fail_Migration_When_Version_Directory_With_Explicit_Transaction_Has_Other_Directories()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
var transactionDirectory = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v0.00", RESERVED_DIRECTORY_NAME.TRANSACTION)).FullName;
var otherDirectory = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v0.00", "other_directory")).FullName;
//act & assert
try
{
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
}
catch (Exception ex)
{
//used try/catch this instead of Assert.ThrowsException because different vendors
//throws different exception type and message content
ex.Message.ShouldNotBeNullOrEmpty();
}
}
public void Test_Run_Ok_With_Explicit_Transaction()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
var v1_00_transactionDirectory = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v1.00", RESERVED_DIRECTORY_NAME.TRANSACTION)).FullName;
_testDataService.CreateScriptFile(Path.Combine(v1_00_transactionDirectory, $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_00"));
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
var v1_01_transactionDirectory = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v0.01", RESERVED_DIRECTORY_NAME.TRANSACTION)).FullName;
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.01"), $"test_v1_01.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_01"));
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
var v1_02_transactionDirectory = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v0.02", RESERVED_DIRECTORY_NAME.TRANSACTION)).FullName;
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.02"), $"test_v1_02.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_02"));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_00").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_01").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_02").ShouldBeTrue();
}
public void Test_Run_With_Missing_Directories_In_Workspace_Must_Throw_Exception()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v0.00"), $"test_v0_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));
Directory.Delete(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.INIT), true);
Directory.Delete(Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.POST), true);
//act
var exception = Assert.ThrowsException <YuniqlMigrationException>(() =>
{
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
});
//assert
exception.Message.Contains("At least one required yuniql directory/folder is missing in your workspace").ShouldBeTrue();
exception.Message.Contains($"{Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.INIT)} / Missing").ShouldBeTrue();
exception.Message.Contains($"{Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.PRE)} / Found").ShouldBeTrue();
exception.Message.Contains($"{Path.Combine(_testConfiguration.WorkspacePath, "v0.00*")} / Found").ShouldBeTrue();
exception.Message.Contains($"{Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.DRAFT)} / Found").ShouldBeTrue();
exception.Message.Contains($"{Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.POST)} / Missing").ShouldBeTrue();
exception.Message.Contains($"{Path.Combine(_testConfiguration.WorkspacePath, RESERVED_DIRECTORY_NAME.ERASE)} / Found").ShouldBeTrue();
}
public void Test_Run_With_Faulty_Script_Throws_Error_Must_Rollback_All_Changes()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $".sql"), _testDataService.GetSqlForCreateBulkTable(TEST_DBOBJECTS.TestCsv));
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Data"), "TestCsv.csv"), Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), "TestCsv.csv"));
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"test_v1_00_error.sql"), _testDataService.GetSqlForCreateDbObjectWithError(TEST_DBOBJECTS.DB_OBJECT_2));
//act
try
{
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
}
catch (Exception ex)
{
//used try/catch this instead of Assert.ThrowsException because different vendors
//throws different exception type and message content
ex.Message.ShouldNotBeNullOrEmpty();
}
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_1).ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.TestCsv).ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_2).ShouldBeFalse();
}
public void Test_Run_Ok_With_Explicit_Transaction_With_SubDirectories()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string v1rootDirectory = Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"));
_testDataService.CreateScriptFile(Path.Combine(v1rootDirectory, $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_00"));;
string v1level1Directory = Path.Combine(v1rootDirectory, "v1.00-level1");
Directory.CreateDirectory(v1level1Directory);
_testDataService.CreateScriptFile(Path.Combine(v1level1Directory, $"test_v1_00_level1.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_00_level1"));
string v1level1SubDirectory = Path.Combine(v1level1Directory, "v1.00-level1-sublevel1");
Directory.CreateDirectory(v1level1SubDirectory);
_testDataService.CreateScriptFile(Path.Combine(v1level1SubDirectory, $"test_v1_00_level1_sublevel1.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_00_level1_sublevel1"));
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string v2rootDirectory = Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v2.00"));
_testDataService.CreateScriptFile(Path.Combine(v2rootDirectory, $"test_v2_00.sql"), _testDataService.GetSqlForCreateDbObject($"test_v2_00"));;
string v2level1Directory = Path.Combine(v2rootDirectory, "v2.00-level1");
Directory.CreateDirectory(v2level1Directory);
_testDataService.CreateScriptFile(Path.Combine(v2level1Directory, $"test_v2_00_level1.sql"), _testDataService.GetSqlForCreateDbObject($"test_v2_00_level1"));
string v2level1SubDirectory = Path.Combine(v2level1Directory, "v2.00-level1-sublevel1");
Directory.CreateDirectory(v2level1SubDirectory);
_testDataService.CreateScriptFile(Path.Combine(v2level1SubDirectory, $"test_v2_00_level1_sublevel1.sql"), _testDataService.GetSqlForCreateDbObject($"test_v2_00_level1_sublevel1"));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TargetVersion = "v2.00";
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_00").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_00_level1").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_00_level1_sublevel1").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v2_00").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v2_00_level1").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v2_00_level1_sublevel1").ShouldBeTrue();
}
public void Test_Run_Ok_Without_Explicit_Transaction_With_SubDirectories()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
var v1rootDirectory = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v1.00", RESERVED_DIRECTORY_NAME.TRANSACTION)).FullName;
_testDataService.CreateScriptFile(Path.Combine(v1rootDirectory, $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));;
string v1level1Directory = Path.Combine(v1rootDirectory, "v1.00-level1");
Directory.CreateDirectory(v1level1Directory);
_testDataService.CreateScriptFile(Path.Combine(v1level1Directory, $"test_v1_00_level1.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_2));
string v1level1SubDirectory = Path.Combine(v1level1Directory, "v1.00-level1-sublevel1");
Directory.CreateDirectory(v1level1SubDirectory);
_testDataService.CreateScriptFile(Path.Combine(v1level1SubDirectory, $"test_v1_00_level1_sublevel1.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_3));
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
var v2rootDirectory = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v2.00", RESERVED_DIRECTORY_NAME.TRANSACTION)).FullName;
_testDataService.CreateScriptFile(Path.Combine(v2rootDirectory, $"test_v2_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_4));;
string v2level1Directory = Path.Combine(v2rootDirectory, "v2.00-level1");
Directory.CreateDirectory(v2level1Directory);
_testDataService.CreateScriptFile(Path.Combine(v2level1Directory, $"test_v2_00_level1.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_5));
string v2level1SubDirectory = Path.Combine(v2level1Directory, "v2.00-level1-sublevel1");
Directory.CreateDirectory(v2level1SubDirectory);
_testDataService.CreateScriptFile(Path.Combine(v2level1SubDirectory, $"test_v2_00_level1_sublevel1.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_6));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TargetVersion = "v2.00";
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_1).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_2).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_3).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_4).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_5).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_6).ShouldBeTrue();
}
public void Test_Run_Ok_Migration_With_Force_Continue_After_Failue_Option_Enabled()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v0.00"), $"test_v0_00_01.sql"), _testDataService.GetSqlForCreateDbObjectWithError($"test_v0_00_01"));
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v0.00"), $"test_v0_00_02.sql"), _testDataService.GetSqlForCreateDbObject($"test_v0_00_02"));
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v0.00"), $"test_v0_00_03.sql"), _testDataService.GetSqlForCreateDbObject($"test_v0_00_03"));
//act & assert - where the first script has failed
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
try
{
migrationService.Run();
}
catch (Exception ex)
{
//used try/catch this instead of Assert.ThrowsException because different vendors
//throws different exception type and message content
ex.Message.ShouldNotBeNullOrEmpty();
}
//verrity status of migrations
var versions = _testDataService.GetAllDbVersions(_testConfiguration.ConnectionString);
versions.Count.ShouldBe(1);
versions.Count(s => s.Status == Status.Failed).ShouldBe(1);
var failedVersion = versions.Single();
failedVersion.Status.ShouldBe(Status.Failed);
failedVersion.FailedScriptPath.ShouldBe(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v0.00"), $"test_v0_00_01.sql"));
failedVersion.FailedScriptError.ShouldNotBeNullOrEmpty();
//act & assert - where force to continue on failure
configuration.IsContinueAfterFailure = true;
migrationService.Run();
//verrity status of migrations
var retriedVersions = _testDataService.GetAllDbVersions(_testConfiguration.ConnectionString);
retriedVersions.Count.ShouldBe(1);
retriedVersions.Count(s => s.Status == Status.Successful).ShouldBe(1);
var version = retriedVersions.Single();
version.Status.ShouldBe(Status.Successful);
version.FailedScriptPath.ShouldBeNullOrEmpty();
version.FailedScriptError.ShouldBeNullOrEmpty();
}
public void Test_Init()
{
//arrange
var workspace = @"c:\temp\yuniql";
var traceService = new Mock <ITraceService>();
var fileService = new Mock <IFileService>();
fileService.Setup(s => s.Exists(Path.Combine(workspace, RESERVED_FILE_NAME.README))).Returns(false);
fileService.Setup(s => s.Exists(Path.Combine(workspace, RESERVED_FILE_NAME.DOCKER_FILE))).Returns(false);
fileService.Setup(s => s.Exists(Path.Combine(workspace, RESERVED_FILE_NAME.GIT_IGNORE_FILE))).Returns(false);
var directoryService = new Mock <IDirectoryService>();
directoryService.Setup(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.INIT))).Returns(false);
directoryService.Setup(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.PRE))).Returns(false);
directoryService.Setup(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.DRAFT))).Returns(false);
directoryService.Setup(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.POST))).Returns(false);
directoryService.Setup(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.ERASE))).Returns(false);
directoryService.Setup(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.BASELINE))).Returns(false);
//act
var sut = new WorkspaceService(traceService.Object, directoryService.Object, fileService.Object);
sut.Init(workspace);
//assert
directoryService.Verify(s => s.CreateDirectory(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.INIT)));
directoryService.Verify(s => s.CreateDirectory(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.PRE)));
directoryService.Verify(s => s.CreateDirectory(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.INIT)));
directoryService.Verify(s => s.CreateDirectory(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.DRAFT)));
directoryService.Verify(s => s.CreateDirectory(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.POST)));
directoryService.Verify(s => s.CreateDirectory(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.ERASE)));
directoryService.Verify(s => s.CreateDirectory(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.BASELINE)));
fileService.Verify(s => s.AppendAllText(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.INIT, RESERVED_FILE_NAME.README), It.IsAny <string>()));
fileService.Verify(s => s.AppendAllText(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.PRE, RESERVED_FILE_NAME.README), It.IsAny <string>()));
fileService.Verify(s => s.AppendAllText(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.DRAFT, RESERVED_FILE_NAME.README), It.IsAny <string>()));
fileService.Verify(s => s.AppendAllText(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.POST, RESERVED_FILE_NAME.README), It.IsAny <string>()));
fileService.Verify(s => s.AppendAllText(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.ERASE, RESERVED_FILE_NAME.README), It.IsAny <string>()));
fileService.Verify(s => s.AppendAllText(Path.Combine(workspace, RESERVED_FILE_NAME.README), It.IsAny <string>()));
fileService.Verify(s => s.AppendAllText(Path.Combine(workspace, RESERVED_FILE_NAME.DOCKER_FILE), It.IsAny <string>()));
fileService.Verify(s => s.AppendAllText(Path.Combine(workspace, RESERVED_FILE_NAME.GIT_IGNORE_FILE), It.IsAny <string>()));
directoryService.Verify(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.INIT)));
directoryService.Verify(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.PRE)));
directoryService.Verify(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.DRAFT)));
directoryService.Verify(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.POST)));
directoryService.Verify(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.ERASE)));
directoryService.Verify(s => s.Exists(Path.Combine(workspace, RESERVED_DIRECTORY_NAME.BASELINE)));
fileService.Verify(s => s.Exists(Path.Combine(workspace, RESERVED_FILE_NAME.README)));
fileService.Verify(s => s.Exists(Path.Combine(workspace, RESERVED_FILE_NAME.DOCKER_FILE)));
fileService.Verify(s => s.Exists(Path.Combine(workspace, RESERVED_FILE_NAME.GIT_IGNORE_FILE)));
}
public void Test_Run_All_Version_SubDirectories_Executed()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string v1rootDirectory = Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"));
_testDataService.CreateScriptFile(Path.Combine(v1rootDirectory, $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));;
string v1level1Directory = Path.Combine(v1rootDirectory, "v1.00-level1");
Directory.CreateDirectory(v1level1Directory);
_testDataService.CreateScriptFile(Path.Combine(v1level1Directory, $"test_v1_00_level1.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_2));
string v1level1SubDirectory = Path.Combine(v1level1Directory, "v1.00-level1-sublevel1");
Directory.CreateDirectory(v1level1SubDirectory);
_testDataService.CreateScriptFile(Path.Combine(v1level1SubDirectory, $"test_v1_00_level1_sublevel1.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_3));
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string v2rootDirectory = Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v2.00"));
_testDataService.CreateScriptFile(Path.Combine(v2rootDirectory, $"test_v2_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_4));;
string v2level1Directory = Path.Combine(v2rootDirectory, "v2.00-level1");
Directory.CreateDirectory(v2level1Directory);
_testDataService.CreateScriptFile(Path.Combine(v2level1Directory, $"test_v2_00_level1.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_5));
string v2level1SubDirectory = Path.Combine(v2level1Directory, "v2.00-level1-sublevel1");
Directory.CreateDirectory(v2level1SubDirectory);
_testDataService.CreateScriptFile(Path.Combine(v2level1SubDirectory, $"test_v2_00_level1_sublevel1.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_6));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_1).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_2).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_3).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_4).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_5).ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_6).ShouldBeTrue();
}
public void Test_Vnext_Minor_Version()
{
//act
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
//assert
Directory.Exists(Path.Combine(_testConfiguration.WorkspacePath, "v0.01")).ShouldBe(true);
}
public void Test_Vnext_Major_Version_With_Template_File()
{
//act
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, "Test.sql");
//assert
Directory.Exists(Path.Combine(_testConfiguration.WorkspacePath, "v1.00")).ShouldBe(true);
File.Exists(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), "Test.sql")).ShouldBe(true);
}
public void Test_Get_Latest_Version()
{
//act
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
//assert
workspaceService.GetLatestVersion(_testConfiguration.WorkspacePath).ShouldBe("v1.02");
}
public void Test_Run_Environment_Aware_Scripts_Placed_In_Sub_Directory_With_Scripts_Outside()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
//creare environment-aware directories
var v00 = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v0.00")).FullName;
var v00_dev = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v0.00", "tables", "_dev")).FullName;
var v00_test = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v0.00", "tables", "_test")).FullName;
var v00_prod = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v0.00", "tables", "_prod")).FullName;
_testDataService.CreateScriptFile(Path.Combine(v00, $"v00_01.sql"), _testDataService.GetSqlForCreateDbObject($"v00_01"));
_testDataService.CreateScriptFile(Path.Combine(v00, $"v00_02.sql"), _testDataService.GetSqlForCreateDbObject($"v00_02"));
_testDataService.CreateScriptFile(Path.Combine(v00, $"v00_03.sql"), _testDataService.GetSqlForCreateDbObject($"v00_03"));
_testDataService.CreateScriptFile(Path.Combine(v00_dev, $"v00_dev.sql"), _testDataService.GetSqlForCreateDbObject($"v00_dev"));
_testDataService.CreateScriptFile(Path.Combine(v00_test, $"v00_test_01.sql"), _testDataService.GetSqlForCreateDbObject($"v00_test_01"));
_testDataService.CreateScriptFile(Path.Combine(v00_test, $"v00_test_02.sql"), _testDataService.GetSqlForCreateDbObject($"v00_test_02"));
_testDataService.CreateScriptFile(Path.Combine(v00_test, $"v00_test_03.sql"), _testDataService.GetSqlForCreateDbObject($"v00_test_03"));
_testDataService.CreateScriptFile(Path.Combine(v00_prod, $"v00_prod.sql"), _testDataService.GetSqlForCreateDbObject($"v00_prod"));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
configuration.TargetVersion = "v0.00";
configuration.Environment = "test";
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "v00_01").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "v00_02").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "v00_03").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "v00_dev").ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "v00_test_01").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "v00_test_02").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "v00_test_03").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "v00_prod").ShouldBeFalse();
}
public void Test_Run_All_NonVersion_Scripts_Executed(string scriptFolder)
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, scriptFolder), $"test_{scriptFolder}.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_1).ShouldBeTrue();
}
public void Test_Run_With_AutocreateDB()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
workspaceService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
workspaceService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
//act
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbExist(_testConfiguration.ConnectionString).ShouldBeTrue();
}
public void Test_Run_With_User_Custom_Directories_In_Workspace()
{
//arrange
var directoryService = new DirectoryService();
var fileService = new FileService();
var workspaceService = new WorkspaceService(_traceService, directoryService, fileService);
workspaceService.Init(_testConfiguration.WorkspacePath);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v0.00"), $"test_v0_00.sql"), _testDataService.GetSqlForCreateDbObject(TEST_DBOBJECTS.DB_OBJECT_1));
Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "user_created_folder"));
Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "_another_user_created_folder"));
//act
var configuration = _testConfiguration.GetFreshConfiguration();
var migrationService = _migrationServiceFactory.Create(configuration.Platform);
migrationService.Run();
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, TEST_DBOBJECTS.DB_OBJECT_1).ShouldBeTrue();
}
