def get_all():
with DB() as database:
rows = Adapter.adapt_query(database.execute('''SELECT * FROM questions''').fetchall()) # convert the data into a list of lists
rows = Adapter.adapt_question_rows(database, rows)
return [Question(*row) for row in rows] # instantiate questions list
def find(id):
with DB() as database:
row = Adapter.adapt_query(database.execute('''SELECT * FROM questions WHERE id = ?''', (id,)).fetchall())
try:
row = tuple(Adapter.adapt_question_rows(database, row)[0])
except IndexError as error:
return None
return Question(*row)
