org.fastnate.generator.dialect

Class MySqlDialect

java.lang.Object

org.fastnate.generator.dialect.GeneratorDialect

org.fastnate.generator.dialect.MySqlDialect

public class MySqlDialect
extends GeneratorDialect

Handles MySQL specific conversions.

Author:

Tobias Liefke

See Also:

MySQL - Reference Manuals

Field Summary

Fields inherited from class org.fastnate.generator.dialect.GeneratorDialect

NOW

Constructor Summary

Constructors

Constructor and Description
MySqlDialect()

Method Summary

Modifier and Type	Method and Description
protected String	createAddDateExpression(String referenceDate, long value, String unit) Creates an SQL expression to add a value to a date.
String	createBlobExpression(byte[] blob) Create MySQL specific binary expression.
String	createSql(EntityStatement stmt) Replace any subselect in an insert statement, if the same table is selected.
String	getOptionalTable() Returns the string to use when no table is required, e.g. for "SELECT 1, 2 FROM DUAL" this would return "FROM DUAL".
protected boolean	isEmulatingSequences() Indicates that tables are used in place of sequences, if GenerationType.SEQUENCE is defined for a GeneratedValue.
String	quoteString(String value) Create MySQL specific quoting of the string.

Methods inherited from class org.fastnate.generator.dialect.GeneratorDialect

addQuotedCharacter, adjustNextIdentityValue, adjustNextSequenceValue, buildCurrentSequenceValue, buildNextSequenceValue, convertBooleanValue, convertTemporalValue, convertTemporalValue, createHexBlobExpression, getAutoGenerationType, getConcatOperator, getLetter, isEmptyStringEqualToNull, isIdentitySupported, isNextSequenceValueInInsertSupported, isSequenceInWhereSupported, isSequenceSupported, isSettingIdentityAllowed

Methods inherited from class java.lang.Object

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

Constructor Detail

MySqlDialect

public MySqlDialect()

Method Detail

createAddDateExpression

protected String createAddDateExpression(String referenceDate,
                                         long value,
                                         String unit)

Description copied from class: GeneratorDialect

Creates an SQL expression to add a value to a date.

Overrides:

createAddDateExpression in class GeneratorDialect

Parameters:

referenceDate - the expression for the reference date

value - the value to add to the date

unit - the unit of the value

Returns:

the SQL expression that adds the value

createBlobExpression

public String createBlobExpression(byte[] blob)

Create MySQL specific binary expression.

Overrides:

createBlobExpression in class GeneratorDialect

Parameters:

blob - the bytes to convert

Returns:

the expression for the bytes

createSql

public String createSql(EntityStatement stmt)

Replace any subselect in an insert statement, if the same table is selected.

Overrides:

createSql in class GeneratorDialect

Parameters:

stmt - contains the table and all column values

Returns:

the SQL

getOptionalTable

public String getOptionalTable()

Description copied from class: GeneratorDialect

Returns the string to use when no table is required, e.g. for "SELECT 1, 2 FROM DUAL" this would return "FROM DUAL".

Overrides:

getOptionalTable in class GeneratorDialect

Returns:

the SQL to use in "SELECT x [OPTIONALTABLE] WHERE ..."

isEmulatingSequences

protected boolean isEmulatingSequences()

Description copied from class: GeneratorDialect

Indicates that tables are used in place of sequences, if GenerationType.SEQUENCE is defined for a GeneratedValue.

Overrides:

isEmulatingSequences in class GeneratorDialect

Returns:

true if sequences are emulated with tables, false if sequences are supported

quoteString

public String quoteString(String value)

Create MySQL specific quoting of the string.

Overrides:

quoteString in class GeneratorDialect

Parameters:

value - the value to quote

Returns:

the quoted string