OrderedQuery3<A, B, C> extension

Extension methods for a query returning zero or more rows with 3 expressions.

on

• OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>

Properties

first → QuerySingle<(Expr<A>, Expr<B>, Expr<C>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Limit Query to the first row using LIMIT clause.

no setter

Methods

fetch() → Future<List<(A, B, C)>>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

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

limit(int limit) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Limit OrderedQuery using LIMIT clause.

offset(int offset) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Offset OrderedQuery using OFFSET clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Order OrderedQuery using ORDER BY clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c)) → ProjectedOrderedQuery<T>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Create a projection of this OrderedQuery using SELECT clause.

stream() → Stream<(A, B, C)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

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

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b, Expr<C> c)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>)>, provided by the OrderedQuery3 extension

Filter OrderedQuery using WHERE clause.