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)