queue.js

exports.queuePicker = function(event, context, callback) {

    var timestamp = new Date().getTime().toString();

    try {
        var username = JSON.parse(event["body"])["username"]
    } catch(e) {
        var username = event["body"]["username"]
    }

    if(event.requestContext.authorizer.claims.email !== username) {
        callback(null, {
            "isBase64Encoded": false,
            "statusCode": 401,
            "headers": {'Content-Type': 'application/json', 'Access-Control-Allow-Origin': '*'},
            "body": JSON.stringify({'message': 'User not found.'}, null, 2)
        });
        return;
    }


    if(event.headers.test === "lambda") {
        var dbName = "pickmo_testdb";
    } else if(event.headers.test === "api") {
        var dbName = "pickmo_APIdb"
    } else {
        var dbName = "pickmodb"
    }

    var connection = mysql.createConnection({
        host: "pickmo.cm8t4da2mqrz.us-west-2.rds.amazonaws.com",
        user: process.env.RDS_USERNAME,
        password: process.env.RDS_PWD,
        port: 3306,
        database: dbName
    });

    connection.connect(function(err) {
        if(err) {
            callback({
                "isBase64Encoded": false,
                "statusCode": 400,
                "headers": {'Content-Type': 'application/json', 'Access-Control-Allow-Origin': '*'},
                "body": JSON.stringify(err, null, 2)
                });
            return;
        }
    });

    var query = "INSERT INTO PickerQueue (username, timestamp) VALUES ('" +
        username + "'," + "'" + timestamp + "')";

    connection.query(query, function(err, results) {
        if(err) {
            callback({
                "isBase64Encoded": false,
                "statusCode": 400,
                "headers": {'Content-Type': 'application/json', 'Access-Control-Allow-Origin': '*'},
                "body": JSON.stringify(err)
            });
        }
        callback(null, {
            "isBase64Encoded": false,
            "statusCode": 200,
            "headers": {'Content-Type': 'application/json', 'Access-Control-Allow-Origin': '*'},
            "body": JSON.stringify(results)
        });
    });
    connection.end();
}

exports.dequeuePicker = function(event, context, callback) {

    try {
        var username = JSON.parse(event["pathParameters"])["username"]
    }
    catch (e) {
        var username = event["pathParameters"]["username"]
    }

    if(event.headers.test === "lambda") {
        var dbName = "pickmo_testdb";
    } else if(event.headers.test === "api") {
        var dbName = "pickmo_APIdb"
    } else {
        var dbName = "pickmodb"
    }

    var connection = mysql.createConnection({
        host: "pickmo.cm8t4da2mqrz.us-west-2.rds.amazonaws.com",
        user: process.env.RDS_USERNAME,
        password: process.env.RDS_PWD,
        port: 3306,
        database: dbName
    });

    connection.connect(function(err) {
        if(err) {
            if(callback) {
                callback({
                    "isBase64Encoded": false,
                    "statusCode": 400,
                    "headers": {'Content-Type': 'application/json', 'Access-Control-Allow-Origin': '*'},
                    "body": JSON.stringify(err, null, 2)
                    });
                return;
            }
        }
    });

    var query = "DELETE FROM PickerQueue WHERE username = " + "'" + username + "'";

    connection.query(query, function(err, results) {
        if(callback) {
            if(err) {
                callback({
                    "isBase64Encoded": false,
                    "statusCode": 400,
                    "headers": {'Content-Type': 'application/json', 'Access-Control-Allow-Origin': '*'},
                    "body": JSON.stringify(err)
                });
            }
            callback(null, {
                "isBase64Encoded": false,
                "statusCode": 200,
                "headers": {'Content-Type': 'application/json', 'Access-Control-Allow-Origin': '*'},
                "body": JSON.stringify(results)
            });
        }
    });
    connection.end();
};