public override void Asserts(CLITestContext testContext)
{
_init_AllProperties_API.Asserts(testContext);
AssertTextByLines.AssertEmpty(GetType().Name, nameof(testContext.ConsoleError), testContext.ConsoleError);
AssertTextByLines assertTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 2);
assertTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "init").Replace("[args]", "IntegrationTestProject"), true);
assertTextByLines.AssertLineMessage(CLITextResources.ProcessCompleteSuccessfully, true);
}
public override void Asserts(CLITestContext testContext)
{
AssertTextByLines.AssertEmpty(GetType().Name, nameof(testContext.ConsoleError), testContext.ConsoleError);
AssertTextByLines assertTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 5);
assertTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageNoArgs.Replace("[processName]", "dbtypes"), true);
assertTextByLines.AssertLineMessage("", true);
assertTextByLines.AssertLineMessage(" Code | Name", true);
assertTextByLines.AssertLineMessage("--------------------", true);
assertTextByLines.AssertLineMessage($"+ {SqlServerDBTypeObjectsFactory.DBTypeCode} | Sql Server", true);
}
public override void Asserts(CLITestContext testContext)
{
_devEnv_NewScrtiptFile_DevDummyData_API.Asserts(testContext);
AssertTextByLines.AssertEmpty(GetType().Name, nameof(testContext.ConsoleError), testContext.ConsoleError);
AssertTextByLines assertTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 3);
assertTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "new ddd").Replace("[args]", "IntegrationTestProject"), true);
assertTextByLines.AssertLineMessage(CLITextResources.ProcessCompleteSuccessfully, true);
assertTextByLines.AssertLineMessage(CLITextResources.TheFileIsCreatedInfoMessage.Replace("[newFilePath]", _devEnv_NewScrtiptFile_DevDummyData_API.GetScriptFullPath_DevDummyData_scriptName1(testContext.ProjectConfig.DBConnectionInfo)), true);
}
public override void Asserts(CLITestContext testContext)
{
_devEnv_Validate_NewProject_API.Asserts(testContext);
AssertTextByLines assertConsoleOutTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 1);
assertConsoleOutTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "validate").Replace("[args]", "IntegrationTestProject"), true);
AssertTextByLines assertErrorsTextByLines = new AssertTextByLines(GetType().Name, "ConsoleError", testContext.ConsoleError, 2);
assertErrorsTextByLines.AssertLineMessage("Welcome!!! This appear to be a new project.", true);
assertErrorsTextByLines.AssertLineMessage("1) Run 'Init DB' for creating our DB system tables >> 2) Add your scripts files >> 3) Run 'Sync'", true);
}
public override void Asserts(CLITestContext testContext)
{
_DeliveryEnv_Validate_NewProject_API.Asserts(testContext);
AssertTextByLines assertConsoleOutTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 1);
assertConsoleOutTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "validate").Replace("[args]", "IntegrationTestProject"), true);
AssertTextByLines assertErrorsTextByLines = new AssertTextByLines(GetType().Name, "ConsoleError", testContext.ConsoleError, 2);
assertErrorsTextByLines.AssertLineMessage("Welcome!!! This appear to be a new project.", true);
assertErrorsTextByLines.AssertLineMessage("1) Copy the artifact file that deployed from your dev environment >> 2) Run 'Virtual' to set the current DB state related to the scripts file >> 3) Run 'Sync' for executing the rest of the scripts files", true);
}
public override void Asserts(CLITestContext testContext)
{
_devEnv_Deploy_API.Asserts(testContext);
AssertTextByLines.AssertEmpty(GetType().Name, nameof(testContext.ConsoleError), testContext.ConsoleError);
AssertTextByLines assertTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 3);
assertTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "deploy").Replace("[args]", "IntegrationTestProject"), true);
assertTextByLines.AssertLineMessage(CLITextResources.ProcessCompleteSuccessfully, true);
assertTextByLines.AssertLineMessage("Artifact file created: ", false, 2);
assertTextByLines.AssertLineMessage(@"Deploy\AutoVersionsDB.Tests.avdb'", false, 2);
}
public override void Asserts(CLITestContext testContext)
{
_deliveryEnv_Restore_API.Asserts(testContext);
AssertTextByLines assertConsoleOutTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 1);
assertConsoleOutTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "sync").Replace("[args]", "IntegrationTestProject"), true);
AssertTextByLines assertErrorsTextByLines = new AssertTextByLines(GetType().Name, "ConsoleError", testContext.ConsoleError, null);
assertErrorsTextByLines.AssertLineMessage(CLITextResources.ProcessCompleteWithErrors, true);
assertErrorsTextByLines.AssertLineMessage("--------------------------------", true);
assertErrorsTextByLines.AssertLineMessage("incScript_0004_CreateTransTable1.sql 0% (0/1) >>> Execute Script Block. Error: System.Exception: Error Message: 'Column, parameter, or variable #3: Cannot find data type nvarcharaaaa.', Script: ", false);
}
public void Init_ID_IsRequired()
{
//Arrange
CLITestContext testContext = new CLITestContext(new ProcessTestContext(new TestArgs()));
MockObjectsProvider.SetTestContextDataByMockCallbacksForCLI(testContext);
CLIRunner.CLIRun($"init");
AssertTextByLines assertConsoleOutTextByLines = new AssertTextByLines(GetType().Name, "ConsoleError", testContext.ConsoleError, 2);
assertConsoleOutTextByLines.AssertLineMessage("Option '--id' is required.", true);
assertConsoleOutTextByLines.AssertLineMessage("Option '--dev-environment' is required.", true);
}
public override void Asserts(CLITestContext testContext)
{
_deliveryEnv_NotAllowMethods_Deploy_API.Asserts(testContext);
AssertTextByLines assertConsoleOutTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 1);
assertConsoleOutTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "deploy").Replace("[args]", "IntegrationTestProject"), true);
AssertTextByLines assertErrorsTextByLines = new AssertTextByLines(GetType().Name, "ConsoleError", testContext.ConsoleError, 5);
assertErrorsTextByLines.AssertLineMessage(CLITextResources.ProcessCompleteWithErrors, true);
assertErrorsTextByLines.AssertLineMessage("--------------------------------", true);
assertErrorsTextByLines.AssertLineMessage($"{CheckDeliveryEnvValidator.Name}. Error: {CoreTextResources.DeliveryEnvErrorMessage}", false);
assertErrorsTextByLines.AssertLineMessage("", true);
assertErrorsTextByLines.AssertLineMessage(CoreTextResources.DeliveryEnvErrorMessage, true);
}
public override void Asserts(CLITestContext testContext)
{
_devEnv_Validate_MissingSystemTables_API.Asserts(testContext);
AssertTextByLines assertConsoleOutTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 1);
assertConsoleOutTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "validate").Replace("[args]", "IntegrationTestProject"), true);
AssertTextByLines assertErrorsTextByLines = new AssertTextByLines(GetType().Name, "ConsoleError", testContext.ConsoleError, 5);
assertErrorsTextByLines.AssertLineMessage(CLITextResources.ProcessCompleteWithErrors, true);
assertErrorsTextByLines.AssertLineMessage("--------------------------------", true);
assertErrorsTextByLines.AssertLineMessage($"{SystemTablesValidator.Name}. Error: {CoreTextResources.TableNotExistErrorMessage.Replace("[TableName]", DBCommandsConsts.DBScriptsExecutionHistoryFullTableName)}", false);
assertErrorsTextByLines.AssertLineMessage("", true);
assertErrorsTextByLines.AssertLineMessage(CoreTextResources.SystemTablesDevEnvInstructionsMessage, true);
}
public override void Asserts(CLITestContext testContext)
{
_deliveryEnv_Validate_ArtifactFile_API.Asserts(testContext);
AssertTextByLines assertConsoleOutTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 1);
assertConsoleOutTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "validate").Replace("[args]", "IntegrationTestProject"), true);
AssertTextByLines assertErrorsTextByLines = new AssertTextByLines(GetType().Name, "ConsoleError", testContext.ConsoleError, 5);
assertErrorsTextByLines.AssertLineMessage(CLITextResources.ProcessCompleteWithErrors, true);
assertErrorsTextByLines.AssertLineMessage("--------------------------------", true);
assertErrorsTextByLines.AssertLineMessage($"{ArtifactFileValidator.Name}. Error: {CoreTextResources.ArtifactFolderExistErrorMessage}", false);
assertErrorsTextByLines.AssertLineMessage("", true);
assertErrorsTextByLines.AssertLineMessage(CoreTextResources.ArtifactFileNotExistErrorMessage, true);
}
public override void Asserts(CLITestContext testContext)
{
_devEnv_Validate_HistoryExecutedFilesChanged_API.Asserts(testContext);
AssertTextByLines assertConsoleOutTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 1);
assertConsoleOutTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "validate").Replace("[args]", "IntegrationTestProject"), true);
AssertTextByLines assertErrorsTextByLines = new AssertTextByLines(GetType().Name, "ConsoleError", testContext.ConsoleError, 5);
assertErrorsTextByLines.AssertLineMessage(CLITextResources.ProcessCompleteWithErrors, true);
assertErrorsTextByLines.AssertLineMessage("--------------------------------", true);
assertErrorsTextByLines.AssertLineMessage($"{HistoryExecutedFilesChangedValidator.Name}. Error: {CoreTextResources.FilesChangedErrorMessage.Replace("[FilesList]", "incScript_0003_CreateLookupTable2.sql").Replace("[FileTypeCode]", IncrementalScriptFileType.Code)}", false);
assertErrorsTextByLines.AssertLineMessage("", true);
assertErrorsTextByLines.AssertLineMessage(CoreTextResources.HistoryExecutedFilesChangedInstructionsMessage, true);
}
public override void Asserts(CLITestContext testContext)
{
_files_IncrementalChanged_API.Asserts(testContext);
AssertTextByLines.AssertEmpty(GetType().Name, nameof(testContext.ConsoleError), testContext.ConsoleError);
AssertTextByLines assertTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 8);
assertTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "files repeatable").Replace("[args]", "IntegrationTestProject"), true);
assertTextByLines.AssertLineMessage(CLITextResources.ProcessCompleteSuccessfully, true);
assertTextByLines.AssertLineMessage("", true);
assertTextByLines.AssertLineMessage("++ Repeatable Scripts:", true);
assertTextByLines.AssertLineMessage(" Status | File", true);
assertTextByLines.AssertLineMessage("-------------------------------------------------------", true);
assertTextByLines.AssertLineMessage(" | rptScript_0001_DataForLookupTable1.sql", true);
assertTextByLines.AssertLineMessage(" | rptScript_0002_DataForLookupTable2.sql", true);
}
public override void Asserts(CLITestContext testContext)
{
AssertTextByLines.AssertEmpty(GetType().Name, nameof(testContext.ConsoleError), testContext.ConsoleError);
AssertTextByLines assertTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 6);
assertTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageNoArgs.Replace("[processName]", "list"), true);
assertTextByLines.AssertLineMessage("", true);
assertTextByLines.AssertLineMessage(" Id | Description", true);
assertTextByLines.AssertLineMessage("-------------------------------------------------------", true);
assertTextByLines.AssertLineMessage(" TestProject1 | Test Project 1", true);
assertTextByLines.AssertLineMessage(" TestProject2 | Test Project 2", true);
}
public override void Asserts(CLITestContext testContext)
{
_getProjectConfigById_API.Asserts(testContext);
AssertTextByLines.AssertEmpty(GetType().Name, nameof(testContext.ConsoleError), testContext.ConsoleError);
AssertTextByLines assertTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 12);
assertTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "info").Replace("[args]", "IntegrationTestProject"), true);
assertTextByLines.AssertLineMessage($"Id : {IntegrationTestsConsts.DummyProjectConfigValid.Id}", true);
assertTextByLines.AssertLineMessage($"Description : {IntegrationTestsConsts.DummyProjectConfigValid.Description}", true);
assertTextByLines.AssertLineMessage($"DBType : {IntegrationTestsConsts.DummyProjectConfigValid.DBType}", true);
assertTextByLines.AssertLineMessage($"ServerInstance : {IntegrationTestsConsts.DummyProjectConfigValid.Server}", true);
assertTextByLines.AssertLineMessage($"DataBaseName : {IntegrationTestsConsts.DummyProjectConfigValid.DBName}", true);
assertTextByLines.AssertLineMessage($"DBUsername : {IntegrationTestsConsts.DummyProjectConfigValid.Username}", true);
assertTextByLines.AssertLineMessage($"DBPassword : {IntegrationTestsConsts.DummyProjectConfigValid.Password}", true);
assertTextByLines.AssertLineMessage($"ConncetionTimeout : {IntegrationTestsConsts.DummyProjectConfigValid.ConncetionTimeout}", true);
assertTextByLines.AssertLineMessage($"Backup Folder Path : {IntegrationTestsConsts.DummyProjectConfigValid.BackupFolderPath}", true);
assertTextByLines.AssertLineMessage($"Dev Environment : {false}", true);
assertTextByLines.AssertLineMessage($"Delivery Artifact Folder Path : {IntegrationTestsConsts.DummyProjectConfigValid.DeliveryArtifactFolderPath}", true);
}
public override void Asserts(CLITestContext testContext)
{
_files_RepeatableChanged_API.Asserts(testContext);
AssertTextByLines.AssertEmpty(GetType().Name, nameof(testContext.ConsoleError), testContext.ConsoleError);
AssertTextByLines assertTextByLines = new AssertTextByLines(GetType().Name, "FinalConsoleOut", testContext.FinalConsoleOut, 11);
assertTextByLines.AssertLineMessage(CLITextResources.StartProcessMessageWithArgs.Replace("[processName]", "files").Replace("[args]", "IntegrationTestProject"), true);
assertTextByLines.AssertLineMessage("The process complete successfully", true);
assertTextByLines.AssertLineMessage("", true);
assertTextByLines.AssertLineMessage("++ Incremental Scripts:", true);
assertTextByLines.AssertLineMessage(" Status | File", true);
assertTextByLines.AssertLineMessage("-------------------------------------------------------", true);
assertTextByLines.AssertLineMessage(" sync | incScript_0001_initState.sql", true);
assertTextByLines.AssertLineMessage(" sync | incScript_0002_CreateLookupTable1.sql", true);
assertTextByLines.AssertLineMessage(" sync | incScript_0003_CreateLookupTable2.sql", true);
assertTextByLines.AssertLineMessage(" sync | incScript_0004_CreateTransTable1.sql", true);
assertTextByLines.AssertLineMessage(" sync | incScript_0005_CreateInvoiceTable1.sql", true);
}
