001/*
002 * Sonar, open source software quality management tool.
003 * Copyright (C) 2008-2012 SonarSource
004 * mailto:contact AT sonarsource DOT com
005 *
006 * Sonar is free software; you can redistribute it and/or
007 * modify it under the terms of the GNU Lesser General Public
008 * License as published by the Free Software Foundation; either
009 * version 3 of the License, or (at your option) any later version.
010 *
011 * Sonar is distributed in the hope that it will be useful,
012 * but WITHOUT ANY WARRANTY; without even the implied warranty of
013 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
014 * Lesser General Public License for more details.
015 *
016 * You should have received a copy of the GNU Lesser General Public
017 * License along with Sonar; if not, write to the Free Software
018 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02
019 */
020package org.sonar.core.persistence.dialect;
021
022import org.apache.commons.lang.StringUtils;
023import org.hibernate.dialect.PostgreSQLDialect;
024
025import java.sql.Types;
026
027/**
028 * @since 1.12
029 */
030public class PostgreSql implements Dialect {
031
032  public static final String ID = "postgresql";
033
034  public String getId() {
035    return ID;
036  }
037
038  public String getActiveRecordDialectCode() {
039    return "postgre";
040  }
041
042  public String getActiveRecordJdbcAdapter() {
043    return "jdbc";
044  }
045
046  public Class<? extends org.hibernate.dialect.Dialect> getHibernateDialectClass() {
047    return PostgreSQLWithDecimalDialect.class;
048  }
049
050  public boolean matchesJdbcURL(String jdbcConnectionURL) {
051    return StringUtils.startsWithIgnoreCase(jdbcConnectionURL, "jdbc:postgresql:");
052  }
053
054  public static class PostgreSQLWithDecimalDialect extends PostgreSQLDialect {
055    public PostgreSQLWithDecimalDialect() {
056      super();
057      registerColumnType(Types.DOUBLE, "numeric($p,$s)");
058    }
059
060    @Override
061    public Class getNativeIdentifierGeneratorClass() {
062      return PostgreSQLSequenceGenerator.class;
063    }
064  }
065
066  public String getDefaultDriverClassName() {
067    return "org.postgresql.Driver";
068  }
069
070  public String getConnectionInitStatement(String schema) {
071    if (StringUtils.isNotBlank(schema)) {
072      return "SET SEARCH_PATH TO " + schema;
073    }
074    return null;
075  }
076
077  public String getTrueSqlValue() {
078    return "true";
079  }
080
081  public String getFalseSqlValue() {
082    return "false";
083  }
084}