const mysql = require('mysql');
const aws = require('aws-sdk');
const fs = require('fs');

exports.handler = (event, context, callback) => {
    // TODO implement
    console.log('First Line');
    console.log(aws.RDS.Signer);

    var signer = new aws.RDS.Signer({
      // configure options
      region: 'us-east-1',
      username: 'rds_lamb',
      hostname: 'ce-mawsdbcopy.cfzki5ktykgk.us-east-1.rds.amazonaws.com',
      port: 3306
    });

    console.log(signer);
    var signer = new aws.RDS.Signer({
        region: 'us-east-1',
        username: 'rds_lamb',
        hostname: 'ce-mawsdbcopy.cfzki5ktykgk.us-east-1.rds.amazonaws.com',
        port: 3306
    });

    console.log("ok");
    console.log(signer);

    signer.getAuthToken({
        username: 'rds_lamb'
    }, function(err, token) {

        var connection = mysql.createConnection({
            host: 'ce-mawsdbcopy.cfzki5ktykgk.us-east-1.rds.amazonaws.com',
            port: 3306,
            user: 'rds_lamb',
            password: token,
            database: 'msaws',
            ssl: {
                ca : fs.readFileSync(__dirname + '/rds-combined-ca-bundle.pem')
            }
        });
        connection.connect(function (error) {
            console.log(`Got an error while connection establishment: ${error}`);
        });
        console.log("I am next to connect");
        connection.query('select * from managedos', function (err, rows, fields) {
            if(!err) {
                console.log("The solution is: ", rows);
            } else {
                console.log("Error while perfoming query! ", err);
            }
        });
        connection.end();
        callback(null, 'Hello from Lambda');
    });
};