app.js

#!/usr/bin/env nodejs

require('dotenv').config()

const express = require('express')
const app = express()
const port = process.env.PORT
const bodyParser = require('body-parser')
const fs = require('fs')
const uuidv4 = require('uuid/v4')
const { Client } = require('pg')

app.set('view engine', 'pug')
app.set('views', './views')

app.use(express.static('public'))
app.use(bodyParser.urlencoded({limit: '5mb'}))

app.get('/', (req, res) => {
    res.render('index')
})

app.get('/images', (req, res) => {
    const client = new Client({
        database: process.env.DATABASE,
        host: 'localhost',
        user: process.env.POSTGRES_USER,
        password: process.env.POSTGRES_PASSWORD,
        port: process.env.DBPORT
    })


    client.connect().catch(err => console.log('Error:', err))

    client.query('SELECT image FROM complaints')
    .then(result => {
        res.render('images', {images: result.rows})
    })
    .catch(err => console.log(err))
})

app.get('/posted', (req, res) => {
    res.render('posted')
})

app.post('/post', (req, res) => {
    console.log('reached')
    const client = new Client({
        database: process.env.DATABASE,
        host: 'localhost',
        user: process.env.POSTGRES_USER,
        password: process.env.POSTGRES_PASSWORD,
        port: process.env.DBPORT
    })

    client.connect().catch(err => console.log('Error:', err))

    var base64Data = req.body.image.replace(/^data:image\/png;base64,/, "");

    var name = uuidv4()

    fs.writeFile(`public/images/${name}.png`, base64Data, 'base64', function(err) {
        if (err) console.log('Error:', err)
    })

    client.query(`INSERT INTO complaints (name, postcode, image, email) VALUES ('${req.body.name}', '${req.body.postcode}', '${name}', '${req.body.email}')`)
    .catch(err => console.log('Error:', err))

    res.status(200).send({message: 'Posted!'})
})

app.listen(port, () => {
    console.log(`Listening on port ${port}`)
})