Easy Money

{
  "game_id": "0042500172",
  "gtu_refetched": true,
  "gtu_refetch_trace": {
    "attempted": true,
    "trigger_reason": "game_time_utc IS NULL",
    "game_date": "2026-04-21",
    "game_time_utc_before": null,
    "source_1_attempted": true,
    "source_1_found_game": true,
    "source_1_value": "2026-04-22T02:30:00Z",
    "source_1_error": null,
    "source_2_attempted": false,
    "source_2_value": null,
    "source_2_error": null,
    "source_used": "ScoreboardV3",
    "value": "2026-04-22T02:30:00Z",
    "db_path": "/opt/render/project/src/data/nba.db",
    "rows_affected": 1,
    "update_applied": true,
    "game_time_utc_after": "2026-04-22T02:30:00Z",
    "error": null
  },
  "games_raw": {
    "game_id": "0042500172",
    "game_status_id": 3,
    "game_time_utc": "2026-04-22T02:30:00Z",
    "home_abbr": "LAL",
    "visitor_abbr": "HOU",
    "home_pts": 101,
    "visitor_pts": 94
  },
  "playoff_games_raw": {
    "game_start_ms": null,
    "scheduled_start_ms": null,
    "basketball_final_ms": 1776835157000,
    "basketball_final_source": "espn_pbp_last_valid_event",
    "basketball_final_event_text": "End of Game",
    "basketball_final_period": 4,
    "basketball_final_clock": "0.0",
    "basketball_final_raw_timestamp": "2026-04-22T05:19:17Z",
    "home_team_abbr": "LAL",
    "away_team_abbr": "HOU",
    "home_score": 101,
    "away_score": 94,
    "status": "final"
  },
  "ph_agg": {
    "cnt": 724,
    "min_ts": 1776293452000,
    "max_ts": 1776837004000
  },
  "bfp": {
    "final_ms": 1776835157000,
    "source": "stored_pbp_last_wallclock_at_zero",
    "event_text": "End of Game",
    "period": 4,
    "clock": "0.0",
    "raw_timestamp": null,
    "warning": null
  },
  "bfp_called": true,
  "bfp_error": null,
  "final_branches": {
    "scores_present": true,
    "game_time_utc_present": true,
    "past_date_in_et": true,
    "status_id_is_3": true,
    "pg_status_is_final": true,
    "pg_status_is_in_progress": false,
    "pg_has_basketball_final_ms": true,
    "pg_bfm_suppressed_in_progress": false,
    "scores_past_date_fired": true,
    "scores_status3_sameday_fired": false,
    "scores_status3_no_tip_fired": false,
    "playoff_games_status_final_fired": false,
    "playoff_games_has_final_ms_fired": false,
    "midnight_et_start_detected": false,
    "midnight_et_start_corrected": false
  },
  "window": {
    "game_start_ms": 1776825000000,
    "window_start_ms": 1776821400000,
    "window_end_ms": 1776836057000,
    "basketball_final_ms": 1776835157000,
    "window_duration_min": 244
  },
  "odds_filter": {
    "raw_count": 0,
    "before_window": 0,
    "in_window": 0,
    "after_window": 0,
    "uncategorized": 0
  },
  "referee_trace": {
    "query": "game_referee_assignments JOIN referees",
    "assignments_found": 3,
    "referees_found": 3,
    "error": null
  },
  "lineup_trace": {
    "query": "lineup_state WHERE game_id = ?",
    "row_found": false,
    "is_confirmed": null,
    "telegram_first_detected_at": null,
    "first_confirmed_at": null,
    "chosen_field": null,
    "error": null,
    "note": "No row in lineup_state for this game_id"
  },
  "pbp_row_count": 470,
  "pbp_last_events": [
    {
      "id": 6749,
      "game_id": "0042500172",
      "source": "espn",
      "event_id": "401869397684",
      "sequence": 684,
      "timestamp_ms": 1776835157000,
      "raw_timestamp": "2026-04-22T05:19:17Z",
      "period": 4,
      "clock": "0.0",
      "event_type": "402",
      "event_text": "End of Game",
      "team_id": null,
      "player_id": null,
      "is_valid_in_game_event": 1,
      "raw_json": "{\"seq\": 684, \"period\": 4, \"clock\": \"0.0\", \"text\": \"End of Game\"}",
      "created_at": "2026-05-04T00:53:16Z",
      "updated_at": "2026-05-04T00:53:16Z",
      "home_score": null,
      "away_score": null
    },
    {
      "id": 6748,
      "game_id": "0042500172",
      "source": "espn",
      "event_id": "401869397683",
      "sequence": 683,
      "timestamp_ms": 1776835038000,
      "raw_timestamp": "2026-04-22T05:17:18Z",
      "period": 4,
      "clock": "0.0",
      "event_type": "412",
      "event_text": "End of the 4th Quarter",
      "team_id": null,
      "player_id": null,
      "is_valid_in_game_event": 1,
      "raw_json": "{\"seq\": 683, \"period\": 4, \"clock\": \"0.0\", \"text\": \"End of the 4th Quarter\"}",
      "created_at": "2026-05-04T00:53:16Z",
      "updated_at": "2026-05-04T00:53:16Z",
      "home_score": null,
      "away_score": null
    },
    {
      "id": 6747,
      "game_id": "0042500172",
      "source": "espn",
      "event_id": "401869397682",
      "sequence": 682,
      "timestamp_ms": 1776835025000,
      "raw_timestamp": "2026-04-22T05:17:05Z",
      "period": 4,
      "clock": "8.5",
      "event_type": "155",
      "event_text": "Rui Hachimura defensive rebound",
      "team_id": "13",
      "player_id": "4066648",
      "is_valid_in_game_event": 1,
      "raw_json": "{\"seq\": 682, \"period\": 4, \"clock\": \"8.5\", \"text\": \"Rui Hachimura defensive rebound\"}",
      "created_at": "2026-05-04T00:53:16Z",
      "updated_at": "2026-05-04T00:53:16Z",
      "home_score": null,
      "away_score": null
    },
    {
      "id": 6746,
      "game_id": "0042500172",
      "source": "espn",
      "event_id": "401869397681",
      "sequence": 681,
      "timestamp_ms": 1776835022000,
      "raw_timestamp": "2026-04-22T05:17:02Z",
      "period": 4,
      "clock": "12.3",
      "event_type": "131",
      "event_text": "Jabari Smith Jr. misses 33-foot three point pullup jump shot",
      "team_id": "10",
      "player_id": "4432639",
      "is_valid_in_game_event": 1,
      "raw_json": "{\"seq\": 681, \"period\": 4, \"clock\": \"12.3\", \"text\": \"Jabari Smith Jr. misses 33-foot three point pullup jump shot\"}",
      "created_at": "2026-05-04T00:53:16Z",
      "updated_at": "2026-05-04T00:53:16Z",
      "home_score": null,
      "away_score": null
    },
    {
      "id": 6745,
      "game_id": "0042500172",
      "source": "espn",
      "event_id": "401869397679",
      "sequence": 679,
      "timestamp_ms": 1776834996000,
      "raw_timestamp": "2026-04-22T05:16:36Z",
      "period": 4,
      "clock": "14.3",
      "event_type": "584",
      "event_text": "Reed Sheppard enters the game for Alperen Sengun",
      "team_id": "10",
      "player_id": "4711272",
      "is_valid_in_game_event": 1,
      "raw_json": "{\"seq\": 679, \"period\": 4, \"clock\": \"14.3\", \"text\": \"Reed Sheppard enters the game for Alperen Sengun\"}",
      "created_at": "2026-05-04T00:53:16Z",
      "updated_at": "2026-05-04T00:53:16Z",
      "home_score": null,
      "away_score": null
    }
  ],
  "games_write_paths": [
    {
      "id": "fetch_and_store_games",
      "file": "app/services/games.py",
      "function": "fetch_and_store_games(game_date)",
      "when": "Homepage load (today/yesterday), scheduler daily, startup warmup_games_db()",
      "source_api": "ScoreboardV3 (nba_api)",
      "writes_game_time_utc": true,
      "game_time_utc_strategy": "COALESCE(existing, new) \u2014 fills if null, never overwrites non-null",
      "can_create_null_gtu": "Only if ScoreboardV3 returns gameTimeUTC=null (rare)",
      "covers_old_games": false,
      "note": "Warmup covers today+yesterday only. Games \u22652 days old are never re-fetched by this path."
    },
    {
      "id": "sync_playoff_games",
      "file": "app/services/games.py",
      "function": "sync_playoff_games(season)",
      "when": "Rate-limited: called by playoff_analytics._sync_playoff_games_if_due() on bracket page fetch",
      "source_api": "LeagueGameFinder (nba_api)",
      "writes_game_time_utc": false,
      "game_time_utc_strategy": "NOT in INSERT column list; NOT in ON CONFLICT SET \u2014 always NULL for new rows",
      "can_create_null_gtu": true,
      "covers_old_games": true,
      "note": "LeagueGameFinder has no gameTimeUTC field. Creates complete rows (date, teams, final score) but leaves game_time_utc=NULL."
    },
    {
      "id": "fetch_and_store_historical_game",
      "file": "app/services/historical.py",
      "function": "fetch_and_store_historical_game(game_id)",
      "when": "On-demand: /games/{game_id} visited and game not yet in DB",
      "source_api": "BoxScoreSummaryV3 (nba_api) / playoff_history_db",
      "writes_game_time_utc": false,
      "game_time_utc_strategy": "NOT in INSERT column list; NOT in ON CONFLICT SET",
      "can_create_null_gtu": true,
      "covers_old_games": true,
      "note": "Bypassed if game already exists (sync_playoff_games may have created it). Does not populate game_time_utc."
    },
    {
      "id": "copy_game_to_nba_db",
      "file": "app/services/playoff_history_db.py",
      "function": "copy_game_to_nba_db(game_id)",
      "when": "Called first inside fetch_and_store_historical_game",
      "source_api": "Local playoff_history.db SQLite file",
      "writes_game_time_utc": false,
      "game_time_utc_strategy": "NOT in INSERT column list; NOT in ON CONFLICT SET",
      "can_create_null_gtu": true,
      "covers_old_games": true,
      "note": "Short-circuits the nba_api call if game is in the local history DB."
    },
    {
      "id": "boxscores_live_update",
      "file": "app/services/boxscores.py",
      "function": "fetch_and_store_live_boxscore() / store_live_period_scores()",
      "when": "During live game polling (~every 5 s while game is live)",
      "source_api": "data.nba.com live BoxScore",
      "writes_game_time_utc": false,
      "game_time_utc_strategy": "UPDATE only: game_status_id, status_text, home_pts, visitor_pts",
      "can_create_null_gtu": false,
      "covers_old_games": false,
      "note": "Never creates rows. Cannot set game_time_utc to NULL."
    },
    {
      "id": "playoff_resolve_update",
      "file": "app/main.py",
      "function": "_resolve_playoff_placeholders()",
      "when": "Homepage load when visitor/home team is still TBD",
      "source_api": "postseason_state / standings (DB-only)",
      "writes_game_time_utc": false,
      "game_time_utc_strategy": "UPDATE only: visitor/home team abbr, name, team_id",
      "can_create_null_gtu": false,
      "covers_old_games": false,
      "note": "Only sets team identification fields. Cannot affect game_time_utc."
    }
  ],
  "likely_games_write_source": {
    "source": "fetch_and_store_games",
    "reason": "game_time_utc is populated. This field is ONLY written by fetch_and_store_games() (ScoreboardV3). All other write paths omit it from their INSERT/UPDATE.",
    "confidence": "High",
    "writes_game_time_utc": true
  },
  "field_write_coverage": {
    "game_time_utc": {
      "written_by": [
        "fetch_and_store_games"
      ],
      "not_written_by": [
        "sync_playoff_games",
        "fetch_and_store_historical_game",
        "copy_game_to_nba_db",
        "boxscores_live_update",
        "playoff_resolve_update"
      ],
      "strategy": "COALESCE \u2014 set once on first non-null insert; never overwritten after that",
      "null_risk": "High: only fetch_and_store_games writes it, and it only runs for today/yesterday"
    },
    "game_status_id": {
      "written_by": [
        "fetch_and_store_games",
        "sync_playoff_games",
        "fetch_and_store_historical_game",
        "copy_game_to_nba_db",
        "boxscores_live_update"
      ],
      "not_written_by": [
        "playoff_resolve_update"
      ],
      "strategy": "MAX(existing, new) in fetch_and_store_games; direct set in sync/historical/live",
      "null_risk": "Low: all major paths write it"
    },
    "home_pts / visitor_pts": {
      "written_by": [
        "fetch_and_store_games",
        "sync_playoff_games",
        "fetch_and_store_historical_game",
        "copy_game_to_nba_db",
        "boxscores_live_update"
      ],
      "not_written_by": [
        "playoff_resolve_update"
      ],
      "strategy": "Varies: MAX for final (sync), COALESCE for live, direct for historical",
      "null_risk": "Low: most paths populate scores"
    },
    "game_date": {
      "written_by": [
        "fetch_and_store_games",
        "sync_playoff_games",
        "fetch_and_store_historical_game",
        "copy_game_to_nba_db"
      ],
      "not_written_by": [
        "boxscores_live_update",
        "playoff_resolve_update"
      ],
      "strategy": "Set on INSERT; ON CONFLICT generally does not update it",
      "null_risk": "Low: all INSERT paths include game_date"
    }
  }
}