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

Example 21 with DatabaseTearDown

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

the class ConditionNotInTest method testConditionNotIn2.

/**
 * 测试有外键情况下condition:notIn功能
 */
@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/conditionNotInTest/testConditionIn2.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/conditionNotInTest/testConditionIn2.xml")
public void testConditionNotIn2() {
    LoginLog_Condition lc = new LoginLog_Condition();
    Account_Condition ac = new Account_Condition();
    List<String> nameC = new ArrayList<>();
    nameC.add("ann");
    nameC.add("bob");
    ac.setNameNotIn(nameC);
    lc.setAccount(ac);
    Collection<LoginLog_> c = loginLogService.selectAll(lc);
    Assert.assertEquals(0, c.size());
    int count = loginLogService.count(lc);
    Assert.assertEquals(0, count);
}

Example 22 with DatabaseTearDown

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

the class ConditionTest method testMultiLikeAND.

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/conditionTest/testMultiLikeAND.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/conditionTest/testMultiLikeAND.xml")
public void testMultiLikeAND() {
    Account_Condition ac = new Account_Condition();
    ac.setName("ann");
    ac.setEmailLike("as");
    List<String> multi = new ArrayList<>();
    multi.add("a");
    multi.add("s");
    multi.add("d");
    ac.setMultiLike(multi);
    Collection<Account_> c = accountService.selectAll(ac);
    Assert.assertEquals(1, c.size());
    int conut = accountService.count(ac);
    Assert.assertEquals(1, conut);
    Account_Condition ac2 = new Account_Condition();
    ac2.setName("ann");
    ac2.setEmailLike("as");
    List<String> multi2 = new LinkedList<>();
    ac2.setMultiLike(multi2);
    Collection<Account_> c2 = accountService.selectAll(ac2);
    Assert.assertEquals(1, c2.size());
    Account_Condition ac3 = new Account_Condition();
    List<String> multi3 = new ArrayList<>();
    multi3.add(null);
    multi3.add("a");
    multi3.add(null);
    ac3.setMultiLike(multi3);
    Collection<Account_> c3 = accountService.selectAll(ac3);
    Assert.assertEquals(1, c3.size());
    LoginLog_ lc = new LoginLog_();
    Account_Condition ac4 = new Account_Condition();
    List<String> multi4 = new ArrayList<>();
    multi4.add("a");
    ac4.setMultiLike(multi4);
    lc.setAccount(ac4);
    Collection<LoginLog_> c4 = loginLogService.selectAll(lc);
    Assert.assertEquals(1, c4.size());
}

Example 23 with DatabaseTearDown

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

the class KeyGeneratorTest method test1.

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/keyGeneratorTest/test1.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT_UNORDERED, value = "/indi/mybatis/flying/test/keyGeneratorTest/test1.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/keyGeneratorTest/test1.xml")
public void test1() {
    Product product = productService.select("a");
    Assert.assertEquals("n", product.getName());
    Product product2 = new Product();
    product2.setName("n2");
    product2.setName2("asd");
    productService.insert(product2);
    Assert.assertEquals(32, product2.getId().length());
    Product p = new Product();
    p.setName("n2");
    Product product_ = productService.selectOne(p);
    Assert.assertEquals(32, product_.getId().length());
    Product product3 = new Product();
    product3.setId("cc");
    product3.setName("n3");
    productService.insert2(product3);
    Assert.assertEquals("cc", product3.getId());
    Product p2 = new Product();
    p2.setName("n3");
    Product product2_ = productService.selectOne(p2);
    Assert.assertEquals("cc", product2_.getId());
    Product product4 = new Product();
    product4.setId("dd");
    product4.setName("n4");
    productService.insert3(product4);
    Assert.assertEquals("dd", product4.getId());
    Product p3 = new Product();
    p3.setName("n4");
    Product product3_ = productService.selectOne(p3);
    Assert.assertEquals("dd", product3_.getId());
    Product product5 = new Product();
    product5.setName("n5");
    productService.insertMilliSecond(product5);
    Product p5 = new Product();
    p5.setName("n5");
    Product product5_ = productService.selectOne(p5);
    Assert.assertEquals(product5.getId(), product5_.getId());
    Product product6 = new Product();
    product6.setName("n6");
    productService.insertSnowFlake(product6);
    Product product9 = new Product();
    product9.setName("n9");
    productService.insertSnowFlake(product9);
    Product product10 = new Product();
    product10.setName("n10");
    productService.insertSnowFlake(product10);
    Product p6 = new Product();
    p6.setName("n6");
    Product product6_ = productService.selectOne(p6);
    Assert.assertEquals(product6.getId(), product6_.getId());
    // Product product7 = new Product();
    // product7.setName("n7");
    // productService.insertMilliSecond(product7);
    // Product p7 = new Product();
    // p7.setName("n7");
    // Product product7_ = productService.selectOne(p7);
    // Assert.assertEquals(product7.getId(), product7_.getId());
    // Product product8 = new Product();
    // product8.setName("n8");
    // productService.insertMilliSecond2(product8);
    // 
    // Product p8 = new Product();
    // p8.setName("n8");
    // Product product8_ = productService.selectOne(p8);
    // Assert.assertEquals(product8.getId(), product8_.getId());
    Product product11 = new Product();
    product11.setName("n11");
    productService.insertMySnowFlake(product11);
    Product product12 = new Product();
    product12.setName("n12");
    productService.insertMySnowFlake(product12);
    Product product13 = new Product();
    product13.setName("n13");
    productService.insertMySnowFlake2(product13);
    Assert.assertNull(product13.getId());
    Product product14 = new Product();
    product14.setName("n14");
    productService.insertAsd(product14);
    Assert.assertEquals("asd", product14.getId());
    Product product15 = new Product();
    product15.setName("n15");
    productService.insertDistributedSnowflake(product15);
    Product product16 = new Product();
    product16.setName("n16");
    productService.insertDistributedSnowflake(product16);
    Product product17 = new Product();
    product17.setName("n17");
    productService.insertDistributedSnowflake(product17);
    Product p15 = new Product();
    p15.setName("n15");
    Product product15_ = productService.selectOne(p15);
    Assert.assertEquals(product15.getId(), product15_.getId());
}

Example 24 with DatabaseTearDown

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

the class LoginLogTest method testInsert.

/**
 * 测试insert功能（无乐观锁）
 */
@Test
@DatabaseSetup(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/loginLogTest/testInsert.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/loginLogTest/testInsert.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/loginLogTest/testInsert.xml")
public void testInsert() {
    LoginLog_ a = new LoginLog_();
    a.setId(1);
    a.setLoginIP("0.0.0.1");
    loginLogService.insert(a);
}

Example 25 with DatabaseTearDown

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

the class OrTest method testOr5.

@Test
@DatabaseSetup(type = DatabaseOperation.CLEAN_INSERT, value = "/indi/mybatis/flying/test/orTest/testOr5.xml")
@ExpectedDatabase(assertionMode = DatabaseAssertionMode.NON_STRICT, value = "/indi/mybatis/flying/test/orTest/testOr5.result.xml")
@DatabaseTearDown(type = DatabaseOperation.DELETE_ALL, value = "/indi/mybatis/flying/test/orTest/testOr5.result.xml")
public void testOr5() {
    LoginLog_Condition lc = new LoginLog_Condition();
    lc.setAccount(new Account_Condition());
    lc.getAccount().setRole(new Role_Condition());
    lc.getAccount().setRoleDeputy(new Role_Condition());
    ((Role_Condition) lc.getAccount().getRole()).setNameEqualsOrAccountNameEquals("user", "bob");
    ((Role_Condition) lc.getAccount().getRoleDeputy()).setNameEqualsOrAccountNameEquals("silver", "bob");
    Collection<LoginLog_> loginLogC = loginLogService.selectAll(lc);
    Assert.assertEquals(2, loginLogC.size());
}