def GET(self):
petitions = db.select(['petition', 'signatory'],
what='petition.id, petition.title, count(signatory.user_id) as signature_count',
where='petition.id = signatory.petition_id',
group='petition.id, petition.title',
order='count(signatory.user_id) desc'
)
return render.petition_list(petitions)
def GET(self):
petitions = db.select(['petition', 'signatory'],
what='petition.id, petition.title, count(signatory.user_id) as signature_count',
where='petition.id = signatory.petition_id and petition.deleted is null',
group='petition.id, petition.title',
order='count(signatory.user_id) desc'
)
msg, msg_type = helpers.get_delete_msg()
return render.petition_list(petitions, msg)
def GET(self):
petitions = db.select(
["petition", "signatory"],
what="petition.id, petition.title, count(signatory.user_id) as signature_count",
where="petition.deleted is null and petition.published is not null "
"and petition.id = signatory.petition_id and signatory.deleted is null",
group="petition.id, petition.title",
order="count(signatory.user_id) desc",
)
msg, msg_type = helpers.get_delete_msg()
return render.petition_list(petitions, msg)
def GET(self):
petitions = db.select(
['petition', 'signatory'],
what=
'petition.id, petition.title, count(signatory.user_id) as signature_count',
where='petition.deleted is null and petition.published is not null '
'and petition.id = signatory.petition_id and signatory.deleted is null',
group='petition.id, petition.title',
order='count(signatory.user_id) desc')
msg, msg_type = helpers.get_delete_msg()
return render.petition_list(petitions, msg)