Deleting a multiple documents in a MongoDB collection by a nested array element

Question

I am new to Mongo and I have a question about deleting documents using PyMongo.

I have a collection called mycollection. It has documents looking like this:

{
    "field1":"value1",
    "field2":"value2",
    "array_field": [
        "id1",
        "id2
    ]
}

I want to delete all documents in the collection which has id1 in the array_field.

How can I do this? (I am using PyMongo, I would appreciate examples based on it :) )

I don't know the python driver, but in the shell you would do it with simply db.collection.deleteMany("array_field": "id1"). You just have to adapt it to your specific driver. Doc : mongodb.com/docs/manual/tutorial/query-arrays and mongodb.com/docs/manual/reference/method/… — raphael.oester
– raphael.oester, Commented Jul 19, 2022 at 8:02

raphael.oester · Accepted Answer · 2022-07-19 08:05:05Z

1

this should do

import pymongo

client = pymongo.MongoClient("mongodb://localhost:27017/")

mydb = client["DATABASE"]
col = mydb["mycoll"]
 
query = {"array_field": "id1"}
d = col.delete_many(query)
 
print(f"{d.deleted_count} documents deleted")

answered Jul 19, 2022 at 8:05

raphael.oester

4455 silver badges21 bronze badges

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

2 Comments

Ben Hirschberg Over a year ago

Isn't the query {"array_field": "id1"} will delete only the documents where the array_field is id1 (but not where it is an array containing id1 ?)

raphael.oester Over a year ago

nope mongodb.com/docs/manual/tutorial/query-arrays/…

Erenn · Accepted Answer · 2022-07-19 08:09:51Z

1

   db.collection.deleteMany({
      "array_field": {
        $in: [
          "id1"
        ]
      }
    })

Check the mongoplayground link: https://mongoplayground.net/p/nkhSCRyR9K-

https://www.mongodb.com/docs/manual/reference/operator/query/

answered Jul 19, 2022 at 8:09

Erenn

6836 silver badges20 bronze badges

Collectives™ on Stack Overflow

Deleting a multiple documents in a MongoDB collection by a nested array element

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related