public void SetUp()
{
_dbVersionProviderFake = new Mock <IDbVersionProvider>(MockBehavior.Loose);
_scriptsToRunWebSelector = new Mock <IScriptsToRunSelector>(MockBehavior.Loose);
DbProjectInfo dbProjectInfo = ProjectInfoGenerator.GetDbProjectInfo();
DeploymentInfo di = DeploymentInfoGenerator.GetDbDeploymentInfo();
_deploymentStep = new GatherDbScriptsToRunDeploymentStep(
dbProjectInfo.DbName,
new Lazy <string>(() => _ScriptPath),
_SqlServerName,
_Environment,
di,
_dbVersionProviderFake.Object,
_scriptsToRunWebSelector.Object);
}
public void SetUp()
{
_dbVersionProviderFake = new Mock<IDbVersionProvider>(MockBehavior.Loose);
_scriptsToRunWebSelector = new Mock<IScriptsToRunSelector>(MockBehavior.Loose);
DbProjectInfo dbProjectInfo = ProjectInfoGenerator.GetDbProjectInfo();
DeploymentInfo di = DeploymentInfoGenerator.GetDbDeploymentInfo();
_deploymentStep = new GatherDbScriptsToRunDeploymentStep(
dbProjectInfo.DbName,
new Lazy<string>(() => _ScriptPath),
_SqlServerName,
_Environment,
di,
_dbVersionProviderFake.Object,
_scriptsToRunWebSelector.Object);
}
protected override void DoPrepare()
{
EnvironmentInfo environmentInfo = GetEnvironmentInfo();
DbProjectInfo projectInfo = GetProjectInfo <DbProjectInfo>();
DbProjectConfiguration dbProjectConfiguration =
environmentInfo.GetDbProjectConfiguration(projectInfo);
DatabaseServer databaseServer =
environmentInfo.GetDatabaseServer(dbProjectConfiguration.DatabaseServerId);
string databaseServerMachineName = databaseServer.MachineName;
bool databaseExists = _dbVersionProvider.CheckIfDatabaseExists(
projectInfo.DbName,
databaseServerMachineName);
// create a step for downloading the artifacts
var downloadArtifactsDeploymentStep =
new DownloadArtifactsDeploymentStep(
projectInfo,
DeploymentInfo,
GetTempDirPath(),
_artifactsRepository);
AddSubTask(downloadArtifactsDeploymentStep);
// create a step for extracting the artifacts
var extractArtifactsDeploymentStep =
new ExtractArtifactsDeploymentStep(
projectInfo,
environmentInfo,
DeploymentInfo,
downloadArtifactsDeploymentStep.ArtifactsFilePath,
GetTempDirPath(),
_fileAdapter,
_directoryAdapter,
_zipFileAdapter);
AddSubTask(extractArtifactsDeploymentStep);
if (databaseExists)
{
// create a step for gathering scripts to run
var gatherDbScriptsToRunDeploymentStep = new GatherDbScriptsToRunDeploymentStep(
projectInfo.DbName,
new Lazy <string>(() => extractArtifactsDeploymentStep.BinariesDirPath),
databaseServerMachineName,
environmentInfo.Name,
DeploymentInfo,
_dbVersionProvider,
_createScriptsToRunSelector
);
AddSubTask(gatherDbScriptsToRunDeploymentStep);
// create a step for running scripts
var runDbScriptsDeploymentStep = new RunDbScriptsDeploymentStep(
GetScriptRunner(projectInfo.IsTransactional, databaseServerMachineName, projectInfo.DbName, environmentInfo.DatabaseServers.FirstOrDefault(e => e.Id == projectInfo.DatabaseServerId)),
databaseServerMachineName,
new DeferredEnumerable <DbScriptToRun>(() => gatherDbScriptsToRunDeploymentStep.ScriptsToRun));
AddSubTask(runDbScriptsDeploymentStep);
}
else
{
// create step for dropping database
var createDatabaseDeploymentStep = new CreateDatabaseDeploymentStep(projectInfo, databaseServer, _dbManagerFactory);
AddSubTask(createDatabaseDeploymentStep);
// create step for deploying dacpac
var publishDatabaseDeploymentStep =
new PublishDatabaseDeploymentStep(
projectInfo,
databaseServer,
GetTempDirPath(),
_databasePublisher);
AddSubTask(publishDatabaseDeploymentStep);
}
foreach (string userId in projectInfo.Users)
{
var environmentUser = environmentInfo.EnvironmentUsers.SingleOrDefault(x => x.Id == userId);
if (environmentUser == null)
{
throw new DeploymentTaskException(string.Format("User [{0}] doesn't exist in enviroment configuration [{1}] in project [{2}]", userId, environmentInfo.Name, projectInfo.Name));
}
string user = _userNameNormalizer.ConvertToPreWin2000UserName(environmentUser.UserName, environmentInfo.DomainName);
IDbManager manager = _dbManagerFactory.CreateDbManager(databaseServerMachineName);
if (databaseExists && manager.UserExists(projectInfo.DbName, user))
{
foreach (string dbUserRole in _dbUserRoles)
{
if (!manager.CheckIfUserIsInRole(projectInfo.DbName, user, dbUserRole))
{
AddSubTask(new AddRoleToUserStep(manager, projectInfo.DbName, user, dbUserRole));
}
}
}
else
{
AddSubTask(new AddUserToDatabaseStep(manager, projectInfo.DbName, user));
foreach (string dbUserRole in _dbUserRoles)
{
AddSubTask(new AddRoleToUserStep(manager, projectInfo.DbName, user, dbUserRole));
}
}
}
}
