get_or_create 抛出完整性错误 [英] get_or_create throws Integrity Error
问题描述
鉴于 object.get_or_create() 的重点是获取已经存在的对象，我不明白为什么它会为此代码抛出完整性错误:
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('/')
这里是错误:
django.db.utils.IntegrityError IntegrityError: (1062, "Duplicate entry 'user@domain.com' for key 'username_UNIQUE'")
有人知道这是怎么回事吗?
Anyone know what's going on?
推荐答案
发送到 get_or_create 方法中的参数需要完全匹配，否则 django 的 ORM 会尝试创建一个新对象，并且由于将违反主键/唯一列约束，您将收到错误消息.
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.
试试这个:
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('/')
阅读更多关于 get_or_create在这里.defaults= 参数正是您所需要的.
Read more on get_or_create here. The defaults= argument is what you needed.
这篇关于get_or_create 抛出完整性错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
