public void The_DatabaseName_Is_Wired_Up_Correctly_With_Database()
{
IDatabaseForm form = MockRepository.GenerateMock <IDatabaseForm>();
Database obj = new Database("Database1");
ISQLServer2005DatabaseConnector connector = MockRepository.GenerateStub <ISQLServer2005DatabaseConnector>();
connector.ConnectionInformation = new ConnectionStringHelper
{
UserName = "******",
Password = "******",
ServerName = "Server",
UseFileName = false
};
connector.DatabaseName = "DatabaseName";
obj.Loader = new SQLServer2005DatabaseLoader(connector);
IMainPanel panel = MockRepository.GenerateMock <IMainPanel>();
var presenter = new DatabasePresenter(panel, form);
presenter.AttachToModel(obj);
form.AssertWasCalled(a => a.SelectedDatabaseType = DatabaseTypes.SQLServer2005);
form.AssertWasCalled(a => a.SetDatabase("DatabaseName"));
form.AssertWasCalled(a => a.Username = "******");
form.AssertWasCalled(a => a.Password = "******");
form.AssertWasCalled(a => a.SelectedServerName = "Server");
form.AssertWasCalled(a => a.DatabaseHelper = Arg <IServerAndDatabaseHelper> .Is.NotNull);
}
public void Outputs_This()
{
ISQLServer2005DatabaseConnector connector = MockRepository.GenerateStub <ISQLServer2005DatabaseConnector>();
connector.ConnectionInformation = new ConnectionStringHelper
{
UserName = "******",
Password = "******", // Including to make sure it does not save the password
ServerName = "server",
DatabaseName = "database"
};
string output = new DatabaseSerialisationScheme().SerialiseConnectionInformation(connector);
Assert.That(output.RemoveWhitespaceBetweenXmlElements(), Is.EqualTo(ExpectedXml));
}
public void Serialise(ISQLServer2005DatabaseConnector connector, XmlWriter writer)
{
if (connector == null)
{
return;
}
if (writer == null)
{
return;
}
writer.WriteStartElement("ConnectionInformation");
writer.WriteAttributeString("DatabaseConnector", "SqlServer2005");
var info = connector.ConnectionInformation;
writer.WriteElementString("ServerName", info.ServerName);
if (info.UseFileName)
{
writer.WriteElementString("FileName", info.FileName);
}
else
{
writer.WriteElementString("DatabaseName", info.DatabaseName);
}
if (info.UseIntegratedSecurity)
{
writer.WriteElementString("UseIntegratedSecurity", "True");
}
else
{
writer.WriteElementString("UserName", info.UserName);
if (info.Password != null)
{
writer.WriteElementString("Password", info.Password.Encrypt());
}
}
writer.WriteElementString("Port", info.Port.ToString());
writer.WriteEndElement();
}
public SQLServer2005DatabaseFormFiller(ISQLServer2005DatabaseConnector connector)
{
this.connector = connector;
}
public void Serialise(ISQLServer2005DatabaseConnector connector, XmlWriter writer)
{
if (connector == null) return;
if (writer == null) return;
writer.WriteStartElement("ConnectionInformation");
writer.WriteAttributeString("DatabaseConnector", "SqlServer2005");
var info = connector.ConnectionInformation;
writer.WriteElementString("ServerName", info.ServerName);
if (info.UseFileName)
writer.WriteElementString("FileName", info.FileName);
else
writer.WriteElementString("DatabaseName", info.DatabaseName);
if (info.UseIntegratedSecurity)
writer.WriteElementString("UseIntegratedSecurity", "True");
else
{
writer.WriteElementString("UserName", info.UserName);
if (info.Password != null)
writer.WriteElementString("Password", info.Password.Encrypt());
}
writer.WriteElementString("Port", info.Port.ToString());
writer.WriteEndElement();
}
public SQLServer2005DatabaseLoader(ISQLServer2005DatabaseConnector connector)
{
this.connector = connector;
}
public SQLServer2005DatabaseLoader(ISQLServer2005DatabaseConnector connector)
{
this.connector = connector;
}
