Arangodb array reduce

Question

Given the following:

LET replacements = [
  ["foo", "bar"],
  ["bar", "baz"]
]

LET title = "foo"

// JS CODE
// title = replacements.reduce((acc, r) => r.replace(acc[0], acc[1]), title);
// or
// for (const r of replacements) {
//   title = title.replace(r[0], r[1]);
// }

RETURN title

How is the logic I described with JS possible to implement in aql?

I can't seem to get FOR loops to work without returning something, and LET itself seems not to allow further reassignment.

What is your expected result? You want to return the value 'bar' in this case? — David Thomas
– David Thomas, Commented Oct 26, 2022 at 8:18
The expected result is 'baz', as you'd get after the replacements implemented in JS had been executed — Jesper
– Jesper, Commented Oct 26, 2022 at 10:39
I don't think it's possible to do in pure AQL, you would use Foxx Microservices if you wanted to solve this. LET assignments cannot be changed once made. — David Thomas
– David Thomas, Commented Oct 26, 2022 at 12:25

user594138 · Accepted Answer · 2022-10-27 07:17:01Z

1

This could be a case for a user function.

In arangosh:

127.0.0.1:8529@_system> require("@arangodb/aql/functions").register(
    "MYFUNC::REPLACEEQ", 
    function (replacements, title) {
        return replacements.reduce(
                (t, r) => t.replace(r[0], r[1]),
                title
        );
    }
);

The AQL-Query:

LET replacements = [
  ["foo", "bar"],
  ["bar", "baz"]
]

RETURN MYFUNC::REPLACEEQ(replacements, "foo")
// => ["baz"]

answered Oct 27, 2022 at 7:17

user594138

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Arangodb array reduce

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related