我有一个带有两个外键的模型,我想在一行中插入值。 例如,模型为:
from __future__ import unicode_literals
from django.db import models
from cms.models.authUser import AuthUser
from cms.models.masterCmsUserTypes import MasterCmsUserTypes
class MasterCmsUser(models.Model):
userId = models.ForeignKey(AuthUser,db_column='userId')
userTypeId = models.ForeignKey(MasterCmsUserTypes, db_column='userTypeId')
status = models.BooleanField(db_column="status", default=False, help_text="")
isDelete = models.BooleanField(db_column="isDelete", default=False, help_text="")
createdAt = models.DateTimeField(db_column='createdAt', auto_now=True, help_text="")
modifiedAt = models.DateTimeField(db_column='modifiedAt', auto_now=True, help_text="")
idv2 = models.IntegerField(db_column='idV2')
class Meta:
managed = False
db_table = 'master_cms_user'
这是我的观点:
@login_required
def admin_user_add(request):
try:
master_cms_user_type_list =MasterCmsUserTypes.objects.all()
first_name = request.POST.get('firstName')
last_name = request.POST.get('lastName')
password = request.POST.get('password')
username = request.POST.get('username')
confirmPassword = request.POST.get('confirmPassword')
email = request.POST.get('email')
status = request.POST.get('status')
userTypeId = request.POST.get('userType')
if status is None or status == '':
status = False
else:
status = True
staff=False
superUser=False
if password != confirmPassword:
messages.error(request,'Password and Confirm Password must be same')
if request.method =='POST':
authUser = AuthUser(firstName=first_name,lastName=last_name,password=password,username=username,email=email,
isActive=status,isStaff=staff,isSuperuser=superUser)
authUser.save()
messages.success(request, 'Successfully added to the university list')
print authUser.id
authid = int(authUser.id)
# ci= get_object_or_404(AuthUser, id=authUser.id)
# print authid
# myu_admin_user = AuthUser.objects.get(id=authid)
# print myu_admin_user
cmsStatus=True
cmsDelete=False
masterCmsUser = MasterCmsUser(userId=authid,userTypeId=userTypeId,status=cmsStatus,isDelete=cmsDelete)
masterCmsUser.save()
return render(request, 'templates/admin_user_management/admin_user_add.html',{
'master_cms_user_type_list':master_cms_user_type_list
})
except Exception as e:
print e
raise Http404
现在,当我删除froeign键constrain时,值被成功地插入到表中。但是,当我有外键时,它会询问那个有外键绑定的表的实例
是的,这是可能的,您说它要求“例如,该表有外键绑定的实例”意味着您需要外键对象的实例。。您正在尝试赋值。你可以用下面的方法来做
获取如下用户类型
把你的插入查询
相关问题 更多 >
编程相关推荐