Spaces:
Sleeping
Sleeping
Commit History
-
Card Lab: fix pitcher selector + internal image system + remove upload
- get_card_lab_pitchers(): replace sparse pife-only JOIN with COALESCE batter cross-ref subquery so DH-era pitchers resolve via shared MLBAM ID namespace; MLB Stats API name_map fills any remaining unknowns; returns (pitchers, meta) tuple with db/api/unknown resolution counts - get_batter_mlbam_id(): new helper for hitter MLBAM ID lookup by name - player_assets.py (new): 3-layer image resolver (Kasper local asset → MLB headshot fallback → None/silhouette); fetch_mlb_player_name_map() bulk-fetches season roster from public MLB Stats API - card_lab_page.py: remove file uploader entirely; wire auto-image via _cached_player_image(mlbam_id); add Debug expander with pitcher count, source, db/api/unknown counts, first 20 names, spot checks for Skubal/ Gray/Liberatore/Leahy/Sheehan; re-enable hitter cache @st.cache_data; apply name_map post-processing after cached pitcher SQL query - poster_renderer.py: change "UPLOAD PLAYER PHOTO" placeholder to "NO IMAGE" - assets/players/:…6735616