public override string Validate()
{
if (_dbConnectionInfo.HasValues)
{
using (var dbConnection = _dbCommandsFactory.CreateDBConnection(_dbConnectionInfo))
{
if (dbConnection != null)
{
if (!dbConnection.CheckConnection(out string exMessage))
{
string errorMsg = CoreTextResources
.ConnectionStringValidatorErrorMessage
.Replace("[DBConnectionInfo]", _dbConnectionInfo.ToString())
.Replace("[ConnectionString]", dbConnection.ConnectionString)
.Replace("[exMessage]", exMessage);
return(errorMsg);
}
}
}
}
return("");
}
public void RestoreDB(DBConnectionInfo dbConnectionInfo, DBBackupFileType dbBackupFileType)
{
using (var dbConnection = _dbCommandsFactory.CreateDBConnection(dbConnectionInfo))
{
using (var dbBackupRestoreCommands = _dbCommandsFactory.CreateDBBackupRestoreCommands(dbConnectionInfo))
{
string dbTestsBaseLocation = Path.Combine(FileSystemPathUtils.CommonApplicationData, "AutoVersionsDB.IntegrationTests", "TestsDBs");
if (!Directory.Exists(dbTestsBaseLocation))
{
Directory.CreateDirectory(dbTestsBaseLocation);
}
string filename = _dbBackupFilesProvider.GetDBBackupFilePath(dbBackupFileType, dbConnectionInfo.DBType);
dbBackupRestoreCommands.RestoreDBFromBackup(filename, dbConnection.DataBaseName, dbTestsBaseLocation);
}
}
}
