Skip to content

Class tigrbl.orm.tables.audit.Change

tigrbl.orm.tables.audit.Change

Bases: Base, GUIDPk, Timestamped

seq class-attribute instance-attribute

seq = acol(
    storage=S(Integer, primary_key=True),
    field=F(),
    io=IO(out_verbs=("read", "list")),
)

at class-attribute instance-attribute

at = acol(
    storage=S(DateTime, default=utcnow),
    field=F(),
    io=IO(out_verbs=("read", "list")),
)

actor_id class-attribute instance-attribute

actor_id = acol(
    storage=S(PgUUID, nullable=True),
    field=F(),
    io=IO(out_verbs=("read", "list")),
)

table_name class-attribute instance-attribute

table_name = acol(
    storage=S(String),
    field=F(),
    io=IO(out_verbs=("read", "list")),
)

row_id class-attribute instance-attribute

row_id = acol(
    storage=S(PgUUID, nullable=True),
    field=F(),
    io=IO(out_verbs=("read", "list")),
)

action class-attribute instance-attribute

action = acol(
    storage=S(String),
    field=F(),
    io=IO(out_verbs=("read", "list")),
)

created_at class-attribute instance-attribute

created_at = acol(
    spec=ColumnSpec(
        storage=S(
            type_=TZDateTime,
            default=tzutcnow,
            nullable=False,
        ),
        field=F(py_type=datetime),
        io=RO_IO,
    )
)

updated_at class-attribute instance-attribute

updated_at = acol(
    spec=ColumnSpec(
        storage=S(
            type_=TZDateTime,
            default=tzutcnow,
            onupdate=tzutcnow,
            nullable=False,
        ),
        field=F(py_type=datetime),
        io=RO_IO,
    )
)

id class-attribute instance-attribute

id = acol(
    spec=ColumnSpec(
        storage=S(
            type_=PgUUID(as_uuid=True),
            primary_key=True,
            default=uuid4,
        ),
        field=F(
            py_type=UUID,
            constraints={"examples": [uuid_example]},
        ),
        io=RO_IO,
    )
)

metadata class-attribute instance-attribute

metadata = MetaData(
    naming_convention={
        "pk": "pk_%(table_name)s",
        "fk": "fk_%(table_name)s_%(column_0_name)s_%(referred_table_name)s",
        "ix": "ix_%(table_name)s_%(column_0_name)s",
        "uq": "uq_%(table_name)s_%(column_0_name)s",
        "ck": "ck_%(table_name)s_%(column_0_name)s_%(constraint_type)s",
    }
)