创建多对多关系表
创建学生表
class Student(db.Model):
s_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
s_name = db.Column(db.String(20), unique=True)
s_age = db.Column(db.Integer, default=18)
__tablename__ = 'student'
def __init__(self, name, age):
self.s_name = name
self.s_age = age
创建学生、课程表的中间表
sc = db.Table('sc',
# 字段s_id, 外键关联学生表的s_id
db.Column('s_id', db.Integer, db.ForeignKey('student.s_id'), primary_key=True),
# 字段c_i, 外键关联课程表的c_id
db.Column('c_id', db.Integer, db.ForeignKey('course.c_id'), primary_key=True)
)
创建课程表
class Course(db.Model):
c_id = db.Column(db.Integer, primary_key=True, autoincrement=True)
c_name = db.Column(db.String(10), unique=True)
students = db.relationship('Student', secondary=sc, backref='cou')
__tablename__ = 'course'
def __init__(self, name):
self.c_name = name
向课程表中插入数据
@stu.route('/addcourse/')
def add_course():
courses = ['高数', '思修', '英语', '造价', '结构']
course_list = []
for course in courses:
cou = Course(course)
course_list.append(cou)
db.session.add_all(course_list)
db.session.commit()
return