MongoDB update multiple documents
mongodb, transactions
Solution
MongoDB doesn't support atomic transactions. So if you need to make the first update "undo itself" if the second update fails, then you're out of luck.
However, in some limited cases, MongoDB does support isolated updates. The update isn't all or nothing, but MongoDB will guarantee that nobody else writes to the collection in the middle of your write.
A couple of major caveats:
- The documents must all be in the same collection
- The updates must all be specified in one query
Based on the example you've provided, your case might qualify.
Here is the documentation describing an isolated update.
Basically you'll want to issue the an update similar to the following to atomically set "available" to false when name is either "a" or "b":
db.blah.update({"name": {"$in": ["a", "b"]}, "$atomic": 1}, {"available": false});
Problem
Schema: ``` { name: String, available: Boolean, for: String } ``` there are "a": ``` { name: "a", available: true, for: ["b", "c"] } ``` and "b": ``` { name: "b", available: true, for: ["a", "b] } ``` if I update a.available = false, I should update b.available = false at the same time. how could I update two documents and make sure there would not has other process/thread getting "b" between the time when updating "a" and "b".