A
- the generic typepublic class StandardDMLAssembler<A extends DbmsAdaptor<A>> extends DbmsAdaptor.Member.Implementation<A> implements DbmsDMLAssembler<A>
DbmsAdaptor.Member.Implementation<A extends DbmsAdaptor<A>>
Modifier and Type | Field and Description |
---|---|
protected static String |
__
The Constant __.
|
protected static String |
_FROM_
The Constant _FROM_.
|
protected static String |
_INTO_
The Constant _INTO_.
|
protected static String |
_ROW
The Constant _ROW.
|
protected static String |
_ROW_ONLY
The Constant _ROW_ONLY.
|
protected static String |
_ROWS
The Constant _ROWS.
|
protected static String |
_ROWS_ONLY
The Constant _ROWS_ONLY.
|
protected static String |
_star
The Constant _star.
|
protected static String |
FETCH_FIRST_
The Constant FETCH_FIRST_.
|
protected static String |
OFFSET_
The Constant OFFSET_.
|
Constructor and Description |
---|
StandardDMLAssembler(A dbmsAdaptor)
Instantiates a new standard dml assembler.
|
Modifier and Type | Method and Description |
---|---|
protected StringBuilder |
assembleAppendSelect(SELECT appendSelect,
StringBuilder sb,
int indentLevel,
int flags,
String clauseSeperator,
String newLine,
String appendKeyword)
Assemble append select.
|
protected StringBuilder |
assembleAppendSELECTs(SELECT query,
StringBuilder sb,
int indentLevel,
int flags,
String clauseSeperator,
String newLine)
Assemble append selec ts.
|
protected StringBuilder |
assembleAssignmentColumnsClause(TableQuery parentQuery,
AssignmentColumnsClause columns,
StringBuilder sb,
int indentLevel,
int flags)
Assemble assignment columns clause.
|
protected StringBuilder |
assembleAssignmentValuesClause(TableQuery parentQuery,
AssignmentValuesClause values,
StringBuilder sb,
int indentLevel,
int flags)
Assemble assignment values clause.
|
StringBuilder |
assembleColumn(SqlColumn column,
StringBuilder sb,
int indentLevel,
int flags) |
StringBuilder |
assembleColumnQualifier(SqlColumn column,
StringBuilder sb,
int flags) |
protected StringBuilder |
assembleCommentLines(Query query,
StringBuilder sb,
int indentLevel,
boolean singleLine)
Assemble comment lines.
|
StringBuilder |
assembleDateTimeExpression(SqlTimestamp dateTimeExpression,
StringBuilder sb) |
protected StringBuilder |
assembleDELETE(DELETE query,
StringBuilder sb,
int flags,
String clauseSeperator,
String newLine,
int indentLevel)
Assemble delete.
|
StringBuilder |
assembleDelimitedIdentifier(String identifier,
StringBuilder sb,
int flags) |
StringBuilder |
assembleDoubleQuotedExpression(DoubleQuotedExpression expression,
StringBuilder sb,
int indentLevel,
int flags)
Assemble double quoted expression.
|
void |
assembleExpression(SqlExpression expression,
StringBuilder sb,
int indentLevel,
int flags)
Assemble expression.
|
protected StringBuilder |
assembleFROM(TableQuery parentQuery,
FROM from,
StringBuilder sb,
int indentLevel,
int flags)
Assemble from.
|
protected StringBuilder |
assembleGROUPBY(TableQuery parentQuery,
GROUP_BY groupBy,
StringBuilder sb,
int indentLevel,
int flags)
Assemble groupby.
|
protected StringBuilder |
assembleHAVING(TableQuery parentQuery,
HAVING having,
StringBuilder sb,
int indentLevel,
int flags)
Assemble having.
|
protected StringBuilder |
assembleINSERT(INSERT query,
StringBuilder sb,
int flags,
String clauseSeperator,
String newLine,
int indentLevel)
Assemble insert.
|
protected StringBuilder |
assembleJOIN(TableQuery parentQuery,
JoinClause join,
StringBuilder sb,
int indentLevel,
int flags) |
StringBuilder |
assembleObject(Object object,
StringBuilder sb,
int indentLevel,
int flags) |
protected StringBuilder |
assembleORDERBY(TableQuery parentQuery,
ORDER_BY orderby,
StringBuilder sb,
int indentLevel,
int flags)
Assemble orderby.
|
protected StringBuilder |
assembleParenthesizedListClauseBody(SqlClause<?> sqlClause,
StringBuilder sb,
int indentLevel,
int flags)
Assemble parenthesized list clause body.
|
void |
assembleQuery(Query query,
StringBuilder sb,
int indentLevel,
int flags)
Assemble query.
|
protected StringBuilder |
assembleQueryComment(Query query,
StringBuilder sb,
int indentLevel,
boolean singleLine)
Assemble query comment.
|
protected StringBuilder |
assembleQueryName(Query query,
StringBuilder sb,
int indentLevel,
boolean singleLine)
Assemble query name.
|
protected StringBuilder |
assembleQuerySubclassContext(Query query,
StringBuilder sb,
int indentLevel,
int flags,
String clauseSeperator,
String newLine)
Assemble query subclass context.
|
StringBuilder |
assembleQuotedExpression(QuotedExpression expression,
StringBuilder sb,
int indentLevel,
int flags)
Assemble quoted expression.
|
protected StringBuilder |
assembleSELECT(SELECT query,
StringBuilder sb,
int indentLevel,
int flags,
String clauseSeperator,
String newLine)
Assemble select.
|
protected StringBuilder |
assembleSelectDISTINCT(SELECT query,
StringBuilder sb,
int indentLevel,
int flags)
Assemble select distinct.
|
void |
assembleSelectItem(SelectItem selectItem,
StringBuilder sb,
int indentLevel,
int flags)
Assemble select item.
|
protected StringBuilder |
assembleSelectItems(SELECT query,
StringBuilder sb,
int flags,
int indentLevel,
String newLine)
Assemble select items.
|
protected StringBuilder |
assembleSelectRowLimit(SELECT query,
StringBuilder sb,
int flags,
String clauseSeperator,
String newLine,
int indentLevel)
Assemble select row limit.
|
protected StringBuilder |
assembleSelectSqlClauses(SELECT query,
StringBuilder sb,
int indentLevel,
int flags,
String clauseSeperator,
String newLine)
Assemble select sql clauses.
|
protected StringBuilder |
assembleSET(TableQuery parentQuery,
SET set,
StringBuilder sb,
int indentLevel,
int flags)
Assemble set.
|
StringBuilder |
assembleSqlClause(SqlClause<?> sqlClause,
StringBuilder sb,
int indentLevel,
int flags)
Assemble sql clause.
|
protected StringBuilder |
assembleSqlClauseBody(SqlClause<?> sqlClause,
StringBuilder sb,
int indentLevel,
int flags)
Assemble sql clause body.
|
protected StringBuilder |
assembleSqlClauseHead(SqlClause<?> sqlClause,
StringBuilder sb,
int indentLevel,
int flags)
Assemble sql clause head.
|
StringBuilder |
assembleStringValue(String s,
StringBuilder sb,
int indentLevel,
int flags) |
StringBuilder |
assembleTableExpression(TableExpression tableExpression,
StringBuilder sb,
int indentLevel,
int flags) |
StringBuilder |
assembleTableIdentifier(SqlTableIdentity table,
StringBuilder sb,
int indentLevel,
int flags) |
protected StringBuilder |
assembleUPDATE(UPDATE query,
StringBuilder sb,
int indentLevel,
int flags,
String clauseSeperator,
String newLine)
Assemble update.
|
protected StringBuilder |
assembleWHERE(TableQuery parentQuery,
WHERE where,
StringBuilder sb,
int indentLevel,
int flags)
Assemble where.
|
DateFormat |
getDateFormatDATE() |
DateFormat |
getDateFormatTIME() |
DateFormat |
getDateFormatTIMESTAMP() |
static StandardDMLAssembler<StandardDbmsAdaptor> |
getSingletonStandardDMLAssembler()
Gets the singleton standard dml assembler.
|
getDbmsAdaptor, setDbmsAdaptor
protected static final String __
protected static final String _star
protected static final String OFFSET_
protected static final String FETCH_FIRST_
protected static final String _ROW
protected static final String _ROWS
protected static final String _ROW_ONLY
protected static final String _ROWS_ONLY
protected static final String _FROM_
protected static final String _INTO_
public StandardDMLAssembler(A dbmsAdaptor)
dbmsAdaptor
- the dbms adaptorpublic static StandardDMLAssembler<StandardDbmsAdaptor> getSingletonStandardDMLAssembler()
public void assembleQuery(Query query, StringBuilder sb, int indentLevel, int flags)
DbmsDMLAssembler
assembleQuery
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
query
- sb
- indentLevel
- flags
- DbmsDMLAssembler.assembleQuery(Query, java.lang.StringBuilder, int, int)
protected StringBuilder assembleQueryName(Query query, StringBuilder sb, int indentLevel, boolean singleLine)
query
- the querysb
- the sbindentLevel
- the indent levelsingleLine
- the single lineprotected StringBuilder assembleQueryComment(Query query, StringBuilder sb, int indentLevel, boolean singleLine)
query
- the querysb
- the sbindentLevel
- the indent levelsingleLine
- the single lineprotected StringBuilder assembleCommentLines(Query query, StringBuilder sb, int indentLevel, boolean singleLine)
query
- the querysb
- the sbindentLevel
- the indent levelsingleLine
- the single lineprotected StringBuilder assembleQuerySubclassContext(Query query, StringBuilder sb, int indentLevel, int flags, String clauseSeperator, String newLine)
query
- the querysb
- the sbindentLevel
- the indent levelflags
- the flagsclauseSeperator
- the clause seperatornewLine
- the new lineprotected StringBuilder assembleSelectDISTINCT(SELECT query, StringBuilder sb, int indentLevel, int flags)
query
- the querysb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleSelectItems(SELECT query, StringBuilder sb, int flags, int indentLevel, String newLine)
query
- the querysb
- the sbflags
- the flagsindentLevel
- the indent levelnewLine
- the new linepublic void assembleSelectItem(SelectItem selectItem, StringBuilder sb, int indentLevel, int flags)
DbmsDMLAssembler
assembleSelectItem
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
selectItem
- sb
- indentLevel
- flags
- DbmsDMLAssembler.assembleSelectItem(com.xdev.jadoth.sqlengine.internal.interfaces.SelectItem, java.lang.StringBuilder, int, int)
public void assembleExpression(SqlExpression expression, StringBuilder sb, int indentLevel, int flags)
DbmsDMLAssembler
assembleExpression
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
expression
- sb
- indentLevel
- flags
- DbmsDMLAssembler.assembleExpression(com.xdev.jadoth.sqlengine.internal.SqlExpression, java.lang.StringBuilder, int, int)
protected StringBuilder assembleSqlClauseHead(SqlClause<?> sqlClause, StringBuilder sb, int indentLevel, int flags)
sqlClause
- the sql clausesb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleSqlClauseBody(SqlClause<?> sqlClause, StringBuilder sb, int indentLevel, int flags)
sqlClause
- the sql clausesb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleParenthesizedListClauseBody(SqlClause<?> sqlClause, StringBuilder sb, int indentLevel, int flags)
sqlClause
- the sql clausesb
- the sbindentLevel
- the indent levelflags
- the flagspublic StringBuilder assembleSqlClause(SqlClause<?> sqlClause, StringBuilder sb, int indentLevel, int flags)
assembleSqlClause
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
parentQuery
- the parent querysqlClause
- the sql clausesb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleFROM(TableQuery parentQuery, FROM from, StringBuilder sb, int indentLevel, int flags)
parentQuery
- the parent queryfrom
- the fromsb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleJOIN(TableQuery parentQuery, JoinClause join, StringBuilder sb, int indentLevel, int flags)
protected StringBuilder assembleWHERE(TableQuery parentQuery, WHERE where, StringBuilder sb, int indentLevel, int flags)
parentQuery
- the parent querywhere
- the wheresb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleGROUPBY(TableQuery parentQuery, GROUP_BY groupBy, StringBuilder sb, int indentLevel, int flags)
parentQuery
- the parent querygroupBy
- the group bysb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleHAVING(TableQuery parentQuery, HAVING having, StringBuilder sb, int indentLevel, int flags)
parentQuery
- the parent queryhaving
- the havingsb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleORDERBY(TableQuery parentQuery, ORDER_BY orderby, StringBuilder sb, int indentLevel, int flags)
parentQuery
- the parent queryorderby
- the orderbysb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleSelectRowLimit(SELECT query, StringBuilder sb, int flags, String clauseSeperator, String newLine, int indentLevel)
query
- the querysb
- the sbflags
- the flagsclauseSeperator
- the clause seperatornewLine
- the new lineindentLevel
- the indent levelprotected StringBuilder assembleSET(TableQuery parentQuery, SET set, StringBuilder sb, int indentLevel, int flags)
parentQuery
- the parent queryset
- the setsb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleAssignmentColumnsClause(TableQuery parentQuery, AssignmentColumnsClause columns, StringBuilder sb, int indentLevel, int flags)
parentQuery
- the parent querycolumns
- the columnssb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleAssignmentValuesClause(TableQuery parentQuery, AssignmentValuesClause values, StringBuilder sb, int indentLevel, int flags)
parentQuery
- the parent queryvalues
- the valuessb
- the sbindentLevel
- the indent levelflags
- the flagsprotected StringBuilder assembleSELECT(SELECT query, StringBuilder sb, int indentLevel, int flags, String clauseSeperator, String newLine)
query
- the querysb
- the sbindentLevel
- the indent levelflags
- the flagsclauseSeperator
- the clause seperatornewLine
- the new lineprotected StringBuilder assembleAppendSELECTs(SELECT query, StringBuilder sb, int indentLevel, int flags, String clauseSeperator, String newLine)
query
- the querysb
- the sbindentLevel
- the indent levelflags
- the flagsclauseSeperator
- the clause seperatornewLine
- the new lineprotected StringBuilder assembleAppendSelect(SELECT appendSelect, StringBuilder sb, int indentLevel, int flags, String clauseSeperator, String newLine, String appendKeyword)
appendSelect
- the append selectsb
- the sbindentLevel
- the indent levelflags
- the flagsclauseSeperator
- the clause seperatornewLine
- the new lineappendKeyword
- the append keywordpublic StringBuilder assembleObject(Object object, StringBuilder sb, int indentLevel, int flags)
assembleObject
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
protected StringBuilder assembleSelectSqlClauses(SELECT query, StringBuilder sb, int indentLevel, int flags, String clauseSeperator, String newLine)
query
- the querysb
- the sbindentLevel
- the indent levelflags
- the flagsclauseSeperator
- the clause seperatornewLine
- the new lineprotected StringBuilder assembleINSERT(INSERT query, StringBuilder sb, int flags, String clauseSeperator, String newLine, int indentLevel)
query
- the querysb
- the sbflags
- the flagsclauseSeperator
- the clause seperatornewLine
- the new lineindentLevel
- the indent levelprotected StringBuilder assembleUPDATE(UPDATE query, StringBuilder sb, int indentLevel, int flags, String clauseSeperator, String newLine)
query
- the querysb
- the sbindentLevel
- the indent levelflags
- the flagsclauseSeperator
- the clause seperatornewLine
- the new lineprotected StringBuilder assembleDELETE(DELETE query, StringBuilder sb, int flags, String clauseSeperator, String newLine, int indentLevel)
query
- the querysb
- the sbflags
- the flagsclauseSeperator
- the clause seperatornewLine
- the new lineindentLevel
- the indent levelpublic StringBuilder assembleDoubleQuotedExpression(DoubleQuotedExpression expression, StringBuilder sb, int indentLevel, int flags)
assembleDoubleQuotedExpression
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
expression
- the expressionsb
- the sbindentLevel
- the indent levelflags
- the flagsDbmsDMLAssembler.assembleDoubleQuotedExpression(com.xdev.jadoth.sqlengine.internal.DoubleQuotedExpression, java.lang.StringBuilder, int, int)
public StringBuilder assembleQuotedExpression(QuotedExpression expression, StringBuilder sb, int indentLevel, int flags)
assembleQuotedExpression
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
expression
- the expressionsb
- the sbindentLevel
- the indent levelflags
- the flagsDbmsDMLAssembler.assembleQuotedExpression(com.xdev.jadoth.sqlengine.internal.QuotedExpression, java.lang.StringBuilder, int, int)
public DateFormat getDateFormatDATE()
getDateFormatDATE
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
public DateFormat getDateFormatTIME()
getDateFormatTIME
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
public DateFormat getDateFormatTIMESTAMP()
getDateFormatTIMESTAMP
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
public StringBuilder assembleDateTimeExpression(SqlTimestamp dateTimeExpression, StringBuilder sb)
assembleDateTimeExpression
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
public StringBuilder assembleColumnQualifier(SqlColumn column, StringBuilder sb, int flags)
assembleColumnQualifier
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
column
- sb
- flags
- DbmsDMLAssembler.assembleColumnQualifier(com.xdev.jadoth.sqlengine.internal.SqlColumn, java.lang.StringBuilder, int)
public StringBuilder assembleColumn(SqlColumn column, StringBuilder sb, int indentLevel, int flags)
assembleColumn
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
column
- sb
- flags
- com.xdev.jadoth.sqlengine.dbms.DbmsDMLAssembler#assembleColumn(com.xdev.jadoth.sqlengine.internal.SqlColumn, java.lang.StringBuilder, int)
public StringBuilder assembleDelimitedIdentifier(String identifier, StringBuilder sb, int flags)
assembleDelimitedIdentifier
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
identifier
- sb
- flags
- DbmsDMLAssembler.assembleDelimitedIdentifier(java.lang.String, java.lang.StringBuilder, int)
public StringBuilder assembleStringValue(String s, StringBuilder sb, int indentLevel, int flags)
assembleStringValue
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
object
- sb
- indentLevel
- flags
- DbmsDMLAssembler.assembleObject(java.lang.Object, java.lang.StringBuilder, int, int)
public StringBuilder assembleTableExpression(TableExpression tableExpression, StringBuilder sb, int indentLevel, int flags)
assembleTableExpression
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
tableExpression
- sb
- indentLevel
- flags
- DbmsDMLAssembler.assembleTableExpression(com.xdev.jadoth.sqlengine.internal.interfaces.TableExpression, java.lang.StringBuilder, int, int)
public StringBuilder assembleTableIdentifier(SqlTableIdentity table, StringBuilder sb, int indentLevel, int flags)
assembleTableIdentifier
in interface DbmsDMLAssembler<A extends DbmsAdaptor<A>>
table
- sb
- indentLevel
- flags
- DbmsDMLAssembler.assembleTableIdentifier(com.xdev.jadoth.sqlengine.internal.tables.SqlTableIdentity, java.lang.StringBuilder, int, int)
Copyright © 2003–2022 XDEV Software. All rights reserved.