lastMigrationVersion method

Future<int> lastMigrationVersion()

Implementation

Future<int> lastMigrationVersion() async {
  final db = await getDb();

  // ensure migrations table exists
  await db.execute(
    'CREATE TABLE IF NOT EXISTS $_migrationVersionsTableName(version INTEGER PRIMARY KEY)',
  );

  final sqliteVersions = await db.query(
    _migrationVersionsTableName,
    distinct: true,
    orderBy: 'version DESC',
    limit: 1,
  );

  if (sqliteVersions.isEmpty) {
    return -1;
  }

  return sqliteVersions.first['version'] as int;
}