private static ProjectConfigItem CreateBaseProjectConfig() { return(new ProjectConfigItem() { Id = IntegrationTestsConsts.TestProjectId, DeployArtifactFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DeployArtifact_FolderPath), BackupFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DBBackupBaseFolder), }); }
private void SaveProjectConfigsFile(Dictionary <string, ProjectConfigItem> dicAllProjectConfigs) { List <ProjectConfigItem> projectConfigs = dicAllProjectConfigs.Values.ToList(); string projectConfigsListStr = SerializationUtils.JsonSerialize(projectConfigs); string configProjectsFilePath = FileSystemPathUtils.ParsePathVaribles(_settings.ConfigProjectsFilePath); FileSystemPathUtils.ResloveFilePath(configProjectsFilePath); File.WriteAllText(configProjectsFilePath, projectConfigsListStr); }
public string GetScriptFullPath_Incremental_scriptName2(DBConnectionInfo dbConnectionInfo) { string devScriptsBaseFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DevScriptsBaseFolderPath_Normal); devScriptsBaseFolderPath = devScriptsBaseFolderPath.Replace("[DBType]", dbConnectionInfo.DBType); string scriptFilename = $"incScript_0007_{ScriptName2}.sql"; string script1FullPath = Path.Combine(devScriptsBaseFolderPath, _relFolder_Incremental, scriptFilename); return(script1FullPath); }
public string GetScriptFullPath_DevDummyData_scriptName1(DBConnectionInfo dbConnectionInfo) { string devScriptsBaseFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DevScriptsBaseFolderPath_Normal); devScriptsBaseFolderPath = devScriptsBaseFolderPath.Replace("[DBType]", dbConnectionInfo.DBType); string scriptFilename = $"dddScript_0003_{ScriptName1}.sql"; string script1FullPath = Path.Combine(devScriptsBaseFolderPath, _relFolder_DevDummyData, scriptFilename); return(script1FullPath); }
public override ITestContext Arrange(TestArgs testArgs) { ProjectConfigItem projectConfig = IntegrationTestsConsts.GetNewInstanceForDummyProjectConfigValid(); projectConfig.DevScriptsBaseFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DevScriptsBaseFolderPath_Normal).Replace("[DBType]", IntegrationTestsConsts.SqlServerDBType); projectConfig.Id = OldProjectId; projectConfig.Description = ProjectDesc; _projectConfigsStorageHelper.PrepareTestProject(projectConfig); ProjectConfigTestArgs projectConfigTestArgs = new ProjectConfigTestArgs(projectConfig); _dbHandler.RestoreDB(projectConfig.DBConnectionInfo, DBBackupFileType.EmptyDB); return(new ProcessTestContext(projectConfigTestArgs)); }
public virtual string GetDBBackupFilePath(DBBackupFileType dbBackupFileType, string dbType) { string filePath = dbBackupFileType switch { DBBackupFileType.EmptyDB => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DBBackup_EmptyDB).Replace("[DBType]", dbType), DBBackupFileType.EmptyDBWithSystemTables => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DBBackup_ExceptSystemTables).Replace("[DBType]", dbType), DBBackupFileType.AfterRunInitStateScript => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DBBackup_AfterRunInitStateScript).Replace("[DBType]", dbType), DBBackupFileType.MiddleState => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DBBackup_MiddleState).Replace("[DBType]", dbType), DBBackupFileType.FinalState_DevEnv => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DBBackup_FinalState_DevEnv).Replace("[DBType]", dbType), DBBackupFileType.FinalState_DeliveryEnv => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DBBackup_FinalState_DeliveryEnv).Replace("[DBType]", dbType), DBBackupFileType.FinalState_MissingSystemTables => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DBBackup_FinalState_MissingSystemTables).Replace("[DBType]", dbType), DBBackupFileType.AddDataAfterFinalState => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DBBackup_AddDataAfterFinalState).Replace("[DBType]", dbType), _ => throw new Exception($"Invalid DBBackupFileType: '{dbBackupFileType}'"), }; return(filePath); }
public void SetDefaltValues() { if (string.IsNullOrWhiteSpace(DBType)) { DBType = SqlServerDBTypeObjectsFactory.DBTypeCode; } if (string.IsNullOrWhiteSpace(Server)) { Server = "(local)"; } if (string.IsNullOrWhiteSpace(BackupFolderPath)) { string tempBackupFolderPath = @"[CommonApplicationData]\AutoVersionsDB\Backups"; if (!string.IsNullOrWhiteSpace(Id)) { tempBackupFolderPath += $@"\{Id}"; } BackupFolderPath = FileSystemPathUtils.ParsePathVaribles(tempBackupFolderPath); } }
public Dictionary <string, ProjectConfigItem> GetAllProjectConfigs() { Dictionary <string, ProjectConfigItem> dicAllProjectConfigs = new Dictionary <string, ProjectConfigItem>(); List <ProjectConfigItem> listAllProjectConfigs; string configProjectsFilePath = FileSystemPathUtils.ParsePathVaribles(_settings.ConfigProjectsFilePath); if (File.Exists(configProjectsFilePath)) { string projectConfigsListStr = File.ReadAllText(configProjectsFilePath); listAllProjectConfigs = SerializationUtils.JsonDeserialize <List <ProjectConfigItem> >(projectConfigsListStr); } else { listAllProjectConfigs = new List <ProjectConfigItem>(); } listAllProjectConfigs = listAllProjectConfigs.OrderBy(e => e.Id.ToTrimedInvariant()).ToList(); dicAllProjectConfigs = listAllProjectConfigs.ToDictionary(e => e.Id.ToTrimedInvariant()); return(dicAllProjectConfigs); }
private static void SetScriptsFoldersPath(ref ProjectConfigItem projectConfig, ScriptFilesStateType scriptFilesStateType) { if (projectConfig.DevEnvironment) { switch (scriptFilesStateType) { case ScriptFilesStateType.ValidScripts: projectConfig.DevScriptsBaseFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DevScriptsBaseFolderPath_Normal).Replace("[DBType]", projectConfig.DBType); break; case ScriptFilesStateType.MissingFile: projectConfig.DevScriptsBaseFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DevScriptsBaseFolderPath_MissingFile).Replace("[DBType]", projectConfig.DBType); break; case ScriptFilesStateType.ScriptError: projectConfig.DevScriptsBaseFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DevScriptsBaseFolderPath_ScriptError).Replace("[DBType]", projectConfig.DBType); break; case ScriptFilesStateType.IncrementalChanged: projectConfig.DevScriptsBaseFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DevScriptsBaseFolderPath_ChangedHistoryFiles_Incremental).Replace("[DBType]", projectConfig.DBType); break; case ScriptFilesStateType.RepeatableChanged: projectConfig.DevScriptsBaseFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DevScriptsBaseFolderPath_ChangedHistoryFiles_Repeatable).Replace("[DBType]", projectConfig.DBType); break; case ScriptFilesStateType.NoScriptFiles: projectConfig.DevScriptsBaseFolderPath = FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DevScriptsBaseFolderPath_NoScriptFiles).Replace("[DBType]", projectConfig.DBType); if (!Directory.Exists(projectConfig.IncrementalScriptsFolderPath)) { Directory.CreateDirectory(projectConfig.IncrementalScriptsFolderPath); } if (!Directory.Exists(projectConfig.RepeatableScriptsFolderPath)) { Directory.CreateDirectory(projectConfig.RepeatableScriptsFolderPath); } if (!Directory.Exists(projectConfig.DevDummyDataScriptsFolderPath)) { Directory.CreateDirectory(projectConfig.DevDummyDataScriptsFolderPath); } break; default: throw new Exception($"Invalid ScriptFilesStateType: '{scriptFilesStateType}'"); } } else { projectConfig.DeliveryArtifactFolderPath = scriptFilesStateType switch { ScriptFilesStateType.ValidScripts => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DeliveryArtifactFolderPath_Normal).Replace("[DBType]", projectConfig.DBType), ScriptFilesStateType.MissingFile => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DeliveryArtifactFolderPath_MissingFileh).Replace("[DBType]", projectConfig.DBType), ScriptFilesStateType.ScriptError => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DeliveryArtifactFolderPath_ScriptError).Replace("[DBType]", projectConfig.DBType), ScriptFilesStateType.IncrementalChanged => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DeliveryArtifactFolderPath_ChangedHistoryFiles_Incremental).Replace("[DBType]", projectConfig.DBType), ScriptFilesStateType.RepeatableChanged => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DeliveryArtifactFolderPath_ChangedHistoryFiles_Repeatable).Replace("[DBType]", projectConfig.DBType), ScriptFilesStateType.WithDevDummyDataFiles => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DeliveryArtifactFolderPath_WithDevDummyDataFiles).Replace("[DBType]", projectConfig.DBType), ScriptFilesStateType.NoScriptFiles => FileSystemPathUtils.ParsePathVaribles(IntegrationTestsConsts.DeliveryArtifactFolderPath_NoScriptFiles).Replace("[DBType]", projectConfig.DBType), _ => throw new Exception($"Invalid ScriptFilesStateType: '{scriptFilesStateType}'"), }; } }
public AutoVersionsDBSettings(string autoVersionsDBBaseFolder) { _autoVersionsDBBaseFolder = FileSystemPathUtils.ParsePathVaribles(autoVersionsDBBaseFolder); }
public AutoVersionsDBSettings() { _autoVersionsDBBaseFolder = FileSystemPathUtils.ParsePathVaribles(@"[CommonApplicationData]\AutoVersionsDB"); }