/**
* Module dependencies.
*/
var express = require('express'),
http = require('http'),
url = require('url'),
util = require('util');
var nconf = require('nconf');
var sql = require('node-sqlserver');
nconf.env();
var conn = nconf.get("SQL_CONN");
var app = express();
app.get('/', function(req, res){
var qs = url.parse( req.url, true );
res.writeHead(200, {'Content-Type': 'application/json; charset=utf-8'});
var alldata={};
var select = "SELECT 1";
sql.query(conn, select, function(err, items) {
res.end(JSON.stringify(alldata));
});
});
http.createServer(app).listen(process.env.PORT || 3000, function(){
console.log("Express server listening ");
});