/Python/Django/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

8 votes184 views2 answers
Purpose of meta class in django
Python Django
0 vote192 views2 answers
Generate-thumbnails-in-django-with-pil
Python Django
0 vote222 views1 answer
Unsupported media type django
Python Django
0 vote123 views1 answer
How to resize image with pillow in django
Python Django
0 vote172 views1 answer
Django queryset to instance
Python Django
0 vote175 views1 answer
Default ordering django
Python Django
0 vote186 views1 answer
Django template child data in nested loop
Python Django
0 vote169 views1 answer
Django get all model fields
Python Django
1 vote174 views1 answer
Insert data in django models
Python Django
0 vote277 views3 answers
Django prevent duplicate entries
Python Django