import mysql from 'mysql2/promise';

export const pool = mysql.createPool({
  host: process.env.DB_HOST || '127.0.0.1',
  port: Number(process.env.DB_PORT) || 3306,
  user: process.env.DB_USER || 'root',
  password: process.env.DB_PASSWORD || '',
  database: process.env.DB_NAME || 'vpmt',
  waitForConnections: true,
  connectionLimit: 10,
  // Return DATE/DATETIME as plain strings (e.g. "2026-01-01") instead of JS Date
  // objects — avoids timezone-shift bugs when a pure calendar date round-trips
  // through Date and back into a <input type="date"> value.
  dateStrings: true,
});