def insert_schedules(self, session, first_season_start_year, last_season_start_year):
for season_start_year in range(first_season_start_year, last_season_start_year + 1):
season_schedule = return_schedule(season_start_year)
for event in season_schedule.parsed_event_list:
home_team = session.query(Team).filter_by(name=event.home_team_name).one()
away_team = session.query(Team).filter_by(name=event.visiting_team_name).one()
get_or_create(session, Game, home_team=home_team.id, away_team=away_team.id, start_time=event.start_time)
def write_box_scores_to_csv_for_season(season_start_year):
schedule = return_schedule(season_start_year + 1)
start_dates = sorted(
set([
event.start_time.astimezone(pytz.timezone("US/Eastern")).date()
for event in schedule.parsed_event_list
]))
for start_date in start_dates:
write_box_scores_to_csv_for_date(start_date)
def write_schedule_to_csv_for_seasons_in_range(start_year, end_year):
file_directory = os.path.dirname(os.path.realpath('__file__'))
for year in range(start_year, end_year + 1):
schedule = return_schedule(year)
file_to_write = os.path.join(
file_directory,
"schedules/{0}_{1}.csv".format(schedule.start_year,
schedule.end_year))
write_schedule_data_to_csv(schedule, file_to_write)
def write_box_scores_to_csv_for_season(season_start_year):
schedule = return_schedule(season_start_year + 1)
start_dates = sorted(set([event.start_time.astimezone(pytz.timezone("US/Eastern")).date() for event in schedule.parsed_event_list]))
for start_date in start_dates:
write_box_scores_to_csv_for_date(start_date)
def write_schedule_to_csv_for_seasons_in_range(start_year, end_year):
file_directory = os.path.dirname(os.path.realpath('__file__'))
for year in range(start_year, end_year + 1):
schedule = return_schedule(year)
file_to_write = os.path.join(file_directory, "schedules/{0}_{1}.csv".format(schedule.start_year, schedule.end_year))
write_schedule_data_to_csv(schedule, file_to_write)
