Manager

Database module to handle SQLAlchemy connections and interactions.

exception ConnectionError

Exception raised when connection fails.

exception DatabaseError

Base exception for database errors.

class DatabaseManager(config, echo=False)

Class to handle database operations using SQLAlchemy.

Initialize database connection.

Parameters:

• database (Path) – Path to the SQLite database file

• echo (bool) – Enable SQL query logging if True

_connect()

Create database tables if they don’t exist.

Return type:

None

_create_engine(echo)

Create SQLAlchemy engine with proper settings.

Return type:

Engine

Parameters:

echo (bool) – Enable SQL query logging if True

Returns:

Configured SQLAlchemy engine

Return type:

Engine

Raises:

ConnectionError – When invalid database settings are provided

session()

Create a contextual database session.

Return type:

Generator[Session, None, None]

Yields:

Session – SQLAlchemy session object

Raises:

QueryError – If session operations fail

exception QueryError

Exception raised when query fails.