org.apache.metamodel.jdbc.dialects

Class PostgresqlQueryRewriter

java.lang.Object

org.apache.metamodel.jdbc.dialects.AbstractQueryRewriter

org.apache.metamodel.jdbc.dialects.DefaultQueryRewriter

org.apache.metamodel.jdbc.dialects.LimitOffsetQueryRewriter

org.apache.metamodel.jdbc.dialects.PostgresqlQueryRewriter

All Implemented Interfaces:

IQueryRewriter

public class PostgresqlQueryRewriter
extends LimitOffsetQueryRewriter

Query rewriter for PostgreSQL

Constructor Summary

Constructors

Constructor and Description
PostgresqlQueryRewriter(JdbcDataContext dataContext)

Method Summary

Modifier and Type	Method and Description
ColumnType	getColumnType(int jdbcType, String nativeType, Integer columnSize) Gets the column type for a specific JDBC type (as defined in Types), native type name and column size.
Object	getResultSetValue(ResultSet resultSet, int columnIndex, Column column) Retrieves a value from a JDBC ResultSet when the anticipated value is mapped to a particular column.
String	rewriteColumnType(ColumnType columnType, Integer columnSize) Rewrites the name of a column type, as it is written in CREATE TABLE statements.
protected String	rewriteFromItem(Query query, FromItem item)
void	setStatementParameter(PreparedStatement st, int valueIndex, Column column, Object value) Method which handles the action of setting a parameterized value on a statement.

Methods inherited from class org.apache.metamodel.jdbc.dialects.LimitOffsetQueryRewriter

isFirstRowSupported, isMaxRowsSupported, rewriteQuery

Methods inherited from class org.apache.metamodel.jdbc.dialects.DefaultQueryRewriter

beforeRewrite, escapeQuotes, isAggregateFunctionSupported, isPrimaryKeySupported, isScalarFunctionSupported, needsQuoting, rewriteFilterItem, rewriteFilterItemWithOperandLiteral, rewriteTimestamp

Methods inherited from class org.apache.metamodel.jdbc.dialects.AbstractQueryRewriter

getDataContext, isSchemaIncludedInColumnPaths, isSupportedVersion, isTransactional, rewriteColumnTypeInternal, rewriteFromClause, rewriteFromItem, rewriteGroupByClause, rewriteGroupByItem, rewriteHavingClause, rewriteOrderByClause, rewriteOrderByItem, rewriteSelectClause, rewriteSelectItem, rewriteWhereClause, toTime, toTimestamp

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgresqlQueryRewriter

public PostgresqlQueryRewriter(JdbcDataContext dataContext)

Method Detail

getColumnType

public ColumnType getColumnType(int jdbcType,
                                String nativeType,
                                Integer columnSize)

Description copied from interface: IQueryRewriter

Gets the column type for a specific JDBC type (as defined in Types), native type name and column size.

Specified by:

getColumnType in interface IQueryRewriter

Overrides:

getColumnType in class AbstractQueryRewriter

Returns:

rewriteColumnType

public String rewriteColumnType(ColumnType columnType,
                                Integer columnSize)

Description copied from interface: IQueryRewriter

Rewrites the name of a column type, as it is written in CREATE TABLE statements. Some databases dont support all column types, or have different names for them. The implementation of this method will do that conversion.

Specified by:

rewriteColumnType in interface IQueryRewriter

Overrides:

rewriteColumnType in class DefaultQueryRewriter

Parameters:

columnType - the (non-null) ColumnType to rewrite

columnSize - the (possibly null) column size that may or may not have been specified

Returns:

setStatementParameter

public void setStatementParameter(PreparedStatement st,
                                  int valueIndex,
                                  Column column,
                                  Object value)
                           throws SQLException

Description copied from interface: IQueryRewriter

Method which handles the action of setting a parameterized value on a statement. Traditionally this is done using the PreparedStatement.setObject(int, Object) method but for some types we use more specific setter methods.

Specified by:

setStatementParameter in interface IQueryRewriter

Overrides:

setStatementParameter in class AbstractQueryRewriter

Throws:

SQLException

getResultSetValue

public Object getResultSetValue(ResultSet resultSet,
                                int columnIndex,
                                Column column)
                         throws SQLException

Description copied from interface: IQueryRewriter

Retrieves a value from a JDBC ResultSet when the anticipated value is mapped to a particular column.

Specified by:

getResultSetValue in interface IQueryRewriter

Overrides:

getResultSetValue in class AbstractQueryRewriter

Returns:

Throws:

SQLException

rewriteFromItem

protected String rewriteFromItem(Query query,
                                 FromItem item)

Overrides:

rewriteFromItem in class AbstractQueryRewriter