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
List<? extends EntityStatement>	adjustNextSequenceValue(String sequenceName, long currentSequenceValue, long nextSequenceValue, int incrementSize) Adjusts the given sequence to ensure that the next value is exactly the given value.
String	buildCurrentSequenceValue(String sequence, int incrementSize) Builds the SQL expression that is used for referencing the current value of the given sequence.
String	buildNextSequenceValue(String sequence, int incrementSize) Builds the SQL expression resp. statement that is used for creating the next value of the given sequence.
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".
boolean	isNextSequenceValueInInsertSupported() Indicates that a sequence may be updated in the insert statement.
boolean	isSequenceSupported() Indicates that sequences are supported by the database.
String	quoteString(String value) Create MySQL specific quoting of the string.

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

addQuotedCharacter, adjustNextIdentityValue, convertBooleanValue, convertTemporalValue, createHexBlobExpression, getAutoGenerationType, isEmptyStringEqualToNull, isIdentitySupported, isSequenceInWhereSupported

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

adjustNextSequenceValue

public List<? extends EntityStatement> adjustNextSequenceValue(String sequenceName,
                                                               long currentSequenceValue,
                                                               long nextSequenceValue,
                                                               int incrementSize)

Description copied from class: GeneratorDialect

Adjusts the given sequence to ensure that the next value is exactly the given value.

Overrides:

adjustNextSequenceValue in class GeneratorDialect

Parameters:

sequenceName - the name of the sequence

currentSequenceValue - the current value of the sequence

nextSequenceValue - the next value of the sequence

incrementSize - the increment size of the sequence

Returns:

all statements necessary to adjust the sequence

buildCurrentSequenceValue

public String buildCurrentSequenceValue(String sequence,
                                        int incrementSize)

Description copied from class: GeneratorDialect

Builds the SQL expression that is used for referencing the current value of the given sequence.

Overrides:

buildCurrentSequenceValue in class GeneratorDialect

Parameters:

sequence - the name of the sequence

incrementSize - the expected incrementSize, as given in the schema - used by some dialects to ensure that exactly that inrement is used

Returns:

the SQL expression to use in statement

buildNextSequenceValue

public String buildNextSequenceValue(String sequence,
                                     int incrementSize)

Description copied from class: GeneratorDialect

Builds the SQL expression resp. statement that is used for creating the next value of the given sequence. Depending on GeneratorDialect.isNextSequenceValueInInsertSupported() this will return an expression or a statement.

Overrides:

buildNextSequenceValue in class GeneratorDialect

Parameters:

sequence - the name of the sequence

incrementSize - the expected incrementSize, as given in the schema - used by some dialects to ensure that exactly that inrement is used

Returns:

the SQL to use in resp. before the insert / update statement

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 ..."

isNextSequenceValueInInsertSupported

public boolean isNextSequenceValueInInsertSupported()

Description copied from class: GeneratorDialect

Indicates that a sequence may be updated in the insert statement.

Overrides:

isNextSequenceValueInInsertSupported in class GeneratorDialect

Returns:

true to indicate that GeneratorDialect.buildNextSequenceValue(String,int) will return an expression that may be used in an INSERT statement, false to indicate that GeneratorDialect.buildNextSequenceValue(String,int) returns a full statement

isSequenceSupported

public boolean isSequenceSupported()

Description copied from class: GeneratorDialect

Indicates that sequences are supported by the database.

Overrides:

isSequenceSupported in class GeneratorDialect

Returns:

true if the database supports sequences

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