[Sqlalchemy-tickets] Issue #3627: self-relationship table bad work child/parent key (zzzeek/sqlalchemy)

[Ramin F. C. <iss...@bi...>]

New issue 3627: self-relationship table bad work child/parent key
https://bitbucket.org/zzzeek/sqlalchemy/issues/3627/self-relationship-table-bad-work-child

Ramin Farajpour Cami:

Hi,
i use one table in above model and insert to database (image 1) and i set breakpoint and i see first record ForeignKey (parent_id=Null ) with id=1 and second record with  ForeignKey 
(parent_id=1) and first record id=1 return list in children in second record but i see (image 2) full children list in first record in sele ,

 

>
>class Student(Base):

>        
>       __tablename__ = 'reltest'

>        id = Column(Integer, primary_key=True)
>        name = Column(String(50))
>        fullname = Column(String(50))
>        password = Column(String(50))
>        parent_id = Column(Integer, ForeignKey('reltest.id'),index=True)
>        children = relationship(lambda: Student)

Responsible: zzzeek