de.akquinet.jbosscc.guttenbase.tools.postgresql.PostgresqlSequenceUpdateTool 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.postgresql;

import java.sql.SQLException;

import de.akquinet.jbosscc.guttenbase.repository.ConnectorRepository;
import de.akquinet.jbosscc.guttenbase.tools.AbstractSequenceUpdateTool;

/**
 * Usually Postgresql creates an autoincrement ID sequence for tables. After data migration these sequences need to be updated...
 * 
 * By default the sequence is updated to SELECT(MAX(ID) + 1) FROM table
 * 
 * © 2012-2020 akquinet tech@spree
 * 
 * @author M. Dahm
 */
public class PostgresqlSequenceUpdateTool extends AbstractSequenceUpdateTool {
  public PostgresqlSequenceUpdateTool(final ConnectorRepository connectorRepository) {
    super(connectorRepository);
  }

  @Override
  public String getSequenceName(final String tableName) throws SQLException {
    return tableName + "_id_seq";
  }

  @Override
  public String getUpdateSequenceClause(final String sequenceName, final long sequenceValue) throws SQLException {
    return "SELECT setval('" + sequenceName + "', " + sequenceValue + ", true);";
  }
}