public void TestDropTableTestClass3() { TestCreateTableTestClass3(); var sqliteDbc = new NLORMSQLiteDb(connectionString); sqliteDbc.DropTable <TestClass3>(); }
private INLORMDb createtable() { var db = new NLORMSQLiteDb(connectionString); db.CreateTable <TestClassOne>(); return(db); }
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() ); }
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); }
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() ); }
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()); }
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); }
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); }
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); }
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()); }
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); }
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); }
public void TestInitialize() { try { var db = new NLORMSQLiteDb(connectionString); this.createtable(db); this.insertdata(db); } finally { } }
public void TestInitialize() { try { var db = new NLORMSQLiteDb(connectionString); this.createtable( db); this.insertdata( db); } finally { } }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
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); }
public void TestCreateTableOnlyStringWithCfd() { var sqliteDbc = new NLORMSQLiteDb(connectionString); sqliteDbc.CreateTable <TestClassOnlyStringWCfd>(); }
public void TestCreateTableOnlyTinyint() { var sqliteDbc = new NLORMSQLiteDb(connectionString); sqliteDbc.CreateTable <TestClassOnlyTinyint>(); }
public void TestCreateTableOnlyInt64() { var sqliteDbc = new NLORMSQLiteDb(connectionString); sqliteDbc.CreateTable <TestclassOnlyInt64>(); }
public void TestCreateTableWithoutDef() { var sqliteDbc = new NLORMSQLiteDb(connectionString); sqliteDbc.CreateTable <TestClass2>(); }
public void TestCreateTableTestClass4() { var sqliteDbc = new NLORMSQLiteDb(connectionString); sqliteDbc.CreateTable <TestClass4>(); }
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); }
public void TestCreateTableOnlyFloatWcfd() { var sqliteDbc = new NLORMSQLiteDb( connectionString); sqliteDbc.CreateTable<TestClassOnlyFloatWcfd>(); }
public void TestCreateTableOnlyDateTime() { var sqliteDbc = new NLORMSQLiteDb(connectionString); sqliteDbc.CreateTable<TestClassOnlyDateTime>(); }
public void TestCreateTableOnlyInt64() { var sqliteDbc = new NLORMSQLiteDb( connectionString); sqliteDbc.CreateTable<TestclassOnlyInt64>(); }