How to show mongodb data as JSON? (NodeJS)

Question

So what I'm asking is how I would show my MongoDB data as JSON on a seprate page? So far I have a database called 'movies' which has a table that contains a bunch of movie titles, rating and stock.

As seen here:

{ "_id" : ObjectId("55e579d30bb58af007d4d8f3"), "movieTitle" : "Iron Man", "rating" : "Excellent", "stock" : "Yes", "sort" : "iron man", "__v" : 0 }
{ "_id" : ObjectId("55e59c3d1d19a3d20ae67a9c"), "movieTitle" : "A Bittersweet Life", "rating" : "Poor", "stock" : "Yes", "sort" : "a bittersweet life", "__v" : 0 }
{ "_id" : ObjectId("55e59c441d19a3d20ae67a9d"), "movieTitle" : "A Team", "rating" : "Okay", "stock" : "No", "sort" : "a team", "__v" : 0 }

I also have the page I want the json to be displayed on:

var express  = require('express');
var mongoose = require('mongoose');
var router   = express.Router();

/* GET home page. */
router.get('/', function(req, res, next) {
  res.render('data', {});
});

module.exports = router;

Schema:

var movieSchema = new Schema({
  movieTitle: {
    type: String,
    required: true
  },
  rating: {
    type: String
  },
  stock: {
    type: String,
    required: true
  },
  sort: {
    type: String
  }
});

Can someone help me out?

Have you registered the model? e.g. mongoose.model('Movie', movieSchema)? — Yuri Zarubin
– Yuri Zarubin, Commented Sep 1, 2015 at 15:29

aquint · Accepted Answer · 2015-09-01 15:29:54Z

1

I think you could do something like this:

var express  = require('express');
var mongoose = require('mongoose');
var router   = express.Router();
var movieSchema = new Schema({
movieTitle: {
    type: String,
    required: true
  },
  rating: {
    type: String
  },
  stock: {
    type: String,
    required: true
  },
  sort: {
    type: String
  }
});
var Movie = mongoose.model('Movie', movieSchema, 'movies');
mongoose.connect('localhost', function(err, res){
})

/* GET home page. */
router.get('/', function(req, res, next) {
  Movie.find({}, function(err, movies) {
    res.render('data', movies);
  })
});
module.exports = router;

answered Sep 1, 2015 at 15:29

aquint

5123 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mmccaff Over a year ago

One small suggestion: skip passing 'movies' to a 'data' view and just res.json(movies);

TheGarrett Over a year ago

Why do I need to include a new schema? I can't get this working, get erros when I do npm start.

TheGarrett · Accepted Answer · 2015-09-02 11:30:12Z

For those who want to see how I got it working:

/* GET home page. */
router.get('/', function(req, res, next) {
  // Get Movie schema for use
  var Movie = mongoose.model('movie');

  // Query all records using aggregate
  Movie
    .aggregate()
    .match({})
    .sort({ sort: 1 })
    .exec(function(err, movies) {
      // Handle errors
      if (err) {
        return res
          .status(500)
          .json({
            error: err
          });
      }

      // Manipulate movies to tidy up keys
      movies.forEach(function (movie) {
        movie.id = movie._id;

        delete movie._id;
        delete movie.__v;
        delete movie.sort;
      });

      return res.json(movies);
    });
});

Collectives™ on Stack Overflow

How to show mongodb data as JSON? (NodeJS)

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related