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)
