Wi%~dZddlZddlZddlZddlZddlmZmZmZdZdZ dZ ddd d d d d ddddddd Z dZ ddZ edk(rxejdZej#deddej'Zej*j-dDcgc]}|j/c}Ze eyycc}w) z Capture Live/In-Game Odds from The Odds API Polls The Odds API for live games and captures in-play odds. Falls back when SGO is unavailable. Run: Every 5 minutes during game hours N)datetimetimezone timedeltazhttps://api.the-odds-api.com/v4cd} t|d5}|D]b}|jds|jdddjjdjddccdddS dddt j jd d jddS#1swY;xYw#t$rYIwxYw) N/var/www/html/eventheodds/.envrzSPORTS_DATABASE_URL=="?rSPORTS_DATABASE_URLopen startswithsplitstripFileNotFoundErrorosenvirongetenv_pathflines 'scripts/capture_live_odds_theoddsapi.py load_db_urlrs/H (C  RA R??#9:::c1-a0668>>sCII#NqQQ R R R R ::>>/ 4 : :3 ? BB  R R    s: B?B3AB3- B?7B39B?3B<8B?? C  C c4d} t|d5}|D]A}|jds|jdddjccdddS dddt j jdS#1swY(xYw#t$rY6wxYw)NrrzTHE_ODDS_API_KEY=r r THE_ODDS_API_KEYrrs rload_odds_api_keyr s/H (C  9A 9??#67::c1-a06688 9 9 9 9 ::>>, --  9 9    s9 B A?$A? B A?B ?BB BBbasketball_nbaamericanfootball_nfl icehockey_nhl baseball_mlbbasketball_ncaabamericanfootball_ncaafbasketball_wnba soccer_eplsoccer_germany_bundesligasoccer_italy_serie_asoccer_spain_la_ligasoccer_france_ligue_onesoccer_usa_mls) nbanflnhlmlbncaabncaafwnbaepl bundesligaseriealaligaligue1mlsctj|}|sgS|ddddd} tjtd|d|d }|jd k(rt d |gS|jd k(rt d |gS|jdk7rt d|jd|gS|j }tjtj}g}|D]h}|jd} | s tj| jdd} |tdz | cxkr|krnn|j|j||fS#YsxYw#t$r} t d|d| ggfcYd} ~ Sd} ~ wwxYw)zGet live odds from The Odds APIuszspreads,totals,h2hamericanr)apiKeyregionsmarkets oddsFormateventIdsz/sports/z/odds)paramstimeoutiz Invalid API key for iz No events for z API returned z for commence_timeZ+00:00)hoursz Error fetching : N) LEAGUE_MAPrrequests ODDS_API_BASE status_codeprintjsonrnowrutc fromisoformatreplacerappend Exception) api_keyleaguesportrDrespeventsrS live_eventseventcommence commence_dtes r get_live_oddsrc=s NN6 "E  '  F'||oXeWE 2    s " *6(3 4I   s " $VH- .I   s " OD$4$4#5U6(C DIll8<<(  Eyy1H"*"8"89I9I#x9X"YKYQ//+CC#**51 F""  !&A3/02v sJAE$E+E/A E>AEEEE F%E?9F?Fc|gd}tdtdtdtjtjj tddj |tdt}t}|s tdytj|}|j}|jd|jd |jd }d }|D]}t||}|s|\} } td |jd t!| d t!| d|t!| z }| D]W} | j#d} | j#dd} | j#dd}| j#d}d}|r& tj$|j'dd}| j#dg}|ddD]}|j#dd}dx}}dx}}d}dx}}dx}}|j#dgD]f}|j#d}|j#dg}|dk(rv|D]p} | j#d| k(r#| j#d}| j#d}:| j#d|k(sO| j#d}| j#d}r|d k(rf|D]_} | j#dd!k(r#| j#d}| j#d}:| j#dd"k(sO| j#d}a |d#k(s|D]N} | j#d| k(r| j#d})| j#d|k(s>| j#d}Pi|jd$|| || |||||||||||f|d%z }Z|jtd dtd&|d'|d(|jd)td*|j)D]}!td+|!d d |!d%td|j+|j+y#YxYw),N)r.r/r0r1r2r3z<============================================================z CAPTURE LIVE ODDS (The Odds API)zTime: z Leagues: z, zERROR: THE_ODDS_API_KEY not seta CREATE TABLE IF NOT EXISTS "LiveOdds" ( id SERIAL PRIMARY KEY, league VARCHAR(20), "gameId" INTEGER, "externalGameId" VARCHAR(100), "gameDate" TIMESTAMP, "homeTeam" VARCHAR(100), "awayTeam" VARCHAR(100), "gameStatus" VARCHAR(20), "gameTime" VARCHAR(20), "homeScoreLive" INTEGER, "awayScoreLive" INTEGER, "liveSpreadHome" DOUBLE PRECISION, "liveSpreadAway" DOUBLE PRECISION, "liveSpreadHomeOdds" INTEGER, "liveSpreadAwayOdds" INTEGER, "liveTotal" DOUBLE PRECISION, "liveTotalOverOdds" INTEGER, "liveTotalUnderOdds" INTEGER, "liveMoneylineHome" INTEGER, "liveMoneylineAway" INTEGER, "capturedAt" TIMESTAMP DEFAULT NOW(), source VARCHAR(50), bookmaker VARCHAR(50), raw JSONB, "createdAt" TIMESTAMP DEFAULT NOW() ) zy CREATE INDEX IF NOT EXISTS idx_live_odds_game ON "LiveOdds"(league, "externalGameId", "capturedAt") r rLz live, z total eventsid home_teamr away_teamrGrHrI bookmakerskeyunknownr@outcomesspreadsnamepointpricetotalsOverUnderh2haI INSERT INTO "LiveOdds" ( league, "externalGameId", "gameDate", "homeTeam", "awayTeam", "liveSpreadHome", "liveSpreadAway", "liveSpreadHomeOdds", "liveSpreadAwayOdds", "liveTotal", "liveTotalOverOdds", "liveTotalUnderOdds", "liveMoneylineHome", "liveMoneylineAway", "capturedAt", source, bookmaker ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, NOW(), 'theoddsapi', %s) r z RESULTS: z live games, z odds capturedz SELECT league, COUNT(*) FROM "LiveOdds" WHERE "capturedAt" > NOW() - INTERVAL '1 hour' GROUP BY league z Recent captures by league:z )rQrrSrrT isoformatjoinrr psycopg2connectcursorexecutecommitrcupperlenrrUrVfetchallclose)"leaguesdb_urlrYconncurtotal_captured total_liverZresultr^ all_eventsr_event_idhomeawayr`raribook book_name spread_home spread_awayspread_home_oddsspread_away_odds total_linetotal_over_oddstotal_under_oddsml_homeml_awaymarket market_keyrmoutcomerows" r capture_oddsrus@ (O ,- F8<< -779: ;< Idii() *+ (O ]F!G  /0   F #D ++-CKK :KK  KKMNJN$w/ "( Z 6<<>""S%5$6gc*o=Nm\]c+&&  D $EyyH99["-D99["-Dyy1HK"*"8"89I9I#x9X"YK <4J"2A5 $ HHUI6 ,00 k6:: #3! 599"2$(('"hhy"5?F!'E!2J%zz*b9H!Y.'/HG&{{62d:.5kk'.B 3:;;w3G 0!(V!4!<.5kk'.B 3:;;w3G 0 H$x/'/HG&{{62f<-4[[-A 29++g2F!(V!4!?3:;;w3G 0 H$u,'/?G&{{62d:*1++g*>!(V!4!<*1++g*> ?-?: Hk4.>@P1AWi !#k5 $D $N$` KKM Bvh- Ij\~.>n MNKK  ()||~' 3q6("SVH%&' (OIIKJJL_s -%Q  Q%__main__z#Capture Live Odds from The Odds API) descriptionz --leaguesznba,nfl,nhl,mlb,ncaab,ncaafz>Comma-separated leagues (default: nba,nfl,nhl,mlb,ncaab,ncaaf))typedefaulthelp,)N)__doc__argparserNrxrrrrrOrr rMrcr__name__ArgumentParserparser add_argumentstr parse_argsargsrrr)ls0rrs 221  C .  !    %  -$$'  "5p^B z $X $ $1V WF  #7T]_    D"&,,"4"4S"9:Qqwwy:G  ;sB: