def add_student():
if request.method == 'GET':
grades = Grade.query.all()
return render_template('addstu.html', grades=grades)
if request.method == 'POST':
s_name = request.form.get('s_name')
g_id = request.form.get('g_id')
stu = Student(s_name)
stu.grades = g_id
db.session.add(stu)
db.session.commit()
return redirect(url_for('main.show_student'))
def create_stu_by_grade():
if request.method == 'GET':
g_id = request.args.get('g_id')
return render_template('create_student.html', g_id=g_id)
if request.method == 'POST':
g_id = request.form.get('g_id')
username = request.form.get('username')
stu = Student()
stu.s_name = username
stu.grades = g_id
db.session.add(stu)
db.session.commit()
return redirect(url_for('user.grade_all'))
def auto_add_student():
firstname_list = [
'赵', '钱', '孙', '李', '周', '武', '郑', '王', '杨', '唐', '刘', '方'
]
lastname_list = [
'倩倩', '微微', '萌萌', '珠珠', '点点', '姗姗', '娜娜', '玉玉', '婉婉', '琪琪', '依依', '思思',
'迪迪', '霏霏', '珂珂', '乐乐', '米米'
]
student_list = []
for i in range(100):
name = choice(firstname_list) + choice(lastname_list)
stu = Student(name)
stu.grades = randint(1, 6)
student_list.append(stu)
db.session.add_all(student_list)
db.session.commit()
return '自动添加学生成功'
def create_stu_by_grade():
"""
班级中添加学生
"""
if request.method == 'GET':
g_id = request.args.get('g_id')
return render_template('create_student.html', g_id=g_id)
if request.method == 'POST':
g_id = request.form.get('g_id')
s_name = request.form.get('stuname')
# 创建学生对象
stu = Student()
stu.s_name = s_name
stu.grades = g_id
db.session.add(stu)
db.session.commit()
return redirect(url_for('user.stu_list'))
