Final handler.js

handler.js

'use strict';

let fs = require('fs');
let mysql = require('mysql');
let querystring = require('querystring');

module.exports.reset = (event, context, callback) => {
  // Extract the Slack username
  const requestingUser = querystring.parse(event.body).user_name;

  // Setup the MySQL connection
  const connection = mysql.createConnection({
    host: "somedatabasehost.com",
    user: "someuser",
    password: "somepassword",
    multipleStatements: true
  });
  
  // Load in the reset script
  const resetScript = fs.readFileSync("resetdata.sql");

  // Execute the reset script
  const query = `USE ${requestingUser}; ${resetScript}`;

  connection.connect();
  connection.query(query, function (error, results, fields) {
    connection.end();

    const response = {
      statusCode: 200,
      body: JSON.stringify({
        text: `Hi, ${requestingUser}.\nYour database has been reset!`
      })
    };
    callback(null, response);      
  });
};