在AQL中组合文档列表？(Combining a list of documents in AQL?)

在AQL中组合文档列表？(Combining a list of documents in AQL?)

我有一份文件清单，并希望将它们合并为一个文件。 Arango的文档说你可以合并两个这样的文件：

arangosh [EC]> db._query('RETURN MERGE({foo: "bar"}, {fizz: "buzz"})', {}).toArray() [ { "foo" : "bar", "fizz" : "buzz" } ]

但合并功能不接受列表：

arangosh [EC]> db._query('RETURN MERGE([{foo: "bar"}, {fizz: "buzz"}])', {}).toArray() JavaScript exception in file '/usr/share/arangodb/js/client/modules/org/arangodb/arangosh.js' at 104,11: [ArangoError 1541: invalid number of arguments for function 'MERGE()', expected number of arguments: minimum: 2, maximum: 65536 (while parsing)] ! throw new ArangoError(requestResult);

如何在AQL中将文档组合在一起？

I have a list of documents and would like to combine them into a single document. The documentation for Arango says you can merge two documents like this:

arangosh [EC]> db._query('RETURN MERGE({foo: "bar"}, {fizz: "buzz"})', {}).toArray() [ { "foo" : "bar", "fizz" : "buzz" } ]

But the merge function does not accept lists:

arangosh [EC]> db._query('RETURN MERGE([{foo: "bar"}, {fizz: "buzz"}])', {}).toArray() JavaScript exception in file '/usr/share/arangodb/js/client/modules/org/arangodb/arangosh.js' at 104,11: [ArangoError 1541: invalid number of arguments for function 'MERGE()', expected number of arguments: minimum: 2, maximum: 65536 (while parsing)] ! throw new ArangoError(requestResult);

How do I combine documents together in AQL?

最满意答案

我认为可以使用APPLY()来完成。

APPLY()将函数名称作为其第一个参数。 第二个参数是此函数的参数数组。 然后它将调用该函数并使数组元素成为单独的调用参数：

RETURN APPLY("merge", [{foo: "bar"}, {fizz: "buzz"})

I think it can be done using APPLY().

APPLY() takes a function name as its first parameter. The second parameter is an array of parameters for this function. It will then call the function and make the array elements individual call parameters:

RETURN APPLY("merge", [{foo: "bar"}, {fizz: "buzz"})