com.xdev.jadoth.sqlengine.internal

Class SqlFunctionCASE

java.lang.Object

com.xdev.jadoth.sqlengine.internal.QueryPart

com.xdev.jadoth.sqlengine.internal.SqlExpression

com.xdev.jadoth.sqlengine.internal.SqlFunctionCASE

All Implemented Interfaces:

Copyable, SelectItem, Serializable

public class SqlFunctionCASE
extends SqlExpression

The Class SqlFunctionCASE.

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected static String	_THEN_ The Constant _THEN_.
protected static String	ELSE_ The Constant ELSE_.
protected static String	WHEN_ The Constant WHEN_.

Fields inherited from class com.xdev.jadoth.sqlengine.internal.SqlExpression

expression

Fields inherited from class com.xdev.jadoth.sqlengine.internal.QueryPart

ASEXPRESSION, defaultClauseStringBuilderLength, defaultExpressionStringBuilderLength, defaultQueryStringBuilderLength, DELIMIT_ALIASES, DELIMIT_COLUMN_IDENTIFIERS, DELIMIT_TABLE_IDENTIFIERS, ESCAPE_DBL_QUOTES, ESCAPE_QUOTES, FLAGS_TAKEN, MINIINDENT, OMITALIAS, PACKED, QUALIFY_BY_TABLE, SINGLELINE, UNQUALIFIED

Constructor Summary

Constructors

Constructor and Description
SqlFunctionCASE() Instantiates a new sql function case.
SqlFunctionCASE(Object expression) Instantiates a new sql function case.

Method Summary

Modifier and Type	Method and Description
protected StringBuilder	assemble(DbmsDMLAssembler<?> dmlAssembler, StringBuilder sb, int indentLevel, int flags) Assemble.
SqlFunctionCASE	ELSE(Object elseExpression) ELSE.
SqlFunctionCASE	WHEN(Object whenExpression, Object thenExpression) WHEN.

Methods inherited from class com.xdev.jadoth.sqlengine.internal.SqlExpression

_ASC, _DESC, _NULLS_FIRST, _NULLS_LAST, AS, BETWEEN, c, CONCAT, CONTAINS, copy, copyAS, eq, getExpression, getExpressionObject, gt, gte, IN, IS_NOT_NULL, IS_NULL, LIKE, lt, lte, ne, NOT_BETWEEN, NOT_CONTAINS, NOT_IN, NOT_LIKE, o, toString

Methods inherited from class com.xdev.jadoth.sqlengine.internal.QueryPart

assembleAlias, assembleObject, assembleQuery, bitAsExpression, bitDelimitAliases, bitDelimitColumnIdentifiers, bitDelimitTableIdentifiers, bitEscapeDoubleQuotes, bitMiniIndent, bitOmitAlias, bitPacked, bitQualified, bitQualifyByTable, bitSingleLine, concat, concatSqlExpressions, EscapeQuotes, flagsToString, function, indent, isAsExpression, isDelimitAliases, isDelimitColumnIdentifiers, isDelimitTableIdentifiers, isEscapeDoubleQuotes, isEscapeQuotes, isMiniIndent, isOmitAlias, isPacked, isQualifyByTable, isSingleLine, isUnqualified, keyword, list, printFlags, setAsExpression, setDelimitAliases, setDelimitColumnIdentifiers, setDelimitTableIdentifiers, setEscapeDoubleQuotes, setEscapeQuotes, setMiniIndent, setPacked, setQualified, setQualifyByTable, setSingleLine, setUseAlias

Methods inherited from class java.lang.Object

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

Field Detail

WHEN_

protected static final String WHEN_

The Constant WHEN_.

See Also:

Constant Field Values

_THEN_

protected static final String _THEN_

The Constant _THEN_.

See Also:

Constant Field Values

ELSE_

protected static final String ELSE_

The Constant ELSE_.

See Also:

Constant Field Values

Constructor Detail

SqlFunctionCASE

public SqlFunctionCASE()

Instantiates a new sql function case.

SqlFunctionCASE

public SqlFunctionCASE(Object expression)

Instantiates a new sql function case.

Parameters:

expression - the expression

Method Detail

WHEN

public SqlFunctionCASE WHEN(Object whenExpression,
                            Object thenExpression)

WHEN.

Parameters:

whenExpression - the when expression

thenExpression - the then expression

Returns:

the sql function case

ELSE

public SqlFunctionCASE ELSE(Object elseExpression)

ELSE.

Parameters:

elseExpression - the else expression

Returns:

the sql function case

assemble

protected StringBuilder assemble(DbmsDMLAssembler<?> dmlAssembler,
                                 StringBuilder sb,
                                 int indentLevel,
                                 int flags)

Description copied from class: QueryPart

Assemble.

Overrides:

assemble in class SqlExpression

Parameters:

dmlAssembler -

sb -

indentLevel -

flags -

Returns:

See Also:

SqlExpression.assemble(com.xdev.jadoth.sqlengine.dbms.DbmsDMLAssembler, java.lang.StringBuilder, int, int)