Django：复制和操作查询集？

发布于 2024-10-10 00:39:34 字数 616 浏览 4 评论 0原文

我需要重新排序 Django 查询集，因为我想放置 FloatField 上的 ORDER BY DESC 查询底部没有值。

不幸的是，我正在努力寻找一种优雅的方法来操作 Django 查询集。这是我到目前为止所得到的：

cities = City.objects.filter(country__id=country.id).order_by('value')
if cities.count() > 1:
    cities_sorted = cities
    del manors_sorted[:]
    for city in cities:
        cities_sorted += city
        # Add code to 
        cities = cities_sorted

目前，此操作失败，并显示 'QuerySet' 对象不支持项目删除。

知道如何复制并重新排序此查询集以将“无”项目放在最后吗？

原文

I need to re-order a Django queryset, because I want to put None values at the bottom of an ORDER BY DESC query on a FloatField.

Unfortunately, I'm struggling to find an elegant way to manipulate a Django queryset. Here's what I have so far:

cities = City.objects.filter(country__id=country.id).order_by('value')
if cities.count() > 1:
    cities_sorted = cities
    del manors_sorted[:]
    for city in cities:
        cities_sorted += city
        # Add code to 
        cities = cities_sorted

Currently, this fails with 'QuerySet' object does not support item deletion.

Any idea how I can copy and re-order this QuerySet to put None items last?

分享到QQ

分享到微博