File size: 1,233 Bytes
d084ead
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
"""

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()