foi7 dZddlZddlZddlmZmZidddddddd d d d d d d dd dd ddddddddddddddddiddddddddd dd!dd"d#d$d#d%d#d&d'd(d'd)d'd*d+d,d+d-d+d.d/d0d/id1d/d2d3d4d3d5d3d6d7d8d7d9d7d:d;dd?d@d?dAd?dBdCdDdCdEdCdFdGidHdGdIdGdJdKdLdKdMdKdNdKdOdPdQdPdRdPdSdTdUdTdVdTdWdXdYdXdZdXd[dXd\d]id^d]d_d]d`dadbdadcdadddadedfdgdfdhdfdidjdkdjdldjdmdjdndodpdodqdodrdsdsdsdtdtdtdudududvdvdvdw idxdydzdyd{dyd|dd}dd~dddddddddddddddddddddddidddddddddddddd#dd#dd'dd'dddddddd/dd/dd3dd3idd3dddddddddddddddddddd7dd7ddddddCddCddKiddKddddddddddddddddddddaddaddƓddƓddƓddʓddʓdddddddddddddvdvdϜiddѓddѓddѓddyddydd dd ddddddۓddۓddۓddddddddddidddddddddddddddddddd'dd'ddddddddddddidddpdddKddKddddddddddddddddddddddd d d d id d dd ddddddddddaddaddƓddƓddƓdddddddd̓dd̓dd id!d d"d d#d d$d%d&d%d'd%d(dtd)dtd*dtd+dud,dud-d.d/d.d0d.d1d2d3d2d4d2d2d5d5d5d6d6d6d7d8Zd9Zd:Zd;Ze d>sCII#NqQQ R R R R ::>>/ 4 : :3 ? BB  R R    s: B?B3AB3- B?7B39B?3B<8B?? C  C ctdtdtdtjtjj tdt }tj|}|j}ddd}td|jdi}|jD]F}|\ }}}} } } } } }t| |}t| |}|t|||f}|| du| du| du|d||<Htd t|d td |jd |j}td t|dg}g}|D]}|\ }}}} } }}}}}}| r| st| |}t| |}|t|||f}|j|}|s0|t|||f}|j|}|r|r| nd}|r| nd}|s|!|ds|j!||r| nd|df|ds|dr||n|}||j!||r| nd|dftd|r8|j#d|t||d<tdt|d|r8|j#d|t||d<tdt|d|j%td|jd|j&|d<td|j&d|j%td|jd td!d"d#d$d%d&d$d'd(d$d)d(td!d*d$d*d$d+d$d+|jD]O}|\}}} } |dkDrd,| z|z d-d.} d,| z|z d-d.}!nd/x} }!td!|d#d$|d&d$| d&d0| d1d2| d&d0|!d1d3 Q|j)|j)td4td5td6|dtd7|dtd8|jddtd|S)9Nz<============================================================z-BACKFILL: Opening/Closing Lines from GameOddszTime: r)openingclosingz( [1] Building SportsGame lookup index...a SELECT id, league, DATE("gameDate"), "homeTeam", "awayTeam", "homeScore", "openingSpreadHome", "closingSpreadHome", "spreadHome" FROM "SportsGame" WHERE "gameDate" >= '2024-10-01' AND "spreadHome" IS NOT NULL )id has_opening has_closing completedcurrent_spreadz Indexed z SportsGame records with spreadsz2 [2] Processing GameOdds with opening line data...a SELECT DISTINCT ON (league, "gameId") league, "gameId", DATE("gameDate") as gd, "homeTeam", "awayTeam", "openingLineValue", "openingHomeOdds", "openingAwayOdds", "lineValue", "homeOdds", "awayOdds" FROM "GameOdds" WHERE market = 'spreads' AND "gameDate" IS NOT NULL AND "gameDate" >= '2024-10-01' ORDER BY league, "gameId", "fetchedAt" DESC z Found z unique games in GameOddsr r rr z [3] Applying updates...z UPDATE "SportsGame" SET "openingSpreadHome" = %s, "openingSpreadAway" = %s, "updatedAt" = NOW() WHERE id = %s r z Set z opening lines from GameOddsz UPDATE "SportsGame" SET "closingSpreadHome" = %s, "closingSpreadAway" = %s, "updatedAt" = NOW() WHERE id = %s r z closing lines from GameOddszF [4] Setting closing lines from current spreads for remaining games...a UPDATE "SportsGame" SET "closingSpreadHome" = "spreadHome", "closingSpreadAway" = "spreadAway", "closingTotal" = "total", "closingMoneylineHome" = "moneylineHome", "closingMoneylineAway" = "moneylineAway", "updatedAt" = NOW() WHERE "homeScore" IS NOT NULL AND "closingSpreadHome" IS NULL AND "spreadHome" IS NOT NULL AND "gameDate" >= '2024-10-01' closing_from_currentz# closing lines from current spreadsz [5] Coverage Report:a SELECT league, COUNT(*) FILTER (WHERE "homeScore" IS NOT NULL) as completed, COUNT(*) FILTER (WHERE "openingSpreadHome" IS NOT NULL) as has_opening, COUNT(*) FILTER (WHERE "closingSpreadHome" IS NOT NULL) as has_closing FROM "SportsGame" WHERE "gameDate" >= '2024-10-01' AND league IN ('nba', 'nfl', 'nhl', 'ncaab', 'epl', 'mma') GROUP BY league ORDER BY completed DESC z Leaguez<10 Completedz>10Openingz>15Closingz ----------z---------------dz.1f%z0%z (z>5z) )z= ============================================================zBackfill Complete:z Opening lines set: z Closing lines set: z Closing from current: )printrnowrutc isoformatrpsycopg2connectcursorexecutefetchallrstrrrappend executemanycommitrowcountclose)"db_urlconncurstats sg_lookuprowsg_idrgdhomeawayscorer r spread home_norm away_normkeygameoddsupdates_openingupdates_closinggame_idopen_val open_home open_awaycurr_val curr_home curr_awaysgkey2 close_valropen_pct close_pcts" r run_backfillrFs  (O 9: F8<< -779: ;< (O ]F   F #D ++-Ca (E 56KK I||~  ILFvr4ugw"40 "40 s2w 95"$."$.d*$  #   Js9~&&F GH ?@KK   ||~H HS]O#< =>OO ajmgT49iS\^g4 "40 "40 s2w 95 ]]3 CGY :Dt$B(0H9d(0H9d   =(9  " "H8xirRVx#X Y k?2m#4$,$8hI$&& I:PTVXY]V^'_`A aD %'     /i s?+,,HIJ     /i s?+,,HIJKKM STKK   %(LLE ! F3<<. C DEKKM "#KK    BxnAk#.a #a # OP Bvhaxq& 23||~n.1+ 7G q=g+i/4A6Hw;y05Q7I#' 'Hy 6#,a #a}Bxm2gVY]Z\]fgi\jjklmnIIKJJL /   !% "2!3 45 !% "2!3 45 $UYY/Eq%I$J KL (O Lr__main__) __doc__rrrrrrrrF__name__rrrKs   '    ' 095 % !*E 3;U   !' 0:5  U  %.u  7B5      !(   1:5   u   '25   ;A%   JUV[   E $/ 8>u GOPU  % "+E 4u   )3E u  % "*5 3u# $ !%% $*8% $AI%% $R]^c% & ' &(25' &;H' ( 5) (#+E) (4>u) * + *)25+ *;J5+ *SXY^+ , - ,!(- ,1:5- . e/ .&-e/ .6>u/ .GUV[/ 0 1 0 &u1 0/81 2 !%3 2*9%3 2BKE3 2T^_d3 4 E5 4$+E5 44@5 6 U7 6.35 UuE5#U= @! U! $/! 8A5! 5! "+U!  E! $,U! 5@!   ! !( ! 1:5 !  U !  %/ !  8B5 !   !  !( !  e! &/! 8DU!  E! $,U!  %! "+E!  %! "+E!  ! !(!  T! $-d! 5@!  %! "*5!  e! &-e! 6DU!  ! (1%! :H!  d!!  %-d!!  5B4!! " T#! "$-d#! "5@#! $ %! $(25%! & E'! &$*5'! ( %)! (",U)! * U+! *%.u+! , -! ,'1$-! ,9Ft-! . d/! .%-d/! 0 51! 0#+E1! 2 3! 2!'3! 4 u5! 4'/5! 6 u7! 6'1%7! 6:Fu7! 8 t9! 8&-d9! 8FJUY!u $D$UY!U!&eA! D" "  '" 095" 5" "+U"  " !)%"  % " "*5 "  % "  "*5 "  3u"  E" $.u" 7@"  U" %,U"  %" "("  e!"  &1%!"  :@!"  ISTY!" " u#" "'25#" ";B5#" "KVW\#" $ U%" $%-e%" $6B5%" & e'" &&1%'" ( E)" ($-e)" * 5+" *#-e+" *6u1" 2 %3" 2"*53" 4 55" 4#*55" 43CE5" 4L_`e5" 6 u7" 6'257" 6;B57" 8 u9" 8'4U9" 8=DU9" : E;" :$*5;" < U=" <%.u=" <7B5=" > ?" >(8?" >AJ5?" >\a$%5C" Gf R ! ChV zNr