migrate method

  1. @override
Future<void> migrate()

Prepare schema.

Implementation

@override
Future<void> migrate() async {
  const statement = '''
    CREATE TABLE IF NOT EXISTS `$GRAPHQL_JOBS_TABLE_NAME` (
      `$GRAPHQL_JOBS_PRIMARY_KEY_COLUMN` INTEGER PRIMARY KEY AUTOINCREMENT,
      `$GRAPHQL_JOBS_ATTEMPTS_COLUMN` INTEGER DEFAULT 1,
      `$GRAPHQL_JOBS_DOCUMENT_COLUMN` TEXT,
      `$GRAPHQL_JOBS_VARIABLES_COLUMN` TEXT,
      `$GRAPHQL_JOBS_LOCKED_COLUMN` INTEGER DEFAULT 0,
      `$GRAPHQL_JOBS_OPERATION_NAME_COLUMN` TEXT,
      `$GRAPHQL_JOBS_UPDATED_AT` INTEGER DEFAULT 0,
      `$GRAPHQL_JOBS_CREATED_AT_COLUMN` INTEGER DEFAULT 0
    );
  ''';
  final db = await getDb();
  await db.execute(statement);
}