app.js

var createError = require('http-errors');
var express = require('express');
var path = require('path');
var cookieParser = require('cookie-parser');
var logger = require('morgan');
var mysql = require("./api/tools/DbInstance");


// var Counter = require('./api/tools/Counter');
// var session = require('express-session');
// var MySQLStore = require('express-mysql-session')(session);
var db_options = require('./api/tools/DbOptions.json');
// var session_options = require('./api/tools/SessionOptions.json');
var fileupload = require("express-fileupload");

var APIRouter = require('./api/Route');

var app = express();

// needed for image upload
app.use(fileupload());

// setup session
// var sessionStore = new MySQLStore(db_options);
// session_options.store = sessionStore;
// app.use(session(session_options));

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

app.use(logger('dev'));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());

app.use(express.static(path.join(__dirname, 'frontend', 'build')));
app.use('/api', APIRouter);

app.get('*', (req, res) => {
    res.sendFile(path.join(__dirname, "frontend", "build", "index.html"));
});

// catch 404 and forward to error handler
app.use(function(req, res, next) {
    console.log(req.url)
    // next(createError(404));
    res.status(404).send("<h1>Not Found</h1>\
    <p>The requested URL was not found on this server.</p>\
    <hr>\
    <address>Apache/2.4.38 (Debian) Server</address>");
});

// error handler
app.use(function(err, req, res, next) {
    // set locals, only providing error in development
    console.log("in error handler:")
    console.log(err)
    // res.locals.message = err.message;
    // res.locals.error = req.app.get('env') === 'development' ? err : {};

    // render the error page
    res.status(err.status || 500).send("<h1>Internal Server Error</h1>\
    <p>The server encountered an internal error or misconfiguration and was unable to complete your request.<br>\
    <br>\
    Please contact the server administrator to inform them of the time this error occurred, and the actions you performed just before this error.<br>\
    <br>\
    More information about this error may be available in the server error log.</p>\
    <hr>\
    <address>Apache/2.4.38 (Debian) Server</address>");
});

module.exports = app;