pymongo : delete records elegantly

Question

Here is my code to delete a bunch of records using pymongo

ids = []
with MongoClient(MONGODB_HOST) as connection:
    db = connection[MONGODB_NAME]
    collection = db[MONGODN_COLLECTION]
    for obj in collection.find({"date": {"$gt": "2012-12-15"}}):
        ids.append(obj["_id"])
    for id in ids:
        print id
        collection.remove({"_id":ObjectId(id)})

IS there a better way to delete these records? like delete a whole set of records directly

collection.find({"date": {"$gt": "2012-12-15"}}).delete() or remove()

or delete from obj like

 obj.delete() or obj.remove()

or somehting similar?

score 72 · Accepted Answer · edited Jul 22 '14 at 19:05

72

You can use the following:

collection.remove({"date": {"$gt": "2012-12-15"}})

edited Jul 22 '14 at 19:05

Juan Carlos Farah

3,829
30
42

answered Dec 19 '12 at 21:00

Jorge Puente-Sarrín

1,082
10
8

6

if you know the id, you can simply `collection.remove(dupId)` – Cmag Feb 10 '15 at 00:07
Note that `collection.remove(dupId)` expects an `ObjectId('some-hex-id')` rather than just the `'some-hex-id'` string – kevlarr Nov 13 '18 at 16:35
2

Python 3, Mongo 3.6: `result = collection.delete_many({"date": {"$gt": "2012-12-15"}})` `print(f'{result.deleted_count} docs deleted')` – Ryan Loggerythm Dec 11 '18 at 02:56

score 13 · Answer 2 · answered Nov 30 '18 at 17:55

13

For now collection.remove(filter) is deprecated, use collection.delete_many(filter).

Example: collection.delete_many({"author": ObjectId("...")})

answered Nov 30 '18 at 17:55

Geekmoss

637
6
11

pymongo : delete records elegantly

2 Answers2