public void InsertIntoTwoTables()
{
var obj1 = new TestObj()
{
Text = "GLaDOS loves testing!"
};
var obj2 = new TestObj2()
{
Text = "Keep testing, just keep testing"
};
var numIn1 = _db.Insert(obj1);
Assert.AreEqual(1, numIn1);
var numIn2 = _db.Insert(obj2);
Assert.AreEqual(1, numIn2);
var result1 = _db.Query <TestObj>("select * from TestObj").ToList();
Assert.AreEqual(numIn1, result1.Count);
Assert.AreEqual(obj1.Text, result1.First().Text);
var result2 = _db.Query <TestObj>("select * from TestObj2").ToList();
Assert.AreEqual(numIn2, result2.Count);
}
public void InsertOrIgnore()
{
_db.TraceListener = DebugTraceListener.Instance;
_db.InsertOrIgnoreAll(from i in Enumerable.Range(1, 20)
select new TestObj2
{
Id = i,
Text = "#" + i
});
Assert.AreEqual(20, _db.Table <TestObj2>().Count());
var t = new TestObj2
{
Id = 5,
Text = "Foo",
};
_db.InsertOrIgnore(t);
List <TestObj2> r = (from x in _db.Table <TestObj2>() orderby x.Id select x).ToList();
Assert.AreEqual(20, r.Count);
Assert.AreEqual("#5", r[4].Text);
}
public void InsertWithExtra()
{
var db = new OrmTestSession();
db.CreateTable <TestObj2>();
var obj1 = new TestObj2 {
Id = 1, Text = "GLaDOS loves testing!"
};
var obj2 = new TestObj2 {
Id = 1, Text = "Keep testing, just keep testing"
};
var obj3 = new TestObj2 {
Id = 1, Text = "Done testing"
};
db.Insert(obj1);
// "Expected unique constraint violation"
ExceptionAssert.Throws <SqliteException>(() => db.Insert(obj2));
db.Insert(obj2, ConflictResolution.Replace);
// "Expected unique constraint violation"
ExceptionAssert.Throws <SqliteException>(() => db.Insert(obj3));
db.Insert(obj3, ConflictResolution.Ignore);
List <TestObj> result = db.Query <TestObj>("select * from TestObj2").ToList();
Assert.AreEqual(1, result.Count);
Assert.AreEqual(obj2.Text, result.First().Text);
db.Close();
}
public void InsertIntoTwoTables()
{
var db = new OrmTestSession();
db.CreateTable <TestObj>();
db.CreateTable <TestObj2>();
var obj1 = new TestObj {
Text = "GLaDOS loves testing!"
};
var obj2 = new TestObj2 {
Text = "Keep testing, just keep testing"
};
int numIn1 = db.Insert(obj1);
Assert.AreEqual(1, numIn1);
int numIn2 = db.Insert(obj2);
Assert.AreEqual(1, numIn2);
List <TestObj> result1 = db.Table <TestObj>().ToList();
Assert.AreEqual(numIn1, result1.Count);
Assert.AreEqual(obj1.Text, result1.First().Text);
List <TestObj> result2 = db.Query <TestObj>("select * from TestObj2").ToList();
Assert.AreEqual(numIn2, result2.Count);
db.Close();
}
public void InsertObjectWithValueInPrimaryKey()
{
var db = new OrmTestSession();
db.CreateTable <TestObj2>();
var obj2 = new TestObj2 {
Id = 5, Text = "Old"
};
int numIn1 = db.Insert(obj2);
Assert.AreEqual(1, numIn1);
var result = db.Table <TestObj2>().Single(i => i.Id == 5);
Assert.AreEqual("Old", result.Text);
result.Text = "New";
var upd = db.Update(result);
result = db.Table <TestObj2>().Single(i => i.Id == 5);
Assert.AreEqual("New", result.Text);
db.Close();
}
public void Test2()
{
var obj2 = new TestObj2();
Assert.AreEqual(false, obj2.Method1Raised);
Assert.AreEqual(false, obj2.Method2Raised);
obj2.Test1 = DateTimeOffset.Now;
Assert.AreEqual(true, obj2.Method1Raised);
Assert.AreEqual(false, obj2.Method2Raised);
}
public void ShouldBuildToStringFromFields()
{
// given
var obj = new TestObj2(age: 30, surname: "Testowski", data: Lists.AsList("A", "B", "C"));
// when
var toString = ToStringHelper.Of(obj)
.AddFields()
.ToString();
// then
Check.That(toString).IsEqualTo("TestObj2 {age:30, surname:Testowski, data:[A, B, C]}");
}
public void ShouldBuildToStringFromFieldsWithoutNulls()
{
// given
var obj = new TestObj2(age: 30, surname: null, data: null);
// when
var toString = ToStringHelper.Of(obj)
.AddFields()
.SkipNulls()
.ToString();
// then
Check.That(toString).IsEqualTo("TestObj2 {age:30}");
}
public void InsertWithExtra()
{
var obj1 = new TestObj2
{
Id = 1,
Text = "GLaDOS loves testing!"
};
var obj2 = new TestObj2
{
Id = 1,
Text = "Keep testing, just keep testing"
};
var obj3 = new TestObj2
{
Id = 1,
Text = "Done testing"
};
_db.Insert(obj1);
try
{
_db.Insert(obj2);
Assert.Fail("Expected unique constraint violation");
}
catch (SQLiteException)
{
}
_db.Insert(obj2, "OR REPLACE");
try
{
_db.Insert(obj3);
Assert.Fail("Expected unique constraint violation");
}
catch (SQLiteException)
{
}
_db.Insert(obj3, "OR IGNORE");
List <TestObj> result = _db.Query <TestObj>("select * from TestObj2").ToList();
Assert.AreEqual(1, result.Count);
Assert.AreEqual(obj2.Text, result.First().Text);
}
public void InsertIntoTwoTables()
{
var obj1 = new TestObj() { Text = "GLaDOS loves testing!" };
var obj2 = new TestObj2() { Text = "Keep testing, just keep testing" };
var numIn1 = _db.Insert(obj1);
Assert.AreEqual(1, numIn1);
var numIn2 = _db.Insert(obj2);
Assert.AreEqual(1, numIn2);
var result1 = _db.Query<TestObj>("select * from TestObj").ToList();
Assert.AreEqual(numIn1, result1.Count);
Assert.AreEqual(obj1.Text, result1.First().Text);
var result2 = _db.Query<TestObj>("select * from TestObj2").ToList();
Assert.AreEqual(numIn2, result2.Count);
}
public void InsertWithExtra()
{
var obj1 = new TestObj2() { Id=1, Text = "GLaDOS loves testing!" };
var obj2 = new TestObj2() { Id=1, Text = "Keep testing, just keep testing" };
var obj3 = new TestObj2() { Id=1, Text = "Done testing" };
_db.Insert(obj1);
try {
_db.Insert(obj2);
Assert.Fail("Expected unique constraint violation");
}
catch (SQLiteException) {
}
_db.Insert(obj2, "OR REPLACE");
try {
_db.Insert(obj3);
Assert.Fail("Expected unique constraint violation");
}
catch (SQLiteException) {
}
_db.Insert(obj3, "OR IGNORE");
var result = _db.Query<TestObj>("select * from TestObj2").ToList();
Assert.AreEqual(1, result.Count);
Assert.AreEqual(obj2.Text, result.First().Text);
}
public void InsertWithExtra()
{
var db = new OrmTestSession();
db.CreateTable<TestObj2>();
var obj1 = new TestObj2 { Id = 1, Text = "GLaDOS loves testing!" };
var obj2 = new TestObj2 { Id = 1, Text = "Keep testing, just keep testing" };
var obj3 = new TestObj2 { Id = 1, Text = "Done testing" };
db.Insert(obj1);
// "Expected unique constraint violation"
ExceptionAssert.Throws<SqliteException>(() => db.Insert(obj2));
db.Insert(obj2, ConflictResolution.Replace);
// "Expected unique constraint violation"
ExceptionAssert.Throws<SqliteException>(() => db.Insert(obj3));
db.Insert(obj3, ConflictResolution.Ignore);
List<TestObj> result = db.Query<TestObj>("select * from TestObj2").ToList();
Assert.AreEqual(1, result.Count);
Assert.AreEqual(obj2.Text, result.First().Text);
db.Close();
}
public void InsertIntoTwoTables()
{
var db = new OrmTestSession();
db.CreateTable<TestObj>();
db.CreateTable<TestObj2>();
var obj1 = new TestObj { Text = "GLaDOS loves testing!" };
var obj2 = new TestObj2 { Text = "Keep testing, just keep testing" };
int numIn1 = db.Insert(obj1);
Assert.AreEqual(1, numIn1);
int numIn2 = db.Insert(obj2);
Assert.AreEqual(1, numIn2);
List<TestObj> result1 = db.Table<TestObj>().ToList();
Assert.AreEqual(numIn1, result1.Count);
Assert.AreEqual(obj1.Text, result1.First().Text);
List<TestObj> result2 = db.Query<TestObj>("select * from TestObj2").ToList();
Assert.AreEqual(numIn2, result2.Count);
db.Close();
}
public void InsertObjectWithValueInPrimaryKey()
{
var db = new OrmTestSession();
db.CreateTable<TestObj2>();
var obj2 = new TestObj2 {Id = 5, Text = "Old"};
int numIn1 = db.Insert(obj2);
Assert.AreEqual(1, numIn1);
var result = db.Table<TestObj2>().Single(i => i.Id == 5);
Assert.AreEqual("Old", result.Text);
result.Text = "New";
var upd = db.Update(result);
result = db.Table<TestObj2>().Single(i => i.Id == 5);
Assert.AreEqual("New", result.Text);
db.Close();
}
public void InsertOrIgnore()
{
_db.TraceListener = DebugTraceListener.Instance;
_db.InsertOrIgnoreAll(from i in Enumerable.Range(1, 20)
select new TestObj2
{
Id = i,
Text = "#" + i
});
Assert.AreEqual(20, _db.Table<TestObj2>().Count());
var t = new TestObj2
{
Id = 5,
Text = "Foo",
};
_db.InsertOrIgnore(t);
List<TestObj2> r = (from x in _db.Table<TestObj2>() orderby x.Id select x).ToList();
Assert.AreEqual(20, r.Count);
Assert.AreEqual("#5", r[4].Text);
}
public void Test2()
{
var obj2 = new TestObj2();
Assert.AreEqual(false, obj2.Method1Raised);
Assert.AreEqual(false, obj2.Method2Raised);
obj2.Test1 = DateTimeOffset.Now;
Assert.AreEqual(true, obj2.Method1Raised);
Assert.AreEqual(false, obj2.Method2Raised);
}
