/config/db-config.js

const sql = require('mysql');
const dotenv = require('dotenv').config();
let instance = null;
const db = sql.createConnection({
    host: process.env.DATABASE_HOST,
    user: process.env.DATABASE_USER,
    password: process.env.DATABASE_PASSWORD,
    database: process.env.DATABASE
    // port: process.env.PORT
});

// class dbService {
//     static getDbServiceInstance() {
//         return instance ? instance : new dbService();
//     }

//     async getAllData() {
//         try {
//             const response = await new Promise((resolve, reject) => {
//                 const query = "SELECT * FROM users";

//                 db.query(query, (err, results) => {
//                     if (err) reject(new Error(err.message));
//                     resolve(results)
//                 })
//             });
//                // console.log(response);
//             return response;

//         } catch (error) {
//             console.log(error);
//         }
//     }
// }


// module.exports = dbService;
module.exports = db;