Created
December 1, 2019 17:54
-
-
Save angelique-w/6d1b2ad42622481dca7bb196391a1e75 to your computer and use it in GitHub Desktop.
quest express 2
This file contains 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 express = require('express'); | |
const app = express(); | |
const port = 3000; | |
const connection = require('./conf'); | |
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 noms de films'); | |
} else { | |
res.json(results); | |
} | |
}); | |
}); | |
app.listen(port, (err) => { | |
if (err) { | |
throw new Error('Sometthing bad happened...'); | |
} | |
console.log(`Server is listening on ${port}`); | |
}) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment