mongodb multiple documents insert or update by unique key

Question

I would like to get a list of items from an external resource periodically and save them into a collection.

There are several possible solutions but they are not optimal, for example:

Delete the entire collection and save the new list of items
Get all items from the collection using "find({})" and use it to filter out existing items and save those that do not exist.

But a better solution will be to set a unique key and just do kind of "update or insert". Right now on saving items the unique key already exists I will get an error is there a way to do it at all?

**upsert won't do the work since it's updating all items with the same value so it's actually good for a single document only

Welcome to SO. To help others to answer your question, please provide some sample data and code of you have tried so far. — mbuechmann
– mbuechmann, Commented Oct 15, 2018 at 17:26
Possible duplicate of Insert or update many documents in MongoDB — str
– str, Commented Oct 15, 2018 at 19:56

dnickless · Accepted Answer · 2018-10-16 18:44:23Z

I have a feeling you can achieve what you want simply by using the "normal" insertMany with the ordered option set to false. The documentation states that

Note that one document was inserted: The first document of _id: 13 will insert successfully, but the second insert will fail. This will also stop additional documents left in the queue from being inserted. With ordered to false, the insert operation would continue with any remaining documents.

So you will get "duplicate key" exceptions which, however, you can simply ignore in your case.

Collectives™ on Stack Overflow

mongodb multiple documents insert or update by unique key

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related