from highscores.highscore import Highscore


class MysteryBoxes(Highscore):
    def __init__(self):
        LAYOUT = ["Rank", "Username", "Clan", "Mystery boxes opened"]
        LINK = r"https://pokemon-planet.com/mostMysteryBoxes.php"
        NAME = "mysteryboxes"
        CREATEQUERY = "CREATE TABLE IF NOT EXISTS mysteryboxes(rank INTEGER PRIMARY KEY, username TEXT, " \
                           "clan TEXT, amount TEXT)"
        super(MysteryBoxes, self).__init__(NAME, LINK, LAYOUT, CREATEQUERY)

    def updatequery(self) -> str:
        return "UPDATE mysteryboxes SET username=?, clan=?, amount=? WHERE rank=?"

from highscores.highscore import Highscore


class MysteryBoxes(Highscore):
    def __init__(self):
        LAYOUT = ["Rank", "Username", "Clan", "Mystery boxes opened"]
        LINK = r"https://pokemon-planet.com/mostMysteryBoxes.php"
        NAME = "mysteryboxes"
        CREATEQUERY = "CREATE TABLE IF NOT EXISTS mysteryboxes(rank INTEGER PRIMARY KEY, username TEXT, " \
                           "clan TEXT, amount TEXT)"
        super(MysteryBoxes, self).__init__(NAME, LINK, LAYOUT, CREATEQUERY)

    def updatequery(self) -> str:
        return "UPDATE mysteryboxes SET username=?, clan=?, amount=? WHERE rank=?"
