import subprocess

with open("/tmp/theme_mods_updated.txt") as f:
    data = f.read().strip()

sql_escaped = data.replace("'", "''")

sql = "UPDATE wp_options SET option_value = '{}' WHERE option_name = 'theme_mods_travel-monster';\n".format(sql_escaped)

result = subprocess.run(
    ["mysql", "-u", "wpuser", "-pStrongPassword@123", "wpdatabase"],
    input=sql, capture_output=True, text=True
)
print("stdout:", result.stdout)
print("stderr:", result.stderr)

# Verify
result2 = subprocess.run(
    ["mysql", "-u", "wpuser", "-pStrongPassword@123", "wpdatabase", "-N", "-r",
     "-e", "SELECT option_value FROM wp_options WHERE option_name='theme_mods_travel-monster'"],
    capture_output=True, text=True
)
data2 = result2.stdout.strip()
if 'sunsandholidays2024' in data2 and '333 E 46th' in data2:
    print("SUCCESS: Email and address updated in theme_mods")
else:
    print("WARNING: Check if update applied correctly")