public void FindById_ContextCache()
{
ConsoleTitleUtil.ShowTestTitle("FindById_ContextCache");
//复杂关联find
TArticle art = TArticle.findById(1);
Console.WriteLine("article 1 title is : " + art.Title);
Assert.AreEqual("狂人日记", art.Title);
//一级缓存
TMember member = TMember.findById(13);
Console.WriteLine("member 13 name is : " + member.Name);
Assert.AreEqual("袁世凯", member.Name);
TCat cat = TCat.findById(8);
Console.WriteLine("cat 8 name is " + cat.Name);
Assert.AreEqual("武侠小说", cat.Name);
TBoard board = TBoard.findById(9);
Console.WriteLine("board 9 name is : " + board.Name);
Assert.AreEqual("board_互联网络", board.Name);
}
public void FindCondition_WithEqual()
{
TArticle art = new TArticle();
art.Member = TMember.findById(8);
art.Cat = TCat.findById(7);
art.Board = TBoard.findById(3);
art.Author = "163羽化";
art.Title = "myurl=www.163.com";
art.CreateTime = DateTime.Now;
art.ChannelId = 4;
art.IsDelete = 0;
art.OrderId = 15;
art.insert();
IList <TArticle> articles = TArticle.find("Title=:t").set("t", art.Title).list();
Assert.AreEqual(1, articles.Count);
logger.Info("===========================================================================");
IList <TArticle> articles2 = TArticle.find("Title='" + art.Title + "'").list();
Assert.AreEqual(1, articles2.Count);
}
//------------------------- Insert -------------------------
public void InsertArticle()
{
ConsoleTitleUtil.ShowTestTitle("InsertArticle");
TArticle art = new TArticle();
art.Member = TMember.findById(13);
art.Cat = TCat.findById(8);
art.Board = TBoard.findById(9);
art.Author = "54鲁迅";
art.Title = "狂人日记";
art.CreateTime = DateTime.Now;
art.ChannelId = 18;
art.IsDelete = 0;
art.OrderId = 5;
art.insert();
int id = art.Id;
art.Member = TMember.findById(2);
art.Cat = TCat.findById(10);
art.Board = TBoard.findById(11);
art.Author = "周做人";
art.Title = "论雷锋大的倒掉";
art.CreateTime = DateTime.Now;
art.ChannelId = 12;
art.IsDelete = 0;
art.OrderId = 8;
art.insert();
id = id + 1;
Assert.AreEqual(id, art.Id);
art.Member = TMember.findById(7);
art.Cat = TCat.findById(4);
art.Board = TBoard.findById(4);
art.Author = "嵇康";
art.Title = "与善举员绝交数";
art.CreateTime = DateTime.Now;
art.ChannelId = 4;
art.IsDelete = 0;
art.OrderId = 9;
art.insert();
id = id + 1;
Assert.AreEqual(id, art.Id);
art.Member = TMember.findById(8);
art.Cat = TCat.findById(7);
art.Board = TBoard.findById(3);
art.Author = "羽化";
art.Title = "许三管买血迹";
art.CreateTime = DateTime.Now;
art.ChannelId = 4;
art.IsDelete = 0;
art.OrderId = 15;
art.insert();
id = id + 1;
Assert.AreEqual(id, art.Id);
Console.WriteLine("添加 article 成功！");
}
public void ZDelete()
{
ConsoleTitleUtil.ShowTestTitle("Delete");
int id = 2;
TBoard bd = TBoard.findById(id);
Assert.IsNotNull(bd);
Assert.AreEqual(id, bd.Id);
db.delete(bd);
TBoard myboard = TBoard.findById(id);
Assert.IsNull(myboard);
}
public void ZDeleteBatch()
{
ConsoleTitleUtil.ShowTestTitle("DeleteBatch");
int count = TBoard.count();
int intVal = 6;
String whereStr = "Id>=" + intVal;
int wcount = TBoard.count(whereStr);
TBoard.deleteBatch(whereStr);
int bdCount = TBoard.count();
Assert.AreEqual((count - wcount), bdCount);
TBoard bd = TBoard.findById(intVal + intVal);
Assert.IsNull(bd);
bd = TBoard.findById(intVal + intVal);
Assert.IsNull(bd);
}