org.restsql.core.impl.postgresql

Class PostgreSqlSqlResourceMetaData

java.lang.Object

org.restsql.core.impl.AbstractSqlResourceMetaData

org.restsql.core.impl.postgresql.PostgreSqlSqlResourceMetaData

All Implemented Interfaces:

SqlResourceMetaData

public class PostgreSqlSqlResourceMetaData
extends AbstractSqlResourceMetaData

Implements SqlResourceMetaData for PostgreSQL.

Author:

Mark Sawers

Constructor Summary

Constructors

Constructor and Description
PostgreSqlSqlResourceMetaData()

Method Summary

Methods

Modifier and Type	Method and Description
protected String	getColumnDatabaseName(SqlResourceDefinition definition, ResultSetMetaData resultSetMetaData, int colNumber) Retrieves database name from result set meta data.
protected String	getColumnName(SqlResourceDefinition definition, ResultSetMetaData resultSetMetaData, int colNumber) Retrieves actual column name from result set meta data.
protected String	getColumnTableName(SqlResourceDefinition definition, ResultSetMetaData resultSetMetaData, int colNumber) Retrieves table name from result set meta data.
protected String	getQualifiedColumnLabel(String tableName, String qualifiedTableName, boolean readOnly, String label) Retrieves qualified column label for disambiguating duplicate labels in SQL statements.
protected String	getQualifiedTableName(Connection connection, String databaseName, String tableName) Retrieves database-specific table name used in SQL statements.
protected String	getQualifiedTableName(SqlResourceDefinition definition, ResultSetMetaData resultSetMetaData, int colNumber) Retrieves database-specific table name used in SQL statements.
protected String	getSqlColumnsQuery() Retrieves sql for querying columns.
protected String	getSqlPkQuery() Retrieves sql for querying primary keys.
protected boolean	isColumnReadOnly(ResultSetMetaData resultSetMetaData, int colNumber) Return whether a column in the given result set is read-only.
protected void	setSequenceMetaData(ColumnMetaDataImpl column, ResultSet resultSet) Sets sequence metadata for a column with the columns query result set.

Methods inherited from class org.restsql.core.impl.AbstractSqlResourceMetaData

getAllReadColumns, getChild, getChildPlusExtTables, getChildReadColumns, getJoin, getJoinList, getNumberTables, getParent, getParentPlusExtTables, getParentReadColumns, getQualifiedColumnName, getSqlMainQuery, getTableMap, getTables, getWriteTables, hasJoinTable, hasMultipleDatabases, init, isDbMetaDataUpperCase, isHierarchical, toHtml, toXml

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgreSqlSqlResourceMetaData

public PostgreSqlSqlResourceMetaData()

Method Detail

getColumnDatabaseName

protected String getColumnDatabaseName(SqlResourceDefinition definition,
                           ResultSetMetaData resultSetMetaData,
                           int colNumber)
                                throws SQLException

Retrieves database name from result set meta data. Hook method for buildTablesAndColumns() allows database-specific overrides.

Overrides:

getColumnDatabaseName in class AbstractSqlResourceMetaData

Throws:

SQLException

getColumnName

protected String getColumnName(SqlResourceDefinition definition,
                   ResultSetMetaData resultSetMetaData,
                   int colNumber)
                        throws SQLException

Retrieves actual column name from result set meta data. Hook method for buildTablesAndColumns() allows database-specific overrides.

Overrides:

getColumnName in class AbstractSqlResourceMetaData

Throws:

SQLException

getColumnTableName

protected String getColumnTableName(SqlResourceDefinition definition,
                        ResultSetMetaData resultSetMetaData,
                        int colNumber)
                             throws SQLException

Retrieves table name from result set meta data. Hook method for buildTablesAndColumns() allows database-specific overrides.

Overrides:

getColumnTableName in class AbstractSqlResourceMetaData

Throws:

SQLException

getSqlColumnsQuery

protected String getSqlColumnsQuery()

Retrieves sql for querying columns. Hook method for buildInvisibleForeignKeys() and buildJoinTableMetadata() allows database-specific overrides.

Specified by:

getSqlColumnsQuery in class AbstractSqlResourceMetaData

getSqlPkQuery

protected String getSqlPkQuery()

Retrieves sql for querying primary keys. Hook method for buildPrimaryKeys allows database-specific overrides.

Specified by:

getSqlPkQuery in class AbstractSqlResourceMetaData

getQualifiedColumnLabel

protected String getQualifiedColumnLabel(String tableName,
                             String qualifiedTableName,
                             boolean readOnly,
                             String label)

Retrieves qualified column label for disambiguating duplicate labels in SQL statements. MySQL can use the form database.table.label, for example sakila.film.id.

Specified by:

getQualifiedColumnLabel in class AbstractSqlResourceMetaData

getQualifiedTableName

protected String getQualifiedTableName(SqlResourceDefinition definition,
                           ResultSetMetaData resultSetMetaData,
                           int colNumber)
                                throws SQLException

Retrieves database-specific table name used in SQL statements.

Specified by:

getQualifiedTableName in class AbstractSqlResourceMetaData

Throws:

SQLException

getQualifiedTableName

protected String getQualifiedTableName(Connection connection,
                           String databaseName,
                           String tableName)
                                throws SQLException

Retrieves database-specific table name used in SQL statements. Used to build join table meta data.

Specified by:

getQualifiedTableName in class AbstractSqlResourceMetaData

Throws:

SQLException

isColumnReadOnly

protected boolean isColumnReadOnly(ResultSetMetaData resultSetMetaData,
                       int colNumber)
                            throws SQLException

Return whether a column in the given result set is read-only. The PostgreSQL implementation calls isReadOnly() on the result set and uses reflection to detect columns with SQL functions as read-only. Contributed by rhuitl.

Overrides:

isColumnReadOnly in class AbstractSqlResourceMetaData

Parameters:

resultSetMetaData - Result set metadata

colNumber - Column number (1..N)

Throws:

SQLException - if a database access error occurs

setSequenceMetaData

protected void setSequenceMetaData(ColumnMetaDataImpl column,
                       ResultSet resultSet)
                            throws SQLException

Sets sequence metadata for a column with the columns query result set. The column_default column will contain a string in the format nextval('sequence-name'::regclass), where sequence-name is the sequence name.

Specified by:

setSequenceMetaData in class AbstractSqlResourceMetaData

Throws:

SQLException - when a database error occurs