将JSON对象重新映射到其他JSON结构 [英] Remap JSON object to other JSON structure

问题描述

我正在尝试重新映射以下按类别设置格式的JSON结构，然后每个类别可以包含多个位置.位置包含lon/lat和区号:

I'm trying to remap the following JSON structure that is formatted by categories and then per category can contain multiple locations. A location contains a lon/lat and an area code:

{
  "cat1":[
    {"location":{
      "latitude":51.38,
      "longitude":4.34,
      "code":"0873"}
    },
    {"location":{
      "latitude":52.65,
      "longitude":6.74,
      "code":"0109"}
    },
    {"location":{
      "latitude":51.48,
      "longitude":4.33,
      "code":"0748"}
    },
    {"location":{
      "latitude":51.48,
      "longitude":4.33,
      "code":"0109"}
    }
  ],
  "cat2":[
    {"location":{
      "latitude":52.33,
      "longitude":4.32,
      "code":"0873"}
    },
    {"location":{
      "latitude":52.65,
      "longitude":6.74,
      "code":"0109"}
    },
    {"location":{
      "latitude":51.48,
      "longitude":4.33,
      "code":"0728"}
    }
  ],
  "cat3":[
    {"location":{
      "latitude":52.33,
      "longitude":4.32,
      "code":"0873"}
    },
    {"location":{
      "latitude":52.65,
      "longitude":6.74,
      "code":"0109"}
    },
    {"location":{
      "latitude":51.48,
      "longitude":4.33,
      "code":"0758"}
    }
  ]
}

进入以下结构，主要集中在区号上，然后具有其中包含实际位置的类别.

Into the following structure, that is primarily focussed on the areacode, then has the categories with the actual locations in them.

{
  "code":[
    {"0873":[
      {"cat1":[
        {"location":{"latitude":51.38,"longitude":4.34}}
      ]},
      {"cat2":[
        {"location":{"latitude":52.33,"longitude":4.32}}
      ]},
      {"cat3":[
        {"location":{"latitude":52.33,"longitude":4.32}}
      ]}
    ]},

    {"0109":[
      {"cat1":[
        {"location":{"latitude":52.65,"longitude":6.74}},
        {"location":{"latitude":51.48,"longitude":4.33}}
      ]},
      {"cat2":[
        {"location":{"latitude":52.65,"longitude":6.74}}
      ]},
      {"cat3":[
        {"location":{"latitude":52.65,"longitude":6.74}}
      ]}

    ]},
    {"0748":[
      {"cat1":[
        {"location":{"latitude":51.48,"longitude":4.33}}
      ]}
    ]},

    {"0728":[
      {"cat2":[
        {"location":{"latitude":51.48,"longitude":4.33}}
      ]}
    ]},
    {"0758":[
      {"cat3":[
        {"location":{"latitude":51.48,"longitude":4.33}}
      ]}
    ]}

  ]
}

我尝试在Javascript/Node中执行此操作，并且正在寻找一种比手动遍历所有对象并对其进行重组更优雅的方法. 正在调查重定向和障碍物，但找不到解决方法....

I try to do this in Javascript/Node and was looking at a way to do this more elegant than traversing all objects by hand and restructure them. Was looking into reorient and obstruction but can't find a way to get it done....

感谢您的帮助！

我知道上面的片段是从文件读取然后解析为对象的JSON字符串.

I know the pieces above are JSON strings that are read from file and then parsed to an object.

目前我要做的代码(尚未完成，因为我不知道什么是执行remapJson()的最佳方法:

The code I have to do this is currently(its not finished, because I didn't know what would be the best way to do the remapJson():

var fs = require('fs'),
jsonfile = require('jsonfile');

function remapJson(oldData) {
  var newData = {};

  // Do the convertion (loop all keys and values?)


  return newData
}

obj = jsonfile.readFileSync('oldstructure.json');

jsonfile.writeFileSync('newstructure.json', remapJson(obj));

推荐答案

您可以使用迭代和递归的方法来处理哈希表中的结果数组.

You could use an iterative and recursive approach for addressing the result arrays in a hash table.

var data = { cat1: [{ location: { latitude: 51.38, longitude: 4.34, code: "0873" } }, { location: { latitude: 52.65, longitude: 6.74, code: "0109" } }, { location: { latitude: 51.48, longitude: 4.33, code: "0748" } }, { location: { latitude: 51.48, longitude: 4.33, code: "0109" } }], cat2: [{ location: { latitude: 52.33, longitude: 4.32, code: "0873" } }, { location: { latitude: 52.65, longitude: 6.74, code: "0109" } }, { location: { latitude: 51.48, longitude: 4.33, code: "0728" } }], cat3: [{ location: { latitude: 52.33, longitude: 4.32, code: "0873" } }, { location: { latitude: 52.65, longitude: 6.74, code: "0109" } }, { location: { latitude: 51.48, longitude: 4.33, code: "0758" } }] },
    result = { code: [] };

Object.keys(data).forEach(function (key) {
    data[key].forEach(function (a) {
        [a.location.code, key].reduce(function (r, k) {
            var o = {};
            if (!r[k]) {
                r[k] = { _: [] };
                o[k] = r[k]._;
                r._.push(o);
            }
            return r[k];
        }, this)._.push({ location: { latitude: a.location.latitude, longitude: a.location.longitude } });
    }, this);
}, { _: result.code });

console.log(result);

.as-console-wrapper { max-height: 100% !important; top: 0; }

这篇关于将JSON对象重新映射到其他JSON结构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！