How to use await/async properly in Nodejs Azure Function App

Question

I am trying to write a code to connect with snowflake inside the azure function app using nodejs stack. Here is the code I have writtern.

async function af2snf() 
{
console.log("starting connection");
var snowflake = require('snowflake-sdk');
// Create a Connection object that we can use later to connect.
console.log("prep conn");
var connection = snowflake.createConnection( {
    account: "myaccountname",
    username: "myusername",
    password: "mypass",
    database: "dbname",
    schema: "schemaname"
    }
    );
console.log("making connection");

var conn_id = connection.connect( 
        function(err, conn) {
            if (err) {
                console.error('Unable to connect: ' + err.message);
                } 
            else {
                console.log('Successfully connected to Snowflake.');
                // Optional: store the connection ID.
                connection_ID = conn.getId();
                }
            }
        )
return conn_id.getId();
}

console.log("outside fucntion");
console.log(af2snf());
console.log("executed fucntion");

The output I am getting is :

outside fucntion
starting connection
prep conn
making conn
Promise { <pending> }
executed fucntion
Successfully connected to Snowflake.

But What I need is :

outside fucntion
starting connection
prep conn
making conn
Successfully connected to Snowflake.
Promise { <pending> }
executed fucntion

I am very new to nodejs. Please help me out on this

mangesh · Accepted Answer · 2020-06-25 11:08:38Z

1

af2nsf needs to return a promise :

async function af2snf() {
  return new Promise((resolve,reject)=>{
   console.log("starting connection");
   var snowflake = require('snowflake-sdk');

   // Create a Connection object that we can use later to connect.
   console.log("prep conn");
   var connection = snowflake.createConnection( {
    account: "myaccountname",
    username: "myusername",
    password: "mypass",
    database: "dbname",
    schema: "schemaname"
    });
   console.log("making connection");

   connection.connect( async function(err, conn) {
            if (err) {
                console.error('Unable to connect: ' + err.message);
                return reject(err);
            } 
            else {
                console.log('Successfully connected to Snowflake.');
                // Optional: store the connection ID.
                var conn_id = await conn.getId();
                return resolve(conn_id);
             }
      })
  });
}

console.log("outside fucntion");
af2snf().then(conn_id=>{
   console.log(conn_id);
   console.log("executed fucntion");
}).catch(err=>{
   console.error(err);
});

edited Jun 25, 2020 at 11:08

answered Jun 25, 2020 at 10:44

mangesh

52110 silver badges28 bronze badges

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

6 Comments

Vipendra Singh Over a year ago

This is giving me an error SyntaxError: await is only valid in async function... But I have declared function with async keyword

mangesh Over a year ago

updated. async was needed at connection.connect( async function(err, conn) {

Vipendra Singh Over a year ago

Still giving me the same issue

mangesh Over a year ago

Please try now.

Vipendra Singh Over a year ago

yeah it helped. Actually I wa trying to replicate the Azure Function in local to trigger the async function. But now since we did some modification in function calling how we can replicate same in Azure function. Any Idea?

|

Collectives™ on Stack Overflow

How to use await/async properly in Nodejs Azure Function App

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related