将json自动处理为具有不同结构的对象

Question

我有一个巨大的JSON文件。它不在正确的结构中，我无法控制结构。它是基于时间戳的来自一组路由器的数据。我试图创建一个对象结构，它将给定路由器的所有信息与时间戳等路由器对象组合成一个数组。 @quodlibetor让我接近这个很有帮助。我也想自动从json中名称val对的名称中命名对象的属性。

我的目的是自动调用json文件中名称的属性，并将其重构为一个看起来像这样的对象（我对这个结构提出建议，这似乎是最有组织的方式） 。

这是我想要的结构：

{ 
     "Router": [ 
      { 
       "routerName": "RouterID1", 
       "TimeStamp": [ 
        "2012/01/01 06:00:00", 
        "2013/01/01 06:00:00", 
        "2014/01/01 06:00:00" 
       ], 
       "OutputBITS": [ 
        "23235", 
        "29903", 
        "22103" 
       ], 
       "InputBITS": [ 
        "23235", 
        "29903", 
        "22103" 
       ] 
      } 
     ] 
    } 

虽然他们试图创建一个结构，我越来越接近，但没有成交：

{ 
    "RouterID1": { 
     "timeStamp": [ 
      { 
       "timeStamp": "2012/01/01 06:00:00" 
      }, 
      { 
       "timeStamp": "2013/01/01 06:00:00" 
      }, 
      { 
       "timeStamp": "2014/01/01 06:00:00" 
      } 
     ], 
     "OutputBITS": [ 
      { 
       "OutputBITS": "23235" 
      }, 
      { 
       "OutputBITS": "23235" 
      }, 
      { 
       "OutputBITS": "23235" 
      } 
     ], 
     "InputBITS": [ 
      { 
       "InputBITS": "29903" 
      }, 
      { 
       "InputBITS": "29903" 
      }, 
      { 
       "InputBITS": "29903" 
      } 
     ] 
    } 
} 

ORIGINAL JSON：

json = [ 
     { 
       "Router": "RouterID1", 
       "TimeStamp": "2012/01/01 06:00:00", 
       "OutputBITS": "23235", 
       "InputBITS": "29903" 
     }, 
      { 
       "Router": "RouterID1", 
       "TimeStamp": "2013/01/01 06:00:00", 
       "OutputBITS": "23235", 
       "InputBITS": "29903" 
     }, 
      { 
       "Router": "RouterID1", 
       "TimeStamp": "2014/01/01 06:00:00", 
       "OutputBITS": "23235", 
       "InputBITS": "29903" 
     }, 
     { 
       "Router": "RouterID3", 
       "TimeStamp": "2012/01/01 06:05:00", 
       "OutputBITS": "21235", 
       "InputBITS": "22103" 
     }, 
     { 
      "Router": "RouterID3", 
      "TimeStamp": "2012/01/01 06:05:00", 
      "OutputBITS": "21235", 
      "InputBITS": "22103" 
     }, 
     { 
      "Router": "RouterID4", 
      "TimeStamp": "2012/01/01 06:05:00", 
      "OutputBITS": "21235", 
      "InputBITS": "22103" 
     }, 
     { 
      "Router": "RouterID4", 
      "TimeStamp": "2012/01/01 06:05:00", 
      "OutputBITS": "21235", 
      "InputBITS": "22103" 
     } 
     ]; 

CODE：

// Create routers object  
    var routers = {}; 


     for (var i=0;i<json.length;i++){ 
     var router_name = json[i].Router; 
     router_name = (router_name.replace(/-/g, "")); //take hyphen out or router name 

     if (!routers[router_name]){ 
      // add properties to the router object thanks to @@quodlibetor 

      // instead of using timeStamp is something like json[i] or json.[name] or some 
      // way to reference each json property and not have to type it in? 

      routers[router_name] = { timeStamp : [], OutputBITS : [], InputBITS : [] }; 
     } 

       routers[router_name].timeStamp.push({ 
        timeStamp : json[i].TimeStamp 
       }); 
       routers[router_name].OutputBITS.push({ 
        OutputBITS : json[i].OutputBITS 
       }); 
       routers[router_name].InputBITS.push({ 
        InputBITS : json[i].InputBITS 
       }); 
    }; 

    console.log(routers); 
    }); 
    </script> 

Answer 1

这里是你需要的代码：

var router = {router: []}, i, j, k, l, inArray, routerName, thisRouter; 

for(i=0,j=json.length;i<j;++i) { 
    inArray = false; 

    routerName = json[i].Router; 

    for(k=0,l=router.router.length;k<l;++k) { 
     if(router.router[k].name === routerName) { 
      inArray = true; --k; l = k; 
     } 
    } 

    if(inArray === true) { 
     router.router[k].TimeStamp.push(json[i].TimeStamp); 
     router.router[k].OutputBITS.push(json[i].OutputBITS); 
     router.router[k].InputBITS.push(json[i].InputBITS); 
    } else { 
     thisRouter = {name: routerName, TimeStamp: [json[i].TimeStamp], OutputBITS: [json[i].OutputBITS], InputBITS: [json[i].InputBITS]}; 

     router.router.push(thisRouter); 
    } 
} 

console.log(router);