const { black, bgGreen } = require('colors');
const { config } = require('dotenv');
const { Sequelize } = require('sequelize');
require('dotenv').config();
// require('dotenv').config();

const sequelize = new Sequelize(
  process.env.DB_NAME,     
  process.env.DB_USER,     
  process.env.DB_PASSWORD, 
  {
    host: process.env.DB_HOST,
    dialect: 'mysql',
    logging: false,        
  }
);

sequelize.authenticate()
  .then(() => {
    console.log('Connected to MySQL database'.bgGreen);
  })
  .catch(err => {
    console.error('Database connection failed:'.bgRed, black, err);
  });

module.exports = sequelize;