| const mysql = require('mysql2'); | |
| require('dotenv').config({override: false}); | |
| const pool = mysql.createPool({ | |
| host: process.env.DB_HOST, | |
| port: process.env.DB_PORT, | |
| user: process.env.DB_USER, | |
| password: process.env.DB_PASSWORD, | |
| database: process.env.DB_NAME, | |
| waitForConnections: true, | |
| connectionLimit: 10, | |
| queueLimit: 0, | |
| enableKeepAlive: true, | |
| keepAliveInitialDelay: 0 | |
| }); | |
| const promisePool = pool.promise(); | |
| module.exports = promisePool; | |