def get_unsolved_challenges(self):
"""
Return a query that produces a list of all unsolved challenges for a
given team.
"""
team_solved_subquery = get_team_solved_subquery(self.id)
online = get_online_challenges()
return online.filter(not_(team_solved_subquery))
def test_get_online_challenges(self, all_in_db):
assert len(get_online_challenges().all()) == 3
