U ð‘Új“ã @s<ddlZddlZddlZddlZddlZddlmZmZddlmZddl Z ddl Z e  d¡Z e  d¡Z ej dd¡Zdd d d d d ddddœ ZdZdd„Zd(dd„Zd)dd„Zd*dd„Zedkr8ddlZddlmZe ¡Zejdd d!ejd"d#d$e ¡Zeejejre  ej¡ndd%Z!e"ej#e!dd&d'ƒdS)+éN)ÚdatetimeÚtimezone)ÚurlparseZhermes_footballzAmerica/TijuanaZHERMES_FOOTBALL_DBz!/var/lib/hermes-nexus/football.db)zLiga MXéd)zChampions Leagueén)zPremier LeagueéZ)ZLaLigar)zSerie AéP)Z Bundesligar)zLigue 1éF)z Europa LeagueéK)zCopa Libertadoresr ) zmex.1zuefa.championszeng.1zesp.1zita.1zger.1zfra.1z uefa.europazconmebol.libertadoreszBhttps://site.api.espn.com/apis/site/v2/sports/soccer/{}/scoreboardcCsltjtj t¡ddtjtdd}tj|_|  d¡dd„|  d¡  ¡Dƒ}d |kr`|  d ¡|  ¡|S) NT)Úexist_oké)Útimeouta4CREATE TABLE IF NOT EXISTS events( id TEXT PRIMARY KEY, league TEXT NOT NULL, league_code TEXT NOT NULL, home TEXT NOT NULL, away TEXT NOT NULL, logo TEXT NOT NULL, starts_utc TEXT NOT NULL, state TEXT NOT NULL, network TEXT NOT NULL, source TEXT NOT NULL, local_day TEXT NOT NULL, updated TEXT NOT NULL)cSsh|] }|d’qS)é©©Ú.0Úrrrú'/var/www/html/NFL_ST/hermes_football.pyÚ szconnect..zPRAGMA table_info(events)Ú away_logoz@ALTER TABLE events ADD COLUMN away_logo TEXT NOT NULL DEFAULT '') ÚosÚmakedirsÚpathÚdirnameÚDBÚsqlite3ÚconnectZRowZ row_factoryÚexecuteÚfetchallÚcommit)ÚdbZcolsrrrrs  ré cCsØg}g}t ¡D]¤\}\}}zDtjt |¡| d¡ddœdddid}| ¡| ¡ dg¡D]ü}| d ¡ptg} | s|qb| d } |  d ¡pg} t | ƒd kr qbt d d„| Dƒ| d ƒ} t dd„| Dƒ| dƒ} dd„}| dd¡}|sêqbt   |  dd¡¡}|jdkr|j tjd}| tj¡}| t¡ ¡|kr8qb|  d¡pFg}ttdd„|Dƒƒƒ}dd„}|| ƒ}|| ƒ}|s®|  di¡ d¡p’g}|rª|d  dd¡nd}|rØt|ƒjdksÔt|ƒjd krØd}t| d!¡pèdƒ}| ¡søqb| t|d"||||| ƒ|| ƒ||| ¡| d#i¡ d$i¡ d%d&¡|rLd' |¡nd(d)| ¡|d* ¡qbWqtk r´}z0| |d+t |ƒj!d+t|ƒdd…¡W5d}~XYqXq|j"d,d-„d.|d|…|fS)/Nz%Y%m%dr)ZdatesÚlimitr!z User-AgentzHermesFootball/1.0)Úparamsr ZheadersÚeventsZ competitionsrZ competitorsécss |]}| d¡dkr|VqdS)ÚhomeAwayÚhomeN©Úget©rÚxrrrÚ .szfetch..css |]}| d¡dkr|VqdS)r&ÚawayNr(r*rrrr,/srcSs(| di¡ d¡p&| di¡ d¡p&dS)NÚteamZ displayNameÚnameÚr(©r+rrrr/0ózfetch..nameÚdater0ÚZz+00:00)ÚtzinfoÚ broadcastscss,|]$}| dg¡D]}|rt|ƒVqqdS)ÚnamesN)r)Ústr)rÚbÚnrrrr,9s cSsh| di¡}| d¡pd}|sD| d¡p*g}|r@|d dd¡nd}t|ƒ}|jdkrd|jdkrd|SdS) Nr.Úlogor0ÚlogosrÚhrefÚhttps©z a.espncdn.comza1.espncdn.comza2.espncdn.com)r)rÚschemeÚhostname)Zsider.Úurlr<ÚparsedrrrÚ team_logo:s ÿzfetch..team_logor.r<r=r>r?Úidú:ÚstatusÚtypeÚstateZprez, zCanal por confirmarZESPN) rEÚleagueÚ league_coder'r-r;rÚ starts_utcrIÚnetworkÚsourceÚ local_dayÚpriorityz: cSs|d |d|dfS)NrPrLrErr1rrrÚSr2zfetch..)Úkey)#ÚLEAGUESÚitemsÚhttpxr)ÚURLÚformatÚstrftimeZraise_for_statusÚjsonÚlenÚnextrÚ fromisoformatÚreplacer5rÚutcÚ astimezoneÚTZr3ÚsortedÚsetrr@rAr8ÚisdigitÚappendÚdictÚ isoformatÚjoinÚ ExceptionrHÚ__name__Úsort)Údayr"ÚfoundÚerrorsÚcoderJrPrZevÚcompsÚcompZsidesr'r-r/Zdate_rawZdtr6ZchannelsrDrr;r<ZeidÚerrrÚfetch!svÿ     ÿ ü@rrFcsÎ|pt t¡ ¡}t|ƒ\}}|r®|r®tƒ}zvt tj¡  ¡}|  d¡dd„|  d¡Dƒ}|D]6‰ˆd|krrq`|  dt ‡fdd„d Dƒƒ|f¡q`|  ¡W5| ¡X|  ¡t |o¼|ƒt|ƒ||d œS) NzlCREATE TABLE IF NOT EXISTS hermes_football_exclusions (event_id TEXT PRIMARY KEY, deleted_utc TEXT NOT NULL)cSsh|] }|d’qS)rrrrrrr^szrun..z/SELECT event_id FROM hermes_football_exclusionsrEa¯INSERT INTO events (id,league,league_code,home,away,logo,away_logo,starts_utc,state,network,source,local_day,updated) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT(id) DO UPDATE SET league=excluded.league, home=excluded.home,away=excluded.away, logo=excluded.logo,away_logo=excluded.away_logo,starts_utc=excluded.starts_utc,state=excluded.state, network=excluded.network,updated=excluded.updatedc3s|]}ˆ|VqdS)Nr)rÚk©rqrrr,hszrun..) rErJrKr'r-r;rrLrIrMrNrO)rkZ publishedÚcountrmr$)rÚnowr`r3rrrÚcloserr^rfrÚtuplerÚboolrZ)ÚpublishrkÚrowsrmr rvZ excluidosrrtrÚrunVs*   ù  ÿr|cCs¾ddlm}tƒ}zœ|dks$|dkr4| d¡ ¡}njt|tƒrˆ| |  dd¡dd…d|  dd¡dd…d|  dd¡dd …¡}| d |  ¡f¡ ¡}d d „|DƒW¢S| ¡XdS) uGSin filtro: todas las tarjetas. Con fecha: solo día local de Mexicali.r©r3Nr0z-SELECT * FROM events ORDER BY starts_utc DESCú-éééz:SELECT * FROM events WHERE local_day=? ORDER BY starts_utccSsg|] }t|ƒ‘qSr)rer*rrrÚ yszlist_events..) rr3rrwrrÚ isinstancer8r\r]rf)rkZ_dater r{rrrÚ list_eventsns  Jr„Ú__main__r}z --publishÚ store_true)Úactionz--datez YYYY-MM-DD, fecha local Mexicali)Úhelp)rzrkr%)Z ensure_asciiÚindent)r!)FN)N)$rrrYÚreZloggingrrÚ urllib.parserrUZpytzZ getLoggerZLOGr`Úenvironr)rrSrVrrrr|r„riÚargparser3ÚArgumentParserÚpÚ add_argumentÚ parse_argsÚarzr\ÚresultÚprintÚdumpsrrrrÚs<(   û 5    "