#!/usr/local/bin/python3.5
#=====CONFIG=====
#Minimum rank for roster:
roster_rank = 3

import json
import urllib.request
import sys
print(sys.version)
import urllib.parse
import time
import mysql.connector

def api_request(url):
    print(url)
    try:
        request = urllib.request.urlopen(url)
    except:
        print('error during http request, retrying in 5 seconds...')
        time.sleep(5)
        request = urllib.request.urlopen(url)
    bytes_response = request.read()
    json_obj = json.loads(bytes_response.decode('utf-8'))
    return json_obj

i = 1
roster = {}
guild_members = api_request('https://eu.api.battle.net/wow/guild/sargeras/whiplash?fields=members&locale=fr_FR&apikey=zsa5wkujcstye4kqngevs5hznxqv3xts')
for member in guild_members['members']:
    if member['rank'] <= roster_rank:
        member_item = api_request('https://eu.api.battle.net/wow/character/' + urllib.parse.quote(member['character']['realm']) + '/' + urllib.parse.quote(member['char$
        print('----'+str(i)+'----')
        roster[member['character']['name']] = {}
        roster[member['character']['name']]['ilvl'] = member_item['items']['averageItemLevelEquipped']
        roster[member['character']['name']]['race'] = member['character']['race']
        roster[member['character']['name']]['class'] = member['character']['class']
        if 'spec' in member['character'].keys():
            roster[member['character']['name']]['spec'] = member['character']['spec']['name']
        else:
            roster[member['character']['name']]['spec'] = 'Unknown'
        roster[member['character']['name']]['thumbnail'] = member['character']['thumbnail']
        i += 1

SQLReq = 'INSERT INTO membres (pseudo, ilvl, race, classe, spe, thumbnail) VALUES'
for membre in roster:
    SQLReq += "('" + membre + "', " + str(roster[membre]['ilvl']) + ", '" + str(roster[membre]['race']) + "', '" + str(roster[membre]['class']) + "', '" + str(roster[m$
SQLReq += '\b;'
print(SQLReq)

conn = mysql.connector.connect(host="localhost",user="root",password="1egn2734zap5r",database="whiplash")
cursor = conn.cursor()
cursor.execute("TRUNCATE membres;")
cursor.close()

cursor = conn.cursor()
cursor.execute(SQLReq)
cursor.close()

conn.commit()
conn.close()