""" auth/database.py — SQLAlchemy engine, session factory, and Base. DATABASE_URL is read from the environment (loaded by dotenv in api_server.py). Switching environments: NeonDB (testing) → postgresql://user:pass@ep-xxx.neon.tech/neondb?sslmode=require Azure PG (prod) → postgresql://user:pass@server.postgres.database.azure.com/db?sslmode=require Only DATABASE_URL in .env ever changes — no code changes needed. """ import os from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker, declarative_base DATABASE_URL = os.getenv("DATABASE_URL") if not DATABASE_URL: raise RuntimeError( "DATABASE_URL environment variable is not set. " "Add it to your .env file. " "See .env.example for the format." ) engine = create_engine( DATABASE_URL, pool_pre_ping=True, # detect stale connections pool_size=5, max_overflow=10, ) SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine) Base = declarative_base() def get_db(): """FastAPI dependency that provides a DB session per request.""" db = SessionLocal() try: yield db finally: db.close()