com.is.jrf
Class MySQLDatabasePolicy

java.lang.Object
  |
  +--com.is.jrf.MySQLDatabasePolicy

All Implemented Interfaces:

DatabasePolicy

public class MySQLDatabasePolicy

extends java.lang.Object

implements DatabasePolicy

Instances of this class perform Sybase/SQLServer-specific logic and return Sybase/SQLServer-specific information.

Field Summary

protected static java.lang.String

AUTO_INCREMENT

Constructor Summary

MySQLDatabasePolicy()

Method Summary

java.lang.String	autoIncrementIdentifier() Return the string used to declare a primary key as Auto-Increment.
void	createSequence(AbstractDomain domain, JDBCHelper aJDBCHelper) This is called when creating a table that has a SEQUENCED_PRIMARY_KEY.
java.lang.String	currentTimestampSQL() This should return the the SQL to use to have the database return the current timestamp.
java.lang.Long	findAutoIncrementId(java.lang.String tableName, java.lang.String columnName, JDBCHelper aJDBCHelper) Return the sequence value (auto increment) from the last insert.
java.lang.String	formatDate(java.sql.Date sqlDate) The result of this is used in SQL.
java.lang.String	formatTimestamp(java.sql.Timestamp ts) The return value should be in the format that the database recognizes for a timestamp.
java.lang.String	outerWhereJoin(java.lang.String mainTableColumn, java.lang.String joinTableColumn) Return a string with a name-value pair that represents an SQL outer join in a WHERE clause for SQLServer and Sybase.
java.lang.String	sequenceSQL(java.lang.String tableName) When executed, this SQL should return a one column, one row result set with an Integer in it.
java.lang.String	timestampColumnType() This method is used when building SQL to create tables.
java.lang.String	timestampFunction() This is the string value (function name) to put into the SQL to tell the database to insert the current timestamp.

Methods inherited from class java.lang.Object

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

Field Detail

AUTO_INCREMENT

protected static final java.lang.String AUTO_INCREMENT

Constructor Detail

MySQLDatabasePolicy

public MySQLDatabasePolicy()

Method Detail

sequenceSQL

public java.lang.String sequenceSQL(java.lang.String tableName)

When executed, this SQL should return a one column, one row result set with an Integer in it.

Specified by:

sequenceSQL in interface DatabasePolicy

Parameters:

tableName - a value of type 'String'

Returns:

a value of type 'String'

timestampFunction

public java.lang.String timestampFunction()

This is the string value (function name) to put into the SQL to tell the database to insert the current timestamp.

Specified by:

timestampFunction in interface DatabasePolicy

Returns:

a value of type 'String'

formatTimestamp

public java.lang.String formatTimestamp(java.sql.Timestamp ts)

The return value should be in the format that the database recognizes for a timestamp.

Specified by:

formatTimestamp in interface DatabasePolicy

Parameters:

ts - a value of type 'Timestamp'

Returns:

a value of type 'String'

formatDate

public java.lang.String formatDate(java.sql.Date sqlDate)

The result of this is used in SQL. This will return only the date (not the time portion)

Specified by:

formatDate in interface DatabasePolicy

Parameters:

sqlDate - a value of type 'java.sql.Date'

Returns:

a value of type 'String'

currentTimestampSQL

public java.lang.String currentTimestampSQL()

This should return the the SQL to use to have the database return the current timestamp.

Specified by:

currentTimestampSQL in interface DatabasePolicy

Returns:

a value of type 'String'

autoIncrementIdentifier

public java.lang.String autoIncrementIdentifier()

Return the string used to declare a primary key as Auto-Increment. RDBMS's that don't use auto-increment should return null.

Specified by:

autoIncrementIdentifier in interface DatabasePolicy

findAutoIncrementId

public java.lang.Long findAutoIncrementId(java.lang.String tableName,
                                          java.lang.String columnName,
                                          JDBCHelper aJDBCHelper)

Return the sequence value (auto increment) from the last insert. This implementation uses reflection since not all users will have MySQL JDBC drivers at compile time.

Specified by:

findAutoIncrementId in interface DatabasePolicy

Parameters:

tableName - a value of type 'String'

columnName - a value of type 'String'

aJDBCHelper - a value of type 'JDBCHelper'

Returns:

a value of type 'Long'

createSequence

public void createSequence(AbstractDomain domain,
                           JDBCHelper aJDBCHelper)
                    throws java.sql.SQLException

This is called when creating a table that has a SEQUENCED_PRIMARY_KEY. This implementation does nothing as we will make use of the MySQL AUTO_INCREMENT column feature.

Specified by:

createSequence in interface DatabasePolicy

Parameters:

domain - a value of type 'AbstractDomain'

aJDBCHelper - a value of type 'JDBCHelper'

outerWhereJoin

public java.lang.String outerWhereJoin(java.lang.String mainTableColumn,
                                       java.lang.String joinTableColumn)

Return a string with a name-value pair that represents an SQL outer join in a WHERE clause for SQLServer and Sybase. Given this operator (*=), it looks like SQLServer always gives preference to the rows in the table on the left whether it is a foreign key in the left table or a foreign key in the right table. This is what we want since we always put the main table on the left.

Specified by:

outerWhereJoin in interface DatabasePolicy

Parameters:

mainTableColumn - a value of type 'String'

joinTableColumn - a value of type 'String'

sqlBuffer - a value of type 'StringBuffer'

Returns:

a value of type 'String'

timestampColumnType

public java.lang.String timestampColumnType()

This method is used when building SQL to create tables.

Specified by:

timestampColumnType in interface DatabasePolicy

Returns:

a value of type 'String'