MongoDB: Updating documents using data from the same document [duplicate]

by

Update: If all you have to do is change the structure of a document without changing the values, see gipset’s answer for a nice solution.

According to a (now unavailable) comment on the Update documentation page, you cannot reference the current document’s properties from within an update().

You’ll have to iterate through all the documents and update them like this:

db.events.find().snapshot().forEach(
  function (e) {
    // update document, using its own properties
    e.coords = { lat: e.lat, lon: e.lon };

    // remove old properties
    delete e.lat;
    delete e.lon;

    // save the updated document
    db.events.save(e);
  }
)

Such a function can also be used in a map-reduce job or a server-side db.eval() job, depending on your needs.

More Related Contents:

  1. Query for documents where array size is greater than 1
  2. Mongodb $push in nested array
  3. How to select a single field for all documents in a MongoDB collection?
  4. mongodb group values by multiple fields
  5. Check that Field Exists with MongoDB
  6. Find MongoDB records where array field is not empty
  7. MongoDB – Update an object in nested Array
  8. Creating Multifield Indexes in Mongoose / MongoDB
  9. Mongodb Explain for Aggregation framework
  10. MongoDB aggregation comparison: group(), $group and MapReduce
  11. MongoDB group by array inner-elements
  12. Multiple Counts with single query in mongodb
  13. NoSQL (MongoDB) vs Lucene (or Solr) as your database [closed]
  14. Delete everything in a MongoDB database
  15. Failed to start mongod.service: Unit mongod.service not found
  16. How to return array of string with mongodb aggregation
  17. How to return just the nested documents of an array from all documents
  18. Mongoose’s find method with $or condition does not work properly
  19. return query based on date
  20. How does MongoDB deal with concurrent updates?
  21. MongoParseError: options useCreateIndex, useFindAndModify are not supported
  22. mgo – query performance seems consistently slow (500-650ms)
  23. Can’t find documents searching by ObjectId using Mongoose
  24. Mongodb aggregation $group, restrict length of array
  25. mongodb – Find document with closest integer value
  26. mongodb, replicates and error: { “$err” : “not master and slaveOk=false”, “code” : 13435 }
  27. MongoDB/NoSQL: Keeping Document Change History
  28. Update a value in MongoDB based on its current value
  29. How to connect to external MongoDB instance in Meteor?
  30. Generating a Structure for Aggregation

Leave a Comment