Re: [sqlalchemy] from_statement and cte problem

2019-06-30 Thread Mike Bayer
On Sun, Jun 30, 2019, at 5:37 AM, sector119 wrote: > Nice, thanks a lot, Mike, now it works as expected that's great. the docs are not good here, there's not enough discussion of "aliased()" , from_statement() and what they do, also I'm changing some details of how they do their work for 1.4

Re: [sqlalchemy] from_statement and cte problem

2019-06-30 Thread sector119
Nice, thanks a lot, Mike, now it works as expected @property def path(self): session = object_session(self) def get_locality_path_q(locality_id): parent_q = session.query(Locality).filter(Locality.id == locality_id).cte(recursive=True) parents = aliased(parent_q)