def GET(self, politician_id, group_id):
votes = db.select(['vote', 'interest_group_bill_support', 'bill'],
where="interest_group_bill_support.bill_id = vote.bill_id AND "
"vote.bill_id = bill.id AND "
"politician_id = $politician_id AND group_id = $group_id",
order='vote = support desc',
vars=locals())
return render.politician_group(votes)
def GET(self, politician_id, group_id):
votes = db.select(['position', 'interest_group_bill_support', 'bill'],
where="interest_group_bill_support.bill_id = position.bill_id AND "
"position.bill_id = bill.id AND "
"politician_id = $politician_id AND group_id = $group_id",
order='vote = support desc',
vars=locals())
pol = schema.Politician.where(id=politician_id)
group = schema.Interest_Group.where(id=group_id)
if not (pol and group):
raise web.notfound()
return render.politician_group(votes, pol[0], group[0].longname)
def GET(self, politician_id, group_id):
votes = db.select(
['position', 'interest_group_bill_support', 'bill'],
where="interest_group_bill_support.bill_id = position.bill_id AND "
"position.bill_id = bill.id AND "
"politician_id = $politician_id AND group_id = $group_id",
order='vote = support desc',
vars=locals())
pol = schema.Politician.where(id=politician_id)
group = schema.Interest_Group.where(id=group_id)
if not (pol and group):
raise web.notfound()
return render.politician_group(votes, pol[0], group[0].longname)
