Django：不支持的 CharField 查找“case_exact”或不允许加入该字段

Question

这是我的服务器上的 GET 请求。 HTTP GET /testPage/?persona_name=Aman&key_name=country&key_label=My+Country&key_value=India&Save=Submit 500在这个视图的帮助下，我从 GET 请求中获取值。def PersonaSave(request):    persona_name = request.GET.get('persona_name',)    persona_key = request.GET.get('key_name',)    persona_key_value = request.GET.get('key_value',)    persona_key_label = request.GET.get('key_label',)    persona_submit = request.GET.get('Save',)    return( persona_name , persona_key , persona_key_label , persona_key_value , persona_submit现在以下是我检查具有给定角色名称的对象是否存在的功能。如果它存在，那么我正在更新值，如果它是一个新的角色，那么我正在创建新的 testPersona 对象。def TestPageView(request):    x=PersonaSave(request)    persona_name = x[0]    persona_key = x[1]    persona_key_label=x[2]    persona_key_value=x[3]    persona_submit=x[4]    testPersonaName = TestPersonaName(name=persona_name)    testPersonaName.save()    if(persona_name is None and persona_key is None and persona_key_label is None and persona_key_value is None):        return render(request, 'dashboard/test_page.html') # Below is the function for updating testPersona .     elif TestPersonaName.objects.filter(name__case_exact=persona_name).exists():        testpersona = TestPersona.objects.get(name__case_exact=persona_name)        if testpersona.key == persona_key:            testpersona.label= persona_key_label            testpersona.value = persona_key_value            testpersona.save()#If persona with new name is detected then saving a new testPersona object.      testpersona=TestPersona(name=persona_name,key=persona_key,label=persona_key_label,value=persona_key_value)        testpersona.save()        return render(request,'dashboard/test_page.html')请您解释一下为什么我会收到此错误以及如何消除此错误？提前致谢。

Answer 1

改变这一行

 testpersona = TestPersona.objects.get(name__case_exact=persona_name)

到

 testpersona = TestPersona.objects.get(name__name__case_exact=persona_name)

Answer 2

确切和模型字段名称之间应该有2 个下划线。

假设您正在匹配名为persona_name 的字段

elif TestPersonaName.objects.filter(persona_name__iexact=persona_name).exists():

    testpersona = TestPersona.objects.get(persona_name__iexact=persona_name)

iexact 无论大小写敏感，都匹配值。

Answer 3

最后，在这个问题上花了一整天之后，我能够知道我在哪里做错了。

在TestPersona 模型中，有一个字段“name”，它是模型TestPersonaName 的外键。这意味着TestPersonaName 的对象将被分配给TestPersona 的“name”字段。所以答案是：

def TestPageView(request):

    x=PersonaSave(request)

    persona_name = x[0]

    persona_key = x[1]

    persona_key_label=x[2]

    persona_key_value=x[3]

    persona_submit=x[4]

    if(persona_name is None and persona_key is None and persona_key_label is None and persona_key_value is None):

    # Since no paramteres are persent in GET request(i.e Nothing is filled in form), then we will simply render the blank form.

        return render(request, 'dashboard/test_page.html')

 #  Below is the function for updating testPersona . 

    elif TestPersonaName.objects.filter(name__iexact=persona_name).exists():

        testPersonaName_obj = TestPersonaName.objects.filter(name__iexact=persona_name) #Fetching an object from TestPersonaName model where name = persona_name

        testpersonaSet = TestPersona.objects.filter(name=testPersonaName_obj) #Passing testPersonaName_obj to 'name' field of TestPersona model because name is foreign key.

        for testpersona in testPersonaSet: #testPersonaSet is a QuerySet

            if testpersona.key == persona_key: #Checking whether persona with given key is already present or not

         # If TestPersona object with given name and give key is already present then we will update the details instead of making a new object.

                testpersona.label= persona_key_label 

                testpersona.value = persona_key_value

                testpersona.save()

                return render(request,'dashboard/test_page.html')    

#If persona with new name is detected then saving new objects of TestPersonaName and TestPersona object.

    testPersonaName = TestPersonaName(name=persona_name)

    testPersonaName.save() 

    testpersona(name=testPersonaName,key=persona_key,label=persona_key_label

                ,value=persona_key_value)

    testpersona.save()

    return render(request,'dashboard/test_page.html')