Re: [sqlalchemy] Filtering self referential relationship

2020-04-13 Thread Mike Bayer
On Mon, Apr 13, 2020, at 11:16 AM, taha wrote: > Hi, > > I have the following model: > > class Categories(Base): >  __tablename__ = "categories" > >  parent_id = db.Column(db.Integer, ForeignKey('categories.id')) >  name = db.Column(db.String(128), nullable=False) >  status =

[sqlalchemy] Filtering self referential relationship

2020-04-13 Thread taha
Hi, I have the following model: class Categories(Base): __tablename__ = "categories" parent_id = db.Column(db.Integer, ForeignKey('categories.id')) name = db.Column(db.String(128), nullable=False) status = db.Column(db.Boolean, nullable=False, default=True) children =