Quest Express 2

express.js

const express = require('express');
const app = express();
const port = 3000;
// para importar la cofiguración de la BD
const connection = require('./conf');



app.get('/api/movie', (req, res) => {
  // SELECT * FROM movies
  
 connection.query('SELECT * from movie', (err, results) => {
   if (err) {
     res.status(500).send('Error retrieving movies');
   } else {
     res.json(results);
   }
   
 });

});


app.get('/api/movie/name', (req, res) => {
  // SELECT name FROM movies
 let sql = 'SELECT name  from movie';
 
 connection.query(sql, (err, results) => {
   if (err) {
     res.status(500).send('Error retrieving movies');
   } else {
     res.json(results);
   }
   
 });
});

   

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

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