Create a function to return a value from an asynchronous query

Question

I have a AQL query and the query works fine. Instead of printing out the result in the console. How can I get the value(result) of this query into a function ?

1.I hope this question is not too vague

example query

db.query(aqlQuery `
                 LET startVertex = (FOR doc IN spec
                 FILTER doc.serial_no == '"123456abcde"'
                 LIMIT 2
                 RETURN doc
                 )[0]

                FOR v IN 1 ANY startVertex belongs_to
                RETURN v.ip`, {
  bindVar1: 'value',
  bindVar2: 'value',
}).then(function(res) {
  console.log("doc" + res._result);
})

console output :

doc,192.168.72.237

Yury Fedorov · Accepted Answer · 2018-02-26 08:09:57Z

1

You could wrap this code in an async function that returns query results, and use it with await keyword:

async function dbQuery(/* your params */) {
    const res = await db.query(/* your query */);
    return res._result;
}

// usage inside another async function
const result = await dbQuery(/* params */);

answered Feb 26, 2018 at 8:09

Yury Fedorov

15k6 gold badges56 silver badges70 bronze badges

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

5 Comments

cantona_7 Over a year ago

if you dont mind..,can you tell me what you mean by params in this context

cantona_7 Over a year ago

it should me something like this ., dBQuery(res, req) ? Is that right ?

cantona_7 Over a year ago

it throws an Unexpected Identifier error: await dbQuery();

Yury Fedorov Over a year ago

params is whatever parameters you prefer to pass to this function, it is a matter of design. It could be a query string, for example. Regarding the error, you probably didn't use the call inside another async function. Please follow the links in my answer to learn more.

cantona_7 Over a year ago

yes I get it..,I have used nothing for instance..,then I even declared dbQuery(); at the end of the file..still there is an Unexpected Identifier error

Collectives™ on Stack Overflow

Create a function to return a value from an asynchronous query

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related