public void Test_Run_With_Target_Version_Skipped_Versions_Higher_Than_Target_Version()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_00"));
localVersionService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.01"), $"test_v1_01.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_01"));
localVersionService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.02"), $"test_v1_02.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_02"));
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v2.00"), $"test_v2_00.sql"), _testDataService.GetSqlForCreateDbObject($"test_v2_00"));
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.01", autoCreateDatabase: true);
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_00").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_01").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_02").ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_03").ShouldBeFalse();
}
public void Test_Run_All_Version_SubDirectories_Executed()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.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"));
localVersionService.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 migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v2.00", autoCreateDatabase: true);
//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_Database_Already_Updated()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
localVersionService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.01", autoCreateDatabase: true);
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(_testConfiguration.WorkspacePath, "v1.01", autoCreateDatabase: true);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.01", autoCreateDatabase: true);
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_Erase()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"script1.sql"), _testDataService.GetSqlForCreateDbObject($"script1"));
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"script2.sql"), _testDataService.GetSqlForCreateDbObject($"script2"));
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"script3.sql"), _testDataService.GetSqlForCreateDbObject($"script3"));
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.00", autoCreateDatabase: true);
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "script1").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "script2").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "script3").ShouldBeTrue();
//arrange
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "_erase"), $"erase.sql"), _testDataService.GetSqlForCleanup());
//act
migrationService.Erase(_testConfiguration.WorkspacePath);
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "script1").ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "script2").ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "script3").ShouldBeFalse();
}
public void Test_Run_With_Faulty_Script_Throws_Error_Must_Rollback_All_Changes()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_00"));
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $".sql"), _testDataService.GetSqlForCreateBulkTable("TestCsv"));
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Core"), "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_v1_00_error"));
//act
try
{
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.00", autoCreateDatabase: true);
}
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_v1_00").ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "TestCsv").ShouldBeFalse();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "test_v1_00_error").ShouldBeFalse();
}
public void Test_Run_With_Parameterized_Tokens(string versionFolder, string scriptName)
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, versionFolder), $"{scriptName}.sql"), _testDataService.GetSqlForCreateDbObjectWithTokens($"{scriptName}"));
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
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"),
};
migrationService.Run(_testConfiguration.WorkspacePath, "v1.00", autoCreateDatabase: true, tokens: tokens);
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{scriptName}_Token1Value_Token2Value_Token3Value").ShouldBeTrue();
}
public void Test_Create_Multiline_Script_With_Error_Must_Rollback()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string sqlFileName = "Test_Single_Run_Failed_Script_Must_Rollback";
string sqlObjectName1 = "Test_Object_1";
string sqlObjectName2 = "Test_Object_2";
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"{sqlFileName}.sql"), _testDataService.GetSqlForMultilineWithError(sqlObjectName1, sqlObjectName2));
//act
try
{
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.00", autoCreateDatabase: true);
}
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_Bulk_Import_With_Null_Word_Value()
{
//arrange - prepare bulk destination table
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string v100Directory = Path.Combine(_testConfiguration.WorkspacePath, "v1.00");
_testDataService.CreateScriptFile(Path.Combine(v100Directory, $"TestCsvNullWordValue.sql"), _testDataService.GetSqlForCreateBulkTable("TestCsvNullWordValue"));
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.00", autoCreateDatabase: true);
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "TestCsvNullWordValue").ShouldBeTrue();
//arrange - add new minor version with csv files
localVersionService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
string v101Directory = Path.Combine(_testConfiguration.WorkspacePath, "v1.01");
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Core"), "TestCsvNullWordValue.csv"), Path.Combine(v101Directory, "TestCsvNullWordValue.csv"));
//act
migrationService.Run(_testConfiguration.WorkspacePath, "v1.01", autoCreateDatabase: true);
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "TestCsvNullWordValue").ShouldBeTrue();
var results = _testDataService.GetBulkTestData(_testConfiguration.ConnectionString, "TestCsvNullWordValue");
var testDataRows = new List <BulkTestDataRow>
{
new BulkTestDataRow {
FirstName = "Jack", LastName = "Poole", BirthDate = null
},
new BulkTestDataRow {
FirstName = "Diana", LastName = "Churchill", BirthDate = null
},
new BulkTestDataRow {
FirstName = "Rebecca", LastName = "Lyman", BirthDate = null
},
new BulkTestDataRow {
FirstName = "Sam", LastName = "Macdonald", BirthDate = null
},
new BulkTestDataRow {
FirstName = "Matt", LastName = "Paige", BirthDate = null
},
};
results.Count.ShouldBe(5);
testDataRows.All(t => results.Exists(r =>
t.FirstName == r.FirstName &&
t.LastName == r.LastName &&
t.BirthDate == r.BirthDate
)).ShouldBeTrue();
}
public void Test_Create_Multiline_Script_With_Terminator_Inside_Statements()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string sqlFileName = "Test_Single_Run_Single_Standard";
string sqlObjectName1 = "Test_Object_1";
string sqlObjectName2 = "Test_Object_2";
string sqlObjectName3 = "Test_Object_3";
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"{sqlFileName}.sql"), _testDataService.GetSqlForMultilineWithTerminatorInsideStatements(sqlObjectName1, sqlObjectName2, sqlObjectName3));
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.00", autoCreateDatabase: true);
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{sqlObjectName1}").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{sqlObjectName2}").ShouldBeTrue();
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{sqlObjectName3}").ShouldBeTrue();
}
public void Test_Run_Ok_With_Explicit_Transaction()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
var v1_00_transactionDirectory = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v1.00", "_transaction")).FullName;
_testDataService.CreateScriptFile(Path.Combine(v1_00_transactionDirectory, $"test_v1_00.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_00"));
localVersionService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
var v1_01_transactionDirectory = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v0.01", "_transaction")).FullName;
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.01"), $"test_v1_01.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_01"));
localVersionService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
var v1_02_transactionDirectory = Directory.CreateDirectory(Path.Combine(_testConfiguration.WorkspacePath, "v0.02", "_transaction")).FullName;
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.02"), $"test_v1_02.sql"), _testDataService.GetSqlForCreateDbObject($"test_v1_02"));
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, autoCreateDatabase: true);
//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_Bulk_Import_With_Utf8()
{
//arrange - pre-create destination bulk tables
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string v100Directory = Path.Combine(_testConfiguration.WorkspacePath, "v1.00");
_testDataService.CreateScriptFile(Path.Combine(v100Directory, $"TestCsvUtf8.sql"), _testDataService.GetSqlForCreateBulkTable("TestCsvUtf8"));
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.00", autoCreateDatabase: true);
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "TestCsvUtf8").ShouldBeTrue();
//arrange - add new version with csv files
localVersionService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
string v101Directory = Path.Combine(_testConfiguration.WorkspacePath, "v1.01");
File.Copy(Path.Combine(Path.Combine(Environment.CurrentDirectory, "Core"), "TestCsvUtf8.csv"), Path.Combine(v101Directory, "TestCsvUtf8.csv"));
//act - bulk load csv files
migrationService.Run(_testConfiguration.WorkspacePath, "v1.01", autoCreateDatabase: true);
//assert
var results = _testDataService.GetBulkTestData(_testConfiguration.ConnectionString, "TestCsvUtf8");
var testDataRows = new List <BulkTestDataRow>
{
new BulkTestDataRow {
FirstName = "Allan", LastName = "Søgaard", BirthDate = new DateTime(1980, 1, 1)
},
new BulkTestDataRow {
FirstName = "Martin", LastName = "Bæk", BirthDate = new DateTime(1980, 1, 1)
},
new BulkTestDataRow {
FirstName = "Gitte", LastName = "Jürgensen", BirthDate = new DateTime(1980, 1, 1)
},
new BulkTestDataRow {
FirstName = "Maria", LastName = "Østergård", BirthDate = new DateTime(1980, 1, 1)
},
new BulkTestDataRow {
FirstName = "Peter", LastName = "Langkjær", BirthDate = new DateTime(1980, 1, 1)
},
};
results.Count.ShouldBe(5);
testDataRows.All(t => results.Exists(r =>
t.FirstName == r.FirstName &&
t.LastName == r.LastName &&
t.BirthDate == r.BirthDate
)).ShouldBeTrue();
}
public void Test_Vnext_Major_Version()
{
//act
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
//assert
Directory.Exists(Path.Combine(_testConfiguration.WorkspacePath, "v1.00")).ShouldBe(true);
}
public void Test_Get_Latest_Version()
{
//act
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
localVersionService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
localVersionService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
//assert
localVersionService.GetLatestVersion(_testConfiguration.WorkspacePath).ShouldBe("v1.02");
}
public void Test_Run_With_AutocreateDB()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
localVersionService.IncrementMinorVersion(_testConfiguration.WorkspacePath, null);
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.01", autoCreateDatabase: true);
//assert
_testDataService.CheckIfDbExist(_testConfiguration.ConnectionString).ShouldBeTrue();
}
public void Test_Create_SingleLine_Script_Without_Terminator()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string sqlObjectName = "Test_Object_1";
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"{sqlObjectName}.sql"), _testDataService.GetSqlForSingleLineWithoutTerminator(sqlObjectName));
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(workingPath: _testConfiguration.WorkspacePath, targetVersion: "v1.00", autoCreateDatabase: true);
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, $"{sqlObjectName}").ShouldBeTrue();
}
public void Test_Create_SingleLine_Empty_Script()
{
//arrange
var localVersionService = new LocalVersionService(_traceService);
localVersionService.Init(_testConfiguration.WorkspacePath);
localVersionService.IncrementMajorVersion(_testConfiguration.WorkspacePath, null);
string sqlStatement = $@"
";
_testDataService.CreateScriptFile(Path.Combine(Path.Combine(_testConfiguration.WorkspacePath, "v1.00"), $"Test_Single_Run_Empty.sql"), sqlStatement);
//act
var migrationService = _migrationServiceFactory.Create(_testConfiguration.Platform);
migrationService.Initialize(_testConfiguration.ConnectionString);
migrationService.Run(_testConfiguration.WorkspacePath, "v1.00", autoCreateDatabase: true);
//assert
_testDataService.CheckIfDbObjectExist(_testConfiguration.ConnectionString, "Test_Single_Run_Empty").ShouldBeFalse();
}
