def update_by_id(po):
obj = BaseService.select_by_id(po)
BizUtil.assert_condition(not obj, "id为" + str(po.id) + "的实体不存在")
"""balabala 写你的逻辑 """
po_dict = bean_util.sqlalchemy_obj_to_dict(po)
bean_util.to_obj(obj, **po_dict)
return obj
def remove(**arg_dict):
"""做参数过滤，基础校验等工作"""
obj = bean_util.to_obj(TreeDO, **arg_dict)
res = TreeService.delete_by_id(obj)
TreeService.commit()
if res:
return bean_util.sqlalchemy_obj_to_dict(res)
def edit(**arg_dict):
"""做参数过滤，基础校验等工作"""
obj = bean_util.to_obj(TreeDO, **arg_dict)
BizUtil.check_assert(obj.id, "id")
res = TreeService.edit(obj)
if res:
return bean_util.sqlalchemy_obj_to_dict(res)
def save(**arg_dict):
"""做参数过滤，基础校验等工作"""
obj = bean_util.to_obj(TreeDO, **arg_dict)
obj.leaf = True
res = TreeService.save(obj)
if res:
return bean_util.sqlalchemy_obj_to_dict(res)
def update_by_where(po, where_po):
if not po:
return po
q = BaseService.gen_query(where_po)
"""拼接其他条件"""
po_dict = bean_util.sqlalchemy_obj_to_dict(po)
q.update(**po_dict)
return po
def gen_query(po):
if not po:
return None
where_dict = bean_util.sqlalchemy_obj_to_dict(po)
cls = po.__class__
q = cls.query
if where_dict:
q = q.filter_by(**where_dict)
if po.ids:
field = cls.id
if po.in_field:
field = getattr(cls, po.in_field)
q = q.filter(field.in_(po.ids))
return q
def get(**arg_dict):
res = TreeService.get(**arg_dict)
if res:
return bean_util.sqlalchemy_obj_to_dict(res)