Cannery static report prototype

cannery-result.js

require('dotenv').config()
const fs = require('fs')
const {
    Client
} = require('pg')

const dbUri = process.env.DATABASE_URL
const queryName = process.env.QUERY_NAME

const db = new Client({
    connectionString: dbUri
})
db.connect()

fs.readFile('./query_files/' + queryName + '.sql', 'utf8', function (err, data) {
    if (err) throw err
    db.query(data)
        .then(res => {
            fs.writeFile('./public/' + queryName + '.json', JSON.stringify(res.rows), () => {
                console.log('done!')
            })
            db.end()
        })
        .catch(e => console.error(e.stack))
})