#db = MySQLdb.connect(host="localhost", # your host, usually localhost
# user="******", # your username
# passwd="bfg123", # your password
# db="bfg") # name of the data base
#test scoreboard
scoreboard = Database("54.218.32.132", "bfguser", "bfg123", "bfg")
scoreboard.dropScoreboardTable()
scoreboard.createScoreboardTable()
test1 = {'name':'Player','score': 9999.99}
#test2 = {'name':'MyName','score': 32.5}
#test3 = {'name':'Hello','score': 5.98}
#test4 = {'name':'Player','score': 1.23}
for i in range(0, 10):
scoreboard.insertScore(test1)
#scoreboard.insertScore(test2)
#scoreboard.insertScore(test3)
#scoreboard.insertScore(test4)
sblist = []
scoreboard.getTopScores(sblist)
length = len(sblist)
print "TOP 10 SCORES"
for i in range(0, length):
print sblist[i]
class Engine:
def __init__(self):
self.my_db = Database('ega.db','user.db')
self.c = {}
root = Tk()
root.geometry("800x300+100+100")
self.my_gui = Gui(self, root)
root.mainloop()
def doRandom(self):
self.i = self.right = self.total = 0
self.wrong_questions = []
self.questions = [x[0] for x in self.my_db.getRandomQuestions()]
self.nextQuestion()
def doWorstRated(self):
self.i = self.right = self.total = 0
self.wrong_questions = []
self.questions = [x[0] for x in self.my_db.getWorstRated()]
self.nextQuestion()
def doType(self, id_type):
self.i = self.right = self.total = 0
self.wrong_questions = []
self.questions = [x[0] for x in self.my_db.getFullType(id_type)]
self.nextQuestion()
def doExam(self, id_exam):
self.i = self.right = self.total = 0
self.wrong_questions = []
self.questions = [x[0] for x in self.my_db.getFullExam(id_exam)]
self.nextQuestion()
def nextQuestion(self):
if self.i < len(self.questions):
id_question = self.questions[self.i]
question = self.my_db.getSingleQuestion(id_question)
self.c["id_question"] = id_question
self.c["id_exam"] = question[9]
self.c["solution"] = question[6]
self.i += 1
self.my_gui.setQuestion(question)
else:
if self.total == 10:
self.my_db.insertScore(self.right)
self.my_gui.launchPopup(self.doWrong)
def doWrong(self):
self.questions = list(set(self.wrong_questions))
self.i = self.right = self.total = 0
self.my_gui.setStatusBar(str(self.right) + " / " + str(self.total))
self.wrong_questions = []
self.nextQuestion()
def questionCallback(self, sel_option):
c = self.c
if not c["id_question"] in self.wrong_questions:
self.total += 1
if c["solution"] == sel_option:
self.right += 1
else:
self.wrong_questions.append(c["id_question"])
self.my_gui.setStatusBar(str(self.right) + " / " + str(self.total))
self.my_db.updateQuestion(c["id_question"], c["id_exam"], (c["solution"] == sel_option))
if c["solution"] == sel_option:
self.nextQuestion()
