How to get the data of a query in arangojs

Question

Hello I'm using arangojs, created a database, added data to the collection beusers.

Now I want to read the added data. In ArangoDB I can do so using the query

FOR user IN beusers
FILTER user.password == '3670747394' && user.email == '3817128089'
RETURN user

Doing

const user = await usedDB.parse(aql`
        FOR user IN ${usersCol.name}
        FILTER user.password == ${hashedPassword} && user.email == ${hashedEmail}
        RETURN user
`)
console.log(user)

in arangojs I get

{
  error: false,
  code: 200,
  parsed: true,
  collections: [],
  bindVars: [ 'value2', 'value0', 'value1' ],
  ast: [ { type: 'root', subNodes: [Array] } ]
}

The example in the readme got me only so far.

What am I missing? How can I read the data?

gurisko · Accepted Answer · 2021-06-16 08:34:46Z

1

You want to use Database.query() to get a cursor (ArrayCursor) and then you want to return the value in the cursor's result list (for example using ArrayCursor.all()).

So the code would look like this:

const cursor = await usedDB.query(aql`
  FOR user IN ${usersCol.name}
    FILTER user.password == ${hashedPassword} && user.email == ${hashedEmail}
    RETURN user
`);
console.log(await cursor.all()); // returns array of users

answered Jun 16, 2021 at 8:34

gurisko

1,1828 silver badges14 bronze badges

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

Comments

pgalle · Accepted Answer · 2021-04-30 18:12:10Z

0

It seems I just used the wrong method there. Correct would've been:

const user = await db.executeTransaction(
    {
      read: ['beusers'],
    },
    `
      function() {
        // This code will be executed inside ArangoDB!
        const { query } = require("@arangodb");
        return query\`
            FOR user IN ${col.name}
            FILTER user.password == "${stringHash(
              passedUser.password,
            )}" && user.email == "${stringHash(passedUser.email)}"
            RETURN user
          \`.toArray()[0];
      }
    `,
  )

answered Apr 30, 2021 at 18:12

pgalle

3045 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to get the data of a query in arangojs

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related