const express = require('express');
const bodyParser= require('body-parser')
const mongodb = require('mongodb')
var db
const dbname = 'user';
const url = 'mongodb://user:pass@172.20.44.30/user';
  
const app = express();
//app.use(bodyParser.json());
//app.use(bodyParser.urlencoded({extended: true}))

// create application/json parser
const jsonParser = bodyParser.json()
// create application/x-www-form-urlencoded parser
const urlencodedParser = bodyParser.urlencoded()
  
mongodb.MongoClient.connect(url, function(err, client) {
  if (err) return console.log(err)
  db = client.db(dbname);
  console.log('Connect OK');
})
  
app.listen(4100,function() {
   console.log('listening on 4100')
})
  
app.get('/', function(req,res) {
  res.send('Aplikacja CRUD - node.js')
})
  
app.get('/form', function(req,res) {
  res.sendFile(__dirname + '/form.html')
})
  
app.post('/stud', urlencodedParser, function( req,res ) {
   console.log(req.body)
   db.collection('stud').insertOne(req.body,function(err,result) {
      if (err) return console.log(err)
      console.log('Rekord dodany do bazy')
      res.end('{"inserted record":"'+result.insertedCount+'"}')
   })
})

app.post('/stud2', jsonParser, function( req,res ) {
   console.log(JSON.stringify(req.body))
   db.collection('stud').insertOne(req.body,function(err,result) {
      if (err) return console.log(err)
      console.log('Rekord dodany do bazy')
      res.end('{"inserted record":"'+result.insertedCount+'"}')
   })
})
  
app.get('/stud', function(req, res) {
  var cursor = db.collection('stud').find().toArray(function(err, results) {
     if (err) return console.log(err)
     res.end(JSON.stringify(results))
     console.log(results) 
  })
})
 
app.get('/stud/:id', function(req,res) {
   console.log(req.params.id)
   db.collection('stud').findOne({_id: new mongodb.ObjectId(req.params.id)},function(err,result) {
       if (err) return console.log(err)
       res.end(JSON.stringify(result))
       console.log(result)
   })      
})