public void ModifyTagTest()
{
Corona.CoronaService.CoronaService target = new Corona.CoronaService.CoronaService(AppDomain.CurrentDomain.BaseDirectory + "testdb6.accdb"); // TODO: 初始化为适当的值
Tag tag = new Tag("小游戏"); // TODO: 初始化为适当的值
Resource res = new Resource("PopCollection.exe",
@"D:\program files\games\PopCollection.exe");
target.AddResource(res);
target.AddTag(tag, res);
target.ModifyTag(tag);
Tag tag1 = new Tag("Pop小游戏");
tag1.TagID = tag.TagID;
tag1.ResourceID = tag.ResourceID;
target.ModifyTag(tag1);
List <Resource> RList = new List <Resource>();
RList.Add(res);
List <Tag> TList;
TList = target.SearchTagsFromResources(RList);
foreach (Tag t in TList)
{
if (t.TagID == tag.TagID)
{
Assert.AreEqual(tag1.TagName, t.TagName);
break;
}
}
Tag tag2 = tag;
tag2.TagName = null;//修改为空名称
target.ModifyTag(tag2);
Assert.IsTrue(true);
Tag tag3 = new Tag();
tag3.TagName = "Pop";
tag3.TagID = tag.TagID;
tag3.ResourceID = tag.ResourceID;
target.AddTag(tag3, res);
tag3.TagName = "Pop小游戏";//修改为重名的同一个资源的标签
target.ModifyTag(tag3);
Assert.IsTrue(true);
Tag tag4 = new Tag();
//不知道怎么测——————————————————————————————————————————————————————————————
tag4.TagName = "~~~~";//tag4是恶意注入的SQL语句
tag4.TagID = @"0 or true";
target.ModifyTag(tag4);
TList = target.SearchTagsFromResources(RList);
foreach (Tag t in TList)
{
if (t.TagName.Equals("~~~~"))
{
Assert.Fail();
}
}
}
public void RemoveTagTest()
{
Corona.CoronaService.CoronaService target = new Corona.CoronaService.CoronaService(AppDomain.CurrentDomain.BaseDirectory + "testdb4.accdb"); // TODO: 初始化为适当的值
Resource res1 = new Resource("1.jpg", @"D:\pictures\1.jpg");
target.AddResource(res1);
Tag tag1 = new Tag("河南");
Tag tag2 = new Tag("人物");
Tag tag3 = new Tag("汴京府");
target.AddTag(tag1, res1);
target.AddTag(tag2, res1);
target.AddTag(tag3, res1);
target.RemoveTag(tag1.TagID);//Remove已经存在数据库中的标签
List <Resource> RL = new List <Resource>();
RL.Add(res1);
List <Tag> TL = null;
TL = target.SearchTagsFromResources(RL);
foreach (Tag t in TL)
{
if (t.TagID == tag1.TagID)
{
Assert.Fail();
break;
}
}
target.RemoveTag(tag1.TagID);//Remove已经删除过的，有ＩＤ
Assert.IsTrue(true);
Tag tempTag = new Tag("Homework");
target.RemoveTag(tempTag.TagID); //测试刚刚新建的，ID此时应该没有赋值
target.RemoveTag(null); //删除空的
Assert.IsTrue(true);
}
public void SearchTagsFromResourcesTest()
{
Corona.CoronaService.CoronaService target = new Corona.CoronaService.CoronaService(AppDomain.CurrentDomain.BaseDirectory + "testdb2.accdb"); // TODO: 初始化为适当的值
Resource res1 = new Resource("1.jpg", @"D:\pictures\1.jpg");
Resource res2 = new Resource("2.jpg", @"D:\pictures\2.jpg");
Resource res3 = new Resource("3.jpg", @"D:\pictures\3.jpg");
target.AddResource(res1); target.AddResource(res2); target.AddResource(res3);
Tag tag1 = new Tag("河南");
Tag tag2 = new Tag("北京");
Tag tag3 = new Tag("内蒙古");
Tag tag4 = new Tag("人物");
Tag tag5 = new Tag("风景");
Tag tag6 = new Tag("风景");
target.AddTag(tag1, res1);
target.AddTag(tag4, res1);
target.AddTag(tag2, res2);
target.AddTag(tag5, res2);
target.AddTag(tag3, res3);
target.AddTag(tag6, res3);
List <Resource> RList = new List <Resource>();
RList.Add(res1);
RList.Add(res2);
RList.Add(res3);
List <Tag> TagExpected = new List <Tag>();
TagExpected.Add(tag1); TagExpected.Add(tag2); TagExpected.Add(tag3);
TagExpected.Add(tag4); TagExpected.Add(tag5); TagExpected.Add(tag6);
List <Tag> TagActual;
TagActual = target.SearchTagsFromResources(RList);//正常情况的测试
foreach (Tag t in TagActual)
{
byte flag = 0;
foreach (Tag ta in TagExpected)
{
if (t.TagID == ta.TagID)
{
flag = 1;
break;
}
}
if (flag == 0)
{
Assert.Fail();
}
}
foreach (Tag t in TagExpected)
{
byte flag = 0;
foreach (Tag ta in TagActual)
{
if (ta.TagID == t.TagID)
{
flag = 1;
break;
}
}
if (flag == 0)
{
Assert.Fail();
}
}
List <Resource> RList1 = new List <Resource>();//测空的资源表
Assert.AreEqual(0, target.SearchTagsFromResources(RList1).Count);
List <Resource> RList2 = null;//测试Null资源表
Assert.AreEqual(0, target.SearchTagsFromResources(RList2).Count);
Resource tempRes = new Resource("tt.jpg", @"C:\pictures");
List <Resource> RList3 = new List <Resource>();//测试刚刚创建的资源
RList3.Add(tempRes);
Assert.AreEqual(0, target.SearchTagsFromResources(RList3).Count);
target.RemoveResource(res1.ResourceID);
List <Resource> RList4 = new List <Resource>();//测试刚刚删除的资源
RList4.Add(res1);
Assert.AreEqual(0, target.SearchTagsFromResources(RList4).Count);
}
public void SearchTagsFromResourcesTest()
{
Corona.CoronaService.CoronaService target = new Corona.CoronaService.CoronaService(AppDomain.CurrentDomain.BaseDirectory + "testdb2.accdb"); // TODO: 初始化为适当的值
Resource res1 = new Resource("1.jpg", @"D:\pictures\1.jpg");
Resource res2 = new Resource("2.jpg", @"D:\pictures\2.jpg");
Resource res3 = new Resource("3.jpg", @"D:\pictures\3.jpg");
target.AddResource(res1); target.AddResource(res2); target.AddResource(res3);
Tag tag1 = new Tag("河南");
Tag tag2 = new Tag("北京");
Tag tag3 = new Tag("内蒙古");
Tag tag4 = new Tag("人物");
Tag tag5 = new Tag("风景");
Tag tag6 = new Tag("风景");
target.AddTag(tag1, res1);
target.AddTag(tag4, res1);
target.AddTag(tag2, res2);
target.AddTag(tag5, res2);
target.AddTag(tag3, res3);
target.AddTag(tag6, res3);
List<Resource> RList=new List<Resource>();
RList.Add(res1);
RList.Add(res2);
RList.Add(res3);
List<Tag> TagExpected=new List<Tag>();
TagExpected.Add(tag1); TagExpected.Add(tag2);TagExpected.Add(tag3);
TagExpected.Add(tag4);TagExpected.Add(tag5);TagExpected.Add(tag6);
List<Tag> TagActual;
TagActual = target.SearchTagsFromResources(RList);//正常情况的测试
foreach (Tag t in TagActual)
{
byte flag=0;
foreach (Tag ta in TagExpected)
{
if (t.TagID == ta.TagID)
{
flag = 1;
break;
}
}
if (flag == 0)
{
Assert.Fail();
}
}
foreach (Tag t in TagExpected)
{
byte flag = 0;
foreach (Tag ta in TagActual)
{
if (ta.TagID == t.TagID)
{
flag = 1;
break;
}
}
if (flag == 0)
{
Assert.Fail();
}
}
List<Resource> RList1 = new List<Resource>();//测空的资源表
Assert.AreEqual(0,target.SearchTagsFromResources(RList1).Count);
List<Resource> RList2 = null;//测试Null资源表
Assert.AreEqual(0,target.SearchTagsFromResources(RList2).Count);
Resource tempRes = new Resource("tt.jpg",@"C:\pictures");
List<Resource> RList3 = new List<Resource>();//测试刚刚创建的资源
RList3.Add(tempRes);
Assert.AreEqual(0,target.SearchTagsFromResources(RList3).Count);
target.RemoveResource(res1.ResourceID);
List<Resource> RList4 = new List<Resource>();//测试刚刚删除的资源
RList4.Add(res1);
Assert.AreEqual(0,target.SearchTagsFromResources(RList4).Count);
}
public void RemoveTagTest()
{
Corona.CoronaService.CoronaService target = new Corona.CoronaService.CoronaService(AppDomain.CurrentDomain.BaseDirectory + "testdb4.accdb"); // TODO: 初始化为适当的值
Resource res1 = new Resource("1.jpg", @"D:\pictures\1.jpg");
target.AddResource(res1);
Tag tag1 = new Tag("河南");
Tag tag2 = new Tag("人物");
Tag tag3 = new Tag("汴京府");
target.AddTag(tag1, res1);
target.AddTag(tag2, res1);
target.AddTag(tag3, res1);
target.RemoveTag(tag1.TagID);//Remove已经存在数据库中的标签
List<Resource> RL = new List<Resource>();
RL.Add(res1);
List<Tag> TL = null;
TL = target.SearchTagsFromResources(RL);
foreach (Tag t in TL)
{
if (t.TagID == tag1.TagID)
{
Assert.Fail();
break;
}
}
target.RemoveTag(tag1.TagID);//Remove已经删除过的，有ＩＤ
Assert.IsTrue(true);
Tag tempTag = new Tag("Homework");
target.RemoveTag(tempTag.TagID);//测试刚刚新建的，ID此时应该没有赋值
target.RemoveTag(null);//删除空的
Assert.IsTrue(true);
}
public void ModifyTagTest()
{
Corona.CoronaService.CoronaService target = new Corona.CoronaService.CoronaService(AppDomain.CurrentDomain.BaseDirectory + "testdb6.accdb"); // TODO: 初始化为适当的值
Tag tag = new Tag("小游戏"); // TODO: 初始化为适当的值
Resource res = new Resource("PopCollection.exe",
@"D:\program files\games\PopCollection.exe");
target.AddResource(res);
target.AddTag(tag,res);
target.ModifyTag(tag);
Tag tag1 = new Tag("Pop小游戏");
tag1.TagID = tag.TagID;
tag1.ResourceID = tag.ResourceID;
target.ModifyTag(tag1);
List<Resource> RList = new List<Resource>();
RList.Add(res);
List<Tag> TList;
TList=target.SearchTagsFromResources(RList);
foreach (Tag t in TList)
{
if (t.TagID == tag.TagID)
{
Assert.AreEqual(tag1.TagName,t.TagName);
break;
}
}
Tag tag2 = tag;
tag2.TagName = null;//修改为空名称
target.ModifyTag(tag2);
Assert.IsTrue(true);
Tag tag3 = new Tag();
tag3.TagName = "Pop";
tag3.TagID = tag.TagID;
tag3.ResourceID = tag.ResourceID;
target.AddTag(tag3,res);
tag3.TagName="Pop小游戏";//修改为重名的同一个资源的标签
target.ModifyTag(tag3);
Assert.IsTrue(true);
Tag tag4 = new Tag();
//不知道怎么测——————————————————————————————————————————————————————————————
tag4.TagName ="~~~~";//tag4是恶意注入的SQL语句
tag4.TagID = @"0 or true";
target.ModifyTag(tag4);
TList = target.SearchTagsFromResources(RList);
foreach (Tag t in TList)
{
if (t.TagName.Equals("~~~~"))
Assert.Fail();
}
}
