com.github.springtestdbunit.assertion.DatabaseAssertionMode Java Examples

@Test
@ExpectedDatabase(value = "data-comment-added-and-edited.xml", assertionMode = DatabaseAssertionMode.NON_STRICT)
@DatabaseTearDown(value = "data.xml", type = DatabaseOperation.TRUNCATE_TABLE) // to reset id sequence, otherwise other tests that insert comments will fail on ExpectedDatabase
public void shouldEditComment() throws Exception {
    mockMvc.perform(post("/posts/1/comments/create").with(userBob()).with(csrf())
            .contentType(MediaType.APPLICATION_FORM_URLENCODED)
            .param("commentText", "new comment text"))
            .andExpect(status().isOk())
            .andExpect(jsonPath("$.status", is("ok")));

    String text = "edited text";

    mockMvc.perform(post("/posts/1/comments/4/edit").with(userBob()).with(csrf())
            .contentType(MediaType.APPLICATION_FORM_URLENCODED)
            .param("commentText", text))
            .andExpect(status().isOk())
            .andExpect(content().string("ok"));

    assertThat(commentService.getComment(4L).getModifiedDateTime().toLocalDate().equals(LocalDate.now()), equalTo(true));
}
 

/** 测试selectOne1 */
@Test
@DatabaseSetup(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/selectOneTest/testSelectOne1.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/selectOneTest/testSelectOne1.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/selectOneTest/testSelectOne1.result.xml")
public void testSelectOne1() {
	Account_ a1 = new Account_();
	a1.setName("ann");
	a1.setEmail("[email protected]");
	accountService.insert(a1);
	Account_ a2 = new Account_();
	a2.setName("bob");
	a2.setEmail("[email protected]");
	accountService.insert(a2);

	accountService.update(a2);
	accountService.updatePersistent(a2);
	Account_ account_ = accountService.select(a2.getId());

	Account_ ac = new Account_();
	ac.setName("bob");
	ac.setEmail("[email protected]");
	Account_ account = accountService.selectOne(ac);
	Assert.assertEquals("[email protected]", account.getEmail());
}
 

/** 测试selectOne2 */
@Test
@DatabaseSetup(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/selectOneTest/testSelectOne2.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/selectOneTest/testSelectOne2.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/selectOneTest/testSelectOne2.result.xml")
public void testSelectOne2() {
	Account_ a1 = new Account_();
	a1.setName("ann");
	a1.setEmail("[email protected]");
	accountService.insert(a1);
	Account_ a2 = new Account_();
	a2.setName("ann");
	a2.setEmail("[email protected]");
	accountService.insert(a2);

	Account_Condition ac = new Account_Condition();
	ac.setLimiter(new PageParam(1, 2));
	ac.setSorter(new SortParam(new Order("id", Sequence.ASC)));
	ac.setName("ann");
	Account_ account = accountService.selectOne(ac);
	Assert.assertEquals("[email protected]", account.getEmail());
	Assert.assertNull(ac.getLimiter());
}
 

/** 测试多重外键情况下sorter是否能正确发挥作用 */
@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/conditionTest/testSorterWithMultiAssociation.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/conditionTest/testSorterWithMultiAssociation.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/conditionTest/testSorterWithMultiAssociation.xml")
public void testSorterWithMultiAssociation() {
	Role_Condition rc1 = new Role_Condition();
	rc1.setName("role1");
	Role_Condition rc2 = new Role_Condition();
	rc2.setName("role2");
	Account_Condition ac = new Account_Condition();
	ac.setRole(rc1);
	ac.setRoleDeputy(rc2);
	ac.setSorter(new SortParam(new Order("name", Sequence.ASC)));
	Collection<Account_> accountC = accountService.selectAll(ac);
	Account_[] accounts = accountC.toArray(new Account_[accountC.size()]);
	Assert.assertEquals(3, accounts.length);
	Assert.assertEquals("bob", accounts[0].getName());
}
 

@Test
@DatabaseSetups({
		@DatabaseSetup(connection = "dataSource2", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/ignoreInsertAndUpdateTest/testInsert.datasource2.xml") })
@ExpectedDatabases({
		@ExpectedDatabase(connection = "dataSource2", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/ignoreInsertAndUpdateTest/testInsert.datasource2.result.xml") })
@DatabaseTearDowns({
		@DatabaseTearDown(connection = "dataSource2", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/ignoreInsertAndUpdateTest/testInsert.datasource2.result.xml") })
public void testInsert() {
	Detail2_ d = new Detail2_(), d2 = new Detail2_();
	d.setName("n");
	d.setNumber(123);
	d.setDetail("d");
	d.setCreatetime(Calendar.getInstance().getTime());
	detail2Service.insertWithoutName(d);

	d2.setName("n2");
	d2.setNumber(234);
	d2.setDetail("d2");
	d2.setCreatetime(Calendar.getInstance().getTime());
	LoginLogSource2 loginLog2 = new LoginLogSource2();
	loginLog2.setId(22);
	d2.setLoginLogSource2(loginLog2);
	detail2Service.insertWithoutFoo(d2);
}
 

@Test
@DatabaseSetups({
		@DatabaseSetup(connection = "dataSource1", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/orTest/testOrMashup.dataSource1.xml"),
		@DatabaseSetup(connection = "dataSource2", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/orTest/testOrMashup.dataSource2.xml"), })
@ExpectedDatabases({
		@ExpectedDatabase(connection = "dataSource1", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT_UNORDERED, value = "/indi/mybatis/flying/test/orTest/testOrMashup.dataSource1.result.xml"),
		@ExpectedDatabase(connection = "dataSource2", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT_UNORDERED, value = "/indi/mybatis/flying/test/orTest/testOrMashup.dataSource2.result.xml"), })
@DatabaseTearDowns({
		@DatabaseTearDown(connection = "dataSource1", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/orTest/testOrMashup.dataSource1.result.xml"),
		@DatabaseTearDown(connection = "dataSource2", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/orTest/testOrMashup.dataSource2.result.xml"), })
public void testOrMashup() {
	LoginLogSource2Condition l2c = new LoginLogSource2Condition();
	l2c.setAccountEqualsOr2(1L, 2L, "23453");
	int i1 = loginLogSource2Service.count(l2c);
	Assert.assertEquals(3, i1);

	LoginLogSource2Condition l2c2 = new LoginLogSource2Condition();
	l2c2.setAccountEqualsOr3(1L, 2L, "23453", "d4");
	Detail2_ d2c = new Detail2_();
	d2c.setLoginLogSource2(l2c2);
	int i2 = detail2Service.count(d2c);
	Assert.assertEquals(4, i2);
}
 

@Test
@IfProfileValue(name = "CACHE", value = "true")
@ExpectedDatabase(connection = "dataSource1", assertionMode = DatabaseAssertionMode.NON_STRICT_UNORDERED, value = "/indi/mybatis/flying/test/cacheTest/testInsertSnowFlakeCache.result.xml")
@DatabaseTearDown(connection = "dataSource1", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/cacheTest/testInsertSnowFlakeCache.result.xml")
public void testInsertSnowFlakeCache() {
	Account_ account = new Account_();
	account.setName("ann");
	accountService.insert(account);

	int i = accountService.count(new Account_());
	Assert.assertEquals(1, i);

	Account_ account2 = new Account_();
	account2.setName("bob");
	accountService.insertSnowFlake(account2);

	int i2 = accountService.count(new Account_());
	Assert.assertEquals(2, i2);
}
 

@Test
@DatabaseSetups({
		@DatabaseSetup(connection = "dataSource2", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/ignoreInsertAndUpdateTest/testUpdate.datasource2.xml") })
@ExpectedDatabases({
		@ExpectedDatabase(connection = "dataSource2", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT_UNORDERED, value = "/indi/mybatis/flying/test/ignoreInsertAndUpdateTest/testUpdate.datasource2.result.xml") })
@DatabaseTearDowns({
		@DatabaseTearDown(connection = "dataSource2", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/ignoreInsertAndUpdateTest/testUpdate.datasource2.result.xml") })
public void testUpdate() {
	Detail2_ detail = detail2Service.select(1);
	detail.setName("n1New");
	detail.setDetail("dNew");
	LoginLogSource2 log = loginLogSource2Service.select(12);
	detail.setLoginLogSource2(log);
	detail2Service.updateWithoutName(detail);

	Detail2_ detail2 = detail2Service.select(2);
	detail2.setName(null);
	detail2.setNumber(null);
	detail2.setLoginLogSource2(null);
	detail2Service.updatePersistentWithoutName(detail2);
}
 

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/orTest/testOr6.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/orTest/testOr6.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/orTest/testOr6.result.xml")
public void testOr6() {
	LoginLog_Condition lc = new LoginLog_Condition();
	lc.setAccount(new Account_Condition());
	lc.getAccount().setRole(new Role_Condition());
	((Role_Condition) lc.getAccount().getRole()).setAccountNameEquals("ann");
	int i = loginLogService.count(lc);
	Assert.assertEquals(2, i);

	LoginLog_Condition lc2 = new LoginLog_Condition();
	lc2.setAccount(new Account_Condition());
	lc2.getAccount().setRole(new Role_Condition());
	((Role_Condition) lc2.getAccount().getRole()).setNameEquals("admin");
	int i2 = loginLogService.count(lc2);
	Assert.assertEquals(4, i2);
}
 

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/orTest/testOr4.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/orTest/testOr4.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/orTest/testOr4.result.xml")
public void testOr4() {
	LoginLog_Condition lc = new LoginLog_Condition();
	Account_Condition ac = new Account_Condition();
	ac.setNameEqualsOrLoginlogIpEquals("ann", "bob", "c1");
	lc.setAccount(ac);
	int i1 = loginLogService.count(lc);
	Assert.assertEquals(5, i1);

	LoginLog_Condition lc2 = new LoginLog_Condition();
	lc2.setAccount(new Account_Condition());
	lc2.getAccount().setRole(new Role_Condition());
	((Role_Condition) (lc2.getAccount().getRole())).setNameEqualsOrAccountNameEquals("admin", "cal");
	int i2 = loginLogService.count(lc2);
	Assert.assertEquals(6, i2);
}
 

/** 测试无外键情况下condition:in功能且变量类型为时间的情况 */
@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/conditionInTest/testConditionIn4.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/conditionInTest/testConditionIn4.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/conditionInTest/testConditionIn4.xml")
public void testConditionIn4() {
	LoginLog_Condition lc = new LoginLog_Condition();
	List<Date> timeC = new ArrayList<>();
	Calendar c = Calendar.getInstance(), c2 = Calendar.getInstance();
	c.clear();
	c2.clear();
	c.set(1970, 0, 1, 8, 0, 0);
	c2.set(1970, 0, 1, 8, 0, 1);
	timeC.add(c.getTime());
	timeC.add(c2.getTime());
	lc.setLoginTimeIn(timeC);
	int count = loginLogService.count(lc);
	Assert.assertEquals(2, count);
}
 

@IfProfileValue(name = "CACHE", value = "true")
@ExpectedDatabase(connection = "dataSource1", assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/cacheTest/testUpdateDirect.result.xml")
@DatabaseTearDown(connection = "dataSource1", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/cacheTest/testUpdateDirect.result.xml")
public void testUpdateDirect() {
	Role_ r = new Role_();
	r.setId(1);
	r.setName("ann");
	roleService.insert(r);
	Account_ a = new Account_();
	a.setId(1L);
	a.setRole(r);
	a.setEmail("email");
	accountService.insert(a);

	Account_ account = accountService.select(1);
	Assert.assertEquals("ann", account.getRole().getName());

	Map<String, Object> m = new HashMap<>(4);
	m.put("id", 1);
	m.put("name", "bob");
	roleService.updateDirect(m);

	Account_ account2 = accountService.select(1);
	Assert.assertEquals("ann", account2.getRole().getName());
}
 

@Test
@DatabaseSetups({
		@DatabaseSetup(connection = "dataSource2", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/jpaTest/testDetail2.datasource2.xml") })
@ExpectedDatabases({
		@ExpectedDatabase(connection = "dataSource2", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/jpaTest/testDetail2.datasource2.result.xml") })
@DatabaseTearDowns({
		@DatabaseTearDown(connection = "dataSource2", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/jpaTest/testDetail2.datasource2.result.xml") })
public void testDetail2() {
	Detail2_ detail2 = detail2Service.select(1);
	Assert.assertEquals("n", detail2.getName());
	Assert.assertEquals(123, detail2.getNumber().intValue());
	Assert.assertEquals("l", detail2.getLoginLogSource2().getLoginIP());
	loginLogSource2Service.update(detail2.getLoginLogSource2());

	Detail2_ detail2_2 = new Detail2_();
	detail2_2.setName("name");
	detail2_2.setDetail("detail");
	detail2_2.setNumber(321);
	detail2Service.insert(detail2_2);

	Detail2_ detail2_c = new Detail2_();
	detail2_c.setName("name");
	detail2_c.setDetail("detail");
	Detail2_ detail2_3 = detail2Service.selectOne(detail2_c);
	Assert.assertEquals(detail2_2.getId(), detail2_3.getId());
}
 

@Test
@DatabaseSetup(connection = "dataSource1", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteListUpdate.xml")
@ExpectedDatabase(connection = "dataSource1", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteListUpdate.result.xml")
@DatabaseTearDown(connection = "dataSource1", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteListUpdate.result.xml")
public void testWhiteListUpdate() {
	Account_ account = accountService.select(1);
	account.setName("bob");
	account.setEmail("[email protected]");
	account.setPassword("bbb");
	account.setStatus(StoryStatus_.p);
	account.setActivateValue("bv");
	Role_ role = new Role_();
	role.setId(2);
	account.setRole(role);
	Permission permission = new Permission();
	permission.setId(22);
	account.setPermission(permission);
	accountService.updateSimpleNoName(account);
}
 

@Test
@DatabaseSetup(connection = "dataSource1", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteListInsertBatch.xml")
@ExpectedDatabase(connection = "dataSource1", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteListInsertBatch.result.xml")
@DatabaseTearDown(connection = "dataSource1", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteListInsertBatch.result.xml")
public void testWhiteListInsertBatch() {
	Account_ account = new Account_();
	account.setName("name");
	account.setEmail("email");
	account.setPassword("aaa");
	Role_ role = new Role_();
	role.setId(11);
	account.setRole(role);
	Permission permission = new Permission();
	permission.setId(22);
	account.setPermission(permission);

	Collection<Account_> ac = new ArrayList<>();
	ac.add(account);
	accountService.insertBatchSimpleNoName(ac);
}
 

@Test
@DatabaseSetup(connection = "dataSource1", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteList.xml")
@ExpectedDatabase(connection = "dataSource1", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteList.result.xml")
@DatabaseTearDown(connection = "dataSource1", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteList.result.xml")
public void testWhiteList() {
	Account_ account = accountService.selectSimple(1);
	Assert.assertNull(account.getEmail());
	Assert.assertNull(account.getPassword());
	Assert.assertNull(account.getPermission().getName());
	Assert.assertNull(account.getPermission().getFakeId());

	LoginLog_ l = new LoginLog_();
	l.setLoginIP("ip1");
	LoginLog_ loginLog = loginLogService.selectOneSimple(l);
	Assert.assertNull(loginLog.getLoginIP2());
	Assert.assertNull(loginLog.getAccount().getEmail());
	Assert.assertNull(loginLog.getAccount().getPassword());
	Assert.assertNull(loginLog.getAccount().getPermission().getName());
	Assert.assertNull(loginLog.getAccount().getPermission().getFakeId());
}
 

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/batchProcessTest/testBatchUpdate10.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/batchProcessTest/testBatchUpdate10.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/batchProcessTest/testBatchUpdate10.xml")
public void testBatchUpdate10() {
	Account_Condition ac = new Account_Condition();
	ac.setEmail("[email protected]");
	ac.setNameIsNull(true);
	accountService.update(ac);

	Account_Condition ac2 = new Account_Condition();
	ac2.setEmail("[email protected]");
	ac2.setNameIsNull(false);
	ac2.setActivateValueEqual("aaa");
	accountService.update(ac2);
}
 

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/batchProcessTest/testBatchUpdate11.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/batchProcessTest/testBatchUpdate11.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/batchProcessTest/testBatchUpdate11.xml")
public void testBatchUpdate11() {
	List<String> nameC = new ArrayList<>();
	nameC.add("a2");
	nameC.add("b");
	Account_Condition ac = new Account_Condition();
	ac.setEmail("[email protected]");
	ac.setNameIn(nameC);
	accountService.update(ac);

	Account_Condition ac2 = new Account_Condition();
	ac2.setEmail("[email protected]");
	ac2.setNameIn(new ArrayList<String>());
	accountService.update(ac2);
}
 

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/batchProcessTest/testBatchUpdate12.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT_UNORDERED, value = "/indi/mybatis/flying/test/batchProcessTest/testBatchUpdate12.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/batchProcessTest/testBatchUpdate12.xml")
public void testBatchUpdate12() {
	List<String> nameC = new ArrayList<>();
	nameC.add("a2");
	nameC.add("b");
	Account_Condition ac = new Account_Condition();
	ac.setEmail("[email protected]");
	ac.setNameNotIn(nameC);
	accountService.update(ac);

	Account_ a2 = new Account_();
	a2.setId(2L);
	a2.setPassword("aaa");
	// wrong opLock
	a2.setOpLock(10);
	accountService.update(a2);
}
 

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/indexTest/testIndex.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/indexTest/testIndex.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/indexTest/testIndex.result.xml")
public void testIndex() {
	Account_ account = accountService.selectWithIndex(2);
	Assert.assertEquals("bob", account.getName());

	Account_ ac = new Account_();
	ac.setName("bob");
	Account_ account2 = accountService.selectOne(ac);
	Assert.assertEquals("[email protected]", account2.getEmail());

	Account_Condition ac2 = new Account_Condition();
	ac2.setNameNotEqual("carl");
	int c = accountService.count(ac2);
	Assert.assertEquals(2, c);
}
 

@Test
@DatabaseSetup(connection = "dataSource1", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/prefixTest/testSelect4.xml")
@ExpectedDatabase(connection = "dataSource1", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/prefixTest/testSelect4.result.xml")
@DatabaseTearDown(connection = "dataSource1", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/prefixTest/testSelect4.result.xml")
public void testSelect4() {
	Detail_ dc = new Detail_();
	dc.setName("d3");
	LoginLog_Condition lc = new LoginLog_Condition();
	lc.setIdNotEqual(102);
	dc.setLoginLog(lc);
	lc.setAccount(new Account_());
	lc.getAccount().setRoleDeputy(new Role_Condition());
	((Role_Condition) (lc.getAccount().getRoleDeputy())).setNameNotEquals("roleDeputy3");
	Collection<Detail_> detailC = detailService.selectAllPrefix2(dc);
	Assert.assertEquals(1, detailC.size());
}
 

/** 测试deputyRole */
@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/accountTest/testDeputy.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/accountTest/testDeputy.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/accountTest/testDeputy.xml")
public void testDeputy() {
	Account_ account = accountService.select(1);
	Assert.assertEquals("role1", account.getRole().getName());
	Assert.assertEquals("role2", account.getRoleDeputy().getName());

	Role_ rc = new Role_();
	rc.setName("role1");
	Role_ rdc = new Role_();
	rdc.setName("role2");
	Account_ ac = new Account_();
	ac.setRole(rc);
	ac.setRoleDeputy(rdc);
	Collection<Account_> accountC = accountService.selectAll(ac);
	Assert.assertEquals(1, accountC.size());

	int count = accountService.count(ac);
	Assert.assertEquals(1, count);
}
 

/** 测试CostumizeStatus功能 */
@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/accountTest/testCostumizeStatus.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/accountTest/testCostumizeStatus.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/accountTest/testCostumizeStatus.xml")
public void testCostumizeStatus() {
	Account_ a = accountService.select(1);
	Assert.assertEquals("发布", a.getStatus().text());
	Account_ ac = new Account_();
	ac.setStatus(StoryStatus_.p);
	Collection<Account_> c = accountService.selectAll(ac);
	Assert.assertEquals(1, c.size());
	Account_ a2 = accountService.select(2);
	Assert.assertEquals(StoryStatus_.s, a2.getStatus());
	a2.setStatus(StoryStatus_.c);
	accountService.update(a2);
	Account_ a3 = accountService.select(3);
	Assert.assertNull(a3.getStatus());
	a3.setPassword("5a690d842935c51f26f473e025c1b97a");
	accountService.updatePersistent(a3);
	Account_ a4 = accountService.select(3);
	Assert.assertNull(a4.getStatus());
}
 

@Test
@DatabaseSetups({
		@DatabaseSetup(connection = "dataSource1", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/accountTest/testTransactive3.datasource.xml"),
		@DatabaseSetup(connection = "dataSource2", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/accountTest/testTransactive3.datasource2.xml") })
@ExpectedDatabases({
		@ExpectedDatabase(connection = "dataSource1", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/accountTest/testTransactive3.datasource.result.xml"),
		@ExpectedDatabase(connection = "dataSource2", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/accountTest/testTransactive3.datasource2.result.xml") })
@DatabaseTearDowns({
		@DatabaseTearDown(connection = "dataSource1", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/accountTest/testTransactive3.datasource.result.xml"),
		@DatabaseTearDown(connection = "dataSource2", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/accountTest/testTransactive3.datasource2.result.xml") })
public void testTransactive3() {
	try {
		transactiveService4.testTransactive();
	} catch (ConfigurerException e) {
		e.printStackTrace();
	}
}
 

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/delegateTest/testDelegate.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/delegateTest/testDelegate.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/delegateTest/testDelegate.xml")
public void testDelegate() {
	LoginLog_ l = new LoginLog_();
	l.setDelegateAccountId(11L);
	LoginLog_ loginLog = loginLogService.selectOnePrefix(l);
	Assert.assertNull(loginLog);

	int c = loginLogService.count(l);
	Assert.assertEquals(0, c);

	LoginLog_ loginLog2 = loginLogService.selectPrefix(1);
	LoginLog_Condition l2 = new LoginLog_Condition();
	l2.setDelegateAccountId(loginLog2.getDelegateAccountId());
	l2.setAccount(loginLog2.getAccount());
	l2.setLimiter(new PageParam(1, 2));
	Collection<LoginLog_> loginLogC = loginLogService.selectAllPrefix(l2);
	Page<LoginLog_> page2 = new Page<>(loginLogC, l2.getLimiter());
	System.out.println("::" + JSONObject.toJSONString(page2));

}
 

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/delegateTest/testDelegateUpdate.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/delegateTest/testDelegateUpdate.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/delegateTest/testDelegateUpdate.xml")
public void testDelegateUpdate() {
	LoginLog_ loginLog = loginLogService.select(1);
	loginLog.setAccount(null);
	loginLog.setDelegateAccountId(2L);
	loginLogService.update(loginLog);

	// 当login.getAccount()不为null时，修改accountId不起作用
	LoginLog_ loginLog2 = loginLogService.select(1);
	loginLog2.setDelegateAccountId(11L);
	loginLogService.update(loginLog2);

}
 

@Test
@DatabaseSetups({
		@DatabaseSetup(connection = "dataSource1", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/accountTest/testTransactive2.datasource.xml"),
		@DatabaseSetup(connection = "dataSource2", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/accountTest/testTransactive2.datasource2.xml") })
@ExpectedDatabases({
		@ExpectedDatabase(connection = "dataSource1", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/accountTest/testTransactive2.datasource.result.xml"),
		@ExpectedDatabase(connection = "dataSource2", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/accountTest/testTransactive2.datasource2.result.xml") })
@DatabaseTearDowns({
		@DatabaseTearDown(connection = "dataSource1", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/accountTest/testTransactive2.datasource.result.xml"),
		@DatabaseTearDown(connection = "dataSource2", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/accountTest/testTransactive2.datasource2.result.xml") })
public void testTransactive2() {
	try {
		transactiveService.addAccountTransactive();
	} catch (ConfigurerException e) {
		e.printStackTrace();
	}
}
 

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/delegateTest/testDelegateInsertBatch.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT_UNORDERED, value = "/indi/mybatis/flying/test/delegateTest/testDelegateInsertBatch.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/delegateTest/testDelegateInsertBatch.xml")
public void testDelegateInsertBatch() {
	Collection<LoginLog_> c = new LinkedList<>();
	LoginLog_ l1 = new LoginLog_();
	l1.setLoginIP("0.0.0.1");
	l1.setDelegateAccountId(1L);
	c.add(l1);
	LoginLog_ l2 = new LoginLog_();
	l2.setLoginIP("0.0.0.2");
	l2.setDelegateAccountId(2L);
	c.add(l2);
	loginLogService.insertBatch(c);
}
 

@Test
@DatabaseSetup(connection = "dataSource1", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteListUpdatePersistent.xml")
@ExpectedDatabase(connection = "dataSource1", override = false, assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteListUpdatePersistent.result.xml")
@DatabaseTearDown(connection = "dataSource1", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/whiteListTest/testWhiteListUpdatePersistent.result.xml")
public void testWhiteListUpdatePersistent() {
	Account_ account = accountService.select(1);
	account.setName("bob");
	account.setEmail("[email protected]");
	account.setPassword("bbb");
	account.setStatus(StoryStatus_.p);
	account.setActivateValue(null);
	Role_ role = new Role_();
	role.setId(33);
	account.setRole(role);
	accountService.updatePersistentSimpleNoName(account);
}
 

@Test
@ExpectedDatabase(value = "data-comment-reply-added-limit-exceeded.xml", assertionMode = DatabaseAssertionMode.NON_STRICT)
@DatabaseTearDown(value = "data.xml", type = DatabaseOperation.TRUNCATE_TABLE) // to reset id sequence, otherwise other tests that insert comments will fail on ExpectedDatabase
public void shouldAddReplyToPreviousLevelWhenLimitExceeded() throws Exception {
    for (int i = 3; i <= 9; i++) {
        mockMvc.perform(post("/posts/1/comments/create").with(userBob()).with(csrf())
                .contentType(MediaType.APPLICATION_FORM_URLENCODED)
                .param("commentText", "new comment text")
                .param("parentId", Integer.toString(i)))
                .andExpect(status().isOk())
                .andExpect(jsonPath("$.status", is("ok")));
    }
}