def recordpage(): query = db.session.query(PlayerRecord, User) \ .join(User, User.id == PlayerRecord.userid) \ .join() query_datas = query.all() data = [] for (record, user) in query_datas: data.append({ 'record': model_to_dict(record) if record else None, 'user': model_to_dict(user) if user else None }) return jsonify( data = data )
def get_record_match(userid): query = db.session.query(MatchRecord, Match).filter(MatchRecord.userid == userid) \ .join(Match, Match.id == MatchRecord.matchid) \ .join() query_datas = query.all() print query_datas data = [] for(matchrecord, match) in query_datas: data.append( { 'matchrecord': model_to_dict(matchrecord) if matchrecord else None, 'match': model_to_dict(match) if match else None } ) return jsonify( data = data )
def get_record_players(): player_records = PlayerRecord.query.all() query_list = [] for record in player_records: temp = model_to_dict(record) query_list.append(temp) return jsonify( data = query_list )
def get_users(): users = User.query.all() query_list = [] for user in users: temp = model_to_dict(user) query_list.append(temp) print(query_list) return jsonify(data=query_list)
def get_matches(): matches = Match.query.all() query_list = [] for match in matches: temp = model_to_dict(match) query_list.append(temp) print(query_list) return jsonify(data=query_list)
def get_record_matches(): match_records = MatchRecord.query.all() query_list = [] for record in match_records: temp = model_to_dict(record) query_list.append(temp) return jsonify( data = query_list )
def get_match_record_by_userid(userid): query = db.session.query(MatchRecord).filter(MatchRecord.userid == userid) records = query.all() data = [] for record in records: temp = model_to_dict(record) data.append(temp) return jsonify( data = data )
def get_users(): users = User.query.all() query_list = [] for user in users: temp = model_to_dict(user) query_list.append(temp) print(query_list) return jsonify( data = query_list )
def login(): request_params = request.get_json() email = request_params.get('email') password = request_params.get('password') user = db.session.query(User).filter( and_(User.email == email, User.password == password)).first() if user is None: return jsonify(userMessage="Please check your email or password") data = model_to_dict(user) token = user.get_token_string() return jsonify(data=data, token=token)
def get_matches(): matches = Match.query.all() query_list = [] for match in matches: temp = model_to_dict(match) query_list.append(temp) print(query_list) return jsonify( data = query_list )
def login(): request_params = request.get_json() email = request_params.get('email') password = request_params.get('password') user = db.session.query(User).filter(and_(User.email == email, User.password == password)).first() if user is None: return jsonify( userMessage="Please check your email or password" ) data = model_to_dict(user) token = user.get_token_string() return jsonify( data=data, token=token )
def post_users(): email = request.files['email'] password = request.files['password'] backnumber = request.files['backnumber'] name = request.files['name'] info = request.files['info'] q = db.session.query(User).filter(User.email == email) if q.count() > 0: return jsonify(userMessage="your email is already enrolled") user = User(email=email, password=password, name=name, info=info, backnumber=backnumber) db.session.add(user) db.session.commit() return jsonify(data=model_to_dict(user), token=user.get_token_string())
def post_users(): email = request.files['email'] password = request.files['password'] backnumber = request.files['backnumber'] name = request.files['name'] info = request.files['info'] q = db.session.query(User).filter(User.email == email) if q.count() > 0: return jsonify( userMessage="your email is already enrolled" ) user = User(email=email, password=password, name=name,info=info, backnumber=backnumber) db.session.add(user) db.session.commit() return jsonify( data=model_to_dict(user), token=user.get_token_string() )
def post_matches(): request_params = request.get_json() tag = request_params.get('tag') against = request_params.get('against') where = request_params.get('where') when = request_params.get('when') matchinfo = request_params.get('matchinfo') score_gnp = request_params.get('score_gnp') score_enemy = request_params.get('score_enemy') finish = request_params.get('finish') win = request_params.get('win') match = Match(tag=tag,against=against,where=where,when=when,matchinfo=matchinfo,score_gnp=score_gnp,score_enemy=score_enemy,finish=finish,win=win) db.session.add(match) db.session.commit() return jsonify( data=model_to_dict(match) )
def post_matches(): request_params = request.get_json() tag = request_params.get('tag') against = request_params.get('against') where = request_params.get('where') when = request_params.get('when') matchinfo = request_params.get('matchinfo') score_gnp = request_params.get('score_gnp') score_enemy = request_params.get('score_enemy') finish = request_params.get('finish') win = request_params.get('win') match = Match(tag=tag, against=against, where=where, when=when, matchinfo=matchinfo, score_gnp=score_gnp, score_enemy=score_enemy, finish=finish, win=win) db.session.add(match) db.session.commit() return jsonify(data=model_to_dict(match))
def get_matches_by_id(matchid): match = Match.query.get(matchid) return jsonify(data=model_to_dict(match))
def get_matches_by_id(matchid): match = Match.query.get(matchid) return jsonify( data=model_to_dict(match) )
def get_player_record_by_userid(userid): query = db.session.query(PlayerRecord).filter(PlayerRecord.userid == userid) data = model_to_dict(query.first()) return jsonify( data = data )