def post(self, student_id=None):
student = StudentModel()
form = StudentForm()
if student_id == None:
if form.validate_on_submit():
form.populate_obj(student)
db_session.add(student)
db_session.commit()
return redirect('student_test')
else:
if form.validate_on_submit():
student_by_id = student.query.get(student_id)
student_by_id.studentUid = form.studentUid.data
student_by_id.nameLast = form.nameLast.data
student_by_id.nameFirst = form.nameFirst.data
student_by_id.email = form.email.data
student_by_id.phone = form.phone.data
student_by_id.major = form.major.data
student_by_id.programCode = form.programCode.data
student_by_id.semBegin = form.semBegin.data
student_by_id.graduationExpected = form.graduationExpected.data
student_by_id.creditFall = form.creditFall.data
student_by_id.creditSpring = form.creditSpring.data
student_by_id.request201408 = form.request201408.data
student_by_id.request201501 = form.request201501.data
db_session.commit()
return redirect('student_test')
return redirect('/')
def delete(self, student_id):
student = StudentModel()
student_by_id = student.query.get(student_id)
db_session.delete(student_by_id)
db_session.commit()
return redirect('student_test')
def post(self):
"create new student record, http://flask.pocoo.org/snippets/63/ for easy WTforms redirect"
student = StudentModel()
form = StudentForm()
if form.validate_on_submit():
form.populate_obj(student)
'''student = StudentModel(
None,
form.studentUid.data,
form.nameLast.data,
form.nameFirst.data,
form.email.data,
form.phone.data,
form.major.data,
form.programCode.data,
form.semBegin.data,
form.graduationExpected.data,
form.creditFall.data,
form.creditSpring.data,
form.request201408.data,
form.request201501.data
)'''
db_session.add(student)
db_session.commit()
return redirect('/')
return render_template('student_review.html', student_list=student, form=form)
def put(self, student_id):
student = StudentModel()
student_by_id = student.query.get(student_id)
form = StudentForm()
if form.validate_on_submit():
form.populate_obj(student)
db_session.update(student_by_id)
db_session.commit()
return redirect('student_test')
return redirect('/')
def post(self, position_id):
"create application record"
applications = ApplicationModel()
form = ApplicationForm(request.form)
if form.validate():
applications(form.app_id.data,
form.student_id.data,
form.position_id.data
)
return application
db_session.add(application)
db_session.commit()
def post(self):
"create supervisor record"
supervisor = SupervisorModel()
form = SupervisorForm()
if form.validate():
supervisor(
10,
form.nameLast.data,
form.nameFirst.data,
form.phone.data,
form.email.data,
form.room.data,
form.center.data
)
db_session.add(supervisor)
db_session.commit()
return redirect('/')
def put(self, student_id):
"edit student record"
"http://wtforms.simplecodes.com/docs/0.6.1/forms.html#wtforms.form.Form.populate_obj"
student = StudentModel()
student_update = student.query.get(student_id)
current_student = [student_update]
form = StudentForm()
student_update.studentUid=form.studentUid.data
student_update.nameLast=form.nameLast.data
student_update.nameFirst=form.nameFirst.data
student_update.email=form.email.data
student_update.phone=form.phone.data
student_update.major=form.major.data
student_update.programCode=form.programCode.data
student_update.semBegin=form.semBegin.data
student_update.graduationExpected=form.graduationExpected.data
student_update.creditFall=form.creditFall.data
student_update.creditSpring=form.creditSpring.data
student_update.request201408=form.request201408.data
student_update.request201501=form.request201501.data
db_session.commit()
if form.validate_on_submit():
student_update.studentUid=form.studentUid.data
student_update.nameLast=form.nameLast.data
student_update.nameFirst=form.nameFirst.data
student_update.email=form.email.data
student_update.phone=form.phone.data
student_update.major=form.major.data
student_update.programCode=form.programCode.data
student_update.semBegin=form.semBegin.data
student_update.graduationExpected=form.graduationExpected.data
student_update.creditFall=form.creditFall.data
student_update.creditSpring=form.creditSpring.data
student_update.request201408=form.request201408.data
student_update.request201501=form.request201501.data
db_session.commit()
return redirect('/')
return redirect('/')
