const mariadb = require('mariadb');
require("dotenv").config();

// Create a pool connection to MariaDB
const pool = mariadb.createPool({
  host: process.env.DB_HOST,
  user: process.env.DB_USER,
  password: process.env.DB_PASSWORD,
  port: parseInt(process.env.DB_PORT, 10),
  database: process.env.DB_NAME,
  connectionLimit: parseInt(process.env.CON_LIMIT, 10),
});

pool.getConnection()
  .then(() => console.log("Database connection successful!"))
  .catch(err => console.error("Database connection error:", err.message));

// Export the pool to use in other files
module.exports = pool;