Пример #1
0
        public void TestDropTableTestClass3()
        {
            TestCreateTableTestClass3();
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.DropTable <TestClass3>();
        }
Пример #2
0
        private INLORMDb createtable()
        {
            var db = new NLORMSQLiteDb(connectionString);

            db.CreateTable <TestClassOne>();
            return(db);
        }
Пример #3
0
 public void TestDeleteTwoRecord()
 {
     var db = new NLORMSQLiteDb( connectionString);
     db.FilterBy(FilterType.EQUAL_AND, new { income = 901234}).Delete<TestClassOne>();
     var items = db.Query<TestClassOne>();
     Assert.AreEqual( 3, items.Count() );
 }
Пример #4
0
        public void TestInsertUserClassMuti()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.CreateTable <TestClassUser>();

            var insertList = new List <TestClassUser>();

            for (int i = 0; i < 30; i++)
            {
                var testObj = new TestClassUser {
                    ID         = i, Name = "Name " + i,
                    CreateTime = DateTime.Now.AddDays(i)
                };
                insertList.Add(testObj);
            }
            foreach (TestClassUser user in insertList)
            {
                sqliteDbc.Insert <TestClassUser>(user);
            }

            var selLis = sqliteDbc.Query <TestClassUser>();

            Assert.AreEqual(selLis.Count(), 30);
        }
Пример #5
0
 public void TestDeleteOneRecord()
 {
     var db = new NLORMSQLiteDb( connectionString);
     int i =  db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss"}).Delete<TestClassOne>();
     var items = db.FilterBy( FilterType.EQUAL_AND, new { Id = "sssss"}).Query<TestClassOne>();
     Assert.AreEqual( 0, items.Count() );
 }
Пример #6
0
        public void TestDeleteOneRecord()
        {
            var db    = new NLORMSQLiteDb(connectionString);
            int i     = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Delete <TestClassOne>();
            var items = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Query <TestClassOne>();

            Assert.AreEqual(0, items.Count());
        }
Пример #7
0
        public void TestSelectClass3SelectByName()
        {
            GenTestClass3TestData();
            var sqliteDbc = new NLORMSQLiteDb(connectionString);
            var result    = sqliteDbc.FilterBy(FilterType.EQUAL_AND, new { NAME = "N5555" })
                            .Query <TestClass3>();

            Assert.AreEqual(result.Count(), 2);
        }
Пример #8
0
        public void TestDeleteAllRecords()
        {
            var db = new NLORMSQLiteDb(connectionString);
            int totalcount = db.Query<TestClassOne>().Count();
            int dc = db.Delete<TestClassOne>();

            var items = db.Query<TestClassOne>();
            Assert.AreEqual(dc, totalcount);
        }
Пример #9
0
        public void TestSelectClass4SelectByAge()
        {
            GenTestClass4TestData();
            var sqliteDbc = new NLORMSQLiteDb(connectionString);
            var result    = sqliteDbc.FilterBy(FilterType.LESS_AND, new { Age = 14 })
                            .Query <TestClass4>();

            Assert.AreEqual(result.Count(), 2);
        }
Пример #10
0
        public void TestDeleteTwoRecord()
        {
            var db = new NLORMSQLiteDb(connectionString);

            db.FilterBy(FilterType.EQUAL_AND, new { income = 901234 }).Delete <TestClassOne>();
            var items = db.Query <TestClassOne>();

            Assert.AreEqual(3, items.Count());
        }
Пример #11
0
        public void TestDeleteAllRecords()
        {
            var db         = new NLORMSQLiteDb(connectionString);
            int totalcount = db.Query <TestClassOne>().Count();
            int dc         = db.Delete <TestClassOne>();

            var items = db.Query <TestClassOne>();

            Assert.AreEqual(dc, totalcount);
        }
Пример #12
0
        public void TestUpdateOneRow()
        {
            var db     = new NLORMSQLiteDb(connectionString);
            var newobj = new TestClassOne {
                Id = "sssss", income = 100
            };
            int i     = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Update <TestClassOne>(newobj);
            var items = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Query <TestClassOne>().First();

            Assert.AreEqual(100, items.income);
        }
Пример #13
0
 public void TestInitialize()
 {
     try
     {
         var db = new NLORMSQLiteDb(connectionString);
         this.createtable(db);
         this.insertdata(db);
     }
     finally
     {
     }
 }
Пример #14
0
        public void TestInitialize()
        {
            try
            {
                var db = new NLORMSQLiteDb(connectionString);
                this.createtable( db);
                this.insertdata( db);
            }
            finally
            {

            }
        }
Пример #15
0
        public void TestSelectClass1()
        {
            TestCreateTable();
            var c1 = new TestClass();

            c1.ID = "5555";
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.Insert <TestClass>(c1);
            var result = sqliteDbc.Query <TestClass>();

            Assert.AreEqual(result.Count(), 1);
        }
Пример #16
0
        public void TestUpdateOneRowUesExpando()
        {
            var db     = new NLORMSQLiteDb(connectionString);
            var newobj = new TestClassOne {
                Id = "sssss", income = 100
            };
            dynamic filterObj = new ExpandoObject();

            filterObj.Id = "sssss";
            int i     = db.FilterBy(FilterType.EQUAL_AND, filterObj).Update <TestClassOne>(newobj);
            var items = db.FilterBy(FilterType.EQUAL_AND, filterObj).Query <TestClassOne>()[0];

            Assert.AreEqual(100, items.income);
        }
Пример #17
0
        public void TestUpdateWithOrUseExpandoToUpdate()
        {
            var     db      = new NLORMSQLiteDb(connectionString);
            dynamic newobjc = new ExpandoObject();

            newobjc.income = 100;
            int i = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" })
                    .Or().FilterBy(FilterType.EQUAL_AND, new { Id = "rrrrr" })
                    .Update <TestClassOne>(newobjc);
            var items  = db.FilterBy(FilterType.EQUAL_AND, new { Id = "sssss" }).Query <TestClassOne>().First();
            var itemsr = db.FilterBy(FilterType.EQUAL_AND, new { Id = "rrrrr" }).Query <TestClassOne>().First();

            Assert.AreEqual(100, items.income);
            Assert.AreEqual(100, itemsr.income);
        }
Пример #18
0
        public void TestInsertClass2MutiData()
        {
            TestCreateTableWithoutDef();
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            for (int i = 0; i < 600; i++)
            {
                var c1 = new TestClass2();
                c1.ID = "id" + i.ToString();
                sqliteDbc.Insert <TestClass2>(c1);
            }
            var result = sqliteDbc.Query <TestClass2>("SELECT * FROM  TestClass2");

            Assert.AreEqual(result.Count(), 600);
        }
Пример #19
0
        public void TestInsertClass2()
        {
            TestCreateTableWithoutDef();
            var c1 = new TestClass2();

            c1.ID = "5555";
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.Insert <TestClass2>(c1);
            var d1 = new { a1 = 1 };

            var result = sqliteDbc.Query <TestClass2>("SELECT * FROM  TestClass2");

            Assert.AreEqual(result.Count(), 1);
        }
Пример #20
0
        private void GenTestClass3TestData()
        {
            TestCreateTableTestClass3();
            var c1 = new TestClass3();

            c1.ID   = "5555";
            c1.NAME = "N5555";
            var c2 = new TestClass3();

            c2.ID   = "5566";
            c2.NAME = "N5555";
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.Insert <TestClass3>(c1);
            sqliteDbc.Insert <TestClass3>(c2);
        }
Пример #21
0
        public void TestSelectClass1WithCons()
        {
            TestCreateTable();
            var c1 = new TestClass();

            c1.ID = "5555";
            var c2 = new TestClass();

            c2.ID = "5566";
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.Insert <TestClass>(c1);
            sqliteDbc.Insert <TestClass>(c2);
            var result = sqliteDbc.FilterBy(FilterType.EQUAL_AND, new { ID = "5555" })
                         .Query <TestClass>();

            Assert.AreEqual(result.Count(), 1);
        }
Пример #22
0
        public void TestTransactionCommit()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.CreateTable <TestClassUser>();
            var trans   = sqliteDbc.BeginTransaction();
            var testObj = new TestClassUser();

            testObj.ID         = 1;
            testObj.Name       = "Name " + 1;
            testObj.CreateTime = DateTime.Now;
            sqliteDbc.Insert <TestClassUser>(testObj);
            trans.Commit();
            sqliteDbc.Close();
            sqliteDbc = new NLORMSQLiteDb(connectionString);
            var selLis = sqliteDbc.Query <TestClassUser>();

            Assert.AreEqual(selLis.Count(), 1);
        }
Пример #23
0
        private void GenTestClass4TestData()
        {
            TestCreateTableTestClass4();
            var c1 = new TestClass4();

            c1.ID  = "5555";
            c1.Age = 13;
            var c2 = new TestClass4();

            c2.ID  = "5566";
            c2.Age = 12;
            var c3 = new TestClass4();

            c3.ID  = "1234";
            c3.Age = 15;
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.Insert <TestClass4>(c1);
            sqliteDbc.Insert <TestClass4>(c2);
            sqliteDbc.Insert <TestClass4>(c3);
        }
Пример #24
0
        public void TestInsertUserClass()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.CreateTable <TestClassUser>();

            var testObj = new TestClassUser();

            testObj.ID         = 1;
            testObj.Name       = "Name " + 1;
            testObj.CreateTime = DateTime.Now;

            sqliteDbc.Insert <TestClassUser>(testObj);
            var selLis = sqliteDbc.Query <TestClassUser>();

            Assert.AreEqual(selLis.Count(), 1);
            var selUser = selLis.ToArray()[0];

            Assert.AreEqual(testObj.ID, selUser.ID);
            Assert.AreEqual(testObj.Name, selUser.Name);
            Assert.AreEqual(testObj.CreateTime, selUser.CreateTime);
        }
Пример #25
0
        public void TestUpdateWithOrUesExpando()
        {
            var db     = new NLORMSQLiteDb(connectionString);
            var newobj = new TestClassOne {
                income = 100
            };

            dynamic filterObjA = new ExpandoObject();
            dynamic filterObjB = new ExpandoObject();

            filterObjA.Id = "sssss";
            filterObjB.Id = "rrrrr";

            int i = db.FilterBy(FilterType.EQUAL_AND, filterObjA)
                    .Or().FilterBy(FilterType.EQUAL_AND, filterObjB)
                    .Update <TestClassOne>(new { income = 100 });
            var items  = db.FilterBy(FilterType.EQUAL_AND, filterObjA).Query <TestClassOne>()[0];
            var itemsr = db.FilterBy(FilterType.EQUAL_AND, filterObjB).Query <TestClassOne>()[0];

            Assert.AreEqual(100, items.income);
            Assert.AreEqual(100, itemsr.income);
        }
Пример #26
0
        public void TestInsertUserClass()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);
            sqliteDbc.CreateTable<TestClassUser>();

            var testObj = new TestClassUser();
            testObj.ID = 1;
            testObj.Name = "Name " + 1;
            testObj.CreateTime = DateTime.Now;

            sqliteDbc.Insert<TestClassUser>(testObj);
            var selLis = sqliteDbc.Query<TestClassUser>();
            Assert.AreEqual(selLis.Count(),1);
            var selUser = selLis.ToArray()[0];
            Assert.AreEqual(testObj.ID,selUser.ID);
            Assert.AreEqual(testObj.Name,selUser.Name);
            Assert.AreEqual(testObj.CreateTime,selUser.CreateTime);
        }
Пример #27
0
        public void TestInsertUserClassMuti()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);
            sqliteDbc.CreateTable<TestClassUser>();

            var insertList = new List<TestClassUser>();

            for (int i = 0; i < 30; i++)
            {
                var testObj = new TestClassUser {ID = i, Name = "Name " + i,
                    CreateTime = DateTime.Now.AddDays(i)};
                insertList.Add(testObj);
            }
            foreach (TestClassUser user in insertList)
            {
                sqliteDbc.Insert<TestClassUser>(user);
            }

            var selLis = sqliteDbc.Query<TestClassUser>();
            Assert.AreEqual(selLis.Count(), 30);
        }
Пример #28
0
        public void TestCreateTableOnlyStringWithCfd()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.CreateTable <TestClassOnlyStringWCfd>();
        }
Пример #29
0
        public void TestCreateTableOnlyTinyint()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.CreateTable <TestClassOnlyTinyint>();
        }
Пример #30
0
        public void TestCreateTableOnlyInt64()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.CreateTable <TestclassOnlyInt64>();
        }
Пример #31
0
        public void TestCreateTableWithoutDef()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.CreateTable <TestClass2>();
        }
Пример #32
0
        public void TestCreateTableTestClass4()
        {
            var sqliteDbc = new NLORMSQLiteDb(connectionString);

            sqliteDbc.CreateTable <TestClass4>();
        }
Пример #33
0
 public void TestTransactionRollback()
 {
     var sqliteDbc = new NLORMSQLiteDb(connectionString);
     sqliteDbc.CreateTable<TestClassUser>();
     var trans = sqliteDbc.BeginTransaction();
     var testObj = new TestClassUser();
     testObj.ID = 1;
     testObj.Name = "Name " + 1;
     testObj.CreateTime = DateTime.Now;
     sqliteDbc.Insert<TestClassUser>(testObj);
     trans.Rollback();
     sqliteDbc.Close();
     sqliteDbc = new NLORMSQLiteDb(connectionString);
     var selLis = sqliteDbc.Query<TestClassUser>();
     Assert.AreEqual(selLis.Count(), 0);
 }
Пример #34
0
 public void TestCreateTableOnlyFloatWcfd()
 {
     var sqliteDbc = new NLORMSQLiteDb( connectionString);
     sqliteDbc.CreateTable<TestClassOnlyFloatWcfd>();
 }
Пример #35
0
 public void TestCreateTableOnlyDateTime()
 {
     var sqliteDbc = new NLORMSQLiteDb(connectionString);
     sqliteDbc.CreateTable<TestClassOnlyDateTime>();
 }
Пример #36
0
 public void TestCreateTableOnlyInt64()
 {
     var sqliteDbc = new NLORMSQLiteDb( connectionString);
     sqliteDbc.CreateTable<TestclassOnlyInt64>();
 }