import json
import sys
from nba_api.stats.endpoints import leaguegamefinder, boxscoretraditionalv3

if len(sys.argv) < 4:
    print(json.dumps({"error": "Paramètres manquants"}))
    sys.exit(1)

game_date = sys.argv[1]
team_1 = sys.argv[2]
team_2 = sys.argv[3]

game_finder = leaguegamefinder.LeagueGameFinder(
    date_from_nullable=game_date,
    date_to_nullable=game_date
)
games_df = game_finder.get_data_frames()[0]

match_rows = games_df[
    games_df['MATCHUP'].str.contains(team_1) & 
    games_df['MATCHUP'].str.contains(team_2)
]

if match_rows.empty:
    print(json.dumps({"error": "Match non trouvé"}))
    sys.exit(1)

game_id = match_rows['GAME_ID'].values[0]

boxscore = boxscoretraditionalv3.BoxScoreTraditionalV3(game_id=game_id)
player_stats_df = boxscore.get_data_frames()[0]

# Liste élargie des colonnes statistiques
columns = [
    'teamTricode', 'firstName', 'familyName', 'minutes', 
    'points', 'reboundsTotal', 'assists', 
    'steals', 'blocks', 'turnovers','foulsPersonal', 
    'fieldGoalsMade', 'fieldGoalsAttempted', 
    'threePointersMade', 'threePointersAttempted', 
    'freeThrowsMade', 'freeThrowsAttempted', 
    'plusMinusPoints'
]

result_df = player_stats_df[columns]
print(result_df.to_json(orient='records'))