de.must.dataobj

Class MariaDbDialect

java.lang.Object

de.must.dataobj.SqlDialect

de.must.dataobj.MariaDbDialect

public class MariaDbDialect
extends SqlDialect

Handles the specific MariaDB dialect. Completes the work of DataObject.

See Also:

DataObject

Field Summary

Fields

Modifier and Type	Field and Description
static char	BOOLEAN_FALSE_CHAR
static java.lang.String	BOOLEAN_FALSE_STRING
static char	BOOLEAN_TRUE_CHAR
static java.lang.String	BOOLEAN_TRUE_STRING

Fields inherited from class de.must.dataobj.SqlDialect

dataObject, timestampFormat

Constructor Summary

Constructors

Constructor and Description
MariaDbDialect()

Method Summary

Modifier and Type	Method and Description
protected void	extendCreateStatement(java.lang.StringBuilder createStatement, AbstractAttribute attribute)
protected void	extendInsertStatementWithValues(int i, java.sql.PreparedStatement statementForInsertion, java.util.Hashtable<java.lang.String,java.lang.Object> original, java.util.Hashtable<java.lang.String,java.lang.Object> workedOn, java.lang.String columnName, int columnType, int columnScale, java.lang.String columnNameOfRecordingDate, java.lang.String columnNameOfRecordingUser, java.lang.String recordingUser)
protected int	extendUpdatePhrase(int countUpdateColumns, java.lang.StringBuilder updateStatement, java.util.Hashtable<java.lang.String,java.lang.Object> original, java.util.Hashtable<java.lang.String,java.lang.Object> workedOn, java.lang.String columnName, int columnType, int columnScale)
boolean	getBoolean(java.lang.String columnName, java.util.Hashtable<java.lang.String,java.lang.Object> original) Returns the value of a column as boolean.
static java.lang.String	getCreateIndexStatement(java.lang.String tableName, Index index, java.lang.String indexName) Returns the specific create index statement string of the specified table
java.lang.String	getCreateStatement(EntityInfo entityInfo)
static java.lang.String	getDbExpression(java.sql.Date sqlDate) Returns the database specific expression of the date as specified.
static java.lang.String	getDbExpression(java.sql.Time sqlTime) Returns the database specific expression of the time as specified.
static java.lang.String	getDbExpression(java.sql.Timestamp timeStamp) Returns the database specific expression of the timestamp as specified.
protected java.lang.String	getLimitationFragment(int limit, int offset) Returns the limitation fragment of the SQL statement.
java.lang.String	getSqlCompareString(boolean b) Returns the specific variant how boolean values are compared.
java.lang.String	getSqlCompareString(java.sql.Date date) Returns the specific variant how date values are compared.
java.lang.String	getSqlCompareString(DateString dateString) Returns the specific variant how date values are compared.
boolean	getWorkedOnBoolean(java.lang.String columnName, java.util.Hashtable<java.lang.String,java.lang.Object> workedOn) Returns the value of a column as boolean in a worked on state - it might already been modified and differ from the original value.
protected void	initColumn(java.util.Hashtable<java.lang.String,java.lang.Object> original, java.util.Hashtable<java.lang.String,java.lang.Object> workedOn, java.lang.String columnName, int columnType, int columnScale)
protected void	loadColumn(java.sql.ResultSet rs, java.util.Hashtable<java.lang.String,java.lang.Object> original, java.util.Hashtable<java.lang.String,java.lang.Object> workedOn, java.lang.String columnName, int columnType, int columnScale)
void	setBoolean(java.lang.String columnName, boolean boolValue, java.util.Hashtable<java.lang.String,java.lang.Object> workedOn) Sets the value of the specified column.
protected java.lang.String	sqlSecure(java.lang.String stringField) Replaces ' by '' to avoid SQL error while inserting or updating.
java.lang.String	unifyColumnName(java.lang.String columnName) Unifies the column name.
java.lang.String	unifyTableName(java.lang.String TableName) Unifies the table name.

Methods inherited from class de.must.dataobj.SqlDialect

compress, extendToLength, fillInsertStatementWithValues, getCreateStatement, getIntDateValue, getRowBoolean, getRowBoolean, getRowDate, getRowDate, getRowDouble, getRowDouble, getRowFloat, getRowFloat, getRowInt, getRowInt, getRowLong, getRowLong, getRowString, getRowString, getRowTime, getRowTime, getRowTimestamp, getSqlCompareString, getSQLFormat, getUpdatePhrase, getWhereConditionFragementForExactDateComparison, initRow, isKnownAsBoolean, isPartOfUniqueIndex, loadRow, setAttributes, setDataObject, supportsPrimaryKey, transformStringWhenSaving

Methods inherited from class java.lang.Object

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

Field Detail

BOOLEAN_TRUE_CHAR

public static final char BOOLEAN_TRUE_CHAR

See Also:

Constant Field Values

BOOLEAN_FALSE_CHAR

public static final char BOOLEAN_FALSE_CHAR

See Also:

Constant Field Values

BOOLEAN_TRUE_STRING

public static final java.lang.String BOOLEAN_TRUE_STRING

BOOLEAN_FALSE_STRING

public static final java.lang.String BOOLEAN_FALSE_STRING

Constructor Detail

MariaDbDialect

public MariaDbDialect()

Method Detail

initColumn

protected void initColumn(java.util.Hashtable<java.lang.String,java.lang.Object> original,
                          java.util.Hashtable<java.lang.String,java.lang.Object> workedOn,
                          java.lang.String columnName,
                          int columnType,
                          int columnScale)

Overrides:

initColumn in class SqlDialect

loadColumn

protected void loadColumn(java.sql.ResultSet rs,
                          java.util.Hashtable<java.lang.String,java.lang.Object> original,
                          java.util.Hashtable<java.lang.String,java.lang.Object> workedOn,
                          java.lang.String columnName,
                          int columnType,
                          int columnScale)

Overrides:

loadColumn in class SqlDialect

extendInsertStatementWithValues

protected void extendInsertStatementWithValues(int i,
                                               java.sql.PreparedStatement statementForInsertion,
                                               java.util.Hashtable<java.lang.String,java.lang.Object> original,
                                               java.util.Hashtable<java.lang.String,java.lang.Object> workedOn,
                                               java.lang.String columnName,
                                               int columnType,
                                               int columnScale,
                                               java.lang.String columnNameOfRecordingDate,
                                               java.lang.String columnNameOfRecordingUser,
                                               java.lang.String recordingUser)
                                        throws java.sql.SQLException

Overrides:

extendInsertStatementWithValues in class SqlDialect

Throws:

java.sql.SQLException

extendUpdatePhrase

protected int extendUpdatePhrase(int countUpdateColumns,
                                 java.lang.StringBuilder updateStatement,
                                 java.util.Hashtable<java.lang.String,java.lang.Object> original,
                                 java.util.Hashtable<java.lang.String,java.lang.Object> workedOn,
                                 java.lang.String columnName,
                                 int columnType,
                                 int columnScale)

Overrides:

extendUpdatePhrase in class SqlDialect

getDbExpression

public static java.lang.String getDbExpression(java.sql.Date sqlDate)

Returns the database specific expression of the date as specified.

Parameters:

sqlDate - the date to be formatted

Returns:

the specific variant of setting a date value

getDbExpression

public static java.lang.String getDbExpression(java.sql.Time sqlTime)

Returns the database specific expression of the time as specified.

Parameters:

sqlTime - the time to be formatted

Returns:

the specific variant of setting a time value

getDbExpression

public static java.lang.String getDbExpression(java.sql.Timestamp timeStamp)

Returns the database specific expression of the timestamp as specified.

Parameters:

timeStamp - the time stamp to be formatted

Returns:

the database specific expression of the timestamp

unifyTableName

public java.lang.String unifyTableName(java.lang.String TableName)

Unifies the table name.

Specified by:

unifyTableName in class SqlDialect

Parameters:

tableName - the table name to unify

Returns:

the unified table name

unifyColumnName

public java.lang.String unifyColumnName(java.lang.String columnName)

Unifies the column name.

Specified by:

unifyColumnName in class SqlDialect

Parameters:

columnName - the column name to unify

Returns:

the unified column name

getSqlCompareString

public java.lang.String getSqlCompareString(DateString dateString)

Returns the specific variant how date values are compared.

Specified by:

getSqlCompareString in class SqlDialect

Parameters:

dateString - the DateString to be prepared

Returns:

the prepared String for data comparison

getSqlCompareString

public java.lang.String getSqlCompareString(java.sql.Date date)

Returns the specific variant how date values are compared.

Specified by:

getSqlCompareString in class SqlDialect

Parameters:

date - the date value to be prepared

Returns:

the prepared String for data comparison

getSqlCompareString

public java.lang.String getSqlCompareString(boolean b)

Description copied from class: SqlDialect

Returns the specific variant how boolean values are compared.

Overrides:

getSqlCompareString in class SqlDialect

Parameters:

b - the boolean value to be prepared

Returns:

the prepared String for boolean comparison

getBoolean

public boolean getBoolean(java.lang.String columnName,
                          java.util.Hashtable<java.lang.String,java.lang.Object> original)

Returns the value of a column as boolean.

Specified by:

getBoolean in class SqlDialect

Parameters:

columnName - the name of the column

original - the buffer of original values of the row

Returns:

the value of a column

getWorkedOnBoolean

public boolean getWorkedOnBoolean(java.lang.String columnName,
                                  java.util.Hashtable<java.lang.String,java.lang.Object> workedOn)

Returns the value of a column as boolean in a worked on state - it might already been modified and differ from the original value.

Parameters:

columnName - the name of the column

workedOn - the buffer of worked on values of the row

Returns:

the actual value of a column

setBoolean

public void setBoolean(java.lang.String columnName,
                       boolean boolValue,
                       java.util.Hashtable<java.lang.String,java.lang.Object> workedOn)

Sets the value of the specified column.

Specified by:

setBoolean in class SqlDialect

Parameters:

columnName - the name of the column to be set

boolValue - the value the column shall be set to

workedOn - the buffer of worked on values of the row

getCreateStatement

public java.lang.String getCreateStatement(EntityInfo entityInfo)

extendCreateStatement

protected void extendCreateStatement(java.lang.StringBuilder createStatement,
                                     AbstractAttribute attribute)

Overrides:

extendCreateStatement in class SqlDialect

getCreateIndexStatement

public static java.lang.String getCreateIndexStatement(java.lang.String tableName,
                                                       Index index,
                                                       java.lang.String indexName)

Returns the specific create index statement string of the specified table

Parameters:

tableName - the name of the table to be indexed

index - the index to be created

Returns:

the create index statement string

getLimitationFragment

protected java.lang.String getLimitationFragment(int limit,
                                                 int offset)

Returns the limitation fragment of the SQL statement.

Overrides:

getLimitationFragment in class SqlDialect

Parameters:

limit - maximum of entries to be put into the result set

offset - the number of records that don't have to be read anymore

Returns:

the limitation fragment

sqlSecure

protected java.lang.String sqlSecure(java.lang.String stringField)

Description copied from class: SqlDialect

Replaces ' by '' to avoid SQL error while inserting or updating.

Overrides:

sqlSecure in class SqlDialect

Parameters:

stringField - the String to modify

Returns:

the modified String