[sqlalchemy] Re: "InvalidRequestError: Can't reconnect until invalid transaction is rolled back" error during "SELECT" query

2013-08-20 Thread Jim Carroll
I'm having the same issue with a Pyramid web app. Did anyone find a solution? I've tried Flup and Waitress as the containers for the pyramid app, and I've tried Lighttpd and Nginx in front... no difference. My latest exceptions look like: Could not convert return value of the view callable fun

Re: [sqlalchemy] Problems when using orderinglist with association_proxy

2013-08-20 Thread Georges Dubus
Thanks a lot ! I'll have to buy you a beer (or equivalent) in a pycon at some point in the future. 2013/8/20 Michael Bayer > I've got it down in http://www.sqlalchemy.org/trac/ticket/2807, will be > the next thing I commit since this is pretty major. > > > On Aug 20, 2013, at 10:11 AM, Michael

Re: [sqlalchemy] Selecting across columns with func.min()

2013-08-20 Thread Michael Bayer
you have to consider that more than one row can have that same close, so it's a set of rows corresponding to that one close. so to remain in terms of sets you need to use a join (or a subquery): select prices.date from prices, (select min(price.close) as close from prices join company on wher

Re: [sqlalchemy] Problems when using orderinglist with association_proxy

2013-08-20 Thread Michael Bayer
I've got it down in http://www.sqlalchemy.org/trac/ticket/2807, will be the next thing I commit since this is pretty major. On Aug 20, 2013, at 10:11 AM, Michael Bayer wrote: > ah, nah that makes this somewhat easier, it's probably related to iterators > vs. lists for collections. the issue

Re: [sqlalchemy] Problems when using orderinglist with association_proxy

2013-08-20 Thread Michael Bayer
ah, nah that makes this somewhat easier, it's probably related to iterators vs. lists for collections. the issue is local to the association proxy, checking that now. On Aug 20, 2013, at 4:07 AM, Georges Dubus wrote: > Damn, there's one thing I forgot to mention in my first mail : I get thi

Re: [sqlalchemy] Problems when using orderinglist with association_proxy

2013-08-20 Thread Georges Dubus
Damn, there's one thing I forgot to mention in my first mail : I get this behaviour with python 3.3.2. I confirm that it works correctly with 2.7.5. I also confirm the problems appeared with the master yesterday. So, a different behaviour between python 2 and 3, that's not a fun bug. Can you think