Learning Objective

• Maintain Configurations in a separate folder, so that its easy to maintain.

Existing Code: Database configurations maintained in app.js

• app.js (In app.js, we maintained configuration)

    // Create Connection Pool
    const mysql = require("mysql2/promise");

     const pool = mysql.createPool({
            host: process.env.DB_HOST,
            port: process.env.DB_PORT,
            user: process.env.DB_USERNAME,
            password: process.env.DB_PASSWORD,
            database: process.env.DB_DATABASE_NAME,
            connectionLimit: process.env.NO_OF_CONNECTIONS
    });

    app.listen(port, () => console.log(`app listening on port port!`))

Task : Move the database related configurations to a separate file

• config/database.js

  // Create Connection Pool
    const mysql = require("mysql2/promise");

    const pool = mysql.createPool({
            host: process.env.DB_HOST,
            port: process.env.DB_PORT,
            user: process.env.DB_USERNAME,
            password: process.env.DB_PASSWORD,
            database: process.env.DB_DATABASE_NAME,
            connectionLimit: process.env.NO_OF_CONNECTIONS
    });

    // We need to export
    module.exports = pool;

• app.js

    //require('dotenv').config()
    const pool = require('./config/database');

Task 4: Run the Server

    nodemon app.js