exec method

  1. @override
Future<Database> exec()
override

Implementation

@override
Future<Database> exec() async {
  return openDatabase(FitnessMastersModelNames.fileName.name, version: 1,
      onCreate: (Database db, int version) async {
    try {
      // テーブル作成
      await db.execute(
        'CREATE TABLE ${FitnessMastersModelNames.tableName.name} ('
        '${FitnessMastersModelNames.masterVersion.name} TEXT, '
        '${FitnessMastersModelNames.fitnessEvaluationThresholdVersion.name} TEXT, '
        '${FitnessMastersModelNames.fitnessMasterVersion.name} TEXT, '
        '${FitnessMastersModelNames.uid.name} TEXT, '
        '${FitnessMastersModelNames.fitnessId.name} INTEGER, '
        '${FitnessMastersModelNames.mets.name} REAL, '
        '${FitnessMastersModelNames.movieFileName.name} TEXT, '
        '${FitnessMastersModelNames.descriptionTimeSeconds.name} INTEGER, '
        'PRIMARY KEY(${FitnessMastersModelNames.masterVersion.name}, '
        '${FitnessMastersModelNames.fitnessEvaluationThresholdVersion.name}, '
        '${FitnessMastersModelNames.fitnessMasterVersion.name}))',
      );
    } on DatabaseException catch (error, stackTrace) {
      throw _sqfliteErrorHandler.handleSqfliteError(
        error,
        stackTrace,
        'CREATE TABLE ${FitnessMastersModelNames.tableName.name}',
      );
    } catch (error, stackTrace) {
      throw _dbErrorHandler.handleUnknownError(
        error,
        stackTrace,
      );
    }
  });
}