get_or_create抛出完整性错误 [英] get_or_create throws Integrity Error

问题描述

假设object.get_or_create（）的整体点是获取对象，如果它已经存在，我不明白为什么它会为此代码抛出一个完整性错误：

pre> class UserAdd（TemplateView）：

def post（self，request，* args，** kwargs）：
context = self.get_context_data （* args，** kwargs）
form = UserAddForm（request.POST）
如果form.is_valid（）：
first_name = form.cleaned_data ['first_name']
last_name = form.cleaned_data ['last_name']
myemail = form.cleaned_data ['email']
mypass = form.cleaned_data ['password']
如果myemail和mypass：
myuser，created = User.objects.get_or_create（email = myemail，username = myemail，first_name = first_name，last_name = last_name）
如果创建：
myuser.set_password（mypass）
return HttpResponseRedirect '/'）


这是错误：

  django.db.utils.IntegrityError IntegrityError：（1062，重复条目[e-mail]用于密钥username_UNIQUE）
 
解决方案
发送到 get_or_create 方法的参数需要完全匹配，否则django的ORM将尝试创建一个新对象，并且由于主键/唯一列约束将是
 
 
 
尝试这样：
 如果form.is_valid（）：
 first_name = form.cleaned_data ['first_name'] 
 last_name = form.cleaned_data ['last_name'] 
 myemail = form.cleaned_data ['email'] 
 mypass = form.cleaned_data ['password'] 
如果myemail和mypass：
 myuser，created = User.objects.get_or_create（email = myemail，defaults = {'username'：myemail，' first_name'：first_name，'last_name'：last_name}）
如果cre ated：
 myuser.set_password（mypass）
 
返回HttpResponseRedirect（'/'）
  
详细了解  get_or_create 这里。  defaults = 参数是您需要的。 
 
Given that the whole point of object.get_or_create() is to get the object if it already exists, I fail to see why it's throwing an integrity error for this code:
class UserAdd(TemplateView):

def post(self, request, *args, **kwargs):
    context = self.get_context_data(*args, **kwargs)
    form = UserAddForm(request.POST)
    if form.is_valid():
        first_name = form.cleaned_data['first_name']
        last_name = form.cleaned_data['last_name']
        myemail = form.cleaned_data['email']
        mypass = form.cleaned_data['password']
        if myemail and mypass:
            myuser,created = User.objects.get_or_create(email=myemail, username=myemail, first_name=first_name, last_name=last_name)
            if created:
                myuser.set_password(mypass)
    return HttpResponseRedirect('/')
Here is the error:
django.db.utils.IntegrityError IntegrityError: (1062, "Duplicate entry '[e-mail]' for key 'username_UNIQUE'")
Anyone know what's going on?
解决方案
The parameters sent into the get_or_create method need to match exactly, or django's ORM would try to create a new object, and since a primary key/unique column constraint would be violated, you are getting the error.

Try this:
if form.is_valid():
    first_name = form.cleaned_data['first_name']
    last_name = form.cleaned_data['last_name']
    myemail = form.cleaned_data['email']
    mypass = form.cleaned_data['password']
    if myemail and mypass:
        myuser,created = User.objects.get_or_create(email=myemail, defaults = {'username': myemail, 'first_name': first_name, 'last_name': last_name})
        if created:
            myuser.set_password(mypass)

return HttpResponseRedirect('/')
Read more on get_or_create here. The defaults= argument is what you needed. 

                        
这篇关于get_or_create抛出完整性错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！