使用属于某个paren的数组格式化为json

Question

我在数据库中有一组行的结果集，这些行都通过父子关系相互关联

每一行都表示为objectid、id、parent、child、name、level，因此当我从程序中的数据库中读取一个示例时，它看起来是这样的

Organization1
Component1
Department1
Sections1
Sections2
Department2
Sections3
Component2
Department3
Sections4
Sections5
Department4
Sections6

组织有许多部门，部门有许多组件，组件有许多部分

到目前为止，我的代码看起来是这样的，但我需要将其转换为json格式，json格式必须如下所示

    for v in result:
        level = v[5]
        child = v[3]
        parent = v[2]
        if level == 0:
            OrgDic['InstID'] = v[4]
            OrgDic['Child'] = v[3]
            OrgDic['Parent'] = v[2]
            Organizations.append(InstDic)
            OrgDic = {}
        if level == 1:
            ComponentsDic['CollegeID'] = v[4]
            ComponentsDic['Child'] = v[3]
            ComponentsDic['Parent'] = v[2]
            Components.append(CollegeDic)
            ComponentsDic = {}
        if level == 2:
            DepartmentDic['DepartmentID'] = v[4]
            DepartmentDic['Child'] = v[3]
            DepartmentDic['Parent'] = v[2]
            Departments.append(DepartmentDic)
            DepartmentDic = {}
        if level == 3:
            SectionDic['SubjectID'] = v[4]
            SectionDic['Child'] = v[3]
            SectionDic['Parent'] = v[2]
            Sections.append(SubjectDic)
            SectionDic = {}


    for w in :
        print w['Organization']
        for x in Components:
            if w['Child'] == x['Parent']:
                print x['Components']
                for y in Departments:
                    if x['Child'] == y['Parent']:
                        print y['Deparments'] 
                        for z in Sections:
                            if y['Child'] == z['Parent']:
                                print z['Sections']

JSON格式

{
"Eff_Date": "08/02/2013",
"Tree":
[       
        {
            "OrganizationID": "Organization1",
            "Components":
            [
                {"ComponentID": "Component1",
                "Departments": 
                [
                    {"DepartmentID": "Dep1",
                    "Sections":
                    [
                        {"SectionID": "Section1"},
                        {"SectionID": "Section2"}
                    ]},
                    {"DepartmentID": "Dep2",
                    "Sections":
                    [
                        {"SectionID": "Section3"}
                    ]}
                ]}

]
}

Answer 1

基本上，您所要做的就是在第一个代码段之后转储json（假设代码段确实正确地创建了您公开的树，我没有彻底检查它，但它看起来是一致的）：

import json
print json.dumps({"Eff_Date": "08/02/2013", "Tree":Organizations})

还有塔达！你知道吗

Answer 2

我可以用下面的方法来做

data[]
data.append([-1, 0 ,"name1", 0])
data.append([0,1, "name2", 1])
data.append([1, 2, "name3", 1])
data.append([2 ,3, "name4", 2])
data.append([2 ,4, "name5" ,2])
data.append([1 ,5, "name6", 2])
data.append([5, 6, "name7", 3])
data.append([5, 7, "name8",1])
data.append([5, 7, "name9",2])

def listToDict(input):
    root = {}
    lookup = {}
    for parent_id, id, name, attr in input:
        if parent_id == -1: 
            root['name'] = name;
            lookup[id] = root
        else:
            node = {'name': name}
            lookup[parent_id].setdefault('children', []).append(node)
            lookup[id] = node
    return root

result = listToDict(data)
print result
print json.dumps(result)

在我的例子中，我的数据是来自一个数据库的结果集，所以我必须按如下方式循环遍历它

    for v in result:
        values = [v[2], v[3], v[4], v[5]]
        pc.append(values)