def createQuizWithQuestions(self, val): # CREATE LIST OF ALL QUESTION FROM SAME QUIZ ID quizId = val db = Database() conn = db.getConnection() cursor = conn.cursor() # get data from db cursor.execute('SELECT * FROM Questions WHERE QuizId = ?', (quizId,)) records = cursor.fetchall() questionsDictionary = [] i = 0 for i in range(len(records)): q = records[i] # options options = {} if q[4]: options["option1"] = q[4] if q[5]: options["option2"] = q[5] if q[6]: options["option3"] = q[6] if q[7]: options["option4"] = q[7] question = { "id": str(q[0]), "question": q[2], "solution": q[3], "options": options, "time": q[8], "score": q[9] } questionsDictionary.append(question) i = i+1 db.closeConnection() return questionsDictionary
def test_database_has_entries(self): database = Database() self.assertTrue(len(database.snapshots) > 0)
def test_one_contract_has_id(self): database = Database() contract_id = database.snapshots[0].markets[0].get_contracts[0].id self.assertTrue(isinstance(contract_id, int))
from Classes.Database import Database from Classes.HTMLWriter import HTMLWriter from Classes.DataCollector import DataCollector from Classes.NumberCruncher import NumberCruncher data_collector = DataCollector() data_collector.collect_data() data_collector.export_content() database = Database() number_cruncher = NumberCruncher(database.snapshots) number_cruncher.write_bias_graph_to_csv("bias_graph.csv") html_writer = HTMLWriter() html_writer.write("predictit-forecasting.html") print("MainDriver run complete!")
def test_one_contract_has_id(self): database = Database() snapshot = list(database.snapshots.values())[0] contract_id = snapshot.markets[0].get_contracts[0].id self.assertTrue(isinstance(contract_id, int))
def test_initialize(self): database = Database() number_cruncher = NumberCruncher(database.snapshots) self.assertTrue(len(number_cruncher.snapshots) > 0)
def test_averages(self): database = Database("data_logs_tests/test_2") number_cruncher = NumberCruncher(database.snapshots) graph = number_cruncher.graph average_bias = graph.points[1].average_bias self.assertTrue(0.01 >= average_bias >= -0.01)
def test_resolve_to_yes(self): database = Database("data_logs_tests/test_1") number_cruncher = NumberCruncher(database.snapshots) graph = number_cruncher.graph self.assertTrue(graph.points[1].average_bias == -0.5)
def test_graph_has_points(self): database = Database() number_cruncher = NumberCruncher(database.snapshots) graph = number_cruncher.graph points = graph.points self.assertTrue(len(points) > 0)