com.mysema.query.sql

Class SQLTemplates

java.lang.Object

com.mysema.query.types.Templates

com.mysema.query.sql.SQLTemplates

Direct Known Subclasses:

CUBRIDTemplates, DerbyTemplates, H2Templates, HSQLDBTemplates, MySQLTemplates, OracleTemplates, PostgresTemplates, SQLiteTemplates, SQLServerTemplates

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 Operator<java.lang.Object>	CAST
static SQLTemplates	DEFAULT
static Operator<java.lang.Long>	DENSERANK
static Operator<java.lang.Object>	FIRSTVALUE
static Operator<java.lang.Object>	LAG
static Operator<java.lang.Object>	LASTVALUE
static Operator<java.lang.Object>	LEAD
static Operator<java.lang.Object>	NEXTVAL
static Operator<java.lang.Long>	RANK
static Operator<java.lang.Long>	ROWNUMBER
static Operator<java.lang.Object>	UNION
static Operator<java.lang.Object>	UNION_ALL

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	SQLTemplates(java.lang.String quoteStr, char escape, boolean useQuotes)

Method Summary

Methods

Modifier and Type	Method and Description
protected void	addClass2TypeMappings(java.lang.String type, java.lang.Class<?>... classes)
java.lang.String	getAsc()
java.lang.String	getAutoIncrement()
java.lang.String	getColumnAlias()
java.lang.String	getCount()
java.lang.String	getCountStar()
java.lang.String	getCreateIndex()
java.lang.String	getCreateTable()
java.lang.String	getCreateUniqueIndex()
java.lang.String	getDeleteFrom()
java.lang.String	getDesc()
java.lang.String	getDistinctCountEnd()
java.lang.String	getDistinctCountStart()
java.lang.String	getDummyTable()
java.lang.String	getForShare()
java.lang.String	getForUpdate()
java.lang.String	getFrom()
java.lang.String	getFullJoin()
java.lang.String	getGroupBy()
java.lang.String	getHaving()
java.lang.String	getInnerJoin()
java.lang.String	getInsertInto()
java.lang.String	getJoin()
java.lang.String	getJoinSymbol(JoinType joinType)
java.lang.String	getKey()
java.lang.String	getLeftJoin()
java.lang.String	getLimitTemplate()
java.lang.String	getMergeInto()
java.lang.String	getNotNull()
java.lang.String	getNoWait()
java.lang.String	getNullsFirst()
java.lang.String	getNullsLast()
java.lang.String	getOffsetTemplate()
java.lang.String	getOn()
java.lang.String	getOrderBy()
java.lang.String	getRightJoin()
java.lang.String	getSelect()
java.lang.String	getSelectDistinct()
java.lang.String	getSet()
java.lang.String	getTableAlias()
java.lang.String	getTypeForCast(java.lang.Class<?> cl)
java.lang.String	getTypeForClass(java.lang.Class<?> cl)
java.lang.String	getUpdate()
java.lang.String	getValues()
java.lang.String	getWhere()
java.lang.String	getWith()
boolean	isBatchCountViaGetUpdateCount()
boolean	isBigDecimalSupported()
boolean	isFunctionJoinsWrapped()
boolean	isNativeMerge()
boolean	isParameterMetadataAvailable()
boolean	isPrintSchema()
boolean	isSupportsAlias()
boolean	isUnionsWrapped()
boolean	isUseQuotes()
protected void	newLineToSingleSpace()
java.lang.String	quoteIdentifier(java.lang.String identifier)
protected boolean	requiresQuotes(java.lang.String identifier)
void	serialize(QueryMetadata metadata, boolean forCountRow, SQLSerializer context)
protected void	serializeModifiers(QueryMetadata metadata, SQLSerializer context)
protected void	setAsc(java.lang.String asc)
protected void	setAutoIncrement(java.lang.String autoIncrement)
protected void	setBatchCountViaGetUpdateCount(boolean batchCountViaGetUpdateCount)
protected void	setBigDecimalSupported(boolean bigDecimalSupported)
protected void	setColumnAlias(java.lang.String columnAlias)
protected void	setCount(java.lang.String count)
protected void	setCountStar(java.lang.String countStar)
protected void	setCreateIndex(java.lang.String createIndex)
protected void	setCreateTable(java.lang.String createTable)
protected void	setCreateUniqueIndex(java.lang.String createUniqueIndex)
protected void	setDeleteFrom(java.lang.String deleteFrom)
protected void	setDesc(java.lang.String desc)
protected void	setDistinctCountEnd(java.lang.String distinctCountEnd)
protected void	setDistinctCountStart(java.lang.String distinctCountStart)
protected void	setDummyTable(java.lang.String dummyTable)
protected void	setForShare(java.lang.String forShare)
protected void	setForUpdate(java.lang.String forUpdate)
protected void	setFrom(java.lang.String from)
protected void	setFullJoin(java.lang.String fullJoin)
protected void	setFunctionJoinsWrapped(boolean functionJoinsWrapped)
protected void	setGroupBy(java.lang.String groupBy)
protected void	setHaving(java.lang.String having)
protected void	setInnerJoin(java.lang.String innerJoin)
protected void	setInsertInto(java.lang.String insertInto)
protected void	setJoin(java.lang.String join)
protected void	setKey(java.lang.String key)
protected void	setLeftJoin(java.lang.String leftJoin)
protected void	setMergeInto(java.lang.String mergeInto)
protected void	setNativeMerge(boolean nativeMerge)
protected void	setNotNull(java.lang.String notNull)
protected void	setNoWait(java.lang.String noWait)
protected void	setNullsFirst(java.lang.String nullsFirst)
protected void	setNullsLast(java.lang.String nullsLast)
protected void	setOffsetTemplate(java.lang.String offsetTemplate)
protected void	setOn(java.lang.String on)
protected void	setOrderBy(java.lang.String orderBy)
protected void	setParameterMetadataAvailable(boolean parameterMetadataAvailable)
protected void	setPrintSchema(boolean printSchema)
protected void	setRightJoin(java.lang.String rightJoin)
protected void	setSelect(java.lang.String select)
protected void	setSelectDistinct(java.lang.String selectDistinct)
protected void	setSet(java.lang.String set)
protected void	setTableAlias(java.lang.String tableAlias)
protected void	setUnionsWrapped(boolean unionsWrapped)
protected void	setUpdate(java.lang.String update)
protected void	setValues(java.lang.String values)
protected void	setWhere(java.lang.String where)
protected void	setWith(java.lang.String with)

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

add, add, getEscapeChar, getPrecedence, getTemplate

Methods inherited from class java.lang.Object

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

Field Detail

CAST

public static final Operator<java.lang.Object> CAST

UNION

public static final Operator<java.lang.Object> UNION

UNION_ALL

public static final Operator<java.lang.Object> UNION_ALL

NEXTVAL

public static final Operator<java.lang.Object> NEXTVAL

ROWNUMBER

public static final Operator<java.lang.Long> ROWNUMBER

RANK

public static final Operator<java.lang.Long> RANK

DENSERANK

public static final Operator<java.lang.Long> DENSERANK

FIRSTVALUE

public static final Operator<java.lang.Object> FIRSTVALUE

LASTVALUE

public static final Operator<java.lang.Object> LASTVALUE

LEAD

public static final Operator<java.lang.Object> LEAD

LAG

public static final Operator<java.lang.Object> LAG

DEFAULT

public static final SQLTemplates DEFAULT

Constructor Detail

SQLTemplates

protected SQLTemplates(java.lang.String quoteStr,
            char escape,
            boolean useQuotes)

Method Detail

addClass2TypeMappings

protected void addClass2TypeMappings(java.lang.String type,
                         java.lang.Class<?>... classes)

getAsc

public final java.lang.String getAsc()

getAutoIncrement

public final java.lang.String getAutoIncrement()

getColumnAlias

public final java.lang.String getColumnAlias()

getCount

public final java.lang.String getCount()

getCountStar

public final java.lang.String getCountStar()

getDeleteFrom

public final java.lang.String getDeleteFrom()

getDesc

public final java.lang.String getDesc()

getDistinctCountEnd

public final java.lang.String getDistinctCountEnd()

getDistinctCountStart

public final java.lang.String getDistinctCountStart()

getDummyTable

public final java.lang.String getDummyTable()

getFrom

public final java.lang.String getFrom()

getFullJoin

public final java.lang.String getFullJoin()

getGroupBy

public final java.lang.String getGroupBy()

getHaving

public final java.lang.String getHaving()

getInnerJoin

public final java.lang.String getInnerJoin()

getInsertInto

public final java.lang.String getInsertInto()

getJoin

public final java.lang.String getJoin()

getJoinSymbol

public final java.lang.String getJoinSymbol(JoinType joinType)

getKey

public final java.lang.String getKey()

getLeftJoin

public final java.lang.String getLeftJoin()

getRightJoin

public final java.lang.String getRightJoin()

getLimitTemplate

public final java.lang.String getLimitTemplate()

getMergeInto

public final java.lang.String getMergeInto()

getNotNull

public final java.lang.String getNotNull()

getOffsetTemplate

public final java.lang.String getOffsetTemplate()

getOn

public final java.lang.String getOn()

getOrderBy

public final java.lang.String getOrderBy()

getSelect

public final java.lang.String getSelect()

getSelectDistinct

public final java.lang.String getSelectDistinct()

getSet

public final java.lang.String getSet()

getTableAlias

public final java.lang.String getTableAlias()

getTypeForCast

public java.lang.String getTypeForCast(java.lang.Class<?> cl)

getTypeForClass

public java.lang.String getTypeForClass(java.lang.Class<?> cl)

getUpdate

public final java.lang.String getUpdate()

getValues

public final java.lang.String getValues()

getWhere

public final java.lang.String getWhere()

isNativeMerge

public final boolean isNativeMerge()

isSupportsAlias

public final boolean isSupportsAlias()

getCreateIndex

public final java.lang.String getCreateIndex()

getCreateUniqueIndex

public final java.lang.String getCreateUniqueIndex()

getCreateTable

public final java.lang.String getCreateTable()

isPrintSchema

public final boolean isPrintSchema()

getWith

public final java.lang.String getWith()

isParameterMetadataAvailable

public final boolean isParameterMetadataAvailable()

isBatchCountViaGetUpdateCount

public final boolean isBatchCountViaGetUpdateCount()

isBigDecimalSupported

public final boolean isBigDecimalSupported()

getForUpdate

public final java.lang.String getForUpdate()

getForShare

public final java.lang.String getForShare()

isUseQuotes

public final boolean isUseQuotes()

getNoWait

public final java.lang.String getNoWait()

isUnionsWrapped

public final boolean isUnionsWrapped()

isFunctionJoinsWrapped

public final boolean isFunctionJoinsWrapped()

getNullsFirst

public final java.lang.String getNullsFirst()

getNullsLast

public final java.lang.String getNullsLast()

newLineToSingleSpace

protected void newLineToSingleSpace()

quoteIdentifier

public final java.lang.String quoteIdentifier(java.lang.String identifier)

requiresQuotes

protected boolean requiresQuotes(java.lang.String identifier)

serialize

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

serializeModifiers

protected void serializeModifiers(QueryMetadata metadata,
                      SQLSerializer context)

setAsc

protected void setAsc(java.lang.String asc)

setAutoIncrement

protected void setAutoIncrement(java.lang.String autoIncrement)

setColumnAlias

protected void setColumnAlias(java.lang.String columnAlias)

setCount

protected void setCount(java.lang.String count)

setCountStar

protected void setCountStar(java.lang.String countStar)

setDeleteFrom

protected void setDeleteFrom(java.lang.String deleteFrom)

setDesc

protected void setDesc(java.lang.String desc)

setDistinctCountEnd

protected void setDistinctCountEnd(java.lang.String distinctCountEnd)

setDistinctCountStart

protected void setDistinctCountStart(java.lang.String distinctCountStart)

setDummyTable

protected void setDummyTable(java.lang.String dummyTable)

setFrom

protected void setFrom(java.lang.String from)

setFullJoin

protected void setFullJoin(java.lang.String fullJoin)

setGroupBy

protected void setGroupBy(java.lang.String groupBy)

setHaving

protected void setHaving(java.lang.String having)

setInnerJoin

protected void setInnerJoin(java.lang.String innerJoin)

setInsertInto

protected void setInsertInto(java.lang.String insertInto)

setJoin

protected void setJoin(java.lang.String join)

setKey

protected void setKey(java.lang.String key)

setLeftJoin

protected void setLeftJoin(java.lang.String leftJoin)

setRightJoin

protected void setRightJoin(java.lang.String rightJoin)

setMergeInto

protected void setMergeInto(java.lang.String mergeInto)

setNativeMerge

protected void setNativeMerge(boolean nativeMerge)

setNotNull

protected void setNotNull(java.lang.String notNull)

setOffsetTemplate

protected void setOffsetTemplate(java.lang.String offsetTemplate)

setOn

protected void setOn(java.lang.String on)

setOrderBy

protected void setOrderBy(java.lang.String orderBy)

setSelect

protected void setSelect(java.lang.String select)

setSelectDistinct

protected void setSelectDistinct(java.lang.String selectDistinct)

setSet

protected void setSet(java.lang.String set)

setTableAlias

protected void setTableAlias(java.lang.String tableAlias)

setUpdate

protected void setUpdate(java.lang.String update)

setValues

protected void setValues(java.lang.String values)

setWhere

protected void setWhere(java.lang.String where)

setWith

protected void setWith(java.lang.String with)

setCreateIndex

protected void setCreateIndex(java.lang.String createIndex)

setCreateUniqueIndex

protected void setCreateUniqueIndex(java.lang.String createUniqueIndex)

setCreateTable

protected void setCreateTable(java.lang.String createTable)

setPrintSchema

protected void setPrintSchema(boolean printSchema)

setParameterMetadataAvailable

protected void setParameterMetadataAvailable(boolean parameterMetadataAvailable)

setBatchCountViaGetUpdateCount

protected void setBatchCountViaGetUpdateCount(boolean batchCountViaGetUpdateCount)

setBigDecimalSupported

protected void setBigDecimalSupported(boolean bigDecimalSupported)

setForUpdate

protected void setForUpdate(java.lang.String forUpdate)

setForShare

protected void setForShare(java.lang.String forShare)

setNoWait

protected void setNoWait(java.lang.String noWait)

setUnionsWrapped

protected void setUnionsWrapped(boolean unionsWrapped)

setFunctionJoinsWrapped

protected void setFunctionJoinsWrapped(boolean functionJoinsWrapped)

setNullsFirst

protected void setNullsFirst(java.lang.String nullsFirst)

setNullsLast

protected void setNullsLast(java.lang.String nullsLast)