def add_match(db, url, teams, game_number, region):
timeline_url = riot_api.get_timeline_url(url)
md = json.loads(riot_api.get_acs_info(url).read())
id = md['gameId']
date = datetime.datetime.fromtimestamp(md['gameCreation'] / 1000)
is_json = json.loads(riot_api.get_acs_info(timeline_url).read())['frames']
item_sets = json.dumps(build_parser.get_build_steps(is_json))
participants = md['participants']
for player in participants:
info = {}
if 'masteries' in player:
del player['masteries']
if 'runes' in player:
del player['runes']
if 'timeline' in player:
del player['timeline']
if 'highestAchievedSeasonTier' in player:
del player['highestAchievedSeasonTier']
info['win'] = player['stats']['win']
info['item0'] = player['stats']['item0']
info['item1'] = player['stats']['item1']
info['item2'] = player['stats']['item2']
info['item3'] = player['stats']['item3']
info['item4'] = player['stats']['item4']
info['item5'] = player['stats']['item5']
info['item6'] = player['stats']['item6']
info['kills'] = player['stats']['kills']
info['deaths'] = player['stats']['deaths']
info['assists'] = player['stats']['assists']
del player['stats']
player['stats'] = info
participantIds = json.dumps(md['participantIdentities'])
participants = json.dumps(participants)
db.execute(
'insert into matches (id, time_stamp, item_sets, participants, participantIds, game_number, teams, region_id) values (?, ?, ?, ?, ?, ?, ?,?)',
[
id,
date.isoformat(), item_sets, participants, participantIds,
int(game_number),
json.dumps(teams), region
])
db.commit()
def add_match(db, url, teams, game_number, winner_id, players, series_id):
timeline_url = riot_api.get_timeline_url(url)
md = json.loads(riot_api.get_acs_info(url).read())
id = md['gameId']
date = datetime.datetime.fromtimestamp(md['gameCreation']/1000)
is_json = json.loads(riot_api.get_acs_info(timeline_url).read())['frames']
item_sets = build_parser.get_build_steps(is_json)
participants = md['participants']
p_ids = {str(p['stats']['goldEarned']) + " " + str(p['championId']):p['participantId'] for p in participants}
for player in players:
p = players[player]
index = str(p['totalGold']) + " " + str(p['championId'])
add_player_info(db, p['id'], p['name'], p['photoURL'])
add_match_participant(db, int(id), p['id'], p_ids[index],
p['teamId'], p['kills'], p['deaths'], p['assists'],
p['championId'], p['spell0'], p['spell1'],
json.dumps(item_sets[p_ids[index]]))
participantIds = json.dumps(md['participantIdentities'])
participants = json.dumps(participants)
db.execute('insert into matches (match_id, time_stamp, game_number,'
'series_id, winning_team_id) values (?, ?, ?, ?, ?)',
[id, date.isoformat(), int(game_number), series_id, winner_id])
db.commit()
def add_match(db, url, teams, game_number, region):
timeline_url = riot_api.get_timeline_url(url)
md = json.loads(riot_api.get_acs_info(url).read())
id = md['gameId']
date = datetime.datetime.fromtimestamp(md['gameCreation']/1000)
is_json = json.loads(riot_api.get_acs_info(timeline_url).read())['frames']
item_sets = json.dumps(build_parser.get_build_steps(is_json))
participants = md['participants']
for player in participants:
info = {}
if 'masteries' in player:
del player['masteries']
if 'runes' in player:
del player['runes']
if 'timeline' in player:
del player['timeline']
if 'highestAchievedSeasonTier' in player:
del player['highestAchievedSeasonTier']
info['win'] = player['stats']['win']
info['item0'] = player['stats']['item0']
info['item1'] = player['stats']['item1']
info['item2'] = player['stats']['item2']
info['item3'] = player['stats']['item3']
info['item4'] = player['stats']['item4']
info['item5'] = player['stats']['item5']
info['item6'] = player['stats']['item6']
info['kills'] = player['stats']['kills']
info['deaths'] = player['stats']['deaths']
info['assists'] = player['stats']['assists']
del player['stats']
player['stats'] = info
participantIds = json.dumps(md['participantIdentities'])
participants = json.dumps(participants)
db.execute('insert into matches (id, time_stamp, item_sets, participants, participantIds, game_number, teams, region_id) values (?, ?, ?, ?, ?, ?, ?,?)',
[id, date.isoformat(), item_sets, participants, participantIds, int(game_number), json.dumps(teams), region])
db.commit()
