propose method

  1. @protected
  2. @override
void propose()

Called by initialize; should contain the object initialization code.

The method is allowed to throw in the case of an error. The default Actor implementation will call dispose afterward to clean up even a partially initialized object; the thrown object is passed to dispose.

Implementation

@protected
@override
void propose() {
  super.propose();
  _database = filename != null
      ? sqlite3.open(filename!)
      : sqlite3.openInMemory();

  _apiStatus = _ApiStatus.readying;

  _database!.config.doubleQuotedStringLiterals = false;

  _beginTransaction = statement("BEGIN TRANSACTION");
  _commitTransaction = statement("COMMIT TRANSACTION");
  _rollbackTransaction = statement("ROLLBACK TRANSACTION");
  _savepoint = statement("SAVEPOINT sp");
  _savepointRelease = statement("RELEASE SAVEPOINT sp");
  _rollbackToSavepoint = statement("ROLLBACK TO SAVEPOINT sp");

  beginTransaction();

  _database!.execute(
    "CREATE TABLE IF NOT EXISTS $tableMapping " +
        "($columnRowId INTEGER PRIMARY KEY AUTOINCREMENT, "
            "$columnKeyId NOT NULL UNIQUE, $columnValue NOT NULL)",
  );
  _database!.execute(
    "CREATE TABLE IF NOT EXISTS $tableScheme " +
        "($columnKeyId NOT NULL UNIQUE, $columnValue NOT NULL)",
  );

  var stored = getStoredDefinition();
  var actual = scheme.toDefinition();
  if (!(const DeepCollectionEquality()).equals(stored, actual))
    migrateScheme(stored, actual);
  else
    initializeUpdatersLookup();

  _insert = statement(
    "INSERT OR IGNORE INTO $tableMapping ($columnKeyId, $columnValue) "
    "VALUES (?, jsonb(?)) RETURNING $columnKind, $columnRowId",
  );

  var noKindsMode = scheme.kindPath == unsetKindPath;
  var kindPath = sqlLiteral(scheme.kindPath);
  var sameKind = noKindsMode
      ? "1"
      : "$columnKind IS json_extract(jsonb(?1), $kindPath)";
  var newValue = noKindsMode
      ? "jsonb(?1)"
      : "CASE WHEN $sameKind THEN jsonb(?1) ELSE $columnValue END";
  _updateByRowId = statement(
    "UPDATE $tableMapping SET $columnValue = $newValue "
    "WHERE $columnRowId == ?2 RETURNING $columnKind, $sameKind",
  );
  _updateByKeyId = statement(
    "UPDATE $tableMapping SET $columnValue = $newValue "
    "WHERE $columnKeyId == ?2 RETURNING $columnKind, $columnRowId, $sameKind",
  );

  _deleteByRowId = statement(
    "DELETE FROM $tableMapping "
    "WHERE $columnRowId == ? RETURNING $columnKind",
  );
  _deleteByKeyId = statement(
    "DELETE FROM $tableMapping "
    "WHERE $columnKeyId == ? RETURNING $columnKind, $columnRowId",
  );

  _existsByRowId = statement(
    "SELECT COUNT($columnRowId) "
    "FROM $tableMapping WHERE $columnRowId == ?",
  );
  _existsByKeyId = statement(
    "SELECT COUNT($columnKeyId) "
    "FROM $tableMapping WHERE $columnKeyId == ?",
  );

  _selectByRowId = statement(
    "SELECT $columnKeyId, json($columnValue) "
    "FROM $tableMapping WHERE $columnRowId == ?",
  );
  _selectByKeyId = statement(
    "SELECT $columnRowId, json($columnValue) "
    "FROM $tableMapping WHERE $columnKeyId == ?",
  );

  _domainQueryId = prepare(
    where: SqlI(columnKeyId).between(SqlP("@L"), SqlP("@U")),
    distinction: QueryDistinction.keyid,
  );

  _apiStatus = _ApiStatus.ready;
  commitTransaction(null);
}