require('dotenv').config(); // โหลดค่าตัวแปรจากไฟล์ .env

const express = require('express');
const mysql = require('mysql2/promise');
const path = require('path');
const bcrypt = require('bcrypt');
const session = require('express-session');
const cookieParser = require('cookie-parser');

// Session configuration
app.use(session({
    secret: process.env.DB_SESSION || "melon",
    resave: false,
    saveUninitialized: true,
    cookie: { secure: false }  // ใช้ false ถ้าคุณไม่ใช้ https, ถ้าใช้ https ใช้ true
  }));
  
  // Database configuration
  const pool = mysql.createPool({
      host: process.env.DB_HOST || "10.104.20.74",
      port: process.env.DB_PORT || "3306",
      user: process.env.DB_USER || "root",
      password: process.env.DB_PASSWORD || "TNSypb73606",
      database: process.env.DB_NAME || "project",
      waitForConnections: true,
      connectionLimit: 10,
      queueLimit: 0
  });










// Start the server
const port = process.env.PORT || 3000;
app.listen(port, () => {
    console.log(`Server started on port ${port}`);
});