server.js

var express = require('express');
var app = express();
var pg = require('pg');
var bodyParser = require('body-parser');


app.set('port', (process.env.PORT || 5000));

app.use(express.static(__dirname + '/client')); //public
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: true }));



// views is directory for all template files
app.set('views', __dirname + '/client/views');
app.set('view engine', 'ejs');

app.get('/', function(request, response) {
  response.render('pages/index')
});

app.get('/report', function(request, response){
  response.render('pages/guidelines')
})

app.get('/map', function(request, response){
    response.render('pages/mapview')
})


//test form submission for single variable entry to db
app.route('/test')
  .get(function(request, response){
    response.render('pages/test')
  })
  .post(function(request, response){
    var name = request.body.name;
    pg.connect(process.env.DATABASE_URL, function(err, client, done){
      client.query('INSERT INTO test_table(name) VALUES ($1)', [name], function(err, result) {
        done();
        if (err)
        { console.error(err); response.send("oops errrrr "); }
        else
        { response.redirect('/posts'); } //redirect to sumbissions
      });
    })
  });


//submissions of lost and seen snakes
app.route('/lost')
  .get(function(request, response){
    response.render('pages/lost')
  })
  .post(function(request, response){
    var species = request.body.snake_species;
    var owner = request.body.owner_name;
    var snake = request.body.snake_name;
    var phone = request.body.contact_phone;
    var email = request.body.contact_email;
    var lat = request.body.latitude;
    var long = request.body.longitude;
    pg.connect(process.env.DATABASE_URL, function(err, client, done){
      client.query('INSERT INTO lost(snake_species_common, owner_name, snake_name, contact_phone, contact_email, location) VALUES ($1, $2, $3, $4, $5, point($6, $7))', 
        [species, owner, snake, phone, email, lat, long], function(err, result) {
        done();
        if (err)
        { console.error(err); response.send("oops errrrr"); }
        else
        { response.redirect('/posts'); } //redirect to confirmation of submission
      });
    })
});

app.route('/seen')
  .get(function(request, response){
    response.render('pages/seen')
  })
  .post(function(request, response){
    var name = request.body.name;
    pg.connect(process.env.DATABASE_URL, function(err, client, done){
      client.query('INSERT INTO test_table(name) VALUES ($1)', [name], function(err, result) {
        done();
        if (err)
        { console.error(err); response.send("oops errrrr"); }
        else
        { response.redirect('/sightings'); } //redirect to confirmation of submission
      });
    })
});


// requests from database for all snake, lost, and sighted tables
app.get('/snake', function (request, response) {
  pg.connect(process.env.DATABASE_URL, function(err, client, done) {
    if (err)
       { console.error(err); response.send("oops errrrr "); }
    client.query('SELECT * FROM snake', function(err, result) {
      done();
      if (err)
       { console.error(err); response.send("oops errrrr "); }
      else
       { response.render('pages/snake', {results: result.rows} ); }
    });
  });
})

app.get('/sightings', function (request, response) {
  pg.connect(process.env.DATABASE_URL, function(err, client, done) {
    if (err)
       { console.error(err); response.send("oops errrrr "); }
    client.query('SELECT * FROM test_table', function(err, result) {
      done();
      if (err)
       { console.error(err); response.send("oops errrrr "); }
      else
       { response.render('pages/sightings', {results: result.rows} ); }
    });
  });
})

app.get('/posts', function (request, response) {
  pg.connect(process.env.DATABASE_URL, function(err, client, done) {
    if (err)
       { console.error(err); response.send("Error " + err); }
    client.query('SELECT * FROM lost', function(err, result) {
      done();
      if (err)
       { console.error(err); response.send("Error " + err); }
      else
       { response.render('pages/posts', {results: result.rows} ); }
    });
  });
})


app.listen(app.get('port'), function() {
  console.log('Node app is running on port', app.get('port'));
});