提问人:Fabrice 提问时间:3/23/2022 更新时间:3/25/2022 访问量:91
alasql & grouping functions:使用 Javascript 或 AlaSQL 创建生成的对象?
alasql & grouping functions: use Javascript or AlaSQL to create the resulting object?
问:
在输入数据下方:
[
{
"name": "jim",
"color": "blue",
"age": "22"
},
{
"name": "Sam",
"color": "blue",
"age": "33"
},
{
"name": "eddie",
"color": "green",
"age": "77"
}
]
我想要一个使用单个 AlaSQL 查询的结果对象:
{
"jim": {
"color": "blue",
"age": "22"
},
"sam": {
"color": "blue",
"age": "33"
},
"eddie": {
"color": "green",
"age": "77"
}
}
有什么办法可以通过 AlaSQL 查询一次性实现它吗? 这样可以很容易地找到联系信息(例如data[“eddie”].age)
我发现的最接近的方法是:
var res = alasql('SELECT name, ARRAY(_) AS details FROM ? GROUP BY name', [data]);
但我仍然在这种格式下获得一个数组:
[
{
"name": "jim",
"details": [{
"color": "blue",
"age": "22"
}],
},
{
"name": "Sam",
"details": [{
"color": "blue",
"age": "33"
}],
},
{
"name": "eddie",
"details": [{
"color": "green",
"age": "77"
}]
}
]
实现目标的最有效和最有效的方法是什么?
答: 暂无答案
评论