def load_rosters(cls, league_id, week):
"""
Load the rosters for the week
"""
print 'Loading rosters for league %s week %s' % (league_id, str(week))
week_list = cls.objects.filter(week=week)
teams = Team.objects.filter(league__league_key=league_id)
team_list = SortedDict([(team.team_key, team) for team in teams])
query_str = "select team_key, roster.players.player.player_key, roster.players.player.selected_position.position from fantasysports.teams.roster where team_key in (value) and week='%s'" % week
for result in cls.query_manager.batch_query(query_str, team_list.keys()):
team_key = result.get('team_key')
team = team_list.get(team_key)
print 'Loading team %s week %s' % (team.name, str(week))
team_rosters = week_list.filter(team=team)
team_rosters.delete()
player_list = result.get('roster').get('players').get('player')
for player in player_list:
player_obj = Player.get_player(player.get('player_key'))
position = player.get('selected_position').get('position')
roster_item = cls.objects.create(team=team, week=week, player=player_obj, position=position)
roster_item.save()
print '%s: %s' % (player_obj, position)
