backend.database

Database connection and session management.

Provides the SQLAlchemy engine, session factory and the FastAPI dependency get_db().

Configuration is done via the DATABASE_URL environment variable (default: sqlite:///./backend/db/app.db).

backend.database.get_db()

FastAPI dependency that provides a database session per request.

Opens a new sqlalchemy.orm.Session and ensures it is closed after the request completes, even if an exception occurs.

Yields:

Session – An active SQLAlchemy database session.