问题:如何返回树结构的数据?
方法:
amodules = self.db.query(
AModule.id, AModule.name, AModule.parent_id).filter(
AModule.is_delete == 0).all()
modules = []
module_dict = {}
for m in ana_modules:
m_dict = {'id': m.id, 'name': m.name}
# 一级模块
if not m.parent_id:
modules.append(m_dict)
continue
# 将其它模块转换成dict
if m.parent_id in module_dict:
module_dict[m.parent_id].append(m_dict)
else:
module_dict[m.parent_id] = [m_dict]
for m in modules:
if m['id'] not in module_dict:
continue
m['children'] = module_dict[m['id']]
for cm in m['children']:
if cm['id'] not in module_dict:
continue
cm['children'] = module_dict[cm['id']]