from question_model import Question
from quiz_data import question_data
from quiz_brain import QuizBrain
from quiz_ui import QuizInterface
from random import shuffle
import html

import mysql.connector

question_bank = []
for question in question_data:
    choices = []
    question_text = html.unescape(question["question"])
    correct_answer = html.unescape(question["correct_answer"])
    incorrect_answers = question["incorrect_answers"]
    for ans in incorrect_answers:
        choices.append(html.unescape(ans))
    choices.append(correct_answer)
    shuffle(choices)
    new_question = Question(question_text, correct_answer, choices)
    question_bank.append(new_question)


quiz = QuizBrain(question_bank)

quiz_ui = QuizInterface(quiz)


print("You've completed the quiz")
print(f"Your final score was: {quiz.score}/{quiz.question_no}")
# p = quiz.score
z = quiz.question_no


mydb = mysql.connector.connect(

  host="localhost",

  user="leo",

  password="leo@2022",

  database="sllak"
)

mycursor = mydb.cursor()

mycursor.execute("SELECT * FROM people")


for x in mycursor:
 print(x)
  
print (' ')


print(' vouslez vous enregistrer votre score')
print("Non (1) / Oui (0)")
x = input()
x= int(x)

if x == 0:
    print (' ')
    print("Parfait, ajoutons ce socre")
    print ('votre nom ?  ')
    y = input()
#    print ('Score ? ')
    
    v = quiz.score
    z = (v * 100)//4
    
    mycursor = mydb.cursor()

    sql = "INSERT INTO people (name, score) VALUES (%s, %s)"
    val = ( y, z)
    mycursor.execute(sql, val)

    mydb.commit()

    print(mycursor.rowcount, "record inserted.")
    print ('Au revoir ')
    
    exit()
    
else:
    print (' ')
    print("Parfait ... Au revoir")
    print (' ')