server.js

var express = require('express');
var db = require('./db/db-config.js');
var requestProxy = require('express-request-proxy');
var app = express();
var apiProxy = require('./api-proxy.js');

var queryDB = function (req, res) {
  var table = 'politicians';
  var q = req.query.query === undefined ? '*' : req.query.query;
  var query = 'SELECT ' + q + ' FROM ' + table;

  db.connect().query(query, function (err, data) {
    if (err) {
      console.log('ERROR:: ' + JSON.stringify(err));
      res.sendStatus(500);
    }

    res.status(200).send(data);
  });
};

app.get('/database/', queryDB);
app.get('/sunlight_congress/*', apiProxy.proxySunlightCongress);
app.get('/sunlight_states/*', apiProxy.proxySunlightStates);
app.get('/sunlight_finance/*', apiProxy.proxySunlightFinance);
app.get('/opensecrets/*', apiProxy.proxyOpenSecrets);
app.get('/nyt_api/*', apiProxy.proxyNewYorkTimes);

app.use(express.static('public/'));

app.get('/*', function (request, response) {
  console.log('New request:', request.url);
  response.sendFile('index.html', { root: './public/' });
});

var server = app.listen(process.env.PORT || 3000, function () {
  console.log('Server is listening on port %s', server.address().port);
});