public void PostGresTestOperators()
{
var conn = new Npgsql.NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString);
var scriptBuilder = conn.GetScriptBuild();
var cliente1 = new Cliente()
{
Nome = "Miranda"
};
var cliente2 = new Cliente()
{
Nome = "Moshe"
};
var cliente3 = new Cliente()
{
Nome = "Moshe"
};
var createTableScript = scriptBuilder.GetCreateTableCommand <Cliente>();
conn.Execute(createTableScript);
var id = conn.InsertReturningId <Cliente>(cliente1);
conn.Insert(cliente2);
conn.Insert(cliente3);
var clientesWithIdGreaterThan1 = conn.Select <Cliente>(c => c.Id > 1);
var clientesIdOtherThan3 = conn.Select <Cliente>(c => c.Id != 3);
var clientesWithIdLessThan2 = conn.Select <Cliente>(c => c.Id < 2);
Assert.AreEqual(2, clientesWithIdGreaterThan1.Count());
Assert.AreEqual("Miranda", clientesIdOtherThan3.ToList()[0].Nome);
Assert.AreEqual(2, clientesIdOtherThan3.ToList()[1].Id);
Assert.AreEqual(1, clientesWithIdLessThan2.Count());
conn.Execute("drop table \"Cliente\"");
}
public void PostGresInsertModelFillingId()
{
var conn = new Npgsql.NpgsqlConnection(ConfigurationManager.ConnectionStrings["postgres"].ConnectionString);
var scriptBuilder = conn.GetScriptBuild();
var cliente = new Cliente()
{
Nome = "Miranda"
};
var createTableScript = scriptBuilder.GetCreateTableCommand <Cliente>();
conn.Execute(createTableScript);
conn.Insert <Cliente>(cliente);
Assert.AreEqual(1, cliente.Id);
conn.Execute("drop table \"Cliente\"");
}
public void TestPostresqlArrayParameters()
{
using (var conn = new NpgsqlConnection("Server=localhost;Port=5432;User Id=dappertest;Password=dapperpass;Database=dappertest;Encoding=UNICODE"))
{
conn.Open();
IDbTransaction transaction = conn.BeginTransaction();
conn.Execute("create table tcat ( id serial not null, breed character varying(20) not null, name character varying (20) not null);");
foreach (var cat in Cats)
conn.Insert(cat);
var r = conn.Query<Cat>("select * from tcat where id=any(:catids)", new { catids = new[] { 1, 3, 5 } });
r.Count().IsEqualTo(3);
r.Count(c => c.Id == 1).IsEqualTo(1);
r.Count(c => c.Id == 3).IsEqualTo(1);
r.Count(c => c.Id == 5).IsEqualTo(1);
transaction.Rollback();
}
}
