/Python/Use in in django while preserving order

Use in in django while preserving order

pk_list = [5, 7, 1, 3, 4]
clauses = ' '.join(['WHEN id=%s THEN %s' % (pk, i) for i, pk in enumerate(pk_list)])
ordering = 'CASE %s END' % clauses
queryset = Article.objects.filter(pk__in=pk_list).extra(
           select={'ordering': ordering}, order_by=('ordering',))

Source: codybonney.com

Similar codes

1 vote127 views1 answer
Postgres django settings
Python
0 vote139 views1 answer
Python generator in while loop
Python
1 vote132 views1 answer
Install chromedriver ubuntu python
Python
0 vote118 views1 answer
Comment arrêter un jeu en appuyant sur une touche python
Python
44 votes142 views3 answers
Python string cut last character
Python
30 votes132 views3 answers
Python day from datetime
Python
0 vote113 views1 answer
Run ipython inside pipenv
Python
0 vote119 views1 answer
Python opencv draw rectangle with mouse
Python
1 vote148 views1 answer
Django sort descending
Python Django
0 vote121 views1 answer
Python print numbers 1 to 10 in one line
Python