\idZddlZddlZddlZddlmZddlmZddlZddl Zddl Z ejjddZ dZedZd d d d d ddddddddd ZdZdZdZedk(rxeej,dkDrej,dndZedk(reyeevr eeeeyedeeddj3ej5yy) zFetch odds from The Odds API for sports not covered by BallDontLie. Merges data into the existing historical files, enriching matching games. N)datetime)Path ODDS_API_KEY 051d1c55f6a354dca3198465f4c27df1zhttps://api.the-odds-api.com/v4z&/var/www/html/eventheodds/data/betting baseball_mlb soccer_eplsoccer_germany_bundesligasoccer_italy_serie_asoccer_france_ligue_onesoccer_spain_la_ligasoccer_uefa_champs_leaguebasketball_nbaamericanfootball_nfl icehockey_nhlbasketball_ncaabbasketball_wnbaamericanfootball_ncaaf) mlbepl bundesligaseriealigue1laligauclnbanflnhlncaabwnbancaafc|sy|j}d|vryd|vryd|vryd|vry d |vry |j}|r|d S|S) z!Normalize team name for matching.z trail blazersblazersz maple leafsleafsz blue jaysjayszred soxsoxz white sox)lowersplit)namenwordss 3/var/www/html/eventheodds/scripts/fetch_odds_api.pynormalize_teamr.#sa  A!I'aA~ea GGIE59$1$c t|dzz }g}tjdd|jr* t|5}t j |}dddi}t|D]T\}}|jdddd }t|jd xs|jd } |sK| sN|||| f<Vtd |d td} td|jd tjj!| d5} t j"| j%j'} ddd std|ytdt5| d|d}d}| D]}|ddd }|d }t|}|j||f}d}|||}n:i}d}d}d}d}|jdgD]}|d}i}|jdgD]}|ddk(r7|d D].}|d!|d k(r|d"|d#<||d"}|d"|d$<|*|d"}0B|dd%k(r?|d D]6}|d!|d k(s|jd&|d'<|&|jd&}8|dd(k(s|d D]3}|d!d)k(s |jd&|d*<|#|jd&}5|s|||<|sO|jd+ijd,}|jd-d.} | r|d/vs||||r| nd|d0|d1|d+<d|d-<|d2z }|dkDrNt|d35}t j6||d45dddt|jd6|d7|St|jd8|S#1swYExYw#tj $rtd|dg}YowxYw#1swYxYw#tj(j*$r2} td|d| j,d| j.Yd} ~ yd} ~ wt0$r$} td|dt3| Yd} ~ yd} ~ wwxYw#1swY xYw)9z.Fetch odds for a specific sport key and merge.z_historical.jsonT)parentsexist_okNzWarning: Could not decode z, starting fresh.dater" homeTeam home_teamz/sports/z /odds?apiKey=z:®ions=us&markets=h2h,spreads,totals&oddsFormat=americanz Fetching z odds from The Odds API...)timeoutzHTTP Error fetching z: z - rzError fetching zNo active games found for zFound z games from Odds API for commence_time bookmakerskeymarketsh2houtcomesr*pricehome_mlaway_mlspreadspointspreadtotalsOvertotaloddssource hasRealOddsF)noneunknownNz the-odds-api) moneylineHome moneylineAway spreadHome spreadAway totalLinerI sportsbooksw)indentz : Updated z games with new odds.z%: No existing games required updates.)DATA_DIRmkdirexistsopenjsonloadJSONDecodeErrorprint enumerategetr.BASE_URLAPI_KEYupperurllibrequesturlopenloadsreaddecodeerror HTTPErrorcodereason Exceptionstrlendump)! sport_key our_sport data_fileexisting_gamesfgame_mapigamedhurlresp odds_datae updated_count new_count game_dater6 home_norm match_idx target_gamerRrDrGr@rA bookmaker book_name book_oddsmarketoutcomecurrent_sourcehas_reals! r-fetch_sport_oddsr3sI(::;IN NN4$N/ i .A!%1 .H^,!4 HHVR " % 488J/H488K3H I  HaV  !Jhykwi?y zC Iioo'((B CD ^^ # #C # 4 9 499;#5#5#78I 9  *9+67 F3y>"";I; GHMII)#2. % "9- LL)Y!78   (3K  ,3 3I!%(II#-- 26 K%=E)#)*#5K"6?d;.??3:73CIi0&'':J3:73CIi0&'':J KE]i/#)*#5M"6?d;.??29++g2FIh/%~ G8LvME]h.#)*#5K"6?f418W1EIg.$}gkk'6JeK K()2 I&3 36 %488B??=%8 >-FF!(!($)/vgT"(*#K *.K & Q MSIVq )S ! 3Q IIna 2 3 "#:m_rs   **..)K L , 8 9  -$'$ &  !    %  % BH z"388}q0 eIE! i 9-y9  {+, "499Y^^-=#>"?@Ar/