public void Should_Find_Sql_Package_Runner_If_Tool_Path_Not_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
// When
var result = fixture.Run();
// Then
Assert.Equal("/Working/tools/SqlPackage.exe", result.Path.FullPath);
}
public void Should_Not_Add_Quiet_If_Not_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
// When
var result = fixture.Run();
// Then
Assert.Equal("/Action:Publish", result.Args);
}
public void Should_Set_Working_Directory()
{
// Given
var fixture = new SqlPackagePublishFixture();
// When
var result = fixture.Run();
// Then
Assert.Equal("/Working", result.Process.WorkingDirectory.FullPath);
}
public void Should_Not_Add_Target_Connection_If_Target_File_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.TargetFile = "./sqlpublishprofile.pubxml";
// When
var result = fixture.Run();
// Then
Assert.DoesNotContain("/TargetConnectionString:", result.Args);
}
public void Should_Add_Target_File_If_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.TargetFile = "./sqlpublishprofile.pubxml";
// When
var result = fixture.Run();
// Then
Assert.Equal("/Action:Publish /TargetFile:\"/Working/sqlpublishprofile.pubxml\"", result.Args);
}
public void Should_Add_Quiet_If_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.Quiet = true;
// When
var result = fixture.Run();
// Then
Assert.Equal("/Action:Publish /Quiet:True", result.Args);
}
public void Should_Add_OutputPath_If_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.OutputPath = "./artifacts";
// When
var result = fixture.Run();
// Then
Assert.Equal("/Action:Publish /OutputPath:\"/Working/artifacts\"", result.Args);
}
public void Should_Add_Overwrite_Files_If_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.OverwriteFiles = true;
// When
var result = fixture.Run();
// Then
Assert.Equal("/Action:Publish /OverwriteFiles:True", result.Args);
}
public void Should_Add_Secret_If_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.AzureSecret = "banana";
// When
var result = fixture.Run();
// Then
Assert.Equal("/Action:Publish /Secret:banana", result.Args);
}
public void Should_Add_Azure_Key_Vault_Auth_Method_If_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.AzureKeyVaultAuthMethod = AzureKeyVaultAuthMethod.Interactive;
// When
var result = fixture.Run();
// Then
Assert.Equal("/Action:Publish /AzureKeyVaultAuthMethod:Interactive", result.Args);
}
public void Should_Throw_If_Settings_Is_Null()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings = null;
// When
var result = Record.Exception(() => fixture.Run());
// Then
Assert.IsType <ArgumentNullException>(result);
}
public void Should_Add_Variables_If_Provided(string key, string value)
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.Variables.Add(key, value);
// When
var result = fixture.Run();
//Then
Assert.Equal($"/Action:Publish /v:{key}={value}", result.Args);
}
public void Should_Not_Add_Target_File_If_Target_Connection_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.TargetConnectionString =
"Data Target=(LocalDB)\\v11.0;AttachDbFileName=|DataDirectory|\\DatabaseFileName.mdf;InitialCatalog=DatabaseName;Integrated Security=True;MultipleActiveResultSets=True";
// When
var result = fixture.Run();
// Then
Assert.DoesNotContain("/TargetFile:", result.Args);
}
public void Should_Throw_If_Process_Has_A_Non_Zero_Exit_Code()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.GivenProcessExitsWithCode(1);
// When
var result = Record.Exception(() => fixture.Run());
// Then
Assert.IsType <CakeException>(result);
Assert.Equal("SqlPackage: Process returned an error (exit code 1).", result?.Message);
}
public void Should_Add_Variables_After_Settings_If_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.OverwriteFiles = true;
fixture.Settings.Variables.Add("CommandTimeout", "120");
// When
var result = fixture.Run();
//Then
Assert.Equal($"/Action:Publish /OverwriteFiles:True /v:CommandTimeout=120", result.Args);
}
public void Should_Use_Sql_Package_Runner_From_Tool_Path_If_Provided(string toolPath, string expected)
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.ToolPath = toolPath;
fixture.GivenSettingsToolPathExist();
// When
var result = fixture.Run();
// Then
Assert.Equal(expected, result.Path.FullPath);
}
public void Should_Add_Source_Connection_String_If_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.SourceConnectionString =
"Data Source=(LocalDB)\\v11.0;AttachDbFileName=|DataDirectory|\\DatabaseFileName.mdf;InitialCatalog=DatabaseName;Integrated Security=True;MultipleActiveResultSets=True";
// When
var result = fixture.Run();
// Then
Assert.Equal("/Action:Publish /SourceConnectionString:\"Data Source=(LocalDB)\\v11.0;AttachDbFileName=|DataDirectory|\\DatabaseFileName.mdf;InitialCatalog=DatabaseName;Integrated Security=True;MultipleActiveResultSets=True\"", result.Args);
}
public void Should_Throw_If_Sql_Package_Runner_Was_Not_Found()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.GivenDefaultToolDoNotExist();
// When
var result = Record.Exception(() => fixture.Run());
// Then
Assert.IsType <CakeException>(result);
Assert.Equal("SqlPackage: Could not locate executable.", result?.Message);
}
public void Should_Throw_If_Process_Was_Not_Started()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.GivenProcessCannotStart();
// When
var result = Record.Exception(() => fixture.Run());
// Then
Assert.IsType <CakeException>(result);
Assert.Equal("SqlPackage: Process was not started.", result?.Message);
}
public void Should_Not_Add_Target_Properties_If_Target_File_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.TargetFile = "./sqlpublishprofile.pubxml";
// When
var result = fixture.Run();
// Then
Assert.DoesNotContain("/TargetConnectionString:", result.Args);
Assert.DoesNotContain("/TargetDatabaseName:", result.Args);
Assert.DoesNotContain("/TargetEncryptConnection:", result.Args);
Assert.DoesNotContain("/TargetPassword:"******"/TargetServerName:", result.Args);
Assert.DoesNotContain("/TargetTimeout:", result.Args);
Assert.DoesNotContain("/TargetTrustServerCertificate:", result.Args);
Assert.DoesNotContain("/TargetUser:", result.Args);
}
public void Should_Not_Add_Source_Properties_If_Source_Connection_Provided()
{
// Given
var fixture = new SqlPackagePublishFixture();
fixture.Settings.SourceConnectionString =
"Data Source=(LocalDB)\\v11.0;AttachDbFileName=|DataDirectory|\\DatabaseFileName.mdf;InitialCatalog=DatabaseName;Integrated Security=True;MultipleActiveResultSets=True";
// When
var result = fixture.Run();
// Then
Assert.DoesNotContain("/SourceFile:", result.Args);
Assert.DoesNotContain("/SourceDatabaseName:", result.Args);
Assert.DoesNotContain("/SourceEncryptConnection:", result.Args);
Assert.DoesNotContain("/SourcePassword:"******"/SourceServerName:", result.Args);
Assert.DoesNotContain("/SourceTimeout:", result.Args);
Assert.DoesNotContain("/SourceTrustServerCertificate:", result.Args);
Assert.DoesNotContain("/SourceUser:", result.Args);
}
public TheRunMethod()
{
fixture = new SqlPackagePublishFixture();
}