// load our app server using express somehow...
const express = require('express')
const app = express()
const morgan = require('morgan')
const mysql = require('mysql')

app.use(morgan('combined'))

app.get('/users/:id', (req, res) => {
  console.log("Fetching user with id: " + req.params.id)

  const connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    database: 'dbRestApi',
    password: '973f192g846'
  })

  connection.query("SELECT * FROM users", (err, rows, fields) =>{
    console.log("I think we fetched users succeesfully")
    res.json(rows)
  })

  //res.end()
})



app.get("/", (req, res) => {
  console.log("Responding to rook route")
  res.send("Hello from ROOT")
})

app.get("/users", (req, res) => {
  var user1 = {firstName: "Tymek", lastName: "Sala"}
  const user2 = {firstName: "Kuba", lastName: "C"}
  res.json([user1, user2])
})

// localhost:3003
app.listen(3306, () => {
  console.log("Server is up and listeing on 3003...")
})


// nodejs comends
// npm init, node app.js, nodemon app.js, sudo npm i -g nodemon, npm install express