QuerySingle5<A, B, C, D, E> extension

Extensions for a query returning at-most one row with 5 expressions.

on

• QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Properties

asQuery → Query<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the QuerySingle5 extension

Get Query with the same rows as this QuerySingle.

no setter

Methods

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

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the QuerySingle5 extension

Query the database for the row matching this QuerySingle, if any.

fetchOrNulls() → Future<(A?, B?, C?, D?, E?)>

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the QuerySingle5 extension

Query the database for the row matching this QuerySingle, if any.

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

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the QuerySingle5 extension

Create a projection of this QuerySingle using SELECT clause.

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

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>)>, provided by the QuerySingle5 extension

Filter QuerySingle using WHERE clause.