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
