public void TestBoolean() { var db = new OrmTestSession(); db.CreateTable<Vo>(); for (int i = 0; i < 10; i++) { db.Insert(new Vo {Flag = (i%3 == 0), Text = String.Format("VO{0}", i)}); } // count vo which flag is true Assert.AreEqual(4, CountWithFlag(db, true)); Assert.AreEqual(6, CountWithFlag(db, false)); Debug.WriteLine("VO with true flag:"); foreach (Vo vo in db.Query<Vo>("SELECT * FROM VO Where Flag = ?", true)) { Debug.WriteLine(vo.ToString()); } Debug.WriteLine("VO with false flag:"); foreach (Vo vo in db.Query<Vo>("SELECT * FROM VO Where Flag = ?", false)) { Debug.WriteLine(vo.ToString()); } }
public void TestBoolean() { var db = new OrmTestSession(); db.CreateTable <Vo>(); for (int i = 0; i < 10; i++) { db.Insert(new Vo { Flag = (i % 3 == 0), Text = String.Format("VO{0}", i) }); } // count vo which flag is true Assert.AreEqual(4, CountWithFlag(db, true)); Assert.AreEqual(6, CountWithFlag(db, false)); Debug.WriteLine("VO with true flag:"); foreach (Vo vo in db.Query <Vo>("SELECT * FROM VO Where Flag = ?", true)) { Debug.WriteLine(vo.ToString()); } Debug.WriteLine("VO with false flag:"); foreach (Vo vo in db.Query <Vo>("SELECT * FROM VO Where Flag = ?", false)) { Debug.WriteLine(vo.ToString()); } }
public void InsertTwoTimes() { var db = new OrmTestSession(); db.CreateTable <TestObj>(); var obj1 = new TestObj { Text = "GLaDOS loves testing!" }; var obj2 = new TestObj { Text = "Keep testing, just keep testing" }; int numIn1 = db.Insert(obj1); int numIn2 = db.Insert(obj2); Assert.AreEqual(1, numIn1); Assert.AreEqual(1, numIn2); List <TestObj> result = db.Query <TestObj>("select * from TestObj").ToList(); Assert.AreEqual(2, result.Count); Assert.AreEqual(obj1.Text, result[0].Text); Assert.AreEqual(obj2.Text, result[1].Text); db.Close(); }
public void InsertIntoTwoTables() { var db = new OrmTestSession(); db.CreateTable <TestObj>(); db.CreateTable <TestObj2>(); var obj1 = new TestObj { Text = "GLaDOS loves testing!" }; var obj2 = new TestObj2 { Text = "Keep testing, just keep testing" }; int numIn1 = db.Insert(obj1); Assert.AreEqual(1, numIn1); int numIn2 = db.Insert(obj2); Assert.AreEqual(1, numIn2); List <TestObj> result1 = db.Table <TestObj>().ToList(); Assert.AreEqual(numIn1, result1.Count); Assert.AreEqual(obj1.Text, result1.First().Text); List <TestObj> result2 = db.Query <TestObj>("select * from TestObj2").ToList(); Assert.AreEqual(numIn2, result2.Count); db.Close(); }
public void InsertWithExtra() { var db = new OrmTestSession(); db.CreateTable <TestObj2>(); var obj1 = new TestObj2 { Id = 1, Text = "GLaDOS loves testing!" }; var obj2 = new TestObj2 { Id = 1, Text = "Keep testing, just keep testing" }; var obj3 = new TestObj2 { Id = 1, Text = "Done testing" }; db.Insert(obj1); // "Expected unique constraint violation" ExceptionAssert.Throws <SqliteException>(() => db.Insert(obj2)); db.Insert(obj2, ConflictResolution.Replace); // "Expected unique constraint violation" ExceptionAssert.Throws <SqliteException>(() => db.Insert(obj3)); db.Insert(obj3, ConflictResolution.Ignore); List <TestObj> result = db.Query <TestObj>("select * from TestObj2").ToList(); Assert.AreEqual(1, result.Count); Assert.AreEqual(obj2.Text, result.First().Text); db.Close(); }
public void Unicode() { var insertItem = new TestObj { Text = "Sinéad O'Connor" }; var db = new OrmTestSession(); db.CreateTable <TestObj>(); int numIn = db.Insert(insertItem); Assert.AreEqual(numIn, 1, "Num inserted must = num objects"); TestObj inObjs = db.Query <TestObj>("select * from TestObj").First(); Assert.AreEqual(insertItem.Text, inObjs.Text); }
public void Unicode() { var insertItem = new TestObj { Text = "Sinéad O'Connor" }; var db = new OrmTestSession(); db.CreateTable<TestObj>(); int numIn = db.Insert(insertItem); Assert.AreEqual(numIn, 1, "Num inserted must = num objects"); TestObj inObjs = db.Query<TestObj>("select * from TestObj").First(); Assert.AreEqual(insertItem.Text, inObjs.Text); }
public void InsertWithExtra() { var db = new OrmTestSession(); db.CreateTable<TestObj2>(); var obj1 = new TestObj2 { Id = 1, Text = "GLaDOS loves testing!" }; var obj2 = new TestObj2 { Id = 1, Text = "Keep testing, just keep testing" }; var obj3 = new TestObj2 { Id = 1, Text = "Done testing" }; db.Insert(obj1); // "Expected unique constraint violation" ExceptionAssert.Throws<SqliteException>(() => db.Insert(obj2)); db.Insert(obj2, ConflictResolution.Replace); // "Expected unique constraint violation" ExceptionAssert.Throws<SqliteException>(() => db.Insert(obj3)); db.Insert(obj3, ConflictResolution.Ignore); List<TestObj> result = db.Query<TestObj>("select * from TestObj2").ToList(); Assert.AreEqual(1, result.Count); Assert.AreEqual(obj2.Text, result.First().Text); db.Close(); }
public void InsertTwoTimes() { var db = new OrmTestSession(); db.CreateTable<TestObj>(); var obj1 = new TestObj { Text = "GLaDOS loves testing!" }; var obj2 = new TestObj { Text = "Keep testing, just keep testing" }; int numIn1 = db.Insert(obj1); int numIn2 = db.Insert(obj2); Assert.AreEqual(1, numIn1); Assert.AreEqual(1, numIn2); List<TestObj> result = db.Query<TestObj>("select * from TestObj").ToList(); Assert.AreEqual(2, result.Count); Assert.AreEqual(obj1.Text, result[0].Text); Assert.AreEqual(obj2.Text, result[1].Text); db.Close(); }
public void InsertIntoTwoTables() { var db = new OrmTestSession(); db.CreateTable<TestObj>(); db.CreateTable<TestObj2>(); var obj1 = new TestObj { Text = "GLaDOS loves testing!" }; var obj2 = new TestObj2 { Text = "Keep testing, just keep testing" }; int numIn1 = db.Insert(obj1); Assert.AreEqual(1, numIn1); int numIn2 = db.Insert(obj2); Assert.AreEqual(1, numIn2); List<TestObj> result1 = db.Table<TestObj>().ToList(); Assert.AreEqual(numIn1, result1.Count); Assert.AreEqual(obj1.Text, result1.First().Text); List<TestObj> result2 = db.Query<TestObj>("select * from TestObj2").ToList(); Assert.AreEqual(numIn2, result2.Count); db.Close(); }