在使用 jtester+unitils+testng 做数据库接口的单元测试框架中， 常常需要编写一些 wiki 及 DAOTest java 文件， 比如：
public class XXXDefaultDAOTest extends BaseRegionDbDAOTestCase {
@SpringBeanByName
private XXXDefaultDAO XXXDefaultDAO;
@Test
@DbFit(when="XXXDefaultDAOTest.initBlank.when.wiki", then="XXXDefaultDAOTest.queryOneRecord.then.wiki")
public void testInsertXXXDefaultDO() {
XXXDefaultDO XXXDefaultDO = new XXXDefaultDO();
XXXDefaultDO.setId(1L);
XXXDefaultDO.setCidrBlock("192.168.10.10");
XXXDefaultDO.setIpProtocol("tcp");
XXXDefaultDO.setPortRange("3000:4000");
XXXDefaultDO.setPolicy(Policy.POLICY_ACCEPT);
XXXDefaultDO.setNic(Nic.INTRANET);
XXXDefaultDO.setPriority(65533L);
XXXDefaultDO.setType(1L);
XXXDefaultDO.setIsDeleted(0L);
XXXDefaultDO.setDescription("test1");
XXXDefaultDO.setGmtCreate(new Date());
XXXDefaultDO.setGmtModify(new Date());
XXXDefaultDAO.insertXXXDefaultDO(XXXDefaultDO);
}
@Test
@DbFit(when="XXXDefaultDAOTest.initRecords.when.wiki")
public void testCountXXXDefaultDOByExample() {
XXXDefaultDO XXXDefaultDO = new XXXDefaultDO();
Assert.assertTrue(XXXDefaultDAO.countXXXDefaultDOByExample(XXXDefaultDO) == 1);
}
@Test
@DbFit(when="XXXDefaultDAOTest.initRecords.when.wiki", then="XXXDefaultDAOTest.testUpdate.then.wiki")
public void testUpdateXXXDefaultDO() {
XXXDefaultDO found = XXXDefaultDAO.findXXXDefaultDOByPrimaryKey(6L);
found.setIpProtocol("udp");
found.setNic(Nic.INTERNET);
found.setDescription("desc");
XXXDefaultDAO.updateXXXDefaultDO(found);
}
@Test
@DbFit(when="XXXDefaultDAOTest.initRecords.when.wiki")
public void testFindListByExample() {
String cidrBlock = "10.152.126.83";
Policy policy = Policy.POLICY_ACCEPT;
XXXDefaultDO XXXDefault = new XXXDefaultDO();
XXXDefault.setCidrBlock(cidrBlock);
XXXDefault.setPolicy(policy);
List list = XXXDefaultDAO.findListByExample(XXXDefault);
Assert.assertEquals(list.size(), 1);
for (XXXDefaultDO XXXDefaultDO: list) {
Assert.assertEquals(XXXDefaultDO.getCidrBlock(), cidrBlock);
Assert.assertEquals(XXXDefaultDO.getPolicy(), policy);
}
}
@Test
@DbFit(when="XXXDefaultDAOTest.initRecords.when.wiki")
public void testFindXXXDefaultDOByPrimaryKey() {
XXXDefaultDO found = XXXDefaultDAO.findXXXDefaultDOByPrimaryKey(6L);
Assert.assertEquals(found.getCidrBlock(), "10.152.126.83");
Assert.assertEquals(found.getIpProtocol(), "all");
Assert.assertEquals(found.getPortRange(), "");
Assert.assertEquals(found.getPolicy(), Policy.POLICY_ACCEPT);
Assert.assertEquals(found.getNic(), Nic.BOTH);
Assert.assertEquals(found.getPriority().longValue(),1L);
Assert.assertEquals(found.getType().intValue(), 1);
Assert.assertEquals(found.getIsDeleted().intValue(), 0);
Assert.assertEquals(found.getDescription(), "bie dong");
}
@Test
@DbFit(when="XXXDefaultDAOTest.initRecords.when.wiki", then="")
public void testDeleteXXXDefaultDOByPrimaryKey() {
Integer count = XXXDefaultDAO.deleteXXXDefaultDOByPrimaryKey(6L);
Assert.assertEquals(count.i