Package io.jmix.dynmodel.impl.db

Class MySqlDynamicModelDbSupport

java.lang.Object

io.jmix.dynmodel.impl.db.DynamicModelDbSupport

io.jmix.dynmodel.impl.db.MySqlDynamicModelDbSupport

Direct Known Subclasses:

MariaDbDynamicModelDbSupport

public class MySqlDynamicModelDbSupport
extends DynamicModelDbSupport

Field Summary

Fields inherited from class io.jmix.dynmodel.impl.db.DynamicModelDbSupport

DEFAULT_BYTES_LENGTH, DEFAULT_STRING_LENGTH, DEFAULT_URI_LENGTH, FALLBACK_IDENTIFIER, IDENTIFIER_HASH_LENGTH, maxIdentifierLength, metadataTools, reservedWords, STANDARD_RESERVED_WORDS

Constructor Summary

Constructors

Constructor	Description
MySqlDynamicModelDbSupport()

Method Summary

Modifier and Type	Method	Description
String	applyPaging(String sql, int firstResult, int maxResults)
String	getAlterColumnTypeSql(String tableName, String columnName, String columnType)	Returns SQL that changes the type/length of an existing column.
protected String	getBooleanType()
protected String	getBytesLobType()
String	getDropUniqueConstraintSql(String tableName, String constraintName)	Returns SQL that drops a unique constraint for the given table.
protected String	getDuplicateConstraintPattern()
String	getLikeEscapeClause()	Returns the ESCAPE clause (including the leading space) appended to a raw-SQL LIKE predicate that escapes wildcards with a backslash.
protected String	getOffsetDateTimeType()
protected String	getOffsetTimeType()
protected String	getStringLobType()
protected String	getUniqueConstraintViolationPattern()
protected String	getUuidSqlType()
protected Object	toDbOffsetDateTime(OffsetDateTime value)
protected Object	toDbOffsetTime(OffsetTime value)
protected Object	toDbUuid(UUID uuid)
protected OffsetDateTime	toOffsetDateTime(Object dbValue)
protected OffsetTime	toOffsetTime(Object dbValue)
protected UUID	toUuid(Object value)
boolean	uniqueConstraintExists(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate, String tableName, String constraintName)	Checks whether the named unique constraint already exists on the given table.

Methods inherited from class io.jmix.dynmodel.impl.db.DynamicModelDbSupport

appendTrailingUnderscore, canonicalizeIdentifier, configureIdentifierRules, extractUniqueConstraintName, getAddColumnSql, getBytesType, getCreateUniqueConstraintSql, getDoubleType, getEnumIdType, getFloatType, getLength, getLocalDateTimeType, getLocalTimeType, getReferenceJavaType, getSqlType, getSqlTypeByJavaType, getStringType, getUniqueDuplicateCheckPredicate, hashIdentifier, isDuplicateConstraintException, isLob, isReservedWord, normalizeGeneratedIdentifier, resolveConstraintName, setMetadataTools, shortenIdentifier, toBoolean, toByteArray, toDbBoolean, toDbLocalTime, toDbValue, toEnumValue, toLocalDate, toLocalDateTime, toLocalTime, toNumber, toPropertyValue, toUnderscoreSeparated

Methods inherited from class java.lang.Object

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

Constructor Details

MySqlDynamicModelDbSupport

public MySqlDynamicModelDbSupport()

Method Details

getUuidSqlType

protected String getUuidSqlType()

Specified by:

getUuidSqlType in class DynamicModelDbSupport

getStringLobType

protected String getStringLobType()

Overrides:

getStringLobType in class DynamicModelDbSupport

getBytesLobType

protected String getBytesLobType()

Overrides:

getBytesLobType in class DynamicModelDbSupport

getBooleanType

protected String getBooleanType()

Overrides:

getBooleanType in class DynamicModelDbSupport

applyPaging

public String applyPaging(String sql,
 int firstResult,
 int maxResults)

Overrides:

applyPaging in class DynamicModelDbSupport

getLikeEscapeClause

public String getLikeEscapeClause()

Description copied from class: DynamicModelDbSupport

Returns the ESCAPE clause (including the leading space) appended to a raw-SQL LIKE predicate that escapes wildcards with a backslash. The default emits a single backslash; MySQL/MariaDB interpret backslashes inside string literals and override this to emit a doubled backslash.

Overrides:

getLikeEscapeClause in class DynamicModelDbSupport

getOffsetTimeType

protected String getOffsetTimeType()

Overrides:

getOffsetTimeType in class DynamicModelDbSupport

getOffsetDateTimeType

protected String getOffsetDateTimeType()

Overrides:

getOffsetDateTimeType in class DynamicModelDbSupport

toDbUuid

protected Object toDbUuid(UUID uuid)

Overrides:

toDbUuid in class DynamicModelDbSupport

toUuid

protected UUID toUuid(Object value)

Overrides:

toUuid in class DynamicModelDbSupport

toDbOffsetTime

protected Object toDbOffsetTime(OffsetTime value)

Overrides:

toDbOffsetTime in class DynamicModelDbSupport

toDbOffsetDateTime

protected Object toDbOffsetDateTime(OffsetDateTime value)

Overrides:

toDbOffsetDateTime in class DynamicModelDbSupport

toOffsetTime

protected OffsetTime toOffsetTime(Object dbValue)

Overrides:

toOffsetTime in class DynamicModelDbSupport

toOffsetDateTime

protected OffsetDateTime toOffsetDateTime(Object dbValue)

Overrides:

toOffsetDateTime in class DynamicModelDbSupport

getAlterColumnTypeSql

public String getAlterColumnTypeSql(String tableName,
 String columnName,
 String columnType)

Description copied from class: DynamicModelDbSupport

Returns SQL that changes the type/length of an existing column.

Overrides:

getAlterColumnTypeSql in class DynamicModelDbSupport

Parameters:

tableName - physical table name

columnName - physical column name

columnType - new physical column type

Returns:

DDL statement

getDropUniqueConstraintSql

public String getDropUniqueConstraintSql(String tableName,
 String constraintName)

Description copied from class: DynamicModelDbSupport

Returns SQL that drops a unique constraint for the given table.

Overrides:

getDropUniqueConstraintSql in class DynamicModelDbSupport

Parameters:

tableName - physical table name

constraintName - physical constraint name

Returns:

DDL statement

uniqueConstraintExists

public boolean uniqueConstraintExists(org.springframework.jdbc.core.JdbcTemplate jdbcTemplate,
 String tableName,
 String constraintName)

Description copied from class: DynamicModelDbSupport

Checks whether the named unique constraint already exists on the given table.

Overrides:

uniqueConstraintExists in class DynamicModelDbSupport

Parameters:

jdbcTemplate - JDBC template for the target store

tableName - physical table name

constraintName - physical constraint name

Returns:

true if the constraint already exists

getUniqueConstraintViolationPattern

protected String getUniqueConstraintViolationPattern()

Overrides:

getUniqueConstraintViolationPattern in class DynamicModelDbSupport

getDuplicateConstraintPattern

protected String getDuplicateConstraintPattern()

Overrides:

getDuplicateConstraintPattern in class DynamicModelDbSupport