Error while sorting in pymongo

Question

In mongoshell, the below statement is working fine:

db.grades.find({'type':'homework'}).sort({$score:1})

But when I am trying to do same in pymongo, i am facing an error:

itr= collection.find({'type':'homework'}).sort(['score', pymongo.ASCENDING])

Error:

    for (key, value) in index_list:
    ValueError: too many values to unpack

shx2 · Accepted Answer · 2014-04-27 05:06:24Z

8

Yes, this always confuses me too.

You need to pass into sort a list of pairs, and you're passing a list of length 2 (i.e. a pair).

This should work:

itr= collection.find({'type':'homework'}).sort([ ['score', pymongo.ASCENDING] ])

The idea is that you can pass more than one pair in your list (for secondary order, etc.).

answered Apr 27, 2014 at 5:06

shx2

64.8k17 gold badges139 silver badges166 bronze badges

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

1 Answer 1