def individual_com(): form = CompetitionIndividualForm() form.acachemys.query = Acachemy.query.all() form.teachers1.query = Teacher.query.all() form.teachers2.query = Teacher.query.all() form.competitions_name.query = ComName.query.all() print form.data if request.method=='POST' and form.validate(): competitions_name = form.competitions_name.data student = Student.query.filter_by(stu_id=form.student_id.data).first() acachemy = form.acachemys.data teacher1 = form.teachers1.data teacher2 = form.teachers2.data if student == None: student = Student( stu_id = form.student_id.data, stu_name = form.student_name.data, stu_major = form.student_major.data, stu_class = form.student_class.data ) student.acachemy = acachemy db.session.add(student) db.session.commit() competition_info = ComInfo( pro_name = form.project_name.data, com_level = form.competition_level.data, com_class = form.competition_class.data, com_org = form.competition_org.data, com_time = form.competition_date.data, com_sid = student.id, tea1_id = teacher1.id, tea2_id = teacher2.id, is_team = 0 ) competition_info.com_name = competitions_name db.session.add(competition_info) db.session.commit() return redirect(url_for('index')) return render_template('individual_com.html', form=form)
def individual_com(): form = CompetitionIndividualForm() form.acachemys.query = Acachemy.query.all() form.teachers1.query = Teacher.query.all() form.teachers2.query = Teacher.query.all() form.competitions_name.query = ComName.query.all() print form.data if request.method == 'POST' and form.validate(): competitions_name = form.competitions_name.data student = Student.query.filter_by(stu_id=form.student_id.data).first() acachemy = form.acachemys.data teacher1 = form.teachers1.data teacher2 = form.teachers2.data if student == None: student = Student(stu_id=form.student_id.data, stu_name=form.student_name.data, stu_major=form.student_major.data, stu_class=form.student_class.data) student.acachemy = acachemy db.session.add(student) db.session.commit() competition_info = ComInfo(pro_name=form.project_name.data, com_level=form.competition_level.data, com_class=form.competition_class.data, com_org=form.competition_org.data, com_time=form.competition_date.data, com_sid=student.id, tea1_id=teacher1.id, tea2_id=teacher2.id, is_team=0) competition_info.com_name = competitions_name db.session.add(competition_info) db.session.commit() return redirect(url_for('index')) return render_template('individual_com.html', form=form)