CODEWITHSUNDEEP
node.jsmongodb
user2947979
user2947979

Reputation: 35

Delete item from MongoDB with Nodejs

I'm trying to delete a user id from all collections that have a reference to it. I'm bringing a user id across from the form and want to remove every reference to it in every business collection. I know the below query doesn't work but it shows my current approach. 

db.collection('business', function (err, allBus){
    allBus.update({}, { $pull: {followers: { userID } } } );
});

Here is my data, any ideas?

{
    "_id" : ObjectId("55355d0ab063708c0b73809e"),
    "address" : "Donegal",
    "businessName" : "burkes shoes",
    "email" : "[email protected]",
    "followers" : [
            ObjectId("55300f5208224af428d1beaf"),
            ObjectId("553129666252d2fc0a4634e4")
    ],
    "gpsLat" : "55.1763595",
    "gpsLong" : "-7.7923",
    "homeDomain" : "www.burkes.ie",
    "imgpath" : "\\images\\uploads\\57461Burkes_logo_1429560586607.jpg",
    "password" : "1",
    "role" : "business"
}

Upvotes: 2

Views: 218

Answers (1)

chridam
chridam

Reputation: 103475

If userID is a string you will need to cast it first to ObjectID before using it in your query. Something like this should do the magic:

var ObjectID = require("mongodb").ObjectID,
    userID = new ObjectId("55300f5208224af428d1beaf"); 
/*
   if userID is a string then this will work 
   var userID = new ObjectId(userID);
*/
db.business.update(
    {"followers": userID}, 
    {
        "$pull": { "followers": userID }
    },
    { multi: true }
);

The query above will have better performance than an update without a query as it first filters documents that have in their followers array an element with the userID value and then updates the matched documents by pulling the ObjectID value from the array.

Upvotes: 1

Related Questions