SqliteConnection final

final class SqliteConnection extends SqlConnection

A SqlConnection backed directly by a sqlite3 Database instance.

This is the low-level connection used by SqliteTransactor. It executes all operations synchronously on the calling isolate via IO.delay.

Inheritance

Object → SqlConnection → SqliteConnection

Constructors

SqliteConnection()

SqliteConnection(Database _db)

Creates a SqliteConnection wrapping the given sqlite3 Database.

Implementation

SqliteConnection(this._db);

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

Closes this connection and releases any associated resources.

Implementation

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

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.delay(
  () =>
      _db
          .select(sql, params.toList)
          .map((sqliteRow) => Row(sqliteRow.values.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.delay(() {
  _db.execute(sql, params.toList);
  return _db.updatedRows;
});

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.bracket(
    IO.delay(() => _db.prepare(sql)),
    (stmt) => IO.exec(() => stmt.close()),
  ).flatMap(
    (stmt) => Rill.fromIterator(
      stmt.selectCursor(params.toList),
      chunkSize: chunkSize,
    ).map((x) => Row(x.values.toIList())),
  );
}

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