public async Task GetDefaultConstraintsAsync_CorrectCreation_MoreConstraints_Async()
{
// Arrange
var xfsMock = Mock.Of <IXmlFormatService>();
var tempDacpacPath = WriteEmbeddedResourceToTemporaryFile("TestDatabase_AuthorWithDefaultConstraints.dacpac");
IDacAccess da = new DacAccess(xfsMock);
// Act
var(defaultConstraints, errors) = await da.GetDefaultConstraintsAsync(tempDacpacPath);
// Assert
Assert.IsNotNull(defaultConstraints);
Assert.IsNull(errors);
Assert.AreEqual(3, defaultConstraints.Length);
var orderedConstraints = defaultConstraints.OrderBy(m => m.ColumnName)
.ToArray();
// First constraint
Assert.AreEqual("dbo", orderedConstraints[0].TableSchema);
Assert.AreEqual("Author", orderedConstraints[0].TableName);
Assert.AreEqual("Birthday", orderedConstraints[0].ColumnName);
Assert.AreEqual("DF_Birthday_Today", orderedConstraints[0].ConstraintName);
// Second constraint
Assert.AreEqual("dbo", orderedConstraints[1].TableSchema);
Assert.AreEqual("Author", orderedConstraints[1].TableName);
Assert.AreEqual("FirstName", orderedConstraints[1].ColumnName);
Assert.AreEqual("DF_FirstName_Empty", orderedConstraints[1].ConstraintName);
// Third constraint
Assert.AreEqual("dbo", orderedConstraints[2].TableSchema);
Assert.AreEqual("Author", orderedConstraints[2].TableName);
Assert.AreEqual("LastName", orderedConstraints[2].ColumnName);
Assert.AreEqual(null, orderedConstraints[2].ConstraintName);
}
public void CreateDeployFilesAsync_ArgumentNullException_PreviousVersionDacpacPath()
{
// Arrange
var xfsMock = Mock.Of <IXmlFormatService>();
IDacAccess da = new DacAccess(xfsMock);
// Act & Assert
// ReSharper disable AssignNullToNotNullAttribute
Assert.Throws <ArgumentNullException>(() => da.CreateDeployFilesAsync(null, null, null, false, false));
// ReSharper restore AssignNullToNotNullAttribute
}
public void GetDefaultConstraintsAsync_ArgumentNullException_DacpacPath()
{
// Arrange
var xfsMock = Mock.Of <IXmlFormatService>();
IDacAccess da = new DacAccess(xfsMock);
// Act & Assert
// ReSharper disable AssignNullToNotNullAttribute
Assert.Throws <ArgumentNullException>(() => da.GetDefaultConstraintsAsync(null));
// ReSharper restore AssignNullToNotNullAttribute
}
public void CreateDeployFilesAsync_InvalidOperationException_CreateNoOutput()
{
// Arrange
var xfsMock = Mock.Of <IXmlFormatService>();
IDacAccess da = new DacAccess(xfsMock);
var previousVersionDacpacPath = "path1";
var newVersionDacpacPath = "path2";
var publishProfilePath = "path3";
// Act & Assert
Assert.Throws <InvalidOperationException>(() => da.CreateDeployFilesAsync(previousVersionDacpacPath, newVersionDacpacPath, publishProfilePath, false, false));
}
public async Task CreateDeployFilesAsync_CorrectCreation_WithPreAndPostDeploymentScripts_Async()
{
// Arrange
var xfsMock = new Mock <IXmlFormatService>();
xfsMock.Setup(m => m.FormatDeployReport(It.IsNotNull <string>())).Returns((string s) => s);
var tempPreviousVersionDacpacPath = WriteEmbeddedResourceToTemporaryFile("TestDatabase_Empty.dacpac");
var tempNewVersionDacpacPath = WriteEmbeddedResourceToTemporaryFile("TestDatabase_WithPreAndPostDeployment.dacpac");
var tempPublishProfilePath = WriteEmbeddedResourceToTemporaryFile("TestDatabase.publish.xml");
IDacAccess da = new DacAccess(xfsMock.Object);
// Act
var result = await da.CreateDeployFilesAsync(tempPreviousVersionDacpacPath, tempNewVersionDacpacPath, tempPublishProfilePath, true, true);
// Assert
Assert.IsNotNull(result.DeployScriptContent);
Assert.IsNotNull(result.DeployReportContent);
Assert.AreEqual("-- Pre-deployment script content goes here\r\nGO\r\n", result.PreDeploymentScript);
Assert.AreEqual("-- Post-deployment script content goes here\r\nGO\r\n", result.PostDeploymentScript);
Assert.IsNull(result.Errors);
xfsMock.Verify(m => m.FormatDeployReport(It.IsNotNull <string>()), Times.Once);
// Verify script
var productionIndex = result.DeployScriptContent.IndexOf("PRODUCTION", StringComparison.InvariantCulture);
Assert.IsTrue(productionIndex > 0);
var onErrorIndex = result.DeployScriptContent.IndexOf(":on error exit", StringComparison.InvariantCulture);
Assert.IsTrue(onErrorIndex > productionIndex);
var changeDatabaseIndex = result.DeployScriptContent.IndexOf("USE [$(DatabaseName)]", StringComparison.InvariantCulture);
Assert.IsTrue(changeDatabaseIndex > onErrorIndex);
var preDeploymentIndex = result.DeployScriptContent.IndexOf(result.PreDeploymentScript, StringComparison.InvariantCulture);
Assert.IsTrue(preDeploymentIndex > changeDatabaseIndex);
var createAuthorPrintIndex = result.DeployScriptContent.IndexOf("[dbo].[Author]...';", StringComparison.InvariantCulture);
Assert.IsTrue(createAuthorPrintIndex > preDeploymentIndex);
var createAuthorTableIndex = result.DeployScriptContent.IndexOf("CREATE TABLE [dbo].[Author]", StringComparison.InvariantCulture);
Assert.IsTrue(createAuthorTableIndex > createAuthorPrintIndex);
var postDeploymentIndex = result.DeployScriptContent.IndexOf(result.PostDeploymentScript, StringComparison.InvariantCulture);
Assert.IsTrue(postDeploymentIndex > createAuthorTableIndex);
// Verify report
Assert.AreEqual(@"<?xml version=""1.0"" encoding=""utf-8""?><DeploymentReport xmlns=""http://schemas.microsoft.com/sqlserver/dac/DeployReport/2012/02""><Alerts />" +
@"<Operations><Operation Name=""Create""><Item Value=""[dbo].[Author]"" Type=""SqlTable"" /><Item Value=""[dbo].[DF_Birthday_Today]"" Type=""SqlDefaultConstraint"" /></Operation>" +
@"</Operations></DeploymentReport>",
result.DeployReportContent);
}
public async Task GetDefaultConstraintsAsync_CorrectCreation_SingleConstraints_Async()
{
// Arrange
var xfsMock = Mock.Of <IXmlFormatService>();
var tempDacpacPath = WriteEmbeddedResourceToTemporaryFile("TestDatabase_AuthorWithLessDefaultConstraints.dacpac");
IDacAccess da = new DacAccess(xfsMock);
// Act
var(defaultConstraints, errors) = await da.GetDefaultConstraintsAsync(tempDacpacPath);
// Assert
Assert.IsNotNull(defaultConstraints);
Assert.IsNull(errors);
Assert.AreEqual(1, defaultConstraints.Length);
Assert.AreEqual("dbo", defaultConstraints[0].TableSchema);
Assert.AreEqual("Author", defaultConstraints[0].TableName);
Assert.AreEqual("Birthday", defaultConstraints[0].ColumnName);
Assert.AreEqual("DF_Birthday_Today", defaultConstraints[0].ConstraintName);
}
