tmi4dZddlZddlZddlmZmZmZddlZidddgddd gd d d gd ddgdddgdgddgddddgdddgdgddd d!gd"d#d$gd%d&d'gd(d)d*gd+d,d-gd.d/d0gd1d2d3gid4gd5d6gd7d8gd9d:d;dd?gd@gdAdBdCdDgdEgdFdGdHdIgdJgdKdLdMdNgdOgdPdQgdRdSdTdUgdVdWdXgdYddZgd[d\d]gid^gd_d`gdadbgdcddgdedfgdgdhdidjgdkgdldmdndogdpdqdrgdsgdtdudvdwgdxgdydzgd{d|gd}d~gddddgdgdidddgdgddgddddgdddgdddgdgddgddddgdgddgddddgdgddddgdddgdd\dgdddrgidddgdddgdddgddidgdddgdddgdddgdd dgdd#dgdgd¢dddgdddgdd&dgdddgdd/dgddvdgdgdӢidddgdddgdddgdddgdddgdgddddgdgddddgdgddddgdgddddgdddgdddgdddgdddggdddgddgddgddgddgddggdgd d d ggd d dggdddgddgdZdZdZ dZ ddZ dZ e dk(re yy(u Sync GameOdds → SportsGame Copies best available odds from GameOdds table into SportsGame embedded fields Run: Every 30 minutes (after scrape_odds_api.py) N)datetimetimezone timedeltaz atlanta hawksatlhawkszboston celticsboscelticsz brooklyn netsbknnetszcharlotte hornetschahornetsz chicago bullschibullszcleveland cavaliers)cle cavalierscavszdallas mavericks)dal mavericksmavszdenver nuggetsdennuggetszdetroit pistonsdetpistonszgolden state warriors)gswgswarriorszhouston rocketshourocketszindiana pacersindpacerszlos angeles clipperslacclipperszlos angeles lakerslallakerszmemphis grizzliesmem grizzliesz miami heatmiaheatzmilwaukee bucksmilbuckszminnesota timberwolves)min timberwolveswolvesznew orleans pelicans)nopnopelicansznew york knicks)nyknyknickszoklahoma city thunderokcthunderz orlando magicorlmagiczphiladelphia 76ers)phi76erssixersz phoenix sunsphxsunszportland trail blazers)porblazers trailblazerszsacramento kingssackingszsan antonio spurs)sassaspursztoronto raptorstorraptorsz utah jazz)utautahjazzzwashington wizards)waswshwizardsz anaheim ducksanaduckszarizona coyotesaricoyotesz boston bruinsbruinszbuffalo sabresbufsabreszcalgary flames)cgycalflameszcarolina hurricanes)car hurricanescaneszchicago blackhawks)r blackhawksrzcolorado avalanche)col avalancheavszcolumbus blue jackets)cbj bluejacketsjacketsz dallas starsrstarszdetroit red wings)rredwingswingszedmonton oilersedmoilerszflorida panthersflapantherszlos angeles kings)laklarAzminnesota wildr+wildzmontreal canadiens)mtl canadienshabsznashville predators)nsh predatorspredsznew jersey devils)njdnjdevilsznew york islanders)nyi islandersislesznew york rangersnyrrangerszottawa senators)ottsenatorssenszphiladelphia flyersr8flyerszpittsburgh penguins)pitpenguinspenszsan jose sharks)sjssjsharkszseattle krakenseakrakenzst louis bluesstlblueszst. louis bluesztampa bay lightning)tbltb lightningboltsztoronto maple leafs)rE mapleleafsleafszvancouver canucksvancanuckszvegas golden knights)vgkvegas goldenknightsknightszwashington capitals)rKrJcapitalscapsz winnipeg jetswpgjetszarizona cardinals)rO cardinalscardszatlanta falconsfalconszbaltimore ravensbalravensz buffalo billsbillszcarolina panthersrWz chicago bearsbearszcincinnati bengalscinbengalszcleveland brownsrbrownszdallas cowboyscowboyszdenver broncosbroncosz detroit lionslionszgreen bay packersgbpackerszhouston texanstexanszindianapolis coltscoltszjacksonville jaguars)jaxjaguarsjagszkansas city chiefskcchiefszlas vegas raiderslvraiderszlos angeles chargerschargerszlos angeles ramslarramszmiami dolphinsdolphinszminnesota vikingsvikingsznew england patriots)nepatriotspatsznew orleans saintsr/saintsznew york giantsnyggiantsz new york jetsnyjzphiladelphia eagleseagleszpittsburgh steelersr}steelerszsan francisco 49ers)sf49ersninerszseattle seahawksseahawksztampa bay buccaneers)r buccaneersbucsztennessee titanstentitanszwashington commanders)rJrK commandersarsenalarsz aston villa)avl astonvillavilla bournemouthbou brentfordbrezbrighton and hove albionbhabrightonburnleyburchelseache)cry crystalpalacepalaceeveevertonfulfulhamleeleedslei leicesterliv liverpoollutluton)mcimancitycity)munmanutdunitednew newcastle)nfo nottinghamforestshu sheffield)tot tottenhamrDwhuwesthamwolr-)zcrystal palacerrz leeds unitedzleicester cityrz luton townzmanchester cityzmanchester unitedznewcastle unitedznottingham forestzsheffield unitedztottenham hotspurzwest ham unitedzwolverhampton wandererscx|sy|jj}tjdd|}|tvr t|dStj D]/\}}||vr|dcS|j d}||k(s*|dcSt|dkr|S|j }|r|dS|S)z0Extract normalized team identifier for matching.z\s+(fc|sc|cf|afc|united|city)$r)lowerstripresub TEAM_ALIASESitemssplitlen)namen full_namealiasesnicknamewordss A/var/www/html/eventheodds/scripts/sync_game_odds_to_sportsgame.pynormalize_team_namer s  A 0"a8A LAq!!+002 7 <1: ??$R( =1:   1v{ GGIE59$1$ct|}t|}||k(ry|r|jnd}|r|jnd}||vs||vryy)z/Check if two team names refer to the same team.TrF)r r)team1team2n1n2t1_lowert2_lowers r teams_matchrsQ U #B U #B Rx %u{{}2H %u{{}2H X~x r cdtjjtjjtddg}|D]s} t |d5}|D]U}|j ds|jdddjjdd ccd d d cS d d d utjjd d jdd S#1swY=xYw#t$rYwxYw) z"Load database URL from environmentz/var/www/html/eventheodds/.envz..z.envrzSPORTS_DATABASE_URL==?rNSPORTS_DATABASE_URLr) ospathjoindirname__file__open startswithrrFileNotFoundErrorenvironget) env_pathsenv_pathflines r load_db_urlr's )  RWW__X.f=I h$ KKD'=>#zz#q1!4::<BB3GJJ K KK K ::>>/ 4 : :3 ? BB  K K!   s< C;C//6C/% C;1C/3C;/C8 4C;; DDc |j}ddddd}td|jd|d|d|j}tdt |di}|D]}|\ }} } } } } }}}}}|t | t | t | f}||vr d d d d ||<| d k(r||d  ||f||d <W| d k(r||d  |||f||d <p| d k(sv||d |||d <tdt |dtd|jd|d|d|j}tdt |d|D]}|\}}} }}|dxxdz cc<t |}t |}|t | ||f}|j|}|sd|t | ||f}|j|}|rB|d r|d d|d df|d <|d r%|d dr |d d nd |d d|d df|d <|s|dxxdz cc<d x}}|d r|d \}}d x}x} }!|d r|d d}|d }"|s|s|"s |jd||||r| nd |"|f|dxxdz cc<"|j|j|S#t$r9}#td|d|#|dxxdz cc<|jYd }#~#d }#~#wwxYw)zu Sync odds from GameOdds to SportsGame for games within date range. Uses intelligent team name matching. r)matchedupdatederrorscheckedzLoading GameOdds data...z SELECT league, DATE("gameDate") as gd, "homeTeam", "awayTeam", "bookmaker", "market", "lineValue", "homeOdds", "awayOdds", "overOdds", "underOdds" FROM "GameOdds" WHERE "gameDate" >= NOW() - INTERVAL 'z3 days' AND "gameDate" <= NOW() + INTERVAL 'zQ days' ORDER BY CASE WHEN "bookmaker" = 'pinnacle' THEN 0 ELSE 1 END zLoaded z odds recordsN)h2hspreadstotalsr-r.r/z Grouped into z unique gamesz'Finding SportsGame records to update...z SELECT id, league, DATE("gameDate") as gd, "homeTeam", "awayTeam" FROM "SportsGame" WHERE "gameDate" >= NOW() - INTERVAL 'zN days' AND ("moneylineHome" IS NULL OR "oddsSource" = 'odds-api') zFound z games to checkr,rr)aT UPDATE "SportsGame" SET "moneylineHome" = COALESCE(%s, "moneylineHome"), "moneylineAway" = COALESCE(%s, "moneylineAway"), "spreadHome" = COALESCE(%s, "spreadHome"), "spreadAway" = COALESCE(%s, "spreadAway"), "total" = COALESCE(%s, "total"), "oddsSource" = 'odds-api', "oddsUpdatedAt" = NOW(), "updatedAt" = NOW() WHERE id = %s r*z Error updating game z: r+) cursorprintexecutefetchallrstrr r" Exceptionrollbackcommitclose)$conn lookback_dayslookahead_dayscurstats odds_data odds_by_gamerowleaguegdhomeawaybookmarketr&h_oddsa_oddsover_ounder_okeygamesgamegame_id home_team away_team norm_home norm_awayodds key_swappedml_homeml_awaysp_valsp_homesp_awaytotales$ r sync_oddsr]s ++-Ca1 CE $&KK .*+ I GC N#= 12L /VYSD$fdFFFGs2w 3D 9;Nt;TU l "(, NL  U?|C07?(.'7L e $ y \#%6y%A%I,0&&+AL i ( x L$5h$?$G*.L h ' / M#l+,M :; 35KK . *+ LLNE F3u:,o ./> 481Y  iA( 2 ' 2 s2w 95$!3r7IyAK##K0D;#';q>4;q>"BDK ?>B9oa>PY(:':VZ'+Iq'94 ?1;M'ODO  iA! ' ;#E{ GW%)))7  ?)_Q'FX f  WvVG4 $i A% u> @ KKMIIK L .wir!=>h1$  s *J K#.KKctdtdtdtjtjj tdt }|s tdy tj|}t|}tddtdtd|dd td |d d td |d d td|dtd|jy#t$r,}td|ddl }|jYd}~yd}~wwxYw)Nz<============================================================uSYNC GAMEODDS → SPORTSGAMEzTime: z$ERROR: SPORTS_DATABASE_URL not found zRESULTS:z Checked: r,z gamesz Matched: r)z Updated: r*z Errors: r+zERROR: r)r2rnowrutc isoformatr'psycopg2connectr]r9r6 traceback print_exc)db_urlr:r>r\res rmainrh>s$ (O () F8<< -779: ;< (O ]F  45'$ 6(m  U9-.f56 U9-.f56 U9-.f56 U8_-./ h  sms8BD E "EE __main__)rj)__doc__rrcrrrrrr rr'r]rh__name__r rrns  22 zeW%zui(zeV_ z %+ z eW% z7z4zui(zy)z6zy)zuh'zUJ/z5(+z %-!z"5&/#z$w'%z&?'z(5)z*.+z,eY/-z.eW%/z041z2UFO3z4@5z6(7z8/9z:y);z<(=z>3?zBeW%CzDy)EzFeX&GzHuh'IzJ.KzL9MzN8OzP5QzR>SzTUG$UzV5WzXx(YzZ +[z\/]z^ufo_z`6azb8czd0ezf7gzh *izj2kzlE8,mzn6ozp.qzruh'sztug&uzvw'wzx>yzz9{z|%+}z~Hz@=AzBeV_CzF6GzHy)IzJ)KzLeW%MzN%,OzPeW%QzR5),SzT)UzVui(WzXui(YzZeW%[z\$ *]z^uh'_z`5'*azb6czd4*ezf$ *gzhUJ/izjkzluj)mzn%+ozp6qzr4*sztx(uzveV_wzxE8,yzzE:.{z|4}z~ +z@8AzB)CzD9EzHy!IzJ1KzLE=)MzN%%OzP 3QzRy!SzTy!UzV9y!hG$k*%'"14 ,8 ,6y) %x0sz x%< C"upB zFr