app.js

const express = require('express');
const path = require('path');
const favicon = require('serve-favicon');
const logger = require('morgan');
const cookieParser = require('cookie-parser');
const bodyParser = require('body-parser');
const mysql = require('mysql');

var routes = require('./routes/index');
var player = require('./routes/player');
var score = require('./routes/score');
var api = require('./routes/api');

var app = express();

if (app.get('env') === 'development') {
  var portSQL = 3307
  var hostSQL = '192.168.1.150'
}else{
  var portSQL = 3306
  var hostSQL = 'mariadb'
}

const sql = mysql.createPool({
  connectionLimit: 10,
  host: hostSQL,
  port: portSQL,
  user: "score",
  password: "board",
  database: "scoreboard"
});

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');

// uncomment after placing your favicon in /public
//app.use(favicon(path.join(__dirname, 'public', 'favicon.ico')));
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: true }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use(function(req,res,next){
  req.sql = sql;
  next();
});

app.use('/score', score);
app.use('/player', player);
app.use('/api', api);
app.use('/', routes);

// catch 404 and forward to error handler
app.use(function(req, res, next) {
  var err = new Error('Not Found');
  err.status = 404;
  next(err);
});

// error handlers

// development error handler
// will print stacktrace
if (app.get('env') === 'development') {
  console.log('DEV Mode');
  app.use(function(err, req, res, next) {
    res.status(err.status || 500);
    res.render('error', {
      message: err.message,
      error: err
    });
  });
}


module.exports = app;