telephony.test.TestDatabaseConnectionFactory.java Source code

Introduction

Here is the source code for telephony.test.TestDatabaseConnectionFactory.java

Source

/**
 * Copyright (C) 2011-2012 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *         http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
/**
 *
 */
package telephony.test;

import com.googlecode.flyway.test.dbunit.DefaultDatabaseConnectionFactory;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.dbunit.DatabaseUnitException;
import org.dbunit.database.DatabaseConnection;
import org.dbunit.database.IDatabaseConnection;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;

/**
 * Helper class to show how a connection factory can be changed or extend.
 *
 * @author Florian
 * @version 1.7
 * @since 1.7.0
 * @version 2012-10-02
 *
 */
public class TestDatabaseConnectionFactory extends DefaultDatabaseConnectionFactory {

    // @@ Construction
    protected final Log logger = LogFactory.getLog(getClass());

    @Override
    public IDatabaseConnection createConnection(final Connection con, final DatabaseMetaData databaseMetaData)
            throws SQLException, DatabaseUnitException {

        logger.warn(String.format(">>>>> %s invoked to create a connection!\n", this.getClass().getSimpleName()));

        IDatabaseConnection connection = null;

        // FIXME not nice I found not a fast possibility to generate inside H2
        // the tables inside a
        // schema as oracle do.
        final String driverName = databaseMetaData.getDriverName();

        if (driverName.toLowerCase().contains("oracle")) {
            // oracle schema name is the user name
            connection = new DatabaseConnection(con, databaseMetaData.getUserName().toUpperCase());
        } else {
            if (driverName.contains("H2")) {
                // H2
                connection = new DatabaseConnection(con);
            } else if (driverName.contains("postgresql")) {
                // postgresql
                connection = new DatabaseConnection(con, "public");
            } else {
                // all other
                connection = new DatabaseConnection(con);
            }
        }

        logger.warn(
                String.format("<<<<<  %s returns connection %s!\n", this.getClass().getSimpleName(), connection));

        // final DatabaseConfig config = connection.getConfig();
        // // oracle 10g
        // // FIXME at the moment we have a hard coded oracle notation
        // config.setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY, new
        // Oracle10DataTypeFactory());

        return connection;

    }

}