예제 #1
0
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)
예제 #2
0
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)