connection with dynamic database node.js using exports

Question

I am getting the database name from front end when user logged in the system and I have to make the connection with that database for further process.I am able to do it if create the connection on same page but I want to use 'exports' I am trying this. I am new in node.js so if there is some very silly mistake please dont mind and help me to understand. I tried different way of exporting but not able to make it run.

my DB_dynamic.js:

var mysql = require('mysql');
exports.dynamicConnection= function(dbname){
var connection = mysql.createConnection({
  host: process.env.DBHost || 'localhost',
  port: process.env.DBPort || 3306,
  user: process.env.DBUser || 'root',
  password: process.env.DBPassword || '',
  database: process.env.DBName || dbname
});
connection.connect((err) =>{
  if(err) throw err;
  console.log('Mysql Connected...');
});
}

now in my model.js

var new_conn = require('./DB_dynamic.js');
var conn = new_conn.dynamicConnection(dbname);
  conn.query("my query"); //Error!

Error:

TypeError: Cannot read property 'query' of undefined

Acolyte · Accepted Answer · 2019-05-17 08:57:32Z

2

DB_dynamic.js

const mysql = require('mysql');


module.exports = dbConnection = (dbname) => {
    return connection = mysql.createConnection({
        host: process.env.DBHost || 'localhost',
        port: process.env.DBPort || 3306,
        user: process.env.DBUser || 'root',
        password: process.env.DBPassword || '',
        database: process.env.DBName || dbname
    });
};

model.js

let dbConnection = require('./DB_dynamic.js');

console.log(dbConnection("your_db_name").query("your_query"))

edited May 17, 2019 at 8:57

answered May 17, 2019 at 8:29

Acolyte

911 silver badge5 bronze badges

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

2 Comments

Nibha Jain Over a year ago

can you explain it too?

Acolyte Over a year ago

DB_dynamic.js exports your method 'dbConnection' dbConnection takes 1 param (dbname - String) and return mysql connection object (contains methods query / connect / end ...) model.js just call the method and use the connection object return to call 'query'

Acolyte · Accepted Answer · 2019-05-17 08:11:40Z

1

module.exports.dynamicConnection= function(dbname){

edited May 17, 2019 at 8:11

answered May 17, 2019 at 8:09

Acolyte

911 silver badge5 bronze badges

Collectives™ on Stack Overflow

connection with dynamic database node.js using exports

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related