我怎样才能得到这样的Django ManyToManyField列表？

Question

msgs

<QuerySet [<Msg: home : Dusra msg from admin>, <Msg: home : good>, <Msg: home : k>, <Msg: home : k>, <Msg: home : hi>, <Msg: home : Yello>, <Msg: home : Good>, <Msg: home : lets se>]>

msgs.values('content','likes') # likes is a ManyToManyField

<QuerySet [{'content': 'Dusra msg from admin', 'likes': UUID('472ab5e5-ddda-4d18-b229-67f7d0f3d7fb')}, {'content': 'Dusra msg from admin', 'likes': UUID('8bbb16f2-11a7-4d52-818b-acbdcf518810')}, {'content': 'Dusra msg from admin', 'likes': UUID('d1499fb6-4fd6-4ec1-abda-a507c1339d93')}, {'content': 'good', 'likes': None}, {'content': 'k', 'likes': None}, {'content': 'k', 'likes': UUID('36d0c720-9169-4d66-8afa-2ff2ffb30166')}, {'content': 'hi', 'likes': None}, {'content': 'Yello', 'likes': None}, {'content': 'Good', 'likes': None}, {'content': 'lets se', 'likes': UUID('36d0c720-9169-4d66-8afa-2ff2ffb30166')}, {'content': 'lets se', 'likes': UUID('68f85e0c-fda1-4856-894c-b9c52fda5669')}, {'content': 'lets se', 'likes': UUID('d1499fb6-4fd6-4ec1-abda-a507c1339d93')}]>

我想把上面的输出转换成下面的输出

    <QuerySet [{'content': 'Dusra msg from admin', 'likes': ['472ab5e5-ddda-4d18-b229-67f7d0f3d7fb', '8bbb16f2-11a7-4d52-818b-acbdcf518810', 'd1499fb6-4fd6-4ec1-abda-a507c1339d93')}, {'content': 'good', 'likes': None}]}

Answer 1

如果数据库是PostgreSQL，则可以使用ArrayAgg。它将结果聚合为字段中的列表。检查此文档：

https://docs.djangoproject.com/en/3.2/ref/contrib/postgres/aggregates/