bank-statement-api / auth /database.py
3v324v23's picture
Merge Conflict solved | Build error solved
205f25f
Raw History Blame Contribute Delete
1.23 kB
"""
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()