rts-rob

{ 
  "token": "ABCD1234EFGH5678IJKL9012",
  "team_id": "XXXXXXXXX",
  "team_domain": "someteamdomain",
  "channel_id": "YYYYYYYYY",
  "channel_name": "directmessage",
  "user_id": "ZZZZZZZZZ",
  "user_name": "someuser",
  "command": "/dbreset",
  "text": "",

rts-rob

function validateUserAgent(event, desiredUserAgent) {

  return new Promise(function(resolve, reject) {
    const foundUserAgent = event.requestContext.identity.userAgent.toLowerCase();

    if (foundUserAgent.startsWith(desiredUserAgent.toLowerCase())) {
      resolve(querystring.parse(event.body));
    } else {
      reject(buildError(401, "This endpoint cannot be accessed via the current User Agent."));
    }

rts-rob

module.exports.reset = (event, context, callback) => {
  const targetUserAgent = 'slackbot';
  const targetSlackTeam = 'SomeSlackTeam';

  validateUserAgent(event, targetUserAgent)
  .then(requestBody => validateSlackTeam(requestBody, targetSlackTeam))
  .then(validatedRequestBody => extractUser(validatedRequestBody))
  .then(extractedUser => resetDB(extractedUser))
  .then(response => callback(null, response))
  .catch(error => callback(error));

rts-rob

AWSTemplateFormatVersion: '2010-09-09'
Transform: 'AWS::Serverless-2016-10-31'
Resources:
  someTable:
    Type: 'AWS::DynamoDB::Table'
    Properties:
      AttributeDefinitions:
        - AttributeName: id
          AttributeType: S
        - AttributeName: version

rts-rob

service: serverless
provider:
  name: aws
  runtime: nodejs6.10
functions:
  someFunction:
    handler: someFunction.handler
    description: Lambda Function
    events:
      - stream:

rts-rob

provider "aws" { }

resource "aws_iam_role" "iam_for_lambda" {
  name = "iam_for_lambda"

  assume_role_policy = <<EOF
{
  "Version": "2012-10-17",
  "Statement": [
    {

rts-rob

CREATE VIEW ClassesAndRunningInformation AS
SELECT 
  ClassGroup.Name AS ClassGroupName,
  Running.StartDate,
  Module.Name AS ModuleName,
  Module.Length AS ModuleLength
FROM
  ClassGroup
    INNER JOIN
  Running

rts-rob

CREATE TABLE userType (
	id int NOT NULL,
  description varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
);

CREATE TABLE user (
	id char(32) NOT NULL, -- use uuid() on INSERT
  username varchar(24) NOT NULL,  -- rob
  passwordHash char(40) NOT NULL, -- c8fed00eb2e87f1cee8e90ebbe870c190ac3848c

rts-rob

function archetype (request, response) {
  // Get Data out of the request

  // Process that data

  // Build and send the response
  response.setHeaders();
  response.write();
  response.end();
}

rts-rob

function signup (email, password) {
  const salt = uuid();
  const hashedPassword = hash(`${salt}${password}`);
  // this stores everything in the DB
  createUser(email, salt, hashedPassword);
}

function login (request, response) {
  // get the salt - SELECT salt FROM users 
  // WHERE email = ?, [email]