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)
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 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 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)
def addSchool(): pass ret = checkAuth() if ret != None: return ret form = SchoolForm() if form.validate_on_submit(): school = School() 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'] 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)