const express = require('express')
const massive = require('massive')
const app = express()
const port = 3000

var bodyParser = require('body-parser')
app.use( bodyParser.json() );       // to support JSON-encoded bodies
app.use(bodyParser.urlencoded({     // to support URL-encoded bodies
  extended: true
}));
app.use(express.json());       // to support JSON-encoded bodies
app.use(express.urlencoded()); // to support URL-encoded bodies


massive({
  host: 'localhost',
  port: 5432,
  database: 'pgguide',
  user: 'postgres',
  password: 'password'
}).then(instance => {
        app.set('db', instance);
        app.get('/login', (req, res) => {
                if (req.query.user && req.query.password) {
                        query = "SELECT password = crypt('" + req.query.password + "', password) FROM account WHERE username='" + req.query.user + "';"

                        req.app.get('db').query(query).then(result => {
                                if(result[0]['?column?'] == true) {
                                        res.send('logged in');
                                } else {
                                        res.send('invalid login');
                                }
                        });


                } else {
                        res.send('Please provide a user and password');
                }
                //query = 'select email, details from users ORDER BY created_at DESC'

                //req.app.get('db').query(query).then(users => {
                //      console.log(req.query.id)
                //      // console.log(users);
                //      res.json(users);
                //});

        });

        app.post('/register', function (req, res) {
                if (req.body.user && req.body.password) {
                        query = "INSERT INTO account (username, password) VALUES ('" + req.body.user + "', crypt('" + req.body.password + "', gen_salt('md5')));";
                        console.log(query);
                        req.app.get('db').query(query).then(() => {
                                res.send('registered');
                        });
                } else {
                        res.send('Please provide a user and password');
                }
        })


        app.listen(port, () => console.log("Example app listening on port ${port}!"));
});