[sqlalchemy] Re: ConcurrentModificationError without concurrent modification?

2008-01-24 Thread maxi
One more thing, I remove the many to many mapper (for ConvPre class and the associated mapper) and: - This work fine on sa 0.4.x - This don't work on sa 0.3.10 Are there any changes relative a this problem in 0.4.x versions ? --~--~-~--~~~---~--~~ You received

[sqlalchemy] Adding text() at the end of an sql.expression?

2008-01-24 Thread Michael Schlenker
Hi all, trying to figure out how i could add an arbitrary string to an sql.expression. If have something like this: s = select([columns]) if cond: s = s.where(text(cond)) if addtl: # how to tack addtl to the end of the statement? # this does not work s = s +

[sqlalchemy] Re: ConcurrentModificationError without concurrent modification?

2008-01-24 Thread Michael Bayer
On Jan 24, 2008, at 5:55 AM, maxi wrote: One more thing, I remove the many to many mapper (for ConvPre class and the associated mapper) and: - This work fine on sa 0.4.x - This don't work on sa 0.3.10 Are there any changes relative a this problem in 0.4.x versions ? its the same idea

[sqlalchemy] Re: Different results with select and object using outerjoin

2008-01-24 Thread MattQc
Thank you for the answer! Does it have any performance differences between the 3 manners? Which one could be the fastest if I have a lot of nested joins to do with other tables? Thanks On Jan 23, 4:30 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Jan 23, 2008, at 3:28 PM, MattQc wrote:

[sqlalchemy] Re: Different results with select and object using outerjoin

2008-01-24 Thread Michael Bayer
On Jan 24, 2008, at 11:36 AM, MattQc wrote: Thank you for the answer! Does it have any performance differences between the 3 manners? Which one could be the fastest if I have a lot of nested joins to do with other tables? straight SQL constructs without using the ORM are always much

[sqlalchemy] Re: Can't figure out the joins across many tables with select_from()

2008-01-24 Thread Alexandre Conrad
Michael Bayer wrote: model.Player.query.join(['site', 'playlists', 'hotlinks', 'hotslot']).filter(model.SlotHot.c.id=='foo').all() another thing im considering, along the lines of what I mentioned in http://groups.google.com/group/sqlalchemy/browse_thread/thread/6b5b1cda1b657723# , would look

[sqlalchemy] a way to share Session.mapper(SomeObject) across two scoped sessions?

2008-01-24 Thread Kumar McMillan
This is a spin-off from the thread on how to do setup/test-app/teardown: http://groups.google.com/group/sqlalchemy/browse_thread/thread/4fd6344bf8b9c033 (thanks for everyone's help on that) I had posted test code that illustrates it's possible to save/delete a mapped object using two different

[sqlalchemy] Re: Can't figure out the joins across many tables with select_from()

2008-01-24 Thread Michael Bayer
On Jan 24, 2008, at 2:55 PM, Alexandre Conrad wrote: But these strings seem to be the relation names. And of course, my Site object doesn't have a 'site_client' as SiteClient uses inherits=Site directly in the mapper(). So it's like transparent and there are no way to get a grab of that

[sqlalchemy] Re: Can't figure out the joins across many tables with select_from()

2008-01-24 Thread Michael Bayer
On Jan 24, 2008, at 3:55 PM, Michael Bayer wrote: as we've said, many times, its not appropriate for SQLAlchemy to *guess* which particular subclass might have the site_client attribute you're looking for. if you would just set up select_table on your mapper, this whole issue goes away.

[sqlalchemy] Re: msqsql and sqlalchemy on linux -was Re: mssql connection uri

2008-01-24 Thread Frank Wierzbicki
On Jan 19, 2008 6:48 PM, jason kirtland [EMAIL PROTECTED] wrote: I just added it to trunk in r4072 and the transform is also easily extractable can be run independently. Nothing too fancy, just rewrites @decorators for 2.3. No generator transforms. For use in SA, there's a new