/*
* Copyright 2010 Inera
*
* This library is free software; you can redistribute it and/or modify
* it under the terms of version 2.1 of the GNU Lesser General Public
*
* License as published by the Free Software Foundation.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
*
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the
* Free Software Foundation, Inc., 59 Temple Place, Suite 330,
*
* Boston, MA 02111-1307 USA
*/
package se.inera.ifv.util;
import java.io.ByteArrayInputStream;
import org.dbunit.database.DatabaseDataSourceConnection;
import org.dbunit.database.IDatabaseConnection;
import org.dbunit.dataset.xml.FlatXmlDataSet;
import org.dbunit.operation.DatabaseOperation;
import org.junit.After;
import org.junit.Before;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.AbstractTransactionalJUnit4SpringContextTests;
/**
* Base test case class for handling the dbunit connection. The database is not rollbacked after the test transaction
* is finished. Utilty method that is always called after the transaction.
* Utility methods for retrieving the dbunit database connection.
*/
@ContextConfiguration(locations = { "classpath:casebox-services-test.xml" })
public abstract class DbunitTestBase extends AbstractTransactionalJUnit4SpringContextTests {
private static String DELETE_DATASET =
"<dataset>"
+ "<ANSWER />"
+ "<QUESTION />"
+ "</dataset>";
private static final Logger log = LoggerFactory.getLogger(DbunitTestBase.class);
private IDatabaseConnection conn;
@Autowired
private DriverManagerDataSource dataSource;
/**
* Should not be possible to override the onSetup method that is always called before the transaction.
* @throws Exception
*/
@Before
public final void onSetup() throws Exception {
log.debug("onSetup(): creating dbunit connection.");
conn = new DatabaseDataSourceConnection(dataSource);
}
/**
* Returns a dbunit database connection that is not commit to the database.
* @return {@link IDatabaseConnection}
*/
public IDatabaseConnection getConnection() {
return conn;
}
/**
* Should not be possible to override the onTearDown method that is always called after the transaction to
* roll back the database.
* @throws Exception
*/
@After
public final void onTearDown() throws Exception {
ByteArrayInputStream is = new ByteArrayInputStream(DELETE_DATASET.getBytes());
FlatXmlDataSet xmlDataSet = new FlatXmlDataSet(is);
DatabaseOperation.DELETE_ALL.execute(getConnection(), xmlDataSet);
log.debug("onTearDown(): rollback dbunit connection. Delete all in database.");
}
}