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

Modifier and Type	Field and Description
private static String[]	ESCAPES
private static char	MAX_ESCAPE

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.
Object	getEmptyValuesExpression() The SQL expression to use in an empty insert statement.
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".
boolean	isEmulatingSequences() Indicates that tables are used in place of sequences, if GenerationType.SEQUENCE is defined for a GeneratedValue.
boolean	isFastInTransaction() Indicates that the database usually faster when all statements are executed within an transaction.
boolean	isSelectFromSameTableInInsertSupported() Indicates that this dialect may select from the same table in a select.
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, convertNumberValue, convertTemporalValue, convertTemporalValue, convertToDatabaseDate, createHexBlobExpression, getAutoGenerationType, getConcatOperator, getLetter, isEmptyStringEqualToNull, isIdentitySupported, isNextSequenceValueInInsertSupported, isSequenceInWhereSupported, isSequenceSupported, isSettingIdentityAllowed, truncateTable

Methods inherited from class java.lang.Object

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

Field Detail

MAX_ESCAPE

private static final char MAX_ESCAPE

See Also:

Constant Field Values

ESCAPES

private static final String[] ESCAPES

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

getEmptyValuesExpression

public Object getEmptyValuesExpression()

Description copied from class: GeneratorDialect

The SQL expression to use in an empty insert statement.

Overrides:

getEmptyValuesExpression in class GeneratorDialect

Returns:

the SQL expression if an insert statement contains no values

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

public 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

isFastInTransaction

public boolean isFastInTransaction()

Description copied from class: GeneratorDialect

Indicates that the database usually faster when all statements are executed within an transaction. For example Oracle is approx. 25% faster but H2 is 200% slower compared to auto commit. Only relevant if executed against a running database.

Overrides:

isFastInTransaction in class GeneratorDialect

Returns:

true if an transaction is faster than auto commit

isSelectFromSameTableInInsertSupported

public boolean isSelectFromSameTableInInsertSupported()

Description copied from class: GeneratorDialect

Indicates that this dialect may select from the same table in a select.

Overrides:

isSelectFromSameTableInInsertSupported in class GeneratorDialect

Returns:

true if "INSERT INTO XXX (a) VALUES (SELECT max(a) FROM XXX)" is 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