net.java.ao.db
Class MySQLDatabaseProvider

java.lang.Object
  net.java.ao.DatabaseProvider
      net.java.ao.db.MySQLDatabaseProvider

public final class MySQLDatabaseProvider
extends DatabaseProvider

Author:

Daniel Spiewak

Field Summary

Fields inherited from class net.java.ao.DatabaseProvider

eventManager

Constructor Summary

MySQLDatabaseProvider(DisposableDataSource dataSource)

Method Summary

protected java.lang.String	convertTypeToString(DatabaseType<?> type) Converts the specified type into the database-specific DDL String value.
protected java.util.Set<java.lang.String>	getReservedWords() Retrieves the set of all reserved words for the underlying database.
protected java.lang.String	renderAppend() Generates any database-specific options which must be appended to the end of a table definition.
protected java.lang.String	renderAutoIncrement() Generates the DDL fragment required to specify an INTEGER field as auto-incremented.
protected java.lang.String	renderCreateIndex(DDLIndex index) Generates the database-specific DDL statement required to create a new index.

Methods inherited from class net.java.ao.DatabaseProvider

considerPrecision, dispose, executeInsertReturningKey, getConnection, getDateFormat, getEventManager, getFunctionNameForField, getMaxIDLength, getTables, getTriggerNameForField, handleBlob, insertReturningKey, isCaseSensetive, isNumericType, parseValue, processID, putBoolean, putNull, renderAction, renderAlterTableAddColumn, renderAlterTableAddKey, renderAlterTableChangeColumn, renderAlterTableChangeColumnStatement, renderAlterTableDropColumn, renderAlterTableDropKey, renderCalendar, renderConstraintsForTable, renderDropFunctions, renderDropIndex, renderDropSequences, renderDropTable, renderDropTriggers, renderField, renderFieldPrecision, renderFieldType, renderForeignKey, renderFunction, renderFunctionForField, renderFunctions, renderInsert, renderOnUpdate, renderQuery, renderQueryGroupBy, renderQueryJoins, renderQueryLimit, renderQueryOrderBy, renderQuerySelect, renderQueryWhere, renderSequences, renderTable, renderTriggerForField, renderTriggers, renderUnique, renderValue, setEventManager, setPostConnectionProperties, setQueryResultSetProperties, setQueryStatementProperties, shouldQuoteID

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLDatabaseProvider

public MySQLDatabaseProvider(DisposableDataSource dataSource)

Method Detail

convertTypeToString

protected java.lang.String convertTypeToString(DatabaseType<?> type)

Description copied from class: DatabaseProvider

Converts the specified type into the database-specific DDL String value. By default, this delegates to the DatabaseType#getDefaultName() method. Subclass implementations should be sure to make a super call in order to ensure that both default naming and future special cases are handled appropriately.

Overrides:

convertTypeToString in class DatabaseProvider

Parameters:

type - The type instance to convert to a DDL string.

Returns:

The database-specific DDL representation of the type (e.g. "VARCHAR").

See Also:

DatabaseType.getDefaultName()

renderAutoIncrement

protected java.lang.String renderAutoIncrement()

Description copied from class: DatabaseProvider

Generates the DDL fragment required to specify an INTEGER field as auto-incremented. For databases which do not support such flags (which is just about every database exception MySQL), "" is an acceptable return value. This method should never return null as it would cause the field rendering method to throw a NullPointerException.

Overrides:

renderAutoIncrement in class DatabaseProvider

renderAppend

protected java.lang.String renderAppend()

Description copied from class: DatabaseProvider

Generates any database-specific options which must be appended to the end of a table definition. The only database I am aware of which requires this is MySQL. For example:

CREATE TABLE test (
     id INTEGER NOT NULL AUTO_INCREMENT,
     name VARCHAR(45),
     PRIMARY KEY(id)
 ) ENGINE=InnoDB;

The "ENGINE=InnoDB" clause is what is returned by this method. The default implementation simply returns null, signifying that no append should be rendered.

Overrides:

renderAppend in class DatabaseProvider

Returns:

A DDL clause to be appended to the CREATE TABLE DDL, or null

renderCreateIndex

protected java.lang.String renderCreateIndex(DDLIndex index)

Description copied from class: DatabaseProvider

Generates the database-specific DDL statement required to create a new index. The syntax for this operation is highly standardized and thus it is unlikely this method will be overridden. If the database in question does not support indexes, a warning should be printed to stderr and null returned.

Overrides:

renderCreateIndex in class DatabaseProvider

Parameters:

index - The index to create. This single instance contains all of the data necessary to create the index, thus no separate parameters (such as a DDLTable) are required.

Returns:

A DDL statement to be executed, or null.

getReservedWords

protected java.util.Set<java.lang.String> getReservedWords()

Description copied from class: DatabaseProvider

Retrieves the set of all reserved words for the underlying database. The set returns should be speculative, meaning that it should include any possible reserved words, not just those for a particular version. As an implementation guideline, the Set instance returned from this method should guarentee O(1) lookup times, otherwise ORM performance will suffer greatly.

Specified by:

getReservedWords in class DatabaseProvider

Returns:

A set of upper case reserved words specific to the database.