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