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