app.js

/*eslint-env node*/

/* Webserver*/
// express webserver
var express = require('express');
// package to parse the body of a request into a JSON object
var bodyParser = require('body-parser');
// create a new express server
var app = express();
var expressValidator = require('express-validator');

/* Cloud environment */
// cfenv provides access to your Cloud Foundry environment
var cfenv = require('cfenv');
// get the app environment from Cloud Foundry
var appEnv = cfenv.getAppEnv();

var fs = require('fs');

// morgan for logging http requests
var morgan = require('morgan');

/*Set EJS template Engine*/
// setting the views directory
app.set('views', './src/views');
// setting ejs as the view engine
app.set('view engine', 'ejs');

// setting the public directory for static files
app.use(express.static('public'));
app.use(bodyParser.json()); // parse application/json (parse the body into req.body for json encoded)
app.use(bodyParser.urlencoded({
    extended: true
})); // parse application/x-www-form-urlencoded (parse the body into req.body for url encoded)
app.use(expressValidator()); // this line must be immediately after any of the bodyParser middlewares!

/*MySql connection*/
// configuring the MySQL DB
var mysql = require('mysql');
var connection = require('express-myconnection');

// Old DB strategy (without a middleware) - kept because being used by user, checkin and cardapio controller
var mySqlDB;
var dbCredentials = {
    dbName: 'splitterdb'
};

/**
 * Initialize DB connection
 */
function initDBConnection() {
    //When running on Bluemix, this variable will be set to a json object
    //containing all the service credentials of all the bound services
    if (process.env.VCAP_SERVICES) {
        dbCredentials.uri = getDBCredentialsUrl(process.env.VCAP_SERVICES);
        console.log("Conectando ao DB na nuvem");
    } else { //When running locally, the VCAP_SERVICES will not be set

        // When running this app locally you can get your MySQL credentials
        // from Bluemix (VCAP_SERVICES in "cf env" output or the Environment
        // Variables section for an app in the Bluemix console dashboard).
        // Once you have the credentials, paste them into a file called vcap-local.json.
        // Alternately you could point to a local database here instead of a
        // Bluemix service.
        // uri will be in this format: mysql://root:@localhost:3306/splitterdb?reconnect=true
        dbCredentials.uri = getDBCredentialsUrl(fs.readFileSync("vcap-local.json", "utf-8"));
        console.log("Conectando ao DB local");
        app.use(morgan('dev'));
    }

    // Old DB strategy pool
    mySqlDB = mysql.createPool(dbCredentials.uri);

    // new DB strategy
    app.use(
        connection(mysql, dbCredentials.uri, 'pool')
    );
};

/**
 * Get DB credentials from a local file (vcap-local.json) or Cloud environment variable
 * @param {*} jsonData 
 */
function getDBCredentialsUrl(jsonData) {
    var vcapServices = JSON.parse(jsonData);
    // Pattern match to find the first instance of a ClearDB (MySQL) service in
    // VCAP_SERVICES. If you know your service key, you can access the
    // service credentials directly by using the vcapServices object.
    for (var vcapService in vcapServices) {
        if (vcapService.match(/cleardb/i)) {
            return vcapServices[vcapService][0].credentials.uri;
        }
    }
}

//initiate db connection
initDBConnection();

/*
    setting up the middleware
*/

// importing routes
// passing mySqlPool connection
var userRouter = require('./src/routes/userRoutes.js')(mySqlDB);
var checkinRouter = require('./src/routes/checkinRoutes')(mySqlDB);
var cardapioRouter = require('./src/routes/cardapioRoutes')(mySqlDB);
var pedidoRouter = require('./src/routes/pedidoRoutes')();
var adminRouter = require('./src/routes/adminRoutes')(dbCredentials.uri);
var contaRouter = require('./src/routes/contaRoutes')();
var mesaRouter = require('./src/routes/mesaRoutes')();

// using the routes
app.use('/api/usuario', userRouter);
app.use('/api/checkin', checkinRouter);
app.use('/api/cardapio', cardapioRouter);
app.use('/api/pedido', pedidoRouter);
app.use('/api/admin', adminRouter);
app.use('/api/conta', contaRouter);
app.use('/api/mesa', mesaRouter);

/**
 * API Estabelecimento
 */

var estabPedidoRouter = require('./src/routes/estabelecimento/pedidoRoutes')();
app.use('/api/estabelecimento/pedido', estabPedidoRouter);

// start server on the specified port and binding host
if (!module.parent) { // checking if a parent already exists, so it doesn't create another one (for testing)
    app.listen(appEnv.port, '0.0.0.0', function() {
        // print a message when the server starts listening
        console.log("server starting on " + appEnv.url);
    });
}
// exporting app to be executed on test
module.exports = app;