twitter: order_by clause to preserve order in list?

Djangoes:

I have this question, copied from the archives:

----8<-----------------------------------------

I want to fetch a list of items in my database, and I have their id
ready:

my_ids_to_get = [ 1, 3, 2, ]

In mysql I would fetch them like this:

SELECT * FROM table WHERE id IN (1, 3, 2) ORDER BY
FIELD( id, 1, 3, 2 )

This would preserve their order.

Can I build this query with the native django order_by?

I can get the objects like this:

MyObject.objects.filter(pk__in=my_ids_to_get)

But I'm not able to build an order clause to use with it, and their
order is not preserved.

Do I have to fall back on raw sql to do this?

----8<-----------------------------------------

The answer in the archives is untenable (it's "go euphemism
yourself!"), so I'm wondering if anything has improved since the Stone
Age, 2008.

I will, of course, start with extra(), and see where that takes me!

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

twitter