How to Insert documents to multiple collection in a single query using nodejs

Question

I am trying to insert documents into multiple collections by writing single query.

Let consider that I have two collections person and address. I want insert documents to both of this collections in single query. That is documents which are like fname,lname should be inserted inside pesron collection and documents which are like city,state,country should be inserted to address collections.

Is there any I can make this happen, If it is possible providing any answer with example will be appreciated.

Dan Starns · Accepted Answer · 2019-09-13 13:15:31Z

2

mongoose doesn't provide this functionality & also node.js is synchronous... so you cant do 2 things at the same time. Is suggest leveraging Promise.all

(async () => {
    const [createdPerson, createdAddress] = await Promise.all([
        person.create({
            fname: "name",
            lname: "lname"
        }),
        address.create({
            city: "city",
            state: "state",
            country: "country"
        })
    ]);
})();

edited Sep 13, 2019 at 13:15

answered Sep 13, 2019 at 9:22

Dan Starns

3,8251 gold badge13 silver badges28 bronze badges

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

3 Comments

manjesha Over a year ago

do not consider my Schema. without async is there any way

Dan Starns Over a year ago

hello, please could you rephrase your question. I do not understand.

Dan Starns Over a year ago

I have updated my answer to reflect your updates, once again. Mongoose does not provide functionality to 'insert multiple collections in a single query'. you can use promise.all to partially achieve this.

Iglesias Leonardo · Accepted Answer · 2022-05-09 13:58:37Z

0

I believe this is possible using MongoDb Transactions. I haven't tested yet, but there's a good example here, and you can view it's settings here. Hope it helps!

answered May 9, 2022 at 13:58

Iglesias Leonardo

5406 silver badges11 bronze badges

Comments

shubham · Accepted Answer · 2022-05-10 04:05:45Z

0

If you want to use two dependent documents in two different collections so that if one insert fails other should fail also then you need to use MongoDB transactions API.

MongoDB transactions - https://www.mongodb.com/docs/manual/core/transactions/ Mongoose reference to transactions - https://mongoosejs.com/docs/transactions.html

answered May 10, 2022 at 4:05

shubham

4571 gold badge9 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to Insert documents to multiple collection in a single query using nodejs

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related