这是我的服务器上的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')
Following is the error that i am getting.
django.core.exceptions.FieldError: Unsupported lookup 'case_exact' for CharField or join on the field not permitted.
Below are TestPersona and TestPersonaName models.
class TestPersonaName(models.Model):
name = models.CharField(max_length=100,null=True)
def __str__(self):
return self.name
class TestPersona(models.Model):
name = models.ForeignKey('TestPersonaName',null=True)
key = models.CharField(max_length=200,null=True,blank=True)
label = models.CharField(max_length=200,null=True,blank=True)
value = models.CharField(max_length=200,null=True,blank=True)
def __str__(self):
return self.name + " " + self.key
请您解释一下为什么我收到此错误,如何删除此错误?提前致谢 .
3 回答
您应该在确切字段名称和模型字段名称之间使用 2 underscores .
假设您正在匹配名为 persona_name 的字段
iexact
匹配值,无论区分大小写 .改变这一行
至
最后,在这个问题上花了一整天后,我能够知道我在哪里做错了 .
在TestPersona模型中,有一个字段'name',它是建模TestPersonaName的外键 . 这意味着TestPersonaName的对象将被分配到TestPersona的'name'字段 . 所以答案是: