de.akquinet.jbosscc.guttenbase.tools.MinMaxIdSelectorTool Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of GuttenBase Show documentation

Copying done right...

There is a newer version: 2.1.0

package de.akquinet.jbosscc.guttenbase.tools;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import de.akquinet.jbosscc.guttenbase.connector.Connector;
import de.akquinet.jbosscc.guttenbase.hints.TableNameMapperHint;
import de.akquinet.jbosscc.guttenbase.mapping.TableNameMapper;
import de.akquinet.jbosscc.guttenbase.meta.TableMetaData;
import de.akquinet.jbosscc.guttenbase.repository.ConnectorRepository;
import de.akquinet.jbosscc.guttenbase.statements.SplitByColumnSelectMinMaxStatementCreator;

/**
 * Compute MIN and MAX of given Id-Column
 * 
 * 
 * © 2012 akquinet tech@spree
 * 
 * 
 * @Uses-Hint {@link TableNameMapperHint}
 * @author M. Dahm
 */
public class MinMaxIdSelectorTool {
  private final ConnectorRepository _connectorRepository;
  private long _minValue;
  private long _maxValue;

  public MinMaxIdSelectorTool(final ConnectorRepository connectorRepository) {
    assert connectorRepository != null : "connectorRepository != null";
    _connectorRepository = connectorRepository;
  }

  /**
   * Compute MIN and MAX of given Id-Column
   */
  public void computeMinMax(final String connectorId, final TableMetaData tableMetaData) throws SQLException {
    final Connector connector = _connectorRepository.createConnector(connectorId);
    final Connection connection = connector.openConnection();

    computeMinMax(connectorId, tableMetaData, connection);

    connector.closeConnection();
  }

  /**
   * Compute MIN and MAX of given Id-Column using existing connection
   */
  public void computeMinMax(final String connectorId, final TableMetaData tableMetaData, final Connection connection) throws SQLException {
    final TableNameMapper tableNameMapper = _connectorRepository.getConnectorHint(connectorId, TableNameMapper.class).getValue();
    final String tableName = tableNameMapper.mapTableName(tableMetaData);
    final PreparedStatement minMaxStatement = new SplitByColumnSelectMinMaxStatementCreator(_connectorRepository, connectorId)
        .createSelectStatement(tableName, tableMetaData, connection);

    final ResultSet rangeResultSet = minMaxStatement.executeQuery();
    rangeResultSet.next();

    _minValue = rangeResultSet.getLong(1);
    _maxValue = rangeResultSet.getLong(2);
    minMaxStatement.close();
  }

  public long getMinValue() {
    return _minValue;
  }

  public long getMaxValue() {
    return _maxValue;
  }
}