0
  1. how to create callback functions properly in this case.

  2. how to wait until query executing the result. This is the code snippet:


app.post('/validate', urlencodedParser, function (req, res) {
    var data = [
        {username:req.body.user, password:req.body.pwd}
    ];
    var disp = function (data,res, callback) {
        return callback(data,res);
    }
    console.log(disp(data,res, LoginCheck));
});

var LoginCheck = function (data,res) {
    var dbresult = [];
    var client = new pg.Client(conString);
    client.connect();
    var query = client.query("SELECT * FROM employee_details");
    query.on("row", function (row, result) {
        result.addRow(row);
    });
    query.on("end", function (result) {      
        dbresult=result.rows;
        console.log(dbresult);
        return dbresult;        
    });
}                                              

1 Answer 1

1

You need only one callback function

app.post('/validate', urlencodedParser, function (req, res) {
  var data = [
  {username:req.body.user, password:req.body.pwd}
  ];

 /* var disp = function (data,res, callback) {
    return callback(data,res,callback2);
  }
  console.log(disp(data,res, LoginCheck));
  */

  LoginCheck(data,res, function(result){

    if(result){

      //do whatever you want

      console.log(result)

    }

  })


});

var LoginCheck = function (data,res,callback2) {
  var dbresult = [];
  var client = new pg.Client(conString);
  client.connect();
  var query = client.query("SELECT * FROM employee_details");
  query.on("row", function (row, result) {
    result.addRow(row);
  });
  query.on("end", function (result) {

    dbresult=result.rows;
    console.log(dbresult);
    return callback2(dbresult);

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

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.