T
- The concrete builder typeBaseCriteriaBuilder<T,X>
, BaseCTECriteriaBuilder<X>
, BaseDeleteCriteriaBuilder<T,X>
, BaseInsertCriteriaBuilder<T,X>
, BaseModificationCriteriaBuilder<X>
, BaseQueryBuilder<T,X>
, BaseSubqueryBuilder<X>
, BaseUpdateCriteriaBuilder<T,X>
, CriteriaBuilder<T>
, DeleteCriteriaBuilder<T>
, FullQueryBuilder<T,X>
, FullSelectCTECriteriaBuilder<X>
, InsertCriteriaBuilder<T>
, LeafOngoingSetOperationCriteriaBuilder<X>
, LeafOngoingSetOperationCTECriteriaBuilder<X>
, LeafOngoingSetOperationSubqueryBuilder<X>
, ModificationCriteriaBuilder<X>
, OngoingSetOperationCriteriaBuilder<T,Y>
, OngoingSetOperationCTECriteriaBuilder<T,Y>
, OngoingSetOperationSubqueryBuilder<T,Y>
, PaginatedCriteriaBuilder<T>
, QueryBuilder<T,X>
, ReturningDeleteCriteriaBuilder<T,X>
, ReturningInsertCriteriaBuilder<T,X>
, ReturningModificationCriteriaBuilder<X,Y>
, ReturningUpdateCriteriaBuilder<T,X>
, SelectBaseCTECriteriaBuilder<X>
, SelectCTECriteriaBuilder<X>
, SelectRecursiveCTECriteriaBuilder<X>
, StartOngoingSetOperationCriteriaBuilder<X,Y>
, StartOngoingSetOperationCTECriteriaBuilder<X,Y>
, StartOngoingSetOperationSubqueryBuilder<X,Y>
, SubqueryBuilder<T>
, UpdateCriteriaBuilder<T>
, WhereAndBuilder<T>
, WhereBuilder<T>
, WhereOrBuilder<T>
public interface BaseWhereBuilder<T extends BaseWhereBuilder<T>>
Modifier and Type | Method | Description |
---|---|---|
RestrictionBuilder<T> |
where(String expression) |
Starts a
RestrictionBuilder for a where predicate with the given expression as left hand expression. |
CaseWhenStarterBuilder<RestrictionBuilder<T>> |
whereCase() |
Starts a
CaseWhenBuilder for a where predicate. |
SubqueryInitiator<T> |
whereExists() |
Starts an exists predicate for the where clause with a subquery on the right hand side.
|
SubqueryBuilder<T> |
whereExists(FullQueryBuilder<?,?> criteriaBuilder) |
Starts an exists predicate for the where clause with a subquery on the right hand side based on the given criteria builder.
|
T |
whereExpression(String expression) |
Adds the given expression as expression for the where clause.
|
MultipleSubqueryInitiator<T> |
whereExpressionSubqueries(String expression) |
Starts a
MultipleSubqueryInitiator for expression of the where clause. |
SubqueryInitiator<T> |
whereNotExists() |
Starts an not exists predicate for the where clause with a subquery on the right hand side.
|
SubqueryBuilder<T> |
whereNotExists(FullQueryBuilder<?,?> criteriaBuilder) |
Starts an exists predicate for the where clause with a subquery on the right hand side based on the given criteria builder.
|
SimpleCaseWhenStarterBuilder<RestrictionBuilder<T>> |
whereSimpleCase(String expression) |
Starts a
SimpleCaseWhenBuilder for a where predicate. |
MultipleSubqueryInitiator<RestrictionBuilder<T>> |
whereSubqueries(String expression) |
Starts a
MultipleSubqueryInitiator for the left hand side of a predicate. |
SubqueryInitiator<RestrictionBuilder<T>> |
whereSubquery() |
Starts a
SubqueryInitiator for the left hand side of a predicate. |
SubqueryBuilder<RestrictionBuilder<T>> |
whereSubquery(FullQueryBuilder<?,?> criteriaBuilder) |
Starts a
SubqueryBuilder based on the given criteria builder for the left hand side of a predicate. |
SubqueryInitiator<RestrictionBuilder<T>> |
whereSubquery(String subqueryAlias,
String expression) |
Starts a
SubqueryInitiator for the left hand side of a predicate. |
SubqueryBuilder<RestrictionBuilder<T>> |
whereSubquery(String subqueryAlias,
String expression,
FullQueryBuilder<?,?> criteriaBuilder) |
Starts a
SubqueryBuilder based on the given criteria builder for the left hand side of a predicate. |
SubqueryInitiator<RestrictionBuilder<T>> whereSubquery()
SubqueryInitiator
for the left hand side of a predicate.
When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the
parent predicate container represented by the type T
.SubqueryInitiator<RestrictionBuilder<T>> whereSubquery(String subqueryAlias, String expression)
SubqueryInitiator
for the left hand side of a 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 predicate is added to the parent predicate
container represented by the type T
.
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.MultipleSubqueryInitiator<RestrictionBuilder<T>> whereSubqueries(String expression)
MultipleSubqueryInitiator
for the left hand side of a 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 the predicate.
expression
- The expression which will be used as left hand side of a predicateSubqueryBuilder<RestrictionBuilder<T>> whereSubquery(FullQueryBuilder<?,?> criteriaBuilder)
SubqueryBuilder
based on the given criteria builder for the left hand side of a predicate.
When the subquery builder and the restriction builder for the right hand side are finished, the predicate is added to the
parent predicate container represented by the type T
.criteriaBuilder
- The criteria builder to base the subquery onSubqueryBuilder<RestrictionBuilder<T>> whereSubquery(String subqueryAlias, String expression, FullQueryBuilder<?,?> criteriaBuilder)
SubqueryBuilder
based on the given criteria builder for the left hand side of a 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 predicate is added to the
parent predicate container represented by the type T
.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 predicatecriteriaBuilder
- The criteria builder to base the subquery onT whereExpression(String expression)
expression
- The where expressionMultipleSubqueryInitiator<T> whereExpressionSubqueries(String expression)
MultipleSubqueryInitiator
for expression of the where clause.
All occurrences of subsequently defined subqueryAlias
es in expression
will be replaced by the respective subquery.
When the builder finishes, the resulting expression is added as expression to the parent predicate container represented by the type T
.
expression
- The where expressionRestrictionBuilder<T> where(String expression)
RestrictionBuilder
for a where predicate with the given expression as left hand expression.
When the builder finishes, the predicate is added to the parent predicate container represented by the type T
.expression
- The left hand expression for a where predicateCaseWhenStarterBuilder<RestrictionBuilder<T>> whereCase()
CaseWhenBuilder
for a where predicate.
When the CaseWhenBuilder
and the restriction builder for the right hand side are finished,
the predicate is added to the parent predicate container represented by the type T
.CaseWhenBuilder
SimpleCaseWhenStarterBuilder<RestrictionBuilder<T>> whereSimpleCase(String expression)
SimpleCaseWhenBuilder
for a where predicate.
When the CaseWhenBuilder
and the restriction builder for the right hand side are finished,
the predicate is added to the parent predicate container represented by the type T
.expression
- Case operand expressionCaseWhenBuilder
SubqueryInitiator<T> whereExists()
T
.SubqueryInitiator<T> whereNotExists()
T
.SubqueryBuilder<T> whereExists(FullQueryBuilder<?,?> criteriaBuilder)
T
.criteriaBuilder
- The criteria builder to base the subquery onSubqueryBuilder<T> whereNotExists(FullQueryBuilder<?,?> criteriaBuilder)
T
.criteriaBuilder
- The criteria builder to base the subquery onCopyright © 2014–2020 Blazebit. All rights reserved.