Can mongo upsert array data?

by

I’m not aware of an option that would upsert into an embedded array as at MongoDB 2.2, so you will likely have to handle this in your application code.

Given that you want to treat the embedded array as sort of a virtual collection, you may want to consider modelling the array as a separate collection instead.

You can’t do an upsert based on a field value within an embedded array, but you could use $addToSet to insert an embedded document if it doesn’t exist already:

db.soup.update({
    "tester":"tom"
}, {
    $addToSet: {
        'array': {
            "id": "3",
            "letter": "d"
        }
    }
})

That doesn’t fit your exact use case of matching by id of the array element, but may be useful if you know the expected current value.

More Related Contents:

  1. How to send documents from my mongodb database to android application?
  2. Querying after populate in Mongoose
  3. How do I manage MongoDB connections in a Node.js web application?
  4. db.collection is not a function when using MongoClient v3.0
  5. Comparing mongoose _id and strings
  6. Why is it recommended not to close a MongoDB connection anywhere in Node.js code?
  7. How to use a variable as a field name in mongodb-native findOne()?
  8. TypeError: db.collection is not a function
  9. Stream from a mongodb cursor to Express response in node.js
  10. MongoDB on with Docker “failed to connect to server [localhost:27017] on first connect “
  11. How to protect the password field in Mongoose/MongoDB so it won’t return in a query when I populate collections?
  12. How to get a callback on MongoDB collection.find()
  13. Mongoose, find, return specific properties
  14. How to use mongoose findOne
  15. Meteor Subscribe doesn’t update sort order of collection
  16. remove _id from mongo result
  17. Mongoose optional search query parameters?
  18. Mongodb sort with case insensitive manner
  19. Mocking database in node.js?
  20. Fail to connect Mongoose to Atlas
  21. What’s going on with Meteor and Fibers/bindEnvironment()?
  22. log all queries that mongoose fire in the application
  23. Combine two OR-queries with AND in Mongoose
  24. Node.js + MongoDB: insert one and return the newly inserted document
  25. Mongoose – finding subdocuments by criteria
  26. Mongoose findOneAndUpdate and runValidators not working
  27. Mongoose select fields to return from findOneAndUpdate
  28. mongoose recursive populate
  29. Heroku app crashes after MongoDB updated to 3.0
  30. Error at connecting to MongoDb Atlas Server

Leave a Comment