Uses of Class
st.orm.template.QueryBuilder

Packages that use QueryBuilder

Package	Description
st.orm.repository	Java repository API.
st.orm.template	Java client API: templates, query builders and transactions.
st.orm.template.impl	Java client API implementation.

Uses of QueryBuilder in st.orm.repository

Methods in st.orm.repository that return QueryBuilder

Modifier and Type	Method	Description
QueryBuilder<E,?,ID>	EntityRepository.delete()	Creates a new query builder for delete entities of the type managed by this repository.
QueryBuilder<E,E,ID>	EntityRepository.select()	Creates a new query builder for selecting entities of the type managed by this repository.
<R> QueryBuilder<E,R,ID>	EntityRepository.select(Class<R> selectType)	Creates a new query builder for the specialized selectType.
<R> QueryBuilder<E,R,ID>	EntityRepository.select(Class<R> selectType, StringTemplatePREVIEW template)	Creates a new query builder for the specialized selectType and specialized template for the select clause.
QueryBuilder<P,P,ID>	ProjectionRepository.select()	Creates a new query builder for the projection type managed by this repository.
<R> QueryBuilder<P,R,ID>	ProjectionRepository.select(Class<R> selectType)	Creates a new query builder for the custom selectType.
<R> QueryBuilder<P,R,ID>	ProjectionRepository.select(Class<R> selectType, StringTemplatePREVIEW template)	Creates a new query builder for the custom selectType and custom template for the select clause.
QueryBuilder<E,Long,ID>	EntityRepository.selectCount()	Creates a new query builder for the entity type managed by this repository.
QueryBuilder<P,Long,ID>	ProjectionRepository.selectCount()	Creates a new query builder for the projection type managed by this repository.
QueryBuilder<E,Ref<E>,ID>	EntityRepository.selectRef()	Creates a new query builder for selecting refs to entities of the type managed by this repository.
<R extends Data> QueryBuilder<E,Ref<R>,ID>	EntityRepository.selectRef(Class<R> refType)	Creates a new query builder for selecting refs to entities of the type managed by this repository.
QueryBuilder<P,Ref<P>,ID>	ProjectionRepository.selectRef()	Creates a new query builder for selecting refs to projections of the type managed by this repository.
<R extends Data> QueryBuilder<P,Ref<R>,ID>	ProjectionRepository.selectRef(Class<R> refType)	Creates a new query builder for selecting refs to projections of the type managed by this repository.
QueryBuilder<E,?,ID>	EntityRepository.update()	Creates a new query builder for updating entities of the type managed by this repository.

Uses of QueryBuilder in st.orm.template

Methods in st.orm.template that return QueryBuilder

Modifier and Type	Method	Description
abstract QueryBuilder<Data,R,ID>	QueryBuilder.crossJoin(Class<? extends Data> relation)	Adds a cross join to the query.
abstract QueryBuilder<Data,R,ID>	QueryBuilder.crossJoin(StringTemplatePREVIEW template)	Adds a cross join to the query.
<T extends Data> QueryBuilder<T,?,?>	QueryTemplate.deleteFrom(Class<T> fromType)	Creates a query builder for the specified table to delete from.
abstract QueryBuilder<T,R,ID>	QueryBuilder.distinct()	Marks the current query as a distinct query.
abstract QueryBuilder<T,R,ID>	QueryBuilder.fetch(List<? extends Navigable<T,? extends Data>> paths)	Resolves the references at the specified paths as part of this query.
final QueryBuilder<T,R,ID>	QueryBuilder.fetch(Navigable<T,? extends Data> path, Navigable<T,? extends Data>... more)	Resolves the references at the specified paths as part of this query.
abstract QueryBuilder<T,R,ID>	QueryBuilder.forLock(StringTemplatePREVIEW template)	Locks the selected rows using a custom lock mode.
abstract QueryBuilder<T,R,ID>	QueryBuilder.forShare()	Locks the selected rows for reading.
abstract QueryBuilder<T,R,ID>	QueryBuilder.forUpdate()	Locks the selected rows for reading.
abstract QueryBuilder<T,R,ID>	QueryBuilder.groupBy(StringTemplatePREVIEW template)	Adds a GROUP BY clause to the query using a string template.
final QueryBuilder<T,R,ID>	QueryBuilder.groupBy(Navigable<? extends T,?> path, Navigable<? extends T,?>... more)	Adds a GROUP BY clause to the query for field at the specified path in the table graph.
abstract QueryBuilder<T,R,ID>	QueryBuilder.having(StringTemplatePREVIEW template)	Adds a HAVING clause to the query using the specified expression.
final <V> QueryBuilder<T,R,ID>	QueryBuilder.having(Navigable<? extends T,V> path, Operator operator, Navigable<?,V> other)	Adds a HAVING clause that compares the column at the specified path with the column at another path of the query.
final <V> QueryBuilder<T,R,ID>	QueryBuilder.having(Navigable<? extends T,V> path, Operator operator, V... o)	Adds a HAVING clause to the query using the specified expression.
abstract QueryBuilder<T,R,ID>	QueryBuilder.havingExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns at least one row.
abstract QueryBuilder<T,R,ID>	QueryBuilder.havingNotExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns no rows.
abstract QueryBuilder<T,R,ID>	QueryBuilder.hint(String hint)	Adds an optimizer hint to the statement this builder builds.
abstract QueryBuilder<T,R,ID>	QueryBuilder.limit(int limit)	Adds a LIMIT clause to the query.
abstract <X extends Data> QueryBuilder<X,R,ID>	QueryBuilder.narrow(Class<X> rootType)	Returns a query builder rooted at the specified type, narrowing a builder whose root was relaxed by a join.
abstract QueryBuilder<T,R,ID>	QueryBuilder.offset(int offset)	Adds an OFFSET clause to the query.
QueryBuilder<Data,R,ID>	JoinBuilder.on(StringTemplatePREVIEW template)	Specifies the join condition using a custom expression.
QueryBuilder<Data,R,ID>	TypedJoinBuilder.on(Class<? extends Data> relation)	Specifies the relation to join on.
QueryBuilder<Data,R,ID>	TypedJoinBuilder.on(Class<? extends Data> relation, Function<WhereBuilder<Data,R,ID>,PredicateBuilder<Data,?,?>> condition)	Specifies the relation to join on, with a condition the join adds to the foreign key it resolves.
QueryBuilder<Data,R,ID>	TypedJoinBuilder.on(Function<WhereBuilder<Data,R,ID>,PredicateBuilder<Data,?,?>> predicate)	Specifies the relation to join on as a predicate, which states it as a whole: the keys it equates and any condition on the joined rows.
abstract QueryBuilder<T,R,ID>	QueryBuilder.orderBy(StringTemplatePREVIEW template)	Adds an ORDER BY clause to the query using a string template.
final QueryBuilder<T,R,ID>	QueryBuilder.orderBy(Navigable<? extends T,?> path, Navigable<? extends T,?>... more)	Adds an ORDER BY clause to the query for the field at the specified path in the table graph.
final QueryBuilder<T,R,ID>	QueryBuilder.orderByDescending(StringTemplatePREVIEW template)	Adds an ORDER BY clause to the query using a string template.
final QueryBuilder<T,R,ID>	QueryBuilder.orderByDescending(Navigable<? extends T,?> path, Navigable<? extends T,?>... more)	Adds an ORDER BY clause to the query for the fields at the specified paths in the table graph.
abstract QueryBuilder<T,R,ID>	QueryBuilder.orderFirst(Function<WhereBuilder<T,R,ID>,PredicateBuilder<T,?,?>> predicate)	Adds an ORDER BY key that puts the rows matching the predicate before the rows that do not, keeping the order of the keys before it and leaving the order within each part to the keys after it.
default <T extends Data> QueryBuilder<T,T,?>	QueryTemplate.selectFrom(Class<T> fromType)	Creates a query builder for the specified table.
default <T extends Data, R> QueryBuilder<T,R,?>	QueryTemplate.selectFrom(Class<T> fromType, Class<R> selectType)	Creates a query builder for the specified table and select type.
<T extends Data, R> QueryBuilder<T,R,?>	QueryTemplate.selectFrom(Class<T> fromType, Class<R> selectType, StringTemplatePREVIEW template)	Creates a query builder for the specified table and select type using the given template.
abstract QueryBuilder<T,R,ID>	QueryBuilder.set(Metamodel<? extends T,?> field, StringTemplatePREVIEW template)	Sets a column of the rows an UPDATE query updates to the value the given SQL expression computes, such as an increment of the column itself.
abstract <V> QueryBuilder<T,R,ID>	QueryBuilder.set(Metamodel<? extends T,V> field, @Nullable V value)	Sets a column of the rows an UPDATE query updates to the given value.
abstract <V extends Data> QueryBuilder<T,R,ID>	QueryBuilder.set(Metamodel<? extends T,V> field, Ref<V> ref)	Sets a foreign key of the rows an UPDATE query updates to the record the given ref refers to.
final QueryBuilder<T,R,ID>	QueryBuilder.setNull(Metamodel<? extends T,?> field)	Sets the columns of a field of the rows an UPDATE query updates to NULL.
default <T extends Data> QueryBuilder<T,?,?>	SubqueryTemplate.subquery(Class<T> fromType)	Create a subquery for the given table.
default <T extends Data, R extends Data> QueryBuilder<T,?,?>	SubqueryTemplate.subquery(Class<T> fromType, Class<R> selectType)	Create a subquery for the given table and select type.
<T extends Data> QueryBuilder<T,?,?>	SubqueryTemplate.subquery(Class<T> fromType, StringTemplatePREVIEW template)	Create a subquery for the given table and select type using the given template.
abstract <X> QueryBuilder<T,R,X>	QueryBuilder.typedId(Class<X> pkType)	Returns a query builder whose primary key type is pkType, so the operations that take an id can be used.
abstract QueryBuilder<T,R,ID>	QueryBuilder.unsafe()	Returns a query builder that allows UPDATE and DELETE queries without a WHERE clause.
<T extends Data> QueryBuilder<T,?,?>	QueryTemplate.updateFrom(Class<T> fromType)	Creates a query builder for the specified table to update.
final QueryBuilder<T,R,ID>	QueryBuilder.where(ID id)	Adds a WHERE clause that matches the specified primary key of the table.
final QueryBuilder<T,R,ID>	QueryBuilder.where(Iterable<? extends T> it)	Adds a WHERE clause that matches the specified records.
final QueryBuilder<T,R,ID>	QueryBuilder.where(StringTemplatePREVIEW template)	Adds a WHERE clause to the query for the specified expression.
abstract QueryBuilder<T,R,ID>	QueryBuilder.where(Function<WhereBuilder<T,R,ID>,PredicateBuilder<T,?,?>> predicate)	Adds a WHERE clause to the query using a WhereBuilder.
final <V extends Data> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, Iterable<V> it)	Adds a WHERE clause that matches the specified records.
final <V> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, Operator operator, Iterable<? extends V> it)	Adds a WHERE clause that matches the specified objects at the specified path in the table graph.
final <V> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, Operator operator, Navigable<?,V> other)	Adds a WHERE clause that compares the column at the specified path with the column at another path of the query, such as a foreign key with a foreign key to the same table.
final <V> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, Operator operator, V... o)	Adds a WHERE clause that matches the specified objects at the specified path in the table graph.
final <V extends Data> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, Ref<V> ref)	Adds a WHERE clause that matches the specified ref.
final <V extends Data> QueryBuilder<T,R,ID>	QueryBuilder.where(Navigable<? extends T,V> path, V record)	Adds a WHERE clause that matches the specified record.
final QueryBuilder<T,R,ID>	QueryBuilder.where(Ref<T> ref)	Adds a WHERE clause that matches the specified primary key of the table, expressed by a ref.
final QueryBuilder<T,R,ID>	QueryBuilder.where(T record)	Adds a WHERE clause that matches the specified record.
final QueryBuilder<T,R,ID>	QueryBuilder.whereExists(QueryBuilder<?,?,?> subquery)	Adds a WHERE clause that keeps the rows for which the specified subquery returns at least one row.
final QueryBuilder<T,R,ID>	QueryBuilder.whereId(Iterable<? extends ID> it)	Adds a WHERE clause that matches the specified primary keys of the table.
final QueryBuilder<T,R,ID>	QueryBuilder.whereNotExists(QueryBuilder<?,?,?> subquery)	Adds a WHERE clause that keeps the rows for which the specified subquery returns no rows.
final QueryBuilder<T,R,ID>	QueryBuilder.whereRef(Iterable<? extends Ref<T>> it)	Adds a WHERE clause that matches the specified primary keys of the table, expressed by a ref.
final <V extends Data> QueryBuilder<T,R,ID>	QueryBuilder.whereRef(Navigable<? extends T,V> path, Iterable<? extends Ref<V>> it)	Adds a WHERE clause that matches the specified records.
abstract QueryBuilder<Data,R,ID>	QueryBuilder.widen()	Widens the query as a join does, without joining: from here on, every clause accepts paths from any entity in the query.

Methods in st.orm.template with parameters of type QueryBuilder

Modifier and Type	Method	Description
abstract PredicateBuilder<T,R,ID>	WhereBuilder.exists(QueryBuilder<?,?,?> subquery)	Adds an EXISTS condition to the WHERE clause using the specified subquery.
abstract QueryBuilder<T,R,ID>	QueryBuilder.havingExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns at least one row.
abstract QueryBuilder<T,R,ID>	QueryBuilder.havingNotExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns no rows.
abstract JoinBuilder<T,R,ID>	QueryBuilder.join(JoinType type, QueryBuilder<?,?,?> subquery, String alias)	Adds a join of the specified type to the query using a subquery.
abstract PredicateBuilder<T,R,ID>	WhereBuilder.notExists(QueryBuilder<?,?,?> subquery)	Adds an NOT EXISTS condition to the WHERE clause using the specified subquery.
static Element	Templates.subquery(QueryBuilder<?,?,?> builder, boolean correlate)	Creates a new subquery element using a query builder.
final QueryBuilder<T,R,ID>	QueryBuilder.whereExists(QueryBuilder<?,?,?> subquery)	Adds a WHERE clause that keeps the rows for which the specified subquery returns at least one row.
final QueryBuilder<T,R,ID>	QueryBuilder.whereNotExists(QueryBuilder<?,?,?> subquery)	Adds a WHERE clause that keeps the rows for which the specified subquery returns no rows.

Uses of QueryBuilder in st.orm.template.impl

Subclasses of QueryBuilder in st.orm.template.impl

Modifier and Type	Class	Description
final class	QueryBuilderImpl<T extends Data,R,ID>

Methods in st.orm.template.impl that return QueryBuilder

Modifier and Type	Method	Description
QueryBuilder<Data,R,ID>	QueryBuilderImpl.crossJoin(Class<? extends Data> relation)	Adds a cross join to the query.
QueryBuilder<Data,R,ID>	QueryBuilderImpl.crossJoin(StringTemplatePREVIEW template)	Adds a cross join to the query.
<T extends Data> QueryBuilder<T,?,?>	QueryTemplateImpl.deleteFrom(Class<T> fromType)
QueryBuilder<T,R,ID>	QueryBuilderImpl.distinct()	Marks the current query as a distinct query.
QueryBuilder<T,R,ID>	QueryBuilderImpl.fetch(List<? extends Navigable<T,? extends Data>> paths)	Resolves the references at the specified paths as part of this query.
QueryBuilder<T,R,ID>	QueryBuilderImpl.forLock(StringTemplatePREVIEW template)	Locks the selected rows using a custom lock mode.
QueryBuilder<T,R,ID>	QueryBuilderImpl.forShare()	Locks the selected rows for reading.
QueryBuilder<T,R,ID>	QueryBuilderImpl.forUpdate()	Locks the selected rows for reading.
QueryBuilder<T,R,ID>	QueryBuilderImpl.groupBy(StringTemplatePREVIEW template)	Adds a GROUP BY clause to the query using a string template.
QueryBuilder<T,R,ID>	QueryBuilderImpl.having(StringTemplatePREVIEW template)	Adds a HAVING clause to the query using the specified expression.
QueryBuilder<T,R,ID>	QueryBuilderImpl.havingExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns at least one row.
QueryBuilder<T,R,ID>	QueryBuilderImpl.havingNotExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns no rows.
QueryBuilder<T,R,ID>	QueryBuilderImpl.hint(String hint)	Adds an optimizer hint to the statement this builder builds.
QueryBuilder<T,R,ID>	QueryBuilderImpl.limit(int limit)	Adds a LIMIT clause to the query.
<X extends Data> QueryBuilder<X,R,ID>	QueryBuilderImpl.narrow(Class<X> rootType)	Returns a query builder rooted at the specified type.
QueryBuilder<T,R,ID>	QueryBuilderImpl.offset(int offset)	Adds an OFFSET clause to the query.
QueryBuilder<T,R,ID>	QueryBuilderImpl.orderBy(StringTemplatePREVIEW template)	Adds an ORDER BY clause to the query using a string template.
QueryBuilder<T,R,ID>	QueryBuilderImpl.orderFirst(Function<WhereBuilder<T,R,ID>,PredicateBuilder<T,?,?>> predicate)
<T extends Data, R> QueryBuilder<T,R,Object>	QueryTemplateImpl.selectFrom(Class<T> fromType, Class<R> selectType, StringTemplatePREVIEW template)
QueryBuilder<T,R,ID>	QueryBuilderImpl.set(Metamodel<? extends T,?> field, StringTemplatePREVIEW template)
<V> QueryBuilder<T,R,ID>	QueryBuilderImpl.set(Metamodel<? extends T,V> field, @Nullable V value)
<V extends Data> QueryBuilder<T,R,ID>	QueryBuilderImpl.set(Metamodel<? extends T,V> field, Ref<V> ref)
<T extends Data> QueryBuilder<T,?,?>	QueryTemplateImpl.subquery(Class<T> fromType)
<T extends Data, R extends Data> QueryBuilder<T,?,?>	QueryTemplateImpl.subquery(Class<T> fromType, Class<R> selectType)
<T extends Data> QueryBuilder<T,?,?>	QueryTemplateImpl.subquery(Class<T> fromType, StringTemplatePREVIEW template)
<X> QueryBuilder<T,R,X>	QueryBuilderImpl.typedId(Class<X> pkType)	Returns a typed query builder for the specified primary key type.
QueryBuilder<T,R,ID>	QueryBuilderImpl.unsafe()	Returns a query builder that allows UPDATE and DELETE queries without a WHERE clause.
<T extends Data> QueryBuilder<T,?,?>	QueryTemplateImpl.updateFrom(Class<T> fromType)
QueryBuilder<T,R,ID>	QueryBuilderImpl.where(Function<WhereBuilder<T,R,ID>,PredicateBuilder<T,?,?>> predicate)	Adds a WHERE clause to the query using a WhereBuilder.
QueryBuilder<Data,R,ID>	QueryBuilderImpl.widen()	Widens the query as a join does, without joining.

Methods in st.orm.template.impl with parameters of type QueryBuilder

Modifier and Type	Method	Description
QueryBuilder<T,R,ID>	QueryBuilderImpl.havingExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns at least one row.
QueryBuilder<T,R,ID>	QueryBuilderImpl.havingNotExists(QueryBuilder<?,?,?> subquery)	Adds a HAVING clause that keeps the groups for which the specified subquery returns no rows.
JoinBuilder<T,R,ID>	QueryBuilderImpl.join(JoinType type, QueryBuilder<?,?,?> subquery, String alias)	Adds a join of the specified type to the query using a subquery.