public void Test1()
{
NullableTable o = NullableTable.FindById(1);
Assert.IsNotNull(o);
Assert.AreEqual(1, o.Id);
Assert.AreEqual("tom", o.Name);
Assert.IsTrue(null == o.MyInt);
Assert.IsTrue(true == o.MyBool);
}
public void Test3()
{
NullableTable o = NullableTable.FindById(3);
Assert.IsNotNull(o);
Assert.AreEqual(3, o.Id);
Assert.AreEqual(null, o.Name);
Assert.IsTrue(null == o.MyInt);
Assert.IsTrue(null == o.MyBool);
}
public void Test2()
{
NullableTable o = NullableTable.FindById(2);
Assert.IsNotNull(o);
Assert.AreEqual(2, o.Id);
Assert.AreEqual(null, o.Name);
Assert.IsTrue(1 == o.MyInt);
Assert.IsTrue(false == o.MyBool);
}
public void TestCrud()
{
var o = new NullableTable {
Name = null, MyInt = null, MyBool = null
};
o.Save();
NullableTable o1 = NullableTable.FindById(o.Id);
Assert.AreEqual(null, o1.Name);
Assert.IsTrue(null == o1.MyInt);
Assert.IsTrue(null == o1.MyBool);
o1.Name = "jerry";
o1.MyInt = 11;
o1.Save();
NullableTable o2 = NullableTable.FindById(o.Id);
Assert.AreEqual("jerry", o2.Name);
Assert.IsTrue(11 == o2.MyInt);
Assert.IsTrue(null == o2.MyBool);
o2.MyInt = 18;
o2.MyBool = true;
o2.Save();
NullableTable o3 = NullableTable.FindById(o.Id);
Assert.AreEqual("jerry", o3.Name);
Assert.IsTrue(18 == o3.MyInt);
Assert.IsTrue(true == o3.MyBool);
o3.Name = null;
o3.MyInt = null;
o3.MyBool = null;
o3.Save();
NullableTable o4 = NullableTable.FindById(o.Id);
Assert.AreEqual(null, o4.Name);
Assert.IsTrue(null == o4.MyInt);
Assert.IsTrue(null == o4.MyBool);
o4.Delete();
NullableTable o5 = NullableTable.FindById(o.Id);
Assert.IsNull(o5);
}
public void TestEmptyString()
{
var o = new NullableTable {
Name = ""
};
o.Save();
var o1 = NullableTable.FindById(o.Id);
Assert.IsNotNull(o1);
Assert.IsNotNull(o1.Name);
Assert.AreEqual("", o1.Name);
}
public void Test3WithSql()
{
List <NullableTable> ls = DbEntry.ExecuteList <NullableTable>(
"select * from NullTest where Id = 3");
Assert.AreEqual(1, ls.Count);
NullableTable o = ls[0];
Assert.IsNotNull(o);
Assert.AreEqual(3, o.Id);
Assert.AreEqual(null, o.Name);
Assert.IsTrue(null == o.MyInt);
Assert.IsTrue(null == o.MyBool);
}
