def updSchool():
pass
ret = checkAuth()
if ret != None:
return ret
sch_id = request.args.get('sch_id')
if sch_id == None:
return bad_request(None, 'sch_id is None')
mysqlSession = mysql.session
school = mysqlSession.query(School).filter(School.sch_id == sch_id).first()
form = SchoolForm()
if form.validate_on_submit():
pass
school.full_name = request.form['full_name']
school.en_name = request.form['en_name']
school.nick_list = request.form['nick_list']
school.tel = request.form['tel']
school.email = request.form['email']
school.push_url = request.form['push_url']
try:
mysqlSession.add(school)
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 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 delAlumni():
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
try:
ret = mysqlSession.query(Alumni).filter(Alumni.alumni_id == alumni_id).delete()
mysqlSession.commit()
if ret > 0:
return execSuccess('del Alumni')
elif ret == 0:
return bad_request(None, 'Alumni is wrong ')
except sqlalchemy.exc.IntegrityError, e:
mysqlSession.rollback()
return bad_request(e)
def delCrawlerRecord():
pass
ret = checkAuth()
if ret != None:
return ret
crawler_id = request.args.get('crawler_id')
if crawler_id == None:
return bad_request(None, 'crawler_id is None')
mysqlSession = mysql.session
try:
ret = mysqlSession.query(School).filter(CrawlerRecord.crawler_id == crawler_id).delete()
mysqlSession.commit()
if ret > 0:
return execSuccess('del crawler_record')
elif ret == 0:
return bad_request(None, 'crawler_id is wrong ')
except sqlalchemy.exc.IntegrityError, e:
mysqlSession.rollback()
return bad_request(e)
def delSchool():
pass
ret = checkAuth()
if ret != None:
return ret
sch_id = request.args.get('sch_id')
if sch_id == None:
return bad_request(None, 'sch_id is None')
mysqlSession = mysql.session
try:
ret = mysqlSession.query(School).filter(School.sch_id == sch_id).first()
mysqlSession.delete(ret)
mysqlSession.commit()
if ret > 0:
return execSuccess('del school')
elif ret == 0:
return bad_request(None, 'sch_id is wrong ')
except sqlalchemy.exc.IntegrityError, e:
mysqlSession.rollback()
return bad_request(e)
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)
finally:
mysqlSession.close()
# mysqlSession = mysqlSession()
return execSuccess('add alumni')
form.graduate.data = 1
return defaultRender('add_alumni.html', form=form)
@app.route('/alumni/upd', methods=['GET', 'POST'])
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())
school.email = request.form['email']
school.push_url = request.form['push_url']
mysqlSession = mysql.session
try:
mysqlSession.add(school)
mysqlSession.commit()
except sqlalchemy.exc.IntegrityError, e:
mysqlSession.rollback()
return bad_request(e)
except Exception, e:
mysqlSession.rollback()
return bad_request(e)
finally:
mysqlSession.close()
# mysqlSession = mysqlSession()
return execSuccess('add school')
return defaultRender('add_school.html', form=form)
@app.route('/school/del', methods=['GET', 'POST'])
def delSchool():
pass
ret = checkAuth()
if ret != None:
return ret
sch_id = request.args.get('sch_id')
if sch_id == None:
return bad_request(None, 'sch_id is None')
mysqlSession = mysql.session
try:
ret = mysqlSession.query(School).filter(School.sch_id == sch_id).first()
