import subprocess
import sys
import os

subprocess.check_call([sys.executable, "-m", "pip", "install", "pymysql", "--quiet"])
import pymysql

DB_CONFIG = {
    "host":            os.environ.get("MYSQL_HOST", "localhost"),
    "port":            int(os.environ.get("MYSQL_PORT", 3306)),
    "user":            os.environ.get("MYSQL_USER", "root"),
    "password":        os.environ.get("MYSQL_PASSWORD", ""),
    "database":        os.environ.get("MYSQL_DATABASE", "admanager"),
    "charset":         "utf8mb4",
    "connect_timeout": 15,
}

conn = pymysql.connect(**DB_CONFIG)
cursor = conn.cursor()

cursor.execute("SHOW COLUMNS FROM tenants LIKE 'ad_service_password'")
if not cursor.fetchone():
    print("[v0] Adicionando coluna ad_service_password na tabela tenants...")
    cursor.execute("""
        ALTER TABLE tenants
        ADD COLUMN ad_service_password VARCHAR(255) NULL DEFAULT NULL
        AFTER ad_service_user
    """)
    conn.commit()
    print("[v0] Coluna ad_service_password adicionada.")
else:
    print("[v0] Coluna ad_service_password ja existe.")

cursor.close()
conn.close()
print("[v0] Pronto.")