def fetch_problems(self): query = ''' SELECT contest_id, p_index, name, type, rating, tags, start_time FROM problem ''' res = self.conn.execute(query).fetchall() if res is None: return None return [(cf.Problem(*r[:6]), r[6]) for r in res]
def _unsquish_tags(problem): args, tags = problem[:-1], json.loads(problem[-1]) return cf.Problem(*args, tags)