Updating a specific field within an array in a Meteor object using MongoDB

Question

Updating a specific field within an array in a Meteor object using MongoDB

I have a document with game details and participants. Here is an example of the structure:

{
   "gameName":"Shooter",
   "details":[
      {
         "submitted":1415215991387,
         "author":"XYZ",
         "subPlayer":{
            "members":{
               "squad1":[
                  {
                     "username":"John",
                     "deaths":0
                  }
               ]
            },
            "gameSlug":"0-shooter"
         }
      }
   ],
   "userId":"foL9NpoZFq9AYmXyj",
   "author":"Peter",
   "submitted":1415215991608,
   "lastModified":1415215991608,
   "participants":[
      "CXRR4sGf5AdvSjdgc",
      "foL9NpoZFq9AYmXyj"
   ],
   "slug":"1-shooterConv",
   "_id":"p2QQ4TBwidjeZX6YS"
}

... along with a Meteor method that needs to update the deaths field in the document:

Meteor.methods({
    updateDeaths: function(gameSlug, user, squad) {
            Stats.update({details.subPlayer.gameSlug: gameSlug}, ...}); // ???
    }
});

The goal is to update the deaths field using the user object (with username = user.username) and the squad name as string (squad1). Any suggestions on how to achieve this would be appreciated.

Your guidance is greatly valued.

javascript mongodb meteor

Answer 1

Answer №1

Here is an example of how you can achieve this:

db.collection.update(
  {'userId':'foL9NpoZFq9AYmXyj', 'details.subPlayer.gameSlug':'0-shooter'}, 
  {'$set': 
     {'details': [{
          'subPlayer': {
               'members': {
                  'squad1':[{'username':'John','death':1}]
               }
          }
       }]
     }
  }
)

UPDATE:

You could also consider using find().snapshot().forEach() which might be a more efficient way, depending on how Meteor handles it. Here is an example:

Stats.find({'userId':'foL9NpoZFq9AYmXyj', 'details.subPlayer.gameSlug':'0-shooter' }).map(function (e) {
    e.details.forEach(function (d) {
        var squad = 'squad1';
        d.subPlayer.members[squad].forEach(function (s) {
            s.deaths = 10000;
        });
    });
    Stats.update({'_id': e._id}, e);
});

Answer 2

Here is an example of how you can achieve this:

db.collection.update(
  {'userId':'foL9NpoZFq9AYmXyj', 'details.subPlayer.gameSlug':'0-shooter'}, 
  {'$set': 
     {'details': [{
          'subPlayer': {
               'members': {
                  'squad1':[{'username':'John','death':1}]
               }
          }
       }]
     }
  }
)

UPDATE:

You could also consider using find().snapshot().forEach() which might be a more efficient way, depending on how Meteor handles it. Here is an example:

Stats.find({'userId':'foL9NpoZFq9AYmXyj', 'details.subPlayer.gameSlug':'0-shooter' }).map(function (e) {
    e.details.forEach(function (d) {
        var squad = 'squad1';
        d.subPlayer.members[squad].forEach(function (s) {
            s.deaths = 10000;
        });
    });
    Stats.update({'_id': e._id}, e);
});

Updating a specific field within an array in a Meteor object using MongoDB

Answer №1

UPDATE:

Similar questions

Encountering Type Error in Angular 2

Is there a way to retrieve the initial value from the second element within the JSON data?

Issue with Electron and Node.js: Application fails to launch due to inability to locate the app within the modules

Customize Your Greasemonkey Script Timeout

Tips for maintaining the full width/height ratio of a child image when covering a fixed size container

Spin a three-dimensional cube on a platform using three.js with a unique functionality

What is the interaction between Vue's v-model and the update:modelValue directive, and how can we customize the default behavior to prevent it from

Alert: It is invalid for an <a> element to be nested inside another <a> element according to validateDOMNesting

Can you explain the process of utilizing WebdriverIO (wdio) to determine the frequency of an element's occurrence?

Error: Unable to locate the tslint command

Injecting dynamic data into a function parameter with Angular 1 Interpolation

Implement a hover effect on a specific class targeting a nested element using JavaScript

Pressing the enter key within Material UI Autocomplete will allow you to quickly create new

Retrieving data from AJAX requests

Using a combination of radio buttons and JavaScript to adjust the color of a div element

Node.js: Verifying the user's previous login status using Passport

Several JavaScript functions require a confirmation dialog to be displayed before they can be executed

Issue with the System.Web.HttpRequestValidationException

Using jQuery's AJAX function to send a POST request and extracting data from the response

Which one should I use: ng-repeat or ng-options?