解决方法

我写了一个小的python脚本来将导出的json转换成一个cypher CREATE指令，它应该会创建之前导出的数据库内容。
如果导出的json有额外的属性没有被这个脚本处理，它至少会打印一个“错误”列表，这些错误只是json输入中被忽略的部分，这样用户就可以手动检查。

import argparse
import json

def main(file_path):
    with open(file_path) as my_file:
        
        data = []
        for line in my_file:
            data.append(json.loads(line))
        
        instruction = 'CREATE\n'
        for json_obj in data:
            if json_obj['type'] == 'node':
                node_id = json_obj['id']
                json_obj.pop('id')
                label_clause = ''
                if 'labels' in json_obj:
                    for label in json_obj['labels']:
                        label_clause = label_clause + ':' + label
                    json_obj.pop('labels')
                property_clause = ''
                if 'properties' in json_obj:
                    property_clause += '{  '
                    for key in json_obj['properties']:
                        property_clause += key
                        if isinstance(json_obj['properties'][key], str):
                            property_clause += " : \""
                            property_clause += json_obj['properties'][key]
                            property_clause += "\", "
                        else:
                            property_clause += " : "
                            property_clause += str(json_obj['properties'][key])
                            property_clause += ", "
                        
                    property_clause = property_clause[:-2]
                    property_clause += '}'
                    json_obj.pop('properties')
                instruction += ' (node_{}{}{}),\n'.format(node_id, label_clause, property_clause)
        for json_obj in data:
            if json_obj['type'] == 'relationship':
                relationship_id = json_obj['id']
                json_obj.pop('id')
                from_id = json_obj['start']['id']
                json_obj.pop('start')
                to_id = json_obj['end']['id']
                json_obj.pop('end')
                
                label_clause = ''
                if 'label' in json_obj:
                    label_clause = ':{}'.format(json_obj['label'])
                    json_obj.pop('label')
                
                relation_clause = 'relationship_{}{}'.format(relationship_id, label_clause)
                
                instruction += ' (node_{})-[{}]->(node_{}),\n'.format(from_id, relation_clause, to_id)
        print('ERRORS:\n') # should print anything from the original json which has been ignored by the code above
        for json_obj in data:
            json_obj.pop('type')
            if bool(json_obj):
                print(json_obj)
                print()
        
        print()
        print()
        print()
        print()
        
        
        instruction = instruction[:-2] + ';\n'
        
        with open("instruction.txt", 'w') as out_file:
            out_file.write(instruction)
        print(data)
    

    
if __name__ == '__main__':
    parser = argparse.ArgumentParser(description='input parser')
    parser.add_argument('--file', metavar='path', required=True,
                        help='the path to the exported json file')
    args = parser.parse_args()
    print(args.file)
    main(file_path=args.file)

字符串