SWDB/install_user.py

#!/usr/bin/python3

import urllib3
import sys
import os
import requests
import urllib.request
import sqlite3
import wget
import json

FILE = "/home/ivalentin/.SWEX/IVV0-8114048.json"

def readFile(file):
    with open(file) as json_file:
        data = json.load(json_file)
    return data

"""
Opens the database file and deletes from the user tables

:param name: The path to the sqlite database.
:returns: Connection to the database.
:raises IntegrityError: The queryes couldn't bre executed.
:raises IOError: The sqlite file couldn't be created.
"""
def openDatabase(name):
    global OPT_CREATE_DB
    print('Configuring database...')
    try:
        db = sqlite3.connect(name)
        cursor = db.cursor()
        cursor.execute('''DELETE FROM unit''')
        #cursor.execute('''DELETE FROM monster_rune''')
        cursor.execute('''DELETE FROM rune''')
        cursor.execute('''DELETE FROM player''')
        cursor.execute('''DELETE FROM building''')
        db.commit()
        cursor.close()
        return db
    except sqlite3.IntegrityError as e:
        print("Error executing statement: " + str(e))
        raise
    except IOError as e:
        print("I/O Error creating database " + name + ": " + str(e))
        raise


"""
Inserts a row into the database.

:param db: Connection to the database.
:param table: Name of the table to insert into.
:param values: List of values to insert.
:raises IntegrityError: The insert query was unsuccesfull.
"""
def insert(db, table, values):
    cursor = db.cursor()
    placeholders = ''
    for x in range(0, len(values)):
        placeholders = placeholders + '?, '
    placeholders = placeholders[:len(placeholders) - 2]
    query = 'INSERT INTO ' + table + ' VALUES (' + placeholders + ')'
    try:
        cursor.execute(query, values)
    except sqlite3.IntegrityError as e:
        print('Error Inserting into ' + table + ' with values (' + str(values) + '): ' + str(e))
        raise
    cursor.close;

"""
Parses player (table player).

:param db: Sqlite database connection.
:param data: Data in SWEX json file.
"""
def parsePlayer(db, data):
    print("Parsing player...")
    uid = data["wizard_info"]["wizard_id"]
    name = data["wizard_info"]["wizard_name"]
    mana = data["wizard_info"]["wizard_mana"]
    crystal = data["wizard_info"]["wizard_crystal"]
    country = data["wizard_info"]["wizard_last_country"]
    lang = data["wizard_info"]["wizard_last_lang"]
    level = data["wizard_info"]["wizard_level"]
    experience = data["wizard_info"]["experience"]
    energy = data["wizard_info"]["wizard_energy"]
    energy_max = data["wizard_info"]["energy_max"]
    energy_per_min = data["wizard_info"]["energy_per_min"]
    arena_energy = data["wizard_info"]["arena_energy"]
    arena_energy_max = data["wizard_info"]["arena_energy_max"]
    rep = data["wizard_info"]["rep_unit_id"]
    social_point = data["wizard_info"]["social_point_current"]
    honor_point = data["wizard_info"]["honor_point"]
    guild_point = data["wizard_info"]["guild_point"]
    darkportal_energy = data["wizard_info"]["darkportal_energy"]
    darkportal_energy_max = data["wizard_info"]["darkportal_energy_max"]
    costume_point = data["wizard_info"]["costume_point"]
    costume_point_max = data["wizard_info"]["costume_point_max"]
    honor_medal = data["wizard_info"]["honor_medal"]
    honor_mark = data["wizard_info"]["honor_mark"]
    event_coin = data["wizard_info"]["event_coin"]
    insert(db, "player", (uid, name, mana, crystal, country, lang, level, experience, energy, energy_max, energy_per_min, arena_energy, arena_energy_max, rep, social_point, honor_point, guild_point, darkportal_energy, darkportal_energy_max, costume_point, costume_point_max, honor_medal, honor_medal, event_coin))
    db.commit()

"""
Parses scenarios (table scenario).

:param db: Sqlite database connection.
:param data: Data in SWEX json file.
"""
def parseScenarios(db, data):
    print("Parsing scenarios...")
    uid = data["wizard_info"]["wizard_id"]
    for sce in data["scenario_list"]:
        region = sce["region_id"]
        difficulty = sce["difficulty"]
        cleared = sce["cleared"]
        max_cleared = 0
        for stage in sce["stage_list"]:
            if stage["cleared"] == 1:
                max_cleared = stage["stage_no"]
        insert(db, "scenario", (uid, region, difficulty, cleared, max_cleared))
    db.commit()

"""
Parses arena defense units (table defense).

:param db: Sqlite database connection.
:param data: Data in SWEX json file.
"""
def parseDefense(db, data):
    print("Parsing arena defense...")
    uid = data["wizard_info"]["wizard_id"]
    for defense in data["defense_unit_list"]:
        unit = defense["unit_id"]
        position = defense["pos_id"]
        insert(db, "defense", (uid, unit, position))
    db.commit()

"""
Parses buildings (table building).

:param db: Sqlite database connection.
:param data: Data in SWEX json file.
"""
def parseBuildings(db, data):
    print("Parsing buildings...")
    uid = data["wizard_info"]["wizard_id"]
    for bui in data["deco_list"]:
        building = bui["master_id"]
        level = bui["level"]
        insert(db, "building", (uid, building, level))
    db.commit()

"""
Parses unit data (tables unit, unit_skill).

:param db: Sqlite database connection.
:param data: Data in SWEX json file.
"""
def parseUnits(db, data):
    print("Parsing monsters...")
    uid = data["wizard_info"]["wizard_id"]
    for mon in data["unit_list"]:
        id = mon["unit_id"]
        building = mon["building_id"]
        monster = mon["unit_master_id"]
        level = mon["unit_level"]
        stars = mon["class"]
        hp = mon["con"] * 15 # Always x15
        attack = mon["atk"]
        defense = mon["def"]
        speed = mon["spd"]
        crit_rate = mon["critical_rate"]
        crit_damage = mon["critical_damage"]
        resistance = mon["resist"]
        accuracy = mon["accuracy"]
        experience = mon["experience"]
        exp_gained = mon["exp_gained"]
        exp_gain_rate = mon["exp_gain_rate"]
        costume = mon["costume_master_id"]
        attribute = mon["attribute"]
        source = mon["source"]
        create_time = mon["create_time"]
        homunculus = mon["homunculus"]
        homunculus_name = mon["homunculus_name"]
        insert(db, "unit", (uid, id, building, monster, level, stars, hp, attack, defense, speed, crit_rate, crit_damage, resistance, accuracy, experience, exp_gained, exp_gain_rate, costume, attribute, source, create_time, homunculus, homunculus_name, 0, None))
        for skill in mon["skills"]:
            skill_id = skill[0]
            skill_level = skill[1]
            insert(db, "unit_skill", (uid, id, skill_id, skill_level))
    db.commit()

"""
Parses rune data (table rune).

:param db: Sqlite database connection.
:param data: Data in SWEX json file.
"""
def parseRunes(db, data):
    print("Parsing runes...")
    uid = data["wizard_info"]["wizard_id"]
    for rune in data["runes"]:
        id = rune["rune_id"]
        assigned_to = rune["occupied_id"]
        if assigned_to == 0:
            assigned_to = None
        runeset = rune["set_id"]
        if runeset == 1:
            runeset = 'Energy'
        elif runeset == 2:
            runeset = 'Guard'
        elif runeset == 3:
            runeset = 'Swift'
        elif runeset == 4:
            runeset = 'Blade'
        elif runeset == 5:
            runeset = 'Rage'
        elif runeset == 6:
            runeset = 'Focus'
        elif runeset == 7:
            runeset = 'Endure'
        elif runeset == 8:
            runeset = 'Fatal'
        elif runeset == 10:
            runeset = 'Despair'
        elif runeset == 11:
            runeset = 'Vampire'
        elif runeset == 13:
            runeset = 'Violent'
        elif runeset == 14:
            runeset = 'Nemesis'
        elif runeset == 15:
            runeset = 'Will'
        elif runeset == 16:
            runeset = 'Shield'
        elif runeset == 17:
            runeset = 'Revenge'
        elif runeset == 18:
            runeset = 'Destroy'
        elif runeset == 19:
            runeset = 'Fight'
        elif runeset == 20:
            runeset = 'Determination'
        elif runeset == 21:
            runeset = 'Enhance'
        elif runeset == 22:
            runeset = 'Accuracy'
        elif runeset == 23:
            runeset = 'Tolerance'
        slot = rune["slot_no"]
        stars = rune["class"]
        level = rune["upgrade_curr"]
        quality = rune["rank"] - 1
        original_quality = rune["extra"] - 1
        value = rune["sell_value"]
        # TODO: Calculate
        #efficiency = rune["efficiency"]
        #max_efficiency = rune["max_efficiency"]
        efficiency = 0
        max_efficiency = 0
        main_stat = rune["pri_eff"][0]
        main_stat_value = rune["pri_eff"][1]
        if rune["prefix_eff"][0] > 0:
            innate_stat = rune["prefix_eff"][0]
            innate_stat_value = rune["prefix_eff"][1]
        else:
            innate_stat = None
            innate_stat_value = 0
        if len(rune["sec_eff"]) > 0:
            substat_1 = rune["sec_eff"][0][0]
            substat_1_value = rune["sec_eff"][0][1]
            substat_1_enchant = rune["sec_eff"][0][2]
            substat_1_grind = rune["sec_eff"][0][3]
        else:
            substat_1 = None
            substat_1_value = 0
            substat_1_enchant = 0
            substat_1_grind = 0
        if len(rune["sec_eff"]) > 1:
            substat_2 = rune["sec_eff"][1][0]
            substat_2_value = rune["sec_eff"][1][1]
            substat_2_enchant = rune["sec_eff"][1][2]
            substat_2_grind = rune["sec_eff"][1][3]
        else:
            substat_2 = None
            substat_2_value = 0
            substat_2_enchant = 0
            substat_2_grind = 0
        if len(rune["sec_eff"]) > 2:
            substat_3 = rune["sec_eff"][2][0]
            substat_3_value = rune["sec_eff"][2][1]
            substat_3_enchant = rune["sec_eff"][2][2]
            substat_3_grind = rune["sec_eff"][2][3]
        else:
            substat_3 = None
            substat_3_value = 0
            substat_3_enchant = 0
            substat_3_grind = 0
        if len(rune["sec_eff"]) > 3:
            substat_4 = rune["sec_eff"][0][0]
            substat_4_value = rune["sec_eff"][3][1]
            substat_4_enchant = rune["sec_eff"][3][2]
            substat_4_grind = rune["sec_eff"][3][3]
        else:
            substat_4 = None
            substat_4_value = 0
            substat_4_enchant = 0
            substat_4_grind = 0

        """
        Human readable stat names (as of 2019-08-16):
            STAT_HP = 1
            STAT_HP_PCT = 2
            STAT_ATK = 3
            STAT_ATK_PCT = 4
            STAT_DEF = 5
            STAT_DEF_PCT = 6
            STAT_SPD = 7
            STAT_CRIT_RATE_PCT = 8
            STAT_CRIT_DMG_PCT = 9
            STAT_RESIST_PCT = 10
            STAT_ACCURACY_PCT = 11
        """
        if (main_stat == 1):
            main_stat = "HP"
        elif (main_stat == 2):
            main_stat = "HP%"
        elif (main_stat == 3):
            main_stat = "ATK"
        elif (main_stat == 4):
            main_stat = "ATK%"
        elif (main_stat == 5):
            main_stat = "DEF"
        elif (main_stat == 6):
            main_stat = "DEF%"
        elif (main_stat == 8):
            main_stat = "SPD"
        elif (main_stat == 9):
            main_stat = "CRR"
        elif (main_stat == 10):
            main_stat = "CRD"
        elif (main_stat == 11):
            main_stat = "RES"
        elif (main_stat == 12):
            main_stat = "ACC"
        if (innate_stat == 1):
            innate_stat = "HP"
        elif (innate_stat == 2):
            innate_stat = "HP%"
        elif (innate_stat == 3):
            innate_stat = "ATK"
        elif (innate_stat == 4):
            innate_stat = "ATK%"
        elif (innate_stat == 5):
            innate_stat = "DEF"
        elif (innate_stat == 6):
            innate_stat = "DEF%"
        elif (innate_stat == 8):
            innate_stat = "SPD"
        elif (innate_stat == 9):
            innate_stat = "CRR"
        elif (innate_stat == 10):
            innate_stat = "CRD"
        elif (innate_stat == 11):
            innate_stat = "RES"
        elif (innate_stat == 12):
            innate_stat = "ACC"
        if (substat_1 == 1):
            substat_1 = "HP"
        elif (substat_1 == 2):
            substat_1 = "HP%"
        elif (substat_1 == 3):
            substat_1 = "ATK"
        elif (substat_1 == 4):
            substat_1 = "ATK%"
        elif (substat_1 == 5):
            substat_1 = "DEF"
        elif (substat_1 == 6):
            substat_1 = "DEF%"
        elif (substat_1 == 8):
            substat_1 = "SPD"
        elif (substat_1 == 9):
            substat_1 = "CRR"
        elif (substat_1 == 10):
            substat_1 = "CRD"
        elif (substat_1 == 11):
            substat_1 = "RES"
        elif (substat_1 == 12):
            substat_1 = "ACC"
        if (substat_2 == 1):
            substat_2 = "HP"
        elif (substat_2 == 2):
            substat_2 = "HP%"
        elif (substat_2 == 3):
            substat_2 = "ATK"
        elif (substat_2 == 4):
            substat_2 = "ATK%"
        elif (substat_2 == 5):
            substat_2 = "DEF"
        elif (substat_2 == 6):
            substat_2 = "DEF%"
        elif (substat_2 == 8):
            substat_2 = "SPD"
        elif (substat_2 == 9):
            substat_2 = "CRR"
        elif (substat_2 == 10):
            substat_2 = "CRD"
        elif (substat_2 == 11):
            substat_2 = "RES"
        elif (substat_2 == 12):
            substat_2 = "ACC"
        if (substat_3 == 1):
            substat_3 = "HP"
        elif (substat_3 == 2):
            substat_3 = "HP%"
        elif (substat_3 == 3):
            substat_3 = "ATK"
        elif (substat_3 == 4):
            substat_3 = "ATK%"
        elif (substat_3 == 5):
            substat_3 = "DEF"
        elif (substat_3 == 6):
            substat_3 = "DEF%"
        elif (substat_3 == 8):
            substat_3 = "SPD"
        elif (substat_3 == 9):
            substat_3 = "CRR"
        elif (substat_3 == 10):
            substat_3 = "CRD"
        elif (substat_3 == 11):
            substat_3 = "RES"
        elif (substat_3 == 12):
            substat_3 = "ACC"
        if (substat_4 == 1):
            substat_4 = "HP"
        elif (substat_4 == 2):
            substat_4 = "HP%"
        elif (substat_4 == 3):
            substat_4 = "ATK"
        elif (substat_4 == 4):
            substat_4 = "ATK%"
        elif (substat_4 == 5):
            substat_4 = "DEF"
        elif (substat_4 == 6):
            substat_4 = "DEF%"
        elif (substat_4 == 8):
            substat_4 = "SPD"
        elif (substat_4 == 9):
            substat_4 = "CRR"
        elif (substat_4 == 10):
            substat_4 = "CRD"
        elif (substat_4 == 11):
            substat_4 = "RES"
        elif (substat_4 == 12):
            substat_4 = "ACC"
        insert(db, "rune", (uid, id, assigned_to, runeset, slot, stars, level, quality, original_quality, value, efficiency, max_efficiency, main_stat, main_stat_value, innate_stat, innate_stat_value, substat_1, substat_1_value, substat_1_enchant, substat_1_grind, substat_2, substat_2_value, substat_2_enchant, substat_2_grind, substat_3, substat_3_value, substat_3_enchant, substat_3_grind, substat_4, substat_4_value, substat_4_enchant, substat_4_grind))
    for mon in data["unit_list"]:
        for rune in mon["runes"]:
            id = rune["rune_id"]
            assigned_to = rune["occupied_id"]
            if assigned_to == 0:
                assigned_to = None
            runeset = rune["set_id"]
            if runeset == 1:
                runeset = 'Energy'
            elif runeset == 2:
                runeset = 'Guard'
            elif runeset == 3:
                runeset = 'Swift'
            elif runeset == 4:
                runeset = 'Blade'
            elif runeset == 5:
                runeset = 'Rage'
            elif runeset == 6:
                runeset = 'Focus'
            elif runeset == 7:
                runeset = 'Endure'
            elif runeset == 8:
                runeset = 'Fatal'
            elif runeset == 10:
                runeset = 'Despair'
            elif runeset == 11:
                runeset = 'Vampire'
            elif runeset == 13:
                runeset = 'Violent'
            elif runeset == 14:
                runeset = 'Nemesis'
            elif runeset == 15:
                runeset = 'Will'
            elif runeset == 16:
                runeset = 'Shield'
            elif runeset == 17:
                runeset = 'Revenge'
            elif runeset == 18:
                runeset = 'Destroy'
            elif runeset == 19:
                runeset = 'Fight'
            elif runeset == 20:
                runeset = 'Determination'
            elif runeset == 21:
                runeset = 'Enhance'
            elif runeset == 22:
                runeset = 'Accuracy'
            elif runeset == 23:
                runeset = 'Tolerance'
            slot = rune["slot_no"]
            stars = rune["class"]
            level = rune["upgrade_curr"]
            quality = rune["rank"] - 1
            original_quality = rune["extra"] - 1
            value = rune["sell_value"]
            # TODO: Calculate
            #efficiency = rune["efficiency"]
            #max_efficiency = rune["max_efficiency"]
            efficiency = 0
            max_efficiency = 0
            main_stat = rune["pri_eff"][0]
            main_stat_value = rune["pri_eff"][1]
            if rune["prefix_eff"][0] > 0:
                innate_stat = rune["prefix_eff"][0]
                innate_stat_value = rune["prefix_eff"][1]
            else:
                innate_stat = None
                innate_stat_value = 0
            if len(rune["sec_eff"]) > 0:
                substat_1 = rune["sec_eff"][0][0]
                substat_1_value = rune["sec_eff"][0][1]
                substat_1_enchant = rune["sec_eff"][0][2]
                substat_1_grind = rune["sec_eff"][0][3]
            else:
                substat_1 = None
                substat_1_value = 0
                substat_1_enchant = 0
                substat_1_grind = 0
            if len(rune["sec_eff"]) > 1:
                substat_2 = rune["sec_eff"][1][0]
                substat_2_value = rune["sec_eff"][1][1]
                substat_2_enchant = rune["sec_eff"][1][2]
                substat_2_grind = rune["sec_eff"][1][3]
            else:
                substat_2 = None
                substat_2_value = 0
                substat_2_enchant = 0
                substat_2_grind = 0
            if len(rune["sec_eff"]) > 2:
                substat_3 = rune["sec_eff"][2][0]
                substat_3_value = rune["sec_eff"][2][1]
                substat_3_enchant = rune["sec_eff"][2][2]
                substat_3_grind = rune["sec_eff"][2][3]
            else:
                substat_3 = None
                substat_3_value = 0
                substat_3_enchant = 0
                substat_3_grind = 0
            if len(rune["sec_eff"]) > 3:
                substat_4 = rune["sec_eff"][3][0]
                substat_4_value = rune["sec_eff"][3][1]
                substat_4_enchant = rune["sec_eff"][3][2]
                substat_4_grind = rune["sec_eff"][3][3]
            else:
                substat_4 = None
                substat_4_value = 0
                substat_4_enchant = 0
                substat_4_grind = 0
    
            """
            Human readable stat names (as of 2019-08-16):
                STAT_HP = 1
                STAT_HP_PCT = 2
                STAT_ATK = 3
                STAT_ATK_PCT = 4
                STAT_DEF = 5
                STAT_DEF_PCT = 6
                STAT_SPD = 7
                STAT_CRIT_RATE_PCT = 8
                STAT_CRIT_DMG_PCT = 9
                STAT_RESIST_PCT = 10
                STAT_ACCURACY_PCT = 11
            """
            if (main_stat == 1):
                main_stat = "HP"
            elif (main_stat == 2):
                main_stat = "HP%"
            elif (main_stat == 3):
                main_stat = "ATK"
            elif (main_stat == 4):
                main_stat = "ATK%"
            elif (main_stat == 5):
                main_stat = "DEF"
            elif (main_stat == 6):
                main_stat = "DEF%"
            elif (main_stat == 8):
                main_stat = "SPD"
            elif (main_stat == 9):
                main_stat = "CRR"
            elif (main_stat == 10):
                main_stat = "CRD"
            elif (main_stat == 11):
                main_stat = "RES"
            elif (main_stat == 12):
                main_stat = "ACC"
            if (innate_stat == 1):
                innate_stat = "HP"
            elif (innate_stat == 2):
                innate_stat = "HP%"
            elif (innate_stat == 3):
                innate_stat = "ATK"
            elif (innate_stat == 4):
                innate_stat = "ATK%"
            elif (innate_stat == 5):
                innate_stat = "DEF"
            elif (innate_stat == 6):
                innate_stat = "DEF%"
            elif (innate_stat == 8):
                innate_stat = "SPD"
            elif (innate_stat == 9):
                innate_stat = "CRR"
            elif (innate_stat == 10):
                innate_stat = "CRD"
            elif (innate_stat == 11):
                innate_stat = "RES"
            elif (innate_stat == 12):
                innate_stat = "ACC"
            if (substat_1 == 1):
                substat_1 = "HP"
            elif (substat_1 == 2):
                substat_1 = "HP%"
            elif (substat_1 == 3):
                substat_1 = "ATK"
            elif (substat_1 == 4):
                substat_1 = "ATK%"
            elif (substat_1 == 5):
                substat_1 = "DEF"
            elif (substat_1 == 6):
                substat_1 = "DEF%"
            elif (substat_1 == 8):
                substat_1 = "SPD"
            elif (substat_1 == 9):
                substat_1 = "CRR"
            elif (substat_1 == 10):
                substat_1 = "CRD"
            elif (substat_1 == 11):
                substat_1 = "RES"
            elif (substat_1 == 12):
                substat_1 = "ACC"
            if (substat_2 == 1):
                substat_2 = "HP"
            elif (substat_2 == 2):
                substat_2 = "HP%"
            elif (substat_2 == 3):
                substat_2 = "ATK"
            elif (substat_2 == 4):
                substat_2 = "ATK%"
            elif (substat_2 == 5):
                substat_2 = "DEF"
            elif (substat_2 == 6):
                substat_2 = "DEF%"
            elif (substat_2 == 8):
                substat_2 = "SPD"
            elif (substat_2 == 9):
                substat_2 = "CRR"
            elif (substat_2 == 10):
                substat_2 = "CRD"
            elif (substat_2 == 11):
                substat_2 = "RES"
            elif (substat_2 == 12):
                substat_2 = "ACC"
            if (substat_3 == 1):
                substat_3 = "HP"
            elif (substat_3 == 2):
                substat_3 = "HP%"
            elif (substat_3 == 3):
                substat_3 = "ATK"
            elif (substat_3 == 4):
                substat_3 = "ATK%"
            elif (substat_3 == 5):
                substat_3 = "DEF"
            elif (substat_3 == 6):
                substat_3 = "DEF%"
            elif (substat_3 == 8):
                substat_3 = "SPD"
            elif (substat_3 == 9):
                substat_3 = "CRR"
            elif (substat_3 == 10):
                substat_3 = "CRD"
            elif (substat_3 == 11):
                substat_3 = "RES"
            elif (substat_3 == 12):
                substat_3 = "ACC"
            if (substat_4 == 1):
                substat_4 = "HP"
            elif (substat_4 == 2):
                substat_4 = "HP%"
            elif (substat_4 == 3):
                substat_4 = "ATK"
            elif (substat_4 == 4):
                substat_4 = "ATK%"
            elif (substat_4 == 5):
                substat_4 = "DEF"
            elif (substat_4 == 6):
                substat_4 = "DEF%"
            elif (substat_4 == 8):
                substat_4 = "SPD"
            elif (substat_4 == 9):
                substat_4 = "CRR"
            elif (substat_4 == 10):
                substat_4 = "CRD"
            elif (substat_4 == 11):
                substat_4 = "RES"
            elif (substat_4 == 12):
                substat_4 = "ACC"
            insert(db, "rune", (uid, id, assigned_to, runeset, slot, stars, level, quality, original_quality, value, efficiency, max_efficiency, main_stat, main_stat_value, innate_stat, innate_stat_value, substat_1, substat_1_value, substat_1_enchant, substat_1_grind, substat_2, substat_2_value, substat_2_enchant, substat_2_grind, substat_3, substat_3_value, substat_3_enchant, substat_3_grind, substat_4, substat_4_value, substat_4_enchant, substat_4_grind))
    db.commit()







"""
Begin script
"""
db = openDatabase('application/sw.sqlite')
data = readFile(FILE)
parsePlayer(db, data)
parseScenarios(db, data)
parseDefense(db, data)
parseBuildings(db, data)
# TODO homunculus_skill_list
parseUnits(db, data)
# TODO summon_special_info
# TODO inventory_info
parseRunes(db, data)
#parseMonsters(db, 'https://swarfarm.com/api/v2/profiles/' + USER +  '/monsters/')
#db.commit()