How to write database module in nodejs

Question

In my project, I am using MySQL database. The problem is, that I don't know how to write simple database module to one js file.

My code is:

File: database.js

var mysql = require("mysql");

var connection = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "",
    database: "mydb"
});

module.exports = class Database {

    constructor() {
        connection.connect(function (err) {
            if (err) {
                console.error(err);
                throw err;
            } else {
                console.log("Connection to database was successful");
            }
        });
    }

    getConnection() { return connection; }
};

I have a lot of files in project and each one needs use database, the problem is, when I import database.js constructor is every time called, I think, its a bad way.

Is there any better way how to use database connection in project? Somethink like call getConnection() from database.js file without call constructor.

Thank you for any help.

Consider using a Singleton for your database. You can also return an instance of a Database inside the module : module.exports = new Database(); — neeh
– neeh, Commented Sep 9, 2017 at 15:34
Simply move the stuff inside the constructor outside of the class definition? — Jonas Wilms
– Jonas Wilms, Commented Sep 9, 2017 at 16:33

Jonas Wilms · Accepted Answer · 2017-09-09 16:36:10Z

3

A possible solution:

const mysql = require("mysql"),
      connection = mysql.createConnection({
          host: "localhost",
          user: "root",
          password: "",
          database: "mydb"
      });

connection.connect(function (err) {
    if (err) {
      console.error(err);
      throw err;
   } else {
    console.log("Connection to database was successful");
  }
});

module.exports =  {
  getConnection() { return connection; }
};

answered Sep 9, 2017 at 16:36

Jonas Wilms

139k20 gold badges164 silver badges164 bronze badges

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

Comments

Madhav Chaturvedi · Accepted Answer · 2017-09-09 16:37:34Z

1

In your database.js file while exporting write:

modules.exports = new Database();

And use

require('./path/to/database-file')

Wherever you have to use the instance, It will always get the same object.

answered Sep 9, 2017 at 16:37

Madhav Chaturvedi

6216 silver badges14 bronze badges

Collectives™ on Stack Overflow

How to write database module in nodejs

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related