MongoDB: Pull complete Key:Array Pair

Question

I have such MongoDB Collection:

{
  date: date,
  domain: domain,
  visitors:  [ {owner:owner, ip:ip, views:views} ]
}

Now I want to check where date equals date AND domain equals domain it should delete the whole visitors array, e.g.:

collection.update({"date":date, {"domain":domain} {"$pull":{"visitors"}} )

How to make this work?

Answer 1

You could try use the $set operator to empty the visitors array instead of removing all items by using the $pull operator, which would be much faster as the $pull will have to do calculations on arrays:

db.collection.update( {"date": date, "domain": domain}, { $set : {"visitors": [] }} , {multi: true} )

The equivalent $pull operation would be

db.collection.update( {"date": date, "domain": domain}, { $pull : { "visitors": {} }}, {multi: true} )