const express = require("express");
const { Pool } = require("pg");
const dotenv = require("dotenv");

dotenv.config();

// Conncet to DATABASE_URL from .env file
const pool = new Pool({
  connectionString: process.env.DATABASE_URL
});

pool.on("connect", () => {
  console.log("connected to the db");
});

const app = express();

app.use(express.json());

// Get route
app.get("/api", (req, res) => {
  // pg connect
  pool.connect((err, client, done) => {
    client.query('SELECT * FROM activities')
    .then(res => console.log('Success..'))
    .catch(err => console.error(err.stack))

    done();
    res.send(200);
  });
  // pool shutdown
  pool.end();

  // return res.status(200).send({ message: "Congratulations! You connected to postgres" });
});

// /api POST
app.post('/api/add', (req, res) => {
  // pg connect
  pool.connect((err, client, done) => {
    client.query('INSERT INTO activities(activity, undone, done) VALUES("laundry", "yes", "no"')
    .then(res => console.log('Items added..'))
    .catch(err => console.error(err.stack))

    done();
    res.redirect('/api');
  });
  // pool shutdown
  pool.end();

  return res.status(200).send({ message: "Congratulations! made a post request to postgres" });
});

//  /api DELETE
app.delete('/delete/:id', (req, res) => {
  // pg connect
  pool.connect((err, client, done) => {
    client.query('DELETE FROM activities WHERE done = "yes"')
    .then(res => console.log('Items delted..'))
    .catch(err => console.error(err.stack))

    done();
    res.send(200);
  });
// pool shutdown
pool.end();
});

// api/ edit
app.post('/api/edit', (req, res) => {
  // pg connect
  pool.connect((err, client, done) => {
    client.query('UPDATE activites SET activity = Cook , undone = no, done = yes WHERE activity = "laundry"')
    .then(res => console.log('Items updated..'))
    .catch(err => console.error(err.stack))

    done();
    res.redirect('/api');
  });
  // pool shutdown
  pool.end();
});

// Server listen
app.listen(5000, () => {
  console.log("app running on port 5000");
});