def iterateVoter(sitting_dict, text, vote_id, decision):
for legislator_uid in ly_common.GetLegislatorIdList(
c,
text.strip().split('\n')[0]):
legislator_id = ly_common.GetLegislatorDetailId(
c, legislator_uid, sitting_dict["ad"])
vote_common.upsert_vote_legislator_vote(c, legislator_id, vote_id,
decision)
def LiterateVoter(sitting_dict, text, vote_id, decision):
firstName = ''
for name in text.split():
#--> 兩個字的立委中文名字中間有空白
if len(name) < 2 and firstName == '':
firstName = name
continue
if len(name) < 2 and firstName != '':
name = firstName + name
firstName = ''
#<--
legislator_id = ly_common.GetLegislatorId(c, name)
if legislator_id:
legislator_id = ly_common.GetLegislatorDetailId(c, legislator_id, sitting_dict["ad"])
vote_common.upsert_vote_legislator_vote(c, legislator_id, vote_id, decision)
else:
break
'6': 2008,
'7': 2012,
'8': 2016,
'9': 2020
}
for legislator in dict_list:
legislator['uid'] = get_or_create_uid(legislator)
legislator_origin = legislator.copy()
json_output.append(legislator_origin)
legislator = ly_common.normalize_person(legislator)
legislator['elected_party'] = legislator.get('elected_party',
legislator['party'])
Legislator(legislator)
LegislatorDetail(legislator['uid'], legislator,
ideal_term_end_year[str(legislator['ad'])])
legislator_id = ly_common.GetLegislatorDetailId(c, legislator['uid'],
legislator['ad'])
if legislator.has_key('committees'):
Committees(legislator['committees'])
for committee in legislator['committees']:
Legislator_Committees(legislator_id, committee)
else:
f.write('no committees!!, uid: %s, name: %s, ad: %s\n' %
(legislator["uid"], legislator["name"], legislator["ad"]))
f.close()
conn.commit()
party_change = json.load(open('legislator/party_change.json'))
for instance in party_change:
c.execute(
'''
UPDATE legislator_legislatordetail
SET party = %(party)s
bill['date'] = ROC2AD(bill[u'提案日期'])
for motion in bill['motions']:
motion['date'] = ROC2AD(motion[u'日期'])
for_search = bill.get(u'主題', []) + bill.get(u'類別', [])
bill['for_search'] = ' '.join(for_search) + bill.get(u'提案名稱', '')
# bill['links'][u'關係文書'] = 'http://lis.ly.gov.tw/lgcgi/lgmeetimage?' + bill['links'][u'關係文書'].split('^')[-1]
bill['data'] = json.dumps(bill)
Bill(bill)
# legislator_bill
for category, role in [(u'主提案', 'sponsor'),
(u'連署提案', 'cosponsor')]:
for legislator in bill.get(category, []):
legislator = ly_common.normalize_person_name(legislator)
uid = ly_common.GetLegislatorId(c, legislator)
if uid:
legislator_id = ly_common.GetLegislatorDetailId(
c, uid, bill['ad'])
if legislator_id:
LegislatorBill(legislator_id, bill['uid'], role)
elif not re.search(u'(黨團|聯盟)', legislator):
raise
except:
print 'bill id: %s, ad: %d' % (
bill['uid'],
bill['ad'],
)
print '%s not legislator?' % legislator
continue
conn.commit()
print 'bills done'
c.execute('''
'3': 1999,
'4': 2002,
'5': 2005,
'6': 2008,
'7': 2012,
'8': 2016,
'9': 2020
}
for legislator in dict_list:
legislator = ly_common.normalize_person(legislator)
Legislator(legislator)
for term in legislator["each_term"]:
term = ly_common.normalize_person(term)
LegislatorDetail(legislator["uid"], term,
ideal_term_end_year[str(term["ad"])])
legislator_id = ly_common.GetLegislatorDetailId(
c, legislator["uid"], term["ad"])
if term.has_key("committees"):
Committees(term["committees"])
for committee in term["committees"]:
Legislator_Committees(legislator_id, committee)
else:
f.write('no committees!!, uid: %s, name: %s, ad: %s\n' %
(legislator["uid"], term["name"], term["ad"]))
f.close()
conn.commit()
party_change = json.load(open('legislator/party_change.json'))
for instance in party_change:
c.execute(
'''
UPDATE legislator_legislatordetail
SET party = %(party)s