[sqlalchemy] Triple Join Table

2008-06-16 Thread Matt Haggard
I've got a triple join table (joining three things together) and I'm really struggling to get it to work as I intend. I've pasted the full model at the bottom. I've struggled with this off and on for months now... I don't really understand how I can get SQLAlchemy to do what I want. The join ta

[sqlalchemy] no server side cursors in SA 0.4.6?

2008-06-16 Thread Matthew Dennis
Using Postgres 8.3.1 Consider the following script. In SA 0.4.3 it works as intended. In SA 0.4.6, it does not. In particular, the time to get the resultset in 0.4.3 is sub-second. The time in 0.4.6 is about 20 seconds. Also, when running on 0.4.3 the memory consumption of the script is const

[sqlalchemy] Re: inverted in_

2008-06-16 Thread ml
great, thanks! > filter(sqlalchemy.not_(User.name.in_('alice', 'bob'))) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubs

[sqlalchemy] Re: inverted in_

2008-06-16 Thread Egil Möller
filter(sqlalchemy.not_(User.name.in_('alice', 'bob'))) How can I invert the in_ operator? I need a select like: "... name NOT IN ('alice', 'bob')..." ...filter(not User.name.in_('alice', 'bob'))... is not working. Hope that helps, E signature.asc Description: OpenPGP digital signature

[sqlalchemy] inverted in_

2008-06-16 Thread ml
Hi! How can I invert the in_ operator? I need a select like: "... name NOT IN ('alice', 'bob')..." ...filter(not User.name.in_('alice', 'bob'))... is not working. Thanks for advices. David --~--~-~--~~~---~--~~ You received this message because you are subscrib

[sqlalchemy] Re: Possible problem with pool?

2008-06-16 Thread Geoff
My bad, turns out to be a threading issue :) On Jun 16, 11:04 am, Geoff <[EMAIL PROTECTED]> wrote: > I'm getting an odd issue with connection recycling. Here's whats > happening: > > 20080616 10:50:01,654 INFO  [sqlalchemy.pool.QueuePool.0x..2c] > Connection <_m

[sqlalchemy] Possible problem with pool?

2008-06-16 Thread Geoff
I'm getting an odd issue with connection recycling. Here's whats happening: 20080616 10:50:01,654 INFO [sqlalchemy.pool.QueuePool.0x..2c] Connection <_mysql.connection open to 'localhost' at 8bf4ddc> exceeded timeout; recycling 20080616 10:50:01,654 INFO [sqlalc