How to set a random string value to all documents in a mongodb collection with the mongo shell?

Question

I need to set a randomly generated string property on all values in a MongoDB collection. I'd like to use the mongo shell and the updateMany function in order to quickly and easily achieve this.

fIwJlxSzApHEZIl · Accepted Answer · 2022-09-09 20:17:23Z

0

After a bit of research I found this solution to work for me:

Copy and paste this function into your mongo shell:

function makeid(length) {
    var result           = '';
    var characters       = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
    var charactersLength = characters.length;
    for ( var i = 0; i < length; i++ ) {
      result += characters.charAt(Math.floor(Math.random() * 
 charactersLength));
   }
   return result;
}

console.log(makeid(5));

Verify it works in your mongo shell by typing makeid(6)
Call the function on every document to set a unique randomly generated property:

db.collectionName.find({}).forEach(function(myDocument) {db.collectionName.update({_id: myDocument._id}, {$set: { randomId: makeid(6)}})})

answered Sep 9, 2022 at 20:17

fIwJlxSzApHEZIl

13.6k7 gold badges71 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

whoami - fakeFaceTrueSoul Over a year ago

Same answer as already provided here: stackoverflow.com/questions/59690531/… Use BulkWrite as stated in that answer to avoid unnecessary multiple DB update calls

Collectives™ on Stack Overflow

How to set a random string value to all documents in a mongodb collection with the mongo shell?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related