/*
*
* The DbUnit Database Testing Framework
* Copyright (C)2002-2004, DbUnit.org
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* 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 org.dbunit.database;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.dbunit.DatabaseUnitRuntimeException;
import org.dbunit.database.statement.IStatementFactory;
import org.dbunit.dataset.DataSetException;
import org.dbunit.dataset.FilteredDataSet;
import org.dbunit.dataset.IDataSet;
import org.dbunit.dataset.ITable;
import org.dbunit.util.QualifiedTableName;
import org.dbunit.util.SQLHelper;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
/**
* @author Manuel Laflamme
* @version $Revision: 1186 $
* @since Mar 6, 2002
*/
public abstract class AbstractDatabaseConnection implements IDatabaseConnection
{
/**
* Logger for this class
*/
private static final Logger logger = LoggerFactory.getLogger(AbstractDatabaseConnection.class);
private IDataSet _dataSet = null;
private final DatabaseConfig _databaseConfig;
public AbstractDatabaseConnection()
{
_databaseConfig = new DatabaseConfig();
}
////////////////////////////////////////////////////////////////////////////
// IDatabaseConnection interface
public IDataSet createDataSet() throws SQLException
{
logger.debug("createDataSet() - start");
if (_dataSet == null)
{
_dataSet = new DatabaseDataSet(this);
}
return _dataSet;
}
public IDataSet createDataSet(String[] tableNames)
throws DataSetException, SQLException
{
logger.debug("createDataSet(tableNames={}) - start", tableNames);
return new FilteredDataSet(tableNames, createDataSet());
}
public ITable createQueryTable(String resultName, String sql)
throws DataSetException, SQLException
{
logger.debug("createQueryTable(resultName={}, sql={}) - start", resultName, sql);
IResultSetTableFactory tableFactory = getResultSetTableFactory();
IResultSetTable rsTable = tableFactory.createTable(resultName, sql, this);
logger.debug("createQueryTable: rowCount={}", Integer.valueOf(rsTable
.getRowCount()));
return rsTable;
}
public ITable createTable(String resultName, PreparedStatement preparedStatement)
throws DataSetException, SQLException
{
logger.debug("createQueryTable(resultName={}, preparedStatement={}) - start", resultName, preparedStatement);
IResultSetTableFactory tableFactory = getResultSetTableFactory();
IResultSetTable rsTable = tableFactory.createTable(resultName, preparedStatement, this);
return rsTable;
}
public ITable createTable(String tableName) throws DataSetException,
SQLException
{
logger.debug("createTable(tableName={}) - start", tableName);
if (tableName == null) {
throw new NullPointerException("The parameter 'tableName' must not be null");
}
String sql = "select * from " + tableName; // TODO Think about QualifiedTableNames here - needed or not?
return this.createQueryTable(tableName, sql);
}
public int getRowCount(String tableName) throws SQLException
{
logger.debug("getRowCount(tableName={}) - start", tableName);
return getRowCount(tableName, null);
}
public int getRowCount(String tableName, String whereClause) throws SQLException
{
logger.debug("getRowCount(tableName={}, whereClause={}) - start", tableName, whereClause);
StringBuffer sqlBuffer = new StringBuffer(128);
sqlBuffer.append("select count(*) from ");
//add table name and schema (schema only if available)
QualifiedTableName qualifiedTableName = new QualifiedTableName(tableName, this.getSchema());
String qualifiedName = qualifiedTableName.getQualifiedName();
sqlBuffer.append(qualifiedName);
if (whereClause != null)
{
sqlBuffer.append(" ");
sqlBuffer.append(whereClause);
}
Statement statement = getConnection().createStatement();
ResultSet resultSet = null;
try
{
resultSet = statement.executeQuery(sqlBuffer.toString());
if(resultSet.next()) {
return resultSet.getInt(1);
} else {
throw new DatabaseUnitRuntimeException("Select count did not return any results for table '" +
tableName + "'. Statement: " + sqlBuffer.toString());
}
}
finally
{
SQLHelper.close(resultSet, statement);
}
}
public DatabaseConfig getConfig()
{
return _databaseConfig;
}
/**
* @deprecated Use {@link #getConfig}
*/
public IStatementFactory getStatementFactory()
{
return (IStatementFactory)_databaseConfig.getProperty(DatabaseConfig.PROPERTY_STATEMENT_FACTORY);
}
private IResultSetTableFactory getResultSetTableFactory()
{
return (IResultSetTableFactory)_databaseConfig.getProperty(DatabaseConfig.PROPERTY_RESULTSET_TABLE_FACTORY);
}
public String toString()
{
StringBuffer sb = new StringBuffer();
sb.append("_databaseConfig=").append(_databaseConfig);
sb.append(", _dataSet=").append(_dataSet);
return sb.toString();
}
}