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