import subprocess
import sys
import os

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

conn = pymysql.connect(
    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,
)

with conn.cursor() as cur:
    cur.execute("SELECT id, name, email, role, status, tenant_id FROM portal_users")
    rows = cur.fetchall()
    print(f"[v0] Total de portal_users: {len(rows)}")
    for r in rows:
        print(f"  id={r[0][:8]}... name={r[1]} email={r[2]} role={r[3]} status={r[4]} tenant_id={str(r[5])[:8] if r[5] else 'NULL'}...")

    # Mostra os valores distintos de role no banco
    cur.execute("SELECT DISTINCT role FROM portal_users")
    roles = cur.fetchall()
    print(f"[v0] Roles existentes: {[r[0] for r in roles]}")

conn.close()