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'))