var express = require('express');
var application = express();

application.get('/', function (req, res) {
  var sql = require("mssql");

  var config = {
    user: 'bisrvuser',
    password: 'Forrester1!',
    server: 'forrepam2.c5jjhjko1svs.us-east-1.rds.amazonaws.com',
    database: 'CXINDEXData'
  };

var connection = sql.connect(config, function (err) {
    var request = new sql.Request();
    request.query("SELECT TypeFlag,CXValue FROM [CXINDEXData].[dm].[CXIndexScore] WHERE UserHash = '1120301866' AND Category = 'CXIndex'", function (err, recordset) {
      res.send(recordset);
      var values = recordset;
      var bigDonut = values[1].CXValue;
      console.log(bigDonut);
      res.end(JSON.stringify(recordset));
      connection.end(); //end connection
    });
  });
});
application.listen(5000, function () {
});