OrderedQueryRange1<A> extension

Extension methods for a query returning zero or more rows with 1 expression.

on

Properties

first QuerySingle<(Expr<A>)>

Available on OrderedQueryRange<(Expr<A>)>, provided by the OrderedQueryRange1 extension

Limit Query to the first row using LIMIT clause.
no setter

Methods

fetch() Future<List<A>>

Available on OrderedQueryRange<(Expr<A>)>, provided by the OrderedQueryRange1 extension

Query the database for rows in this Query as a List.
limit(int limit) OrderedQueryRange<(Expr<A>)>

Available on OrderedQueryRange<(Expr<A>)>, provided by the OrderedQueryRange1 extension

Limit OrderedQueryRange using LIMIT clause.
offset(int offset) OrderedQueryRange<(Expr<A>)>

Available on OrderedQueryRange<(Expr<A>)>, provided by the OrderedQueryRange1 extension

Offset OrderedQueryRange using OFFSET clause.
orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a)) OrderedQuery<(Expr<A>)>

Available on OrderedQueryRange<(Expr<A>)>, provided by the OrderedQueryRange1 extension

Order OrderedQueryRange using ORDER BY clause.
select<T extends Record>(T projectionBuilder(Expr<A> a)) ProjectedOrderedQueryRange<T>

Available on OrderedQueryRange<(Expr<A>)>, provided by the OrderedQueryRange1 extension

Create a projection of this OrderedQueryRange using SELECT clause.
stream() Stream<A>

Available on OrderedQueryRange<(Expr<A>)>, provided by the OrderedQueryRange1 extension

Query the database for rows in this Query as a Stream.