org.apache.marmotta.kiwi.persistence.pgsql

Class PostgreSQLDialect

java.lang.Object

org.apache.marmotta.kiwi.persistence.KiWiDialect

org.apache.marmotta.kiwi.persistence.pgsql.PostgreSQLDialect

public class PostgreSQLDialect
extends KiWiDialect

Add file description here!

Author: Sebastian Schaffert

Field Summary

Fields inherited from class org.apache.marmotta.kiwi.persistence.KiWiDialect

VERSION

Constructor Summary

Constructors

Constructor and Description
PostgreSQLDialect()

Method Summary

Methods

Modifier and Type	Method and Description
String	getDateTimeTZ(String alias) Return the SQL timezone value for a KiWiDateLiteral, corrected by the timezone offset.
String	getDriverClass() Return the name of the driver class (used for properly initialising JDBC connections)
String	getGroupConcat(String value, String separator, boolean distinct) Return the name of the aggregate function for group concatenation (string_agg in postgres, GROUP_CONCAT in MySQL)
String	getILike(String text, String pattern) Return the database specific case insensitive like comparison, e.g.
String	getRegexp(String text, String pattern, String flags) Return the database specific operator for matching a text against a regular expression.
String	getValidationQuery() Get the query string that can be used for validating that a JDBC connection to this database is still valid.
boolean	isArraySupported() Return true in case the database supports creating arrays with ARRAY[...]
boolean	isBatchSupported() Return true if batched commits are supported by this dialect.
boolean	isCursorSupported() Return true in case the database system supports using cursors for queries over large data tables.
boolean	isRegexpSupported(String flags) Return true in case the SPARQL RE flags contained in the given string are supported.

Methods inherited from class org.apache.marmotta.kiwi.persistence.KiWiDialect

getCreateScript, getDropScript, getMigrationScript, getScript, getStatement, getStatementIdentifiers, getVersion, hasStatement

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PostgreSQLDialect

public PostgreSQLDialect()
                  throws DriverNotFoundException

Throws:

DriverNotFoundException

Method Detail

getDriverClass

public String getDriverClass()

Return the name of the driver class (used for properly initialising JDBC connections)

Specified by:

getDriverClass in class KiWiDialect

Returns:

isBatchSupported

public boolean isBatchSupported()

Description copied from class: KiWiDialect

Return true if batched commits are supported by this dialect.

Specified by:

isBatchSupported in class KiWiDialect

Returns:

getRegexp

public String getRegexp(String text,
               String pattern,
               String flags)

Description copied from class: KiWiDialect

Return the database specific operator for matching a text against a regular expression.

Specified by:

getRegexp in class KiWiDialect

Returns:

isRegexpSupported

public boolean isRegexpSupported(String flags)

Return true in case the SPARQL RE flags contained in the given string are supported.

Specified by:

isRegexpSupported in class KiWiDialect

Parameters:

flags -

Returns:

getILike

public String getILike(String text,
              String pattern)

Description copied from class: KiWiDialect

Return the database specific case insensitive like comparison, e.g. ILIKE in Postgres.

Specified by:

getILike in class KiWiDialect

Returns:

getGroupConcat

public String getGroupConcat(String value,
                    String separator,
                    boolean distinct)

Return the name of the aggregate function for group concatenation (string_agg in postgres, GROUP_CONCAT in MySQL)

Specified by:

getGroupConcat in class KiWiDialect

Parameters:

value -

separator -

Returns:

getDateTimeTZ

public String getDateTimeTZ(String alias)

Return the SQL timezone value for a KiWiDateLiteral, corrected by the timezone offset. In PostgreSQL, this is e.g. computed by (ALIAS.tvalue + ALIAS.tzoffset * INTERVAL '1 second')

Specified by:

getDateTimeTZ in class KiWiDialect

Parameters:

alias -

Returns:

getValidationQuery

public String getValidationQuery()

Get the query string that can be used for validating that a JDBC connection to this database is still valid. Typically, this should be an inexpensive operation like "SELECT 1",

Specified by:

getValidationQuery in class KiWiDialect

Returns:

isCursorSupported

public boolean isCursorSupported()

Return true in case the database system supports using cursors for queries over large data tables.

Overrides:

isCursorSupported in class KiWiDialect

Returns:

isArraySupported

public boolean isArraySupported()

Return true in case the database supports creating arrays with ARRAY[...]

Overrides:

isArraySupported in class KiWiDialect

Returns: