org.databene.platform.db.ConnectionHolder Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of databene-benerator Show documentation

benerator is a framework for creating realistic and valid high-volume test data, used for testing (unit/integration/load) and showcase setup. Metadata constraints are imported from systems and/or configuration files. Data can imported from and exported to files and systems, anonymized or generated from scratch. Domain packages provide reusable generators for creating domain-specific data as names and addresses internationalizable in language and region. It is strongly customizable with plugins and configuration options.

The newest version!

/*
 * (c) Copyright 2013 by Volker Bergmann. All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, is permitted under the terms of the
 * GNU General Public License (GPL).
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
 * WITHOUT A WARRANTY OF ANY KIND. ALL EXPRESS OR IMPLIED CONDITIONS,
 * REPRESENTATIONS AND WARRANTIES, INCLUDING ANY IMPLIED WARRANTY OF
 * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT, ARE
 * HEREBY EXCLUDED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE
 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
 * POSSIBILITY OF SUCH DAMAGE.
 */

package org.databene.platform.db;

import java.io.Closeable;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import org.databene.commons.LogCategories;
import org.databene.commons.OrderedMap;
import org.databene.jdbacl.ColumnInfo;
import org.databene.jdbacl.DBUtil;
import org.databene.jdbacl.model.DBTable;
import org.databene.model.data.ComplexTypeDescriptor;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 * Wraps a database connection and provides access functionality.


 * Created: 07.01.2013 08:28:36
 * @since 0.8.0
 * @author Volker Bergmann
 */
public class ConnectionHolder implements Closeable {

	private static final Logger JDBC_LOGGER = LoggerFactory.getLogger(LogCategories.JDBC);
	
	private DBSystem db;
    private Connection connection;
    
    public Map insertStatements;
    public Map updateStatements;
    public Map selectByPKStatements;
    
    public ConnectionHolder(DBSystem db) {
    	this.insertStatements = new OrderedMap();
    	this.updateStatements = new OrderedMap();
    	this.selectByPKStatements = new OrderedMap();
        this.db = db;
        this.connection = null; // lazily initialized
    }
    
	public Connection getConnection() {
		if (connection == null)
	        this.connection = db.createConnection();
		return connection;
	}
    
    public void commit() {
        try {
			flushStatements(insertStatements);
			flushStatements(updateStatements);
            JDBC_LOGGER.debug("Committing connection: {}" + connection);
            getConnection().commit();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

	private void flushStatements(Map statements) throws SQLException {
		for (Map.Entry entry : statements.entrySet()) {
		    PreparedStatement statement = entry.getValue();
		    if (statement != null) {
		        // need to finish old statement
	            if (db.isBatch())
	                statement.executeBatch();
	            JDBC_LOGGER.debug("Closing statement: {}", statement);
		        DBUtil.close(statement);
		    }
		    entry.setValue(null);
		}
	}

    public PreparedStatement getSelectByPKStatement(ComplexTypeDescriptor descriptor) {
        try {
            PreparedStatement statement = selectByPKStatements.get(descriptor);
            if (statement == null)
                statement = createSelectByPKStatement(descriptor);
            else
                statement.clearParameters();
            return statement;
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

	private PreparedStatement createSelectByPKStatement(ComplexTypeDescriptor descriptor) throws SQLException {
        PreparedStatement statement;
        String tableName = descriptor.getName();
        DBTable table = db.getTable(tableName.toUpperCase());
        if (table == null)
        	throw new IllegalArgumentException("Table not found: " + tableName);
        StringBuilder builder = new StringBuilder("select * from ").append(tableName).append(" where");
        for (String idColumnName : descriptor.getIdComponentNames())
        	builder.append(' ').append(idColumnName).append("=?");
        statement = DBUtil.prepareStatement(getConnection(), builder.toString(), db.isReadOnly());
    	selectByPKStatements.put(descriptor, statement);
        return statement;
    }

    public PreparedStatement getStatement(ComplexTypeDescriptor descriptor, boolean insert, List columnInfos) {
        try {
            PreparedStatement statement = (insert ? insertStatements.get(descriptor) : updateStatements.get(descriptor));
            if (statement == null)
                statement = createStatement(descriptor, insert, columnInfos);
            else
                statement.clearParameters();
            return statement;
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

	private PreparedStatement createStatement(ComplexTypeDescriptor descriptor, boolean insert,
            List columnInfos) throws SQLException {
        PreparedStatement statement;
        String tableName = descriptor.getName();
        DBTable table = db.getTable(tableName.toUpperCase());
        if (table == null)
        	throw new IllegalArgumentException("Table not found: " + tableName);
        String sql = (insert ? 
        		db.getDialect().insert(table, columnInfos) : 
        		db.getDialect().update(table, db.getTable(tableName).getPKColumnNames(), columnInfos));
        JDBC_LOGGER.debug("Creating prepared statement: {}", sql);
        statement = DBUtil.prepareStatement(getConnection(), sql, db.isReadOnly());
        if (insert)
        	insertStatements.put(descriptor, statement);
        else
        	updateStatements.put(descriptor, statement);
        return statement;
    }

    @Override
	public void close() {
        commit();
        DBUtil.close(connection);
    }
    
}