How to extract collections in Mongo using Python?

Question

Please apologize me if my question is naive, I am new to python and I am trying my hand on using the collections using pymongo. I have tried to extract the names using

collects = db.collection_names(); #This returns a list with names of collections

But when I tried to get the cursor using

cursor = db.collects[1].find(); #This returns a cursor which has no reference to a collection.

I understand that the above code uses a string instead of an object. So, I was wondering how I could accomplish this task of retaining a cursor for each collection in the DB, which I can use later to perform operations of search and update etc.

Sede · Accepted Answer · 2015-11-07 21:18:31Z

2

If you are using the pymongo driver you must use the get_collection method or a dict-style lookups instead. Also you may want to set the include_system_collections to False in collection_names so you don't include system collections (e.g system.indexes)

import pymongo

client = pymongo.MongoClient()
db = client.db
collects = db.collection_names(include_system_collections=False)
cursor = db.get_collection(collects[1]).find()

or

cursor = db[collects[1]].find()

edited Nov 7, 2015 at 21:18

answered Oct 14, 2015 at 18:00

Sede

61.5k20 gold badges159 silver badges162 bronze badges

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

Comments

Friwi · Accepted Answer · 2015-10-14 17:17:24Z

1

Sry, i can't create a comment yet, but have you tried?:

cursor = db.getCollection(collects[1]).find();

answered Oct 14, 2015 at 17:17

Friwi

4923 silver badges13 bronze badges

1 Comment

reticentroot Over a year ago

If @Friwi's answer was satisfactory it is customary to accept the answer. One because the answer helped you, second so that other users know that this question has been resolved.

Collectives™ on Stack Overflow

How to extract collections in Mongo using Python?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related