拿到所有的数据库分类
cursor = connection.cursor()
cursor.execute(f'select id,name_cn,name_en,code from new_db_type order by `position` asc')
ret = [format_types(i) for i in cursor.fetchall()]
for t in ret:
# 根据中间表获取到分类下面的数据库所有数据
cursor.execute(
f'select d.name_en,d.name_cn,d.code,m.type_id,d.show_style,d.document,d.left_nav from new_db_type_middle'
f' m join new_db_list d on d.id=m.db_id where m.type_id={t["id"]} order by `position`')
t['dbs'] = [format_dbs(i) for i in cursor.fetchall()]
cursor.close()
return JsonResponse({'code': 200, 'msg': 'success', 'data': ret})
网友评论