text: var createError = require('http-errors');
  var express = require('express');
  var path = require('path');
  var cookieParser = require('cookie-parser');
  var logger = require('morgan');
  
  var indexRouter = require('./routes/index');
  var usersRouter = require('./routes/users');
  
  var sqldb = require('./routes/dbms_promise');
  
  var app = express();
  
  // 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, 'public')));
  
  app.use('/', indexRouter);
  app.use('/users', usersRouter);
  
  app.post('/', async function (req, res) {
    var month = "'" + req.body.month.toUpperCase() + "'";
    var getter = 'SELECT * FROM ORDERS WHERE MONTH LIKE ' + month;
    var data = await sqldb.dbquery(getter);
  
    var plain = 0;
    var cherry = 0;
    var chocolate = 0;
  
    for (var i = 0; i < data.length; i++) {
      if (data[i].TOPPING == 'plain') {
        plain += data[i].QUANTITY;
      } else if (data[i].TOPPING == 'cherry') {
        cherry += data[i].QUANTITY;
      } else {
        chocolate += data[i].QUANTITY;
      }
    }
  
    var json = {
      'plain': plain,
      'cherry': cherry,
      'chocolate': chocolate
    };
  
    res.send(json)
  });
  
  app.post('/orders', async function (req, res) {
    var day = req.body.day;
    var month = "'" + req.body.month + "'";
    var type =  "'" + req.body.type + "'";
    var notes = "'" + req.body.notes + "'";
    var quantity = req.body.quantity;
  
    var count = await sqldb.dbquery('SELECT * FROM ORDERS');
    var orderID = count.length;
  
    var insertion = "INSERT INTO ORDERS VALUES (" + orderID + ", "
        + month + ", " + day + ", " + quantity + ", " + type + ", " + notes + ")";
  
    var sent = await sqldb.dbquery(insertion);
  });
  
  // catch 404 and forward to error handler
  app.use(function(req, res, next) {
    next(createError(404));
  });
  
  // error handler
  app.use(function(err, req, res, next) {
    // set locals, only providing error in development
    res.locals.message = err.message;
    res.locals.error = req.app.get('env') === 'development' ? err : {};
  
    // render the error page
    res.status(err.status || 500);
    res.render('error');
  });
  
  module.exports = app;
  