var express=require('express');
var http = require('http');
var sql=require('mssql');
var fs = require('fs');
var hbs = require('hbs');
var cors = require('cors');
var app=express();
var data;
//config for your database
var config={
        user:'***',
        password:'****',
        server:'***',
        database:'****'
    };
    //connect to your database
sql.connect(config,function (err) {
  if(err) console.log(err);
    //create Request object
  var request=new sql.Request();
  var fDate, lDate;
  fDate = '2017-08-03';
  lDate = '2017-08-04';
  request.input('firstdate', sql.NVarChar, fDate);
  request.input('lastdate', sql.NVarChar, lDate);
  request.query(" EXEC dbo.KSD_Front_YbidCountByMinutes @firstdate , @lastdate ", (err,recordset) => {
                      if(err) console.log(err);
                    //send records as a response
                      data = JSON.stringify(recordset);

// send the data to the script.js
app.use(cors());
app.get('/',function(req,res){
    res.writeHead(200, {'Content-Type':'text/json;charset=utf-8'});
    res.end(data);
});

app.listen(5050,function(){
  console.log('Server is running!');
});
                    });
  });