How to append two results of query in one json in Node.js

Question

Following is my code of in node.js i would like to know how to append two results of query in one json and send the json in response.

        router.get("/get-meta", function(req, res, next){

    connection.query("select id, country_name from country", function (error, results) {

        if (error) res.json({"status": "failed", "message": error.message});
        else res.send(JSON.stringify({ results }));
    });
    connection.query("select id, currency from currency", function (error, results2) {

        if (error) res.json({"status": "failed", "message": error.message});
        else res.send(JSON.stringify({ results2 }));
    });
});

dev07 · Accepted Answer · 2017-05-27 10:57:00Z

3

use async.parallel to send parallel requests.the result of async.parallel will be an array of results (which will solve your problem)

var async = require('async')

router.get("/get-meta", function(req, res, next){

    async.parallel([
        function(callback){
            connection.query("select id, country_name from country", function (error, result1) {
                callback(error,result1)
            });
        },
        function(callback){
            connection.query("select id, currency from currency", function (error, result2) {
                callback(error,result2)
            });
        }

        ],function(err,results){
            if(err){
                res.json({"status": "failed", "message": error.message})
            }else{
                res.send(JSON.stringify(results)); //both result1 and result2 will be in results
            }
        })
});

answered May 27, 2017 at 10:57

dev07

3562 silver badges8 bronze badges

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

4 Comments

Azeem Ullah Over a year ago

How can I give heading to each result-set while returning response? For example i am getting data like: [[{"id":1,"country_name":"Pakistan"}],[{"id":1,"currency":"PKR"}]] to [country: [{"id":1,"country_name":"Pakistan"}], currency:[{"id":1,"currency":"PKR"}]]

dev07 Over a year ago

you cannot specify headers ,but the results will be in order.so you can asume the results of query1( first function) will be in results[0] and query2 will be in results[1] and so on

Azeem Ullah Over a year ago

and can we use some data from result1 in second function?

dev07 Over a year ago

it is parallel function both functions will run together so you cannot use data from one func. in another,but you want such operation you can use async.waterfall (but this will run your functions in series)

Mihai Alexandru-Ionut · Accepted Answer · 2017-05-27 10:09:38Z

1

First of all, you should find a method to await for two async operation to finished, and then concat the results. Have a look here or here

You should use concat method.

Here is an example:

var json1 = [{'name': "doug", 'id':5}];
var json2 = [{'name': "goud", 'id':1}];
json1 = json1.concat(json2);
console.log(json1);

answered May 27, 2017 at 10:09

Mihai Alexandru-Ionut

48.6k14 gold badges106 silver badges132 bronze badges

1 Comment

Azeem Ullah Over a year ago

Appreciate your efforts but the reference links you provided was confusing and complicated. But thanks though.

Collectives™ on Stack Overflow

How to append two results of query in one json in Node.js

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related