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
!! Adolfo On Monday, August 20, 2012 5:07:39 PM UTC-5, adolfo wrote: I have a Self-Referential Many-to-Many Relationship situation where the right_nodes = relationship(Node, secondary=node_to_node, primaryjoin=id==node_to_node.c.left_node_id

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

2012-08-21 Thread adolfo
, in _key_fallback expression._string_or_unprintable(key)) NoSuchColumnError: Could not locate column in row for column '%(67064688 caso)s.id' strange any idea? thanks for all this great effort. Adolfo On Monday, August 20, 2012 10:04:59 PM UTC-5, Michael Bayer wrote: On Aug 20

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

2012-08-20 Thread adolfo
, backref=left_nodes works fine. The problem: I need a related nodes relationship, which, in one expression, returns all related nodes, both left nodes and right nodes, excluding the given node itself. Is that possible using the RELATIONSHIP construct? Adolfo -- You

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

2012-08-20 Thread adolfo
the relation() functionality. Is there some way to accomplish that? Thanks again! Adolfo On Monday, August 20, 2012 5:35:51 PM UTC-5, Michael Bayer wrote: On Aug 20, 2012, at 6:07 PM, adolfo wrote: I have a Self-Referential Many-to-Many Relationship situation where the right_nodes = relationship

[sqlalchemy] Query with outerjoin and more that one table making a reference to a third one

2008-09-28 Thread adolfo
having 2 foreign references to another table works fine, like this: A - P A - P with P1 = aliased(P) P2 = aliased(P) but not this one. Do I am doing something wrong? Any help will be greatly appreciated!!! Adolfo --~--~-~--~~~---~--~~ You received this message

[sqlalchemy] Re: Query with outerjoin and more that one table making a reference to a third one

2008-09-28 Thread adolfo
Thanks a lot, Michael. I did not note about the tuple. I have to say that with the pattern A - P (aliased P1) A - P (aliased P2) it worked without an explicit tuple. A bug or a feature? ;) Adolfo On Sep 28, 4:25 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Sep 28, 2008, at 5:09 PM

[sqlalchemy] multiple foreign references to the same table

2008-09-27 Thread adolfo
(or reference) Adolfo -- Adolfo Dunayevich --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email

[sqlalchemy] Re: multiple foreign references to the same table

2008-09-27 Thread adolfo
That was of great help. Thanks a lot!! Adolfo On Sep 27, 9:04 am, Michael Bayer [EMAIL PROTECTED] wrote: On Sep 26, 2008, at 9:02 PM, adolfo wrote: Hello, and sorry if this issue is already covered. I have a table which makes foreign references to other table, and I   need to make