public void InsertALot() { var db = new OrmTestSession(); SqliteSession.Trace = false; db.CreateTable <TestObj>(); const int n = 10000; IEnumerable <TestObj> q = Enumerable.Range(1, n).Select(i => new TestObj { Text = "I am" }); TestObj[] objs = q.ToArray(); int numIn = db.InsertAll(objs); Assert.AreEqual(numIn, n, "Num inserted must = num objects"); TestObj[] inObjs = db.Table <TestObj>().ToArray(); for (int i = 0; i < inObjs.Length; i++) { Assert.AreEqual(i + 1, objs[i].Id); Assert.AreEqual(i + 1, inObjs[i].Id); Assert.AreEqual("I am", inObjs[i].Text); } int numCount = db.Table <TestObj>().Count(); Assert.AreEqual(numCount, n, "Num counted must = num objects"); db.Close(); }
public void InsertALotPlain() { var db = new OrmTestSession(); SqliteSession.Trace = false; db.CreateTable <TestObjPlain>(); const int n = 10000; IEnumerable <TestObjPlain> q = Enumerable.Range(1, n).Select(i => new TestObjPlain { Text = "I am" }); TestObjPlain[] objs = q.ToArray(); int numIn = db.InsertAll(objs); Assert.AreEqual(numIn, n, "Num inserted must = num objects"); TestObjPlain[] inObjs = db.Table <TestObjPlain>().ToArray(); foreach (TestObjPlain t in inObjs) { Assert.AreEqual("I am", t.Text); } int numCount = db.Table <TestObjPlain>().Count(); Assert.AreEqual(numCount, n, "Num counted must = num objects"); 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 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 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 InsertObjectWithValueInPrimaryKey() { var db = new OrmTestSession(); db.CreateTable <TestObj2>(); var obj2 = new TestObj2 { Id = 5, Text = "Old" }; int numIn1 = db.Insert(obj2); Assert.AreEqual(1, numIn1); var result = db.Table <TestObj2>().Single(i => i.Id == 5); Assert.AreEqual("Old", result.Text); result.Text = "New"; var upd = db.Update(result); result = db.Table <TestObj2>().Single(i => i.Id == 5); Assert.AreEqual("New", result.Text); db.Close(); }
public void InterfaceTest() { var db = new OrmTestSession(); db.CreateTable<Product>(); var obj1 = new Product { Name = "Some Cool Name" }; int numIn1 = db.Insert(obj1); Assert.AreEqual(1, numIn1); db.Close(); }
public void InterfaceTest() { var db = new OrmTestSession(); db.CreateTable <Product>(); var obj1 = new Product { Name = "Some Cool Name" }; int numIn1 = db.Insert(obj1); Assert.AreEqual(1, numIn1); db.Close(); }
public void InsertGuid() { var db = new OrmTestSession(); db.CreateTable <TestObjDateTime>(); var obj2 = new TestObjDateTime { Guid = Guid.NewGuid() }; int numIn1 = db.Insert(obj2); Assert.AreEqual(1, numIn1); TestObjDateTime result = db.Table <TestObjDateTime>().First(i => i.Id == obj2.Id); Assert.AreEqual(obj2.Guid, result.Guid); db.Close(); }
public void InsertDateTime() { var db = new OrmTestSession(); db.CreateTable <TestObjDateTime>(); DateTime date = DateTime.Now; var obj1 = new TestObjDateTime { TheDate = date }; int numIn1 = db.Insert(obj1); Assert.AreEqual(1, numIn1); TestObjDateTime result = db.Table <TestObjDateTime>().First(); Assert.AreEqual(date, result.TheDate); Assert.AreEqual(obj1.TheDate, result.TheDate); db.Close(); }
public void InsertALotPlain() { var db = new OrmTestSession(); SqliteSession.Trace = false; db.CreateTable<TestObjPlain>(); const int n = 10000; IEnumerable<TestObjPlain> q = Enumerable.Range(1, n).Select(i => new TestObjPlain { Text = "I am" }); TestObjPlain[] objs = q.ToArray(); int numIn = db.InsertAll(objs); Assert.AreEqual(numIn, n, "Num inserted must = num objects"); TestObjPlain[] inObjs = db.Table<TestObjPlain>().ToArray(); foreach (TestObjPlain t in inObjs) { Assert.AreEqual("I am", t.Text); } int numCount = db.Table<TestObjPlain>().Count(); Assert.AreEqual(numCount, n, "Num counted must = num objects"); db.Close(); }
public void InsertALot() { var db = new OrmTestSession(); SqliteSession.Trace = false; db.CreateTable<TestObj>(); const int n = 10000; IEnumerable<TestObj> q = Enumerable.Range(1, n).Select(i => new TestObj { Text = "I am" }); TestObj[] objs = q.ToArray(); int numIn = db.InsertAll(objs); Assert.AreEqual(numIn, n, "Num inserted must = num objects"); TestObj[] inObjs = db.Table<TestObj>().ToArray(); for (int i = 0; i < inObjs.Length; i++) { Assert.AreEqual(i + 1, objs[i].Id); Assert.AreEqual(i + 1, inObjs[i].Id); Assert.AreEqual("I am", inObjs[i].Text); } int numCount = db.Table<TestObj>().Count(); Assert.AreEqual(numCount, n, "Num counted must = num objects"); db.Close(); }
public void InsertDateTime() { var db = new OrmTestSession(); db.CreateTable<TestObjDateTime>(); DateTime date = DateTime.Now; var obj1 = new TestObjDateTime { TheDate = date }; int numIn1 = db.Insert(obj1); Assert.AreEqual(1, numIn1); TestObjDateTime result = db.Table<TestObjDateTime>().First(); Assert.AreEqual(date, result.TheDate); Assert.AreEqual(obj1.TheDate, result.TheDate); db.Close(); }
public void InsertGuid() { var db = new OrmTestSession(); db.CreateTable<TestObjDateTime>(); var obj2 = new TestObjDateTime { Guid = Guid.NewGuid() }; int numIn1 = db.Insert(obj2); Assert.AreEqual(1, numIn1); TestObjDateTime result = db.Table<TestObjDateTime>().First(i => i.Id == obj2.Id); Assert.AreEqual(obj2.Guid, result.Guid); db.Close(); }
public void InsertObjectWithValueInPrimaryKey() { var db = new OrmTestSession(); db.CreateTable<TestObj2>(); var obj2 = new TestObj2 {Id = 5, Text = "Old"}; int numIn1 = db.Insert(obj2); Assert.AreEqual(1, numIn1); var result = db.Table<TestObj2>().Single(i => i.Id == 5); Assert.AreEqual("Old", result.Text); result.Text = "New"; var upd = db.Update(result); result = db.Table<TestObj2>().Single(i => i.Id == 5); Assert.AreEqual("New", result.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 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 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(); }