org.restsql.core.impl.mysql

Class MySqlSqlResourceMetaData

java.lang.Object

org.restsql.core.impl.AbstractSqlResourceMetaData

org.restsql.core.impl.mysql.MySqlSqlResourceMetaData

All Implemented Interfaces:

SqlResourceMetaData

public class MySqlSqlResourceMetaData
extends AbstractSqlResourceMetaData

Implements SqlResourceMetaData for MySQL.

Author:

Mark Sawers

Constructor Summary

Constructors

Constructor and Description
MySqlSqlResourceMetaData()

Method Summary

Methods

Modifier and Type	Method and Description
protected String	getQualifiedColumnLabel(String tableName, String qualifiedTableName, boolean readOnly, String label) Building the 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 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, getColumnDatabaseName, getColumnName, getColumnTableName, getJoin, getJoinList, getNumberTables, getParent, getParentPlusExtTables, getParentReadColumns, getQualifiedColumnName, getSqlMainQuery, getTableMap, getTables, getWriteTables, hasJoinTable, hasMultipleDatabases, init, isColumnReadOnly, isDbMetaDataUpperCase, isHierarchical, toHtml, toXml

Methods inherited from class java.lang.Object

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

Constructor Detail

MySqlSqlResourceMetaData

public MySqlSqlResourceMetaData()

Method Detail

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)

Building the 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

Parameters:

readOnly - true if column is read only

label - base column label

Returns:

qualified label

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

setSequenceMetaData

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

Sets sequence metadata for a column with the columns query result set. The extra column value will contain the string auto_increment if this is a sequence.

Specified by:

setSequenceMetaData in class AbstractSqlResourceMetaData

Throws:

SQLException - when a database error occurs