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.
http://groups.google.com/group/django-users/browse_thread/thread/f23b2bdf24ff7a26/110d3e5c9e69ca63
I will, of course, start with extra(), and see where that takes me!
--
Phlip
http://zeekland.zeroplayer.com/
--
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+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
