Advertisement
stevebekaert

Express EX2 Routes

Nov 25th, 2019
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. const con = require('./config');
  2.  
  3. let express = require('express');
  4. let app = express();
  5. const port = 3000;
  6.  
  7. app.get('/api/movies', (req, res) => {
  8. con.query("SELECT * from movie", (err, results) => {
  9. if (err) {
  10. res.status(500).send("Fatal error while requesting");
  11. } else {
  12. res.json(results);
  13. }
  14. })
  15. })
  16.  
  17. app.get('/api/movies/names', (req, res) => {
  18. con.query("SELECT name from movie", (err, results) => {
  19. if (err) {
  20. res.status(500).send("Fatal error while requesting");
  21. } else {
  22. res.json(results);
  23. }
  24. })
  25. })
  26.  
  27. app.listen(port, err => {
  28. if (err) {
  29. throw new Error('Something wrong')
  30. }
  31. console.log(`Server is listening on ${port}`);
  32. })
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement