def team_parser(season_id=2011, division="1"):
# defaults to division 1, but also supports division 3
season = Season.objects.get(end_year=season_id)
url = "http://stats.ncaa.org/team/inst_team_list/%s?division=%s" % (
season.ncaa_id, division)
soup = soupify(url)
team_links = [x.find('a') for x in soup.findAll('td')]
for team in team_links:
ncaa_id = int(team["href"].split("=")[1])
name = SafeUnicode(team.contents[0])
t, created = Team.objects.get_or_create(ncaa_id=ncaa_id, name=name)
team_season, created = TeamSeason.objects.get_or_create(team=t,
season=season,
division=1)
def schedule_parser(season_id, team_id):
season = Season.objects.get(ncaa_id=season_id)
url = "http://stats.ncaa.org/team/index/%s?org_id=%s" % (season_id,
team_id)
soup = soupify(url)
game_ids = []
links = soup.findAll('table')[1].findAll(
lambda tag: tag.name == 'a' and tag.findParent(
'td', attrs={'class': 'smtext'}))
for link in links:
if not link.has_key('onclick'):
game_ids.append(int(link["href"].split("?")[0].split("/")[3]))
for game_id in game_ids:
game_parser(game_id)
def game_parser(game_id, season_id=2011):
url = "http://stats.ncaa.org/game/box_score/%s" % game_id
soup = soupify(url)
season = Season.objects.get(end_year=season_id)
visit_id, home_id = [
int(x['href'].split('=')[1])
for x in soup.findAll('table')[0].findAll('a')
]
try:
visit = TeamSeason.objects.select_related().get(team__ncaa_id=visit_id,
season=season)
except:
v_team, created = Team.objects.get_or_create(
ncaa_id=visit_id,
name=soup.findAll('table')[0].findAll('a')[0].renderContents())
visit = TeamSeason.objects.create(team=v_team,
season=season,
division=0)
home = TeamSeason.objects.select_related().get(team__ncaa_id=home_id,
season=season)
game_details = soup.findAll('table')[2]
dt = parse(game_details.findAll('td')[1].contents[0])
loc = game_details.findAll('td')[3].contents[0]
try:
attend = int(
game_details.findAll('td')[5].contents[0].replace(',', ''))
except:
attend = None
officials = soup.findAll('table')[3].findAll('td')[1].contents[0].strip()
scores = soup.findAll('table')[0].findAll('td', attrs={'align': 'right'})
visit_team_scores = [
int(x.renderContents()) for x in scores[0:len(scores) / 2]
]
home_team_scores = [
int(x.renderContents()) for x in scores[len(scores) / 2:len(scores)]
] # second team listed is considered home team
home_final = home_team_scores[(len(scores) / 2) - 1]
visit_final = visit_team_scores[(len(scores) / 2) - 1]
game, created = Game.objects.get_or_create(
ncaa_id=game_id,
home_team=home,
visiting_team=visit,
datetime=dt,
location=SafeUnicode(loc),
attendance=attend,
officials=SafeUnicode(officials),
home_team_score=home_final,
visiting_team_score=visit_final)
def roster_parser(season_id, team_id, division=1):
team_season = TeamSeason.objects.select_related().get(
team__ncaa_id=team_id, season__end_year=season_id)
url = "http://stats.ncaa.org/team/index/%s?org_id=%s" % (
team_season.season.ncaa_id, team_id)
soup = soupify(url)
rows = soup.findAll('table')[2].findAll('tr')
player_links = rows[2:len(rows)]
for p in player_links:
try:
ncaa_id = int(
float(p.findAll('td')[1].find('a')['href'].split('=', 2)[2]))
name = extract_player_name(
p.findAll('td')[1].find('a').contents[0].split(','))
except:
ncaa_id = -1
name = extract_player_name(
p.findAll('td')[1].contents[0].split(','))
player, player_created = Player.objects.get_or_create(name=name,
ncaa_id=ncaa_id)
player_season, ps_created = PlayerSeason.objects.get_or_create(
player=player, team_season=team_season)
if ps_created:
try:
player_season.jersey = int(p.findAll('td')[0].contents[0])
except:
player_season.jersey = None
try:
player_season.position = SafeUnicode(
p.findAll('td')[2].contents[0])
player_season.feet = int(
p.findAll('td')[3].contents[0].split('-')[0])
player_season.inches = int(
p.findAll('td')[3].contents[0].split('-')[1])
player_season.year = SafeUnicode(
p.findAll('td')[4].contents[0])
except:
pass
player_season.save()
