openIntervalDatabase method

Future<Database> openIntervalDatabase()

Implementation

Future<Database> openIntervalDatabase() async {
  logger.d("Opening database");

  const createIntervalTableQuery = '''
    CREATE TABLE IF NOT EXISTS $_intervalTableName(
      id TEXT PRIMARY KEY,
      workoutId TEXT,
      time INTEGER,
      name TEXT,
      color INTEGER,
      intervalIndex INTEGER,
      startSound TEXT,
      halfwaySound TEXT,
      countdownSound TEXT,
      endSound TEXT
    )
  ''';

  String dbPath = join(await getDatabasesPath(), _databaseName);
  int dbVersion = 1;

  return openDatabase(
    dbPath,
    version: dbVersion,
    onCreate: (db, version) async {
      logger.d("Creating interval table");
      await db.execute(createIntervalTableQuery);
    },
  );
}