class Shop(db.Model):
__tablename__ = 'shop'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(20), unique=True)
class Category(db.Model):
__tablename__ = 'category'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
shop_id = db.Column(db.Integer, db.ForeignKey('shop.id'), nullable=False)
shop = db.relationship('Shop')
name = db.Column(db.String(20))
class Food(db.Model):
__tablename__ = 'food'
id = db.Column(db.Integer, primarykey=True, autoincrement=True)
shop_id = db.Column(db.Integer, db.ForeignKey('shop.id'), nullable=False)
shop = db.relationship('Shop')
category_id = db.Column(db.Integer, db.ForeignKey('category.id'), nullable=False)
category = db.relationship('Category')
name = db.Column(db.String(20))
问题如下:
如何实现,根据Shop里的内容,过滤掉Shop里没有的Category
即:Shop为“路边烧烤摊”,对应的Category应该什么都不显示
flask-admin英文资料多,但是本人英语不好。希望好心人指定迷津,谢谢啦