//Required node modules
var express                     = require('express'),
        app                     = express(),
        printError              = require('.././errorHandler'),
        purchasesRouter         = require('./PurchasesController'),
        plisRouter              = require('./PLISController');

//Create Routes
app.use('/api/purchases', purchasesRouter);
app.use('/api/plis', plisRouter);

//Catch-all route
app.get("/*",  function(req, res) {res.status(404).send('Not found')});

module.exports = app;

//Required node modules
var env = require('dotenv').config();

//Configure the database connection
var dbConfig = {
    domain: process.env.DOMAIN,
    server: process.env.DB_SERVER,
    database: process.env.DATABASE,
    user: process.env.DB_USER,
    password: process.env.DB_USER_PASSWORD
};

module.exports.dbConfig = dbConfig;

//Required modules
var express             = require('express'),
    purchasesRouter     = express.Router(),
    printError          = require('../errorHandler.js'),
    sql                 = require('mssql'),
    db                  = require('./db.js'),
    bodyParser          = require('body-parser');

//Body Parser Middleware
purchasesRouter.use(bodyParser.urlencoded({ extended: true }));
purchasesRouter.use(bodyParser.json({ type: 'application/json' }));

function lookupPurchases(req, res, next) {
  try {
    sql.connect(db.dbConfig, function (err) {
      if (err) {
        console.log("Error connecting to database :- " + err);
        sql.close();
      }
      else {
        var request = new sql.Request();
        var sqlQuery = 'SELECT * FROM Purchases WHERE PreviousID IS NULL';
        request.query(sqlQuery, function(err, result) {
          if (err) {
            console.error(err);
            res.statusCode = 400;
            return res.json({
              errors: ['Failed to query database.']
            });
          } else {
            res.statusCode = 200;
            sql.close();
            return res.send(result);
          }; //end else
        }); //end request.query
      }; //end else
    }); //end sql.connect
  } catch (error) {
    printError(error);
    sql.close();
  }; //end catch
}
purchasesRouter.get("/", lookupPurchases, function(req, res) {
  res.send(req.Purchases);
  sql.close();
});
module.exports = purchasesRouter;

var express             = require('express'),
    app                 = express(),
    app                 = require('./app'),
    env                 = require('dotenv').config();

var server = app.listen(process.env.PORT || 8080, function () {
    var port = server.address().port;
    console.log("App now running on port", port);
});

module.exports = app;

var chai              = require('chai'),
    chaiHttp          = require('chai-http'),
    expect            = chai.expect,
    server            = require('../server/server'),
    should            = chai.should();

chai.use(chaiHttp);

// Purchases API Route test suite
describe('Purchases', function() {
  it('should list current Purchases on /api/purchases GET', function(done) {
    chai.request(server)
    .get('/api/purchases')
    .end(function(err, res){
      expect(res).to.have.status(200);
      done();
    });
  });
});