server.js

var express = require('express')
var cors = require('cors')
var bodyParser = require('body-parser')
var app = express()
var jwt = require('jwt-simple')
var auth = require('./auth.js')
var mysql = require('mysql')
var log4js = require('log4js')
var config = require('./config.js')

log4js.configure({
    appenders: { log: { type: 'file', filename: __dirname + '/external/gthx-server.log' },
                 out: { type: 'stdout' }},
    categories: { default: { appenders: ['log', 'out'], level: 'debug' } }
});

var logger = log4js.getLogger();

logger.info('GThx server version 0.1 running in environment: ' + config.env);

if (config.settings.logLevel){
    logger.info('Setting log level to ' + config.settings.logLevel);
    logger.level = config.settings.logLevel;
}

app.use(cors())
app.use(bodyParser.json())

app.use(express.static('client'));

app.get('/factoids/:search', (req, res) => {
    logger.info('Factoid search for ' + req.params.search)
    
    auth.db.query("SELECT item, value, nick FROM factoids WHERE item LIKE ?", [req.params.search], function (err, result, fields) {
        if (err) {
            logger.warn('Factoid search failed: ' + err)
            res.status(500).send({ error: 'Internal Server Error' });
        }
        else {
            res.send(result)
        }
    })
})

app.get('/stats/factoids', (req, res) => {
    logger.debug('Factoid stats request')
    
    auth.db.query('select factoids.item as item,GROUP_CONCAT(value SEPARATOR " and also ") as value,count,lastreferenced from factoids join refs r on r.item=factoids.item WHERE r.item NOT IN ("botsnack","botsmack") GROUP BY factoids.item ORDER BY count desc, lastreferenced desc LIMIT 20', function (err, result, fields) {
        if (err) {
            logger.warn('Factoid stats request failed: ' + err)
            res.status(500).send({ error: 'Internal Server Error' });
        }
        else {
            res.send(result)
        }
    })
})

app.use('/auth', auth.router)

app.get('*', function(req, res){
    res.sendFile(__dirname + '/client/index.html')
})

var port = 3000
logger.info(`Server listening on port ${port}`)
var server = app.listen(port)

// Close the app by attempting to close all connections, then
// forcing a shutdown if that doesn't work.
var gracefulShutdown = function() {
    server.close(function() {
        logger.info('Sucessfully closed all connections.')
        process.exit()
    })

    // Give it 10 seconds for the graceful shutdown to work,
    // then force exit.
    setTimeout(function() {
        logger.error('Timeout waiting for a graceful shutdown - forcing close')
        process.exit()
    }, 10*1000)
}

process.on('SIGTERM', function () {
    logger.warn('SIGTERM: shutting down')
    gracefulShutdown()
});

process.on('SIGINT', function () {
    logger.warn('SIGINT: shutting down')
    gracefulShutdown()
});