simpleml.orm.base_sqlalchemy

Base class for sqlalchemy table models. Defaults some opinionated fields for all inherited tables.

Module Contents

Classes

BaseSQLAlchemy

Base class for sqlalchemy table models. Defaults some opinionated fields for

Functions

_receive_before_update(mapper, connection, target)

Listen for updates and update modified_timestamp column.

Attributes

Base

LOGGER

__author__

simpleml.orm.base_sqlalchemy.Base[source]
simpleml.orm.base_sqlalchemy.LOGGER[source]
simpleml.orm.base_sqlalchemy.__author__ = Elisha Yadgaran[source]
class simpleml.orm.base_sqlalchemy.BaseSQLAlchemy[source]

Bases: Base, sqlalchemy_mixins.AllFeaturesMixin

Base class for sqlalchemy table models. Defaults some opinionated fields for all inherited tables.

A sqlalchemy.MetaData object needs to be defined on each table/table group and then initialized as part of a session to be attached to a database.

Premixes the following base classes for all table models: - sqlalchemy-mixins (AllFeatureMixin)

Takes advantage of sqlalchemy-mixins to enable active record operations (TableModel.save(), create(), where(), destroy())

Added some inheritable convenience methods

created_timestamp: Server time on insert modified_timestamp: Server time on update

__abstract__ = True[source]
created_timestamp[source]
modified_timestamp[source]
classmethod filter(cls, *filters)[source]
classmethod query_by(cls, *queries)[source]
simpleml.orm.base_sqlalchemy._receive_before_update(mapper, connection, target)[source]

Listen for updates and update modified_timestamp column.