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)
