Application.py

import tkinter as tk
from tkinter import *
import tkinter.font as tkFont
import tkinter.messagebox
import mysql.connector
import requests
import json

# exitProtocol is called whenever a user presses the button to exit the program
def exitProtocol(self):
    exitOption = tkinter.messagebox.askquestion("Exit?", "Are you sure you want to exit?")

    if exitOption == "no":
        pass
    else:
        app.destroy()


# The setUp class is used for defining the global variables and main frame that things are placed in
# each of the classes, which are also frames, are defined here
class setUp(tk.Tk):

    def __init__(self, *args, **kwargs):
        tk.Tk.__init__(self, *args, **kwargs)
        container = tk.Frame(self)

        self.state('zoomed')

        # Disabled for the moment since it has not been implemented yet
        # global currentTimeline
        # currentTimeline = tk.StringVar()
        # currentTimeline.set("1775 - 1861")
        global numquestions
        numquestions = tk.IntVar()
        numquestions.set(15)
        global questionsAnswered
        questionsAnswered = tk.IntVar()
        questionsAnswered.set(1)
        global questionsCorrect
        questionsCorrect = tk.IntVar()
        questionsCorrect.set(0)
        global percentCorrect
        percentCorrect = tk.StringVar()
        percentCorrect.set("0.0")
        global requestmade
        requestmade=False
        global localCount
        localCount = 4

        container.pack(side="top", fill="both", expand=True)

        container.grid_rowconfigure(0, weight=1)
        container.grid_columnconfigure(0, weight=1)

        self.frames = {}

        for F in (startPage, settingsPage, questionsPage, pausePage, resultsPage, tutorialpage):
            frame = F(container, self)
            self.frames[F] = frame
            frame.grid(row=0, column=0, sticky="nsew")

        self.show_frame(startPage)

    # called in order to change the page of the program
    def show_frame(self, cont):

        frame = self.frames[cont]
        frame.tkraise()


# startPage is the main page that a user will come to when starting the program
class startPage(tk.Frame):
    def __init__(self, parent, controller):
        tk.Frame.__init__(self, parent)
        exitButton = Button(self, text="Exit", width=10, height=1, padx=10, pady=10, command=lambda:exitProtocol(self))
        exitButton.pack(side=LEFT, anchor=NW)

        settingsButton = Button(self, text="Settings", width=10, height=1, padx=10, pady=10,
                                command=lambda:controller.show_frame(settingsPage))
        settingsButton.pack(side=RIGHT, anchor=NE)

        fontStyle = tkFont.Font(family="Lucida Grande", size=15)
        startButton = Button(self, text="Start", width=20, height=2, font=fontStyle, bg="blue", fg="white",
                             command=lambda:controller.show_frame(tutorialpage))
        startButton.pack(side=BOTTOM)

        fontStyle = tkFont.Font(size=35)
        title = Label(self, text="Time Line History Quiz", width=50, height=2, font=fontStyle)
        title.pack(side=TOP)

        fontStyle = tkFont.Font(size=12, slant="italic")
        description = Label(self, text="This program is meant to test your knowledge of the timelines of various "
                                       "periods of history.\n To change your time period, select settings in the top "
                                       "right corner. Once you have confirmed your correct time period, select start "
                                       "to begin the test.", font=fontStyle, height=10)
        description.pack(side=TOP)


# settingsPage is the settings page that a user can enter use to change on their test.
class settingsPage(tk.Frame):
    def __init__(self, parent, controller):
        tk.Frame.__init__(self, parent)

        # saveChanges is used to finalize changes that a user may make
        def savechanges():
            # Disabled for the moment since it has not been implemented yet
            # global currentTimeline
            # currentTimeline.set(clicked1.get())
            global numquestions
            numquestions.set(clicked2.get())

            if numquestions.get() >= 40:
                numareyousure = tkinter.messagebox.askquestion("Are you sure?",
                                                               "You have selected the option to have over 40 questions."
                                                               " This may take you a long time to complete. "
                                                               "Are you sure that this is the correct number "
                                                               "of questions?")
                if numareyousure == "yes":
                    pass
                else:
                    numquestions.set(15)
                    clicked2.set(numQuestionsOptions[2])

        homeButton = Button(self, text="Home", width=10, height=1, padx=10, pady=10,
                            command=lambda: controller.show_frame(startPage))
        homeButton.pack(side=LEFT, anchor=NW)

        fontStyle = tkFont.Font(size=35)
        title = Label(self, text="Settings", height=3, font=fontStyle)
        title.pack(side=TOP)

        # Disabled for the moment since it has not been implemented yet
        # fontStyle = tkFont.Font(size=16)
        # TPlabel = Label(self, text="Time Period", font=fontStyle)
        # TPlabel.pack(side=TOP)
        #
        # fontStyle = tkFont.Font(size=10, slant="italic")
        # TP2label = Label(self, text="This will change the time period that you are asked questions and tested on",
        #                  font=fontStyle)
        # TP2label.pack(side=TOP)
        #
        # timePeriodOptions = ["1775 - 1861", "1862 - 1914", "1915 - 1945", "1946 - 1968", "1969 - Present"]

        # clicked1 = StringVar()
        # clicked1.set(timePeriodOptions[0])
        #
        # drop1 = OptionMenu(self, clicked1, *timePeriodOptions)
        # drop1.pack(side=TOP)

        fontStyle = tkFont.Font(size=16)
        NQlabel = Label(self, text="Number of Questions", font=fontStyle)
        NQlabel.pack(side=TOP)

        fontStyle = tkFont.Font(size=10, slant="italic")
        NQ2label = Label(self, text="This will change the total number of questions of the overall test",
                         font=fontStyle)
        NQ2label.pack(side=TOP)

        numQuestionsOptions = ["5","10","15","20","25","30","35","40","45","50"]

        clicked2 = StringVar()
        clicked2.set(numQuestionsOptions[2])

        drop2 = OptionMenu(self, clicked2, *numQuestionsOptions)
        drop2.pack(side=TOP)

        fontStyle = tkFont.Font(size=12)
        selectButton = Button(self, text="Save Changes", bg="blue", fg="white", width=20, height=2, font=fontStyle,
                              command=savechanges)
        selectButton.pack(side=BOTTOM)


# Question is an object used to store a string which is the name and a string which is also a date
class Question:
  def __init__(self, text, date):
    self.text = tk.StringVar()
    self.text.set(text)
    self.date = tk.StringVar()
    self.date.set(date)


# tutorialpage is used to help with outlining each of the functions for the user.
class tutorialpage(tk.Frame):
    def __init__(self, parent, controller):
        tk.Frame.__init__(self, parent)

        def resetCorrect():
            global questionsCorrect
            questionsCorrect.set(0)
            controller.show_frame(questionsPage)

        homeButton = Button(self, text="Home", width=10, height=1, padx=10, pady=10)
        homeButton.pack(side=LEFT, anchor=NW)

        pauseButton = Button(self, text="Pause", width=10, height=1, padx=10, pady=10)
        pauseButton.pack(side=RIGHT, anchor=NE)

        # Disabled for the moment since it has not been implemented yet
        # global currentTimeline
        fontStyle = tkFont.Font(family="lucida Grande", size=18)
        # timeperiodlabel = Label(self, textvariable=currentTimeline, font=fontStyle)
        # timeperiodlabel.pack(side=TOP)

        QuestionFrame = Frame(self)
        AnswersFrame = Frame(self)
        nextframe = Frame(self)
        questionframe = Frame(self)
        QuestionFrame.place(relx=.05, rely=.4, anchor=W)
        AnswersFrame.place(relx=.8, rely=.4, anchor=E)
        questionframe.place(relx=.1, rely=1, anchor=S)
        nextframe.place(relx=.95, rely=1, anchor=S)

        question1 = Label(QuestionFrame, text="Name", font=fontStyle)
        question1.pack()
        spacer1 = Label(QuestionFrame, text="")
        spacer1.pack()

        question2 = Label(QuestionFrame, text="Name", font=fontStyle)
        question2.pack()
        spacer2 = Label(QuestionFrame, text="")
        spacer2.pack()

        question3 = Label(QuestionFrame, text="Name", font=fontStyle)
        question3.pack()
        spacer3 = Label(QuestionFrame, text="")
        spacer3.pack()

        question4 = Label(QuestionFrame, text="Name", font=fontStyle)
        question4.pack()

        Answers = ["1st", "2nd", "3rd", "4th"]

        clicked1 = StringVar()
        clicked1.set(Answers[0])
        drop1 = OptionMenu(AnswersFrame, clicked1, *Answers)
        drop1.pack(side=TOP)
        spacer21 = Label(AnswersFrame, text="")
        spacer21.pack()
        clicked2 = StringVar()
        clicked2.set(Answers[0])
        drop2 = OptionMenu(AnswersFrame, clicked2, *Answers)
        drop2.pack(side=TOP)
        spacer22 = Label(AnswersFrame, text="")
        spacer22.pack()
        clicked3 = StringVar()
        clicked3.set(Answers[0])
        drop3 = OptionMenu(AnswersFrame, clicked3, *Answers)
        drop3.pack(side=TOP)
        spacer23 = Label(AnswersFrame, text="")
        spacer23.pack()
        clicked4 = StringVar()
        clicked4.set(Answers[0])
        drop4 = OptionMenu(AnswersFrame, clicked4, *Answers)
        drop4.pack(side=TOP)

        global numquestions
        global questionsAnswered
        fontStyle = tkFont.Font(size=20)
        CurQuestion = Label(questionframe, textvariable=questionsAnswered, font=fontStyle)
        spacerlabel = Label(questionframe, text="/", font=fontStyle)
        totalQuestions = Label(questionframe, textvariable=numquestions, font=fontStyle)
        CurQuestion.pack(side=LEFT)
        spacerlabel.pack(side=LEFT)
        totalQuestions.pack(side=LEFT)

        NextButton = Button(nextframe, text="Next", font=fontStyle, bg="Orange")
        NextButton.pack(side=RIGHT)

        fontStyle = tkFont.Font(size=15)
        startButton = Button(self, text= "Start", font=fontStyle, bg="Blue", fg="White", width=20, height=2,
                             command=resetCorrect)
        startButton.place(relx=.5, rely=1, anchor=S)

        # These are the tutorial labels that are used to help a user
        fontStyle = tkFont.Font(slant="italic")
        homelabel = Label(self, text="Select To Go To The Home Page", font=fontStyle)
        pauselabel = Label(self, text="Select To Pause The Test", font=fontStyle)
        namelabel = Label(self, text="Displayed In Place Of 'Name' Will Be \n Names That You Will Be Putting In Order",
                          font=fontStyle)
        #timelinelabel = Label(self, text="This Is The Current Timeline That You Have Selected", font=fontStyle)
        answerslabel = Label(self, text="Choose An Order For The \n Names Based On Birthdate", font=fontStyle)
        questionslabel = Label(self, text="Current Question Number/ Number Of Questions In The Test", font=fontStyle)
        nextlabel = Label(self, text="Select In Order To Go \n To The Next Question", font=fontStyle)
        homelabel.place(relx=0, rely=.06, anchor=NW)
        pauselabel.place(relx=1, rely=.06, anchor=NE)
        # timelinelabel.place(relx=.5, rely=.04, anchor=N)
        namelabel.place(relx=0, rely=.55, anchor=W)
        answerslabel.place(relx=.85, rely=.55, anchor=E)
        questionslabel.place(relx=0, rely=.95, anchor=SW)
        nextlabel.place(relx=.99, rely=.92, anchor=SE)


# questionsPage is the actual page of the test with questions and during test information
class questionsPage(tk.Frame):
    def __init__(self, parent, controller):
        tk.Frame.__init__(self, parent)

        # homeProtocol, similar to exit protocol is called whenever a user requests to go back to home
        def homeProtocol():
            exitOption = tkinter.messagebox.askquestion("Exit To Home?", "Are you sure you want to quit the test? "
                                                                         "All progress will be lost")

            if exitOption == "no":
                pass
            else:
                global questionsAnswered
                questionsAnswered.set(1)
                controller.show_frame(startPage)

        # conversion is a helper function for checking if questions are correct.
        def conversion(change):
            if change == "1st":
                return 1
            elif change == "2nd":
                return 2
            elif change == "3rd":
                return 3
            else:
                return 4

        # checkCorrect will take a users answer and check to see if they correct
        def checkCorrect():
            global questionsCorrect
            ans1 = conversion(Option1answer.get())
            ans2 = conversion(Option2answer.get())
            ans3 = conversion(Option3answer.get())
            ans4 = conversion(Option4answer.get())

            answersConverted = [ans1, ans2, ans3, ans4]

            questions1 = question1txt.date.get()
            questions2 = question2txt.date.get()
            questions3 = question3txt.date.get()
            questions4 = question4txt.date.get()

            questions = [questions1, questions2, questions3, questions4]
            questionsSorted = sorted(questions)


            for i in range(0, 4):
                if answersConverted[i] == questionsSorted.index(questions[i]) + 1:
                    pass
                else:
                    return False
            questionsCorrect.set(questionsCorrect.get() + 1)
            return True

        # updatequestions is used for updating the questions on the test. This is called each time a user
        # goes to the next question.
        def updatequestions():
            global requestmade
            global localCount
            request = {}
            request = requests.get("http://flip3.engr.oregonstate.edu:6952/query")
            requestmade = True
            response = request.json()
            responselength = len(response)

            if localCount < responselength:
                question1txt.text.set(response[localCount]['name'])
                question1txt.date.set(response[localCount]['date'])
                localCount+=1
            else:
                localCount = 0
                question1txt.text.set(response[localCount]['name'])
                question1txt.date.set(response[localCount]['date'])
                localCount+=1

            if localCount < responselength:
                question2txt.text.set(response[localCount]['name'])
                question2txt.date.set(response[localCount]['date'])
                localCount+=1
            else:
                localCount = 0
                question2txt.text.set(response[localCount]['name'])
                question2txt.date.set(response[localCount]['date'])
                localCount+=1

            if localCount < responselength:
                question3txt.text.set(response[localCount]['name'])
                question3txt.date.set(response[localCount]['date'])
                localCount+=1
            else:
                localCount = 0
                question3txt.text.set(response[localCount]['name'])
                question3txt.date.set(response[localCount]['date'])
                localCount+=1

            if localCount < responselength:
                question4txt.text.set(response[localCount]['name'])
                question4txt.date.set(response[localCount]['date'])
                localCount+=1
            else:
                localCount = 0
                question4txt.text.set(response[localCount]['name'])
                question4txt.date.set(response[localCount]['date'])
                localCount+=1


            Option1answer.set(Answers[0])
            Option2answer.set(Answers[0])
            Option3answer.set(Answers[0])
            Option4answer.set(Answers[0])

        # updateServer is used in order to connect with my local Server and send the test information to it
        def updateServer():
            db = mysql.connector.connect(
                host="localhost",
                user="root",
                passwd="Celticsbasketball2001.",
                database="mainbase"
            )

            cur = db.cursor()

            global numquestions
            global questionsCorrect
            global percentCorrect

            cur.execute("INSERT INTO finaltab (numbercorrect, numberofquestions, percentage) VALUES (%s, %s, %s)",
                        (questionsCorrect.get(), numquestions.get(), percentCorrect.get()))
            db.commit()
            controller.show_frame(resultsPage)

        # endTest is used to check if the test needs to be ended
        def endTest():
            global numquestions
            global questionsAnswered
            global percentCorrect
            global questionsCorrect
            questionsAnswered.set(questionsAnswered.get() + 1)
            checkCorrect()

            if questionsAnswered.get() > numquestions.get():
                questionsAnswered.set(1)
                percentCorrect.set(str((questionsCorrect.get() / numquestions.get()) * 100) + "%")
                updateServer()

            else:
                updatequestions()

        homeButton = Button(self, text="Home", width=10, height=1, padx=10, pady=10, command=homeProtocol)
        homeButton.pack(side=LEFT, anchor=NW)

        pauseButton = Button(self, text="Pause", width=10, height=1, padx=10, pady=10,
                             command=lambda:controller.show_frame(pausePage))
        pauseButton.pack(side=RIGHT, anchor=NE)

        # Disabled for the moment since it has not been implemented yet
        # global currentTimeline
        fontStyle = tkFont.Font(family="lucida Grande", size=18)
        # timeperiodlabel = Label(self, textvariable=currentTimeline, font=fontStyle)
        # timeperiodlabel.pack(side=TOP)

        QuestionFrame = Frame(self)
        AnswersFrame = Frame(self)
        nextframe = Frame(self)
        questionframe = Frame(self)
        QuestionFrame.place(relx=.05, rely=.4, anchor=W)
        AnswersFrame.place(relx=.8, rely=.4, anchor=E)
        questionframe.place(relx=.1, rely=1, anchor=S)
        nextframe.place(relx=.95, rely=1, anchor=S)

        question1txt = Question("", 0)
        question1 = Label(QuestionFrame, textvariable=question1txt.text, font=fontStyle)
        question1.pack()
        spacer1 = Label(QuestionFrame, text="")
        spacer1.pack()

        question2txt = Question("", 0)
        question2 = Label(QuestionFrame, textvariable=question2txt.text, font=fontStyle)
        question2.pack()
        spacer2 = Label(QuestionFrame, text="")
        spacer2.pack()

        question3txt = Question("", 0)
        question3 = Label(QuestionFrame, textvariable=question3txt.text, font=fontStyle)
        question3.pack()
        spacer3 = Label(QuestionFrame, text="")
        spacer3.pack()

        question4txt = Question("", 0)
        question4 = Label(QuestionFrame, textvariable=question4txt.text, font=fontStyle)
        question4.pack()

        Answers = ["1st", "2nd", "3rd", "4th"]

        Option1answer = StringVar()
        Option1answer.set(Answers[0])
        drop1 = OptionMenu(AnswersFrame, Option1answer, *Answers)
        drop1.pack(side=TOP)
        blankline1 = Label(AnswersFrame, text="")
        blankline1.pack()
        Option2answer = StringVar()
        Option2answer.set(Answers[0])
        drop2 = OptionMenu(AnswersFrame, Option2answer, *Answers)
        drop2.pack(side=TOP)
        blankline2 = Label(AnswersFrame, text="")
        blankline2.pack()
        Option3answer = StringVar()
        Option3answer.set(Answers[0])
        drop3 = OptionMenu(AnswersFrame, Option3answer, *Answers)
        drop3.pack(side=TOP)
        blankline3 = Label(AnswersFrame, text="")
        blankline3.pack()
        Option4answer = StringVar()
        Option4answer.set(Answers[0])
        drop4 = OptionMenu(AnswersFrame, Option4answer, *Answers)
        drop4.pack(side=TOP)

        global numquestions
        global questionsAnswered
        fontStyle = tkFont.Font(size=20)
        CurQuestion = Label(questionframe, textvariable=questionsAnswered, font=fontStyle)
        spacerlabel = Label(questionframe, text="/", font=fontStyle)
        totalQuestions = Label(questionframe, textvariable=numquestions, font=fontStyle)
        CurQuestion.pack(side=LEFT)
        spacerlabel.pack(side=LEFT)
        totalQuestions.pack(side=LEFT)

        NextButton = Button(nextframe, text="Next", font=fontStyle, bg = "Orange", command=endTest)
        NextButton.pack(side=RIGHT)

        global requestmade
        request = {}
        if requestmade == False:
            request = requests.get("http://flip3.engr.oregonstate.edu:6952/query")
            requestmade = True
        response = request.json()
        question1txt.text.set(response[0]['name'])
        question1txt.date.set(response[0]['date'])
        question2txt.text.set(response[1]['name'])
        question2txt.date.set(response[1]['date'])
        question3txt.text.set(response[2]['name'])
        question3txt.date.set(response[2]['date'])
        question4txt.text.set(response[3]['name'])
        question4txt.date.set(response[3]['date'])


# pausePage is used for when a user pauses a test.
class pausePage(tk.Frame):
    def __init__(self, parent, controller):
        tk.Frame.__init__(self,parent)

        # homeProtocol, similar to exit protocol is called whenever a user requests to go back to home
        def homeProtocol():
            messagetext = "Are you sure you want to quit the test? All progress will be lost"
            exitOption = tkinter.messagebox.askquestion("Exit To Home?", messagetext)

            if exitOption == "no":
                pass
            else:
                global questionsAnswered
                questionsAnswered.set(1)
                controller.show_frame(startPage)

        homeButton = Button(self, text="Home", width=10, height=1, padx=10, pady=10, command=homeProtocol)
        homeButton.pack(side=LEFT, anchor=NW)

        fontStyle = tkFont.Font(family="Lucida Grande", size=15)
        ResumeButton = Button(self, text="Resume", width=20, height=2, font=fontStyle, bg="blue", fg="white",
                              command=lambda: controller.show_frame(questionsPage))
        ResumeButton.pack(side=BOTTOM)

        fontStyle = tkFont.Font(size=20)
        PausedLabel = Label(self, pady=30, text="The Test Has Been Paused", font=fontStyle)
        PausedLabel.pack(side=TOP)

        curansweredlbl = Frame(self)
        curansweredlbl.place(relx=.5, rely=.5, anchor="center")

        global questionsAnswered
        qnumlbl = Label(curansweredlbl, text="Question Number: ", font=fontStyle)
        curQuestion = Label(curansweredlbl, textvariable=questionsAnswered, font=fontStyle)
        qnumlbl.pack(side=LEFT)
        curQuestion.pack(side=LEFT)


# resultsPage is used to display the final results of the test that the user was doing.
class resultsPage(tk.Frame):
    def __init__(self, parent, controller):

        tk.Frame.__init__(self,parent)
        exitButton = Button(self, text="Exit", width=10, height=1, padx=10, pady=10, command=lambda: exitProtocol(self))
        exitButton.pack(side=LEFT, anchor=NW)

        fontStyle = tkFont.Font(family="Lucida Grande", size=12)
        startButton = Button(self, text="Home", width=20, height=2, font=fontStyle, bg="blue", fg="white",
                             command=lambda: controller.show_frame(startPage))
        startButton.pack(side=BOTTOM)

        # Disabled for the moment since it has not been implemented yet
        # fontStyle = tkFont.Font(size=18)
        # timeperiodlabel = Label(self, textvariable=currentTimeline, font=fontStyle)
        # timeperiodlabel.pack(side=TOP)

        fontStyle = tkFont.Font(size=24)
        finishedlabel = Label(self, text="Finished! Here's The Results", font=fontStyle)
        finishedlabel.pack(side=TOP)

        keyframe = Frame(self)
        resultframe = Frame(self)
        keyframe.place(relx=.40, rely=.5)
        resultframe.place(relx=.60, rely=.5)

        global questionsCorrect
        global numquestions
        global percentCorrect
        fontStyle = tkFont.Font(size=16)
        numCorrect = Label(keyframe, text="Total Correct:", font=fontStyle)
        numCorrect.pack()
        CurQuestion = Label(resultframe, textvariable=questionsCorrect, font=fontStyle)
        spacerlabel = Label(resultframe, text="/", font=fontStyle)
        totalQuestions = Label(resultframe, textvariable=numquestions, font=fontStyle)
        percentCorrectlbl = Label(keyframe, text="Percent Correct:", font=fontStyle)
        percentCorrectlbl.pack()
        PercentLabel = Label(resultframe, textvariable=percentCorrect, font=fontStyle)
        PercentLabel.pack(side=BOTTOM)
        CurQuestion.pack(side=LEFT)
        spacerlabel.pack(side=LEFT)
        totalQuestions.pack(side=LEFT)



app = setUp()
app.title("Time Line Test")


app.mainloop()