def delete(cls, id_): ses = db.get_session() q = ses.query(cls) q = q.filter_by(id=id_) obj = q.one() if not obj: raise Exception ses.delete(obj) ses.flush()
def on_get(self, req, resp): session = db.get_session() q = session.query(models.Category) rows = q.all() resp.json = {"categories": map(dict, rows)}
def on_get(self, req, resp, category_id): session = db.get_session() q = session.query(models.Category) q = q.filter_by(id=category_id) obj = q.one() resp.json = dict(obj)
def create(cls, values): session = get_session() inst = cls(**values) cls.save(inst, session) return inst