How to print mongoose find() array docs in console

Question

I'm trying to use mongodb with node.js using Mongoose ODM.

I've written some sample code which is given below:

Sample Code -

/*!
 * mongoose.js
 * 
 * Getting Started
 */ 

var mongoose = require('mongoose');
var Schema = mongoose.Schema;

var db = mongoose.connect('mongodb://localhost/trymongo').connection;
db.on('error', console.error.bind(console, 'connection error:'));
db.once('open', function() {
  console.log("Connected to database");  // we're connected!
  
  // create schemas
  var SubjectSchema = new Schema({
    name: {
        type: String,
        required: true
    },
    teacher: {
        type: String
    }
  },
  {
    collection: 'subjects'
  });

  // create a model
  var Subject = mongoose.model('Subject', SubjectSchema);
  
  var arr = [{ name: 'Computer Programming', teacher: 'M. Swaminathan' }, { name: 'History' }];
  Subject.insertMany(arr, function(err) {
    if (err) throw err;
    
    console.log('Multiple subjects created!');

    // get all the subjects
    Subject.find({}, function(err, subjects) {
        if (err) throw err;
                
        console.log(subjects);
    });
  });
});

I want to print subjects in console using console.log() returned by mongoose model but it only prints like this -

[ [object Object], [object Object] ]

I've also tried with console.dir() but result is same as above.

Yerken · Accepted Answer · 2016-05-03 08:47:37Z

1

Use console.log(JSON.stringify(subjects, null, 4))

More about JSON.stringify

answered May 3, 2016 at 8:47

Yerken

1,9421 gold badge14 silver badges18 bronze badges

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

1 Comment

robertklep Over a year ago

Or console.log('%j', subjects) if you're okay with unindented JSON.

qolu · Accepted Answer · 2023-08-21 21:12:20Z

I've just started learning Mongoose and found this question while facing the same problem now over 7 years after it was originally posted. I was finally able to figure out how to print the docs queried by a .find() to terminal for Mongoose version 7.0, which probably isn't helpful in regards to the original post, but I figured I would share for the benefit of anyone stumbling upon this question onwards of 2023.

const uri = "mongodb+srv://<user>:<password>@cluster0.xxxxxxx.mongodb.net/fruitDB?retryWrites=true&w=majority";
const mongoose = require("mongoose");
mongoose.connect(uri);

const fruitSchema = new mongoose.Schema ({
  key: value,
  key: value
});

const Fruit = mongoose.model("Fruit", fruitSchema);

Fruit.find({}).then((data) => {
  console.log(data);
}).finally(() => {
  mongoose.connection.close();
});

You need to resolve the promise returned by the .find() call --- if you try to console.log() the result before it's resolved then it will print the query object to the terminal. If you console.log() the result inside an anonymous function after appending .then() you ensure that the .find() promise has been resolved before proceeding and you print the resulting array of doc objects as intended.

I apologize if anything I've said is outright wrong, I do not have very much experience coding yet.

armusiq · Accepted Answer · 2024-02-25 15:19:11Z

0

just in case for those who are struggling to console log only the names of the fruits :

  Fruit.find()
  .then((fruits) => {
    fruits.forEach((fruits) => {
      console.log('Names of fruits:', fruits.name);
    });
  })
  .catch((error) => {
    console.error('Error retrieving documents:', error);
  }).finally(()=> {
    mongoose.connection.close();
  });

answered Feb 25, 2024 at 15:19

armusiq

1

Collectives™ on Stack Overflow

How to print mongoose find() array docs in console

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related