def get_pitch_stats_for_season_for_all_teams(cls, db_engine, year): s = select([cls]).where(cls.year == year) results = db_engine.execute(s).fetchall() return PitchStatsMetrics.from_query_results(results) if results else []
def get_pitch_stats_by_year_for_team(cls, db_engine, team_id_bbref): s = select([cls]).where(cls.team_id_bbref == team_id_bbref) results = db_engine.execute(s).fetchall() return PitchStatsMetrics.from_query_results(results) if results else []
def get_pitch_stats_for_career_for_player(cls, db_engine, mlb_id): s = select([cls]).where(cls.mlb_id == mlb_id) results = db_engine.execute(s).fetchall() return PitchStatsMetrics.from_query_results( results)[0] if results else None
def get_pitch_stats_for_team(cls, db_engine, team_id_bbref, year): s = select([cls]).where(and_(cls.team_id_bbref == team_id_bbref, cls.year == year)) results = db_engine.execute(s).fetchall() return PitchStatsMetrics.from_query_results(results)[0] if results else None
def get_pitch_stats_by_opp_team_by_year_for_player(cls, db_engine, mlb_id): s = select([cls]).where(cls.mlb_id == mlb_id) results = db_engine.execute(s).fetchall() return PitchStatsMetrics.from_query_results(results) if results else []