server.js

'use strict';

const express = require('express');
const cors = require('cors');
const superagent = require('superagent');

const app=express();
const TOKEN=process.env.TOKEN;
if(!TOKEN) throw new Error('TOKEN missing');

const PORT=process.env.PORT;
if(!PORT){throw new Error('PORT is a ghost');}

app.use(cors());
app.use(express.static('./public'));
/* use these to recieve posts if needed in the furture
app.use(express.json());
app.use(express.urlencoded({extended:true}));
*/

app.get('/',(req,res)=>res.sendFile('index.html'));

app.get('/api/spirit',(req, res)=>{
  var s = req.query.south;
  var n = req.query.north;
  var w = req.query.west;
  var e = req.query.east;
  var query = `
    SELECT row_index,location,longitude, latitude, description
    FROM haunted_places_2
    WHERE latitude BETWEEN ${s} AND ${n}
    AND longitude BETWEEN ${w} AND ${e}
    LIMIT 50
    `;
  superagent.post('https://api.data.world/v0/sql/timothyrenner/haunted-places')
    .set('Authorization',`Bearer ${TOKEN}`)
    .type('form')
    .send({query})
    .then((result)=>{
      res.send(result.body);
    })
    .catch( err=>{
      console.error(err);
      res.sendStatus(500,err);
    });
});

app.get('/api/alien', (req,res)=>{
  var s = req.query.south;
  var n = req.query.north;
  var w = req.query.west;
  var e = req.query.east;
  var query = `
  SELECT row_index,city, city_longitude, city_latitude, text 
  FROM nuforc_reports 
  WHERE city_latitude BETWEEN ${s} AND ${n} 
  AND city_longitude BETWEEN ${w} AND ${e}
  LIMIT 50
  `;
  superagent.post('https://api.data.world/v0/sql/timothyrenner/ufo-sightings')
    .set('Authorization', `Bearer ${TOKEN}`)
    .type('form')
    .send({query})
    .then((result)=>{
      res.send(result.body);
    })
    .catch( err=>{
      console.error(err);
      res.sendStatus(500,err);
    });
});

app.get('/api/bigfoot', (req,res)=>{
  var s = req.query.south;
  var n = req.query.north;
  var w = req.query.west;
  var e = req.query.east;
  var query = `
  SELECT row_index,county, latitude, longitude, observed 
  FROM bfro_reports_geocoded 
  WHERE latitude BETWEEN ${s} AND ${n} 
  AND longitude BETWEEN ${w} AND ${e} 
  LIMIT 50
  `;
  superagent.post('https://api.data.world/v0/sql/timothyrenner/bfro-sightings-data')
    .set('Authorization', `Bearer ${TOKEN}`)
    .type('form')
    .send({query})
    .then((result)=>{
      res.send(result.body);
    })
    .catch( err=>{
      console.error(err);
      res.sendStatus(500,err);
    });
});

app.get('/api/:type/:index',(req,res)=>{
  let apiUrl;
  let table;
  let id = parseInt(req.params.index);
  if(req.params.type==='spirit'){
    apiUrl='https://api.data.world/v0/sql/timothyrenner/haunted-places';
    table='haunted_places_2';
  }
  else if(req.params.type==='alien'){
    apiUrl='https://api.data.world/v0/sql/timothyrenner/ufo-sightings';
    table='nuforc_reports';
  }
  else{
    apiUrl='https://api.data.world/v0/sql/timothyrenner/bfro-sightings-data';
    table='bfro_reports_geocoded';
  }
  superagent.post(apiUrl)
    .set('Authorization', `Bearer ${TOKEN}`)
    .type('form')
    .send({query: `SELECT ${table}.*,row_index FROM ${table} WHERE row_index = '${id}' LIMIT 10`})
    .then((result)=>{
      if(result.body.length){
        res.send(result.body[0]);
      }
      else{
        res.sendStatus(404);
      }
    }, err=>{
      res.sendStatus(500).send(err);
    });
});

app.get('*', (req,res) =>{
  res.sendFile('public/index.html',{root: '.'});
});

app.listen(PORT,()=>console.log('Listening on PORT:'+PORT));