On Nov 1, 2007, at 12:41 PM, Lukasz Szybalski wrote:
>
> Hello,
> Does assign_mapper have any order_by function available to him after
> the object has been mapped?
>
> model.py -----
> myclass_table = sqlalchemy.Table('myClass', metadata, autoload=True)
>
> class myClass(object):
> pass
>
> myclassmapper=assign_mapper(session.context,myClass,myclass_table)
>
> controller.py------
> Now in controller, at one point I am trying to order by Date
>
> x=model.myClass.select((model.myClass.c.STATE=='IL')
>
>
> I cannot do:
> x=model.myClass.select((model.myClass.c.STATE=='IL').order_by
> (model.myClass.DATE,
> DESC) ??
> Is there another function that can do it? At this point the only way
> is to sort the list of results is to do it manually or use
> sqlalchemy.select() ? Is that correct?
query.select() is a deprecated method which is not generative (i.e.,
returns results immediately). you want to be using filter().
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
