def fill_items(c, api_key): api = RiotWatcher(api_key) try: all_items = api.static_get_item_list(None, None, None, "image") except: print("Error getting all items:", sys.exc_info()[0]) return for _, item in all_items["data"].iteritems(): wiki_url = "http://leagueoflegends.wikia.com/wiki/" + item["name"] c.execute(''' INSERT INTO Item (Id, Name, Description, WikiLink, Image) VALUES (?, ?, ?, ?, ?) ''', (item["id"], item["name"], item["description"], wiki_url, item["image"]["full"]))
from riotwatcher import RiotWatcher from collections import defaultdict from json import load, dump import os from datetime import datetime, timedelta from riotwatcher import LoLException, error_404, error_429 import time with open('key.txt') as f: key = f.read() rw = RiotWatcher(key) item_list = rw.static_get_item_list() with open('data/static/items.json', 'w') as fp: dump(item_list, fp)