public void BulkInsertAndSelect() { var db = new TestDb(false, new ContractResolver(t => _container.CanResolve(t), (t, op) => _container.Resolve(t))); db.CreateTable <IProduct>(); db.CreateTable <IOrder>(); db.CreateTable <IOrderLine>(); db.CreateTable <IOrderHistory>(); var rnd = new Random(); var data = new List <IOrderLine>(); for (var i = 0; i < 100; i++) { var l = _container.Resolve <IOrderLine>(); l.OrderId = rnd.Next(1, 100); l.ProductId = rnd.Next(1, 100); l.Quantity = rnd.Next(1, 25); l.Status = OrderLineStatus.Shipped; l.UnitPrice = rnd.Next(0, 100); data.Add(l); } db.InsertAll(data.ToArray()); var results = db.Table <IOrderLine>(); Assert.AreEqual(data.Count, results.Count()); Assert.AreEqual(data.First().UnitPrice, results.First().UnitPrice); Assert.AreEqual(data.Last().UnitPrice, results.Last().UnitPrice); }
public void Setup() { testObjects = Enumerable.Range(1, 20).Select(i => new TestObj()).ToList(); db = new TestDb(TestPath.CreateTemporaryDatabase()); db.InsertAll(testObjects); }
private SQLiteConnection CreateDb() { var db = new TestDb(); db.CreateTable <TestTable>(); IEnumerable <TestTable> items = from i in Enumerable.Range(0, Count) select new TestTable { Two = 2 }; db.InsertAll(items); Assert.AreEqual(Count, db.Table <TestTable>().Count()); return(db); }
private static TestDb GetTestDBWith100Elements() { int n = 100; IEnumerable <TestObj> cq = from i in Enumerable.Range(1, n) select new TestObj { Order = i }; TestObj[] objs = cq.ToArray(); var db = new TestDb(TestPath.CreateTemporaryDatabase()); int numIn = db.InsertAll(objs); Assert.AreEqual(numIn, n, "Num inserted must = num objects"); return(db); }
public void AddForStringsMeansConcatenate() { int n = 20; IEnumerable <TestObjString> cq = from i in Enumerable.Range(1, n) select new TestObjString() { Data = i.ToString(), }; var db = new TestDb(TestPath.CreateTemporaryDatabase()); db.InsertAll(cq); TableQuery <TestObjString> results = db.Table <TestObjString>().Where(o => o.Data + "1" == "11"); Assert.AreEqual(1, results.Count()); Assert.AreEqual("1", results.OrderBy(o => o.Data).FirstOrDefault().Data); }
public void CanHaveSubtractInWhereClause() { int n = 20; IEnumerable <TestObjInt> cq = from i in Enumerable.Range(1, n) select new TestObjInt() { Data = i, }; var db = new TestDb(TestPath.CreateTemporaryDatabase()); db.InsertAll(cq); TableQuery <TestObjInt> results = db.Table <TestObjInt>().Where(o => o.Data - 10 >= 0); Assert.AreEqual(results.Count(), 11); Assert.AreEqual(results.OrderBy(o => o.Data).FirstOrDefault().Data, 10); }
public void Issue115_MissingPrimaryKey() { using (var conn = new TestDb()) { conn.CreateTable <Issue115_MyObject>(); conn.InsertAll(from i in Enumerable.Range(0, 10) select new Issue115_MyObject { UniqueId = i.ToString(), OtherValue = (byte)(i * 10), }); TableQuery <Issue115_MyObject> query = conn.Table <Issue115_MyObject>(); foreach (Issue115_MyObject itm in query) { itm.OtherValue++; Assert.AreEqual(1, conn.Update(itm, typeof(Issue115_MyObject))); } } }
public void SetUp() { db = new TestDb(); db.CreateTable <Product>(); var prods = new[] { new Product { Name = "Foo" }, new Product { Name = "Bar" }, new Product { Name = "Foobar" } }; db.InsertAll(prods); }
public void ReplaceInWhere() { string testElement = "Element"; string alternateElement = "Alternate"; string replacedElement = "ReplacedElement"; int n = 20; IEnumerable <TestObj> cq = from i in Enumerable.Range(1, n) select new TestObj { Name = (i % 2 == 0) ? testElement : alternateElement }; var db = new TestDb(TestPath.CreateTemporaryDatabase()); db.InsertAll(cq); db.TraceListener = DebugTraceListener.Instance; List <TestObj> result = (from o in db.Table <TestObj>() where o.Name.Replace(testElement, replacedElement) == replacedElement select o).ToList(); Assert.AreEqual(10, result.Count); }