use of org.dbunit.database.DatabaseConnection in project head by mifos.
the class DatabaseTestUtils method cleanAndInsertDataSet.
private void cleanAndInsertDataSet(DriverManagerDataSource dataSource, IDataSet dataSet) throws DatabaseUnitException, SQLException {
Connection jdbcConnection = null;
ReplacementDataSet replacementDataSet = getDataSetWithNullsReplaced(dataSet);
try {
jdbcConnection = DataSourceUtils.getConnection(dataSource);
IDatabaseConnection databaseConnection = new DatabaseConnection(jdbcConnection);
databaseConnection.getConfig().setProperty(DatabaseConfig.FEATURE_CASE_SENSITIVE_TABLE_NAMES, Boolean.TRUE);
DatabaseOperation.CLEAN_INSERT.execute(databaseConnection, replacementDataSet);
} finally {
if (null != jdbcConnection) {
jdbcConnection.close();
}
DataSourceUtils.releaseConnection(jdbcConnection, dataSource);
}
}
use of org.dbunit.database.DatabaseConnection in project head by mifos.
the class DataSetUpgradeUtil method upgrade.
private void upgrade(String fileName, ApplicationContext applicationContext) throws Exception {
System.out.println("Upgrading: " + fileName);
dbUnitUtilities = new DbUnitUtilities();
IDataSet dataSet = null;
try {
dataSet = dbUnitUtilities.getDataSetFromFile(fileName);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Class.forName("com.mysql.jdbc.Driver");
Connection jdbcConnection = null;
try {
// TODO use same db cxn info that Mifos uses! (local.properties)
jdbcConnection = DriverManager.getConnection(getUrl(databaseName, port, params), user, password);
jdbcConnection.setAutoCommit(false);
resetDatabase(databaseName, jdbcConnection);
SqlExecutor.execute(new FileInputStream(schemaFileName), jdbcConnection);
jdbcConnection.commit();
jdbcConnection.setAutoCommit(true);
IDatabaseConnection databaseConnection = new DatabaseConnection(jdbcConnection);
databaseConnection.getConfig().setProperty(DatabaseConfig.FEATURE_CASE_SENSITIVE_TABLE_NAMES, Boolean.FALSE);
DatabaseOperation.CLEAN_INSERT.execute(databaseConnection, dataSet);
} finally {
if (jdbcConnection != null) {
jdbcConnection.close();
}
}
System.setProperty(TestingService.TEST_MODE_SYSTEM_PROPERTY, "acceptance");
ApplicationInitializer applicationInitializer = new ApplicationInitializer();
applicationInitializer.dbUpgrade(applicationContext);
applicationContext.getBean(DatabaseUpgradeSupport.class).contraction();
applicationInitializer.setAttributesOnContext(null);
StaticHibernateUtil.closeSession();
System.out.println(" upgrade done!");
}
Aggregations