sqlalchemy多对多

最新推荐文章于 2025-09-23 09:40:45 发布

原创最新推荐文章于 2025-09-23 09:40:45 发布 · 390 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#python

本文介绍了学校表、教师表及其关联表的设计，展示了如何使用ORM方式管理学生与教师之间的多对多关系，重点在于数据库模型的定义和关系映射。

# class Student(BaseModel):
#     """
#     学校表
#     """
#
#     __tablename__ = "student"
#
#     id = db.Column(db.Integer, primary_key=True, doc='id')
#     name = db.Column(db.String(128), doc='姓名')
#     age = db.Column(db.Integer, doc='年龄')
#     teachers = db.relationship('Teacher', backref='student', secondary='student_teacher', doc='教师')
#
#     def __str__(self):
#         return self.name
#
#
# class Teacher(BaseModel):
#     """
#     教师表
#     """
#
#     __tablename__ = "teacher"
#
#     id = db.Column(db.Integer, primary_key=True, doc='id')
#     name = db.Column(db.String(128), doc='姓名')
#     subject = db.Column(db.String(128), doc='学科')
#     students = db.relationship('Student', backref='teacher', secondary='student_teacher', doc='学生')
#
#     def __str__(self):
#         return self.name
#
#
# class StudentTeacher(BaseModel):
#     """
#     学校和教师关联表
#     """
#
#     __tablename__ = "student_teacher"
#
#     id = db.Column(db.Integer, primary_key=True, doc='id')
#     student_id = db.Column(db.Integer, db.ForeignKey("student.id"), primary_key=True, doc='学生')
#     teacher_id = db.Column(db.Integer, db.ForeignKey("teacher.id"), primary_key=True, doc='教师')
#
#     def __str__(self):
#         return '{}-{}'.format(self.student_id, self.teacher_id)