import random
import MySQLdb
from tkinter import messagebox
from tkinter import *


conn = MySQLdb.connect(host='localhost', database='world', user='root', password='veer1811')
cursor = conn.cursor()

global questions
questions = []
global options
options = []
global answers
answers = []
answerstemp =[]
s1=set()

while len(s1)<10:
    strQ=""
    strA=""
    id = random.randint(1, 30)
    s1.add(id)
print(s1)
while len(s1)>0:
    s = "select qstn from questions where QID=%d"
    id = s1.pop()
    arg = (id)
    cursor.execute(s % arg)
    strQ = strQ.join(list(cursor.fetchone()))
    questions.append(strQ)

    s = "select opA,opB,opC,opD from questions where QID=%d"
    arg = (id)
    cursor.execute(s % arg)
    options.append(list(cursor.fetchone()))

    s = "select ans from questions where QID=%d"
    arg = (id)
    cursor.execute(s % arg)
    l = list(cursor.fetchone())
    answerstemp.append(l)
print(answerstemp)
print(questions)
print(options)
mydict={}
for i in range(10):
    mydict[questions[i]]=options[i]
for key,val in mydict.items():
    print(key,"---->",val)
    print("\n")
for i in range(len(answerstemp)):
    answers.append(answerstemp[i][0])

print(answers)

cursor.close()
conn.close()
l1={}
for i in range(10):
   l1[i]=0
print(l1)
class Quiz:
    def __init__(self, master):
        global mReg
        mReg = master
        self.master = master
        self.master.geometry("1350x750+0+0")
        self.master.title("Online Quiz - Registration")
        self.master.config(bg="azure")
        global f1
        f = Frame(self.master, height=1080, width=1920, bg="azure", relief="ridge", bd=20)
        f.propagate(0)
        f.pack()
        self.qno = 0
        self.score1 = 0  # self.correct
        self.ques = self.create_q(f, self.qno)
        self.opts = self.create_options(f)
        self.display_q(self.qno)
        self.Back = Button(f, text="<-Back",command = self.back).place(x=265,y=225)
        self.Next = Button(f, text="Next->",command=self.next ).place(x=315,y=225)
        self.submit=Button(f, text="Submit",fg="white",command=self.Submit,bg="blue").place(x=290,y=275)


    def create_q(self, master, qno):
        qLabel = Label(master, text=questions[qno],bg='azure')
        qLabel.place(x=40,y=70)
        return qLabel

    def create_options(self,master):
        b_val = 0
        b = []
        ht=75
        self.opt_selected = IntVar()
        while b_val<4:
            btn = Radiobutton(master, text="", variable=self.opt_selected, value=b_val+1,bg = 'azure')
            b.append(btn)
            ht=ht+25
            btn.place(x=30,y=ht)
            b_val = b_val + 1
        return b

    def display_q(self, qno):
        b_val = 0
        print(qno)
        self.ques['text'] = str(qno+1)+". "+questions[qno]
        for op in options[qno]:
            self.opts[b_val]['text'] = op
            b_val = b_val + 1
        print(l1)

    def next(self):
        self.qno += 1

        if self.qno >= len(questions):
            self.qno -=1
            messagebox.showwarning("Warning", "You are at the end.Press Submit to proceed")
        else:
            l1[self.qno-1]=self.opt_selected.get()
            self.opt_selected.set(l1[(self.qno)])
            self.display_q(self.qno)

    def back(self):
        l1[self.qno]=self.opt_selected.get()
        self.qno -= 1
        if self.qno <0:
            self.qno +=1
            messagebox.showerror("Error", "You are already in the start!!!")
        else:
            self.display_q(self.qno)
            c=l1[self.qno]
            print(c,self.qno)
            self.opt_selected.set(c)
    def Submit(self):
        l1[self.qno]=self.opt_selected.get()
        x=0
        for i in range(10):
            if(l1[i]==0):
                x+=1
        if(x>0 and x!=1):
            y = True
            y=messagebox.askyesno("Warning","You have not attempted "+str(x)+" questions, Are you sure you want to submit?, You won't be able to make changes again")
        elif(x==1):
            y=messagebox.askyesno("Warning","You have not attempted "+str(x)+" question, Are you sure you want to submit?, You won't be able to make changes again")
        if(y==True or x==0):
            s = 0
            for i in range(10):
                print(answerstemp[i][0],l1[i])
                if(l1[i]==answerstemp[i][0]):
                    s = s+1
            print(s)


        #Label(master,text="Congrats!!!..Your score is : "+str(s)+"/10",bg='azure').place(x=200,y=300)
root = Tk()
root.resizable(0,0)
RegObj = Quiz(root)
root.mainloop()