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)