var sql = require('mssql');
var router = express.Router();
router.use(function(req, res, next){
    // Add database connection
    var connection = new sql.Connection(sqlConfig: {
        user: 'username',
        password: 'password',
        server: 'IP address',
        database: 'database name',
        options: {
            encrypt: true
        }
    }, function(err) {
        if (err) {
            logger.error('Connection error: ' + err.message);
            res.sendStatus(400);
        }
        else {
            req.connection = connection;
            next();
        }
    });
});
module.exports = router;