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 UpdateCat() { ConsoleTitleUtil.ShowTestTitle("UpdateCat"); TCat cat = TCat.findById(10); Console.WriteLine("\n读取 TCat{{Id:{0},Name:{1}}} code:{2} \n", cat.Id, cat.Name, cat.GetHashCode()); Assert.AreEqual("国内新闻10", cat.Name); cat.Name = "糊播新闻10"; db.update(cat); Console.WriteLine("\n更新 TCat{{Id:{0},Name:{1}}} code:{2} \n", cat.Id, cat.Name, cat.GetHashCode()); cat = TCat.findById(10); Console.WriteLine("\n重新读取 TCat{{Id:{0},Name:{1}}} code:{2} \n", cat.Id, cat.Name, cat.GetHashCode()); Assert.AreEqual("糊播新闻10", cat.Name); // Id 不可以修改 //------------------------------------------------ cat.Id = 101; cat.update(); TCat newCat = TCat.findById(101); Assert.IsNull(newCat); }
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 GetCat() { ConsoleTitleUtil.ShowTestTitle("GetCat"); TCat cat = TCat.findById(20); Assert.AreEqual("国际新闻20", cat.Name); Console.WriteLine("\n读取 TCat{{Id:{0},Name:{1}}} code:{2} \n", cat.Id, cat.Name, cat.GetHashCode()); }
public void DeleteCat() { ConsoleTitleUtil.ShowTestTitle("DeleteCat"); int retval = TCat.delete(30); Assert.AreEqual(1, retval); // 删除了一条记录 Console.WriteLine("\n删除 {0} 条记录 \n", retval); TCat mycat = TCat.findById(30); Assert.IsNull(mycat); }
public void UpdateACat() { ConsoleTitleUtil.ShowTestTitle("UpdateCat"); TCat cat = TCat.findById(2); Assert.AreEqual("国际新闻", cat.Name); cat.Name = "这里不是新闻"; cat.update(); TCat newcat = TCat.findById(cat.Id); Assert.AreEqual("这里不是新闻", newcat.Name); }
public void FindById_Simply() { ConsoleTitleUtil.ShowTestTitle("FindById_Simply"); //简易find TCat cat = TCat.findById(3); Console.WriteLine("cat name is : " + cat.Name); Assert.AreEqual("娱乐电影", cat.Name); TCat nullCat = TCat.findById(99999999); Assert.IsNull(nullCat); }