Django ForeignKey字段可选值筛选实现问题

需要在Django的Test模型中，让thema字段的可选选项仅显示当前选中subject关联的Thema项。模型结构如下：

class Test(models.Model):
    student = models.ForeignKey(Person, on_delete=models.CASCADE, blank=True, null=True)
    subject = models.ForeignKey(Subject, on_delete=models.CASCADE, blank=True, null=True)
    thema = models.ForeignKey(Thema, on_delete=models.CASCADE, blank=True, null=True)
    school_class = models.ForeignKey(SchoolClass, on_delete=models.CASCADE, blank=True, null=True)
    grade = models.FloatField(validators=[MinValueValidator(0), MaxValueValidator(6)], blank=True, null=True)
    date = models.DateField(default=datetime.date.today)

    def save(self, *args, **kwargs):
        if not self.school_class and self.student:
            self.school_class = self.student.klasse
        return super().save(*args, **kwargs)


class Thema(models.Model):
    subject = models.ForeignKey(Subject, on_delete=models.CASCADE, blank=True, null=True)
    thema = models.CharField(max_length=50)

class Subject(models.Model):
    teacher = models.ForeignKey(Person, on_delete=models.CASCADE, blank=True, null=True)
    name = models.CharField(max_length=20)

尝试通过limit_choices_to调用静态方法实现，先遇到模型未加载错误：

django.core.exceptions.AppRegistryNotReady: Models aren't loaded yet.

解决迁移问题后，后台创建Test时又出现新错误：

File "/Users/di/Code/Schule/GymnasiumApp/venv/lib/python3.10/site-packages/django/db/models/sql/query.py", line 1404, in build_filter
    arg, value = filter_expr
ValueError: too many values to unpack (expected 2)

这种动态关联筛选在模型层直接用limit_choices_to做不到，因为模型加载时无法获取当前实例的subject值，得从Admin后台或前端表单入手实现：

一、Django Admin后台实现联动 #

1. 自定义Admin表单，动态过滤选项 #

在admin.py里写自定义表单，重写__init__方法，根据当前实例的subject过滤thema：

from django import forms
from .models import Test, Thema

class TestAdminForm(forms.ModelForm):
    class Meta:
        model = Test
        fields = '__all__'

    def __init__(self, *args, **kwargs):
        super().__init__(*args, **kwargs)
        # 编辑已有记录时，获取当前选中的subject
        subject_id = self.instance.subject_id
        if subject_id:
            self.fields['thema'].queryset = Thema.objects.filter(subject_id=subject_id)
        else:
            # 新建记录时默认不显示任何thema
            self.fields['thema'].queryset = Thema.objects.none()

2. 关联表单到ModelAdmin，并添加前端联动JS #

继续在admin.py里配置Test的Admin类，加入JS实现实时更新：

from django.contrib import admin
from .models import Subject

class TestAdmin(admin.ModelAdmin):
    form = TestAdminForm

    # 引入自定义JS
    class Media:
        js = ('admin/js/test_admin.js',)

    def changeform_view(self, request, object_id=None, form_url='', extra_context=None):
        extra_context = extra_context or {}
        # 提前把所有subject对应的thema数据传给前端
        extra_context['subject_themas'] = {
            sub.id: list(sub.thema_set.values_list('id', 'thema'))
            for sub in Subject.objects.all()
        }
        return super().changeform_view(request, object_id, form_url, extra_context)

admin.site.register(Test, TestAdmin)

3. 写前端JS实现实时联动 #

在static/admin/js/test_admin.js里写监听逻辑：

document.addEventListener('DOMContentLoaded', function() {
    const subjectSelect = document.getElementById('id_subject');
    const themaSelect = document.getElementById('id_thema');
    // 获取后台传递的subject与thema的映射数据
    const subjectThemas = JSON.parse(document.getElementById('subject-themas').textContent);

    // 页面加载时如果已有选中的subject，更新thema选项
    updateThemaOptions(subjectSelect.value);

    // 监听subject选择变化，实时更新thema
    subjectSelect.addEventListener('change', function() {
        updateThemaOptions(this.value);
    });

    function updateThemaOptions(subjectId) {
        // 清空现有选项
        themaSelect.innerHTML = '<option value="">---------</option>';
        if (subjectId && subjectThemas[subjectId]) {
            // 添加对应subject的thema选项
            subjectThemas[subjectId].forEach(function(thema) {
                const option = document.createElement('option');
                option.value = thema[0];
                option.textContent = thema[1];
                themaSelect.appendChild(option);
            });
        }
    }
});

4. 在Admin模板中添加数据容器 #

创建templates/admin/change_form.html（如果没有的话），添加隐藏的JSON数据：

{% extends "admin/change_form.html" %}
{% block extrahead %}
    {{ block.super }}
    <script type="application/json" id="subject-themas">{{ subject_themas|json_script:"subject-themas" }}</script>
{% endblock %}

二、自定义前端表单实现联动 #

如果是自己写的前端页面，用AJAX实现：

1. 写视图接口返回对应subject的thema #

在views.py里加一个接口：

from django.http import JsonResponse
from .models import Thema

def get_themas_by_subject(request):
    subject_id = request.GET.get('subject_id')
    themas = Thema.objects.filter(subject_id=subject_id).values('id', 'thema')
    return JsonResponse(list(themas), safe=False)

2. 配置URL #

在urls.py里添加接口路由：

from django.urls import path
from . import views

urlpatterns = [
    # ...你的其他URL
    path('get-themas/', views.get_themas_by_subject, name='get_themas'),
]

3. 前端HTML和JS #

<!-- 渲染subject下拉框 -->
<select id="subject" name="subject">
    {% for subject in subjects %}
        <option value="{{ subject.id }}">{{ subject.name }}</option>
    {% endfor %}
</select>

<!-- thema下拉框 -->
<select id="thema" name="thema">
    <option value="">---------</option>
</select>

<script>
const subjectSelect = document.getElementById('subject');
const themaSelect = document.getElementById('thema');

subjectSelect.addEventListener('change', function() {
    const subjectId = this.value;
    if (!subjectId) {
        themaSelect.innerHTML = '<option value="">---------</option>';
        return;
    }
    // 调用接口获取对应thema
    fetch(`/get-themas/?subject_id=${subjectId}`)
        .then(response => response.json())
        .then(data => {
            themaSelect.innerHTML = '<option value="">---------</option>';
            data.forEach(thema => {
                const option = document.createElement('option');
                option.value = thema.id;
                option.textContent = thema.thema;
                themaSelect.appendChild(option);
            });
        });
});
</script>

之前方法失败的原因 #

1. limit_choices_to在模型加载阶段就会被解析，此时根本拿不到当前实例的subject值，所以报模型未加载完成的错误。
2. 就算解决了加载问题，你写的静态方法返回的是包含查询集的字典，而limit_choices_to需要的是查询条件字典或Q对象，格式不对才会触发"too many values to unpack"错误。

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