const mssql = require('mssql')
const dotenv  = require('dotenv').config()

let pool;
const sqlConfig = {
    user:process.env.DB_USER,
    password:process.env.DB_PASSWORD,
    database:process.env.DB,
    server:process.env.SERVER,
    port:1433,
    pool:{
        max:10,
        min:0,
        idleTimeoutMillis:30000
    },
    options:{
        encrypt:false,
        trustServerCertificate:false,
    }
}

async function initPool(){

   
    if(pool) return pool;
    pool= await mssql.connect(sqlConfig);
    
    return pool;

}
module.exports = {initPool};