OrderedQuery7<A, B, C, D, E, F, G> extension

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

on

• OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Properties

first → QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Limit Query to the first row using LIMIT clause.

no setter

Methods

fetch() → Future<List<(A, B, C, D, E, F, G)>>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

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

limit(int limit) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Limit OrderedQuery using LIMIT clause.

offset(int offset) → OrderedQueryRange<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Offset OrderedQuery using OFFSET clause.

orderBy(List<(Expr<Comparable?>, Order)> builder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Order OrderedQuery using ORDER BY clause.

select<T extends Record>(T projectionBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → ProjectedOrderedQuery<T>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Create a projection of this OrderedQuery using SELECT clause.

stream() → Stream<(A, B, C, D, E, F, G)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 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, Expr<D> d, Expr<E> e, Expr<F> f, Expr<G> g)) → OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

Available on OrderedQuery<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>, provided by the OrderedQuery7 extension

Filter OrderedQuery using WHERE clause.