Package com.onec.query

Class QueryBuilder<T>

java.lang.Object

com.onec.query.QueryBuilder<T>

public final class QueryBuilder<T>
extends Object

Fluent front-end that accumulates a QuerySpec and runs it through a QueryEngine. DSL helpers from Q produce un-rooted paths; this builder binds them to <T> as they are added, so callers never repeat the entity class.

 import static com.onec.query.Q.*;

 List<Row> rows = engine.from(SalesOrder.class)
     .select(col(SalesOrder::getNumber),
             ref(SalesOrder::getCustomer, Customer::getName))
     .where(eq(SalesOrder::getStatus, "APPROVED"))
     .orderBy(desc(SalesOrder::getDate))
     .fetch();
 

Method Summary

Modifier and Type	Method	Description
List<Row>	fetch()
<D> List<D>	fetchInto(Class<D> dtoType)
QueryBuilder<T>	groupBy(Path... paths)
QueryBuilder<T>	limit(int limit)
QueryBuilder<T>	offset(int offset)
QueryBuilder<T>	orderBy(Order... orders)
QueryBuilder<T>	select(Select... items)
QuerySpec	toSpec()	The declarative spec this builder has assembled — usable without executing.
QueryBuilder<T>	totalsBy(Path... paths)
QueryBuilder<T>	where(Predicate... predicates)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

select

public QueryBuilder<T> select(Select... items)

where

public QueryBuilder<T> where(Predicate... predicates)

groupBy

public QueryBuilder<T> groupBy(Path... paths)

orderBy

public QueryBuilder<T> orderBy(Order... orders)

totalsBy

public QueryBuilder<T> totalsBy(Path... paths)

limit

public QueryBuilder<T> limit(int limit)

offset

public QueryBuilder<T> offset(int offset)

toSpec

public QuerySpec toSpec()

The declarative spec this builder has assembled — usable without executing.

fetch

public List<Row> fetch()

fetchInto

public <D> List<D> fetchInto(Class<D> dtoType)