Examples with ExpectedDatabase com.github.springtestdbunit.annotation.ExpectedDatabase used on opensource projects

Example 56 with ExpectedDatabase

use of com.github.springtestdbunit.annotation.ExpectedDatabase in project mybatis.flying by limeng32.

the class NullOrNotTest method testNullOrNot.

/**
 * 测试NullOrNot关键字
 */
@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/nullOrNotTest/testNullOrNot.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/nullOrNotTest/testNullOrNot.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/nullOrNotTest/testNullOrNot.xml")
public void testNullOrNot() {
    Account_Condition ac = new Account_Condition();
    ac.setEmailIsNull(true);
    Collection<Account_> accountC = accountService.selectAll(ac);
    Assert.assertEquals(1, accountC.size());
    int count = accountService.count(ac);
    Assert.assertEquals(1, count);
    Account_Condition ac2 = new Account_Condition();
    ac2.setEmailIsNull(false);
    Collection<Account_> accountC2 = accountService.selectAll(ac2);
    Assert.assertEquals(1, accountC2.size());
    int count2 = accountService.count(ac2);
    Assert.assertEquals(1, count2);
    Account_Condition ac3 = new Account_Condition();
    Collection<Account_> accountC3 = accountService.selectAll(ac3);
    Assert.assertEquals(2, accountC3.size());
    int count3 = accountService.count(ac3);
    Assert.assertEquals(2, count3);
    Account_Condition ac4 = new Account_Condition();
    ac4.setRoleIsNull(true);
    Collection<Account_> accountC4 = accountService.selectAll(ac4);
    for (Account_ a : accountC4) {
        Assert.assertEquals("bob", a.getName());
    }
    int count4 = accountService.count(ac4);
    Assert.assertEquals(1, count4);
    Account_Condition ac5 = new Account_Condition();
    ac5.setRoleIsNull(false);
    Collection<Account_> accountC5 = accountService.selectAll(ac5);
    for (Account_ a : accountC5) {
        Assert.assertEquals("ann", a.getName());
    }
    int count5 = accountService.count(ac5);
    Assert.assertEquals(1, count5);
}

Example 57 with ExpectedDatabase

use of com.github.springtestdbunit.annotation.ExpectedDatabase in project mybatis.flying by limeng32.

the class OrTest method testOr6.

/* 一个只有单独入参的或逻辑测试用例 */
@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);
}

Example 58 with ExpectedDatabase

use of com.github.springtestdbunit.annotation.ExpectedDatabase in project mybatis.flying by limeng32.

the class OrTest method testOr7.

/* 一个dbAssociationTypeHandler型外键的或逻辑测试用例 */
@Test
@DatabaseSetup(connection = "dataSource2", type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/orTest/testOr7.datasource2.xml")
@ExpectedDatabase(connection = "dataSource2", assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/orTest/testOr7.datasource2.result.xml")
@DatabaseTearDown(connection = "dataSource2", type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/orTest/testOr7.datasource2.result.xml")
public void testOr7() {
    LoginLogSource2Condition loginLogSource2 = new LoginLogSource2Condition();
    loginLogSource2.setAccountEqualsOr(1L, 2L);
    int i = loginLogSource2Service.count(loginLogSource2);
    Assert.assertEquals(4, i);
}

Example 59 with ExpectedDatabase

use of com.github.springtestdbunit.annotation.ExpectedDatabase in project mybatis.flying by limeng32.

the class OrTest method testOr1.

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/orTest/testOr1.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/orTest/testOr1.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/orTest/testOr1.result.xml")
public void testOr1() {
    LoginLog_Condition lc1 = new LoginLog_Condition();
    lc1.setLoginIPHeadLikeOr("a", "b");
    lc1.setIpLikeFilter("1");
    Collection<LoginLog_> LoginLogC = loginLogService.selectAll(lc1);
    Assert.assertEquals(2, LoginLogC.size());
    LoginLog_Condition lc2 = new LoginLog_Condition();
    lc2.setLoginIPLikeOr("b1", "c1");
    Collection<LoginLog_> LoginLogC2 = loginLogService.selectAll(lc2);
    Assert.assertEquals(2, LoginLogC2.size());
    int c2 = loginLogService.count(lc2);
    Assert.assertEquals(2, c2);
    LoginLog_Condition lc3 = new LoginLog_Condition();
    lc3.setLoginIPHeadLikeOrTailLike("a", "2");
    int c3 = loginLogService.count(lc3);
    Assert.assertEquals(2, c3);
    LoginLog_Condition lc4 = new LoginLog_Condition();
    lc4.setLoginIPEqualsOr("a1", "z3");
    int c4 = loginLogService.count(lc4);
    Assert.assertEquals(2, c4);
    LoginLog_Condition lc5 = new LoginLog_Condition();
    lc5.setLoginIPLikeOr("a1", "b1");
    lc5.setLoginIPEqualsOr("b1", "c1");
    int c5 = loginLogService.count(lc5);
    Assert.assertEquals(1, c5);
    LoginLog_Condition lc6 = new LoginLog_Condition();
    lc6.setNumEqualsOr(1, 2);
    int c6 = loginLogService.count(lc6);
    Assert.assertEquals(2, c6);
    LoginLog_Condition lc7 = new LoginLog_Condition();
    lc7.setNumEqualsOrLoginIPLike(1, "b1");
    Collection<LoginLog_> LoginLogC7 = loginLogService.selectAll(lc7);
    Assert.assertEquals(2, LoginLogC7.size());
    LoginLog_ l1 = new LoginLog_();
    l1.setLoginIP("a1");
    LoginLog_ loginLog_1 = loginLogService.selectOne(l1);
    LoginLog_ l2 = new LoginLog_();
    l2.setLoginIP("b1");
    LoginLog_ loginLog_2 = loginLogService.selectOne(l2);
    LoginLog_Condition lc8 = new LoginLog_Condition();
    lc8.setLoginTimeEqualsOr(loginLog_1.getLoginTime(), loginLog_2.getLoginTime());
    int c8 = loginLogService.count(lc8);
    Assert.assertEquals(2, c8);
    LoginLog_Condition lc9 = new LoginLog_Condition();
    lc9.setStatusEqualsOr(LogStatus.b, LogStatus.t);
    int c9 = loginLogService.count(lc9);
    Assert.assertEquals(2, c9);
    LoginLog_Condition lc10 = new LoginLog_Condition();
    lc10.setLoginIPNotEqualsOr("z2", "z3");
    int c10 = loginLogService.count(lc10);
    Assert.assertEquals(6, c10);
    LoginLog_Condition lc11 = new LoginLog_Condition();
    lc11.setNumGtOrLt(5, 2);
    int c11 = loginLogService.count(lc11);
    Assert.assertEquals(2, c11);
    LoginLog_Condition lc12 = new LoginLog_Condition();
    lc12.setNumGeOrLe(5, 2);
    int c12 = loginLogService.count(lc12);
    Assert.assertEquals(4, c12);
    LoginLog_Condition lc13 = new LoginLog_Condition();
    Object[] o13 = { 5, 2 };
    lc13.setNumGtOrLe(o13);
    int c13 = loginLogService.count(lc13);
    Assert.assertEquals(3, c13);
    LoginLog_Condition lc14 = new LoginLog_Condition();
    lc14.setNumGeOrLt(5, 2);
    int c14 = loginLogService.count(lc14);
    Assert.assertEquals(3, c14);
    LoginLog_Condition lc15 = new LoginLog_Condition();
    Object[] o15 = { true, false };
    lc15.setStatusIsNullOr(o15);
    int c15 = loginLogService.count(lc15);
    Assert.assertEquals(6, c15);
    LoginLog_Condition lc16 = new LoginLog_Condition();
    // 最后一个参数无意义
    lc16.setStatusIsNullOrLoginIPEquals(false, "a1", "b1", "c1");
    int c16 = loginLogService.count(lc16);
    Assert.assertEquals(4, c16);
}

Example 60 with ExpectedDatabase

use of com.github.springtestdbunit.annotation.ExpectedDatabase in project mybatis.flying by limeng32.

the class SelectOneTest method testSelectOne3.

/**
 * 测试selectOne3，缓存测试
 */
@Test
@DatabaseSetup(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/selectOneTest/testSelectOne3.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/selectOneTest/testSelectOne3.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/selectOneTest/testSelectOne3.result.xml")
public void testSelectOne3() {
    Account_ a1 = new Account_();
    a1.setName("ann");
    accountService.insert(a1);
    Account_ a2 = new Account_();
    a2.setName("bob");
    accountService.insert(a2);
    Account_ ac = new Account_();
    Account_ account1 = accountService.selectOne(ac);
    Assert.assertEquals("ann", account1.getName());
    Collection<Account_> accountC = accountService.selectAll(ac);
    Assert.assertEquals(2, accountC.size());
}