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 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 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 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 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 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 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);
}
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);
}
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 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 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);
}
