我正在尝试整合node-postgres驱动程序,并学习如何执行简单的CRUD操作。在我的app.js
中,我做了类似这样的事情:
...
var postgres = require('./adapters/postgres')
var postClient = new postgres(conf);
...
postClient.connect(function (dbconn) {
app.dbconn = dbconn;
app.conf = conf;
console.log("************************************************************");
console.log(new Date() + ' | CRUD Server Listening on ' + conf['web']['port']);
console.log("************************************************************");
server.listen(conf['web']['port']);
var Routes = require('./routes/http-routes');
new Routes(app);
});
在我的adapters/postgres.js
文件中,我有以下内容:
const Client = require('pg');
const postClient = new Client(conf)({
host: conf['postgres'].host,
port: conf['postgres'].port,
dbname: conf['postgres'].dbname,
username: conf['postgres'].username,
password: conf['postgres'].password,
dbconn: null,
});
module.exports = postClient;
postClient.prototype.connect = function (cbk) {
var self = this;
client.connect(function (err, db) {
console.log(new Date() + " | Postgres Server Connection Establised...");
console.log(new Date() + " | Current database: ", db.databaseName);
if (!err) {
console.log(new Date() + " | Postgres Server Authenticated...");
self.dbconn = db;
cbk(db);
} else {
console.log(new Date() + " | Postgres Server Error in connection...");
console.log(err);
self.dbconn = db;
cbk(db);
}
});
};
使用以上代码时,我一直收到这个错误:
ReferenceError: conf is not defined
,所以我添加了它:var conf = require('../config/conf');
。这不是一个合适的解决方案,因为我想从app.js
中传递它。接下来,即使添加了这个,我仍然会收到以下错误:TypeError: Client is not a constructor
。有人可以指导如何修复这两个错误吗?