How to call a javascript function inside another function in node js

Question

I have a file index.js as below. Where I am trying to call a async function getConn in other function createThumbnails. But I am getting the error as "failed to connect to DEDC: 1433 - self signed certificate" in the catch block.

const sharp = require('sharp');
const sql = require('mssql')

// CONNECTION CONFIGURATION OF BASE DB
async function getConn() {
    try {
        const config = {
            user: 'sa_user',
            password: '*******',
            server: 'DEDC',
            database: 'DEMO_BASE'
        }
        const pool = await new sql.ConnectionPool(config)
        const req=await pool.connect()
        const conn = await req.request()
        return conn;
    } catch (err) {
        return err;
    }
};


const createThumbnails = async() => {
    try{
        var conn = await getConn();
        const query = `exec DBBASE.get_client_info`
        var clientusers = await conn.query(query);
    } catch (err) {
        return err;
    }
}


createThumbnails()

How do I exactly call the function getConn inside createThumbnails. Please help. Thanks in advance

Don't name it the same?

Jeremy Thille
– Jeremy Thille

2021-06-24 12:14:09 +00:00
Commented Jun 24, 2021 at 12:14 — Jeremy Thille
– Jeremy Thille, Commented Jun 24, 2021 at 12:14
Name your variable var getConn something else.

James
– James

2021-06-24 12:14:22 +00:00
Commented Jun 24, 2021 at 12:14 — James
– James, Commented Jun 24, 2021 at 12:14

vanowm · Accepted Answer · 2021-06-24 12:13:28Z

1

It's because you are using variable with the same name as the function.

Try different name:

var conn = await getConn();
const query = `exec DBBASE.get_client_info`
var clientusers = await conn.query(query);

answered Jun 24, 2021 at 12:13

vanowm

10.4k2 gold badges29 silver badges50 bronze badges

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

3 Comments

Sai sri Over a year ago

I changed my variable to "conn". Now I am getting the error as "conn.query is not a function"

vanowm Over a year ago

Well, that's different issue, since your getConn() can return either req.request() or err, so you'd need check for that.

Sai sri Over a year ago

Ya I am getting the error as "failed to connect to DEDC: 1433 - self signed certificate"

hgb123 · Accepted Answer · 2021-06-24 12:21:24Z

1

You encounter what called hoisting. Kyle Simpson has a great explaination on this topic

var getConn = await getConn();

which means getConn will be initialized first, before assignment, which equivalents to

var getConn // initialized
getConn = await getConn() // assignment

Then turned out that you got the error

Solution here is to store it in a different variable name, like

var conn = await getConn();

async function getConn() {
  return {
    query: async () => {
      console.log("query called");
    },
  };
}

const createThumbnails = async () => {
  try {
    var conn = await getConn();
    const query = `exec DBBASE.get_client_info`;
    var clientusers = await conn.query(query);
  } catch (err) {
    console.log(err);
  }
};

createThumbnails();

edited Jun 24, 2021 at 12:21

answered Jun 24, 2021 at 12:18

hgb123

14.9k3 gold badges24 silver badges43 bronze badges

3 Comments

Sai sri Over a year ago

I changed my code. Now I am getting "conn.query is not a function"

hgb123 Over a year ago

@Saisri I think now it should be a problem in the result returned in getConn function itself. Please log the value before return to see what conn is

Sai sri Over a year ago

Ya it is returning the error as "failed to connect to DEDC: 1433 - self signed certificate"

Sai sri · Accepted Answer · 2021-06-24 12:35:25Z

0

We need to use trustServerCertificate: true in DB configuration i.e in const config

answered Jun 24, 2021 at 12:35

Sai sri

5431 gold badge13 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to call a javascript function inside another function in node js

3 Answers 3

3 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related