def delete(self, argument): try: noautoflushsession.query(Product).filter( Product.ProductID == int(argument)).delete() noautoflushsession.commit() noautoflushsession.close() self.write_json("success", code=1) except Exception, e: print e self.write_json("failed", code=0)
def get(self): ret = noautoflushsession.query(Product) for i, x in enumerate(ret): # 根据ProductTypeID查询每个类型的名称【有个坑,需要关闭sqlalchemy自动刷新】 q_name = "" q_name = noautoflushsession.query(ProductType).filter_by( ProductTypeID=x.ProductType).first() if q_name: q_name = q_name.ProductTypeName ret[i].ProductType = q_name noautoflushsession.close() self.render('admin_product.html', Product_list=ret)