Re: [sqlalchemy] multiple databases?

2013-12-11 Thread Richard Gerd Kuesters
thanks! in fact i'm using twisted, and i make use of some abstractions on top of query so they can be treated as a deferred :) but either way, i'm using a very modified version of this: http://techspot.zzzeek.org/2012/01/11/django-style-database-routers-in-sqlalchemy/ it's been working good

Re: [sqlalchemy] Find out what's going to be deleted

2013-12-11 Thread Tim Kersten
Hi, On Sunday, June 2, 2013 5:47:03 PM UTC+1, pub...@enkore.de wrote: Thanks a lot for your comprehensive answer! I was able to solve my problem by implementing your first suggestion. Orphans do not play a role yet� I think :-) On 06/02/2013 05:09 PM, Michael Bayer wrote: The only

[sqlalchemy] subqueryload does not populate relation if backref is joined

2013-12-11 Thread Dmitry Mugtasimov
My question from stackoverflow: http://stackoverflow.com/questions/20519910/subqueryload-does-not-populate-relation-if-backref-is-joined Why CASE 4 (see output) does not provide related children. It looks like if it happens because subqueryload does not populate relation if backref is

[sqlalchemy] sqlacodegen 1.1.3 released.

2013-12-11 Thread Alex Grönholm
This release fixes compatibility with SQLAlchemy 0.8.3 and onwards. The test suite passes on SQLAlchemy 0.9.0b1 as well. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an

Re: [sqlalchemy] Find out what's going to be deleted

2013-12-11 Thread Michael Bayer
On Dec 11, 2013, at 8:02 AM, Tim Kersten t...@io41.com wrote: The before_delete and after_delete shouldn't make use of the current Session though, according to http://docs.sqlalchemy.org/en/rel_0_9/orm/events.html?highlight=after_delete#sqlalchemy.orm.events.MapperEvents.after_delete

Re: [sqlalchemy] multiple databases?

2013-12-11 Thread Jonathan Vanasco
richard - how are you handle the scoping and management of sessions ? i'm wanting (badly) to convert some twisted code that is using raw sql through their db api onto the sqlalchemy model for my core app. -- You received this message because you are subscribed to the Google Groups sqlalchemy

Re: [sqlalchemy] Find out what's going to be deleted

2013-12-11 Thread Tim Kersten
On 11 Dec 2013, at 16:32, Michael Bayer mike...@zzzcomputing.com wrote: On Dec 11, 2013, at 8:02 AM, Tim Kersten t...@io41.com wrote: The before_delete and after_delete shouldn't make use of the current Session though, according to

Re: [sqlalchemy] multiple databases?

2013-12-11 Thread Richard Gerd Kuesters
quite frankly, i'm handling them using deferreds, in a similar way you can find in sqlalchemy-future: https://github.com/lunant/SQLAlchemy-Future with this -- and using scoped sessions based on the callbacks, i can close the session quite nice. the code is very, very ugly for now, but i plan

Re: [sqlalchemy] table inheritance: how to change a record from base type to derived type?

2013-12-11 Thread Iain Duncan
On Tue, Dec 10, 2013 at 3:54 PM, Michael Bayer mike...@zzzcomputing.comwrote: On Dec 10, 2013, at 5:04 PM, Iain Duncan iainduncanli...@gmail.com wrote: Hi, I'm stuck on how to do something that I'm sure must be possible. I have two kinds of records, using table inheritance, Client, and

Re: [sqlalchemy] table inheritance: how to change a record from base type to derived type?

2013-12-11 Thread Michael Bayer
On Dec 11, 2013, at 12:45 PM, Iain Duncan iainduncanli...@gmail.com wrote: On Tue, Dec 10, 2013 at 3:54 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Dec 10, 2013, at 5:04 PM, Iain Duncan iainduncanli...@gmail.com wrote: Hi, I'm stuck on how to do something that I'm sure must be

Re: [sqlalchemy] subqueryload does not populate relation if backref is joined

2013-12-11 Thread Michael Bayer
On Dec 11, 2013, at 8:12 AM, Dmitry Mugtasimov dmugtasi...@gmail.com wrote: My question from stackoverflow: http://stackoverflow.com/questions/20519910/subqueryload-does-not-populate-relation-if-backref-is-joined Why CASE 4 (see output) does not provide related children. It looks like if

Re: [sqlalchemy] subqueryload does not populate relation if backref is joined

2013-12-11 Thread Dmitry Mugtasimov
Thank you very much. среда, 11 декабря 2013 г., 21:58:57 UTC+4 пользователь Michael Bayer написал: On Dec 11, 2013, at 8:12 AM, Dmitry Mugtasimov dmugt...@gmail.comjavascript: wrote: My question from stackoverflow: