public class Expressions extends Object
Modifier and Type | Method and Description |
---|---|
static ComboExpression |
add()
Convenience method for generating a ComboExpression for joining
expressions using '+'.
|
static ComboExpression |
add(Object... expressions)
Convenience method for generating a ComboExpression for joining
the given expressions using '+'.
|
static CaseStatement |
caseStmt()
Convenience method for generating a CASE statement.
|
static SimpleCaseStatement |
caseStmt(Object columnObj)
Convenience method for generating a simple CASE statement.
|
static ComboExpression |
concatenate()
Convenience method for generating a ComboExpression for joining
expressions using '||'.
|
static ComboExpression |
concatenate(Object... expressions)
Convenience method for generating a ComboExpression for joining
the given expressions using '||'.
|
static CommonTableExpression |
cte(String name)
Convenience method for generating a common table expression.
|
static CustomExpression |
customExpr(Object exprObj)
Convenience method for generating a custom expression.
|
static CustomSql |
customSql(Object obj)
Convenience method for generating literal sql (not truly an "expression",
but convenient nonetheless).
|
static ComboExpression |
divide()
Convenience method for generating a ComboExpression for joining
expressions using '/'.
|
static ComboExpression |
divide(Object... expressions)
Convenience method for generating a ComboExpression for joining
the given expressions using '/'.
|
static Expression |
emptyExpr()
an Expression object which will always return
true for
NestableClause.isEmpty() . |
static ExtractExpression |
extractDay(Object dateExpr)
Convenience method for generating an EXTRACT day expression.
|
static ExtractExpression |
extractHour(Object dateExpr)
Convenience method for generating an EXTRACT hour expression.
|
static ExtractExpression |
extractMinute(Object dateExpr)
Convenience method for generating an EXTRACT minute expression.
|
static ExtractExpression |
extractMonth(Object dateExpr)
Convenience method for generating an EXTRACT month expression.
|
static ExtractExpression |
extractSecond(Object dateExpr)
Convenience method for generating an EXTRACT second expression.
|
static ExtractExpression |
extractTimezoneHour(Object dateExpr)
Convenience method for generating an EXTRACT timezone hour expression.
|
static ExtractExpression |
extractTimezoneMinute(Object dateExpr)
Convenience method for generating an EXTRACT timezone minute expression.
|
static ExtractExpression |
extractYear(Object dateExpr)
Convenience method for generating an EXTRACT year expression.
|
static ComboExpression |
multiply()
Convenience method for generating a ComboExpression for joining
expressions using '*'.
|
static ComboExpression |
multiply(Object... expressions)
Convenience method for generating a ComboExpression for joining
the given expressions using '*'.
|
static NamedParamObject |
namedParam(String name)
Convenience method for generating a custom "named" parameter expression.
|
static NegateExpression |
negate(Object obj)
Convenience method for generating the negation of an expression.
|
static Subquery |
subquery(Object query)
Convenience method for generating a subquery expression.
|
static ComboExpression |
subtract()
Convenience method for generating a ComboExpression for joining
expressions using '-'.
|
static ComboExpression |
subtract(Object... expressions)
Convenience method for generating a ComboExpression for joining
the given expressions using '-'.
|
public static ComboExpression add()
public static ComboExpression add(Object... expressions)
Object
-> Expression
conversions handled by
Converter.CUSTOM_TO_EXPRESSION
.public static ComboExpression subtract()
public static ComboExpression subtract(Object... expressions)
Object
-> Expression
conversions handled by
Converter.CUSTOM_TO_EXPRESSION
.public static ComboExpression multiply()
public static ComboExpression multiply(Object... expressions)
Object
-> Expression
conversions handled by
Converter.CUSTOM_TO_EXPRESSION
.public static ComboExpression divide()
public static ComboExpression divide(Object... expressions)
Object
-> Expression
conversions handled by
Converter.CUSTOM_TO_EXPRESSION
.public static ComboExpression concatenate()
public static ComboExpression concatenate(Object... expressions)
Object
-> Expression
conversions handled by
Converter.CUSTOM_TO_EXPRESSION
.public static NegateExpression negate(Object obj)
Object
-> Expression
conversions handled by
Converter.toExpressionObject(Object)
.
public static ExtractExpression extractYear(Object dateExpr)
Object
-> Expression
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static ExtractExpression extractMonth(Object dateExpr)
Object
-> Expression
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static ExtractExpression extractDay(Object dateExpr)
Object
-> Expression
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static ExtractExpression extractHour(Object dateExpr)
Object
-> Expression
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static ExtractExpression extractMinute(Object dateExpr)
Object
-> Expression
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static ExtractExpression extractSecond(Object dateExpr)
Object
-> Expression
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static ExtractExpression extractTimezoneHour(Object dateExpr)
Object
-> Expression
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static ExtractExpression extractTimezoneMinute(Object dateExpr)
Object
-> Expression
conversions handled by
Converter.toColumnSqlObject(Object)
.
public static CaseStatement caseStmt()
public static SimpleCaseStatement caseStmt(Object columnObj)
public static Subquery subquery(Object query)
Object
-> SqlObject
conversions handled by
Converter.toCustomSqlObject(Object)
.
public static NamedParamObject namedParam(String name)
public static CommonTableExpression cte(String name)
public static CustomExpression customExpr(Object exprObj)
public static Expression emptyExpr()
true
for
NestableClause.isEmpty()
. useful for selectively including expression
blocksCopyright © 2006–2021 OpenHMS. All rights reserved.