poopy butt

const pg = require('pg')
const path = require('path')
const express = require('express')
const exphbs = require('express-handlebars')
const app = express()
const bodyParser = require('body-parser')


const Pool = require('pg-pool');
const config = {
  user: 'postgres',
  password: '1234',
  host: 'localhost',
  port: '3000',
  database: 'board',
  ssl: true
};
const pool = new Pool(config);

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

app.set('view engine', '.hbs')
app.set('views', path.join(__dirname, 'views'))

app.use((err, request, response, next) => {
  // log the error, for now just console.log
    console.log(err)
    response.status(500).send('Something broke!')
})

app.engine('.hbs', exphbs({
    defaultLayout: 'main',
    extname: '.hbs',
    layoutsDir: path.join(__dirname, 'views/layouts')
}))

app.get('/', (req, res) => {
//  var title = $.find('title').text();
    console.log('fuck');
   // console.log(title);
  pool.connect((err, client, done) => {
       client.query('SELECT * from posts', function (err, res) {
         console.log(res.rows[0].name) // brianc
       })
  })

})

app.listen(3000)