private ProjectMetadata GetDbProjectMetadata(DbProjectInfo dbProjectInfo, EnvironmentInfo environmentInfo)
{
var projectVersions = new List <MachineSpecificProjectVersion>();
DbProjectConfiguration dbProjectConfiguration =
environmentInfo.GetDbProjectConfiguration(dbProjectInfo);
DatabaseServer databaseServer =
environmentInfo.GetDatabaseServer(dbProjectConfiguration.DatabaseServerId);
var dbVersions =
_dbVersionProvider.GetVersions(
dbProjectInfo.DbName,
databaseServer.MachineName);
DbVersion latestDbVersion =
dbVersions
.Select(s => DbVersion.FromString(s.Version))
.OrderByDescending(v => v)
.FirstOrDefault();
if (latestDbVersion != null)
{
projectVersions.Add(new MachineSpecificProjectVersion(databaseServer.MachineName, latestDbVersion.ToString()));
}
return(new ProjectMetadata(dbProjectInfo.Name, environmentInfo.Name, projectVersions));
}
public void DbSettingsLoadUsersCorrectly()
{
ProjectInfo info = _projectInfoRepository.FindByName("UberDeployer.SampleDb");
DbProjectInfo dbInfo = (DbProjectInfo)info;
Assert.AreEqual(3, dbInfo.Users.Count);
Assert.AreEqual("Username1", dbInfo.Users.First());
}
public DropDatabaseDeploymentStep(DbProjectInfo projectInfo, DatabaseServer databaseServer, IDbManagerFactory dbManagerFactory)
{
Guard.NotNull(projectInfo, "projectInfo");
Guard.NotNull(databaseServer, "databaseServer");
Guard.NotNull(dbManagerFactory, "dbManager");
_projectInfo = projectInfo;
_databaseServer = databaseServer;
_dbManagerFactory = dbManagerFactory;
}
public PublishDatabaseDeploymentStep(DbProjectInfo dbProjectInfo, DatabaseServer databaseServer, string artifactsDirPath, IMsSqlDatabasePublisher databasePublisher)
{
Guard.NotNull(dbProjectInfo, "dbProjectInfo");
Guard.NotNull(databaseServer, "databaseServer");
Guard.NotNull(artifactsDirPath, "artifactsDirPath");
Guard.NotNull(databasePublisher, "databasePublisher");
_dbProjectInfo = dbProjectInfo;
_databaseServer = databaseServer;
_artifactsDirPath = artifactsDirPath;
_databasePublisher = databasePublisher;
}
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));
}
}
}
}
