ParameterizedQuery<P, A> final

final class ParameterizedQuery<P, A>

A parameterized query template. Binds parameters at call time.

Example:

final byName = ParameterizedQuery(
  'SELECT id, name FROM person WHERE name = ?', personRead, Write.string);

final alice = await byName.unique('Alice').transact(xa).unsafeRunFuture();

Constructors

ParameterizedQuery() const

const ParameterizedQuery(String sql, Read<A> read, Write<P> write)

Creates a ParameterizedQuery from a SQL string, a Read codec for result rows, and a Write codec for input parameters.

Implementation

const ParameterizedQuery(this.sql, this.read, this.write);

Properties

hashCode no setter inherited

int get hashCode

The hash code for this object.

A hash code is a single integer which represents the state of the object that affects operator == comparisons.

All objects have hash codes. The default hash code implemented by Object represents only the identity of the object, the same way as the default operator == implementation only considers objects equal if they are identical (see identityHashCode).

If operator == is overridden to use the object state instead, the hash code must also be changed to represent that state, otherwise the object cannot be used in hash based data structures like the default Set and Map implementations.

Hash codes must be the same for objects that are equal to each other according to operator ==. The hash code of an object should only change if the object changes in a way that affects equality. There are no further requirements for the hash codes. They need not be consistent between executions of the same program and there are no distribution guarantees.

Objects that are not equal are allowed to have the same hash code. It is even technically allowed that all instances have the same hash code, but if clashes happen too often, it may reduce the efficiency of hash-based data structures like HashSet or HashMap.

If a subclass overrides hashCode, it should override the operator == operator as well to maintain consistency.

Inherited from Object.

Implementation

external int get hashCode;

read final

final Read<A> read

The Read codec used to decode each result row into a value of type A.

Implementation

final Read<A> read;

runtimeType no setter inherited

Type get runtimeType

A representation of the runtime type of the object.

Inherited from Object.

Implementation

external Type get runtimeType;

sql final

final String sql

The raw SQL string with ? placeholders for parameters.

Implementation

final String sql;

write final

final Write<P> write

The Write codec used to encode input parameters of type P.

Implementation

final Write<P> write;

Methods

apply()

Query<A> apply(P params)

Apply params to this query, resulting in a Query that can be transacted.

Implementation

Query<A> apply(P params) => Query(Fragment.fromParts(sql, write.encode(params)), read);

ilist()

ConnectionIO<IList<A>> ilist(P params)

Applies the given params to the query and returns all result rows as an IList.

Implementation

ConnectionIO<IList<A>> ilist(P params) => apply(params).ilist();

ivector()

ConnectionIO<IVector<A>> ivector(P params)

Applies the given params to the query and returns all result rows as an IVector.

Implementation

ConnectionIO<IVector<A>> ivector(P params) => apply(params).ivector();

nel()

ConnectionIO<NonEmptyIList<A>> nel(P params)

Applies the given params to the query and returns all result rows as a NonEmptyIList, failing if there are none.

Implementation

ConnectionIO<NonEmptyIList<A>> nel(P params) => apply(params).nel();

noSuchMethod() inherited

dynamic noSuchMethod(Invocation invocation)

Invoked when a nonexistent method or property is accessed.

A dynamic member invocation can attempt to call a member which doesn't exist on the receiving object. Example:

dynamic object = 1;
object.add(42); // Statically allowed, run-time error

This invalid code will invoke the noSuchMethod method of the integer 1 with an Invocation representing the .add(42) call and arguments (which then throws).

Classes can override noSuchMethod to provide custom behavior for such invalid dynamic invocations.

A class with a non-default noSuchMethod invocation can also omit implementations for members of its interface. Example:

class MockList<T> implements List<T> {
  noSuchMethod(Invocation invocation) {
    log(invocation);
    super.noSuchMethod(invocation); // Will throw.
  }
}
void main() {
  MockList().add(42);
}

This code has no compile-time warnings or errors even though the MockList class has no concrete implementation of any of the List interface methods. Calls to List methods are forwarded to noSuchMethod, so this code will log an invocation similar to Invocation.method(#add, [42]) and then throw.

If a value is returned from noSuchMethod, it becomes the result of the original invocation. If the value is not of a type that can be returned by the original invocation, a type error occurs at the invocation.

The default behavior is to throw a NoSuchMethodError.

Inherited from Object.

Implementation

@pragma("vm:entry-point")
@pragma("wasm:entry-point")
external dynamic noSuchMethod(Invocation invocation);

option()

ConnectionIO<Option<A>> option(P params)

Applies the given params to the query and returns Some if 1 rows is returned, None if 0, and fails if more than 1 row is returned.

Implementation

ConnectionIO<Option<A>> option(P params) => apply(params).option();

stream()

ConnectionRill<A> stream(P params)

Applies the given params to the query and returns a ConnectionRill that streams result rows lazily.

Call .transact(xa) on the result to obtain a Rill that keeps the database connection open for the duration of the stream.

Example:

final rill = byName.stream('Alice').transact(xa);

Implementation

ConnectionRill<A> stream(P params) => apply(params).stream();

toString() inherited

String toString()

A string representation of this object.

Some classes have a default textual representation, often paired with a static parse function (like int.parse). These classes will provide the textual representation as their string representation.

Other classes have no meaningful textual representation that a program will care about. Such classes will typically override toString to provide useful information when inspecting the object, mainly for debugging or logging.

Inherited from Object.

Implementation

external String toString();

unique()

ConnectionIO<A> unique(P params)

Applies the given params to the query and returns exactly 1 row, failing if there are 0 or more than 1.

Implementation

ConnectionIO<A> unique(P params) => apply(params).unique();

Operators

operator ==() inherited

bool operator ==(Object other)

The equality operator.

The default behavior for all Objects is to return true if and only if this object and other are the same object.

Override this method to specify a different equality relation on a class. The overriding method must still be an equivalence relation. That is, it must be:

• Total: It must return a boolean for all arguments. It should never throw.

• Reflexive: For all objects o, o == o must be true.

• Symmetric: For all objects o1 and o2, o1 == o2 and o2 == o1 must either both be true, or both be false.

• Transitive: For all objects o1, o2, and o3, if o1 == o2 and o2 == o3 are true, then o1 == o3 must be true.

The method should also be consistent over time, so whether two objects are equal should only change if at least one of the objects was modified.

If a subclass overrides the equality operator, it should override the hashCode method as well to maintain consistency.

Inherited from Object.

Implementation

external bool operator ==(Object other);