gistfile1.txt

app.delete('/api/movies/:id', (req, res) => {
  const movieId = req.params.id;
  connection.promise().query(
    'DELETE FROM movies WHERE id = ?',
    [movieId],)
    .then(result=>res.status(200).send('🎉 Movie deleted!'))
    .catch(err=>{
      console.log(err)
      res.status(500).send('😱 Error deleting an movie')
    })
})