alasql & grouping functions:使用 Javascript 或 AlaSQL 创建生成的对象?

alasql & grouping functions: use Javascript or AlaSQL to create the resulting object?

提问人:Fabrice 提问时间:3/23/2022 更新时间:3/25/2022 访问量:91

问:

在输入数据下方:

[
        {
            "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"
        }]
    }
]

实现目标的最有效和最有效的方法是什么?

JavaScript AlaSQL

评论


答: 暂无答案