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 pg = require('pg');
var dotenv = require('dotenv').config();

var indexRouter = require('./routes/index');
var subscriptionsRouter = require('./routes/subscriptions');
var testRouter = require('./routes/test');
var { Channel } = require('./objects/channel');
var { Listener } = require('./objects/channel');
var channels = [];
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('/subscriptions', subscriptionsRouter);
app.use('/test', testRouter);

// 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');
});

function loadAllChannels() {

  const client = new pg.Client({
    user: process.env.PGUSER,
    host: process.env.PGSERVER,
    database: process.env.PGDATABASE,
    password: process.env.PGPASS,
    port: 5432,
  });

  client.connect(function (err) {
    if (err) {
    }
    else {
      var queryString = `select distinct channel from subscriptions;`
      var query = client.query(queryString, function (error, result) {
        if (!error) {
          for (i in result.rows) {
            var c = Object.create(Channel);
            c.init(result.rows[i].channel);
            console.log(c)
            channels.push(c);
          }
        }
        else {

        }

      });
    }
  });

  //return retval;
}
loadAllChannels();
module.exports = app;