31 lines
566 B
JavaScript
31 lines
566 B
JavaScript
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}; |