public void GeraInsertCategoriaTeste()
{
CategoriaTeste categoria = new CategoriaTeste();
categoria.Id = 2;
categoria.Nome = "Comidas";
target = new CommandInsertGenerator(categoria);
string insert = "INSERT INTO categoria_teste (nome) VALUES ('Comidas')";
Assert.That(target.GetCommand(), Is.EqualTo(insert));
}
public void GeraDeleteProduto()
{
CategoriaTeste cat = new CategoriaTeste();
cat.Id = 65;
cat.Nome = "Cat Delete";
target = new CommandDeleteGenerator(cat);
string delete = "DELETE FROM categoria_teste WHERE id = 65";
Assert.That(target.GetCommand(), Is.EqualTo(delete));
}
public void GeraInsertCategoriaTeste()
{
CategoriaTeste categoria = new CategoriaTeste();
categoria.Id = 2;
categoria.Nome = "Comidas";
target = new CommandUpdateGenerator(categoria);
string insert = "UPDATE categoria_teste SET nome = 'Comidas' WHERE id = 2";
Assert.That(target.GetCommand(), Is.EqualTo(insert));
}
//[Test]
public void TestA()
{
CategoriaTeste cat = new CategoriaTeste();
cat.Id = 20000;
cat.Nome = "Teste Insert";
var insert = new CommandInsertGenerator(cat).GetCommand();
NonQueryCommandsExecutor executor = new NonQueryCommandsExecutor(cat);
executor.Execute();
var novaCategoria = target.Query()
.Where("categoriaTeste.Id = 20000")
.Execute()[0];
Assert.That(novaCategoria.Id, Is.EqualTo(20000));
Assert.That(novaCategoria.Nome, Is.EqualTo("Teste Insert"));
}
