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-25T11:08:38.757

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 '20 at 11:08

answered Jun 25 '20 at 10:44

mangesh

419
4
16

This is giving me an error SyntaxError: await is only valid in async function... But I have declared function with async keyword – Vipendra Singh Jun 25 '20 at 11:00
updated. async was needed at `connection.connect( async function(err, conn) {` – mangesh Jun 25 '20 at 11:03
Still giving me the same issue – Vipendra Singh Jun 25 '20 at 11:06
Please try now. – mangesh Jun 25 '20 at 11:08
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? – Vipendra Singh Jun 25 '20 at 11:19
I do not have much idea about Azure functions. Will have to look into it. – mangesh Jun 25 '20 at 11:21

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

1 Answers1