How to iterate a cursor in mongodb using python?

Question

My document structure is something like this....

I ran this query

test_run_names = self._database.suiteruns.find({'user': user_id, {'$or': [{'name': {'$exists': True}},{'name': {'$eq': ""}}]}})

test_run_names is of type cursor.

How can i iterate over it and get the attributes i need ?

What i did ?

for t in test_run_names 
    print (t['name']) #throws a key error

I'd suggest to have a look at api.mongodb.com/python/current/tutorial.html — Saleem
– Saleem, Commented Jun 1, 2016 at 5:56

Juanín · Accepted Answer · 2016-06-01 05:57:12Z

1

Maybe you have an element without name.

Try this instead:

for t in test_run_names 
    print (t.get('name'))

answered Jun 1, 2016 at 5:57

Juanín

8516 silver badges16 bronze badges

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

7 Comments

cafebabe1991 Over a year ago

Ok, i am trying it out, but isnt t['name'] same as t.get('name') ?

Juanín Over a year ago

t['name'] will throw an error if name doesn't exist and t.get('name') will return none if there's no name variable

Juanín Over a year ago

I mean, it will throw an error if name is not defined

cafebabe1991 Over a year ago

Every get('name') shows none , why is that ? Do i need to put projection too ? I mean cursor is returning only the object id i suppose. So that is why maybe every get operation returns None . Am i right ? If yes , how do i get other attributes ?

Juanín Over a year ago

Maybe you do have none in every document. You can print t just to make sure the data you are getting makes sense.

|

Collectives™ on Stack Overflow

How to iterate a cursor in mongodb using python?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related