Cannot read from database using mongoose

Question

This is my GET request

var Catalog = mongoose.model('Catalog');
router.get('/catalog', function(req, res, next) {
  Catalog.find(function(err, items){
    if(err){
      return next(err);
    }
    console.log(items);
    res.json(items);
  });
});

The model

var mongoose = require('mongoose');

var CatalogSchema = new mongoose.Schema({
    title: String,
    cost: String,
    description: String
});

mongoose.model('Catalog', CatalogSchema);

The console.log gives me a [] but there is a collection named Catalog with the parameters filled.

robertklep · Accepted Answer · 2016-05-20 20:25:52Z

2

If you have an existing collection, created outside of Mongoose, that you wish to query you need to configure your model to use that collection.

Otherwise, Mongoose will use a utility function to create a collection name by pluralizing and lowercasing the model name (which in your case would become catalogs).

To use Catalog as a collection, use the collection option:

var CatalogSchema = new mongoose.Schema({
  title: String,
  cost: String,
  description: String
}, { collection : 'Catalog' });

answered May 20, 2016 at 20:25

robertklep

205k38 gold badges421 silver badges413 bronze badges

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

1 Comment

traveller Over a year ago

Thank you, you were right. I created the collection outside Mongoose and now I can query it!

S M Hasan Mansur · Accepted Answer · 2016-05-20 20:18:50Z

0

you might check again the collection name in mongodb i.e whether it is 'Catalog' or 'Catalogs'. In my experience I found that if you name the model 'Catalog', then either mongoose creates the collection with a name 'Catalogs' if it is not already there or you have to create the collection first with a name 'Catalogs'.
You might check the following line also:

Catalog.find({}, function(err, items){ // your code goes here }

Hope it helps..

answered May 20, 2016 at 20:18

S M Hasan Mansur

463 bronze badges

Collectives™ on Stack Overflow

Cannot read from database using mongoose

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related