public void ShouldObfuscatePasswordOfConnectionString()
{
string configPath = GetPath("WithWrongConnectionString.config");
string machineConfigPath = GetPath("FromMachineConfig.config");
_configManagerMock.Setup(x => x.LoadFromFile(TARGET))
.Returns(LoadFromFile(configPath));
_configManagerMock.Setup(x => x.LoadFromMachineConfiguration())
.Returns(LoadFromFile(machineConfigPath));
var sut = new ConnectionStringManager(
_configManagerMock.Object,
_logger,
@"server=.\SQLEXPRESS;uid=test;pwd=test;Trusted_Connection=yes;database=FluentMigrator",
null,
TARGET,
DATABASE);
sut.LoadConnectionString();
var expectedMessage = @"Using Database sqlserver2008 and Connection String server=.\SQLEXPRESS;uid=test;pwd=********;Trusted_Connection=yes;database=FluentMigrator";
_logMessages.Count(x => x.Contains(expectedMessage)).ShouldBe(1);
}
public void ShouldLoadNamedConnectionFromSpecifiedConfigFile()
{
string configPath = GetPath("WithConnectionString.config");
var sut = new ConnectionStringManager(configManagerMock.Object, announcerMock.Object, CONNECTION_NAME, configPath, TARGET, DATABASE);
configManagerMock.Setup(m => m.LoadFromFile(configPath))
.Returns(LoadFromFile(configPath));
sut.LoadConnectionString();
Assert.That(sut.ConnectionString, Is.EqualTo("From Arbitrary Config"));
}
public void ShouldLoadNamedConnectionFromTargetAssemblyConfig()
{
string configPath = GetPath("WithConnectionString.exe.config");
configManagerMock.Setup(x => x.LoadFromFile(TARGET))
.Returns(LoadFromFile(configPath));
var sut = new ConnectionStringManager(configManagerMock.Object, announcerMock.Object, CONNECTION_NAME, null, TARGET, DATABASE);
sut.LoadConnectionString();
Assert.That(sut.ConnectionString, Is.EqualTo("From App Config"));
}
public void ShouldLoadMachineNameConnectionFromSpecifiedConfigIfNoConnectionNameSpecified()
{
string configPath = GetPath("WithConnectionString.config");
var sut = new ConnectionStringManager(configManagerMock.Object, announcerMock.Object, null, configPath, TARGET, DATABASE);
configManagerMock.Setup(m => m.LoadFromFile(configPath))
.Returns(LoadFromFile(configPath));
sut.MachineNameProvider = () => "MACHINENAME";
sut.LoadConnectionString();
Assert.That(sut.ConnectionString, Is.EqualTo("From Machine Name"));
}
public void ShouldUseAsConnectionStringIfNoConnectionMatchesAndNoMatchInMachineConfig()
{
string configPath = GetPath("WithWrongConnectionString.config");
string machineConfigPath = GetPath("FromMachineConfig.config");
configManagerMock.Setup(x => x.LoadFromFile(TARGET))
.Returns(LoadFromFile(configPath));
configManagerMock.Setup(x => x.LoadFromMachineConfiguration())
.Returns(LoadFromFile(machineConfigPath));
var sut = new ConnectionStringManager(configManagerMock.Object, announcerMock.Object, "This is a connection string", null, TARGET, DATABASE);
sut.LoadConnectionString();
Assert.That(sut.ConnectionString, Is.EqualTo("This is a connection string"));
}
public void ShouldLoadNamedConnectionFromMachineConfigIfTargetAssemblyConfigHasNoMatch()
{
string configPath = GetPath("WithWrongConnectionString.config");
string machineConfigPath = GetPath("FromMachineConfig.config");
configManagerMock.Setup(x => x.LoadFromFile(TARGET))
.Returns(LoadFromFile(configPath));
configManagerMock.Setup(x => x.LoadFromMachineConfiguration())
.Returns(LoadFromFile(machineConfigPath));
var sut = new ConnectionStringManager(configManagerMock.Object, announcerMock.Object, CONNECTION_NAME, null, TARGET, DATABASE);
sut.LoadConnectionString();
configManagerMock.VerifyAll();
Assert.That(sut.ConnectionString, Is.EqualTo("From Machine Config"));
}
public void ShouldObfuscatePasswordOfConnectionString()
{
string configPath = GetPath("WithWrongConnectionString.config");
string machineConfigPath = GetPath("FromMachineConfig.config");
configManagerMock.Setup(x => x.LoadFromFile(TARGET))
.Returns(LoadFromFile(configPath));
configManagerMock.Setup(x => x.LoadFromMachineConfiguration())
.Returns(LoadFromFile(machineConfigPath));
var sut = new ConnectionStringManager(configManagerMock.Object, announcerMock.Object,
@"server=.\SQLEXPRESS;uid=test;pwd=test;Trusted_Connection=yes;database=FluentMigrator", null, TARGET,
DATABASE);
sut.LoadConnectionString();
announcerMock.Verify(a => a.Say(@"Using Database sqlserver2008 and Connection String server=.\SQLEXPRESS;uid=test;pwd=********;Trusted_Connection=yes;database=FluentMigrator"), Times.Once());
}
