import { Sequelize } from "sequelize";
import dotenv from "dotenv";
import mysql2 from "mysql2";

dotenv.config(); // load .env at runtime

// Make Sequelize a global singleton (prevents multiple instances during hot reload)
declare global {
  var sequelize: Sequelize | undefined;
}

const sequelize =
  // global.sequelize ??
  new Sequelize(
    process.env.DB_NAME as string,
    process.env.DB_USER as string,
    process.env.DB_PASSWORD as string,
    {
      host: process.env.DB_HOST,
      dialect: "mysql",
      dialectModule: mysql2,
      logging: false,
      pool: {
        max: 5,
        min: 0,
        acquire: 30000,
        idle: 10000,
      },
    }
  );

if (process.env.NODE_ENV !== "production") {
  global.sequelize = sequelize;
}

export default sequelize;