'use strict';

const sql = require('mssql');

exports.handler = (event, context, callback) => {
  const config = {
    user: 'username',
    password: 'password',
    server: 'server',
    database: 'database',
  };

  sql.connect(config, (err) => {
    if (err) {
      console.log(err);
      callback(err);
    } else {
      const req = new sql.Request();
      req.query('SELECT * FROM test_table', (error, result) => {
        if (error) {
          console.log(error);
          callback(error);
        } else {
          console.log(result);
          sql.close();
          callback(null, result.recordset);
        }
      });
    }
  });

  sql.on('error', (err) => {
    console.log(err);
    callback(err);
  });
};