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
)
