sqlobject-discuss

[SQLObject] self join

[Culley H. <har...@gm...>]

Hi,

I am trying to model a self join and having trouble.  Say we have a
table called node with two columns:  id, parent_id.  So we have a
class:

class Node(SQLObject):
    parent = ForeignKey('node')
    children = MultipleJoin('node', joinColumn='parentID')

The childrens reference is invalid.  How do I do this?

culley

[SQLObject] Re: self join

[Culley H. <har...@gm...>]

I figured it out.  I wasn't grokking the naming conventions....  the
multiple join column has to be named just so and the joinColumn
reference is to the actual column name rather than the sqlobject
munged column name.  Makes for some ugly method names when dealing
with legacy tables but that is ok!

All is good-- Ian thanks for all your hard work on this!  Amazing tool...

culley


On Fri, 1 Oct 2004 18:20:52 -0700, Culley Harrelson <har...@gm...> wrote:
> Hi,
> 
> I am trying to model a self join and having trouble.  Say we have a
> table called node with two columns:  id, parent_id.  So we have a
> class:
> 
> class Node(SQLObject):
>     parent = ForeignKey('node')
>     children = MultipleJoin('node', joinColumn='parentID')
> 
> The childrens reference is invalid.  How do I do this?
> 
> culley
>