关闭。这个问题需要详细或明确。它目前不接受答案。
**想改进这个问题吗?**编辑这篇文章,添加细节并澄清问题。
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);
}
}
);
1条答案
按热度按时间du7egjpx1#
来自@keith的评论帮助找到了解决方案,该方案即将添加
Object.values(json_result)
(参考)响应数据。详情如下: