Re: [sqlalchemy] Dynamic query

2011-05-09 Thread Enrico Morelli
On Fri, 6 May 2011 17:11:39 +0100 King Simon-NFHD78 simon.k...@motorolasolutions.com wrote: -Original Message- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Enrico Morelli Sent: 06 May 2011 16:20 To: sqlalchemy Subject: [sqlalchemy]

[sqlalchemy] Queries issued with 'passive_deletes'

2011-05-09 Thread Israel Ben Guilherme Fonseca
I didn't get why issuing selects for the children objects when passive_deletes=False. Wouldn't be better just issue direct deletes, and maybe using subselects in the where clause of these deletes (for nested associations) when approriate? It would solve the overhead problem of the selecting large

Re: [sqlalchemy] Queries issued with 'passive_deletes'

2011-05-09 Thread Michael Bayer
On May 9, 2011, at 7:57 AM, Israel Ben Guilherme Fonseca wrote: I didn't get why issuing selects for the children objects when passive_deletes=False. Wouldn't be better just issue direct deletes, and maybe using subselects in the where clause of these deletes (for nested associations)

[sqlalchemy] Problem with relationships and polymorphism

2011-05-09 Thread Matthias
[EDIT: Duh, forgot the attachment. Here it is.] Hello, I ran into a problem with relationships and polymorphism. I've attached a test case which runs on its own and shows my models. The version as given results in an exception for me: ArgumentError: Could not determine join condition between

[sqlalchemy] Problem with relationships and polymorphism

2011-05-09 Thread Matthias
Hello, I ran into a problem with relationships and polymorphism. I've attached a test case which runs on its own and shows my models. The version as given results in an exception for me: ArgumentError: Could not determine join condition between parent/child tables on relationship

Re: [sqlalchemy] Problem with relationships and polymorphism

2011-05-09 Thread Michael Bayer
On May 9, 2011, at 11:16 AM, Matthias wrote: [EDIT: Duh, forgot the attachment. Here it is.] Hello, I ran into a problem with relationships and polymorphism. I've attached a test case which runs on its own and shows my models. The version as given results in an exception for me:

[sqlalchemy] Re: deferred column sometimes lazily loaded, sometimes not

2011-05-09 Thread Bill Curtis
I dont understand the ultimate issue, unless its that you're getting the wrong data back. if its just that the data is being cached instead of it loading deferred, then yes that's just the caching query happening. it would need to be more careful about the state its placing in the cache -

Re: [sqlalchemy] Problem with relationships and polymorphism

2011-05-09 Thread Matthias
Am 09.05.2011, 17:50 Uhr, schrieb Michael Bayer mike...@zzzcomputing.com: On May 9, 2011, at 11:16 AM, Matthias wrote: [EDIT: Duh, forgot the attachment. Here it is.] Hello, I ran into a problem with relationships and polymorphism. I've attached a test case which runs on its own and

Re: [sqlalchemy] Queries issued with 'passive_deletes'

2011-05-09 Thread Israel Ben Guilherme Fonseca
Well, now it does make sense. :) Thanks for the explanation. 2011/5/9 Michael Bayer mike...@zzzcomputing.com On May 9, 2011, at 7:57 AM, Israel Ben Guilherme Fonseca wrote: I didn't get why issuing selects for the children objects when passive_deletes=False. Wouldn't be better just issue