@Test public void singleTestingEntityData() { Assert.assertEquals(0, em.createQuery("select t from TestingEntity t").getResultList().size()); this.createDbDataUtil().buildImport() .from("/datasets/singleTestingEntityData.xml") .executeInsert(); Assert.assertEquals(1, em.createQuery("select t from TestingEntity t").getResultList().size()); this.createDbDataUtil().buildAssert() .expected(JuUrl.resource().relativeTo(BaseDbTest.class).get("BaseDbTest_singleTestingEntityData.xml")) .assertEqualsTable("TestingEntity", "id"); } }
/** * Asserts that a specific table export equals the data in an XML file. */ @Test public void assertEqualsTables() { // du.buildExport() // .addTable("team", "select * from team order by name") // .writeToXmlFile("teamExport.xml"); this.createDbDataUtil().buildAssert() .expected(JuUrl.resource().relativeTo(DbDataUtilTest.class).get("DbDataUtilsTest_assertEqualsTables.xml")) .assertEqualsTable("team", "name"); } }
/** * Path to XML of expected data. * @param resourcePath Resource path, either absolute or relative to the current class * @return AssertBuilder */ public AssertBuilder expected(String resourcePath) { URL url = JuUrl.resource().relativeTo(ReflectUtils.getCallingClass()).get(resourcePath); return expected(url); }
/** * Returns a new AssertBuilder to assert that table data equals expected data * specified in an XML file. * @return AssertBuilder instance */ public AssertBuilder buildAssert() { return new AssertBuilder(this); }
/** * Makes sure that a DefaultDataSet of NONE contains no data. */ @Test public void noData() { this.createDbDataUtil().buildAssert() .expected(JuUrl.resource().relativeTo(BaseDbTest.class).get("BaseDbTest_noData.xml")) .assertEqualsAll(); }
/** * Asserts that the complete DB export equals the data in an XML file. */ @Test public void assertEqualsAll() { // // Can be used to create full export XML // du.buildExport().writeToXmlFile("completeExport.xml"); this.createDbDataUtil().buildAssert() .expected(JuUrl.resource().relativeTo(DbDataUtilTest.class).get("DbDataUtilsTest_assertEqualsAll.xml")) .assertEqualsAll(); }
@Test(expected=ComparisonFailure.class) public void assert_canAssertTables_failsOnWrongData() { DbSchemaUtil ds = new DbSchemaUtil(this.em); ds.prepareDefaultTestData(true, true, true); DbDataUtil du = new DbDataUtil(this.emUtil); du.cleanImport("/ch/inftec/ju/testing/db/DbDataUtilTest_testingEntity_unsorted.xml"); du.buildAssert() .expected("/ch/inftec/ju/testing/db/DbDataUtilTest_testingEntity.xml") .assertEquals(); }
@Test public void assert_canAssertTables() { DbSchemaUtil ds = new DbSchemaUtil(this.em); ds.prepareDefaultTestData(true, true, true); DbDataUtil du = new DbDataUtil(this.emUtil); du.cleanImport("/ch/inftec/ju/testing/db/DbDataUtilTest_testingEntity_unsorted.xml"); du.buildAssert() .expected("/ch/inftec/ju/testing/db/DbDataUtilTest_testingEntity_sorted.xml") .assertEquals(); }