import sys
import random
import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="root",database="quiz")
mycursor=mydb.cursor()
def Home():
    f=1
    while f!=3:
        print("Welcome to Quiz")
        print("1. Enter Questions")
        print("2. Take Quiz")
        print("3. Exit")
        f=int(input("Enter your choice:"))
        if f==1:
            Question()
        elif f==2:
            Quiz()
        elif f==3:
            print("Exiting the Quiz")
            mycursor.close()
            mydb.close()
            sys.exit();
        else:
            Home()
def Question():
    ch='Y';
    while ch=='Y' or ch=='y':
        print("Welcome to Question Portal")
        q=input("Enter the question :")
        op1=input("Enter the option 1 :")
        op2=input("Enter the option 2 :")
        op3=input("Enter the option 3 :")
        op4=input("Enter the option 4 :")
        ans=0
        while ans==0:
            op=int(input("Which option is correct answer (1,2,3,4)"))
            if op==1:
                ans=op1
            elif op==2:
                ans=op2
            elif op==3:
                ans=op3
            elif op==4:
                ans=op4
            else:
                print("Please choose the correct option as answer")
    mycursor.execute("Select * from question")
    data=mycursor.fetchall()
    qid=(mycursor.rowcount)+1
    mycursor.execute("Insert into question values",(qid,q,op1,op2,op3,op4,ans))
    mydb.commit()
    ch=input("Question added successfully.. Do you want to add more (Y/N)")
Home()
def Quiz():
    print("Welcome to Quiz portal")
    mycursor.execute("Select * from question")
    data=mycursor.fetchall()
    name=input("Enter your name :")
    rc=mycursor.rowcount
    noq=int(input("Enter the number of questions to attempt (max %s):"%rc))
    l=[]
    while len(l)!=noq:
        x=random.randint(1,rc)
        if l.count(x)>0:
            l.remove(x)
        else:
            l.append(x)
 
    print("Quiz has started")
    c=1
    score=0
    for i in range(0,len(l)):
        mycursor.execute("Select * from question where qid=%s",(l[i],))
        ques=mycursor.fetchone()
        print("Q.",c,":",ques[1],"\nA.",ques[2],"\t\tB.",ques[3],"\nC.",ques[4],"\t\tD.",ques[5])
 
        c+=1
        ans=None
        while ans==None:
            choice=input("Answer (A,B,C,D):")
            if choice=="A":
                ans=ques[2]
            elif choice=="B":
                ans=ques[3]
            elif choice=="C":
                ans=ques[4]
            elif choice=="D":
                ans=ques[5]
            else:
                print("Kindly select A,B,C,D as option only")
    if ans==ques[6]:
        print("Correct")
        score=score+1
    else:
        print("Incorrect.. Correct answer is :",ques[6])
    print("Quiz has ended !! Your final score is :",score)
    input("Press any key to continue")
    Home()
Home()
 

aW1wb3J0IHN5cwppbXBvcnQgcmFuZG9tCmltcG9ydCBteXNxbC5jb25uZWN0b3IKbXlkYj1teXNxbC5jb25uZWN0b3IuY29ubmVjdChob3N0PSJsb2NhbGhvc3QiLHVzZXI9InJvb3QiLHBhc3N3ZD0icm9vdCIsZGF0YWJhc2U9InF1aXoiKQpteWN1cnNvcj1teWRiLmN1cnNvcigpCmRlZiBIb21lKCk6CiAgICBmPTEKICAgIHdoaWxlIGYhPTM6CiAgICAgICAgcHJpbnQoIldlbGNvbWUgdG8gUXVpeiIpCiAgICAgICAgcHJpbnQoIjEuIEVudGVyIFF1ZXN0aW9ucyIpCiAgICAgICAgcHJpbnQoIjIuIFRha2UgUXVpeiIpCiAgICAgICAgcHJpbnQoIjMuIEV4aXQiKQogICAgICAgIGY9aW50KGlucHV0KCJFbnRlciB5b3VyIGNob2ljZToiKSkKICAgICAgICBpZiBmPT0xOgogICAgICAgICAgICBRdWVzdGlvbigpCiAgICAgICAgZWxpZiBmPT0yOgogICAgICAgICAgICBRdWl6KCkKICAgICAgICBlbGlmIGY9PTM6CiAgICAgICAgICAgIHByaW50KCJFeGl0aW5nIHRoZSBRdWl6IikKICAgICAgICAgICAgbXljdXJzb3IuY2xvc2UoKQogICAgICAgICAgICBteWRiLmNsb3NlKCkKICAgICAgICAgICAgc3lzLmV4aXQoKTsKICAgICAgICBlbHNlOgogICAgICAgICAgICBIb21lKCkKZGVmIFF1ZXN0aW9uKCk6CiAgICBjaD0nWSc7CiAgICB3aGlsZSBjaD09J1knIG9yIGNoPT0neSc6CiAgICAgICAgcHJpbnQoIldlbGNvbWUgdG8gUXVlc3Rpb24gUG9ydGFsIikKICAgICAgICBxPWlucHV0KCJFbnRlciB0aGUgcXVlc3Rpb24gOiIpCiAgICAgICAgb3AxPWlucHV0KCJFbnRlciB0aGUgb3B0aW9uIDEgOiIpCiAgICAgICAgb3AyPWlucHV0KCJFbnRlciB0aGUgb3B0aW9uIDIgOiIpCiAgICAgICAgb3AzPWlucHV0KCJFbnRlciB0aGUgb3B0aW9uIDMgOiIpCiAgICAgICAgb3A0PWlucHV0KCJFbnRlciB0aGUgb3B0aW9uIDQgOiIpCiAgICAgICAgYW5zPTAKICAgICAgICB3aGlsZSBhbnM9PTA6CiAgICAgICAgICAgIG9wPWludChpbnB1dCgiV2hpY2ggb3B0aW9uIGlzIGNvcnJlY3QgYW5zd2VyICgxLDIsMyw0KSIpKQogICAgICAgICAgICBpZiBvcD09MToKICAgICAgICAgICAgICAgIGFucz1vcDEKICAgICAgICAgICAgZWxpZiBvcD09MjoKICAgICAgICAgICAgICAgIGFucz1vcDIKICAgICAgICAgICAgZWxpZiBvcD09MzoKICAgICAgICAgICAgICAgIGFucz1vcDMKICAgICAgICAgICAgZWxpZiBvcD09NDoKICAgICAgICAgICAgICAgIGFucz1vcDQKICAgICAgICAgICAgZWxzZToKICAgICAgICAgICAgICAgIHByaW50KCJQbGVhc2UgY2hvb3NlIHRoZSBjb3JyZWN0IG9wdGlvbiBhcyBhbnN3ZXIiKQogICAgbXljdXJzb3IuZXhlY3V0ZSgiU2VsZWN0ICogZnJvbSBxdWVzdGlvbiIpCiAgICBkYXRhPW15Y3Vyc29yLmZldGNoYWxsKCkKICAgIHFpZD0obXljdXJzb3Iucm93Y291bnQpKzEKICAgIG15Y3Vyc29yLmV4ZWN1dGUoIkluc2VydCBpbnRvIHF1ZXN0aW9uIHZhbHVlcyIsKHFpZCxxLG9wMSxvcDIsb3AzLG9wNCxhbnMpKQogICAgbXlkYi5jb21taXQoKQogICAgY2g9aW5wdXQoIlF1ZXN0aW9uIGFkZGVkIHN1Y2Nlc3NmdWxseS4uIERvIHlvdSB3YW50IHRvIGFkZCBtb3JlIChZL04pIikKSG9tZSgpCmRlZiBRdWl6KCk6CiAgICBwcmludCgiV2VsY29tZSB0byBRdWl6IHBvcnRhbCIpCiAgICBteWN1cnNvci5leGVjdXRlKCJTZWxlY3QgKiBmcm9tIHF1ZXN0aW9uIikKICAgIGRhdGE9bXljdXJzb3IuZmV0Y2hhbGwoKQogICAgbmFtZT1pbnB1dCgiRW50ZXIgeW91ciBuYW1lIDoiKQogICAgcmM9bXljdXJzb3Iucm93Y291bnQKICAgIG5vcT1pbnQoaW5wdXQoIkVudGVyIHRoZSBudW1iZXIgb2YgcXVlc3Rpb25zIHRvIGF0dGVtcHQgKG1heCAlcyk6IiVyYykpCiAgICBsPVtdCiAgICB3aGlsZSBsZW4obCkhPW5vcToKICAgICAgICB4PXJhbmRvbS5yYW5kaW50KDEscmMpCiAgICAgICAgaWYgbC5jb3VudCh4KT4wOgogICAgICAgICAgICBsLnJlbW92ZSh4KQogICAgICAgIGVsc2U6CiAgICAgICAgICAgIGwuYXBwZW5kKHgpCiAgICAgICAgICAgIAogICAgcHJpbnQoIlF1aXogaGFzIHN0YXJ0ZWQiKQogICAgYz0xCiAgICBzY29yZT0wCiAgICBmb3IgaSBpbiByYW5nZSgwLGxlbihsKSk6CiAgICAgICAgbXljdXJzb3IuZXhlY3V0ZSgiU2VsZWN0ICogZnJvbSBxdWVzdGlvbiB3aGVyZSBxaWQ9JXMiLChsW2ldLCkpCiAgICAgICAgcXVlcz1teWN1cnNvci5mZXRjaG9uZSgpCiAgICAgICAgcHJpbnQoIlEuIixjLCI6IixxdWVzWzFdLCJcbkEuIixxdWVzWzJdLCJcdFx0Qi4iLHF1ZXNbM10sIlxuQy4iLHF1ZXNbNF0sIlx0XHRELiIscXVlc1s1XSkKCiAgICAgICAgYys9MQogICAgICAgIGFucz1Ob25lCiAgICAgICAgd2hpbGUgYW5zPT1Ob25lOgogICAgICAgICAgICBjaG9pY2U9aW5wdXQoIkFuc3dlciAoQSxCLEMsRCk6IikKICAgICAgICAgICAgaWYgY2hvaWNlPT0iQSI6CiAgICAgICAgICAgICAgICBhbnM9cXVlc1syXQogICAgICAgICAgICBlbGlmIGNob2ljZT09IkIiOgogICAgICAgICAgICAgICAgYW5zPXF1ZXNbM10KICAgICAgICAgICAgZWxpZiBjaG9pY2U9PSJDIjoKICAgICAgICAgICAgICAgIGFucz1xdWVzWzRdCiAgICAgICAgICAgIGVsaWYgY2hvaWNlPT0iRCI6CiAgICAgICAgICAgICAgICBhbnM9cXVlc1s1XQogICAgICAgICAgICBlbHNlOgogICAgICAgICAgICAgICAgcHJpbnQoIktpbmRseSBzZWxlY3QgQSxCLEMsRCBhcyBvcHRpb24gb25seSIpCiAgICBpZiBhbnM9PXF1ZXNbNl06CiAgICAgICAgcHJpbnQoIkNvcnJlY3QiKQogICAgICAgIHNjb3JlPXNjb3JlKzEKICAgIGVsc2U6CiAgICAgICAgcHJpbnQoIkluY29ycmVjdC4uIENvcnJlY3QgYW5zd2VyIGlzIDoiLHF1ZXNbNl0pCiAgICBwcmludCgiUXVpeiBoYXMgZW5kZWQgISEgWW91ciBmaW5hbCBzY29yZSBpcyA6IixzY29yZSkKICAgIGlucHV0KCJQcmVzcyBhbnkga2V5IHRvIGNvbnRpbnVlIikKICAgIEhvbWUoKQpIb21lKCkK