Updating nested data in MongoDB without creating duplicate objects

Question

Updating nested data in MongoDB without creating duplicate objects

My goal is to add new data into an existing document:

Graph.update(
    { id: id }, 
    {
        $push: {
            tooltips: {
                element: Session.get('tooltipID'),
                text: text
            }
        }
    }
);

Everything is going smoothly, however, I am encountering an issue where if there is already existing data in tooltips, instead of adding a new object, I need it to update the existing one. This is because each element (tooltipID) should have a unique object.

I want to prevent duplicate entries for the same element-value in tooltips.

{
    "_id" : "c4bKur6TKcgFHGLZZ",
    "data" : "[]",
    "tooltips" : [
        {
            "element" : "2d4edaaf",
            "text" : "Lorem"
        },
        {
            "element" : "2d4edaaf",
            "text" : "ipsum"
        }
    ]
}

However, it should be allowed to have multiple objects in tooltips as long as the element is unique...

I attempted to include upsert:true in the update() function, but unfortunately, it did not work as intended.

javascript mongodb

Answer 1

Answer №1

It is certain that utilizing upsert will not function with an embedded document.

One possible solution could be

Graph.update({id:id}, 
    {
       $addToSet: {
           'tooltips': {
              element: Session.get('tooltipID'),
              text: text
            }
       }
})

This method guarantees there are no duplicates in tooltips;

alternatively, you may employ $set

Graph.update({
  id:id,
 'tooltips.element': Session.get('tooltipID')
  }, 
  {
 $set: {
    'tooltips.$.text':text
   }
})

or you can remove before adding

Graph.update({
    "id":id
}, {
    $pull: {
        'tooltips': {
            "element": Session.get('tooltipID')
        }
    }
})
    Graph.update(
    { id: id }, 
    {
        $push: {
            tooltips: {
                element: Session.get('tooltipID'),
                text: text
            }
        }
    }
);

Answer 2

It is certain that utilizing upsert will not function with an embedded document.

One possible solution could be

Graph.update({id:id}, 
    {
       $addToSet: {
           'tooltips': {
              element: Session.get('tooltipID'),
              text: text
            }
       }
})

This method guarantees there are no duplicates in tooltips;

alternatively, you may employ $set

Graph.update({
  id:id,
 'tooltips.element': Session.get('tooltipID')
  }, 
  {
 $set: {
    'tooltips.$.text':text
   }
})

or you can remove before adding

Graph.update({
    "id":id
}, {
    $pull: {
        'tooltips': {
            "element": Session.get('tooltipID')
        }
    }
})
    Graph.update(
    { id: id }, 
    {
        $push: {
            tooltips: {
                element: Session.get('tooltipID'),
                text: text
            }
        }
    }
);

Updating nested data in MongoDB without creating duplicate objects

Answer №1

Similar questions

Typemoq and Angular-cli are incompatible with each other

Preventing the dispatch function from being overwritten by an empty state

Calculate the Pythagorean Theorem with HTML and JavaScript

React hooks for managing a to-do list

Looking for a categorized list of unique special characters and their classifications

Viewing multiple pages and maintaining sessions in Laravel

Converting a tree structure into JSON with the help of tree-model-js

The JQuery condition is failing to accurately recognize the span checkbox

How to use JavaScript and regex to control the state of a disabled submit button

DxDataGrid: Implementing a comprehensive validation system for multiple edit fields

When Vue is clicked, it appears to trigger multiple methods simultaneously

The hyperlink refuses to open in a new tab

Having trouble accessing the height of a div within an Iframe

What is the process of creating {{shortcodes}} in a node.js, express.js, and jade.js application

What is the best way to populate MongoDB with information retrieved from an external API?

How can Mongodb regular expressions be used to search for a substring that ends with '..' or has a '.' in the middle of a field in mongo?

Can all intervals set within NGZone be cleared?

Creating a user-friendly form in a Nuxt/Vue application that enables dynamic attribute creation

Parsley.js now supports the use of the attribute `data-parsley-errors

Converting JSON data into an array of objects for managing React state using hooks