/*
var http = require('http');

var server = http.createServer(function (request, response) {
		response.writeHead(200, {"Content-Type": "text/plain"});
		response.end("Hello, World");
});

server.listen(8000);

console.log("Server running at http://localhost:8000");

*/

/*
var Connection = require('tedious').Connection;
var Request = require('tedious').Request;
var TYPES = require('tedious').TYPES;

// Create connection to database
var config = {
	userName: 'sa', // update me
	password: 'Tower2021', // update me
	server: 'NSONHOUSE2',
	options: {
		database: 'sandboxDB'
	}
  }
  var connection = new Connection(config);

  // Attempt to connect and execute queries if connection goes through
connection.on('connect', function(err) {
	if (err) {
	  console.log(err);
	} else {
	  console.log('Connected');
	}
  });

  */


 const sql = require("mssql");
 require("msnodesqlv8");
 const conn = new sql.ConnectionPool({
   database: "sandboxDB",
   server: "localhost",
   driver: "msnodesqlv8",
   options: {
	 trustedConnection: true
   }
 });