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);
}
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 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);
}
//------------------------- 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 FindCondition_Simply3()
{
ConsoleTitleUtil.ShowTestTitle("FindCondition_Simply");
TCat mycat = TCat.find("Id=" + 3).first();
Assert.IsNotNull(mycat);
Assert.AreEqual("娱乐电影", mycat.Name);
}
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 static Identifier Addidentifier(string name, TCat cat)
{
Identifier identifier = new Identifier
{
name = name,
cat = cat
};
Identifiers.AddLast(identifier);
return(identifier);
}
public void FindCondition_LikeParams()
{
ConsoleTitleUtil.ShowTestTitle("FindCondition_LikeParams");
List <TCat> cats = TCat.find("Name like '%'+:t+'%'").set("t", "新闻").list();
Assert.AreEqual(2, cats.Count);
Assert.AreEqual("国际新闻", cats[0].Name);
Assert.AreEqual("国内新闻", cats[1].Name);
}
public void UpdateACat()
{
TCat cat = db.findById <TCat>(2);
Assert.AreEqual("国际新闻", cat.Name);
cat.Name = "这里不是新闻";
db.update(cat);
TCat newcat = db.findById <TCat>(cat.Id);
Assert.AreEqual("这里不是新闻", newcat.Name);
}
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 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);
}
public void FindAll_Simply()
{
ConsoleTitleUtil.ShowTestTitle("FindAll_Simply");
IList <TCat> results = TCat.findAll();
Assert.AreEqual(12, results.Count);
foreach (TCat cat in results)
{
Assert.Greater(cat.Id, 0);
Assert.IsNotNull(cat.Name);
Console.WriteLine("TCat {0} - {1}", cat.Id, cat.Name);
}
}
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 FindCondition_Simply2()
{
ConsoleTitleUtil.ShowTestTitle("FindCondition_Simply");
IList <TCat> cats = TCat.find("Id>" + 5).select("Id,Name,ArticleCount").list();
Assert.AreEqual(7, cats.Count);
foreach (TCat cat in cats)
{
Assert.Greater(cat.Id, 0);
Assert.IsNotNull(cat.Name);
}
}
public void InsertCat()
{
ConsoleTitleUtil.ShowTestTitle("InsertCat");
TCat cat = new TCat();
cat.Name = "国内新闻";
cat.insert();
cat.Name = "国际新闻";
cat.insert();
cat.Name = "娱乐电影";
cat.insert();
cat.Name = "音像世界";
cat.insert();
cat.Name = "游戏广场";
cat.insert();
cat.Name = "文学艺术";
cat.insert();
cat.Name = "电视剧本";
cat.insert();
cat.Name = "武侠小说";
cat.insert();
cat.Name = "互联网络";
cat.insert();
cat.Name = "软件服务";
cat.insert();
cat.Name = "笑话幽默";
cat.insert();
cat.Name = "金融期货";
cat.insert();
Console.WriteLine("添加 cat 成功！");
}
public void InsertCat()
{
ConsoleTitleUtil.ShowTestTitle("InsertCat");
TCat cat = new TCat();
cat.Id = 10;
cat.Name = "国内新闻10";
db.insert(cat);
cat.Name = "国际新闻20";
cat.Id = 20;
db.insert(cat);
cat.Name = "金融期货30";
cat.Id = 30;
db.insert(cat);
Console.WriteLine("\n添加 cat 成功！\n\n");
}
public void InsertCat()
{
ConsoleTitleUtil.ShowTestTitle("InsertCat");
TCat cat = new TCat();
cat.Id = 10;
cat.Name = "国内新闻10";
db.insert(cat);
cat.Name = "国际新闻20";
cat.Id = 20;
db.insert(cat);
cat.Name = "金融期货30";
cat.Id = 30;
db.insert(cat);
Console.WriteLine("\n添加 cat 成功！\n\n");
}
public void FindCondition_Params()
{
ConsoleTitleUtil.ShowTestTitle("FindCondition_Params");
List <TCat> cats = TCat.find("Id in (:id1,:id2,:id3)")
.set("id1", 6)
.set("id2", 7)
.set("id8", 8)
.list();
Assert.AreEqual(3, cats.Count);
foreach (TCat cat in cats)
{
Assert.Greater(cat.Id, 0);
Assert.IsNotNull(cat.Name);
Console.WriteLine(cat.Id);
}
}
public void FindPropertyNull()
{
string artIds = "";
string catIds = "";
ArrayList list = new ArrayList();
IList arts = new ArrayList();
for (int i = 0; i < 5; i++)
{
TCat cat = new TCat();
cat.Name = "tempCat1";
cat.insert();
list.Add(cat);
catIds += cat.Id + ",";
TArticle art = new TArticle();
art.Title = "这是什么地方的测试" + i;
art.Cat = cat;
art.insert();
arts.Add(art);
artIds += art.Id + ",";
cat.delete();
}
catIds = catIds.TrimEnd(',');
artIds = artIds.TrimEnd(',');
IList <TArticle> results = TArticle.find("Id in (" + artIds + ")").list();
foreach (TArticle art in results)
{
Assert.IsNull(art.Cat);
Console.WriteLine(art.Title);
//Console.WriteLine( "Id:" + art.Cat.Id + " catNull:" + art.Cat.IsNull() + " nameNull:" + strUtil.IsNullOrEmpty( art.Cat.Name ) );
}
}
public void Count()
{
int count = TCat.count();
Assert.AreEqual(12, count);
count = TCat.count("Id=3");
Assert.AreEqual(1, count);
count = TArticle.count("Member.Id=7");
Assert.AreEqual(1, count);
count = TArticle.count("Author='周做人' ");
Assert.AreEqual(1, count);
// 上面直接使用Count的速度比较快，因为直接运行 select count(*) from TCat 语句
// 下面的count速度慢，先 select Id from Syy_Article where ( MemberId = 7 ) order by Id desc ，然后计算数量。
// 但这第二种方法也有优点，就是可以使用参数化查询
//count = TArticle.find( "Member.Id=:mid" ).set( "mid", 7 ).count();
//Assert.AreEqual( 1, count );
}
public void InsertCat()
{
ConsoleTitleUtil.ShowTestTitle( "InsertCat" );
TCat cat = new TCat();
cat.Name = "国内新闻";
db.insert( cat );
cat.Name = "国际新闻";
db.insert( cat );
cat.Name = "娱乐电影";
db.insert( cat );
cat.Name = "音像世界";
db.insert( cat );
cat.Name = "游戏广场";
db.insert( cat );
cat.Name = "文学艺术";
db.insert( cat );
cat.Name = "电视剧本";
db.insert( cat );
cat.Name = "武侠小说";
db.insert( cat );
cat.Name = "互联网络";
db.insert( cat );
cat.Name = "软件服务";
db.insert( cat );
cat.Name = "笑话幽默";
db.insert( cat );
cat.Name = "金融期货";
db.insert( cat );
Console.WriteLine( "添加 cat 成功！" );
}
public void InsertCat()
{
ConsoleTitleUtil.ShowTestTitle( "InsertCat" );
TCat cat = new TCat();
cat.Name = "��������";
db.insert( cat );
cat.Name = "��������";
db.insert( cat );
cat.Name = "���ֵ�Ӱ";
db.insert( cat );
cat.Name = "��������";
db.insert( cat );
cat.Name = "��Ϸ�㳡";
db.insert( cat );
cat.Name = "��ѧ����";
db.insert( cat );
cat.Name = "���Ӿ籾";
db.insert( cat );
cat.Name = "����С˵";
db.insert( cat );
cat.Name = "��������";
db.insert( cat );
cat.Name = "�������";
db.insert( cat );
cat.Name = "Ц����Ĭ";
db.insert( cat );
cat.Name = "�����ڻ�";
db.insert( cat );
Console.WriteLine( "��� cat �ɹ���" );
}
public void FindPropertyNull()
{
string artIds = "";
string catIds = "";
ArrayList list = new ArrayList();
IList arts = new ArrayList();
for (int i = 0; i < 5; i++) {
TCat cat = new TCat();
cat.Name = "tempCat1";
db.insert( cat );
list.Add( cat );
catIds += cat.Id + ",";
TArticle art = new TArticle();
art.Title = "����ʲô�ط��IJ���" + i;
art.Cat = cat;
db.insert( art );
arts.Add( art );
artIds += art.Id + ",";
db.delete( cat );
}
catIds = catIds.TrimEnd( ',' );
artIds = artIds.TrimEnd( ',' );
IList<TArticle> results = db.find<TArticle>( "Id in (" + artIds + ")" ).list();
foreach (TArticle art in results) {
Assert.IsNull( art.Cat );
Console.WriteLine( art.Title );
//Console.WriteLine( "Id:" + art.Cat.Id + " catNull:" + art.Cat.IsNull() + " nameNull:" + strUtil.IsNullOrEmpty( art.Cat.Name ) );
}
}
