def fillOutMatch(SESSION, match, name, id):
user = SESSION.query(User).filter(User.id == id).filter(
User.name == name).one()
d = datetime.strptime(match['started_at'], "%Y-%m-%dT%H:%M:%S%z")
_m = SESSION.query(Match).filter(Match.user_id==user.id).\
filter(Match.user_name==user.name).\
filter(Match.date==d).\
filter(Match.id==match['match_id']).all()
#Don't add duplicate data
if len(_m) > 0:
#my_print("duplicate data!")
return True
participant = match['participant']
stats = participant['stats']
combat = stats['combat']
m = Match()
m.pubg_id = participant['_id']
# 2018-01-24T03:10:17+0000
m.date = d
m.id = match['match_id']
m.mode = match['mode']
m.queue_size = match['queue_size']
m.rank = stats['rank']
m.rating_delta = stats['rating_delta']
m.boosts = combat['boosts']
m.damage = combat['damage']['damage_dealt']
m.knocks = combat['dbno']['knock_downs']
m.revives = combat['dbno']['revives']
m.death_type = combat['death_type']
m.ride_distance = combat['distance_traveled']['ride_distance']
m.walk_distance = combat['distance_traveled']['walk_distance']
m.distance_traveled = m.ride_distance + m.walk_distance
m.heals = combat['heals']
m.assists = combat['kda']['assists']
m.headshot_kills = combat['kda']['headshot_kills']
m.kill_steaks = combat['kda']['kill_steaks']
m.kills = combat['kda']['kills']
m.longest_kill = combat['kda']['longest_kill']
m.road_kills = combat['kda']['road_kills']
m.team_kills = combat['kda']['team_kills']
m.kda = m.kills + m.assists
m.kill_place = combat['kill_place']
m.most_damage = combat['most_damage']
m.time_survived = combat['time_survived']
m.vehicle_destroys = combat['vehicle_destroys']
m.weapon_acquired = combat['weapon_acquired']
m.win_place = combat['win_place']
m.user_id = user.id
m.user_name = user.name
m.user.append(user)
user.matches.append(m)
SESSION.add(m)
return False
def admin():
"""Admin page"""
if users.is_current_user_admin():
logout_url=users.create_logout_url('/admin')
method = request.args.get('m','')
logging.info('Method name:[%s]' % method)
if method == 'dropdb':
match_keys = Match.query().fetch(keys_only=True)
ndb.delete_multi(match_keys)
return render_template('admin.html', msg='Matches all deleted!', logout_url=logout_url)
if method == 'dropbet':
if not isLocal():
abort(401)
bet_keys = Bet.query().fetch(keys_only=True)
ndb.delete_multi(bet_keys)
return render_template('admin.html', msg='Bet all deleted!', logout_url=logout_url)
elif method == 'initdb':
with open('worldcup2014-group-stage.csv', 'rb') as csvfile:
spamreader = csv.reader(csvfile)
for row in spamreader:
match = Match( matchid=int(row[0]),
date=datetime.strptime(str(row[1]), "%m/%d/%Y %H:%M"),
stage=row[5],
team_a=row[2],
team_b=row[3],
score_a=None,
score_b=None,
extra_a=None,
extra_b=None,
penalty_a=None,
penalty_b=None
)
match.put()
return render_template('admin.html', msg='Matches imported!', logout_url=logout_url)
elif method == 'initdb2':
with open('worldcup2014-knockoff-stage.csv', 'rb') as csvfile:
spamreader = csv.reader(csvfile)
for row in spamreader:
match = Match( matchid=int(row[0]),
date=datetime.strptime(str(row[1]), "%m/%d/%Y %H:%M"),
stage=row[5],
team_a='winner of '+row[2],
team_b='winner of '+row[3],
score_a=None,
score_b=None,
extra_a=None,
extra_b=None,
penalty_a=None,
penalty_b=None
)
match.put()
return render_template('admin.html', msg='Matches imported!', logout_url=logout_url)
elif method == 'randombetwithknownuser':
for useremail in known_users.keys():
#drop existing first
existing_bets = Bet.query(Bet.useremail==useremail).fetch(keys_only=True)
ndb.delete_multi(existing_bets)
#new data
digits = 21
uid = str(int(random.random()*10**digits)).rjust(digits,'0')
matches = Match.query().fetch()
for match in matches:
bet = Bet( userid=uid,
useremail=useremail,
bet_match_id=int(match.matchid),
bet_amount=1,
score_a=random.randint(0,3),
score_b=random.randint(0,3),
extra_a=None,
extra_b=None,
penalty_a=None,
penalty_b=None
)
bet.put()
return render_template('admin.html', msg='simulated bets for known user has been generated!', logout_url=logout_url)
elif method == 'randombet':
digits = 21
uid = str(int(random.random()*10**digits)).rjust(digits,'0')
digits = 3
email = '*****@*****.**'%int(random.random()*10**digits)
matches = Match.query().fetch()
for match in matches:
bet = Bet( userid=uid,
useremail=email,
bet_match_id=int(match.matchid),
bet_amount=1,
score_a=random.randint(0,3),
score_b=random.randint(0,3),
extra_a=None,
extra_b=None,
penalty_a=None,
penalty_b=None
)
bet.put()
return render_template('admin.html', msg='simulated bets for %s has been generated!'%uid, logout_url=logout_url)
elif method == 'insertmatch':
match_id = int(request.args.get('id',0))
team_a = request.args.get('a',None) or None
team_b = request.args.get('b',None) or None
match_stage = request.args.get('s',None) or None
match_date = request.args.get('d',None) or None
score_a = request.args.get('sa',None) or None or None
score_b = request.args.get('sb',None) or None
extra_a = request.args.get('ea',None) or None
extra_b = request.args.get('eb',None) or None
penalty_a = request.args.get('pa',None) or None
penalty_b = request.args.get('pb',None) or None
matches = Match.query(Match.matchid==match_id).fetch()
if len(matches)==0:
match = Match( matchid=match_id,
date=datetime.strptime(match_date, "%d %B %Y %H:%M"),
stage=match_stage,
team_a=team_a,
team_b=team_b,
score_a=None,
score_b=None,
extra_a=None,
extra_b=None,
penalty_a=None,
penalty_b=None
)
logging.info('insert attempt:%s' % str(match))
match.put()
return render_template('admin.html',
msg='Match between %s and %s has been inserted!' %
(match.team_a, match.team_b), logout_url=logout_url)
else:
match = matches[0]
if match_date:
match.date = datetime.strptime(match_date, "%d %B %Y %H:%M")
if match_stage:
match.stage = match_stage
if team_a:
match.team_a = team_a
if team_b:
match.team_b = team_b
if score_a:
match.score_a = int(score_a)
if score_b:
match.score_b = int(score_b)
if extra_a:
match.extra_a = int(extra_a)
if extra_b:
match.extra_b = int(extra_b)
if penalty_a:
match.penalty_a = int(penalty_a)
if penalty_b:
match.penalty_b = int(penalty_b)
logging.info('update attempt:%s' % str(match))
match.put()
return render_template('admin.html',
msg='Match between %s and %s has been updated!' %
(match.team_a, match.team_b))
elif method == 'sendmail':
match_id = int(request.args.get('id',0))
subject = request.args.get('s',None) or None
body = request.args.get('b',None) or None
html = request.args.get('h',None) or None
logging.info('sendmail attempt:%s' % str(match_id))
if match_id > 0:
bets = Bet.query(Bet.bet_match_id==match_id).fetch()
match = Match.query(Match.matchid==match_id).fetch()[0]
addresses = []
[addresses.append(str(bet.useremail)) for bet in bets]
target_address = ';'.join(addresses)
#subject = "Match between %s and %s just started!" %(match.team_a, match.team_b)
#body = "http://localhost:8080/#/my"
#html = "<a href=\"http://localhost:8080/#/my\">My guess</a>"
send_mail(target_address, subject, body, html)
return render_template('admin.html',
msg='Mail to %s with <%s> has succeeded!' % (target_address, subject))
return render_template('admin.html',msg='You have to specify match id!', logout_url=logout_url)
return render_template('admin.html', logout_url=logout_url)
else:
return render_template('logout.html', logout_url=users.create_logout_url(request.path), login_url=users.create_login_url(request.path))
def admin():
"""Admin page"""
if users.is_current_user_admin():
logout_url = users.create_logout_url('/admin')
method = request.args.get('m', '')
logging.info('Method name:[%s]' % method)
if method == 'dropdb':
match_keys = Match.query().fetch(keys_only=True)
ndb.delete_multi(match_keys)
return render_template('admin.html',
msg='Matches all deleted!',
logout_url=logout_url)
if method == 'dropbet':
if not isLocal():
abort(401)
bet_keys = Bet.query().fetch(keys_only=True)
ndb.delete_multi(bet_keys)
return render_template('admin.html',
msg='Bet all deleted!',
logout_url=logout_url)
elif method == 'initdb':
with open('worldcup2014-group-stage.csv', 'rb') as csvfile:
spamreader = csv.reader(csvfile)
for row in spamreader:
match = Match(matchid=int(row[0]),
date=datetime.strptime(
str(row[1]), "%m/%d/%Y %H:%M"),
stage=row[5],
team_a=row[2],
team_b=row[3],
score_a=None,
score_b=None,
extra_a=None,
extra_b=None,
penalty_a=None,
penalty_b=None)
match.put()
return render_template('admin.html',
msg='Matches imported!',
logout_url=logout_url)
elif method == 'initdb2':
with open('worldcup2014-knockoff-stage.csv', 'rb') as csvfile:
spamreader = csv.reader(csvfile)
for row in spamreader:
match = Match(matchid=int(row[0]),
date=datetime.strptime(
str(row[1]), "%m/%d/%Y %H:%M"),
stage=row[5],
team_a='winner of ' + row[2],
team_b='winner of ' + row[3],
score_a=None,
score_b=None,
extra_a=None,
extra_b=None,
penalty_a=None,
penalty_b=None)
match.put()
return render_template('admin.html',
msg='Matches imported!',
logout_url=logout_url)
elif method == 'randombetwithknownuser':
for useremail in known_users.keys():
#drop existing first
existing_bets = Bet.query(Bet.useremail == useremail).fetch(
keys_only=True)
ndb.delete_multi(existing_bets)
#new data
digits = 21
uid = str(int(random.random() * 10**digits)).rjust(digits, '0')
matches = Match.query().fetch()
for match in matches:
bet = Bet(userid=uid,
useremail=useremail,
bet_match_id=int(match.matchid),
bet_amount=1,
score_a=random.randint(0, 3),
score_b=random.randint(0, 3),
extra_a=None,
extra_b=None,
penalty_a=None,
penalty_b=None)
bet.put()
return render_template(
'admin.html',
msg='simulated bets for known user has been generated!',
logout_url=logout_url)
elif method == 'randombet':
digits = 21
uid = str(int(random.random() * 10**digits)).rjust(digits, '0')
digits = 3
email = '*****@*****.**' % int(random.random() * 10**digits)
matches = Match.query().fetch()
for match in matches:
bet = Bet(userid=uid,
useremail=email,
bet_match_id=int(match.matchid),
bet_amount=1,
score_a=random.randint(0, 3),
score_b=random.randint(0, 3),
extra_a=None,
extra_b=None,
penalty_a=None,
penalty_b=None)
bet.put()
return render_template(
'admin.html',
msg='simulated bets for %s has been generated!' % uid,
logout_url=logout_url)
elif method == 'insertmatch':
match_id = int(request.args.get('id', 0))
team_a = request.args.get('a', None) or None
team_b = request.args.get('b', None) or None
match_stage = request.args.get('s', None) or None
match_date = request.args.get('d', None) or None
score_a = request.args.get('sa', None) or None or None
score_b = request.args.get('sb', None) or None
extra_a = request.args.get('ea', None) or None
extra_b = request.args.get('eb', None) or None
penalty_a = request.args.get('pa', None) or None
penalty_b = request.args.get('pb', None) or None
matches = Match.query(Match.matchid == match_id).fetch()
if len(matches) == 0:
match = Match(matchid=match_id,
date=datetime.strptime(match_date,
"%d %B %Y %H:%M"),
stage=match_stage,
team_a=team_a,
team_b=team_b,
score_a=None,
score_b=None,
extra_a=None,
extra_b=None,
penalty_a=None,
penalty_b=None)
logging.info('insert attempt:%s' % str(match))
match.put()
return render_template(
'admin.html',
msg='Match between %s and %s has been inserted!' %
(match.team_a, match.team_b),
logout_url=logout_url)
else:
match = matches[0]
if match_date:
match.date = datetime.strptime(match_date,
"%d %B %Y %H:%M")
if match_stage:
match.stage = match_stage
if team_a:
match.team_a = team_a
if team_b:
match.team_b = team_b
if score_a:
match.score_a = int(score_a)
if score_b:
match.score_b = int(score_b)
if extra_a:
match.extra_a = int(extra_a)
if extra_b:
match.extra_b = int(extra_b)
if penalty_a:
match.penalty_a = int(penalty_a)
if penalty_b:
match.penalty_b = int(penalty_b)
logging.info('update attempt:%s' % str(match))
match.put()
return render_template(
'admin.html',
msg='Match between %s and %s has been updated!' %
(match.team_a, match.team_b))
elif method == 'sendmail':
match_id = int(request.args.get('id', 0))
subject = request.args.get('s', None) or None
body = request.args.get('b', None) or None
html = request.args.get('h', None) or None
logging.info('sendmail attempt:%s' % str(match_id))
if match_id > 0:
bets = Bet.query(Bet.bet_match_id == match_id).fetch()
match = Match.query(Match.matchid == match_id).fetch()[0]
addresses = []
[addresses.append(str(bet.useremail)) for bet in bets]
target_address = ';'.join(addresses)
#subject = "Match between %s and %s just started!" %(match.team_a, match.team_b)
#body = "http://localhost:8080/#/my"
#html = "<a href=\"http://localhost:8080/#/my\">My guess</a>"
send_mail(target_address, subject, body, html)
return render_template(
'admin.html',
msg='Mail to %s with <%s> has succeeded!' %
(target_address, subject))
return render_template('admin.html',
msg='You have to specify match id!',
logout_url=logout_url)
return render_template('admin.html', logout_url=logout_url)
else:
return render_template('logout.html',
logout_url=users.create_logout_url(
request.path),
login_url=users.create_login_url(request.path))
