import csv
import random
import time

# variables: 
scorestemp = []
userpoints = 0
username = ""
userData = "C:\Python Main\Exam Practise\Xuserdata.csv"
songLibrary = "C:\Python Main\Exam Practise\Xmusiclibrary.csv"
leaderboard = "C:\Python Main\Exam Practise\Xleaderboard.csv"
scoresFile = "C:\Python Main\Exam Practise\Xscores.csv"

#def appendHighScore(userpoints):
    #choose_name = str(input("Enter the name you would like your score to be saved as: "))
    #with open(leaderboard, "a", newline = '') as LeaderboardWrite:
        #LeaderboardWriter = csv.writer(LeaderboardWrite)
        #highscoredata = [choose_name, userpoints]
        #LeaderboardWriter.writerow(highscoredata)

    
def appendScore(username, userpoints): 
    with open(scoresFile, "a", newline = '') as ScoresCSV: 
        writer3 = csv.writer(ScoresCSV)
        data1 = [username, userpoints]
        writer3.writerows([data1])           
        # WORKING - writes to scores.   

def detectHighScore(userpoints): 
    with open(scoresFile, "r") as DTCHighscore:
        scorereader = csv.reader(DTCHighscore)
        data = []
        for y in scorereader:
            if y:
                data.append(y[1])
        data.sort(reverse=True)   # sorted list of all scores in the file.
        
        if userpoints >= int(data[0]) or userpoints >= int(data[1]) or userpoints >= int(data[2]) or userpoints >= int(data[3]) or userpoints >= int(data[4]):
            print("High Score Detected. Good Job! Your highscore is: " + str(userpoints))
            print("Here is the leaderboard: ")
            print(data[0], data[1], data[2], data[3], data[4]) # how to display username as well??
            data.clear()
            #appendHighScore(userpoints)
            exit()
        elif userpoints != int(data[0]) or userpoints != int(data[1]) or userpoints != int(data[2]) or userpoints != int(data[3]) or userpoints != int(data[4]):
            print("Here is the leaderboard: ")
            print(data[0], data[1], data[2], data[3], data[4]) # you need to have 5 scores already saved.
            data.clear() # still putting a random number at the start not in order
            exit()

def validateUserGuess(songname):   
    global userpoints
    Playing = True
    while Playing:
        print("You have two guesses to correctly guess the song. Good luck!")
        userguess1 = input("Enter your guess (Enter the full song name.) : ")
        if userguess1 == songname:
            userpoints += 3                                                         
            print("Correct. You have earned 3 points.") 
            print("You now have: " + (str(userpoints)) + " points.")
            randomsong()
        else:
            userguess2 = input("Incorrect guess. This is your last attempt: ") 
            if userguess2 == songname: 
                userpoints += 1
                print("Correct.You have earned 1 point.")
                print("You now have: " + (str(userpoints)) + " points.")
                randomsong()
            else:
                Playing = False
                print("You lose KEKW. You scored: " + str(userpoints) + " points.")
                appendScore(username, userpoints) # writes every score to scores file.                        # still continues this loop aftger detecthighscore runs. "break" underneath does not do anuthing
                detectHighScore(userpoints)
                
# takes a random entry from music library and the artist producing the song and then prints it as a list, string. ie ["R", "I", "B"] XXXTENTACION]
def randomsong(): 
    with open(songLibrary, "r") as SongLibrary: # opens the Xmusiclibrary.csv file
        songreader = csv.reader(SongLibrary) 
        #header = next(songreader)
        for x in songreader:# "for every row in the file"
            if x:
                songrows = list(songreader) # turn all entries into one list
                random_row = random.choice(songrows) # selects a random entry
                #print(random_row)
                songname = random_row[0] # sets the name of the song to column 1 # sometimes throws up a list index error 
                artist = random_row[1] # sets artist name to column 2
                random_song_str = "".join(str(e) for e in songname) # converts just the song name to a string
                firstletter = [s[0] for s in random_song_str.split()] # stores the first letter of each word in the song title in a list
                print(firstletter, artist)
                validateUserGuess(songname)

# user authentication
def userauth():
    global login
    global username
    login = False
    username = input("Logging in. Enter your username: ") 
    password = input("Please Enter your password. Bear in mind that it is case sensitive.")
    with open(userData, "r") as userdata_csv_file:
        reader = csv.reader(userdata_csv_file)
        #header = next(reader)

        for row in reader:
            auth_user = row[0] 
            auth_pass = row[1]
            if auth_user == username and auth_pass == password:
                login = True
                print("You are logged in as: " + username)
                randomsong()
                break
            
        if auth_user != username or auth_pass != password:
            print("Login incorrect. Please try again.")  
            LogCreate()

# Creating a new account and adding it to the CSV file
def appendAccount():
    Newusername = input("Enter your username: ") 
    Newpassword = input("Enter your password: ")
    with open(userData, "a", newline = '') as userDataCSV:
        writer = csv.writer(userDataCSV)
        details = [Newusername, Newpassword]
        writer.writerows([details])

def LogCreate():
    userchoice = input("Login or create account? L/C: ").lower()
    if userchoice == "l":
        userauth()
    else:
        appendAccount()
        LogCreate()

LogCreate()

# bonus items