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