def updAlumni(): pass ret = checkAuth() if ret != None: return ret alumni_id = request.args.get('alumni_id') if alumni_id == None: return bad_request(None, 'alumni_id is None') mysqlSession = mysql.session form = AlumniForm(lst=mysqlSession.query(School).all()) alumni = mysqlSession.query(Alumni).filter(Alumni.alumni_id == alumni_id).first() error = None if form.validate_on_submit(): alumni.name = request.form['name'] alumni.graduate = request.form['graduate'] alumni.email = request.form['email'] alumni.tel = request.form['tel'] alumni.email = request.form['email'] alumni.remark = request.form['remark'] alumni.industry = request.form['industry'] alumni.manager = request.form['manager'] try: mysqlSession.add(alumni) mysqlSession.commit() return execSuccess('修改成功') except sqlalchemy.exc.IntegrityError, e: mysqlSession.rollback() return bad_request(e) except Exception, e: mysqlSession.rollback() return bad_request(e)
def addAlumni(): pass ret = checkAuth() if ret != None: return ret mysqlSession = mysql.session form = AlumniForm(lst=mysqlSession.query(School).all()) error = None if form.validate_on_submit(): alumni = Alumni() alumni.name = request.form['name'] alumni.graduate = request.form['graduate'] alumni.email = request.form['email'] alumni.tel = request.form['tel'] alumni.email = request.form['email'] alumni.remark = request.form['remark'] alumni.industry = request.form['industry'] alumni.manager = request.form['manager'] try: mysqlSession.add(alumni) mysqlSession.commit() except sqlalchemy.exc.IntegrityError, e: mysqlSession.rollback() return bad_request(e) except Exception, e: mysqlSession.rollback() return bad_request(e)