/**
 * Copyright (C) 2009 - present by OpenGamma Inc. and the OpenGamma group of companies
 *
 * Please see distribution for license.
 */
package com.opengamma.util.db;

import java.sql.Driver;

import org.hibernate.dialect.Dialect;
import org.hibernate.dialect.PostgreSQLDialect;

import com.opengamma.elsql.ElSqlConfig;

/**
 * Database dialect for Postgres databases.
 * <p>
 * This contains any Postgres specific SQL and is tested for version 8.4 and 9.1.
 */
public class PostgresDbDialect extends DbDialect {

  /**
   * Helper can be treated as a singleton.
   */
  public static final PostgresDbDialect INSTANCE = new PostgresDbDialect();

  /**
   * Restrictive constructor.
   */
  public PostgresDbDialect() {
  }

  //-------------------------------------------------------------------------
  @Override
  public Class<? extends Driver> getJDBCDriverClass() {
    return org.postgresql.Driver.class;
  }

  @Override
  protected Dialect createHibernateDialect() {
    return new PostgreSQLDialect();
  }

  @Override
  protected ElSqlConfig createElSqlConfig() {
    return ElSqlConfig.POSTGRES;
  }

  //-------------------------------------------------------------------------
  @Override
  public String sqlNextSequenceValueSelect(final String sequenceName) {
    return "SELECT nextval('" + sequenceName + "')";
  }

  @Override
  public String sqlNextSequenceValueInline(final String sequenceName) {
    return "nextval('" + sequenceName + "')";
  }

}