QuerySingle<T extends Record> class final Writing queries

A Query which can return at-most a single row.

A QuerySingle object may return zero or one row.

Available extensions

• QuerySingle1
• QuerySingle1AsExpr
• QuerySingle2
• QuerySingle3
• QuerySingle4
• QuerySingle5
• QuerySingle6
• QuerySingle7
• QuerySingle8

Properties

asExpr → Expr<T?>

Available on QuerySingle<(Expr<T>)>, provided by the QuerySingle1AsExpr extension

Use this QuerySingle as subquery expression.

no setter

asQuery → Query<(Expr<A>)>

Available on QuerySingle<(Expr<A>)>, provided by the QuerySingle1 extension

Get Query with the same rows as this QuerySingle.

no setter

asQuery → Query<(Expr<A>, Expr<B>)>

Available on QuerySingle<(Expr<A>, Expr<B>)>, provided by the QuerySingle2 extension

Get Query with the same rows as this QuerySingle.

no setter

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

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

Get Query with the same rows as this QuerySingle.

no setter

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

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

Get Query with the same rows as this QuerySingle.

no setter

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

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

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

Get Query with the same rows as this QuerySingle.

no setter

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

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

Get Query with the same rows as this QuerySingle.

no setter

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

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the QuerySingle8 extension

Get Query with the same rows as this QuerySingle.

no setter

hashCode → int

The hash code for this object.

no setter, inherited

runtimeType → Type

A representation of the runtime type of the object.

no setter, inherited

Methods

fetch() → Future<A?>

Available on QuerySingle<(Expr<A>)>, provided by the QuerySingle1 extension

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

fetch() → Future<(A, B)?>

Available on QuerySingle<(Expr<A>, Expr<B>)>, provided by the QuerySingle2 extension

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the QuerySingle8 extension

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

fetchOrNulls() → Future<(A?, B?)>

Available on QuerySingle<(Expr<A>, Expr<B>)>, provided by the QuerySingle2 extension

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

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

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

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

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

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>)>, provided by the QuerySingle4 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.

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

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

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

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

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

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

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

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the QuerySingle8 extension

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

noSuchMethod(Invocation invocation) → dynamic

Invoked when a nonexistent method or property is accessed.

inherited

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

Available on QuerySingle<(Expr<A>)>, provided by the QuerySingle1 extension

Create a projection of this QuerySingle using SELECT clause.

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

Available on QuerySingle<(Expr<A>, Expr<B>)>, provided by the QuerySingle2 extension

Create a projection of this QuerySingle using SELECT clause.

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

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

Create a projection of this QuerySingle using SELECT clause.

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

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

Create a projection of this QuerySingle using SELECT clause.

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.

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

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

Create a projection of this QuerySingle using SELECT 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)) → QuerySingle<T>

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

Create a projection of this QuerySingle using SELECT 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, Expr<H> h)) → QuerySingle<T>

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the QuerySingle8 extension

Create a projection of this QuerySingle using SELECT clause.

toString() → String

A string representation of this object.

inherited

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

Available on QuerySingle<(Expr<A>)>, provided by the QuerySingle1 extension

Filter QuerySingle using WHERE clause.

where(Expr<bool> conditionBuilder(Expr<A> a, Expr<B> b)) → QuerySingle<(Expr<A>, Expr<B>)>

Available on QuerySingle<(Expr<A>, Expr<B>)>, provided by the QuerySingle2 extension

Filter QuerySingle using WHERE clause.

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

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

Filter QuerySingle using WHERE clause.

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

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

Filter QuerySingle using WHERE 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.

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

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

Filter QuerySingle using WHERE clause.

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)) → QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>)>

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

Filter QuerySingle using WHERE clause.

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, Expr<H> h)) → QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>

Available on QuerySingle<(Expr<A>, Expr<B>, Expr<C>, Expr<D>, Expr<E>, Expr<F>, Expr<G>, Expr<H>)>, provided by the QuerySingle8 extension

Filter QuerySingle using WHERE clause.

Operators

operator ==(Object other) → bool

The equality operator.

inherited