Re: [SQLObject] ForeignKey...

[Philippe N. <ph...@re...>]

Le 2/11/2004, "Michel Thadeu" <mic...@ya...> a =E9crit:

>Hi guys,
>
>I have 2 tables, question and reply:
>
>class Question(SQLObject):
>   content=3DStringCol()
>   parent=3DForeignKey('Reply')
>   childs=3DMultipleJoin('Reply')
>
>class Reply(SQLObject):
>   content=3DStringCol()
>   parent=3DForeignKey('Question')
>   childs=3DMultipleJoin('Question')
>
>One question can has infinite replies and one reply can has infinite
>subquestions, if my user don't understand the reply... I using
>SQLObject from svn with postgresql.
>
>

Use a RelatedJoin ?

class Question(SQLObject):
   content =3D StringCol()
   replies =3D RelatedJoin('Reply')

class Reply(SQLObject):
    content =3D StringCol()
    questions =3D RelatedJoin('Question')

Philippe