de.akquinet.jbosscc.guttenbase.tools.postgresql.PostgresqlSequenceCreationTool 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 de.akquinet.jbosscc.guttenbase.meta.TableMetaData;
import de.akquinet.jbosscc.guttenbase.repository.ConnectorRepository;
import de.akquinet.jbosscc.guttenbase.tools.AbstractSequenceCreationTool;

import java.sql.SQLException;
import java.util.Arrays;
import java.util.List;

/**
 * Create an autoincrement ID sequence for tables.
 *
 *
 * © 2012-2020 akquinet tech@spree
 *
 * @author M. Dahm
 */
public class PostgresqlSequenceCreationTool extends AbstractSequenceCreationTool
{
  public PostgresqlSequenceCreationTool(final ConnectorRepository connectorRepository)
  {
    super(connectorRepository);
  }

  @Override
  protected String getIdColumn(final TableMetaData tableMetaData)
  {
    return "ID";
  }

  @Override
  public List getCreateSequenceClauses(final String tableName, String idColumn, final String sequenceName, final long start, final long incrementBy)
  {
    return Arrays.asList("CREATE SEQUENCE " + sequenceName +
                    "    START WITH " + start +
                    "    INCREMENT BY " + incrementBy +
                    "    NO MINVALUE\n" +
                    "    NO MAXVALUE\n" +
                    "    CACHE 1;",
            "ALTER SEQUENCE " + sequenceName + " OWNED BY " + tableName + "." + idColumn + ";");
  }

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