Package com.valqueries.automapper

Class MssqlSqlDialect

java.lang.Object

com.valqueries.automapper.MssqlSqlDialect

All Implemented Interfaces:

SqlDialect

public class MssqlSqlDialect
extends Object
implements SqlDialect

Constructor Summary

Constructors

Constructor	Description
MssqlSqlDialect()

Method Summary

Modifier and Type	Method	Description
String	addColumn(TableToken tablename, ColumnToken columnName, String sqlType)
boolean	allowsConversion(Clazz<?> sqlType, String type)
String	defaultOrderStatement()
String	describe(TableToken tablename)
String	describeIndex(TableToken tablename)
String	escapeColumnOrTable(String name)
String	generateAlterColumnPartStatement(ColumnToken name)
String	generateDeleteStatement(String tableAlias, TableToken table, List<Element> elements, Integer limit)
String	generateDropIndexStatement(TableToken tableName, IndexToken index, boolean isPrimary)
String	generateIndexOnCreateStatement(TableToken tableName, KeySet keyset, boolean isUnique)
String	generateIndexStatement(TableToken tablename, KeySet key)
String	generatePrimaryKeyStatement(TableToken name, KeySet key)
String	generateUpdateStatement(TableToken table, List<Element> elements, List<Property.PropertyValue<?>> newPropertyValues, List<Property.PropertyValue<?>> incrementPropertyValues)
<O> String	getCustomUpsert(CompoundColumnizer<O> columnizer, Class<O> modelType, List<Property.PropertyValue<?>> newValues, List<Property.PropertyValue<?>> incrementValues, List<Property<?>> setObjValues, List<Property<?>> incrementByObjValues)
SqlDescriber.DbRow	getDescribeDbResult(OrmResultSet ormResultSet)
SqlDescriber.DbIndex	getDescribeIndexResult(OrmResultSet r)
<O> String	getInsertAutoIncrement(CompoundColumnizer<O> columnizer, Class<O> oClass, List<Boolean> keyNulls)
String	getLimitDefinition(int offset, int limit)
String	getSqlType(Property<?> property)
<O> String	getUpsert(CompoundColumnizer<O> columnizer, Class<O> oClass)
<O> String	getUpsertAutoIncrement(CompoundColumnizer<O> columnizer, Class<O> oClass, List<Boolean> keyNulls)
String	groupConcat(Property<?> resultProperty, String separator)
Object	harmonizeLikeValue(Object value)	Harmonize the value to be used in a LIKE statement.
boolean	isDuplicateKeyEntry(Exception e)	Check whether an exception was caused by a duplicate value for primary or unique key.
boolean	isOrderRequiredForOffset()

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.valqueries.automapper.SqlDialect

_column, buildSelectSql, column, dropTableStatement, generateDeleteStatement, generateDistinctSelectStatement, generateUpdateStatement, getAddColumnStatement, getInsert, getTableName, getUniqueKeyCheck, operator, operator, operator, prepareColumnOrTable, table

Constructor Details

MssqlSqlDialect

public MssqlSqlDialect()

Method Details

escapeColumnOrTable

public String escapeColumnOrTable(String name)

Specified by:

escapeColumnOrTable in interface SqlDialect

getUpsert

public <O> String getUpsert(CompoundColumnizer<O> columnizer,
 Class<O> oClass)

Specified by:

getUpsert in interface SqlDialect

getUpsertAutoIncrement

public <O> String getUpsertAutoIncrement(CompoundColumnizer<O> columnizer,
 Class<O> oClass,
 List<Boolean> keyNulls)

Specified by:

getUpsertAutoIncrement in interface SqlDialect

getSqlType

public String getSqlType(Property<?> property)

Specified by:

getSqlType in interface SqlDialect

isOrderRequiredForOffset

public boolean isOrderRequiredForOffset()

Specified by:

isOrderRequiredForOffset in interface SqlDialect

defaultOrderStatement

public String defaultOrderStatement()

Specified by:

defaultOrderStatement in interface SqlDialect

getLimitDefinition

public String getLimitDefinition(int offset,
 int limit)

Specified by:

getLimitDefinition in interface SqlDialect

generateUpdateStatement

public String generateUpdateStatement(TableToken table,
 List<Element> elements,
 List<Property.PropertyValue<?>> newPropertyValues,
 List<Property.PropertyValue<?>> incrementPropertyValues)

Specified by:

generateUpdateStatement in interface SqlDialect

getInsertAutoIncrement

public <O> String getInsertAutoIncrement(CompoundColumnizer<O> columnizer,
 Class<O> oClass,
 List<Boolean> keyNulls)

Specified by:

getInsertAutoIncrement in interface SqlDialect

generateDeleteStatement

public String generateDeleteStatement(String tableAlias,
 TableToken table,
 List<Element> elements,
 Integer limit)

Specified by:

generateDeleteStatement in interface SqlDialect

describe

public String describe(TableToken tablename)

Specified by:

describe in interface SqlDialect

describeIndex

public String describeIndex(TableToken tablename)

Specified by:

describeIndex in interface SqlDialect

getDescribeDbResult

public SqlDescriber.DbRow getDescribeDbResult(OrmResultSet ormResultSet)

Specified by:

getDescribeDbResult in interface SqlDialect

getDescribeIndexResult

public SqlDescriber.DbIndex getDescribeIndexResult(OrmResultSet r)

Specified by:

getDescribeIndexResult in interface SqlDialect

generatePrimaryKeyStatement

public String generatePrimaryKeyStatement(TableToken name,
 KeySet key)

Specified by:

generatePrimaryKeyStatement in interface SqlDialect

generateIndexStatement

public String generateIndexStatement(TableToken tablename,
 KeySet key)

Specified by:

generateIndexStatement in interface SqlDialect

addColumn

public String addColumn(TableToken tablename,
 ColumnToken columnName,
 String sqlType)

generateAlterColumnPartStatement

public String generateAlterColumnPartStatement(ColumnToken name)

Specified by:

generateAlterColumnPartStatement in interface SqlDialect

generateIndexOnCreateStatement

public String generateIndexOnCreateStatement(TableToken tableName,
 KeySet keyset,
 boolean isUnique)

generateDropIndexStatement

public String generateDropIndexStatement(TableToken tableName,
 IndexToken index,
 boolean isPrimary)

Specified by:

generateDropIndexStatement in interface SqlDialect

allowsConversion

public boolean allowsConversion(Clazz<?> sqlType,
 String type)

Specified by:

allowsConversion in interface SqlDialect

groupConcat

public String groupConcat(Property<?> resultProperty,
 String separator)

Specified by:

groupConcat in interface SqlDialect

isDuplicateKeyEntry

public boolean isDuplicateKeyEntry(Exception e)

Description copied from interface: SqlDialect

Check whether an exception was caused by a duplicate value for primary or unique key.

Specified by:

isDuplicateKeyEntry in interface SqlDialect

Parameters:

e - the exception to be tested

Returns:

whether the exception was caused by a unique constraint violation

harmonizeLikeValue

public Object harmonizeLikeValue(Object value)

Description copied from interface: SqlDialect

Harmonize the value to be used in a LIKE statement.

Some databases (e.g. MSSQL) allow for a broader range of special operations to be performed in a LIKE statement. This method takes in the value to be used in a LIKE statement and returns a value that performs the same operation in the current database.

For example, in MSSQL, the value "a[bc]" would match "a", "ab", or "ac", but in MySQL, it would match "a[bc]". As such the value "a[bc]" would need to be harmonized to "a[[]bc]" when used in a LIKE statement in MSSQL.

Specified by:

harmonizeLikeValue in interface SqlDialect

Parameters:

value - the value to be harmonized

Returns:

the harmonized value

getCustomUpsert

public <O> String getCustomUpsert(CompoundColumnizer<O> columnizer,
 Class<O> modelType,
 List<Property.PropertyValue<?>> newValues,
 List<Property.PropertyValue<?>> incrementValues,
 List<Property<?>> setObjValues,
 List<Property<?>> incrementByObjValues)

Specified by:

getCustomUpsert in interface SqlDialect