Delete WCS

const con = require('./config');

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

app.use(bodyParser.json());
app.use(bodyParser.urlencoded({extended: true}));

app.get('/', (req, res) => {
    res.send('Welcome');
})

app.get('/api/employees', (req, res) => {
    con.query("SELECT * FROM employee", (err, results) => {
    if (err) {
        res.status(500).send('Error retrieving employees');
      } else {
        res.json(results);
      }
    })
})

app.get('/api/movies', (req, res) => {
    con.query("SELECT * from movie", (err, results) => {
        if (err) {
            res.status(500).send("Fatal error while requesting");
        } else {
            res.json(results);
        }
    })
})

app.get('/api/movies/names', (req, res) => {
    con.query("SELECT name from movie", (err, results) => {
        if (err) {
            res.status(500).send("Fatal error while requesting");
        } else {
            res.json(results);
        }
    })
})

app.post('/api/post/movie', (req, res) => {
    const formData = {
        name: "Me",
        poster: "dsqdf",
        comment: "fdsfsdfs"
    }
    con.query('INSERT INTO movie SET ?', formData, (err, results) => {
        if (err) {
            console.log(err);
            res.status(500).send("Error saving a movie");
          } else {
            res.sendStatus(200);
          }
      })
})

app.put('/api/put/movie/:id', (req, res) => {
    const movieId = req.params.id;
    //Thiis one and make the object commentary if something is really sent to the server
    //const formData = req.body;
    const formData = {
        name: "Updated movie",
        poster: "link to updated URL",
        comment: "An updated comment for the updated movie"
    }

    con.query ('UPDATE movie SET ? WHERE id=?', [formData, movieId], (err, result) => {
        if (err) {
            console.log(err);
            res.status(500).send("An error occured while updating the data");
        } else {
            res.status(200).send(`Movie with id ${movieId} updated !`);
        }
    })
})

app.delete('/api/delete/movie/:id', (req, res) => {
    const movieId = req.params.id;
    con.query("DELETE FROM movie WHERE id = ?", [movieId], err => {
        if (err) {
            res.status(500).send('An unexpected error occured while deleting the data.')
        } else  {
            res.status(200).send(`${movieId} has been deleted.` )
        }
    })
})

app.listen(port, err => {
    if (err) {
        throw new Error('Something wrong')
    }
    console.log(`Server is listening on ${port}`);
})