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