Created
November 19, 2019 11:08
-
-
Save BastienSaulnier/4168c5abdb4e6b973c19594b7738e8ee to your computer and use it in GitHub Desktop.
02 - express Wild Code School
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
const connection = require("./conf"); | |
const express = require("express"); | |
const app = express(); | |
const port = process.env.PORT || 3000; | |
app.get("/api/movies", (req, res) => { | |
// TODO récupération des données (étape 2) | |
connection.query("SELECT * FROM movie", (err, results) => { | |
// TODO envoyer les données récupérées (étape 3) | |
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) => { | |
// TODO récupération des données (étape 2) | |
connection.query("SELECT name FROM movie", (err, results) => { | |
// TODO envoyer les données récupérées (étape 3) | |
if (err) { | |
res.status(500).send("Erreur lors de la récupération des films"); | |
} else { | |
res.json(results); | |
} | |
}); | |
}); | |
//PORT | |
app.listen(port, err => { | |
if (err) { | |
throw new Error("Quelque chose ne s'est pas passé come prévu !"); | |
} | |
console.log(`Server listening to port ${port}...`); | |
}); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment