.js

const express = require('express')
const app = express() 
const mustacheExpress = require('mustache-express')

// initialize pg promise library
const pgp = require('pg-promise')() 
// location of the database
const connectionString = "postgres://localhost:5432/tripsdb"
// create a db object based on the connection string 
const db = pgp(connectionString)

// tell express to use mustache templating engine
app.engine('mustache',mustacheExpress())
// the pages are located in views directory
app.set('views','./views')
// extension will be .mustache
app.set('view engine','mustache')

// display all trips 
app.get('/trips',(req,res) => {

    // access the database 
    db.any('SELECT trip_id,name from trips;').then(results => {
        res.render('index',{trips: results})
    })

})


app.listen(3000,() => {
    console.log('Server is running...')
})