check_db.py

# comp_eb/check_db.py
from database import SessionLocal
from models import User

def check_users():
    db = SessionLocal()
    print("--- Checking users in the database ---")
    try:
        users = db.query(User).all()
        if not users:
            print("Database contains NO users.")
            return

        for user in users:
            print(
                f"  ID: {user.id}, "
                f"Email: {user.email}, "
                f"Username: {user.username}, "
                f"Display Name: {user.display_name}"
            )
    finally:
        db.close()
        print("--- Check complete ---")

if __name__ == "__main__":
    check_users()