//  Copyright © 2021 650 Industries. All rights reserved.

import Foundation
import sqlite3

internal final class UpdatesDatabaseMigration8To9: UpdatesDatabaseMigration {
  private(set) var filename: String = "expo-v8.db"

  func runMigration(onDatabase db: OpaquePointer) throws {
    // https://www.sqlite.org/lang_altertable.html#otheralter
    let sql = """
      ALTER TABLE "assets" ADD COLUMN "expected_hash" TEXT
    """

    guard sqlite3_exec(db, String(sql.utf8), nil, nil, nil) == SQLITE_OK else {
      throw UpdatesDatabaseMigrationError.migrationSQLError
    }
  }
}