Modularize Nodejs Connection with Postgresql

Question

I’m having trouble creating a module on nodejs to export my connection to PostgreSQL.

I couldn’t understand why according to code does not work as I would like to export connect.

Code 1 .

var pg = require('pg');

module.exports = function () {
    var conString = 'postgres://usuario:senha@localhost:5432/teste';
    var conexao = new pg.Client(conString);
    return conexao;
};

I call it that in my app:

var db = require('../../config/conexao');
var conexao = db();
conexao.connect();
conexao.query('select * from cliente', function (error, result) {..

Code 2

var pg = require('pg');

module.exports = function () {
    var conString = 'postgres://usuario:senha@localhost:5432/teste';
    var conexao = new pg.Client(conString);

    // retorna já a conexao feita 
    return conexao.connect();
};

And I call it that:

var conexao = db();

Without using the connect, so I get the error that method query nay exists.

Because the second way, I can’t find the method query in my connection?

Answer 1

In the second code you are already exporting the object that represents the connection. It is not necessary to invoke it as if it were a function.

So instead of importing the module this way:

var conexao = db();

You can just use:

var conexao = db;