python 级别联动实现

最新推荐文章于 2024-04-21 09:53:21 发布

我的狗叫乐乐八岁了

最新推荐文章于 2024-04-21 09:53:21 发布

阅读量900

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/Heyll__/article/details/91363980

本文详细介绍了使用Python从数据库中查询系统、节点、任务及API信息的方法，并构建了一个树状结构的数据接口。通过多级联查，实现了数据的高效获取与组织。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

from utils.httputil import Http
from utils.dbQry import MyDbUtil

http = Http()
mydb = MyDbUtil()


def query_interface():
    list = mydb.select_some("systems", "switch", 1)
    nodes = mydb.select_some("node", "switch", 1)
    tasks = mydb.select_some("task", "switch", 1)
    apis = mydb.select_some("apis", "switch", 1)

    if list:
        treelist = []
        for node in list:
            system = {"sys_id": node.get("id"), "sys_name": node.get("name"), "children": []}
            treelist.append(system)

        for tl in treelist:
            if nodes:
                for node in nodes:
                    if tl.get('sys_id') == node.get('systems_id'):
                        node2 = {"node_id": node.get("id"), "node_name": node.get("name"), "children": []}
                        if tasks:
                            for task in tasks:
                                if node.get("id") == task.get('node_id'):
                                    node3 = {"task_id": task.get("id"), "task_name": task.get("name"),
                                             "task_result": task.get("expected"),
                                             "expression": eval(task.get("expression")),
                                             "frequency": task.get("frequency"), "children": []}
                                    node2['children'].append(node3)
                                    if apis:
                                        for api in apis:
                                            if task.get("id") == api.get("task_id"):
                                                node4 = {"api_id": api.get("id"), "api_name": api.get("name"),
                                                         "method": api.get("method"), "url": api.get("url"),
                                                         "params": api.get("params")}
                                                node3['children'].append(node4)
                        tl['children'].append(node2)

        return treelist
    else:
        return None

    # rs = http.doHttp(method=interface.get("method"), url=interface.get("url"), data=json.dumps(interface.get("params")))
    # print("CCC",rs)


if __name__:
    rs = query_interface()