Re: [sqlalchemy] Unset order_by()

2010-06-17 Thread Andi Albrecht
With the latest revision removing a order_by that was previously set by a mapping works fine now! Thanks for having a look at this! Andi On Thu, Jun 17, 2010 at 9:56 PM, Michael Bayer wrote: > > On Jun 17, 2010, at 3:15 PM, Andi Albrecht wrote: > >> Adding these two lines to you

Re: [sqlalchemy] Unset order_by()

2010-06-17 Thread Andi Albrecht
.name AS users_name FROM > users", >                use_default_dialect=True) > > > and it passes.   So how to reproduce the failure I assume you are getting ? > > > > On Jun 17, 2010, at 3:14 AM, Andi Albrecht wrote: > >> It's not different at all. I'v

Re: [sqlalchemy] Unset order_by()

2010-06-17 Thread Andi Albrecht
RE criterion, or join(None) doesn't remove all > joins.    This issue has come up before.  How is order_by() different ? > > > On Jun 16, 2010, at 8:05 AM, Andi Albrecht wrote: > >> Hi, >> >> I'm a bit curious about how to unset an order_by in 0.6. >> &

[sqlalchemy] Unset order_by()

2010-06-16 Thread Andi Albrecht
Hi, I'm a bit curious about how to unset an order_by in 0.6. query.order_by(None) should do it, but in sqlalchemy/orm/query.py in _no_select_modifiers() the notset value for the _order_by attribute is False. In turn, the order_by() method doesn't seem to accept False. What would be a proper way

[sqlalchemy] Re: Populate a mapped class from RowProxy

2009-05-29 Thread Andi Albrecht
Thanks, Michael! That was exactly what I'm looking for :) Andi On Thu, May 28, 2009 at 5:45 PM, Michael Bayer wrote: > > Andi Albrecht wrote: >> >> class Foo(object): >>   pass >> >> database.mapper(Foo, database.metadata.tables["footable"])

[sqlalchemy] Populate a mapped class from RowProxy

2009-05-28 Thread Andi Albrecht
Hi, maybe I've overlooked something very trivial, but how can I populate a mapped class from a RowProxy? Here's a simple example of what I'd like to do (using TurboGears): class Foo(object): pass database.mapper(Foo, database.metadata.tables["footable"]) Now I have a rather complex SQL that