Package io.jmix.dynmodel.impl.db

Class OracleDynamicModelDbSupport

java.lang.Object

io.jmix.dynmodel.impl.db.DynamicModelDbSupport

io.jmix.dynmodel.impl.db.OracleDynamicModelDbSupport

public class OracleDynamicModelDbSupport
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
OracleDynamicModelDbSupport()

Method Summary

Modifier and Type	Method	Description
String	getAddColumnSql(String tableName, String columnName, String columnType)	Returns SQL that adds a single column to an existing table.
String	getAlterColumnTypeSql(String tableName, String columnName, String columnType)	Returns SQL that changes the type/length of an existing column.
protected String	getBooleanType()
protected String	getBytesType(int length)
protected String	getDoubleType()
protected String	getDuplicateConstraintPattern()
protected String	getFloatType()
protected String	getLocalTimeType()
protected String	getOffsetDateTimeType()
protected String	getOffsetTimeType()
protected String	getSqlTypeByJavaType(Class<?> javaType, MetaProperty property)
protected String	getStringType(int length)
protected String	getUniqueConstraintViolationPattern()
String	getUniqueDuplicateCheckPredicate(List<String> columnNames)	Returns the WHERE predicate (without the WHERE keyword) that excludes rows from the duplicate-data pre-check run before adding a unique constraint, reflecting how this DBMS treats NULLs in unique keys.
protected String	getUuidSqlType()
protected Boolean	toBoolean(Object dbValue)
protected Object	toDbBoolean(Boolean value)
protected Object	toDbLocalTime(LocalTime value)
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, applyPaging, canonicalizeIdentifier, configureIdentifierRules, extractUniqueConstraintName, getBytesLobType, getCreateUniqueConstraintSql, getDropUniqueConstraintSql, getEnumIdType, getLength, getLikeEscapeClause, getLocalDateTimeType, getReferenceJavaType, getSqlType, getStringLobType, hashIdentifier, isDuplicateConstraintException, isLob, isReservedWord, normalizeGeneratedIdentifier, resolveConstraintName, setMetadataTools, shortenIdentifier, toByteArray, 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

OracleDynamicModelDbSupport

public OracleDynamicModelDbSupport()

Method Details

getAddColumnSql

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

Description copied from class: DynamicModelDbSupport

Returns SQL that adds a single column to an existing table.

Overrides:

getAddColumnSql in class DynamicModelDbSupport

Parameters:

tableName - physical table name

columnName - physical column name

columnType - physical column type

Returns:

DDL statement

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

getUniqueDuplicateCheckPredicate

public String getUniqueDuplicateCheckPredicate(List<String> columnNames)

Description copied from class: DynamicModelDbSupport

Returns the WHERE predicate (without the WHERE keyword) that excludes rows from the duplicate-data pre-check run before adding a unique constraint, reflecting how this DBMS treats NULLs in unique keys. The default treats NULLs as distinct, so a row with a NULL in any constrained column never collides and is ignored. Returns an empty string when no rows should be excluded.

Overrides:

getUniqueDuplicateCheckPredicate in class DynamicModelDbSupport

getSqlTypeByJavaType

protected String getSqlTypeByJavaType(Class<?> javaType,
 MetaProperty property)

Overrides:

getSqlTypeByJavaType in class DynamicModelDbSupport

getUuidSqlType

protected String getUuidSqlType()

Specified by:

getUuidSqlType in class DynamicModelDbSupport

getStringType

protected String getStringType(int length)

Overrides:

getStringType in class DynamicModelDbSupport

getBytesType

protected String getBytesType(int length)

Overrides:

getBytesType in class DynamicModelDbSupport

getBooleanType

protected String getBooleanType()

Overrides:

getBooleanType in class DynamicModelDbSupport

getLocalTimeType

protected String getLocalTimeType()

Overrides:

getLocalTimeType in class DynamicModelDbSupport

toDbLocalTime

protected Object toDbLocalTime(LocalTime value)

Overrides:

toDbLocalTime in class DynamicModelDbSupport

getDoubleType

protected String getDoubleType()

Overrides:

getDoubleType in class DynamicModelDbSupport

getFloatType

protected String getFloatType()

Overrides:

getFloatType 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

toDbBoolean

protected Object toDbBoolean(Boolean value)

Overrides:

toDbBoolean in class DynamicModelDbSupport

toBoolean

protected Boolean toBoolean(Object dbValue)

Overrides:

toBoolean in class DynamicModelDbSupport

toDbOffsetTime

protected Object toDbOffsetTime(OffsetTime value)

Overrides:

toDbOffsetTime in class DynamicModelDbSupport

toOffsetTime

protected OffsetTime toOffsetTime(Object dbValue)

Overrides:

toOffsetTime in class DynamicModelDbSupport

toDbOffsetDateTime

protected Object toDbOffsetDateTime(OffsetDateTime value)

Overrides:

toDbOffsetDateTime in class DynamicModelDbSupport

toOffsetDateTime

protected OffsetDateTime toOffsetDateTime(Object dbValue)

Overrides:

toOffsetDateTime in class DynamicModelDbSupport

getUniqueConstraintViolationPattern

protected String getUniqueConstraintViolationPattern()

Overrides:

getUniqueConstraintViolationPattern in class DynamicModelDbSupport

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

getDuplicateConstraintPattern

protected String getDuplicateConstraintPattern()

Overrides:

getDuplicateConstraintPattern in class DynamicModelDbSupport