migrateToAddCurlColumn static method

Future<void> migrateToAddCurlColumn(Database database)

Implementation

static Future<void> migrateToAddCurlColumn(Database database) async {
  debugPrint('Migrating to v2: Adding cUrl column to http_requests table');

  try {
    final result = await database
        .rawQuery("PRAGMA table_info(${HttpRequestModel.tableName})");

    bool curlColumnExists = result.any((column) => column['name'] == 'cUrl');

    if (!curlColumnExists) {
      await database.execute(
          'ALTER TABLE ${HttpRequestModel.tableName} ADD COLUMN cUrl TEXT');
      debugPrint(
          'Successfully added cUrl column to ${HttpRequestModel.tableName}');
    } else {
      debugPrint(
          'cUrl column already exists in ${HttpRequestModel.tableName}');
    }
  } catch (e) {
    debugPrint('Error during v2 migration: $e');
    rethrow;
  }
}