Microsoft SQL Server connection

ms-config.js

const msLocalConfig = {
    msHost: '',
    msDb:   '',
    msUser: '',
    msPassword: '',
    msPort: 1433,
    msTimeoutMilli: 20000,
    msMaxPoolClients: 10,
    msPoolTimeoutMilli: 30000
};


export default msLocalConfig;

mssql-connector.js

import sql from 'mssql';
import colors from 'colors';

import msLocalConfig from './ms-config';

const config = {
	user: process.env.MSUSER || msLocalConfig.msUser,
	database: process.env.MSDATABASE || msLocalConfig.msDatabase,
	password: process.env.MSPASSWORD || msLocalConfig.msPassword,
	server: process.env.MSHOST || msLocalConfig.msHost,
	port:  process.env.MSPORT || msLocalConfig.msPort,
    pool: {
        max: process.env.MSMAXPOOLCLIENTS || msLocalConfig.msMaxPoolClients,
        idleTimeoutMillis: process.env.MSTIMEOUTMILLI || msLocalConfig.msPoolTimeoutMilli
    },
    options: {
        trustedConnecton: true
    }

};

console.log(`[+] Enabling MS SQL client pool ...`.yellow);
const msPool = new sql.ConnectionPool(config, err => {
    if (err) {
        console.log(`[-] ${err}`.red);
    } else {
        console.log(`[+] Connection to MS SQL Server established.`.green);
    }
});

export { msPool };