Django:__in查询查找不维护queryset中的顺序 [英] Django: __in query lookup doesn't maintain the order in queryset

问题描述

我有特定顺序的ID

>>> album_ids = [24, 15, 25, 19, 11, 26, 27, 28]
>>> albums = Album.objects.filter( id__in=album_ids, published= True )
>>> [album.id for album in albums]
[25, 24, 27, 28, 26, 11, 15, 19]

在查询集中我需要相册的顺序与 album_ids 中id的顺序相同.有人请告诉我如何维持订单?还是像album_ids中那样获得相册?

I need albums in queryset in the same order as id's in album_ids. Anyone please tell me how can i maintain the order? or obtain the albums as in album_ids?

推荐答案

假设ID列表不太大，您可以将QS转换为列表并在Python中对其进行排序:

Assuming the list of IDs isn't too large, you could convert the QS to a list and sort it in Python:

album_list = list(albums)
album_list.sort(key=lambda album: album_ids.index(album.id))

这篇关于Django:__in查询查找不维护queryset中的顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！