def loadHeroes():
    """Function that loads the heroes from a csv file into a list"""
    hero_list = []
    f = open('marvel.csv')
    marvelFile = csv.reader(f)
    for line in marvelFile:
        marvel_list = CsvHandler.split(line[0], ";")
        hero_list.append(Hero(marvel_list[0], [marvel_list[1], marvel_list[2], marvel_list[3]]))
    return hero_list
def loadHighscore(sortType = "None"):
    f = open('highscores.csv', 'r')
    file = csv.reader(f)
    highscore_list = []
    for row in file:
        row_list = CsvHandler.split(row[0], ";")
        scoreDing = Highscore(row_list[2], row_list[1], row_list[3], row_list[0])
        highscore_list.append(scoreDing)
    return highscore_list
def loadScores(fileName, sc):
    fileName += ".csv"
    file = open(fileName, "r")
    bestand = csv.reader(file)
    outputString = ""
    count = 1
    for row in bestand:
        punten = CsvHandler.split(row[0], ";")
        outputString = outputString + str(count) + ": " + punten[2] + " - Score: " + punten[1] + " - Date: " + punten[0] + "\n"
        count += 1
    sc.set(outputString)
    def save(self):
        dagmaandjaarList = CsvHandler.split(self.TimeStamp, "/")
        stScore = str(self.Score)
        if(len(stScore) == 1):
            stScore = "0" + stScore
        stSeconds = str(self.Seconds)
        if len(stSeconds) < 4:
            for i in range(4 - len(stSeconds)):
                stSeconds = "0" + stSeconds

        with open('highscores.csv', 'a+', newline='') as csvfile:
            winnaars = csv.writer(csvfile, delimiter=";")
            winnaars.writerow([self.TimeStamp, stScore, self.UserName, stSeconds,dagmaandjaarList[0], dagmaandjaarList[1], dagmaandjaarList[2]])
__author__ = 'Brent'

import csv
import operator
import CsvHandler
import time

bestand = open('highscores.csv', 'r')

reader = csv.reader(bestand, delimiter=";")

sort = sorted(reader, key=operator.itemgetter(1), reverse=True)

datum = time.strftime("%x")
maand = CsvHandler.split(time.strftime("%x"),"/")
maand = maand[0]

open("sortedlist.csv", 'w')

for eachline in sort:
    # print(eachline)
    with open("sortedlist.csv", 'a', newline='') as csvfile:
        bla = csv.writer(csvfile, delimiter=';')
        bla.writerow([eachline[0], eachline[1], eachline[2], eachline[3], eachline[4], eachline[5], eachline[6]])

def daily():
    file = open("highscores.csv", 'r')
    lezer = csv.reader(file, delimiter=';')
    surt = sorted(lezer, key=operator.itemgetter(5), reverse=False)
    surt = sorted(surt, key=operator.itemgetter(1), reverse=True)
    open('daily.csv', 'w')