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