Class 7

Class 7 - Express

//Basic Connection to DB:

const pg = require ('pg');
require ('dotenv').config(); //DB Configuration:
const client = new pg.client('postgres://...') // connect to DB
client. connect (); // Handle Middleware:
const superagent = require ('superagent');
app.use (express.urlencoded({extended:true})); // Set-up view engine:
app.set('view engine','ejs'); // Error Management -- Catch-all route for any request that isn't defined e.g., send 404:
app.get('*',(req,res)=>res.status(404).send('not found')); // Create route shell/application routes:
app.get('/',getTasks);
function getTasks(request,response){ let SQL='SELECT*from tasks'; // Give data to showcase its rendering:
return client.query(SQL)
.then(results=>response.render('index'),{results:results.row}))
.catch(err=>console.error(err));