SqlExpression (XDEV Application Framework 6.0.0 API)

java.lang.Object
- com.xdev.jadoth.sqlengine.internal.QueryPart
- - com.xdev.jadoth.sqlengine.internal.SqlExpression

All Implemented Interfaces:

Copyable, SelectItem, Serializable

Direct Known Subclasses:

AliasedExpression, DISTINCT, DoubleQuotedExpression, QuotedExpression, SqlBoolean, SqlConcatenation, SqlFunction, SqlFunctionCASE, SqlIdentifier, SqlOperation, SqlTimestamp
```
public class SqlExpression
extends QueryPart
implements SelectItem
```
The Class SqlExpression.

Author:

Thomas Muenz

See Also:

Serialized Form

Field Summary

Fields
Modifier and Type Field and Description

protected Object expression
The 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

Fields
Modifier and Type	Field and Description
`protected Object`	`expression` The expression.

Constructor Summary

Constructors
Modifier Constructor and Description

SqlExpression(Object expression)
Instantiates a new sql expression.

protected SqlExpression(SqlExpression copySource)

Constructors
Modifier	Constructor and Description
	`SqlExpression(Object expression)` Instantiates a new sql expression.
`protected`	`SqlExpression(SqlExpression copySource)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`SqlOrderItemNullSortable`	`_ASC()` _ asc.
`SqlOrderItemNullSortable`	`_DESC()` _ desc.
`SqlOrderItem`	`_NULLS_FIRST()` _ null s_ first.
`SqlOrderItem`	`_NULLS_LAST()` _ null s_ last.
`SqlExpression`	`AS(String alias)` AS.
`protected StringBuilder`	`assemble(DbmsDMLAssembler<?> dmlAssembler, StringBuilder sb, int indentLevel, int flags)` Assemble.
`SqlConditionBETWEEN`	`BETWEEN(Object lowerBoundExpression, Object upperBoundExpression)` BETWEEN.
`SqlComparison`	`c(String operator, Object value)` C.
`SqlxFunctionCONCAT`	`CONCAT(Object value)` CONCAT.
`SqlComparison`	`CONTAINS(Object value)` CONTAINS.
`SqlExpression`	`copy()`
`SqlExpression`	`copyAS(String alias)` Copy as.
`SqlComparison`	`eq(Object value)` Eq.
`String`	`getExpression()` Gets the expression.
`Object`	`getExpressionObject()` Gets the expression object.
`SqlComparison`	`gt(Object value)` Gt.
`SqlComparison`	`gte(Object value)` Gte.
`SqlComparison`	`IN(Object... list)` IN.
`SqlComparison`	`IS_NOT_NULL()` I s_ no t_ null.
`SqlComparison`	`IS_NULL()` I s_ null.
`SqlConditionLIKE`	`LIKE(Object value)` LIKE.
`SqlComparison`	`lt(Object value)` Lt.
`SqlComparison`	`lte(Object value)` Lte.
`SqlComparison`	`ne(Object value)` Ne.
`SqlConditionNOT`	`NOT_BETWEEN(Object lowerBoundExpression, Object upperBoundExpression)` NO t_ between.
`SqlComparison`	`NOT_CONTAINS(Object value)` NO t_ contains.
`SqlComparison`	`NOT_IN(Object... list)` NO t_ in.
`SqlConditionNOT`	`NOT_LIKE(Object value)` NO t_ like.
`SqlOperation`	`o(String operator, Object value)` O.
`String`	`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
  - expression
```
protected Object expression
```
    The expression.
- Constructor Detail
  - SqlExpression
```
public SqlExpression(Object expression)
```
    Instantiates a new sql expression.
    
    Parameters:
    
    expression - the expression
  - SqlExpression
```
protected SqlExpression(SqlExpression copySource)
```
- Method Detail
  - AS
```
public final SqlExpression AS(String alias)
```
    AS.
    
    Parameters:
    
    alias - the alias
    
    Returns:
    
    the sql expression
  - o
```
public final SqlOperation o(String operator,
                            Object value)
```
    O.
    
    Parameters:
    
    operator - the operator
    
    value - the value
    
    Returns:
    
    the sql operation
  - c
```
public final SqlComparison c(String operator,
                             Object value)
```
    C.
    
    Parameters:
    
    operator - the operator
    
    value - the value
    
    Returns:
    
    the sql comparison
  - eq
```
public final SqlComparison eq(Object value)
```
    Eq.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sql comparison
  - ne
```
public final SqlComparison ne(Object value)
```
    Ne.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sql comparison
  - gt
```
public final SqlComparison gt(Object value)
```
    Gt.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sql comparison
  - lt
```
public final SqlComparison lt(Object value)
```
    Lt.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sql comparison
  - gte
```
public final SqlComparison gte(Object value)
```
    Gte.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sql comparison
  - lte
```
public final SqlComparison lte(Object value)
```
    Lte.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sql comparison
  - IS_NULL
```
public final SqlComparison IS_NULL()
```
    I s_ null.
    
    Returns:
    
    the sql comparison
  - IS_NOT_NULL
```
public final SqlComparison IS_NOT_NULL()
```
    I s_ no t_ null.
    
    Returns:
    
    the sql comparison
  - IN
```
public final SqlComparison IN(Object... list)
```
    IN.
    
    Parameters:
    
    list - the list
    
    Returns:
    
    the sql comparison
  - NOT_IN
```
public final SqlComparison NOT_IN(Object... list)
```
    NO t_ in.
    
    Parameters:
    
    list - the list
    
    Returns:
    
    the sql comparison
  - LIKE
```
public final SqlConditionLIKE LIKE(Object value)
```
    LIKE.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sql condition like
  - NOT_LIKE
```
public final SqlConditionNOT NOT_LIKE(Object value)
```
    NO t_ like.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sql condition not
  - BETWEEN
```
public final SqlConditionBETWEEN BETWEEN(Object lowerBoundExpression,
                                         Object upperBoundExpression)
```
    BETWEEN.
    
    Parameters:
    
    lowerBoundExpression - the lower bound expression
    
    upperBoundExpression - the upper bound expression
    
    Returns:
    
    the sql condition between
  - NOT_BETWEEN
```
public final SqlConditionNOT NOT_BETWEEN(Object lowerBoundExpression,
                                         Object upperBoundExpression)
```
    NO t_ between.
    
    Parameters:
    
    lowerBoundExpression - the lower bound expression
    
    upperBoundExpression - the upper bound expression
    
    Returns:
    
    the sql condition not
  - CONCAT
```
public final SqlxFunctionCONCAT CONCAT(Object value)
```
    CONCAT.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sqlx function concat
  - CONTAINS
```
public final SqlComparison CONTAINS(Object value)
```
    CONTAINS.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sql comparison
  - NOT_CONTAINS
```
public final SqlComparison NOT_CONTAINS(Object value)
```
    NO t_ contains.
    
    Parameters:
    
    value - the value
    
    Returns:
    
    the sql comparison
  - _ASC
```
public final SqlOrderItemNullSortable _ASC()
```
    _ asc.
    
    Returns:
    
    the sql order item null sortable
  - _DESC
```
public final SqlOrderItemNullSortable _DESC()
```
    _ desc.
    
    Returns:
    
    the sql order item null sortable
  - _NULLS_FIRST
```
public final SqlOrderItem _NULLS_FIRST()
```
    _ null s_ first.
    
    Returns:
    
    the sql order item
  - _NULLS_LAST
```
public final SqlOrderItem _NULLS_LAST()
```
    _ null s_ last.
    
    Returns:
    
    the sql order item
  - getExpression
```
public String getExpression()
```
    Gets the expression.
    
    Returns:
    
    the expression
  - getExpressionObject
```
public Object getExpressionObject()
```
    Gets the expression object.
    
    Returns:
    
    the expression object
  - toString
```
public String toString()
```
    Overrides:
    
    toString in class Object
    
    Returns:
    
    See Also:
    
    Object.toString()
  - assemble
```
protected StringBuilder assemble(DbmsDMLAssembler<?> dmlAssembler,
                                 StringBuilder sb,
                                 int indentLevel,
                                 int flags)
```
    Description copied from class: QueryPart
    
    Assemble.
    
    Specified by:
    
    assemble in class QueryPart
    
    Parameters:
    
    dmlAssembler -
    
    sb -
    
    indentLevel -
    
    flags -
    
    Returns:
    
    See Also:
    
    QueryPart.assemble(com.xdev.jadoth.sqlengine.dbms.DbmsDMLAssembler, java.lang.StringBuilder, int, int)
  - copyAS
```
public final SqlExpression copyAS(String alias)
```
    Copy as.
    
    Parameters:
    
    alias - the alias
    
    Returns:
    
    the sql expression
  - copy
```
public SqlExpression copy()
```
    Specified by:
    
    copy in interface Copyable
    
    Returns:

Class SqlExpression

Field Summary

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

Constructor Summary

Method Summary

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

Methods inherited from class java.lang.Object

Field Detail

expression

Constructor Detail

SqlExpression

SqlExpression

Method Detail

AS

o

c

eq

ne

gt

lt

gte

lte

IS_NULL

IS_NOT_NULL

IN

NOT_IN

LIKE

NOT_LIKE

BETWEEN

NOT_BETWEEN

CONCAT

CONTAINS

NOT_CONTAINS

_ASC

_DESC

_NULLS_FIRST

_NULLS_LAST

getExpression

getExpressionObject

toString

assemble

copyAS

copy