var mysql = require('mysql');
//var JWT = require('jwt-decode');

//exports.handler = function(event, context, callback) {
var con = mysql.createConnection({
    host: "backend.cyrlqgeqf2ao.us-east-2.rds.amazonaws.com",
    user: "admin",
    password: "9?]#k84f6Td&",
    database: "BackEnd"
    });
//var token = event.token;
//var decoded = JWT(token);
//var userID = decoded["cognito:username"];
var userID = "admin";

    con.connect(function(err) {
        if (err) throw err;
        var sql = "SELECT * from Calls where UserID = " + "'" + userID + "'";
        con.query(sql, function (err, result) {
            if (err)
            {
                //callback(err, "Error");
                throw err;
            }
            con.end();
            //callback(null,result);
            console.log(result);
        });
    });