def existUser(userId): query = session.query(User).filter_by(userId=userId) result = {} try: query.one() except NoResultFound, e: result['requestCode'] = -1 result['requestMessage'] = u'존재하지 않는 유저입니다.' return result
def getScore(userId): existUserId = existUser(userId) if existUserId['requestCode'] == -1: return json.dumps(existUserId, ensure_ascii=False) query = session.query(User).filter_by(userId=userId) result = {} user = query.first() result['requestCode'] = 1 result['userId'] = user.userId result['score'] = user.score return json.dumps(result, ensure_ascii=False)
def getScoreAll(): query = session.query(User).order_by(User.score.desc()).all() result = {} result['users'] = [] for user in query: item = {} item['userId'] = user.userId item['score'] = user.score result['users'].append(item) result['requestCode'] = 1 result['requestMessage'] = u'성공적으로 값을 받아왔습니다.' return json.dumps(result, ensure_ascii=False)
def registScore(userId): existUserId = existUser(userId) if existUserId['requestCode'] == -1: return json.dumps(existUserId, ensure_ascii=False) query = session.query(User).filter_by(userId=userId) result = {} user = query.first() if user.setScore(request.args.get('score')): result['requestCode'] = 1 result['requestMessage'] = u'스코어가 갱신되었습니다.' result['score'] = user.score session.commit() else: result['requestCode'] = 2 result['requestMessage'] = u'최고점수를 넘지 못했습니다.' return json.dumps(result, ensure_ascii=False)
def registUser(): id = request.args.get('id') query = session.query(User).filter_by(userId=id) result = {} try: query.one() except NoResultFound, e: user = User(id) session.add(user) session.commit() result['requestCode'] = 1 result['requestMessage'] = u'등록되었습니다.' result['userId'] = user.userId result['highScore'] = user.score return json.dumps(result, ensure_ascii=False)
result = {} try: query.one() except NoResultFound, e: user = User(id) session.add(user) session.commit() result['requestCode'] = 1 result['requestMessage'] = u'등록되었습니다.' result['userId'] = user.userId result['highScore'] = user.score return json.dumps(result, ensure_ascii=False) user = session.query(User).filter_by(userId=id).first() result['requestCode'] = 2 result['requestMessage'] = u'이미 등록되어있습니다' result['userId'] = user.userId result['highScore'] = user.score return json.dumps(result, ensure_ascii=False) @app.route('/regist/score/<userId>', methods=['GET', 'POST']) def registScore(userId): existUserId = existUser(userId) if existUserId['requestCode'] == -1: return json.dumps(existUserId, ensure_ascii=False) query = session.query(User).filter_by(userId=userId) result = {}