rts-rob

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

rts-rob

let fs = require('fs');
...
const resetScript = fs.readFileSync("resetdata.sql");
const query = `USE ${requestingUser}; ${resetScript}`;
...
connection.query(query, function (error, results, fields) {
  connection.end();

rts-rob

let mysql = require('mysql');
...
const connection = mysql.createConnection({
  host: "somedatabasehost.com",
  user: "someuser",
  password: "somepassword",
  multipleStatements: true
});
...
connection.connect();

rts-rob

let querystring = require('querystring');
...
const requestingUser = querystring.parse(event.body).user_name;

rts-rob

service: dbreset

provider:
  name: aws
  runtime: nodejs6.10
  region: eu-central-1

functions:
  reset:
    handler: handler.reset

rts-rob

'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;

rts-rob

service: aws-nodejs # NOTE: update this with your service name

provider:
  name: aws
  runtime: nodejs6.10

functions:
  hello:
    handler: handler.hello

rts-rob

'use strict';

module.exports.hello = (event, context, callback) => {
  const response = {
    statusCode: 200,
    body: JSON.stringify({
      message: 'Go Serverless v1.0! Your function executed successfully!',
      input: event,
    }),
  };