python - ValueError: too many values to unpack with .extra django modifier -

python - ValueError: too many values to unpack with .extra django modifier -

i trying utilize .extra django queryset modifier find closest 5 matching average steps param 'user_avg_steps'. in django model, average steps stored in 'avg_steps' column in userprofile table.

here snippet of code:

class="lang-py prettyprint-override">user_avg_steps = 400.0 profile_list = userprofile.objects.extra(select=ordereddict(['diff','%f']),select_params=(abs(avg_steps-user_avg_steps))).order_by('diff')[:5]

i getting error: valueerror: many values unpack

please suggest might going wrong. thanks

you getting error here,

ordereddict(['diff','%f'])

example:

>>> # regular unsorted dictionary >>> d = {'banana': 3, 'apple':4, 'pear': 1, 'orange': 2} >>> # dictionary sorted key >>> ordereddict(sorted(d.items(), key=lambda t: t[0]))

https://docs.python.org/2/library/collections.html#ordereddict-examples-and-recipes

python django