const express = require('express');
const parser = require('body-parser');
const app = express();

const mongodb = require('mongodb')
const client = mongodb.MongoClient;
var url = "mongodb://localhost:27017/crudwebappdb";

app.use(parser.urlencoded({extended:true}))
app.get('/test', (req, res) => {
  res.send('Test Test');
});

client.connect(url, (err, con) => {
  if (err) throw err;
  console.log("Database ชื่อ crudwebappdb สร้างแล้วเด้อ!");
  app.get('/', (req, res) => {
    console.log(db.collection('quotes').find());
    res.sendFile(__dirname+'/index.html');
  });
  let db = con.db('crudwebappdb');
  app.post('/quotes', (req, res) => {
    console.log(req.body); 
    db.collection('quotes').insertOne(req.body, (err, result) => {
      if (err) return console.log(err)
      console.log(`บันทึก ${req.body} ไปที่ database แล้ว`)
      res.redirect('/')
    })
  });
  app.listen(8000, function() {
    console.log("เริ่มละนะ ");
  });

  //con.close();
});