On Dec 27, 2011, at 8:37 PM, Vlad K. wrote:
>
> Hi all.
>
>
> I need to select some rows where pkey is in a sequence. How do I order by
> that very sequence?
>
>
> images_all =
> session.query(AdImage).filter(AdImage.image_id.in_(images)).order_by( ?
> ).all()
>
>
> Postgresql backend.
typically with case():
order_by(
case([
(Adimage.id == 3, "A"),
(Adimage.id == 1, "B"),
(Adimage.id == 9, "C"),
])
)
unless you can use a simpler transformation on AdImage.id that converts it into
a sortable value.
The above can be generalized:
case([(AdImage.id == value, literal(index)) for index, value in
enumerate(images)])
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
