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()