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")); }