Simple query with arangodb and nodejs

Question

I want to execute a simple query in my database arangodb with nodejs for a login page.

var arango = require('arangojs');
/*---*/
Database = arango.Database;  
db = new Database('http://127.0.0.1:8529');
db.useDatabase('MyDB');
db.useBasicAuth('root', 'root');
/*---*/

//Post Methods
var username;
var passworddb;

//Login method
app.post('/', function (request, response) {

    username = request.body.user.name;

    db.query('FOR u IN User FILTER u.firstname == "'+username+'" RETURN u.password').then(
      cursor => cursor.all()
    ).then(
      key => console.log('key:', key),
      //key => passworddb = key,
      err => console.error('Failed to execute query')
    );

    console.log(passworddb)
});

It's working, but i can't save in my var passworddb the result of the key... I don't undertand... the request is asynchronous in arangodb

Console.write(passworddb) return "undefined" and after console.log('key:', key) return correctly the key... Twice.

My question is : how can i get only the password in arangodb (What is the query for once request) and how to store the value in my var ?

Thank you for your answers.

Aslam Shaik · Accepted Answer · 2020-09-12 10:38:57Z

2

// required package for arango
const arangojs = require('arangojs');

   //sample function
   async function main(){
       DB = new arangojs.Database({ url: <arango_url> });
       DB.useDatabase(<arango_db_name>);
       DB.useBasicAuth(<arango_db_username>, <arango_db_password>);
       const data = await DB.query('RETURN LENGTH(<arango_collection_anme>)')
       console.log("result", data._result)
   }
   main()

answered Sep 12, 2020 at 10:38

Aslam Shaik

1,9971 gold badge13 silver badges11 bronze badges

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

Comments

Lukilas · Accepted Answer · 2017-11-16 12:17:53Z

1

The line console.log(passworddb) gets executed before //key => passworddb = key happens because of the asynchronous request. So by the time you try to log the password, the db response has not arrived yet. The password gets saved correctly in passworddb, you just console.log too soon. You could do

key => {
  passworddb = key;
  console.log(passworddb);
}

to confirm that the assignment works.

answered Nov 16, 2017 at 12:17

Lukilas

1761 silver badge6 bronze badges

Collectives™ on Stack Overflow

Simple query with arangodb and nodejs

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