Query1<A> extension

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

on

• Query<(Expr<A>)>

Properties

first → QuerySingle<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Limit Query to the first row using LIMIT clause.

no setter

Methods

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

Available on Query<(Expr<A>)>, provided by the Query1 extension

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

except(Query<(Expr<A>)> other) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Combine this Query with other using EXCEPT set operator.

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

Available on Query<(Expr<A>)>, provided by the Query1 extension

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

fetch() → Future<List<A>>

Available on Query<(Expr<A>)>, provided by the Query1 extension

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

groupBy<T extends Record>(T groupBuilder(Expr<A> a)) → Group<T, (Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Create projection for GROUP BY clause.

intersect(Query<(Expr<A>)> other) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Combine this Query with other using INTERSECT set operator.

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

Available on Query<(Expr<A>)>, provided by the Query1 extension

Join this Query with another Query using INNER JOIN clause.

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

Available on Query<(Expr<A>)>, provided by the Query1 extension

Join this Query with another Query using LEFT JOIN clause.

limit(int limit) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Limit Query using LIMIT clause.

offset(int offset) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Offset Query using OFFSET clause.

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

Available on Query<(Expr<A>)>, provided by the Query1 extension

Order Query using ORDER BY clause.

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

Available on Query<(Expr<A>)>, provided by the Query1 extension

Join this Query with another Query using RIGHT JOIN clause.

select<T extends Record>(T projectionBuilder(Expr<A> a)) → Query<T>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Create a projection of this Query using SELECT clause.

stream() → Stream<A>

Available on Query<(Expr<A>)>, provided by the Query1 extension

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

union(Query<(Expr<A>)> other) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Combine this Query with other using UNION set operator.

unionAll(Query<(Expr<A>)> other) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Combine this Query with other using UNION ALL set operator.

where(Expr<bool> conditionBuilder(Expr<A> a)) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Filter Query using WHERE clause.

Operators

operator &(Query<(Expr<A>)> other) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Combine this Query with other using INTERSECT set operator.

operator +(Query<(Expr<A>)> other) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Combine this Query with other using UNION ALL set operator.

operator -(Query<(Expr<A>)> other) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Combine this Query with other using UNION set operator.

operator |(Query<(Expr<A>)> other) → Query<(Expr<A>)>

Available on Query<(Expr<A>)>, provided by the Query1 extension

Combine this Query with other using EXCEPT set operator.