import sys
from pathlib import Path
sys.path.insert(0, str(Path(__file__).resolve().parents[1]))
from dotenv import load_dotenv
load_dotenv(Path(__file__).resolve().parents[1] / '.env')
from app import create_app
from app.models.base import db

app = create_app()
tablas = ['empresas','usuarios','sucursales','clientes','productos','roles','accesos_sucursal']
with app.app_context():
    with db.engine.connect() as conn:
        for tabla in tablas:
            r = conn.execute(db.text(f"SELECT COUNT(*) FROM {tabla}"))
            count = r.scalar()
            print(f"{tabla}: {count} registros")
        
        # Mostrar usuarios
        print("\n--- USUARIOS ---")
        r = conn.execute(db.text("SELECT email, is_superadmin, is_active, pantallas_asignadas FROM usuarios"))
        for row in r.fetchall():
            print(f"  {row[0]} | superadmin={row[1]} | activo={row[2]} | pantallas={row[3]}")
        
        # Mostrar empresas
        print("\n--- EMPRESAS ---")
        r = conn.execute(db.text("SELECT razon_social, cedula_juridica, plan_estado, is_active FROM empresas"))
        for row in r.fetchall():
            print(f"  {row[0]} | ced={row[1]} | plan={row[2]} | activo={row[3]}")