T
- The builder type that is returned on terminal operationspublic interface BinaryPredicateBuilder<T>
Modifier and Type | Method and Description |
---|---|
RestrictionBuilder<CaseWhenThenBuilder<CaseWhenBuilder<T>>> |
caseWhen(String expression)
Starts a
RestrictionBuilder to create a when expression with a single predicate
in which expression will be on the left hand side of the predicate. |
CaseWhenAndThenBuilder<CaseWhenBuilder<T>> |
caseWhenAnd()
Starts a
CaseWhenAndThenBuilder for building a when expression
with conjunctively connected predicates. |
SubqueryInitiator<CaseWhenThenBuilder<CaseWhenBuilder<T>>> |
caseWhenExists()
Starts a
SubqueryInitiator to create a when expression with a single exists predicate. |
SubqueryInitiator<CaseWhenThenBuilder<CaseWhenBuilder<T>>> |
caseWhenNotExists()
Starts a
SubqueryInitiator to create a when expression with a single negated exists predicate. |
CaseWhenOrThenBuilder<CaseWhenBuilder<T>> |
caseWhenOr()
Starts a
CaseWhenOrThenBuilder for building a when expression
with disjunctively connected predicates. |
SubqueryInitiator<RestrictionBuilder<CaseWhenThenBuilder<CaseWhenBuilder<T>>>> |
caseWhenSubquery()
Starts a
SubqueryInitiator to create a when expression with a single predicate
in which the left hand side will be a subquery. |
SubqueryInitiator<RestrictionBuilder<CaseWhenThenBuilder<CaseWhenBuilder<T>>>> |
caseWhenSubquery(String subqueryAlias,
String expression)
Starts a
SubqueryInitiator to create a when expression with a single predicate
in which the left hand side will be a subquery. |
T |
expression(String expression)
Uses the given expression as right hand side for the binary predicate.
|
SimpleCaseWhenBuilder<T> |
simpleCase(String caseOperand)
Starts a
SimpleCaseWhenBuilder for building a simple case when expression. |
T |
value(Object value)
Uses the given value as right hand side for the binary predicate.
|
T value(Object value)
T
.value
- The value to use for the right hand side of the binary predicateT expression(String expression)
T
.expression
- The expression to use for the right hand side of the binary predicateRestrictionBuilder<CaseWhenThenBuilder<CaseWhenBuilder<T>>> caseWhen(String expression)
RestrictionBuilder
to create a when expression with a single predicate
in which expression
will be on the left hand side of the predicate.expression
- The left hand side expression for a when predicateMore details about this method
SubqueryInitiator<RestrictionBuilder<CaseWhenThenBuilder<CaseWhenBuilder<T>>>> caseWhenSubquery()
SubqueryInitiator
to create a when expression with a single predicate
in which the left hand side will be a subquery.
When the subquery builder and the restriction builder for the right hand side are finished, the when predicate in conjunction with its then expression are added to the case when builder.
More details about this method
SubqueryInitiator<RestrictionBuilder<CaseWhenThenBuilder<CaseWhenBuilder<T>>>> caseWhenSubquery(String subqueryAlias, String expression)
SubqueryInitiator
to create a when expression with a single predicate
in which the left hand side will be a subquery.
When the subquery builder and the restriction builder for the right hand side are finished, the when predicate in conjunction with its then expression are added to the case when builder.
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
SubqueryInitiator<CaseWhenThenBuilder<CaseWhenBuilder<T>>> caseWhenExists()
SubqueryInitiator
to create a when expression with a single exists predicate.
When the builder finishes, the when predicate in conjunction with its then expression are added to the case when builder.
More details about this method
SubqueryInitiator<CaseWhenThenBuilder<CaseWhenBuilder<T>>> caseWhenNotExists()
SubqueryInitiator
to create a when expression with a single negated exists predicate.
When the builder finishes, the when predicate in conjunction with its then expression are added to the case when builder.
More details about this method
CaseWhenAndThenBuilder<CaseWhenBuilder<T>> caseWhenAnd()
CaseWhenAndThenBuilder
for building a when expression
with conjunctively connected predicates.
When the builder finishes, the when predicate in conjunction with its then expression are added to the case when builder.
More details about this method
CaseWhenOrThenBuilder<CaseWhenBuilder<T>> caseWhenOr()
CaseWhenOrThenBuilder
for building a when expression
with disjunctively connected predicates.
When the builder finishes, the when predicate in conjunction with its then expression are added to the case when builder.
More details about this method
SimpleCaseWhenBuilder<T> simpleCase(String caseOperand)
SimpleCaseWhenBuilder
for building a simple case when expression.
When the builder finishes, the when predicate in conjunction with its then expression are added to the case when builder.
caseOperand
- The case operandMore details about this method
Copyright © 2015 Blazebit. All Rights Reserved.