#!/usr/bin/env python3
from app_complete import app
from models import User, Company, db
import sys

with app.app_context():
    print("\n=== CURRENT USERS AND ROLES ===\n")
    users = User.query.all()
    for user in users:
        company_name = user.company.name if user.company else "No Company"
        print(f"Username: {user.username}")
        print(f"  Email: {user.email}")
        print(f"  Role: {user.role}")
        print(f"  Company: {company_name}")
        print(f"  Active: {user.active}")
        print(f"  ID: {user.id}")
        print("-" * 40)
    
    print("\n=== CURRENT COMPANIES ===\n")
    companies = Company.query.all()
    for company in companies:
        print(f"Company: {company.name}")
        print(f"  ID: {company.id}")
        print(f"  Users: {len(company.users)}")
        print("-" * 40)