Async Nodejs database connection

Question

I want the db query to be completed before the command line moves to next lines to execute.

Here is excerpt of my code:

const express = require('express');
const bodyparser = require('body-parser');
const mysql = require('mysql');
const app = express();
app.use(bodyparser())
var pool = mysql.createPool(
    {
        connectionLimit:40,
        host: <>
        user:<>,
        password: <>,
        database:<>
    }
)

console.log("First Print Command")

let sql = "select * FROM pinfo" 
   pool.getConnection((err,conn1)=>
   {
        if(true)
       {
           conn1.query(sql,(err1,results)=>
           {
               conn1.release()

              console.log("Second print command")

           });
       }
   })

   console.log("Third print command")

const port  = 3001;
app.listen(port, () => {
    console.log('Server is running at port '+port);
  });

This is the output I am getting

First Print Command
Third print command
Server is running at port 3001
Second print command

I want the print command to proceed in order and i have looked into async and promises but couldn't figure out the syntax as it always skipped the command, it would be helpful if you could provide an excerpt of the syntax.

You need to move Third print command within the callback if you want to achieve what you want — Sagar Chilukuri
– Sagar Chilukuri, Commented Mar 14, 2020 at 8:17
yes that is a solution but i have to make nested db connection , i need the data from one query to be accessed in another query and by using callback it would be problematic and i need to print the results outside the db connection. Could you help me with that ? if we can arrange the print order and make the connection terminal to execute the db connection then we can achieve the above issue. — sks123245
– sks123245, Commented Mar 14, 2020 at 8:40
See this answer from earlier today: stackoverflow.com/questions/60678479/…. — jfriend00
– jfriend00, Commented Mar 14, 2020 at 8:43
@sks123245 that is called 'Callback hell' , as Hemanath answer, use Promises and async/await pattern. — karianpour
– karianpour, Commented Mar 14, 2020 at 9:10

Hemanath · Accepted Answer · 2020-03-14 09:00:48Z

you can wait for the query to complete and print the third statement like this,

const express = require('express');
const bodyparser = require('body-parser');
const mysql = require('mysql');
const app = express();
app.use(bodyparser())
var pool = mysql.createPool(
    {
        connectionLimit: 40,
        host,
        user,
        password,
        database,
    }
);

console.log("First Print Command");

async function queryDB() {
    let sql = "select * FROM pinfo";
    return new Promise(function (resolve, reject) {
        pool.getConnection((err, conn1) => {
            if (true) {
                conn1.query(sql, (err1, results) => {
                    conn1.release()
                    console.log("Second print command")
                    resolve(results)
                });
            }
        })
    });
}

async function main() {
    let results = await queryDB();
    console.log("Third print command");
    const port = 3001;
    app.listen(port, () => {
        console.log('Server is running at port ' + port);
    });
}

main();

Collectives™ on Stack Overflow

Async Nodejs database connection

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related