不工作module.exports

Question

文件ConnectToDB

var pg = require("pg");
var dataWithDB = require('./DataBase/ConnectToDb');
var pool = new pg.Pool({
host: "localhost",
port: "5432",
user: "postgres",
password: "111111",
database: "hrs"
});

pool.connect(function (err,client,done) {
if(err)console.log("connect "  + err.toString());

else
    client.query('SELECT id, "idName", "idContact", "idExperience", 
"idSkill", "dateAdded", "dateColloquy"' +
'FROM public."applicant ";',function (err,result) {

        if(err) {
            //console.log("query " + err.toString());
            exports.res = "Data NOT";
        }
        else {
            console.log(result.rows);
            module.exports.resul = result.rows;
        }
        done();
    });

});
pool.end()

文件app.js

var dataWithDB = require('./DataBase/ConnectToDb');

console.log(dataWithDB + "  wit DB");

因此，我可以从数据库中推断出未定义的数据库，但应该从DB中提取数据。

范围内会出现错误吗？如果在文件module.exporst.result =“示例”的末尾指定数据，则会发送数据。

Answer 1

您应该将连接到db代码封装在接受回调的函数中。

这里有一个例子，希望你能得到这个想法。:)

/数据库/ConnectToDb

var pg = require("pg");
module.exports = (callback) => {
    var pool = new pg.Pool({
        host: "localhost",
        port: "5432",
        user: "postgres",
        password: "111111",
        database: "hrs"
    });

    pool.connect(function (err, client, done) {
        if (err) {
            console.log("connect " + err.toString());
        } else {
            let query = 'SELECT id, "idName", "idContact",' +
                ' "idExperience","idSkill", "dateAdded", "dateColloquy"' +
                'FROM public."applicant ";'
            client.query(query, function (err, result) {
                if (err) {
                    //console.log("query " + err.toString());
                    exports.res = "Data NOT";
                    callback(err);
                }
                else {
                    console.log(result.rows);
                    callback(null, result);
                }
                done(); // Not sure what this does! :-o
            });
        }
    });
    // Is this trying to close it before we've connected? 
    // It should probably be up above...
    pool.end() 

}

应用程序

var connectToDb = require('./DataBase/ConnectToDb');
connectToDb((err, result) => {
    // This is a callback!
    if(err) console.log(err)
    else console.log(result)
})

进行google搜索：node.js回调模式

Answer 2

下面是您应该做的:导入传递到查询中的不同的回调函数。此回调将执行任何您想要的结果。正如所写的，您的方法将不起作用，也没有意义。