def get_partners_huwknd(op_number): """ List of partner mentioning of OP in Huwknd table """ print("get_partners_huwknd()") npartners = 0 partners = [] huwknd_qs = get_huwknd(op_number) if huwknd_qs is None: print("Huwknd does not contain partners for OP %d", op_number) else: nhuwknds = huwknd_qs.count() print("Huwknd has %d entries for OP %s" % (nhuwknds, op_number)) for huwknd in huwknd_qs: mar_date = "%02d/%02d/%04d" % (int(huwknd.hdag), int(huwknd.hmaand), int(huwknd.hjaar)) gebsex = huwknd.gebsex if gebsex == 'm': # OP is man partnersex = 'v' familyname = huwknd.anmhv # familyname wife firstname1 = huwknd.vrn1hv # firstname1 wife firstname2 = huwknd.vrn2hv # firstname2 wife firstname3 = huwknd.vrn3hv # firstname3 wife elif gebsex == 'v': # OP is woman partnersex = 'm' familyname = huwknd.anmhm # familyname husband firstname1 = huwknd.vrn1hm # firstname1 husband firstname2 = huwknd.vrn2hm # firstname2 husband firstname3 = huwknd.vrn3hm # firstname3 husband if familyname is None: familyname = "" if firstname1 is None: firstname1 = "" if firstname2 is None: firstname2 = "" if firstname3 is None: firstname3 = "" fullname = familyname fullname += ", " fullname += firstname1 if firstname2 != "": fullname += " " fullname += firstname2 if firstname3 != "": fullname += " " fullname += firstname3 if gebsex == 'm' or gebsex == 'v': partner = { "mar_date": mar_date, "sex": partnersex, "fullname": fullname } npartners += 1 print("partner:", partner) partners.append(partner) print("Huwknd has %d partner entries for OP %s" % (npartners, op_number)) return partners
def get_marriages_huwknd(op_numstr): print("hsn_manage/views/get_marriages_huwknd:", op_numstr) marriages = [] # get marriage info info from Huwknd huwknd_qs = get_huwknd(op_numstr) if huwknd_qs is not None: for huwknd in huwknd_qs: mar_date = "%02d/%02d/%04d" % (int(huwknd.hdag), int(huwknd.hmaand), int(huwknd.hjaar)) # construct partner info gebsex = huwknd.gebsex if gebsex == 'm': # OP is man partnersex = 'v' familyname = huwknd.anmhv # familyname wife firstname1 = huwknd.vrn1hv # firstname1 wife firstname2 = huwknd.vrn2hv # firstname2 wife firstname3 = huwknd.vrn3hv # firstname3 wife elif gebsex == 'v': # OP is woman partnersex = 'm' familyname = huwknd.anmhm # familyname husband firstname1 = huwknd.vrn1hm # firstname1 husband firstname2 = huwknd.vrn2hm # firstname2 husband firstname3 = huwknd.vrn3hm # firstname3 husband if familyname is None: familyname = "" if firstname1 is None: firstname1 = "" if firstname2 is None: firstname2 = "" if firstname3 is None: firstname3 = "" fullname = familyname fullname += ", " fullname += firstname1 if firstname2 != "": fullname += " " fullname += firstname2 if firstname3 != "": fullname += " " fullname += firstname3 partner = "" if gebsex == 'm' or gebsex == 'v': partner = { "sex": partnersex, "familyname": familyname, "firstname1": firstname1, "firstname2": firstname2, "firstname3": firstname3, "fullname": fullname } print("partner:", partner) mar = {"date": mar_date, "place": huwknd.hplts, "comment": "ingevoerd", "partner": partner} print("marriage:", mar) marriages.append(mar) else: print("Huwknd entry %s does not exist", op_numstr) return marriages