SqlAlchemy 关系

SqlAlchemy 关系

一对多

class Comment(db.Model):
    # ...
    
class User(db.Model):
    # ...
    comments = db.relationship('Comment', backref='author', lazy='dynamic')
class Post(db.Model):
    # ...
    comments = db.relationship('Comment', backref='post', lazy='dynamic')

• db.relationship()，关系只用设置一次。通过 backref 设定反向逻辑
• lazy='dynamic'，保证了关系属性返回的是查询对象。还可以继续跟过滤器

多对多

registrations = db.Table('registrations',
                         db.Column('student_id', db.Integer, db.ForeignKey('students.id')),
                         db.Column('class_id', db.Integer, db.ForeignKey('classes.id'))
                         )
class Student(db