Skip to content

table_mixins

TableNameMixin

Mixing to automatically name tables based on class name.

Generates a __tablename__ for classes inheriting from this mixin.

Source code in src/red_utils/ext/sqlalchemy_utils/mixins/table_mixins.py 
32
33
34
35
36
37
38
39
40
class TableNameMixin:
    """Mixing to automatically name tables based on class name.

    Generates a `__tablename__` for classes inheriting from this mixin.
    """

    @so.declared_attr.directive
    def __tablename__(cls) -> str:
        return cls.__name__.lower() + "s"

TimestampMixin

Add a created_at & updated_at column to records.

Add to class declaration to automatically create these columns on records.

Usage:

``` py linenums=1 class Record(Base, TimestampMixin): tablename = ...

...

```

Source code in src/red_utils/ext/sqlalchemy_utils/mixins/table_mixins.py 
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
class TimestampMixin:
    """Add a created_at & updated_at column to records.

    Add to class declaration to automatically create these columns on
    records.

    Usage:

    ``` py linenums=1
    class Record(Base, TimestampMixin):
        __tablename__ = ...

        ...
    ```
    """

    created_at: so.Mapped[datetime] = so.mapped_column(
        sa.TIMESTAMP, server_default=sa.func.now()
    )
    updated_at: so.Mapped[datetime] = so.mapped_column(
        sa.TIMESTAMP, server_default=sa.func.now(), onupdate=sa.func.now()
    )