const express = require('express'),
    mysql = require('mysql'),
    myConnection = require('express-myconnection'),
    dbOptions = {
        host: 'localhost',
        user: 'root',
        password: 'root',
        port: '8889',
        database: 'mini_game'
    };

const app = express();

// settings
app.set('port', 3001);


// middlewares
app.use(myConnection(mysql, dbOptions, 'single'));
app.use(express.urlencoded({extended: false}));

// routes
app.get('/', (req, res) => {
    res.send('Bienvenue !!!');
});


app.get('/api/movies', (req, res) => {
    connection.query('SELECT * FROM movie', (err, results) => {
        if (err) {
            res.status(500).send('Erreur lors de la récupération des films');
        } else {
            res.json(results)
        }
    })
});

app.get('/api/movies/names', (req, res) => {
    connection.query('SELECT name FROM movie', (err, results) => {
        if (err) {
            res.status(500).send('Erreur lors de la récupération des nom de films');
        } else {
            res.json(results)
        }
    })
});

/// catch 404 and forward to error handler
app.use(function (req, res, next) {
    const err = new Error('404 Not Found');
    err.status = 404;
    next(err);
});

// starting the server
app.listen(app.get('port'), () => {
    console.log(`server on port ${app.get('port')}`);
});