Re: [sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

2016-08-12 Thread Douglas Russell
ell/508e8b33fe92434eafe001ee806f355a My knowledge of how subqueryload is extremely limited so it's possible I'm doing something wrong here, but having made this test case, what I was doing seems logical so I figured it was maybe a bug. Cheers, Douglas On Thursday, 11 August 2016 19:08:57 UTC-4, Douglas Russell wr

Re: [sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

2016-08-11 Thread Douglas Russell
Thanks for your help, Mike! Douglas On Thu, 11 Aug 2016 at 17:14 Mike Bayer <mike...@zzzcomputing.com> wrote: > > > On 08/11/2016 03:35 PM, Douglas Russell wrote: > > Of course! That makes sense. > > > > Does SQLAlchemy just discard the subqueryload chain par

Re: [sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

2016-08-11 Thread Douglas Russell
this in the abstract as you say! Thanks again, Douglas On Thursday, 11 August 2016 11:51:39 UTC-4, Mike Bayer wrote: > > > > On 08/11/2016 09:53 AM, Douglas Russell wrote: > > of_type was what I was searching for. Thanks. > > > > Unfortunately, it did not yield the d

[sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

2016-08-11 Thread Douglas Russell
C2 Cheers, Douglas On Wednesday, 10 August 2016 18:18:27 UTC-4, Douglas Russell wrote: > > Hi, > > I have two (well, more than two with more than two levels each, but this > is the simplest recreation of the problem) parallel joined-table > inheritance hierarchies > >

[sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

2016-08-10 Thread Douglas Russell
Finally, you can't see it on the Gist, but there is a branch on the repo if you clone it called 'more_relations' with the code for my joinedload test. Sorry for 3 posts where 1 would have been better! Thanks On Wednesday, 10 August 2016 18:18:27 UTC-4, Douglas Russell wrote: > > Hi, >

[sqlalchemy] Re: subqueryload with multiple joined table inheritance hierarchies

2016-08-10 Thread Douglas Russell
Scratch that last bit about the joinedload working. It does succeed in doing the joinedload to get all the data in one go, but it still lazy loads the B2 fields despite them already having been queried. On Wednesday, 10 August 2016 18:18:27 UTC-4, Douglas Russell wrote: > > Hi, > >

[sqlalchemy] subqueryload with multiple joined table inheritance hierarchies

2016-08-10 Thread Douglas Russell
Hi, I have two (well, more than two with more than two levels each, but this is the simplest recreation of the problem) parallel joined-table inheritance hierarchies A -> A2 B -> B2 B.a is a relationship to A, backref in A.bs. The problem arises when I want to query this whole structure back

[sqlalchemy] Re: Update with where, ORM with joined table inheritance

2016-06-23 Thread Douglas Russell
Thanks, that would definitely be an option if it weren't for the joined table inheritance as we need to be sure that the whole object is being updated as one. Cheers, Douglas On Thursday, 23 June 2016 16:57:29 UTC-4, Jonathan Vanasco wrote: > > for what it's worth... > > I handle a similar

Re: [sqlalchemy] Update with where, ORM with joined table inheritance

2016-06-23 Thread Douglas Russell
June 2016 15:25:19 UTC-4, Mike Bayer wrote: > > > > On 06/23/2016 02:42 PM, Douglas Russell wrote: > > Hi, > > > > I have a situation where I need to check a condition during an update. > > In my case it is a timestamp and the functio

[sqlalchemy] Update with where, ORM with joined table inheritance

2016-06-23 Thread Douglas Russell
Hi, I have a situation where I need to check a condition during an update. In my case it is a timestamp and the function of the condition is to ensure that there was no intermittent update by another between the type the object was edited and when it was saved. In this example though, I just

Re: [sqlalchemy] mapper_configured event, class fully configured?

2015-08-27 Thread Douglas Russell
more readable to have the relationship properties declared where they will exist. Cheers, Douglas On Monday, 24 August 2015 21:54:17 UTC-4, Michael Bayer wrote: On 8/24/15 9:21 PM, Mike Bayer wrote: On 8/24/15 7:41 PM, Douglas Russell wrote: def print_stuff(mapper, class_): print

[sqlalchemy] mapper_configured event, class fully configured?

2015-08-24 Thread Douglas Russell
Hi again, I'm trying to track an issue making use of Marshmallow-SQLAlchemy (I've also seen what looks like a very similar problem in ColanderAlchemy, but I haven't dug into that yet). I think it might have something to do with the mapper_configured event and whether the class is truly fully

Re: [sqlalchemy] Multiple JOINs of superclass table and potential discrepancy in chained vs on-clause

2015-08-10 Thread Douglas Russell
you want to again join from B. You need to be using from_joinpoint here: q = q.join(A.x_list, from_joinpoint=True) it then knows you want to join from A and not B. On 8/3/15 11:13 AM, Douglas Russell wrote: Hi again, Full code: https://gist.github.com/dpwrussell

[sqlalchemy] Re: Polymorphic self referential foreign key in sqlalchemy

2015-07-23 Thread Douglas Russell
Perfect, thanks! On Monday, 20 July 2015 10:49:26 UTC-4, Douglas Russell wrote: Apologies for cross-posting this, but I realised that this might be a better place to get an answer than this Stackoverflow question http://stackoverflow.com/questions/31393824/polymorphic-self-referential

[sqlalchemy] Polymorphic self referential foreign key in sqlalchemy

2015-07-20 Thread Douglas Russell
Apologies for cross-posting this, but I realised that this might be a better place to get an answer than this Stackoverflow question http://stackoverflow.com/questions/31393824/polymorphic-self-referential-foreign-key-in-sqlalchemy that I asked a week ago. I am trying to resolve a problem