Пример #1
0
        private static void VerifyCreations(TestDb db)
        {
            var orderLine = db.GetMapping(typeof(OrderLine));
            Assert.AreEqual(6, orderLine.Columns.Length);

            var l = new OrderLine()
            {
                Status = OrderLineStatus.Shipped
            };
            db.Insert(l);
            var lo = db.Table<OrderLine>().First(x => x.Status == OrderLineStatus.Shipped);
            Assert.AreEqual(lo.Id, l.Id);
        }
Пример #2
0
        public void CreateThem()
        {
            var db = new TestDb ();

            db.CreateTable<Product> ();
            db.CreateTable<Order> ();
            db.CreateTable<OrderLine> ();
            db.CreateTable<OrderHistory> ();

            var orderLine = db.GetMapping(typeof(OrderLine));
            Assert.AreEqual(6, orderLine.Columns.Length, "Order history has 3 columns");

            var l = new OrderLine() {
                Status = OrderLineStatus.Shipped
            };
            db.Insert(l);
            var lo = db.Table<OrderLine>().Where(x => x.Status == CreateTableTest.OrderLineStatus.Shipped).FirstOrDefault();
            Assert.AreEqual(lo.Id, l.Id);
        }
Пример #3
0
        public void TenThousandRecords()
        {
            using (var db = new TestDb()) {

                db.Trace = false;
                //db.Execute("PRAGMA journal_mode = MEMORY", new object[] { });
                //sqlite3_exec(db, "PRAGMA synchronous = OFF", NULL, NULL, &sErrMsg);
                //sqlite3_exec(db, "PRAGMA journal_mode = MEMORY", NULL, NULL, &sErrMsg);
                db.Execute("PRAGMA synchronous = OFF", new object[] { });
                db.Execute("PRAGMA journal_mode = MEMORY", new object[] { });

                db.CreateTable<OrderLine>();

                var st = DateTime.Now;

                int doFor = 1; //was 15

                //for (int i = 0; i < 1000; i++) {
                //    var l = new OrderLine() {
                //        Status = OrderLineStatus.Shipped
                //    };
                //    db.Insert(l);
                //}

                //var end = DateTime.Now.Subtract(st).TotalMilliseconds;

                //st = DateTime.Now;

                for (int times = 0; times < doFor; times++) {
                    db.BeginTransaction();

                    //for (int i = 0; i < 20000; i++) {
                    //    var l = new OrderLine() {
                    //        OrderId = 12,
                    //        ProductId = 14,
                    //        Quantity = 54,
                    //        UnitPrice = 12.95M
                    //    };
                    //    db.Insert(l);
                    //}

                    for (int i = 0; i < 10000; i++) {
                        var l = new OrderLine() {
                            OrderId = 12,
                            ProductId = 14,
                            Quantity = 54,
                            UnitPrice = 12.95M
                        };
                        db.Insert(l);
                    }

                    //for (int i = 0; i < 10000; i++) {
                    //    var l = new OrderLine() {
                    //        OrderId = 12 + i,
                    //        ProductId = 14 + i,
                    //        Quantity = 54 + i,
                    //        UnitPrice = (12.95M + (decimal)i)
                    //    };
                    //    db.Insert(l);
                    //}

                    db.Commit();
                }

                var end2 = DateTime.Now.Subtract(st).TotalMilliseconds;
                Console.WriteLine(end2);
            }
        }