将id键控对象转换为数组

kcwpcxri  于 2021-09-23  发布在  Java
关注(0)|答案(1)|浏览(225)

关闭。这个问题需要详细或明确。它目前不接受答案。
**想改进这个问题吗?**编辑这篇文章,添加细节并澄清问题。

12小时前关门。
改进这个问题
我有一个带有嵌套对象的对象,该对象由它们自己的id标识为其键。我觉得这不是处理angular的合适方法,所以我需要去掉id键,因为每个对象都有自己的id作为其属性。

{
  "1": {
    "id": 1,
    "questionGroup": "Mathematics",
    "questions": {
      "1": {
        "id": 1,
        "questionTitle": "2+2",
        "questionType": "singleChoice",
        "answerOptions": {
          "1": {
            "id": 1,
            "answerOptionText": "4"
          },
          "2": {
            "id": 2,
            "answerOptionText": "3"
          }
        }
      }
    }
  },
  "2": {
    "id": 2,
    "questionGroup": "Geography",
    "questions": {
      "3": {
        "id": 3
      }
    }
  },
  "3": {
    "id": 3,
    "questionGroup": "Philosophy",
    "questions": {
      "4": {
        "id": 4
      }
    }
  }
}

但我需要将其转换为以下内容:

[
  {
    "id": 1,
    "questionGroup": "Mathematics",
    "questions": [
      {
        "id": 1,
        "questionTitle": "2+2",
        "questionType": "singleChoice",
        "answerOptions": [
          {
            "id": 1,
            "answerOptionText": "4"
          },
          {
            "id": 2,
            "answerOptionText": "3"
          }
        ]
      }
    ]
  },
  {
    "id": 2,
    "questionGroup": "Geography",
    "questions": [
      {
        "id": 3
      }
    ]
  },
  {
    "id": 3,
    "questionGroup": "Philosophy",
    "questions": [
      {
        "id": 4
      }
    ]
  }
]

我希望看到答案是使用最现代的javascript方式来处理这个问题,因为我觉得用我以前的方式处理许多嵌套迭代器和条件并不合适。

json_result = [];
db.query(`SELECT ex.id, ex.name, qgrp.id as questionGroupId, qgrp.name as questionGroupName, ans.id as answerOptionId, ans.\`text\` as questionName, ans.question_type as questionType, ansopt.id as answerOptionId, ansopt.display_text as answerOptionText FROM _questionGroup qgrp
    INNER JOIN exam ex 
    ON ex.id = qgrp.examId 
    INNER JOIN question ans 
    ON ans.questionGroupId = qgrp.id 
    INNER JOIN answerOption ansopt 
    ON ansopt.answerOptionId  = ans.id
    AND ex.id = ?;`, [req.params.id], (err, rows, results) => {
        if(!err) {
            var index = {}, questionGroup = {}, question = {};

            rows.forEach(function (row) {
                console.log("ROW: ", row);
                if ( !(row.id in index) ) {
                    index[row.id] = {
                        id: row.id,
                        name: row.name,
                        questionGroup: {}
                    };
                    json_result.push(index[row.id]);
                }
                if( !(row.questionGroupId in questionGroup) ) {
                    questionGroup[row.questionGroupId] = {
                        id: row.questionGroupId,
                        name: row.questionGroupName,
                        question: {}
                    };
                    index[row.id].questionGroup[row.questionGroupId] = questionGroup[row.questionGroupId];
                }
                if( !(row.answerOptionId in question) ) {
                    question[row.answerOptionId] = {
                        id: row.answerOptionId,
                        name: row.questionName,
                        question_type: row.questionType,
                        answerOptions: []
                    }
                }
                question[row.answerOptionId].answerOptions.push({
                    id: row.answerOptionId,
                    name: row.answerOptionText,
                });

                index[row.id].questionGroup[row.questionGroupId].question[row.answerOptionId] = question[row.answerOptionId];
            });

            res.status(200).json(json_result);
        } else {
            res.status(410).json(err);
        }
    }
);
du7egjpx

du7egjpx1#

来自@keith的评论帮助找到了解决方案,该方案即将添加 Object.values(json_result) (参考)响应数据。详情如下:

json_result = [];
db.query(`SELECT ex.id, ex.name, qgrp.id as questionGroupId, qgrp.name as questionGroupName, ans.id as answerOptionId, ans.\`text\` as questionName, ans.question_type as questionType, ansopt.id as answerOptionId, ansopt.display_text as answerOptionText FROM _questionGroup qgrp
    INNER JOIN exam ex 
    ON ex.id = qgrp.examId 
    INNER JOIN question ans 
    ON ans.questionGroupId = qgrp.id 
    INNER JOIN answerOption ansopt 
    ON ansopt.answerOptionId  = ans.id
    AND ex.id = ?;`, [req.params.id], (err, rows, results) => {
        if(!err) {
            var index = {}, questionGroup = {}, question = {};

            rows.forEach(function (row) {
                console.log("ROW: ", row);
                if ( !(row.id in index) ) {
                    index[row.id] = {
                        id: row.id,
                        name: row.name,
                        questionGroup: {}
                    };
                    json_result.push(index[row.id]);
                }
                if( !(row.questionGroupId in questionGroup) ) {
                    questionGroup[row.questionGroupId] = {
                        id: row.questionGroupId,
                        name: row.questionGroupName,
                        question: {}
                    };
                    index[row.id].questionGroup[row.questionGroupId] = questionGroup[row.questionGroupId];
                }
                if( !(row.answerOptionId in question) ) {
                    question[row.answerOptionId] = {
                        id: row.answerOptionId,
                        name: row.questionName,
                        question_type: row.questionType,
                        answerOptions: []
                    }
                }
                question[row.answerOptionId].answerOptions.push({
                    id: row.answerOptionId,
                    name: row.answerOptionText,
                });

                index[row.id].questionGroup[row.questionGroupId].question[row.answerOptionId] = question[row.answerOptionId];
            });

            res.status(200).json(Object.values(json_result));
        } else {
            res.status(410).json(err);
        }
    }
);

相关问题