db-config.js

const { response } = require('express');
const sql = require('mysql');
const dotenv = require('dotenv').config();
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
});
let instance = null;

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);
        }
    }

    async insertNewName(name) {
        try {
            const dateAdded = new Date();
            const insertId = await new Promise((resolve, reject) => {

                const query = "INSERT INTO users (name, dateAdded) VALUES (?,?);";

                db.query(query, [name, dateAdded] , (err, result) => {
                    if (err) reject(new Error(err.message));
                    resolve(result.insertId);
                })
            });
            console.log(response);
            return response;
        } catch (error) {
            console.log(error);
        }

    }
}


module.exports = { db, dbService }