:Ki!tdZddlZddlZddlZddlZddlZddlZddlmZmZm Z ejjdejjejjeddlmZdZdZddd d d d d d d ddd ddd d dd dZhdZdZdZdZddZdZedk(reyy)z Fetch TV Broadcast Information from ESPN Captures which networks are broadcasting each game (ESPN, TNT, ABC, etc.) ESPN scoreboard includes broadcasts in competitions[0].broadcasts Run: Daily before games N)datetimetimezone timedelta)normalize_to_fullz-https://site.api.espn.com/apis/site/v2/sportsg333333? basketballnba)sport espn_leaguefootballnflhockeynhlbaseballmlbmens-college-basketballcollege-football)rr rrncaabncaaf>NBA TV NFL Network NHL NetworkABCCBSFOXFS1NBCTBSTNTUSAESPNESPN2NBCSNc~d} t|d5}|D]S}|jds|jdddjjddccdddS dddt j jdd jddS#1swY;xYw#t$rYIwxYw) Nz/var/www/html/eventheodds/.envrzSPORTS_DATABASE_URL==?rSPORTS_DATABASE_URL)open startswithsplitstripFileNotFoundErrorosenvironget)env_pathflines scripts/fetch_broadcast_info.py load_db_urlr6$s/H (C  GA G??#9:::c1-a0668>>sCAFF G G G G ::>>/ 4 : :3 ? BB  G G    s9 B0B$6B$ B0(B$*B0$B-)B00 B<;B<cj|jd|jd|jdy)z$Create GameBroadcast table if neededa CREATE TABLE IF NOT EXISTS "GameBroadcast" ( id BIGSERIAL PRIMARY KEY, league VARCHAR(50) NOT NULL, "gameId" BIGINT, "gameDate" TIMESTAMP, "homeTeam" VARCHAR(20), "awayTeam" VARCHAR(20), network VARCHAR(100), "isNational" BOOLEAN DEFAULT FALSE, market VARCHAR(100), "createdAt" TIMESTAMP DEFAULT NOW(), UNIQUE(league, "gameId", network) ) zhCREATE INDEX IF NOT EXISTS "GameBroadcast_league_national_idx" ON "GameBroadcast" (league, "isNational")zSCREATE INDEX IF NOT EXISTS "GameBroadcast_gameId_idx" ON "GameBroadcast" ("gameId")N)execute)curs r5ensure_broadcast_tabler:0s/KK KKz{KKefc td|d|d|}|dvr|dz } tj|d}|jdk7rgS|j }g}|jdgD]6}|jd g}|s|d } d } d } | jd gD]M} | jd i} | jddj }| jddk(r|} L|} O| jdg}g}|D]m}|jdd}|jdg}|D]B}|j t vxs|jdk(}|j|||dDo| s| s|j| | |jd|d9|S#t$r}td|gcYd }~Sd }~wwxYw)z,Fetch broadcast info for all games on a date/z/scoreboard?dates=)rrz&groups=50&limit=300)timeoutevents competitionsrN competitorsteam abbreviationr)homeAwayhome broadcastsmarketnamesnational)network is_nationalrIdate)rGawayrNrHz Error: ) ESPN_BASErequestsr1 status_codejsonupperNATIONAL_NETWORKSlowerappend Exceptionprint)r r date_strurlrespdatagameseventrBcomp home_team away_team competitorrDabbrevrHgame_broadcastsbroadcast_grouprIrJnamerMes r5fetch_broadcasts_for_dateriEs Kqq -?z JCEE %%5||C,   s "Iyy{XXh+( E 99^R8L?DII"hh}b9 ' !~~fb1."5;;=>>*-7 &I &I  ',3J O#- (,,Xr:'++GR8!D"&**,2C"C"cv||~YcGcK#**#''2"(, Y %%!IIf-"1 G( T  !o s0'F$D0F$6F$:)F$$ G-G<GGc|tvrtd|dddSt|}t}tj|}|j }t ||jtjtjj}|t|z }|t|z} td|jd|d| d} d} |} | | kr| jd} t!j"t$t'|d |d | }|D]}|d s t)|d |}t)|d |}|j+d|||| f|j-}|r|dnd}|r|dn| }|d D]+} |j+d||||||d|d|df| dz } -| dz } | tdz } | | kr|j|j+d|f|j-}|j1|j1td|d|dd|dd|dd | | dS#t.$r }Yd}~d}~wwxYw)z!Fetch broadcast info for a leaguezUnknown league: r)r^rH)days z: Fetching broadcasts from z to z%Y%m%dr r rHrGrOz SELECT id, "gameDate" FROM "SportsGame" WHERE league = %s AND "homeTeam" = %s AND "awayTeam" = %s AND "gameDate"::date = %s LIMIT 1 Nr&a INSERT INTO "GameBroadcast" ( league, "gameId", "gameDate", "homeTeam", "awayTeam", network, "isNational", market ) VALUES (%s, %s, %s, %s, %s, %s, %s, %s) ON CONFLICT (league, "gameId", network) DO UPDATE SET "isNational" = EXCLUDED."isNational", market = EXCLUDED.market rLrMrIz SELECT COUNT(DISTINCT "gameId"), COUNT(*), SUM(CASE WHEN "isNational" THEN 1 ELSE 0 END) FROM "GameBroadcast" WHERE league = %s z z:  games, z broadcasts (z national)) LEAGUE_CONFIGrYr6psycopg2connectcursorr:commitrnowrutcrNrrTstrftimetimesleep REQUEST_DELAYrirr8fetchonerXclose)league days_back days_forwardconfigdb_urlconnr9today start_dateend_date total_gamestotal_broadcasts current_daterZr^game home_full away_fulldb_gamegame_id game_date broadcastrhstatss r5fetch_broadcasts_for_leaguers ]"  )*!,, 6 "F ]F   F #D ++-C3KKM LL & + + -E 22Jyl33H Bv||~9*T( TUKL ( "((2 =!)&/6-;PRZ[' D %)$v,?I)$v,?I KK )Y =  ?llnG$+gajG&- rs 22277??277??8#<=>( ;  "% 8 6e 4 6#4M N!2D E  O Cg*;|WBt< zFr;