def create_stu_gra():
stu = Students()
stu.s_name = '李哥'
stu.s_age = 27
stu.s_g = 3
stu.save()
return '一对多一个学生添加成功'
def create_stu_many():
# 实现创建多个功能
names = ['贪狼', '释天', '无相', '青冥', '太上', '无为', '北斗', '七殇', '三才', '布衣']
stu_list = []
for name in names:
stu = Students()
stu.s_name = name
# 避免多次IO操作
# stu.save()
stu_list.append(stu)
db.session.add_all(stu_list)
db.session.commit()
return '创建多个学生信息成功'
def create_stu_many():
# 实现创建多个功能
names = ['纳兰', '性德', '容若', '太白', '牧之', '青莲', '武斗', '南山', '一笑', '殺']
stu_list = []
for name in names:
stu = Students()
stu.s_name = name
# 避免多次IO操作
# stu.save()
stu_list.append(stu)
db.session.add_all(stu_list)
db.session.commit()
return '创建多个学生信息成功'
def create_stu_all():
# 批量创建，add_all()
names = ['小王', '老王', '厂长', '李哥', '小花']
stu_list = []
for name in names:
stu = Students()
stu.s_name = name
# stu.save()
# db.session.add(stu)
stu_list.append(stu)
db.session.add_all(stu_list)
db.session.commit()
return '批量创建学生信息成功'
def create_stus_gra():
names = ['老王', '55开', 'uzi', '大哥', '麻辣香锅', 'god', 'wawa']
stu_list = []
i = 1
for name in names:
stu = Students()
stu.s_name = name
stu.s_g = i % 5 + 1
i += 1
stu_list.append(stu)
db.session.add_all(stu_list)
db.session.commit()
return '一对多批量学生添加成功'
def create_stu():
# 实现创建功能
stu = Students()
stu.s_name = '小明1'
stu.save()
return '创建学生信息成功'
def create_stu():
# 实现学生对象的创建
stu = Students()
stu.s_name = '小明'
stu.save()
return '创建学生信息成功'