Gitlab@Informatics

Skip to content
Snippets Groups Projects
Select Git revision
  • 71cd70b6c350d699aae9ba4102e0fa1cf6854bb1
  • master default
  • main protected
3 results

db.js

Blame
  • db.js 1.16 KiB
    // const mysql = require("mysql2");
    // require("dotenv").config();
    
    // const pool = mysql.createPool({
    //   host: process.env.DB_HOST || "localhost",
    //   user: process.env.DB_USER || "root",
    //   password: process.env.DB_PASS || "",
    //   database: process.env.DB_NAME || "mypocketapp",
    //   port: process.env.DB_PORT || 3306,
    // });
    
    // pool.getConnection((err) => {
    //   if (err) {
    //     console.error("❌ Database connection failed:", err);
    //     return;
    //   }
    //   console.log("✅ MySQL Connected...");
    // });
    
    // module.exports = pool;
    
    const mysql = require("mysql2/promise");
    require("dotenv").config();
    
    const pool = mysql.createPool({
      host: process.env.DB_HOST || "localhost",
      user: process.env.DB_USER || "root",
      password: process.env.DB_PASS || "",
      database: process.env.DB_NAME || "mypocketapp",
      port: process.env.DB_PORT || 3306,
    });
    
    // Test the database connection
    (async () => {
      try {
        const connection = await pool.getConnection();
        console.log("✅ MySQL Connected...");
        connection.release(); // Release the connection back to the pool
      } catch (err) {
        console.error("❌ Database connection failed:", err);
      }
    })();
    
    module.exports = pool;