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)
