public void NullableSumTest()
{
SQLiteConnection db = new TestDb();
db.CreateTable <NullableIntClass>();
var r = db.ExecuteScalar <int>("SELECT SUM(NullableInt) FROM NullableIntClass WHERE 1 = 0");
Assert.AreEqual(0, r);
}
public void CheckMaxLengthAttributesSubtypesRespected()
{
var db = new TestDb();
db.CreateTable <Tweet>();
string creationString = db.ExecuteScalar <string>("select min(sql) from sqlite_master");
Assert.That(creationString, Is.StringContaining("varchar(140)"));
}
public void CanUseSubtypeOfTableAttribute()
{
var db = new TestDb();
db.CreateTable <Cat>();
db.Insert(new Cat()
{
Breed = "Siamese"
});
int numCats = db.ExecuteScalar <int>("select count(*) from Cats");
Assert.That(numCats, Is.EqualTo(1), "The resulting num cats should be 1.");
}
public void NullableSumTest()
{
SQLiteConnection db = new TestDb();
db.CreateTable<NullableIntClass>();
var r = db.ExecuteScalar<int>("SELECT SUM(NullableInt) FROM NullableIntClass WHERE 1 = 0");
Assert.AreEqual(0, r);
}
public void CheckMaxLengthAttributesSubtypesRespected()
{
var db = new TestDb();
db.CreateTable<Tweet>();
string creationString = db.ExecuteScalar<string>("select min(sql) from sqlite_master");
Assert.That(creationString, Is.StringContaining("varchar(140)"));
}
public void CanUseSubtypeOfTableAttribute()
{
var db = new TestDb();
db.CreateTable<Cat>();
db.Insert(new Cat()
{
Breed = "Siamese"
});
int numCats = db.ExecuteScalar<int>("select count(*) from Cats");
Assert.That(numCats,Is.EqualTo(1), "The resulting num cats should be 1.");
}
