[sqlalchemy] migrating to 0.6

2010-05-12 Thread werner
I just started migrating to 0.6 and I get: c:\python26\lib\site-packages\sqlalchemy-0.6.0-py2.6.egg\sqlalchemy\util.py:239: DeprecationWarning: functions overriding warnings.showwarning() must support the 'line' argument warnings.warn(msg, warning_type, stacklevel=3) string:1:

Re: [sqlalchemy] migrating to 0.6

2010-05-12 Thread David Gardner
Looks like your issuing query like: query.order_by([col1, col2]) in 0.6 you should instead be doing: query.order_by(col1, col2) Also take a look at: http://www.sqlalchemy.org/trac/wiki/06Migration#DeprecatedRemovedORMElements On 05/12/2010 08:53 AM, werner wrote: I just started migrating to

Re: [sqlalchemy] migrating to 0.6

2010-05-12 Thread werner
David, On 12/05/2010 18:00, David Gardner wrote: Looks like your issuing query like: query.order_by([col1, col2]) Should have thought about that one, i.e. search for order_by([ instead of just order_by. in 0.6 you should instead be doing: query.order_by(col1, col2) Also take a look at:

Re: [sqlalchemy] migrating to 0.6

2010-05-12 Thread David Gardner
A little tip because I ran into this one a bit. I usually end up building out a list of columns that I want to order by based on user input from the command line, or from a column heading click, and end up with something like: order_list=['parent','name'] what you can do is just toss a '*' in