org.jooq.SQLDialect Maven / Gradle / Ivy
Show all versions of hello-world-plugin Show documentation
/*
* Copyright (c) 2009-2016, Data Geekery GmbH (http://www.datageekery.com)
* All rights reserved.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
* Other licenses:
* -----------------------------------------------------------------------------
* Commercial licenses for this work are available. These replace the above
* ASL 2.0 and offer limited warranties, support, maintenance, and commercial
* database integrations.
*
* For more information, please visit: http://www.jooq.org/licenses
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*/
package org.jooq;
import java.util.EnumSet;
import java.util.Set;
/**
* Dialects and dialect families as supported by jOOQ.
*
* jOOQ supports a variety of dialects, which are grouped into dialect families.
* For instance, the SQL Server dialect family {@link #POSTGRES} is specialised
* by its dialects
*
* - {@link #POSTGRES_9_3}
* - {@link #POSTGRES_9_4}
*
*
* @author Lukas Eder
*/
public enum SQLDialect {
/**
* The standard SQL dialect family.
*
* @deprecated - [#3844] - 3.6.0 - {@link #DEFAULT} will replace this
* pseudo-dialect.
*/
@Deprecated
SQL99("", false),
/**
* The default SQL dialect.
*
* This dialect is chosen in the absence of a more explicit dialect. It is
* not intended to be used with any actual database as it may combined
* dialect-specific things from various dialects.
*/
DEFAULT("", false),
// -------------------------------------------------------------------------
// SQL dialects for free usage
// -------------------------------------------------------------------------
/**
* The CUBRID dialect family.
*/
CUBRID("CUBRID", false),
/**
* The Apache Derby dialect family.
*/
DERBY("Derby", false),
/**
* The Firebird dialect family.
*/
FIREBIRD("Firebird", false),
/**
* The Firebird 2.5 dialect.
*/
FIREBIRD_2_5("Firebird", false, FIREBIRD, null),
/**
* The Firebird 3.0 dialect.
*/
FIREBIRD_3_0("Firebird", false, FIREBIRD, FIREBIRD_2_5),
/**
* The H2 dialect family.
*/
H2("H2", false),
/**
* The Hypersonic dialect family.
*/
HSQLDB("HSQLDB", false),
/**
* The MariaDB dialect family.
*/
MARIADB("MariaDB", false),
/**
* The MySQL dialect family.
*/
MYSQL("MySQL", false),
/**
* The PostgreSQL dialect family.
*
* While this family (and its dialects) have been observed to work to some
* extent on Amazon RedShift as well, we strongly suggest you use the
* official {@link #REDSHIFT} support, instead.
*/
POSTGRES("Postgres", false),
/**
* The PostgreSQL 9.3 dialect.
*
* While this family (and its dialects) have been observed to work to some
* extent on Amazon RedShift as well, we strongly suggest you use the
* official {@link #REDSHIFT} support, instead.
*/
POSTGRES_9_3("Postgres", false, POSTGRES, null),
/**
* The PostgreSQL 9.4 dialect.
*
* While this family (and its dialects) have been observed to work to some
* extent on Amazon RedShift as well, we strongly suggest you use the
* official {@link #REDSHIFT} support, instead.
*/
POSTGRES_9_4("Postgres", false, POSTGRES, POSTGRES_9_3),
/**
* The PostgreSQL 9.5 dialect.
*
* While this family (and its dialects) have been observed to work to some
* extent on Amazon RedShift as well, we strongly suggest you use the
* official {@link #REDSHIFT} support, instead.
*/
POSTGRES_9_5("Postgres", false, POSTGRES, POSTGRES_9_4),
/**
* The SQLite dialect family.
*/
SQLITE("SQLite", false),
// -------------------------------------------------------------------------
// SQL dialects for commercial usage
// -------------------------------------------------------------------------
;
private static final SQLDialect[] FAMILIES;
static {
Set set = EnumSet.noneOf(SQLDialect.class);
for (SQLDialect dialect : values()) {
set.add(dialect.family());
}
FAMILIES = set.toArray(new SQLDialect[0]);
}
private final String name;
private final boolean commercial;
private final SQLDialect family;
private SQLDialect predecessor;
private final ThirdParty thirdParty;
private SQLDialect(String name, boolean commercial) {
this(name, commercial, null, null);
}
private SQLDialect(String name, boolean commercial, SQLDialect family) {
this(name, commercial, family, null);
}
private SQLDialect(String name, boolean commercial, SQLDialect family, SQLDialect predecessor) {
this.name = name;
this.commercial = commercial;
this.family = family == null ? this : family;
this.predecessor = predecessor == null ? this : predecessor;
if (family != null)
family.predecessor = this;
this.thirdParty = new ThirdParty();
}
/**
* Whether this dialect is supported with the jOOQ commercial license only.
*/
public final boolean commercial() {
return commercial;
}
/**
* The dialect family.
*
* This returns the dialect itself, if it has no "parent family". E.g.
*
* SQLSERVER == SQLSERVER2012.family();
* SQLSERVER == SQLSERVER2008.family();
* SQLSERVER == SQLSERVER.family();
*
* If this is a dialect version (e.g. {@link #POSTGRES_9_4}) within a family
* (e.g. {@link #POSTGRES}), then the predecessor will point to the
* historically previous dialect version (e.g. {@link #POSTGRES_9_3}) within
* the same family, or to the dialect itself if there was no predecessor
* explicitly supported by jOOQ.
*/
public final SQLDialect predecessor() {
return predecessor;
}
/**
* Whether this dialect precedes an other dialect from the same family.
*
* This returns:
*
* true if this dialect is the same as the other dialecttrue if this dialect precedes the other dialect via any
* number of calls to {@link #predecessor()}
* The above also implies that:
*
* false if the two dialects do not belong to the same
* family
*
* This is useful to see if some feature is supported by "at least"
* a given dialect version. Example:
* // Do this block only if the chosen dialect supports PostgreSQL 9.4+ features
* if (POSTGRES_9_4.precedes(dialect)) {
* }
*
* // Do this block only if the chosen dialect supports PostgreSQL 9.3+ features
* else if (POSTGRES_9_3.precedes(dialect)) {
* }
*
* // Fall back to pre-PostgreSQL 9.3 behaviour
* else {
* }
*
* This is:
*
* false if dialects don't belong to the same familytrue if either dialect {@link #isFamily()}true if other dialect precedes this
* dialect
*
* The other argument dialect is typically referenced from a
* {@link Support} annotation, whereas this dialect is the user dialect.
*/
public final boolean supports(SQLDialect other) {
if (family != other.family)
return false;
if (isFamily() || other.isFamily())
return true;
return other.precedes(this);
}
/**
* The name of this dialect as it appears in related class names.
*/
public final String getName() {
return name;
}
/**
* The name of this dialect as it appears in related package names.
*/
public final String getNameLC() {
return name == null ? null : name.toLowerCase();
}
/**
* The name of this dialect as it appears in related enum values.
*/
public final String getNameUC() {
return name == null ? null : name.toUpperCase();
}
/**
* Get a list of all {@link SQLDialect#family()} values.
*/
public static final SQLDialect[] families() {
return FAMILIES.clone();
}
/**
* Get access to third party representations of this {@link SQLDialect}.
*/
public final ThirdParty thirdParty() {
return thirdParty;
}
/**
* Third party representations of the enclosing {@link SQLDialect}.
*/
public final class ThirdParty {
/**
* The Spring DB name or null, if the db name is not
* supported by Spring.
*
* The name returned by this method corresponds to the DB id as
* referenced in
* org/springframework/jdbc/support/sql-error-codes.xml
*/
public final String springDbName() {
switch (SQLDialect.this.family) {
case DERBY: return "Derby";
case H2: return "H2";
case HSQLDB: return "HSQL";
case MARIADB:
case MYSQL: return "MySQL";
case POSTGRES: return "PostgreSQL";
default: return null;
}
}
/**
* The Hibernate dialect name or null, if the dialect is
* not supported by Hibernate.
*
*
* @see
* http://docs.jboss.org/hibernate/orm/5.0/javadocs/org/hibernate/
* dialect/package-summary.html
*/
public final String hibernateDialect() {
switch (SQLDialect.this) {
case CUBRID: return "org.hibernate.dialect.CUBRIDDialect";
case DERBY: return "org.hibernate.dialect.DerbyTenSevenDialect";
case FIREBIRD: return "org.hibernate.dialect.FirebirdDialect";
case H2: return "org.hibernate.dialect.H2Dialect";
case HSQLDB: return "org.hibernate.dialect.HSQLDialect";
case MARIADB:
case MYSQL: return "org.hibernate.dialect.MySQL5Dialect";
case POSTGRES_9_3: return "org.hibernate.dialect.PostgreSQL92Dialect";
case POSTGRES_9_4:
case POSTGRES_9_5:
case POSTGRES: return "org.hibernate.dialect.PostgreSQL94Dialect";
case SQLITE: return null;
default: return null;
}
}
}
}