Re: [SQLObject] Storing object from same table

[Timo <tim...@gm...>]

On 13-08-11 15:43, Timo wrote:
> Hello, sorry if I use the wrong terminology, I just started with 
> SQLObject and databases in general.
>
> This is my current class:
> class Person(SQLObject):
>     name = StringCol(notNone=True)
>     father = StringCol(default='')
>     mother = StringCol(default='')
Sorry about the fuzz, after some more searching and experimenting, I 
came up with the following which seems to work fine:

class Person(SQLObject):
     name = StringCol(notNone=True)
     father = ForeignKey('Person', default=None)
     mother = ForeignKey('Person', default=None)

p1 = Person(name='John')
print p1, p1.father, p1.mother
p2 = Person(name='Jane')
print p2, p2.father, p2.mother
p3 = Person(name='Jeff', father=p1, mother=p2)
print p3, p3.father, p3.mother

Cheers,
Timo

>
> This stores the names for the person's father and mother, but when I 
> want to access their data, I need to fetch their names first and then 
> lookup their objects from the database. What I actually want, is that 
> father and mother are references to their own Person object. Is 
> something like this possible? I read about SingleJoin/MultipleJoin, 
> but it always references to another table.
>
> Cheers,
> Timo