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)
'filename': str(args.filename),
'directory': str(args.directory),
'game': str(args.game),
'league': str(args.league),
'force': bool(args.force),
}
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "fantasy.settings")
from analyze.models.player import Player
from analyze.models.league import League, NFLMatchup
from analyze.models.team import Team, Roster
if args.find:
Player.query_manager.set_sleep(int(args.sleep))
kwargs['eligible'] = args.eligible
Player.find_all(**kwargs)
elif args.raw:
import re
id_reg = re.compile('(\d+)$')
query = QueryManager(sleep=args.sleep)
with open(args.filename, 'r') as source:
player_list = []
for player_id in source:
player_id = player_id.strip()
if (int(args.start) <= int(id_reg.search(player_id).group(0)) and
int(args.end) >= int(id_reg.search(player_id).group(0))):
player_list.append(player_id)
query_str = "select * from fantasysports.players where player_key in (value)"
for result in query.batch_query(query_str, player_list):
player_id = result.get('player_key')
print player_id
