subclass does not inherit parent's ordering

[yosong-github]

class BaseModel(Model):

    created_at = fields.DatetimeField(auto_now_add=True, description="创建时间")
    updated_at = fields.DatetimeField(auto_now=True, description="更新时间")

    class Meta:
        ordering = ["-created_at"]  # 创建时间倒序排序 目前默认所有子类都不会按创建时间降序排序
        abstract = True 


class Book(BaseModel):
    name = fields.CharField(max_length=255, description="书名")
    author = fields.CharField(max_length=255, description="作者")

    class Meta:
        table = "books"

Book.first() or Book.all()

没有按照时间创建时间倒序

[
    {
    "updated_at": "2025-12-19T02:36:06.495233+00:00",
    "created_at": "2025-12-19T02:36:06.495219+00:00",
    "author": "作者姓名",
    "id": 1,
    "name": "示例书籍"
    },
    {
    "updated_at": "2025-12-19T02:36:28.903933+00:00",
    "created_at": "2025-12-19T02:36:28.903920+00:00",
    "author": "作者姓名",
    "id": 2,
    "name": "示例书籍"
    },
    {
    "updated_at": "2025-12-19T02:36:52.893059+00:00",
    "created_at": "2025-12-19T02:36:52.893044+00:00",
    "author": "作者姓名",
    "id": 3,
    "name": "示例书籍"
    }
]

[waketzheng]

It seems that there is a BUG about Meta inherit.

Currently, you can do it like this:

from tortoise import Model, fields


class TimeMixin:
    created_at = fields.DatetimeField(auto_now_add=True, description="创建时间")
    updated_at = fields.DatetimeField(auto_now=True, description="更新时间")

    class Meta:
        ordering = ["-created_at"]


class BaseModel(TimeMixin, Model):
    class Meta:
        abstract = True


class Book(BaseModel):
    name = fields.CharField(max_length=255, description="书名")
    author = fields.CharField(max_length=255, description="作者")

    class Meta(TimeMixin.Meta):
        table = "books"


def main() -> None:
    import anyio
    from tortoise import run_async
    from tortoise.contrib.test import init_memory_sqlite

    @init_memory_sqlite
    async def run() -> None:
        await Book.create(name="1", author="2")
        await anyio.sleep(0.1)
        await Book.create(name="10", author="20")
        print(await Book.all())

    run_async(run())


if __name__ == "__main__":
    main()