T
- The builder type that is returned on terminal operationspublic interface CaseWhenAndBuilder<T>
Modifier and Type | Method | Description |
---|---|---|
RestrictionBuilder<CaseWhenAndBuilder<T>> |
and(String expression) |
Starts a
RestrictionBuilder for a case when predicate with the given expression as left hand expression. |
SubqueryInitiator<CaseWhenAndBuilder<T>> |
andExists() |
Starts an exists predicate for the when clause with a subquery on the right hand side.
|
SubqueryBuilder<CaseWhenAndBuilder<T>> |
andExists(FullQueryBuilder<?,?> criteriaBuilder) |
Starts an exists predicate for the when clause with a subquery on the right hand side based on the given criteria builder.
|
SubqueryInitiator<CaseWhenAndBuilder<T>> |
andNotExists() |
Starts an exists predicate for the when clause with a subquery on the right hand side.
|
SubqueryBuilder<CaseWhenAndBuilder<T>> |
andNotExists(FullQueryBuilder<?,?> criteriaBuilder) |
Starts an exists predicate for the when clause with a subquery on the right hand side based on the given criteria builder.
|
MultipleSubqueryInitiator<RestrictionBuilder<CaseWhenAndBuilder<T>>> |
andSubqueries(String expression) |
Starts a
MultipleSubqueryInitiator for the left hand side of a when predicate. |
SubqueryInitiator<RestrictionBuilder<CaseWhenAndBuilder<T>>> |
andSubquery() |
Starts a
SubqueryInitiator for the left hand side of a when predicate. |
SubqueryBuilder<RestrictionBuilder<CaseWhenAndBuilder<T>>> |
andSubquery(FullQueryBuilder<?,?> criteriaBuilder) |
Starts a
SubqueryBuilder based on the given criteria builder for the left hand side of a when predicate. |
SubqueryInitiator<RestrictionBuilder<CaseWhenAndBuilder<T>>> |
andSubquery(String subqueryAlias,
String expression) |
Starts a
SubqueryInitiator for the left hand side of a when predicate. |
SubqueryBuilder<RestrictionBuilder<CaseWhenAndBuilder<T>>> |
andSubquery(String subqueryAlias,
String expression,
FullQueryBuilder<?,?> criteriaBuilder) |
Starts a
SubqueryBuilder based on the given criteria builder for the left hand side of a when predicate. |
T |
endAnd() |
Finishes the AND predicate and adds it to the parent predicate container represented by the type
T . |
CaseWhenOrBuilder<CaseWhenAndBuilder<T>> |
or() |
Starts a case when or builder which connects it's predicates with the OR operator.
|
RestrictionBuilder<CaseWhenAndBuilder<T>> and(String expression)
RestrictionBuilder
for a case when predicate with the given expression as left hand expression.
When the builder finishes, the predicate is added this predicate container.expression
- The left hand expression for a case when predicateSubqueryInitiator<RestrictionBuilder<CaseWhenAndBuilder<T>>> andSubquery()
SubqueryInitiator
for the left hand side of a when predicate.
When the subquery builder and the restriction builder for the right hand side are finished,
the when predicate in conjunction with it's then expression are added to this predicate container as conjunct.SubqueryInitiator<RestrictionBuilder<CaseWhenAndBuilder<T>>> andSubquery(String subqueryAlias, String expression)
SubqueryInitiator
for the left hand side of a when predicate.
All occurrences of subqueryAlias
in expression
will be replaced by the subquery. When the subquery
builder and the restriction builder for the right hand side are finished, the when predicate in conjunction with it's then
expression are added to this predicate container as conjunct.
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate.
This expression contains the subqueryAlias
to define the insertion points for the subquery.More details about this method
MultipleSubqueryInitiator<RestrictionBuilder<CaseWhenAndBuilder<T>>> andSubqueries(String expression)
MultipleSubqueryInitiator
for the left hand side of a when predicate.
All occurrences of subsequently defined subqueryAlias
es in expression
will be replaced by the respective subquery.
When the builder finishes, the resulting expression is used for the left hand side of a when predicate.
expression
- The expression which will be used as left hand side of a when predicateSubqueryBuilder<RestrictionBuilder<CaseWhenAndBuilder<T>>> andSubquery(FullQueryBuilder<?,?> criteriaBuilder)
SubqueryBuilder
based on the given criteria builder for the left hand side of a when predicate.
When the subquery builder and the restriction builder for the right hand side are finished,
the when predicate in conjunction with it's then expression are added to this predicate container as conjunct.criteriaBuilder
- The criteria builder to base the subquery onSubqueryBuilder<RestrictionBuilder<CaseWhenAndBuilder<T>>> andSubquery(String subqueryAlias, String expression, FullQueryBuilder<?,?> criteriaBuilder)
SubqueryBuilder
based on the given criteria builder for the left hand side of a when predicate.
All occurrences of subqueryAlias
in expression
will be replaced by the subquery. When the subquery
builder and the restriction builder for the right hand side are finished, the when predicate in conjunction with it's then
expression are added to this predicate container as conjunct.
subqueryAlias
- The alias for the subquery which will be replaced by the actual subqueryexpression
- The expression which will be used as left hand side of a predicate.
This expression contains the subqueryAlias
to define the insertion points for the subquery.criteriaBuilder
- The criteria builder to base the subquery onMore details about this method
SubqueryInitiator<CaseWhenAndBuilder<T>> andExists()
SubqueryInitiator<CaseWhenAndBuilder<T>> andNotExists()
SubqueryBuilder<CaseWhenAndBuilder<T>> andExists(FullQueryBuilder<?,?> criteriaBuilder)
criteriaBuilder
- The criteria builder to base the subquery onSubqueryBuilder<CaseWhenAndBuilder<T>> andNotExists(FullQueryBuilder<?,?> criteriaBuilder)
criteriaBuilder
- The criteria builder to base the subquery onCaseWhenOrBuilder<CaseWhenAndBuilder<T>> or()
T endAnd()
T
.Copyright © 2014–2018 Blazebit. All rights reserved.