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)