Deleting document in PyMongo from id

Question

I seem to be struggling to find the right way of deleting a document. I.e. should I be using remove() or delete_one() for example and also what is the canonical method of deleting by id, which is a string.

I.e. should I be using the following:

mongo.db.xxx.delete_one({'_id': { "$oid" : str(_id) } })

or can I use another format?

mongo.db.xxx.remove({'_id': { "$oid" : str(_id) } })
mongo.db.xxx.remove({'_id': ObjectId(_id) })

What is the canonical form?

JohnnyHK · Accepted Answer · 2015-10-05T15:15:34.760

56

remove is deprecated in the 3.x release of pymongo, so the current canonical form would be to use delete_one:

from bson.objectid import ObjectId

result = mongo.db.xxx.delete_one({'_id': ObjectId(_id)})

The call returns a DeleteResult in which you can inspect the deleted_count field to see if it found a document to delete

edited Oct 05 '15 at 15:15

answered Oct 05 '15 at 13:56

JohnnyHK

305,182
66
621
471

Thanks, do you know the error exceptions? I cannot get debug at the moment. I.e. if the ID isn't found. – disruptive Oct 05 '15 at 14:18
When I try this at the command line, I get the following: `NameError: name 'ObjectId' is not defined` – disruptive Oct 05 '15 at 15:07
@Navonod You need to import that if you're not already doing that. See updated answer. – JohnnyHK Oct 05 '15 at 15:16

score 0 · Answer 2 · edited Sep 17 '22 at 13:16

0

You can simply do:

result = mongo.db.xxx.delete_one({})

edited Sep 17 '22 at 13:16

Suraj Rao

29,388
11
94
103

answered Sep 17 '22 at 13:11

Bruce Wayne

1

Deleting document in PyMongo from id

2 Answers2