Skip to main content
 首页 » 编程设计

python之使用下拉菜单外键 : IntegrityError XXX_id may not be NULL 保存表单集

2025年05月04日9del

我正在尝试创建一个表单集,其中每个表单 (PropertySelector) 都有一个下拉菜单 (PropertySelector.property),而该菜单的每个项目都是对另一个模型 (Property) 的 ForeignKey 引用。

不知何故,当我尝试提交并保存我得到的表单集时:

Exception Type:     IntegrityError 
Exception Value:    testproj_propertyselector.property_id may not be NULL 

它有什么问题,我该如何解决?我的整个代码如下。谢谢。

编辑: 在我看来这像是 inline_formset 问题(也许 MySQL 也是)。请帮助我解决问题。

项目名为 testproj,我的应用也名为 testproj。

首先我们填充属性:

>>> from testproj.models import Property 
>>> p = Property(name='prop1', basic=True) 
>>> p.save()  
>>> p = Property(name='prop2', basic=True) 
>>> p.save() 

模型.py

from django.db import models 
 
class PropertySet(models.Model): 
    name = models.CharField(max_length=50) 
 
class Property(models.Model): 
    name = models.CharField(max_length=50) 
    basic = models.BooleanField() 
 
    def __unicode__(self): 
        return u'%s' % (self.name) 
 
class PropertySelector(models.Model): 
    property_set = models.ForeignKey(PropertySet) 
    title = models.CharField(max_length=50) 
    property = models.ForeignKey(Property) 

表单.py

from django.forms import ModelForm, TextInput, Select, ModelChoiceField 
from django.db.models import Q 
from testproj.models import Property, PropertySet, PropertySelector 
 
class PropertySetForm(ModelForm): 
    class Meta: 
        model = PropertySet 
 
def PropertySelForm(): 
    PropertyQueryset = Property.objects.filter(Q(basic=True)) 
 
    class PropertySelectorForm(ModelForm): 
        property = ModelChoiceField( 
            queryset=PropertyQueryset, 
            widget=Select(attrs={'class': 'property'}) 
        ) 
 
        def __init__(self, *args, **kwargs):  
            super(ModelForm, self).__init__(*args, **kwargs) 
            self.css_class = "prop_sel" 
 
        class Meta: 
            model = PropertySelector 
            fields = ("property_set", "title") 
            widgets = {"title" : TextInput(attrs={"class" : "title"})} 
 
    return PropertySelectorForm 

View .py

from django.shortcuts import render_to_response 
from django.template import RequestContext 
from django.forms.models import inlineformset_factory 
 
from testproj.models import PropertySet, PropertySelector 
from testproj.forms import PropertySetForm, PropertySelForm, PropertySelForm 
 
def index(request): 
 
    property_selector_form = PropertySelForm() 
    PropertySelectorFormSet = inlineformset_factory(PropertySet, PropertySelector, form=property_selector_form) 
 
    if request.method == "POST": 
 
        property_set_form = PropertySetForm(request.POST) 
 
        if property_set_form.is_valid():             
            saved_property_set = property_set_form.save() 
 
            prop_sel_formset = PropertySelectorFormSet(request.POST, instance=saved_property_set) 
 
            if prop_sel_formset.is_valid(): 
                prop_sel_formset.save() 
 
        else: 
 
            property_set_form = PropertySetForm() 
 
            prop_sel_formset = PropertySelectorFormSet()     
 
        return render_to_response( 
            "testproj/index.html", 
            { 
                "property_set_form": property_set_form, 
                "prop_sel_formset": prop_sel_formset 
            }, 
            context_instance=RequestContext(request) 
        ) 

index.html(模板):

{% block content %} 
 
<head> 
 
</head> 
 
<body> 
 
<form method="post" action=""> {% csrf_token %} 
 
    {{ property_set_form.as_p }} 
 
    {{ prop_sel_formset.management_form }} 
 
    {% for form in prop_sel_formset %} 
        {{ form }} 
 
    {% endfor %} 
 
    <input type="submit" value="Submit">     
</form> 
 
</body> 
{% endblock %} 

请您参考如下方法:

property_id 未保存,因为您未将其包含在 form.Meta 中。离开字段,它起作用了:

def PropertySelForm(): 
    PropertyQueryset = Property.objects.filter(Q(basic=True)) 
 
    class PropertySelectorForm(ModelForm): 
        property = ModelChoiceField( 
            queryset=PropertyQueryset, 
            widget=Select(attrs={'class': 'property'}) 
        ) 
 
        def __init__(self, *args, **kwargs):  
            super(ModelForm, self).__init__(*args, **kwargs) 
            self.css_class = "prop_sel" 
 
        class Meta: 
            model = PropertySelector 
            #fields = ("property_set", "title") 
            widgets = {"title" : TextInput(attrs={"class" : "title"})} 
 
    return PropertySelectorForm 

我会将 PropertySelForm 重命名为 property_selectorform_factory,但那是 只有我。 :)