Skip to content
Snippets Groups Projects
parsedb.py 1.29 KiB
Newer Older
#!/usr/bin/python

import json

datafile = open('fabricademy_data.json','r')

data = json.load(datafile)

projects_list = data['library']['projects']


projects = []

for key in projects_list.keys():
    p = projects_list[key]
    for k in p.keys():
        print('%s = %s' % (k, p[k]))
    print('---')
    project = {
        "id": key,
        "category": p['category'],
        "name": p['name'],
        "created": p['created'],
        "downloaded": p.get('downloaded'),
        "description": p['description'],
        'thumbnail': p['thumbnail'],
        'userAvatar': p['userAvatar'],
        'username': p.get('username',''),
        'userId': p['userId'],
        'downloadsCount': p.get('downloadsCount', 0),
        'commentsCount': p.get('commentsCount',0) , 
        'tags': p.get('tags',{}).values() ,
        'photos':  p.get('photos',{}).values(),
        'files':  p.get('files',{}).values(),
        'comments': p.get('comments',{}).values()
    }
    projects.append(project)

json.dump(projects, open('out_projects.json','w'))


category_list = data['library']['categories']


categories = []

for key in category_list.keys():
    c = category_list[key]
    categories.append({
        "id": c['_id'],
        "label": c['label']
    })

json.dump(categories, open('out_categories.json','w'))