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)
