com.mysema.query.sql

Class SQLTemplates

java.lang.Object

com.mysema.query.types.Templates

com.mysema.query.sql.SQLTemplates

Direct Known Subclasses:

CUBRIDTemplates, DB2Templates, DerbyTemplates, FirebirdTemplates, H2Templates, HSQLDBTemplates, MySQLTemplates, OracleTemplates, PostgresTemplates, SQLiteTemplates, SQLServerTemplates, TeradataTemplates

public class SQLTemplates
extends Templates

SQLTemplates extends Templates to provides SQL specific extensions and acts as database specific Dialect for Querydsl SQL

Author:

tiwe

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SQLTemplates.Builder

Field Summary

Fields

Modifier and Type	Field and Description
static SQLTemplates	DEFAULT
static Expression<?>	RECURSIVE
protected static Set<String>	SQL_RESERVED_WORDS

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	SQLTemplates(Set<String> reservedKeywords, String quoteStr, char escape, boolean useQuotes)
protected	SQLTemplates(String quoteStr, char escape, boolean useQuotes) Deprecated.

Method Summary

Methods

Modifier and Type	Method and Description
protected void	addCustomType(Type<?> type)
protected void	addTableOverride(SchemaAndTable from, SchemaAndTable to)
protected void	addTypeNameToCode(String type, int code)
protected void	addTypeNameToCode(String type, int code, boolean override)
String	escapeLiteral(String str)
String	getAsc()
String	getAutoIncrement()
String	getCastTypeNameForCode(int code)
Integer	getCodeForTypeName(String type)
String	getColumnAlias()
String	getCount()
String	getCountStar()
String	getCreateIndex()
String	getCreateTable()
String	getCreateUniqueIndex()
List<Type<?>>	getCustomTypes()
String	getDefaultValues()
String	getDelete()
String	getDesc()
String	getDistinctCountEnd()
String	getDistinctCountStart()
String	getDummyTable()
String	getFrom()
String	getFullJoin()
String	getGroupBy()
String	getHaving()
String	getInnerJoin()
String	getInsertInto()
String	getJoin()
String	getJoinSymbol(JoinType joinType)
String	getKey()
String	getLeftJoin()
String	getLimitTemplate()
int	getListMaxSize()
String	getMergeInto()
String	getNotNull()
String	getNullsFirst()
String	getNullsLast()
String	getOffsetTemplate()
String	getOn()
String	getOrderBy()
String	getRightJoin()
String	getSelect()
String	getSelectDistinct()
String	getSet()
String	getTableAlias()
Map<SchemaAndTable,SchemaAndTable>	getTableOverrides()
String	getTypeForCast(Class<?> cl) Deprecated.
String	getTypeForClass(Class<?> cl) Deprecated.
String	getTypeNameForCode(int code)
String	getUpdate()
String	getValues()
String	getWhere()
String	getWith()
String	getWithRecursive()
boolean	isArraysSupported()
boolean	isBatchCountViaGetUpdateCount()
boolean	isBigDecimalSupported() Deprecated.
boolean	isCountDistinctMultipleColumns()
boolean	isCountViaAnalytics()
boolean	isFunctionJoinsWrapped()
boolean	isLimitRequired()
boolean	isNativeMerge()
boolean	isParameterMetadataAvailable()
boolean	isPrintSchema()
boolean	isSupportsAlias()
boolean	isSupportsUnquotedReservedWordsAsIdentifier()
boolean	isUnionsWrapped()
boolean	isUseQuotes()
boolean	isWrapSelectParameters()
protected void	newLineToSingleSpace()
String	quoteIdentifier(String identifier)
String	quoteIdentifier(String identifier, boolean precededByDot)
protected boolean	requiresQuotes(String identifier, boolean precededByDot)
void	serialize(QueryMetadata metadata, boolean forCountRow, SQLSerializer context) template method for SELECT serialization
String	serialize(String literal, int jdbcType)
void	serializeDelete(QueryMetadata metadata, RelationalPath<?> entity, SQLSerializer context) template method for DELETE serialization
void	serializeInsert(QueryMetadata metadata, RelationalPath<?> entity, List<Path<?>> columns, List<Expression<?>> values, SubQueryExpression<?> subQuery, SQLSerializer context) template method for INSERT serialization
void	serializeMerge(QueryMetadata metadata, RelationalPath<?> entity, List<Path<?>> keys, List<Path<?>> columns, List<Expression<?>> values, SubQueryExpression<?> subQuery, SQLSerializer context) template method for MERGE serialization
protected void	serializeModifiers(QueryMetadata metadata, SQLSerializer context) template method for LIMIT and OFFSET serialization
void	serializeUpdate(QueryMetadata metadata, RelationalPath<?> entity, List<com.mysema.commons.lang.Pair<Path<?>,Expression<?>>> updates, SQLSerializer context) template method for UPDATE serialization
protected void	setArraysSupported(boolean b)
protected void	setAsc(String asc)
protected void	setAutoIncrement(String autoIncrement)
protected void	setBatchCountViaGetUpdateCount(boolean batchCountViaGetUpdateCount)
protected void	setColumnAlias(String columnAlias)
protected void	setCount(String count)
protected void	setCountDistinctMultipleColumns(boolean countDistinctMultipleColumns)
protected void	setCountStar(String countStar)
protected void	setCountViaAnalytics(boolean countViaAnalytics)
protected void	setCreateIndex(String createIndex)
protected void	setCreateTable(String createTable)
protected void	setCreateUniqueIndex(String createUniqueIndex)
protected void	setDefaultValues(String defaultValues)
protected void	setDelete(String delete)
protected void	setDesc(String desc)
protected void	setDistinctCountEnd(String distinctCountEnd)
protected void	setDistinctCountStart(String distinctCountStart)
protected void	setDummyTable(String dummyTable)
protected void	setFrom(String from)
protected void	setFullJoin(String fullJoin)
protected void	setFunctionJoinsWrapped(boolean functionJoinsWrapped)
protected void	setGroupBy(String groupBy)
protected void	setHaving(String having)
protected void	setInnerJoin(String innerJoin)
protected void	setInsertInto(String insertInto)
protected void	setJoin(String join)
protected void	setKey(String key)
protected void	setLeftJoin(String leftJoin)
protected void	setLimitRequired(boolean limitRequired)
protected void	setListMaxSize(int i)
protected void	setMergeInto(String mergeInto)
protected void	setNativeMerge(boolean nativeMerge)
protected void	setNotNull(String notNull)
protected void	setNullsFirst(String nullsFirst)
protected void	setNullsLast(String nullsLast)
protected void	setOffsetTemplate(String offsetTemplate)
protected void	setOn(String on)
protected void	setOrderBy(String orderBy)
protected void	setParameterMetadataAvailable(boolean parameterMetadataAvailable)
protected void	setPrintSchema(boolean printSchema)
protected void	setRightJoin(String rightJoin)
protected void	setSelect(String select)
protected void	setSelectDistinct(String selectDistinct)
protected void	setSet(String set)
void	setSupportsUnquotedReservedWordsAsIdentifier(boolean b)
protected void	setTableAlias(String tableAlias)
protected void	setUnionsWrapped(boolean unionsWrapped)
protected void	setUpdate(String update)
protected void	setValues(String values)
protected void	setWhere(String where)
protected void	setWith(String with)
protected void	setWithRecursive(String withRecursive)
protected void	setWrapSelectParameters(boolean b)

Methods inherited from class com.mysema.query.types.Templates

add, add, add, escapeForLike, getEscapeChar, getPrecedence, getTemplate

Methods inherited from class java.lang.Object

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

Field Detail

SQL_RESERVED_WORDS

protected static final Set<String> SQL_RESERVED_WORDS

RECURSIVE

public static final Expression<?> RECURSIVE

DEFAULT

public static final SQLTemplates DEFAULT

Constructor Detail

SQLTemplates

@Deprecated
protected SQLTemplates(String quoteStr,
                       char escape,
                       boolean useQuotes)

Deprecated.

SQLTemplates

protected SQLTemplates(Set<String> reservedKeywords,
            String quoteStr,
            char escape,
            boolean useQuotes)

Method Detail

serialize

public String serialize(String literal,
               int jdbcType)

escapeLiteral

public String escapeLiteral(String str)

addTypeNameToCode

protected void addTypeNameToCode(String type,
                     int code,
                     boolean override)

addTypeNameToCode

protected void addTypeNameToCode(String type,
                     int code)

addTableOverride

protected void addTableOverride(SchemaAndTable from,
                    SchemaAndTable to)

isBigDecimalSupported

@Deprecated
public final boolean isBigDecimalSupported()

Deprecated.

Use customTypes instead

getCustomTypes

public final List<Type<?>> getCustomTypes()

getAsc

public final String getAsc()

getAutoIncrement

public final String getAutoIncrement()

getColumnAlias

public final String getColumnAlias()

getCount

public final String getCount()

getCountStar

public final String getCountStar()

getDelete

public final String getDelete()

getDesc

public final String getDesc()

getDistinctCountEnd

public final String getDistinctCountEnd()

getDistinctCountStart

public final String getDistinctCountStart()

getDummyTable

public final String getDummyTable()

getFrom

public final String getFrom()

getFullJoin

public final String getFullJoin()

getGroupBy

public final String getGroupBy()

getHaving

public final String getHaving()

getInnerJoin

public final String getInnerJoin()

getInsertInto

public final String getInsertInto()

getJoin

public final String getJoin()

getJoinSymbol

public final String getJoinSymbol(JoinType joinType)

getKey

public final String getKey()

getLeftJoin

public final String getLeftJoin()

getRightJoin

public final String getRightJoin()

getLimitTemplate

public final String getLimitTemplate()

getMergeInto

public final String getMergeInto()

getNotNull

public final String getNotNull()

getOffsetTemplate

public final String getOffsetTemplate()

getOn

public final String getOn()

getOrderBy

public final String getOrderBy()

getSelect

public final String getSelect()

getSelectDistinct

public final String getSelectDistinct()

getSet

public final String getSet()

getTableAlias

public final String getTableAlias()

getTableOverrides

public final Map<SchemaAndTable,SchemaAndTable> getTableOverrides()

getTypeForCast

@Deprecated
public String getTypeForCast(Class<?> cl)

Deprecated.

getTypeForClass

@Deprecated
public String getTypeForClass(Class<?> cl)

Deprecated.

getTypeNameForCode

public String getTypeNameForCode(int code)

getCastTypeNameForCode

public String getCastTypeNameForCode(int code)

getCodeForTypeName

public Integer getCodeForTypeName(String type)

getUpdate

public final String getUpdate()

getValues

public final String getValues()

getDefaultValues

public final String getDefaultValues()

getWhere

public final String getWhere()

isNativeMerge

public final boolean isNativeMerge()

isSupportsAlias

public final boolean isSupportsAlias()

getCreateIndex

public final String getCreateIndex()

getCreateUniqueIndex

public final String getCreateUniqueIndex()

getCreateTable

public final String getCreateTable()

getWith

public final String getWith()

getWithRecursive

public final String getWithRecursive()

isCountDistinctMultipleColumns

public final boolean isCountDistinctMultipleColumns()

isPrintSchema

public final boolean isPrintSchema()

isParameterMetadataAvailable

public final boolean isParameterMetadataAvailable()

isBatchCountViaGetUpdateCount

public final boolean isBatchCountViaGetUpdateCount()

isUseQuotes

public final boolean isUseQuotes()

isUnionsWrapped

public final boolean isUnionsWrapped()

isFunctionJoinsWrapped

public final boolean isFunctionJoinsWrapped()

isLimitRequired

public final boolean isLimitRequired()

getNullsFirst

public final String getNullsFirst()

getNullsLast

public final String getNullsLast()

isCountViaAnalytics

public boolean isCountViaAnalytics()

isWrapSelectParameters

public boolean isWrapSelectParameters()

isArraysSupported

public boolean isArraysSupported()

getListMaxSize

public int getListMaxSize()

isSupportsUnquotedReservedWordsAsIdentifier

public boolean isSupportsUnquotedReservedWordsAsIdentifier()

newLineToSingleSpace

protected void newLineToSingleSpace()

quoteIdentifier

public final String quoteIdentifier(String identifier)

quoteIdentifier

public final String quoteIdentifier(String identifier,
                     boolean precededByDot)

requiresQuotes

protected boolean requiresQuotes(String identifier,
                     boolean precededByDot)

serialize

public void serialize(QueryMetadata metadata,
             boolean forCountRow,
             SQLSerializer context)

template method for SELECT serialization

Parameters:

metadata -

forCountRow -

context -

serializeDelete

public void serializeDelete(QueryMetadata metadata,
                   RelationalPath<?> entity,
                   SQLSerializer context)

template method for DELETE serialization

Parameters:

metadata -

entity -

context -

serializeInsert

public void serializeInsert(QueryMetadata metadata,
                   RelationalPath<?> entity,
                   List<Path<?>> columns,
                   List<Expression<?>> values,
                   SubQueryExpression<?> subQuery,
                   SQLSerializer context)

template method for INSERT serialization

Parameters:

metadata -

entity -

columns -

values -

subQuery -

context -

serializeMerge

public void serializeMerge(QueryMetadata metadata,
                  RelationalPath<?> entity,
                  List<Path<?>> keys,
                  List<Path<?>> columns,
                  List<Expression<?>> values,
                  SubQueryExpression<?> subQuery,
                  SQLSerializer context)

template method for MERGE serialization

Parameters:

metadata -

entity -

keys -

columns -

values -

subQuery -

context -

serializeUpdate

public void serializeUpdate(QueryMetadata metadata,
                   RelationalPath<?> entity,
                   List<com.mysema.commons.lang.Pair<Path<?>,Expression<?>>> updates,
                   SQLSerializer context)

template method for UPDATE serialization

Parameters:

metadata -

entity -

updates -

context -

serializeModifiers

protected void serializeModifiers(QueryMetadata metadata,
                      SQLSerializer context)

template method for LIMIT and OFFSET serialization

Parameters:

metadata -

context -

addCustomType

protected void addCustomType(Type<?> type)

setAsc

protected void setAsc(String asc)

setAutoIncrement

protected void setAutoIncrement(String autoIncrement)

setColumnAlias

protected void setColumnAlias(String columnAlias)

setCount

protected void setCount(String count)

setCountStar

protected void setCountStar(String countStar)

setDelete

protected void setDelete(String delete)

setDesc

protected void setDesc(String desc)

setDistinctCountEnd

protected void setDistinctCountEnd(String distinctCountEnd)

setDistinctCountStart

protected void setDistinctCountStart(String distinctCountStart)

setDummyTable

protected void setDummyTable(String dummyTable)

setFrom

protected void setFrom(String from)

setFullJoin

protected void setFullJoin(String fullJoin)

setGroupBy

protected void setGroupBy(String groupBy)

setHaving

protected void setHaving(String having)

setInnerJoin

protected void setInnerJoin(String innerJoin)

setInsertInto

protected void setInsertInto(String insertInto)

setJoin

protected void setJoin(String join)

setKey

protected void setKey(String key)

setLeftJoin

protected void setLeftJoin(String leftJoin)

setRightJoin

protected void setRightJoin(String rightJoin)

setMergeInto

protected void setMergeInto(String mergeInto)

setNativeMerge

protected void setNativeMerge(boolean nativeMerge)

setNotNull

protected void setNotNull(String notNull)

setOffsetTemplate

protected void setOffsetTemplate(String offsetTemplate)

setOn

protected void setOn(String on)

setOrderBy

protected void setOrderBy(String orderBy)

setSelect

protected void setSelect(String select)

setSelectDistinct

protected void setSelectDistinct(String selectDistinct)

setSet

protected void setSet(String set)

setTableAlias

protected void setTableAlias(String tableAlias)

setUpdate

protected void setUpdate(String update)

setValues

protected void setValues(String values)

setDefaultValues

protected void setDefaultValues(String defaultValues)

setWhere

protected void setWhere(String where)

setWith

protected void setWith(String with)

setWithRecursive

protected void setWithRecursive(String withRecursive)

setCreateIndex

protected void setCreateIndex(String createIndex)

setCreateUniqueIndex

protected void setCreateUniqueIndex(String createUniqueIndex)

setCreateTable

protected void setCreateTable(String createTable)

setPrintSchema

protected void setPrintSchema(boolean printSchema)

setParameterMetadataAvailable

protected void setParameterMetadataAvailable(boolean parameterMetadataAvailable)

setBatchCountViaGetUpdateCount

protected void setBatchCountViaGetUpdateCount(boolean batchCountViaGetUpdateCount)

setUnionsWrapped

protected void setUnionsWrapped(boolean unionsWrapped)

setFunctionJoinsWrapped

protected void setFunctionJoinsWrapped(boolean functionJoinsWrapped)

setNullsFirst

protected void setNullsFirst(String nullsFirst)

setNullsLast

protected void setNullsLast(String nullsLast)

setLimitRequired

protected void setLimitRequired(boolean limitRequired)

setCountDistinctMultipleColumns

protected void setCountDistinctMultipleColumns(boolean countDistinctMultipleColumns)

setCountViaAnalytics

protected void setCountViaAnalytics(boolean countViaAnalytics)

setWrapSelectParameters

protected void setWrapSelectParameters(boolean b)

setArraysSupported

protected void setArraysSupported(boolean b)

setListMaxSize

protected void setListMaxSize(int i)

setSupportsUnquotedReservedWordsAsIdentifier

public void setSupportsUnquotedReservedWordsAsIdentifier(boolean b)