const express = require('express');
const http = require('http');
const massive = require('massive');

const app = express();

massive({
    host: '127.0.0.1',
    port: 5432,
    database: 'pgguide',
    user: 'geo17',
    password: 'geo17'
}).then(instance => {
    app.set('db', instance);

    app.get('/users', (req, res) => {
        req.app.get('db').query("select email, details from users order by created_at desc;")
            .then(items => {
                res.json(items);
            });
    });