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)