[Sqlalchemy-tickets] Issue #3403: 1.0 regression re: column_descriptions w/ CTE (zzzeek/sqlalchemy)
Brought to you by:
zzzeek
|
From: Mike B. <iss...@bi...> - 2015-04-30 16:04:51
|
New issue 3403: 1.0 regression re: column_descriptions w/ CTE https://bitbucket.org/zzzeek/sqlalchemy/issue/3403/10-regression-re-column_descriptions-w-cte Mike Bayer: ``` #!python from sqlalchemy import * from sqlalchemy.orm import * from sqlalchemy.ext.declarative import declarative_base from sqlalchemy.orm import aliased Base = declarative_base() class Part(Base): __tablename__ = 'part' part = Column(String, primary_key=True) sub_part = Column(String, primary_key=True) quantity = Column(Integer) e = create_engine("postgresql://scott:tiger@localhost/test", echo=True) Base.metadata.create_all(e) session = Session(e) included_parts = session.query( Part.sub_part, Part.part, Part.quantity).\ filter(Part.part=="our part").\ cte(name="included_parts", recursive=True) incl_alias = aliased(included_parts, name="pr") parts_alias = aliased(Part, name="p") included_parts = included_parts.union_all( session.query( parts_alias.sub_part, parts_alias.part, parts_alias.quantity).\ filter(parts_alias.part==incl_alias.c.sub_part) ) q = session.query(included_parts) print q.column_descriptions ``` ``` #! Traceback (most recent call last): File "test.py", line 40, in <module> print q.column_descriptions File "/Users/classic/dev/sqlalchemy/lib/sqlalchemy/orm/query.py", line 2582, in column_descriptions for ent in self._entities AttributeError: 'CTE' object has no attribute 'entity' ``` |