pytams.sqlmanager

A base class for pyTAMS databases.

Classes

BaseSQLManager

A base class to handle SQLAlchemy engine and session boilerplate.

Module Contents

class BaseSQLManager(file_name: str, base_metadata: sqlalchemy.MetaData, in_memory: bool = False, ro_mode: bool = False)

A base class to handle SQLAlchemy engine and session boilerplate.

session_scope() → collections.abc.Generator[sqlalchemy.orm.Session, None, None]

Provide a transactional scope around a series of operations.

name() → str

Access the DB file name.

Returns:

the database name, empty string if in-memory

close() → None

Dispose of the engine and clear connections.