def delete(self, id):
try:
b = Blurb.get(id)
b.destroySelf()
flash("Deleted")
except SQLObjectNotFound:
flash("Delete failed")
util.redirect("/blurbs/list")
def edit(self, id=0, **kw):
form_vals = {}
if id:
try:
b = Blurb.get(id)
form_vals = util.so_to_dict(b)
except SQLObjectNotFound:
pass
form_vals.update(kw)
return dict(blurb_form=blurb_form, form_vals=form_vals, blurb=None)
def save(self, id, **kw):
if id:
try:
b = Blurb.get(id)
b.set(**util.clean_dict(Blurb, kw))
flash("Updated")
except SQLObjectNotFound:
flash("Update Error")
else:
if kw.get("preview"):
kw['show_text'] = publish_parts(kw['text'], writer_name="html")["html_body"]
return self.edit(**kw)
else:
b = Blurb(added_by=identity.current.user, **util.clean_dict(Blurb, kw))
flash("Blurb added")
util.redirect("/blurbs/list")
def index(self, gclid=None):
conn = hub.getConnection()
events = conn.queryAll(
"""
select event.id, event.name, venue.name
from event, venue
where event.venue_id = venue.id
and event.date = CURRENT_DATE
and event.approved is not NULL
order by venue.name
"""
)
blurb_text = publish_parts(Blurb.random(), writer_name="html")["html_body"]
return dict(events=events, blurb=blurb_text)
def list(self):
results = Blurb.select().reversed()
return dict(title="Blurbs", grid=datagrid, data=results)
