todo-full-stack / src /database.py
codeverseinnovation
update files
a7a252e
Raw History Blame Contribute Delete
1.16 kB
from sqlalchemy import create_engine
from sqlalchemy.pool import QueuePool
from sqlmodel import Session, SQLModel
from contextlib import contextmanager
from .config import settings
# Create the database engine
# Uses DATABASE_URL from environment variables (loaded via settings)
# Connection pooling is configured for production use
engine = create_engine(
settings.get_database_url, # Loads from NEON_DATABASE_URL or DATABASE_URL
poolclass=QueuePool,
pool_size=5,
pool_pre_ping=True, # Verify connections before using them
pool_recycle=300, # Recycle connections after 5 minutes
echo=False, # Set to True for SQL query logging during development
)
@contextmanager
def get_session():
"""
Context manager for database sessions.
Ensures proper cleanup of database connections.
"""
session = Session(engine)
try:
yield session
session.commit()
except Exception:
session.rollback()
raise
finally:
session.close()
def get_session_dep():
"""
FastAPI dependency for database sessions.
"""
with get_session() as session:
yield session