How to run multiple `find()` queries in mongodb using Node.js and Mongoose

Question

I have an array of objects like following

[
  {
    grade: "Grade1",
    subject: "Subject1"
  },
  {
    grade: "Grade2",
    subject: "Subject2"
  },
  .....
]

I want to check if any of the subject in the array already exists in mongodb. What is the best practice to perform this action?

Currently I am using the following code, but I think it's not good practice to use await again and again

for(var i = 0; i< grades.length; i++)
{
    var subject = await Subject.findOne({subject: grades[i].subject});

    if(subject)
    {
        return res.status({BAD_REQUEST}).json({
          hasError: true,
          message: grades[i].subject+" of "+grades[i].grade+" is already taken"
        })
    }
}

Kousika Ganesan · Accepted Answer · 2020-11-08 15:00:14Z

1

Fetch all the subject at once and then query only once so it will reduce the number of hits in the database and also the usage of await will be reduced.

let subjects = array.map(i => i.subject)

let subjectList = await Subject.find({ subject: { $in: subjects } });

answered Nov 8, 2020 at 15:00

Kousika Ganesan

6091 gold badge8 silver badges23 bronze badges

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

1 Comment

Kousika Ganesan Over a year ago

Great @ZainUlAbideen!

Collectives™ on Stack Overflow

How to run multiple `find()` queries in mongodb using Node.js and Mongoose

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related