Query4<A, B, C, D> extension

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

on

• Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Properties

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

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Limit Query to the first row using LIMIT clause.

no setter

Methods

count() → QuerySingle<(Expr<int>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Count number of rows in this Query using COUNT(*) aggregate function.

except(Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)> other) → Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Combine this Query with other using EXCEPT set operator.

exists() → QuerySingle<(Expr<bool>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Check for existance of rows in this Query using EXISTS operator.

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

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

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

groupBy<T extends Record>(T groupBuilder(Expr<A> a, Expr<B> b, Expr<C> c, Expr<D> d)) → Group<T, (Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Create projection for GROUP BY clause.

intersect(Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)> other) → Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Combine this Query with other using INTERSECT set operator.

join<T extends Record>(Query<T> query) → InnerJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), T>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Join this Query with another Query using INNER JOIN clause.

leftJoin<T extends Record>(Query<T> query) → LeftJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), T>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Join this Query with another Query using LEFT JOIN clause.

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

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Limit Query using LIMIT clause.

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

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Offset Query using OFFSET clause.

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

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Order Query using ORDER BY clause.

rightJoin<T extends Record>(Query<T> query) → RightJoin<(Expr<A>, Expr<B>, Expr<C>, Expr<D>), T>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Join this Query with another Query using RIGHT JOIN clause.

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

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Create a projection of this Query using SELECT clause.

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

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

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

union(Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)> other) → Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Combine this Query with other using UNION set operator.

unionAll(Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)> other) → Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Combine this Query with other using UNION ALL set operator.

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

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Filter Query using WHERE clause.

Operators

operator &(Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)> other) → Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Combine this Query with other using INTERSECT set operator.

operator +(Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)> other) → Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Combine this Query with other using UNION ALL set operator.

operator -(Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)> other) → Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Combine this Query with other using UNION set operator.

operator |(Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)> other) → Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>

Available on Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the Query4 extension

Combine this Query with other using EXCEPT set operator.