Advertisement
Guest User

Untitled

a guest
Feb 19th, 2016
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. var express = require('express');
  2. var router = express.Router();
  3. var articles = require('../model/articles.js');
  4.  
  5. router.get('/all', function(req, res, next) {
  6. res.json(articles.getAll());
  7. console.log( "From route: " + articles.getAll());
  8. });
  9. module.exports = router;
  10.  
  11. var mysql = require("mysql");
  12. var con = mysql.createConnection({
  13. host: "localhost",
  14. user: "rest_news",
  15. password: "rest_news",
  16. database: "rest_news"
  17. });
  18. exports.getAll = function () {
  19. con.query('SELECT * FROM articles', function(err, rows){
  20. if(err) {
  21. return err;
  22. } else {
  23. console.log("From model: " + rows);
  24. return rows;
  25. }
  26. });
  27. };
  28.  
  29. From route: undefined
  30. GET /article/all 200 22.802 ms - -
  31. From model: [object Object],[object Object]
  32. From model: [object Object],[object Object]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement