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

const knex = require('knex')({
    client: 'mysql',
    connection: {
        host: '127.0.0.1',
        user: 'root',
        password: '',
        database: 'tokobuku'
    },
    debug: true
});

app.use(bodyParser.urlencoded({
    extended: true
}));
app.use(bodyParser.json({
    limit: "8mb",
}));

app.get('/', (req, res) => res.send('Hello World!'))


app.get('/buku', async (req, res ) => {
    try {
        let buku = await knex('buku');
        res.json(buku)
    } catch (e) {
        console.log(e);
    }
})

app.post('/buku', async (req, res) => {
    try {
        let judul = req.body.judul;
        let sinopsis = req.body.sinopsis;
        let penulis = req.body.penulis;

        let id = await knex('buku').insert({
            "judul": judul,
            "sinopsis": sinopsis,
            "penulis": penulis
        })
        res.json({
            id: id[0],
            judul,
            sinopsis,
            penulis
        })
    } catch (e) {
        console.log(e);
        next(e)
    }
})

app.put('/buku/:id', async (req, res) => {
    try {
        let id = req.params.id;
        let judul = req.body.judul;
        let sinopsis = req.body.sinopsis;
        let penulis = req.body.penulis;

        await knex('buku').where('id', id).update({
            "judul": judul,
            "sinopsis": sinopsis,
            "penulis": penulis
        })
        res.json({
            id,
            judul,
            sinopsis,
            penulis
        })
    } catch (e) {
        console.log(e);
        next(e)
    }
})

app.delete('/buku/:id', async (req, res) => {
    try {
        let id = req.params.id;

        await knex('buku').where('id', id).del()
        res.json({
            id,
        })
    } catch (e) {
        console.log(e);
        next(e)
    }
})


app.listen(port, () => console.log(`Example app listening on port ${port}!`))