Django中如何将列表转为QuerySet以适配django_filters？

问题背景 #

当前视图通过嵌套循环遍历Request和Quota模型数据，匹配同部件系列且日期差≤2天的记录，最终返回Python列表。接入django_filters时触发错误：AttributeError: 'list' object has no attribute '_meta'，直接使用QuerySet(result)无法将列表转为有效QuerySet，需修改逻辑生成可被django_filters处理的标准QuerySet对象。

现有代码 #

models.py #

class Part(models.Model):
    series = models.CharField(max_length=100)
    number = models.CharField(max_length=100)
    brand = models.CharField(max_length=100)

class Request(models.Model):
    part_number = models.ForeignKey(Part, on_delete=models.CASCADE)
    brand = models.CharField(max_length=100)
    quantity = models.PositiveIntegerField()
    date = models.DateField()

class Quota(models.Model):
    part_number = models.ForeignKey(Part, on_delete=models.CASCADE)
    brand = models.CharField(max_length=100)
    quantity = models.PositiveIntegerField()
    price = models.DecimalField(max_digits=10, decimal_places=2)
    supplier = models.CharField(max_length=100)
    date = models.DateField()

views.py（原逻辑） #

def requests_and_quotas(request):
    requests = Request.objects.all()
    quotas = Quota.objects.all()
    result = []
    for req in requests:
        match = False
        for quo in quotas:
            if (req.part_number.series == quo.part_number.series) and (abs((req.date - quo.date).days) <= 2):
                result.append({'request': req, 'quota': quo})
        if not match:
            result.append({'request': req, 'quota': None})
    return render(request, 'requests_and_quotas.html', {'result': result,})

解决方案 #

方案1：子查询+Annotate 注入匹配Quota字段 #

通过Django ORM的子查询功能，将符合条件的Quota字段直接注入到Request的QuerySet中，得到的QuerySet可直接兼容django_filters。

修改后的views.py：

from django.db.models import Subquery, OuterRef
from django.utils import timezone

def requests_and_quotas(request):
    # 子查询：获取当前Request对应的符合条件的首个Quota
    quota_subquery = Quota.objects.filter(
        part_number__series=OuterRef('part_number__series'),
        date__gte=OuterRef('date') - timezone.timedelta(days=2),
        date__lte=OuterRef('date') + timezone.timedelta(days=2)
    ).values(
        'id', 'brand', 'quantity', 'price', 'supplier', 'date'
    )[:1]

    # 给Request QuerySet添加匹配的Quota属性
    requests_qs = Request.objects.annotate(
        quota_id=Subquery(quota_subquery.values('id')),
        quota_brand=Subquery(quota_subquery.values('brand')),
        quota_quantity=Subquery(quota_subquery.values('quantity')),
        quota_price=Subquery(quota_subquery.values('price')),
        quota_supplier=Subquery(quota_subquery.values('supplier')),
        quota_date=Subquery(quota_subquery.values('date'))
    )

    # 直接将QuerySet传入模板和django_filters
    return render(request, 'requests_and_quotas.html', {'result': requests_qs})

模板渲染示例：

{% for req in result %}
    <div>
        <p>Request: {{ req.part_number.number }} - {{ req.date }}</p>
        {% if req.quota_id %}
            <p>Matched Quota: {{ req.quota_supplier }} - {{ req.quota_price }}</p>
        {% else %}
            <p>No matched quota</p>
        {% endif %}
    </div>
{% endfor %}

方案2：Prefetch 预取匹配的Quota集合 #

若需保留一个Request对应多个Quota的一对多结构，可使用Prefetch对象自定义预取逻辑，将所有符合条件的Quota关联到Request中，返回的仍是Request的QuerySet。

步骤1：修改Quota模型添加反向关联

在Quota的外键字段添加related_name，便于反向查询：

class Quota(models.Model):
    part_number = models.ForeignKey(Part, on_delete=models.CASCADE, related_name='quotas')
    # 其余字段不变

步骤2：修改视图使用Prefetch

from django.db.models import Prefetch, OuterRef, Q
from django.utils import timezone

def requests_and_quotas(request):
    # 定义Prefetch查询：仅获取与当前Request同系列且日期差≤2天的Quota
    matched_quotas_prefetch = Prefetch(
        'part_number__quotas',
        queryset=Quota.objects.filter(
            Q(date__gte=OuterRef('date') - timezone.timedelta(days=2)) &
            Q(date__lte=OuterRef('date') + timezone.timedelta(days=2))
        ),
        to_attr='matched_quotas'
    )

    # 预取匹配的Quota，生成标准Request QuerySet
    requests_qs = Request.objects.prefetch_related(matched_quotas_prefetch).all()

    return render(request, 'requests_and_quotas.html', {'result': requests_qs})

模板渲染示例：

{% for req in result %}
    <div>
        <p>Request: {{ req.part_number.number }} - {{ req.date }}</p>
        {% if req.part_number.matched_quotas %}
            <p>Matched Quotas:</p>
            <ul>
                {% for quota in req.part_number.matched_quotas %}
                    <li>{{ quota.supplier }} - {{ quota.price }}</li>
                {% endfor %}
            </ul>
        {% else %}
            <p>No matched quota</p>
        {% endif %}
    </div>
{% endfor %}

关键说明 #

1. 两种方案返回的都是标准Django QuerySet，完全兼容django_filters的过滤逻辑；
2. 方案1适合一对一匹配场景，方案2适合一对多匹配场景；
3. 避免使用Python循环处理数据库数据，改用ORM查询可大幅提升性能，尤其是数据量较大时。

内容的提问来源于stack exchange，提问作者Brodie121