public void Main()
{
Director director = new Director();
Console.WriteLine("Cadena de conexión del SQL Server");
SQLServerBuilder CadenaBuilder = new SQLServerBuilder();
director.CrearConexion(CadenaBuilder);
SQLServer sQLServer = CadenaBuilder.GetResult();
sQLServer.Imprimir();
Console.WriteLine("\nCadena de conexión del MySQL ");
MySQLBuilder CadenaMySQLBuilder = new MySQLBuilder();
director.CrearConexion(CadenaMySQLBuilder);
MySQL mySQL = CadenaMySQLBuilder.GetResult();
mySQL.Imprimir();
Console.WriteLine("\n Cadena de conexión del Access");
AccessBuilder CadenaAccessBuilder = new AccessBuilder();
director.CrearConexion(CadenaAccessBuilder);
Access Access = CadenaAccessBuilder.GetResult();
Access.Imprimir();
Console.ReadLine();
}
public void DeveGerarScriptSelecao()
{
//Arrange
var builder = new SQLServerBuilder <PessoaMock>();
//Act
var select = builder.BuildSelect();
//Assert
Assert.AreEqual("select id, nome, datanascimento from pessoa", select.ToLower());
}
public void DeveGerarScriptInsert()
{
//Arrange
var builder = new SQLServerBuilder <PessoaMock>();
var pessoa = new PessoaMock()
{
Id = 1, Nome = "João", DataNascimento = new DateTime(2000, 01, 01)
};
IDictionary <string, object> parametros = new Dictionary <string, object>();
//Act
var insert = builder.BuildInsert(pessoa, out parametros);
//Assert
Assert.AreEqual(@"insert into pessoa values(1, 'João', '2000-01-01'", insert.ToLower());
}
