Package | Description |
---|---|
org.apache.empire.db |
This package contains the core Empire-DB implementation classes.
|
org.apache.empire.db.expr.column |
This package contains SQL-generator classes for column expressions.
|
Modifier and Type | Method and Description |
---|---|
DBCaseExpr |
DBDatabase.caseMap(DBColumnExpr column,
Map<? extends Object,? extends Object> valueMap,
Object elseValue)
Creates a SQL case expression
in the form "case [Expr] when [mapKey] then [mapValue] else [elseValue] end"
|
DBCaseExpr |
DBDatabase.caseMap(DBColumnExpr column,
Object cmpValue,
Object trueValue,
Object falseValue)
Creates a SQL case expression
in the form "case [Expr] when [compareValue] then [trueValue] else [elseValue] end"
|
DBCaseExpr |
DBDatabase.caseMap(DBColumnExpr column,
Options options,
Object elseValue)
Creates a SQL case expression
in the form "case [Expr] when [optionValue] then [optionText] else [elseValue] end"
|
DBCaseExpr |
DBDatabase.caseWhen(DBCompareExpr condition,
Object trueValue,
Object falseValue)
Creates a SQL case expression
in the form "case when [condition] then [trueValue] else [falseValue] end"
This is a helper function to simplify client usage
|
DBCaseExpr |
DBDatabase.caseWhen(Map<DBCompareExpr,? extends Object> whenMap,
Object elseValue)
Creates a SQL case expression
in the form "case when [mapKey] then [mapValue] else [elseValue] end"
|
DBCaseExpr |
DBDatabase.caseWhenNull(DBColumnExpr column,
Object trueValue,
Object falseValue)
Creates a SQL case expression that check whether a column or column expression is null
"case when [condition] is null then [trueValue] else [falseValue] end"
This is a helper function to simplify client usage
|
DBCaseExpr |
DBColumnExpr.when(DBCompareExpr compExpr,
Object otherwise)
Creates and returns a sql-expression for the SQL case-phrase.
|
Modifier and Type | Class and Description |
---|---|
class |
DBCaseMapExpr
This class is used to create a SQL CASE constraint in the form of
case {expr} when {value1} then {result1}
when {value2} then {result2}
...
|
class |
DBCaseWhenExpr
This class is used to create a SQL CASE constraint in the form of
case when {cond1} then {result1}
when {cond2} then {result2}
...
|
Copyright © 2008–2023 Apache Software Foundation. All rights reserved.