com.blazebit.persistence

Interface SelectBuilder<T,X extends SelectBuilder<T,X>>

Type Parameters:

T - The result type

X - The concrete builder type

All Known Subinterfaces:

BaseQueryBuilder<T,X>, CriteriaBuilder<T>, PaginatedCriteriaBuilder<T>, QueryBuilder<T,X>, SubqueryBuilder<T>

public interface SelectBuilder<T,X extends SelectBuilder<T,X>>

An interface for builders that support selecting. This is related to the fact, that a query builder supports select clauses.

Since:

1.0

Author:

Christian Beikov

Method Summary

Modifier and Type	Method and Description
SelectBuilder<T,?>	select(String expression) Adds a select clause with the given expression to the query.
SelectBuilder<T,?>	select(String expression, String alias) Adds a select clause with the given expression and alias to the query.
CaseWhenStarterBuilder<? extends SelectBuilder<T,?>>	selectCase() Like selectCase(java.lang.String) but without an alias.
CaseWhenStarterBuilder<? extends SelectBuilder<T,?>>	selectCase(String alias) Starts a CaseWhenBuilder with the given alias as select alias.
SimpleCaseWhenStarterBuilder<? extends SelectBuilder<T,?>>	selectSimpleCase(String caseOperand) Like selectSimpleCase(java.lang.String, java.lang.String) but without an alias.
SimpleCaseWhenStarterBuilder<? extends SelectBuilder<T,?>>	selectSimpleCase(String caseOperand, String alias) Starts a SimpleCaseWhenBuilder with the given alias as select alias.
SubqueryInitiator<? extends SelectBuilder<T,?>>	selectSubquery() Like selectSubquery(java.lang.String) but without an alias.
SubqueryInitiator<? extends SelectBuilder<T,?>>	selectSubquery(String alias) Starts a SubqueryInitiator for the select item with the given alias.
SubqueryInitiator<? extends SelectBuilder<T,?>>	selectSubquery(String subqueryAlias, String expression) Like selectSubquery(java.lang.String,java.lang.String,java.lang.String) but without a select alias.
SubqueryInitiator<? extends SelectBuilder<T,?>>	selectSubquery(String subqueryAlias, String expression, String selectAlias) Starts a SubqueryInitiator for a new select item with the given select alias.

Method Detail

selectCase

CaseWhenStarterBuilder<? extends SelectBuilder<T,?>> selectCase()

Like selectCase(java.lang.String) but without an alias.

Returns:

The case when builder

selectCase

CaseWhenStarterBuilder<? extends SelectBuilder<T,?>> selectCase(String alias)

Starts a CaseWhenBuilder with the given alias as select alias.

Parameters:

alias - The select alias for the case when expression

Returns:

The case when builder

selectSimpleCase

SimpleCaseWhenStarterBuilder<? extends SelectBuilder<T,?>> selectSimpleCase(String caseOperand)

Like selectSimpleCase(java.lang.String, java.lang.String) but without an alias.

Parameters:

caseOperand - The case operand

Returns:

The simple case when builder

selectSimpleCase

SimpleCaseWhenStarterBuilder<? extends SelectBuilder<T,?>> selectSimpleCase(String caseOperand,
                                                                            String alias)

Starts a SimpleCaseWhenBuilder with the given alias as select alias. The expression is the case operand which will be compared to the when expressions defined in the subsequent SimpleCaseWhenBuilder.

Parameters:

caseOperand - The case operand

alias - The select alias for the simple case when expression

Returns:

The simple case when builder

selectSubquery

SubqueryInitiator<? extends SelectBuilder<T,?>> selectSubquery()

Like selectSubquery(java.lang.String) but without an alias.

Returns:

The subquery initiator for building a subquery

selectSubquery

SubqueryInitiator<? extends SelectBuilder<T,?>> selectSubquery(String alias)

Starts a SubqueryInitiator for the select item with the given alias. When the builder finishes, the select item is added to the parent container represented by the type X.

Parameters:

alias - The select alias for the subquery

Returns:

The subquery initiator for building a subquery

selectSubquery

SubqueryInitiator<? extends SelectBuilder<T,?>> selectSubquery(String subqueryAlias,
                                                               String expression,
                                                               String selectAlias)

Starts a SubqueryInitiator for a new select item with the given select alias.

All occurrences of subqueryAlias in expression will be replaced by the subquery. When the builder finishes, the select item is added to the parent container represented by the type X.

Parameters:

subqueryAlias - The alias for the subquery which will be replaced by the actual subquery

expression - The expression which will be added as select item. This expression contains the subqueryAlias to define the insertion points for the subquery.

selectAlias - The select alias for the expression

Returns:

The subquery initiator for building a subquery

selectSubquery

SubqueryInitiator<? extends SelectBuilder<T,?>> selectSubquery(String subqueryAlias,
                                                               String expression)

Like selectSubquery(java.lang.String,java.lang.String,java.lang.String) but without a select alias.

Parameters:

subqueryAlias - The alias for the subquery which will be replaced by the actual subquery

expression - The expression which will be added as select item

Returns:

The subquery initiator for building a subquery

select

SelectBuilder<T,?> select(String expression)

Adds a select clause with the given expression to the query.

Parameters:

expression - The expression for the select clause

Returns:

The query builder for chaining calls

select

SelectBuilder<T,?> select(String expression,
                          String alias)

Adds a select clause with the given expression and alias to the query.

Parameters:

expression - The expression for the select clause

alias - The alias for the expression

Returns:

The query builder for chaining calls