routes.js

const express = require('express')
const routes = express.Router()

// show all registers
routes.get('/', (req, res)=>{
    req.getConnection((err, conn) => {
        if(err) return res.send(err)

        conn.query('SELECT * FROM books', (err, rows)=>{
            if(err) return res.send(err)

            res.json(rows)
        })
    })
})

// show only register
routes.get('/:id', (req, res)=>{
    req.getConnection((err, conn) => {
        if(err) return res.send(err)

        conn.query('SELECT * FROM books WHERE id = ?',[req.params.id], (err, rows)=>{
            if(err) return res.send(err)

            res.json(rows)
        })
    })
})

// add registers
routes.post('/', (req, res)=>{
    req.getConnection((err, conn) => {
        if(err) return res.send(err)
        // console.log(req.body)
        conn.query('INSERT INTO books SET ?', [req.body], (err, rows)=>{
            if(err) return res.send(err)

            res.send('book inserted')
        })
    })
})

// delete registers
routes.delete('/:id', (req, res)=>{
    req.getConnection((err, conn) => {
        if(err) return res.send(err)
        // console.log(req.body)
        conn.query('DELETE FROM books WHERE id = ?', [req.params.id], (err, rows)=>{
            if(err) return res.send(err)

            res.send('book deleted')
        })
    })
})

// update registers
routes.put('/:id', (req, res)=>{
    req.getConnection((err, conn) => {
        if(err) return res.send(err)
        // console.log(req.body)
        conn.query('UPDATE books SET ? WHERE id = ?', [req.body, req.params.id], (err, rows)=>{
            if(err) return res.send(err)

            res.send('book updated')
        })
    })
})

module.exports = routes