app.js

const express = require('express');
const cookieParser = require('cookie-parser');
const path = require('path')
const logger = require('morgan');
const session = require('express-session');
const sql = require('mssql');
const moment = require('moment');
const { StatusCodes } = require('http-status-codes');


require('dotenv').config();
const sqlConfig = {
  user: process.env.DB_USER_ADMIN,
  password: process.env.DB_PASS_ADMIN,
  database: 'pg_database',
  server: 'localhost',
  pool: {
    max: 10,
    min: 0,
    idleTimeoutMillis: 30000
  },
  options: {
    encrypt: true, // for azure
    trustServerCertificate: true // change to true for local dev / self-signed certs
  }
};
const connect = async () => {
  try {
    // make sure that any items are correctly URL encoded in the connection string
    await sql.connect(sqlConfig);
  } catch (err) {
    console.log(err.message);
  }
};
// routes
const loginRoute = require('./routes/login');
const registerRoute = require('./routes/register');
const adminRoute = require('./routes/admin');
const studentRoute = require('./routes/student');
const supervisorRoute = require('./routes/supervisor');
const examinerRoute = require('./routes/examiner');
const logoutRoute = require('./routes/logout');
const addMobileRoute = require('./routes/addMobile')


const app = express();

// view engine setup
app.use(
  session({
    secret: 'keyboard cat',
    resave: false,
    saveUninitialized: true
  })
);
app.set('view engine', 'ejs');
app.use(logger('dev'));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static('public'));
app.use('/', express.static(path.join(__dirname + 'public')));

app.use('/', loginRoute);
app.use('/register', registerRoute);
app.use('/logout', logoutRoute);
app.use('/admin', adminRoute);
app.use('/student', studentRoute);
app.use('/supervisor', supervisorRoute);
app.use('/examiner', examinerRoute);
app.use('/addMobile',addMobileRoute)




app.use((req, res) => {
  res.status(StatusCodes.NOT_FOUND).render('error', {
    title: '404 NOT FOUND',
    message: 'Error 404 : Page Not Found'
  });

});

app.locals = {
  app: app,
  toastState: '',
  toastMessage: '',
  moment: moment
};

const port = process.env.PORT || 4000;
app.listen(
  port,
  connect().then(() => {
    console.log(`Server started on port ${port}`);
  })
);