我很難過，需要有關(guān)我的功能的幫助。我有兩個(gè)表學(xué)生和學(xué)生信息。學(xué)生信息是該學(xué)生的所有監(jiān)護(hù)人信息。我將此數(shù)據(jù)與主學(xué)生表分開，因此您可以根據(jù)需要將任意數(shù)量的監(jiān)護(hù)人添加到具有新記錄的學(xué)生文件中。我得到的錯(cuò)誤如下。無法分配“'1'”：“StudentInformation.studentpsid”必須是“Student”實(shí)例。附件你會(huì)看到我的代碼。學(xué)生信息中的studentpsid是student的外鍵。def ImportStudentGuardian(request): AuthTokenP(request) print("Getting student guardian data from SIS for K-8") #Pulls K-8 Guardians url = "removed for posting" payload = {} token = APIInformation.objects.get(api_name="PowerSchool") key = token.key headers = {'Authorization': 'Bearer {}'.format(key)} response = requests.request("GET", url, headers=headers, data = payload) encode_xml = response.text.encode('utf8') xml_string = ET.fromstring(encode_xml) students = xml_string.findall("student") for student in students: #XML Values psid = student.find("id").text try: mother = student.find("contact").find("mother").text except Exception: mother = "" try: father = student.find("contact").find("father").text except Exception: father = "" if Student.objects.filter(studentpsid=psid).exists(): print("Accessing guardian information.") m = StudentInformation.objects.create(studentpsid=psid,guardian_name = mother, relation = "Mom") <---- Function Fails here print("Record doesn't exist for mom, creating record.") m.save() d= StudentInformation.objects.create(studentpsid=psid,guardian_name = father, relation = "Dad") print("Record doesn't exist for dad, creating record.") d.save() return ("Updated Guardian Information ")
1 回答
交互式愛情
TA貢獻(xiàn)1712條經(jīng)驗(yàn) 獲得超3個(gè)贊
在使用外鍵關(guān)系創(chuàng)建記錄時(shí)，應(yīng)提供相關(guān)表的實(shí)例，以便表可以維護(hù)該特定記錄的關(guān)系。
Student獲取具有給定的表的實(shí)例psid并在創(chuàng)建StudentInformation記錄時(shí)使用它
編輯mother：僅在和father值可用時(shí)包括用于創(chuàng)建記錄的部分。
for student in students:
#XML Values
psid = student.find("id").text
try:
psid_obj = Student.objects.get(studentpsid=psid) #(pk = psid) also works as the field is primary key
try:
mother = student.find("contact").find("mother").text
m = StudentInformation.objects.create(studentpsid=psid_obj,guardian_name = mother, relation = "Mom")
m.save()
except Exception as err1:
print "Error at Mom", str(err1)
try:
father = student.find("contact").find("father").text
d= StudentInformation.objects.create(studentpsid=psid_obj,guardian_name = father, relation = "Dad")
d.save()
except Exception as err2:
print "Error at Dad",str(err2)
except:
print "Student Record Not found"
添加回答
舉報(bào)
0/150
提交
取消