Skip to main content

MongoDB — Updating Documents — 3


  1. UpdateOne
    • db.<collection>.updateOne(filter, update)
    • Example:
      • db.<collection>.updateOne({_id: <id>}, {$set: {<field>: <Value>}})
  2. UpdateMany
    • db.<collection>.updateOne(filter, update)
    • Example:
      • db.<collection>.updateMany({<field1>: <Value1>}, {$set: {<field2>: <Value2>}})
  3. $inc (Incrementing/Decrementing)
    • Incrementing
      • db.<collection>.updateOne({<field1>: <Value>}, {$inc: {<field2>: <n>}})
    • Decrementing
      • db.<collection>.updateOne({<field1>: <Value>}, {$inc: {<field2>: <-n>}})
    • Increment/Decrement one field and update other
      1. db.<collection>.updateOne({<field1>: <Value1>}, {$inc: {<field2>: <n>}, $inc: {<field3>: <Value2>}})
  4. $min — if new value < old value then updates with new value
    • db.<collection>.updateOne({<field1>: <Value>} {$min: {<field2>:<n>}})
  5. $max — if new value > old value then updates with new value
    • db.<collection>.updateOne({<field1>: <Value>} {$max: {<field2>:<n>}})
  6. $max — multiplies value and updates
    • db.<collection>.updateOne({<field1>: <Value>} {$mul: {<field2>:<n>}})
  7. $unset — removes field
    • db.<collection>.updateMany({<field1>: <Value>}, {$unset: {<field2>: ""}})
  8. $rename — rename field
    • db.<collection>.updateMany({}, {$rename: {<field2>: <new field name>}})
      • if field exists, it will be renamed in all documents
  9. $upsert — takes boolean value, default is false, if set true add a document if not found
    • db.<collection>.updateMany({<field1>: <Value1>}, {$set: {<field2>: <Value2>, <field3>: <Value3>}}, {upsert: true})
  10. Update embeded document inside document
    • Wrong Way: db.<documents>.updateMany({$and: [{<field>.<subfield1>:<Value1>}, {<field>.<subfield2>: {$gte: n}}]}, {$set: {}})
    • Right Way: db.<documents>.updateMany({<field>: {$elemMatch: {<subfield1>:<Value1>, <subfield2>: {$gte: n}}}}, {$set: {"<field>.$.<new subfield>": <Value2>}})
  11. Update all matched values from an array of embeded documents
    • db.<collection>.updateMany({<field>: {$gt: <num>}}, {$inc: {"<field>.$[].frequency": <num>}})
      • Updating field inside array of embeded documents
    • db.<collection>.updateMany({<field>: {$gt: <num>}}, {$inc: {"<field>.$[]": <num>}})
      • Updating field inside array
  12. When searching directly for a few embeded documents in an array, entire array is returned. If you want only embeded documents from array that match your need then use the following
    • db.<collection>.updateMany({"<field>.<subfield>": {$gt: <n>}}, {$set: {"<field>.$[ele]<subfield>": <Value>}}, {arrayFilters: [{"ele.<subfield>": {$gt: <n>}}]})
      • First filter and arrayFilters do not have to be equal, even though we used the same in the example
      • First filter is to return documents containing the condition, and arrayFilters, like the name suggests, is to return the embeded documents in the array that matches the condition
      • 'ele' in the example is a name given by us to refer each array element
  13. Adding embeded document or value to an array
    • db.<collection>.updateOne({<field1>:<value1>}, {$push: {<array field>: <embeded document OR value>}})
      • for adding one value or embeded document to the array
    • db.<collection>.updateOne({<field1>:<value1>}, {$push: {<array field>: {$each: [<embeded documents OR values SEPARATED BY COMMA>]}}})
      • for adding more than one values or embeded documents to the array
    • db.<collection>.updateOne({<field1>:<value1>}, {$push: {<array field>: {$each: [<embeded documents OR values SEPARATED BY COMMA>], $sort: {<subfield>: <1 OR -1>}, $slice: <n>}}})
      • sort sorts entire array before storing (optional)
      • slice takes the first n values/embeded documents and stores (optional)
  14. Removing embeded document or value from an array
    • db.<collection>.updateOne({<field1>:<value1>}, {$pull: {<array field>: {<subfield>: <value>}}})
      • removes matching documents/values from array
    • db.<collection>.updateOne({<field1>:<value1>}, {$pop: {<array field>: <1 for last element or -1 for first element>}}})
      • removes first or last item from the array
  15. $addToSet
    • db.<collection>.updateOne({<field1>:<value1>}, {$addToSet: {<array field>: <embeded document OR value>}})
      • for adding one value or embeded document to the array only once. If you try again it won't work since it adds only unique values. If duplicate, it won't execute
  16. .replaceOne()
    1. Used to replace entire document with a new document but retain the id

    Comments

    Post a Comment

    Popular posts from this blog

    Python - List - Append, Count, Extend, Index, Insert, Pop, Remove, Reverse, Sort

    🐍 Advance List List is widely used and it's functionalities are heavily useful. Append Adds one element at the end of the list. Syntax list1.append(value) Input l1 = [1, 2, 3] l1.append(4) l1 Output [1, 2, 3, 4] append can be used to add any datatype in a list. It can even add list inside list. Caution: Append does not return anything. It just appends the list. Count .count(value) counts the number of occurrences of an element in the list. Syntax list1.count(value) Input l1 = [1, 2, 3, 4, 3] l1.count(3) Output 2 It returns 0 if the value is not found in the list. Extend .count(value) counts the number of occurrences of an element in the list. Syntax list1.extend(list) Input l1 = [1, 2, 3] l1.extend([4, 5]) Output [1, 2, 3, 4, 5] If we use append, entire list will be added to the first list like one element. Extend, i nstead of considering a list as one element, it joins the two lists one after other. Append works in the following way. Input l1 = [1, 2, 3] l1.append([4, 5]) Output...
    Post a Comment
    Read more

    Difference between .exec() and .execPopulate() in Mongoose?

    Here I answer what is the difference between .exec() and .execPopulate() in Mongoose? .exec() is used with a query while .execPopulate() is used with a document Syntax for .exec() is as follows: Model.query() . populate ( 'field' ) . exec () // returns promise . then ( function ( document ) { console . log ( document ); }); Syntax for .execPopulate() is as follows: fetchedDocument . populate ( 'field' ) . execPopulate () // returns promise . then ( function ( document ) { console . log ( document ); }); When working with individual document use .execPopulate(), for model query use .exec(). Both returns a promise. One can do without .exec() or .execPopulate() but then has to pass a callback in populate.
    1 comment
    Read more

    683 K Empty Slots

      Approach #1: Insert Into Sorted Structure [Accepted] Intuition Let's add flowers in the order they bloom. When each flower blooms, we check it's neighbors to see if they can satisfy the condition with the current flower. Algorithm We'll maintain  active , a sorted data structure containing every flower that has currently bloomed. When we add a flower to  active , we should check it's lower and higher neighbors. If some neighbor satisfies the condition, we know the condition occurred first on this day. Complexity Analysis Time Complexity (Java):  O(N \log N) O ( N lo g N ) , where  N N  is the length of  flowers . Every insertion and search is  O(\log N) O ( lo g N ) . Time Complexity (Python):  O(N^2) O ( N 2 ) . As above, except  list.insert  is  O(N) O ( N ) . Space Complexity:  O(N) O ( N ) , the size of  active . Approach #2: Min Queue [Accepted] Intuition For each contiguous block ("window") of  k  po...
    Post a Comment
    Read more