[sqlalchemy] [Q] How to return mapped instances from a recursive cte

2012-09-05 Thread Ladislav Lenart
Hello. I have the following example (Base is the usual declarative_base instance): class Node(Base): __tablename__ = 'node' id = Column(Integer(), primary_key=True) parent_id = Column(Integer(), ForeignKey('node.id')) def path(self, root_id): Query to return a list of

Re: [sqlalchemy] [Q] How to return mapped instances from a recursive cte

2012-09-05 Thread Michael Bayer
On Sep 5, 2012, at 9:05 AM, Ladislav Lenart wrote: Hello. I have the following example (Base is the usual declarative_base instance): class Node(Base): __tablename__ = 'node' id = Column(Integer(), primary_key=True) parent_id = Column(Integer(), ForeignKey('node.id'))