Package io.jmix.dynmodel.impl.db

Class SqlServerDynamicModelDbSupport

java.lang.Object

io.jmix.dynmodel.impl.db.DynamicModelDbSupport

io.jmix.dynmodel.impl.db.SqlServerDynamicModelDbSupport

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

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.
protected String	getBooleanType()
protected String	getBytesLobType()
protected String	getBytesType(int length)
protected String	getDoubleType()
protected String	getDuplicateConstraintPattern()
protected String	getLocalDateTimeType()
protected String	getOffsetDateTimeType()
protected String	getOffsetTimeType()
protected String	getStringLobType()
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 Object	toDbOffsetDateTime(OffsetDateTime value)
protected Object	toDbOffsetTime(OffsetTime value)
protected OffsetDateTime	toOffsetDateTime(Object dbValue)
protected OffsetTime	toOffsetTime(Object dbValue)
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, getAlterColumnTypeSql, getCreateUniqueConstraintSql, getDropUniqueConstraintSql, getEnumIdType, getFloatType, getLength, getLikeEscapeClause, getLocalTimeType, getReferenceJavaType, getSqlType, getSqlTypeByJavaType, hashIdentifier, isDuplicateConstraintException, isLob, isReservedWord, normalizeGeneratedIdentifier, resolveConstraintName, setMetadataTools, shortenIdentifier, toBoolean, toByteArray, toDbBoolean, toDbLocalTime, toDbUuid, toDbValue, toEnumValue, toLocalDate, toLocalDateTime, toLocalTime, toNumber, toPropertyValue, toUnderscoreSeparated, toUuid

Methods inherited from class java.lang.Object

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

Constructor Details

SqlServerDynamicModelDbSupport

public SqlServerDynamicModelDbSupport()

Method Details

getUuidSqlType

protected String getUuidSqlType()

Specified by:

getUuidSqlType in class DynamicModelDbSupport

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

getStringType

protected String getStringType(int length)

Overrides:

getStringType in class DynamicModelDbSupport

getStringLobType

protected String getStringLobType()

Overrides:

getStringLobType in class DynamicModelDbSupport

getBytesType

protected String getBytesType(int length)

Overrides:

getBytesType in class DynamicModelDbSupport

getBytesLobType

protected String getBytesLobType()

Overrides:

getBytesLobType in class DynamicModelDbSupport

getBooleanType

protected String getBooleanType()

Overrides:

getBooleanType in class DynamicModelDbSupport

getDoubleType

protected String getDoubleType()

Overrides:

getDoubleType in class DynamicModelDbSupport

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

getLocalDateTimeType

protected String getLocalDateTimeType()

Overrides:

getLocalDateTimeType in class DynamicModelDbSupport

getOffsetTimeType

protected String getOffsetTimeType()

Overrides:

getOffsetTimeType in class DynamicModelDbSupport

getOffsetDateTimeType

protected String getOffsetDateTimeType()

Overrides:

getOffsetDateTimeType 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