get_match_info.py
1.85 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
import requests
from urllib import parse
import pymysql
def insert_match_table(name,country,season):
conn = pymysql.connect(host='localhost', user='root', password="!!fnsldkwjsrl11", db="project_troll", charset='utf8')
try:
with conn.cursor() as curs:
sql = 'insert into match_info values(%s, %s,%s)'
curs.execute(sql, (name, country,season))
conn.commit()
finally:
conn.close()
APIKEY="RGAPI-dd27bd34-ec78-4c30-8c11-5144d7ec85e5"
headers={
"User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.183 Safari/537.36",
"Accept-Language": "ko-KR,ko;q=0.9,en-US;q=0.8,en;q=0.7",
"Accept-Charset": "application/x-www-form-urlencoded; charset=UTF-8",
"Origin": "https://developer.riotgames.com",
"X-Riot-Token": APIKEY
}
def game_id(name,num):
API="https://kr.api.riotgames.com/lol/summoner/v4/summoners/by-name/" + name
getAPI=requests.get(API, headers=headers)
LOL_API_DATA=getAPI.json()
accountid=LOL_API_DATA["accountId"]
API="https://kr.api.riotgames.com/lol/match/v4/matchlists/by-account/" + accountid
getAPI=requests.get(API, headers=headers)
LOL_API_DATA=getAPI.json()['matches']
#int값 리턴
return LOL_API_DATA[num].get("gameId")
def season_country(name):
API="https://kr.api.riotgames.com/lol/summoner/v4/summoners/by-name/" + name
getAPI=requests.get(API, headers=headers)
LOL_API_DATA=getAPI.json()
accountid=LOL_API_DATA["accountId"]
API="https://kr.api.riotgames.com/lol/match/v4/matchlists/by-account/" + accountid
getAPI=requests.get(API, headers=headers)
LOL_API_DATA=getAPI.json()['matches']
#str값리턴
#insert_table(name,LOL_API_DATA[0].get("platformId"),LOL_API_DATA[0].get("season"))
return LOL_API_DATA[0].get("platformId"),LOL_API_DATA[0].get("season")