#!/usr/bin/env python3


import mysql.connector
import sys

mydb = mysql.connector.connect(
  host="127.0.0.1",
  user="flood_user",
  password="flood@ADMIN123",
  database="pakistan_flood"
)

random = sys.argv[1]

mycursor = mydb.cursor()

mycursor.execute(f"UPDATE hec_ras_model_run_archive_tb SET exp_available=1 WHERE location_name='{random}'")

mydb.commit()
mycursor.close()