const express = require('express');
const connection = require('./config/conf');
const bodyParser = require('body-parser');

const app = express();
const port = 3000;

// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
app.use(bodyParser.urlencoded({
    extended: true
}));

app.get('/', (request, response) => {
    response.send('Welcome to Express');
});
// listen to the url "/api/employees" with the verb POST
app.put('/api/employees/:id', (req, res) => {

    // Get the data sent
    const idEmployee = req.params.id;
    const formData = req.body;

    // connection to the database, and insertion of the employee
    connection.query('UPDATE employee SET ? WHERE id = ?', [formData, idEmployee], err => {
        if (err) {
            // If an error has occurred, then the user is informed of the error
            console.log(err);
            res.status(500).send("Error editing an employee");
        } else {
            // If everything went well, we send a status "ok".
            res.sendStatus(200);
        }
    });
});

// listen to the url "/api/movies" with the verb POST
app.put('/api/movies/:id', (req, res) => {

    // Get the data sent
    const idMovie = req.params.id;
    const formData = req.body;

    // connection to the database, and insertion of the employee
    connection.query('UPDATE movie SET ? WHERE id = ?', [formData, idMovie], err => {
        if (err) {
            // If an error has occurred, then the user is informed of the error
            console.log(err);
            res.status(500).send("Error editing an employee");
        } else {
            // If everything went well, we send a status "ok".
            res.sendStatus(200);
        }
    });
});

app.listen(port, (err) => {
    if (err) {
        throw new Error('Something bad happened...');
    }

    console.log(`Server is listening on ${port}`);
});