Re: [sqlalchemy] Re: Self-Referential Many-to-Many Relationship: related nodes

2012-08-24 Thread adolfo
Thanks again, Michael. I guess for now I will be using a view as a workaround, yet using your core (brilliant) ideas for the issue. Thanks a lot for all your great work. Sqlalchemy changed my life :-) Adolfo On Tuesday, August 21, 2012 11:09:05 PM UTC-5, Michael Bayer wrote: On Aug 21,

[sqlalchemy] Re: Self-Referential Many-to-Many Relationship: related nodes

2012-08-21 Thread adolfo
Hi Michael and all I successfully built a all nodes relationship following your guidelines. As: subq1=select([caso_vinculo.c.caso_1_id.label('id1'),caso_vinculo.c.caso_2_id.label('id2')]).union(select([caso_vinculo.c.caso_2_id, caso_vinculo.c.caso_1_id])) subq2=aliased(subq1) CasoMapper