Spaces:
Sleeping
Sleeping
Download auth/database.py from Coeinterns/bank-statement-api: direct link, hf CLI and curl.
- Browser
- Download file 1.23 kB
-
https://huggingface.co/spaces/Coeinterns/bank-statement-api/resolve/main/auth/database.py
- Command line
-
hf download hf://spaces/Coeinterns/bank-statement-api/auth/database.py
-
curl -L -o database.py https://huggingface.co/spaces/Coeinterns/bank-statement-api/resolve/main/auth/database.py
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() | |