def earmark_list(format, page=0, limit=50): earmarks = schema.Earmark.select(limit=limit, offset=page * limit, order='id') out = apipublish.publish(earmarks, format) if out: return out return render.earmark_list(earmarks, limit)
def earmark_pol_list(pol_id, format, page=0, limit=50): earmarks = db.select(['earmark_sponsor', 'earmark'], what='earmark.*', where='politician_id = $pol_id AND earmark_id=earmark.id', order='final_amt desc', vars=locals()) if not earmarks: # @@TODO: something better here. raise web.notfound out = apipublish.publish(earmarks, format) if out: return out return render.earmark_list(earmarks, limit)
def earmark_pol_list(pol_id, format, page=0, limit=50): earmarks = db.select(['earmark_sponsor', 'earmark'], what='earmark.*', where='politician_id = $pol_id AND earmark_id=earmark.id', order='final_amt desc', vars=locals()).list() for e in earmarks: p = schema.Politician.where(id=pol_id)[0] e.sponsor_name = '%s %s' % (p.title, p.name) if not earmarks: # @@TODO: something better here. raise web.notfound() out = apipublish.publish(earmarks, format) if out: return out return render.earmark_list(earmarks, limit)
def earmark_pol_list(pol_id, format, page=0, limit=50): earmarks = db.select( ['earmark_sponsor', 'earmark'], what='earmark.*', where='politician_id = $pol_id AND earmark_id=earmark.id', order='final_amt desc', vars=locals()).list() for e in earmarks: p = schema.Politician.where(id=pol_id)[0] e.sponsor_name = '%s %s' % (p.title, p.name) if not earmarks: # @@TODO: something better here. raise web.notfound() out = apipublish.publish(earmarks, format) if out: return out return render.earmark_list(earmarks, limit)
def earmark_list(format, page=0, limit=50): earmarks = schema.Earmark.select(limit=limit, offset=page*limit, order='id') out = apipublish.publish(earmarks, format) if out: return out return render.earmark_list(earmarks, limit)