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

app.get('/api/movies', (request, response) => {
    connection.query('SELECT * from movie', (error, results) => {
        if (error) response.status(500).send('Cannot retrieve the data...');
        else response.json(results);
    });
})
.get('/api/movies/names', (request, response) => {
    connection.query('SELECT name from movie', (error, results) => {
        if (error) response.status(500).send('Cannot retrieve the data...');
        else response.json(results);
    });
});

app.listen(port, err => {
    if (err) throw new Error('Impossible to connect...');
});