將物件陣列格式化為二維陣列

我有一個物件陣列，我想將其轉換為 react-csv（二維陣列）使用的格式。2D 應該看起來像一個嵌套回圈，類似于

最終結果應該是這樣的

[
  ["Name", "Message", "Column", "configDataType","dbDataType"],
  ["STAGE", "Columns present in source config but not in the database.", "TEST"],
  ["", "", "TEST1"],
  ["", "", "TEST2"],
  ["", "Columns present in database but not in the source config.", ""],
  ["", "Columns with datatype mismatch.", "LAST_NAME", "varchar(50)", "varchar(40)"],
  ["", "", "FIRST_NAME", "varchar(50)", "varchar(40)"],
  ["RAW", "Column sets are identical."],
  ["LAST", "Column sets are identical."],
  ["HIST", "Column sets are identical."],
  ["CORE", "Column sets are identical."],
  ["ADDR", "Column sets are identical."],
  ["CONFIG", "Column sets are identical."],
  ["ACTION", "Column sets are identical."],
]

這是我到目前為止所做的，但我無法獲得預期的結果。請告訴我我缺少什么。

const data = {
  "STAGE": [{
      "infoLevel": "error",
      "message": "Columns present in source config but not in the database.",
      "columns": [],
      "columnsName": [
        "TEST",
        "TEST1",
        "TEST2"
      ],
      "type": "String"
    },
    {
      "infoLevel": "error",
      "message": "Columns present in database but not in the source config.",
      "columns": [],
      "columnsName": [],
      "type": "String"
    },
    {
      "infoLevel": "error",
      "message": "Columns with datatype mismatch.",
      "columns": [{
        "name": "LAST_NAME",
        "configDatatype": "varchar(50)",
        "dbDatatype": "varchar(40)"
      }, {
        "name": "FIRST_NAME",
        "configDatatype": "varchar(50)",
        "dbDatatype": "varchar(40)"
      }],
      "columnsName": [],
      "type": "Table"
    }
  ],
  "RAW": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "LAST": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "HIST": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "CORE": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "ADDR": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "TRAN": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "CONFIG": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "ACTION": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }]
}

const res = _.flattenDeep(Object.keys(data).map(i => {
  return data[i].map(j => {
    return {
      ...j,
      tableName: i
    }
  })
}))

console.log(res.map(i => {
  return [
    i.tableName,
    i.message,
    ...((i.columns.length > 0 ? i.columns : i.columnsName).map(j => typeof j === 'string' ? j : j.name)),
    ..._.compact(((i.columns.length > 0 ? i.columns : i.columnsName).map(j => typeof j === 'string' ? '' : j.configDatatype))),
    ...(((i.columns.length > 0 ? i.columns : i.columnsName).map(j => typeof j === 'string' ? '' : j.dbDatatype)))
  ]
}))

<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.21/lodash.min.js"></script>

uj5u.com熱心網友回復：

為什么不使用舊式命令式代碼？嘗試這個：

const data = {
  "STAGE": [{
      "infoLevel": "error",
      "message": "Columns present in source config but not in the database.",
      "columns": [],
      "columnsName": [
        "TEST",
        "Arun",
        "Abnc"
      ],
      "type": "String"
    },
    {
      "infoLevel": "error",
      "message": "Columns present in database but not in the source config.",
      "columns": [],
      "columnsName": [],
      "type": "String"
    },
    {
      "infoLevel": "error",
      "message": "Columns with datatype mismatch.",
      "columns": [{
        "name": "LAST_NAME",
        "configDatatype": "varchar(50)",
        "dbDatatype": "varchar(40)"
      }, {
        "name": "FIRST_NAME",
        "configDatatype": "varchar(50)",
        "dbDatatype": "varchar(40)"
      }],
      "columnsName": [],
      "type": "Table"
    }
  ],
  "RAW": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "LAST": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "HIST": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "CORE": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "ADDR": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "TRAN": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "CONFIG": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }],
  "ACTION": [{
    "infoLevel": "success",
    "message": "Column sets are identical.",
    "columns": [],
    "columnsName": [],
    "type": "String"
  }]
};

var rows = [];
for (var c1 in data) {
  const list = data[c1];
  for (var i in list) {
    const obj = list[i];
    var c2 = obj.message;
    for (var j in obj.columnsName) {
      rows.push([c1, c2, obj.columnsName[j]]);
      c1 = ""; c2 = "";
    }
    for (var j in obj.columns) {
      const col = obj.columns[j];
      rows.push([c1, c2, col.name, col.configDatatype, col.dbDatatype]);
      c1 = ""; c2 = "";
    }
    if (c2 != "") rows.push([c1, c2]);
    c1 = "";
  }
}

console.log(rows);

標籤：javascript 数组 多维数组 洛达什

上一篇：函式類似于_.getfromlodash但它遍歷陣列中的所有專案而不是指定的索引

下一篇：如何在映射函式中宣告一個常量？