const express = require('express');
const connexion = require('./conf');
const app = express();
const port = 3000;

app.get('/api/movies',(request,response) => {
    connexion.query('SELECT * FROM movie', (err,results) => {
        if (err) {
            response.status(500).send('Impossible de récupérer les films');
        } else {
            response.json(results);
        }
    })
});

app.get('/api/movies/names', (request,response) =>{
    connexion.query('SELECT name FROM movie', (err,results) => {
        if(err) {
            response.status(500).send('Impossible de récupérer les noms des films');
        } else {
            response.json(results);
        }
    })
});

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