const sql  = require('mssql');

const connectToBIDatabase = async () => {
  const dbOptions = {
    user: 'a_user',
    password: 'XXXX',
    server: 'aws-DBServerName',
    domain: 'SOMEDOMAIN',
    requestTimeout: 5 * 60 * 1000, // 5 mins
    options: {
      trustedConnection: true,
    },
    database: 'myAppDB',
  };

  return new Promise((resolve, reject) => {
    /**
     * @todo use single connection or pool
     */
    sql.connect(dbOptions, (err, result) => {
      if (err) {
        return reject(err);
      }

      resolve(result);
    });
  });
};

const executeStoredProc = async (request) => {
  return new Promise((resolve, reject) => {
    const request = new sql.Request();
    request.input('EmailAddress', sql.NVarChar, request.customerEmailAddress);
    request.input('RequestId', sql.NVarChar, request.requestId);
    request.input('ExpectedCompletionDate', sql.NVarChar, request.expectedCompletionDate);
    request.execute('[someSchema].[uspLogRequest]', (err, result) => {
      if (err) {
        return reject(err);
      }

      resolve(result);
    });
  });
};

connectToBIDatabase().then(() => {
  executeStoredProc({
    emailAddress: 'anon_3241@somefake.com',
    requestId: '10',
    expectedCompletionDate: new Date().toISOString()
  }).then(() => {
    console.log('done');
  });
}).catch((err) => {
  console.log(err);
})