DbSetupConfiguration.java

/**
 * This Source Code Form is subject to the terms of the Mozilla Public License,
 * v. 2.0. If a copy of the MPL was not distributed with this file, You can
 * obtain one at http://mozilla.org/MPL/2.0/. OpenMRS is also distributed under
 * the terms of the Healthcare Disclaimer located at http://openmrs.org/license.
 *
 * Copyright (C) OpenMRS Inc. OpenMRS is a registered trademark and the OpenMRS
 * graphic logo is a trademark of OpenMRS Inc.
 */
package org.openmrs.module.radiology.acceptancetest.dataset;

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;
import javax.sql.DataSource;
import java.sql.SQLException;

import org.dbunit.DatabaseUnitException;
import org.dbunit.database.*;
import org.dbunit.dataset.DataSetException;
import org.dbunit.dataset.xml.FlatXmlDataSet;
import org.dbunit.dataset.xml.FlatXmlProducer;
import org.dbunit.ext.mysql.MySqlDataTypeFactory;
import org.junit.After;
import org.junit.Before;
import org.xml.sax.InputSource;

public class DbSetupConfiguration {
  private DataSource dataSource;
  private IDatabaseConnection databaseConnection;
  public DbTestSelectSupport defaultSelectSupport;

  private static final String JDBC_URL = System.getProperty("db.url");
  private static final String DB_USER = System.getProperty("db.userid");
  private static final String DB_PASSWORD = System.getProperty("db.password");

  @Before
  public void setupConnections() throws SQLException, DatabaseUnitException, ClassNotFoundException {
    MysqlDataSource dataSource = new MysqlDataSource();
    dataSource.setURL(JDBC_URL);
    dataSource.setUser(DB_USER);
    dataSource.setPassword(DB_PASSWORD);
    this.dataSource = dataSource;

    DatabaseConnection databaseConnection = new DatabaseConnection(getDataSource().getConnection());
    databaseConnection.getConfig().setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY, new MySqlDataTypeFactory());
    this.databaseConnection = databaseConnection;

    defaultSelectSupport = new DbTestSelectSupport(getDataSource());
  }

  @After
  public void shutdownConnections() throws SQLException {
    if (databaseConnection != null) {
      databaseConnection.close();
    }
  }

  public DataSource getDataSource() {
    return dataSource;
  }

  public IDatabaseConnection getDatabaseConnection() {
    return databaseConnection;
  }
  
  public FlatXmlDataSet getDataSet(String fileName) throws DataSetException {
    return new FlatXmlDataSet(new FlatXmlProducer(new InputSource(getClass().getResourceAsStream(fileName))));
  }
}