How to make pymongo's find() return a list?

Question

Pymongo returns a cursor with it I am able to iterate over the results and append their documents to a list. Is there a way to get the result documents in a list directly? Thanks

score 122 · Accepted Answer · edited Sep 02 '15 at 19:34

122

The following code will convert the entire result set (Cursor) into a list:

myresults = list(mydb.mycollection.find())

This is fine for relatively small result sets, as you are pulling everything into memory.

edited Sep 02 '15 at 19:34

mcont

1,543
1
19
30

answered Nov 04 '12 at 02:11

Brian Cajes

3,136
3
19
22

what if i have bigger results? what is recommended? – Jaziel_Inc Aug 25 '18 at 14:47
2

@Jaziel_Inc if it's large then you can iterate over it e.g. `first_doc = next( mydb.mycollection.find() )`, where `first_doc` would be a dictionary – Alex Aug 28 '18 at 19:34
5

For more rows: `c = mydb.mycollection.find(); first_5_rows = [next(c) for _ in range(5)]` – Alex Aug 28 '18 at 19:39
@AlexG thank you, so the other option is to iterate over the cursor. – Jaziel_Inc Aug 28 '18 at 21:31
Thank you! Took too long to figure out that you can only iterate the Cursor once and need to convert it to a list otherwise! – Jonathan Brown Jan 26 '21 at 23:03

score -3 · Answer 2 · answered Feb 03 '21 at 13:11

-3

Adding to the answer above, a quick way to create a list of all results from one particular field would be:

myResults = list(mydb.mycollection.find({},{"FieldName":1,"-id":False}))

answered Feb 03 '21 at 13:11

JackX

75
5

How to make pymongo's find() return a list?

2 Answers2

Linked

Related