快递.js存储来自响应数据库的数据

Question

我对node/express有问题.js我已连接到数据库，并且正在从数据库中检索数据，并将其保存为"localhost：3000/interval"作为res.send。我想将其存储到一个变量中，使其在 ./interval 上不可见，解析它，然后传递给谷歌图表 API 以绘制图表:)到目前为止，我没有被困这么久。请帮忙:)

来自数据库的数据

[{"CZAS":"2017-02-02 21:19:05","PM1":"28","PM25":"40","PM10":"48","ID":"300"},{"CZAS":"2017-02-03 07:17:07","PM1":"45","PM25":"69","PM10":"86","ID":"600"},{"CZAS":"2017-02-03 07:25:58","PM1":"67","PM25":"110","PM10":"139","ID":"900"},{"CZAS":"2017-02-03 07:35:11","PM1":"72","PM25":"121","PM10":"164","ID":"1200"}

这是来自服务器.js

app.get('/interval', common.listPoints2);

来自通用的代码。

exports.listPoints2 = function(req, res) {
var data = require('../data.js');
console.log("Getting list points " + req + " res " + res);
data.connect();
console.log("Conecnted ...");
data.fiveMinInterval(1, res);}

这是一个函数

exports.fiveMinInterval = function(req, res) {
var xys = [];
console.log("Get data from DB");
client.query('SELECT time AS CZAS, pm1 AS PM1, pm25 AS PM25, pm10 AS PM10, id AS ID FROM dev_0_data WHERE id%300=0')
.on('result', function(res) {
        res.on('data', function(row) {
    xys.push(row);
        })
    .on('error', function(err) {
                console.log('Result error: ' + inspect(err));
    })
    .on('end', function(info) {
                console.log('Result finished successfully');
    });
})
.on('end', function() {
    console.log("Get track points end");
      res.send(xys);
});

}

Answer 1

是否打印了"获取跟踪点结束"？

请注意，结果回调函数参数和 fiveMinInterval 参数 "res" 具有相同的变量名称。