import os
from dotenv import load_dotenv
from sqlalchemy import create_engine, text

load_dotenv()
url = os.getenv('DATABASE_URL')
print("DATABASE_URL:", url)
engine = create_engine(url)

with engine.connect() as conn:
    print("\n--- users table records ---")
    try:
        res = conn.execute(text("SELECT id, name, email FROM \"users\""))
        for row in res:
            print(row)
    except Exception as e:
        print("Error reading users:", e)
