Cacher is the code snippet organizer for pro developers

const express = require('express');
const app = express();
const port = 3000;


const {connection} = require('./conf')

const bodyParser = require('body-parser');
// Support JSON-encoded bodies
app.use(bodyParser.json());
// Support URL-encoded bodies
app.use(bodyParser.urlencoded({
  extended: true
}));

connection.connect(function(err){
    app.get('/', (request, response) => {
        connection.query('SELECT * FROM movie;', function(err, result){
            if(err) throw err

            response.json({result});
        })})




        
    app.get('/api/movies', (request, response) => {
        connection.query('SELECT * FROM movie;', function(err, result){
            if(err) throw err

            response.send({result});
        })})
        app.get('/api/movies/names', (request, response) => {
            connection.query('SELECT name FROM movie;', function(err, result){
                if(err) throw err
    
                response.send({result});
            })})


    app.get('/api/movies/:id', (request, response) => {
        const id = request.params.id;
        connection.query('SELECT * FROM movie WHERE id=?',id, function(err, result){
            if(err) throw err

            response.json({result}) 
        })})


    app.get('/api/employee', (request, response) => {
        connection.query('SELECT * FROM employee;', function(err, result){
            if(err) throw err
            if(request.query.name)
            {response.status(404).send('dnif uoy hcraes uoy fi') 
            }else{response.sendStatus(304) }
        })})



// méthode post


app.post('/api/movies', (request, response) => {

   const formData = request.body;
  
    connection.query('INSERT INTO movie SET ?', formData, (err, results) => {
  
      if (err) {console.log(err);
        response.status(500).send("Erreur lors de la sauvegarde d'un film");
      } else {
       response.sendStatus(200);
      }
    });
  }); 



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

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