def get_pending_transactions(): transactions = dict() cursor.execute(SELECT_SQL) records = cursor.fetchall() for record in records: transaction = Transaction(record[0]) transaction.state = State(int(record[1])) transaction.cohorts = json.loads(record[2]) transactions[transaction.id] = transaction return transactions