import os
from sqlmodel import create_engine, Session, select
from app.models.user import User
from dotenv import load_dotenv
load_dotenv()

DATABASE_URL = os.getenv("DATABASE_URL", "sqlite:///./insurance.db")
engine = create_engine(DATABASE_URL)

with Session(engine) as session:
    users = session.exec(select(User).order_by(User.id.desc())).all()
    print(f"Total users in DB: {len(users)}")
    for u in users:
        print(f"ID: {u.id}, Name: {u.name}, Email: {u.email}, Created At: {u.created_at}")
