Skip navigation

Database testing – putting everything together

  • Create – database instance is not necessary
  • Prepare – clean tables, load data to datasource
  • Assert – verify your datasource contains expected data
@Test
public void testGetCustomerFromDao()
{
	//business dao object
	final CustomerDao customerDao = new CustomerDao();

	// initialize DbAssert
	final DbAssert dbAssert = DbAssert.init("org/testfw/TestSource.xml");

	// create a "fake" datasource. Stanalone instance of HSQLDB will be created (no database required).
	final DbSource myTestSource = dbAssert.fake_source("testSrc","org/testfw/testSourceSchema.sql", getClass());

	// clean "customers" table
	myTestSource.clean_table("customers");

	//load data from customers.yml file
	final Fixture customerFixtures = myTestSource.fixture("customers");
	final Fixture customer_one  = (Fixture) customerFixtures.get("customer_one");

	//make an assertion
	assertEquals(customer_one.get("name"), customerDao.findById(customer_one.get("id")));
}

One Trackback/Pingback

  1. [...] tools. You could see posts about asserting data, putting the datastore to a known state and about mocking it up. I started working on it because I didn’t really like what dbUnit offered at that moment. I [...]

Post a Comment

Your email is never published nor shared. Required fields are marked *
*
*