use of indi.mybatis.flying.pojo.condition.Account_Condition in project mybatis.flying by limeng32.
the class ConditionNotInTest method testConditionNotIn.
/**
* 测试无外键情况下condition:notIn功能
*/
@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/conditionNotInTest/testConditionIn.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/conditionNotInTest/testConditionIn.xml")
public void testConditionNotIn() {
Account_Condition ac = new Account_Condition();
List<String> nameC = new ArrayList<>();
nameC.add("ann");
ac.setNameNotIn(nameC);
Collection<Account_> c = accountService.selectAll(ac);
Assert.assertEquals(1, c.size());
nameC.add("bob");
Collection<Account_> c2 = accountService.selectAll(ac);
Assert.assertEquals(0, c2.size());
List<String> nameC2 = new ArrayList<>();
ac.setNameNotIn(nameC2);
Collection<Account_> c3 = accountService.selectAll(ac);
Assert.assertEquals(2, c3.size());
}
use of indi.mybatis.flying.pojo.condition.Account_Condition in project mybatis.flying by limeng32.
the class ConditionNotInTest method testConditionNotIn3.
/**
* 测试无外键情况下condition:notIn功能且变量类型为数字的情况
*/
@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/conditionNotInTest/testConditionIn3.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/conditionNotInTest/testConditionIn3.xml")
public void testConditionNotIn3() {
Account_Condition ac = new Account_Condition();
List<Integer> opLockC = new ArrayList<>();
opLockC.add(1);
opLockC.add(2);
ac.setOpLockNotIn(opLockC);
int count = accountService.count(ac);
Assert.assertEquals(0, count);
}
use of indi.mybatis.flying.pojo.condition.Account_Condition in project mybatis.flying by limeng32.
the class ConditionTest method testSorterWithMultiAssociation.
/**
* 测试多重外键情况下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());
}
use of indi.mybatis.flying.pojo.condition.Account_Condition in project mybatis.flying by limeng32.
the class ConditionTest method testConditionLike.
/**
* 测试condition:like功能
*/
@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/conditionTest/testConditionLike.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/conditionTest/testConditionLike.xml")
public void testConditionLike() {
Account_Condition ac = new Account_Condition();
ac.setEmailLike("%%");
Collection<Account_> c = accountService.selectAll(ac);
Account_[] accounts = c.toArray(new Account_[c.size()]);
Assert.assertEquals(1, accounts.length);
Assert.assertEquals("an%%n@live.cn", accounts[0].getEmail());
Account_Condition ac2 = new Account_Condition();
ac2.setEmailNotLike("%%");
List<Account_> l = accountService.selectAll(ac2);
Assert.assertEquals(1, l.size());
Assert.assertEquals("bob@live.cn", l.get(0).getEmail());
}
use of indi.mybatis.flying.pojo.condition.Account_Condition in project mybatis.flying by limeng32.
the class ConditionTest method testConditionLike2.
/**
* 测试condition:like功能2:在parameter为null和为空字符串时的情况
*/
@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/conditionTest/testConditionLike2.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/conditionTest/testConditionLike2.xml")
public void testConditionLike2() {
Account_Condition ac = new Account_Condition(), ac2 = new Account_Condition();
ac.setEmailLike(null);
Collection<Account_> c = accountService.selectAll(ac);
Account_[] accounts = c.toArray(new Account_[c.size()]);
Assert.assertEquals(2, accounts.length);
ac2.setEmailLike("");
Collection<Account_> c2 = accountService.selectAll(ac);
Assert.assertEquals(2, c2.size());
}
Aggregations