PostgresConnection final

final class PostgresConnection extends SqlConnection

A SqlConnection backed by a PostgreSQL pg.Session.

Wraps either a pg.Connection or a pg.TxSession so the same SqlConnection interface works both outside and inside a transaction.

Inheritance

Object → SqlConnection → PostgresConnection

Constructors

PostgresConnection()

PostgresConnection(Session _session)

Creates a PostgresConnection wrapping the given PostgreSQL session.

Implementation

PostgresConnection(this._session);

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;

runtimeType no setter inherited

Type get runtimeType

A representation of the runtime type of the object.

Inherited from Object.

Implementation

external Type get runtimeType;

Methods

beginTransaction() inherited

IO<Unit> beginTransaction()

Begins a new database transaction.

Inherited from SqlConnection.

Implementation

IO<Unit> beginTransaction() => execute('BEGIN TRANSACTION');

close() override

IO<Unit> close()

No-op — the underlying session lifecycle is managed by the Transactor (or pool) that created this connection.

Implementation

@override
IO<Unit> close() => IO.unit;

commit() inherited

IO<Unit> commit()

Commits the current transaction.

Inherited from SqlConnection.

Implementation

IO<Unit> commit() => execute('COMMIT');

execute() inherited

IO<Unit> execute(String sql)

Executes a SQL statement that produces no result rows (e.g. DDL or pragmas). This is a convenience over executeQuery that discards the result.

Inherited from SqlConnection.

Implementation

IO<Unit> execute(String sql) => executeQuery(sql, StatementParameters.empty()).voided();

executeQuery() override

IO<IList<Row>> executeQuery(String sql, StatementParameters params)

Executes a SELECT query and returns all rows as lists of column values.

Implementation

@override
IO<IList<Row>> executeQuery(String sql, StatementParameters params) => IO.fromFutureF(() async {
  final result = await _session.execute(_toPositional(sql), parameters: params.toList);
  return result.map((postgresRow) => Row(postgresRow.toIList())).toIList();
});

executeUpdate() override

IO<int> executeUpdate(String sql, StatementParameters params)

Executes an INSERT, UPDATE, or DELETE statement and returns the number of rows affected.

Implementation

@override
IO<int> executeUpdate(String sql, StatementParameters params) => IO.fromFutureF(() async {
  final result = await _session.execute(
    _toPositional(sql),
    parameters: params.toList,
    ignoreRows: true,
  );
  return result.affectedRows;
});

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);

rollback() inherited

IO<Unit> rollback()

Rolls back the current transaction.

Inherited from SqlConnection.

Implementation

IO<Unit> rollback() => execute('ROLLBACK');

streamQuery() override

Rill<Row> streamQuery(
  String sql,
  StatementParameters params, {
  int chunkSize = 64,
})

Streams rows from a SELECT query, emitting each Row. Suitable for large result sets that should not be fully buffered.

The returned rill will attempt to pull chunks from the result sized up to chunkSize.

Implementation

@override
Rill<Row> streamQuery(String sql, StatementParameters params, {int chunkSize = 64}) {
  return Rill.bracketCase(
    IO.fromFutureF(() => _session.prepare(_toPositional(sql))),
    (statement, ec) {
      final dispose = IO.fromFutureF(() => statement.dispose()).voided();

      &#47;&#47; On cancellation, the in-flight query holds the connection's internal
      &#47;&#47; operation lock. statement.dispose() would hang indefinitely waiting
      &#47;&#47; for that lock (which only releases when the server finishes the
      &#47;&#47; query). Force-closing the connection first interrupts the pending
      &#47;&#47; query, releases the lock, and turns dispose() into a no-op (it
      &#47;&#47; checks _isClosing) so cleanup can proceed without blocking.
      if (!ec.isCanceled || _session is! pg.Connection) {
        return dispose;
      } else {
        return IO.fromFutureF(() => _session.close(force: true)).attempt().productR(dispose);
      }
    },
  ).flatMap((statement) {
    return Rill.eval(Queue.unbounded<Either<Object, Option<pg.ResultRow>>>()).flatMap((queue) {
      final maxN = Some(chunkSize);

      Rill<Row> consumeQueue() {
        &#47;&#47; Option 1: Chunking
        return Rill.eval(queue.tryTakeN(maxN)).flatMap((events) {
          &#47;&#47; split into the Right<Option> prefix, and whatever is a Left
          final (rightOpts, errOpt) = events.spanRightsAndFirstLeft;

          final rows = Rill.emits(
            rightOpts.unNone().map((pgRow) => Row(pgRow.toIList())).toList(),
          );

          &#47;&#47; A None signals the underlying Stream is done
          final continueConsume = rightOpts.forall((opt) => opt.isDefined);

          if (continueConsume) {
            &#47;&#47; all Somes so send all
            final Rill<Row> err = errOpt.fold(
              () => Rill.empty(),
              (err) => Rill.raiseError(err),
            );

            return rows.append(() => err).append(() => consumeQueue());
          } else {
            return rows;
          }
        });

        &#47;&#47; Option 2: No chunking
        &#47;&#47; return Rill.eval(queue.take()).flatMap((event) {
        &#47;&#47;   return event.fold(
        &#47;&#47;     Rill.raiseError<Row>,
        &#47;&#47;     (opt) => opt.fold(
        &#47;&#47;       Rill.empty<Row>,
        &#47;&#47;       (row) => Rill.emit(Row(row.toIList())).append(() => consumeQueue()),
        &#47;&#47;     ),
        &#47;&#47;   );
        &#47;&#47; });
      }

      final acquire = IO.delay(
        () => statement
            .bind(params.toList)
            .listen(
              (row) => queue.offer(Right(Some(row))).unsafeRunAndForget(),
              onError: (Object err) => queue.offer(Left(err)).unsafeRunAndForget(),
              onDone: () => queue.offer(Right(none())).unsafeRunAndForget(),
              cancelOnError: false,
            ),
      );

      &#47;&#47; On cancellation, skip sub.cancel() — the outer bracketCase will
      &#47;&#47; force-close the connection, which causes the subscription to
      &#47;&#47; terminate naturally via onError&#47;onDone. Calling sub.cancel() here
      &#47;&#47; would race with the force-close and could block on the operation
      &#47;&#47; lock that the in-flight query holds.
      &#47;&#47; On success&#47;error the stream is already done, so cancel() is a no-op.
      return Rill.bracketCase(
        acquire,
        (sub, ec) => ec.isCanceled ? IO.unit : IO.fromFutureF(() => sub.cancel()).voided(),
      ).flatMap((_) => consumeQueue());
    });
  });
}

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();

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);