import asyncio
from sqlalchemy import select
from app.database import get_db
from app.models.user import User

async def list_users():
    async for db in get_db():
        result = await db.execute(select(User))
        users = result.scalars().all()
        for u in users:
            print(f"User ID: {u.id}, Email: {u.email}, Role: {u.role}")

if __name__ == "__main__":
    asyncio.run(list_users())