daklib.database.base

Classes

Base(**kwargs)
BaseMethods(**kwargs)
BaseTimestamp(**kwargs)

class daklib.database.base.Base(**kwargs: Any)

_sa_registry: ClassVar[_RegistryType] = <sqlalchemy.orm.decl_api.registry object>

metadata: ClassVar[MetaData] = MetaData()

Refers to the _schema.MetaData collection that will be used for new _schema.Table objects.

See also

Accessing Table and Metadata

registry: ClassVar[_RegistryType] = <sqlalchemy.orm.decl_api.registry object>

Refers to the _orm.registry in use where new _orm.Mapper objects will be associated.

class daklib.database.base.BaseMethods(**kwargs: Any)

classmethod get(primary_key, session)

This is a support function that allows getting an object by its primary key.

Architecture.get(3[, session])

instead of the more verbose

session.query(Architecture).get(3)

class daklib.database.base.BaseTimestamp(**kwargs: Any)

created: Mapped[datetime] = <sqlalchemy.orm.properties.MappedColumn object>

modified: Mapped[datetime] = <sqlalchemy.orm.properties.MappedColumn object>

modified_trigger = <DDL@139663129239760; '\nCREATE TRIGGER %(table)s_modified BEFORE UPDATE ON %(fullname)s\nFOR EACH ROW EXECUTE PROCEDURE tfunc_set_modified()\n    '>

modified_trigger_function = <DDL@139663128980720; '\nCREATE OR REPLACE FUNCTION tfunc_set_modified() RETURNS trigger\nLANGUAGE plpgsql\nAS $$\n    BEGIN NEW.modified = now(); return NEW; END;\n$$\n    '>