ODYSSEY_EXPRESS_DELETE

conf.js

const mysql = require('mysql');

const connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: process.env['SQLPASSWORD'],
    database: 'my_db',
})
module.exports = connection;

index.js

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


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



app.delete('/api/movies/:id', (req, res) => {
    const movieId = req.params.id;
    connection.query('DELETE FROM movie WHERE id = ?', [movieId], err => {
        if (err) {
            res.status(500).send(`Error deleting the movie: ${err}`);
        } else {
            res.status(200).send(`Movie with id ${movieId} successfully deleted from database.`)
        }
    });
});

app.listen(3000, (err) => {
    if (err) {
        throw new Error(`Something bad happened: ${err}`)
    }
    console.log(`Server is listening on ${3000}`);
})