--On 25. April 2007 07:13:19 -0400 Michael Bayer <[EMAIL PROTECTED]> wrote:
well i just noticed youre sticking an external table into your primaryjoin....but i see nothing there that implies the usage of a LEFT OUTER JOIN ? are you saying that you dont need the rows from AMH_View to be present ? how could SA possibly know that ? (if not, please send me the exact query being produced, and the exact query you think should be produced)
My first posting contains all the informations: The mapper code is: class HierarchyNode(MappedClassBase): pass mapper(HierarchyNode, HierarchyTable, properties={ ......omitting the code for the self-referential table... 'tools' : relation( HierarchyNode, primaryjoin=AMH_View.c.idhierarchy==HierarchyTable.c.id, foreign_keys=[AMH_View.c.idhierarchy], uselist=True, ), } ) Using 'tools' I am trying to obtain all rows from AMH_View whose 'idhierarchy' col match the 'id' value of the 'current' Hierarchy row. SA generates: select .... from hierarchy, arbeitsmittelhierarchy_arbeitsmittel_view where arbeitsmittelhierarchy_arbeitsmittel_view = some_id I would expect something likeselect ...from hierarchy H left join arbeitsmittelheirarchy_arbeitsmittel_view AMH on AMH.idhierarchy = H.id
where H.id = <current id> Andreas
pgpglXzX3XZZ4.pgp
Description: PGP signature