Express5

const express = require('express')
const connection = require('./conf')
const app = express()
const port = 8080

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

app.delete('/api/movies/:id', (req, res) => {
  const idMovie = req.params.id
  connection.query('DELETE FROM movie WHERE id = ?', [idMovie], err => {
    if (err) {
      res.status(500).send('Erreur lors de la suppression d\'un film')
    } else {
      res.sendStatus(200)
    }
  })
})

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