\j SrSSKrSSKrSSKJr SSKrSSKrSSKr\"\ 5R5RRr \ S- S- S- r S\R4SjrS\4S jr\S :Xa\R&"\"55 gg) u Importa il nome dell'arbitro nella tabella matches, dalle colonne Referee dei CSV football-data già scaricati (disponibile solo per la Premier League). Aggiunge la colonna matches.referee se manca. Idempotente. Uso: python scripts/import_referees.py N)Pathdatarawz football-datareturnc  /n[[RS55GHJnUR5SSS:XaSOSn[R "XSS9nUR RR5UlSUR ;a[S URS 35 MUR/S QS 9nU/S QR5n[R"US SSSS9US 'URS /S 9nUSRRSSSS9RR5US'URU5 [SURS[!U5S35 GMM [R""USS9$)Nz*_E0.csvsz utf-8-sigzlatin-1skip)encoding on_bad_linesRefereez [salto] z: nessuna colonna Referee)DateHomeTeamAwayTeamr )subsetr Tmixedcoerce)dayfirstformaterrorsz\s+ )regexz [ok] z: z partite con arbitro) ignore_index)sortedRAW_DIRglob read_bytespdread_csvcolumnsstrstripprintnamedropnacopy to_datetimereplaceappendlenconcat)framespathr dfouts 2C:\wamp64\www\Tigertips\scripts\import_referees.pyload_referee_rowsr0sS Fw||J/0"&//"3BQ"7?"J;PY [[v FZZ^^))+ BJJ & Jtyyk)BC D  YYIY J<=BBDnnS[4,3HFF jjj)Y++33FCt3LPPVVXI c  {"SXJ.BCD1 99V$ //c [R"SS9n[R"U5 UR 5n[ 5n[ S[U5SUSR5S35 [R"URURURURSS9nUR5nUR!S 5 UR#5S S :Xa,UR!S 5 UR%5 [ S 5 UR!S 5 UR'5VVVVs0sH upVpxXgU4U_M n nnnn/S pUR)SS9Hjn U R+U R,R/5U R0U R245nUcU S- n MMU R5U R6U45 Ml [9S [U 5S5H*n UR;SXU S-5 UR%5 M, UR!S5 [ SUR#5S SU S35 UR=5 g s snnnnf)Nz'Importa arbitri (Premier League) nel DB) descriptionzTotale: z partite, r z arbitri distinti tigertips)hostportuserpassworddatabasez SELECT COUNT(*) FROM information_schema.columns WHERE table_schema = 'tigertips' AND table_name = 'matches' AND column_name = 'referee' rzEALTER TABLE matches ADD COLUMN referee VARCHAR(50) NULL AFTER away_xgz Colonna matches.referee aggiuntaz SELECT m.id, m.match_date, h.name, a.name FROM matches m JOIN leagues l ON l.id = m.league_id JOIN teams h ON h.id = m.home_team_id JOIN teams a ON a.id = m.away_team_id WHERE l.code = 'E0' F)indexiz-UPDATE matches SET referee = %s WHERE id = %sz6SELECT COUNT(*) FROM matches WHERE referee IS NOT NULLzPartite con arbitro nel DB: z (non abbinate: ))argparseArgumentParserconfig add_db_args parse_argsr0r"r)nuniquepymysqlconnectr5r6r7r8cursorexecutefetchonecommitfetchall itertuplesgetr daterrr(r range executemanyclose)parserargsrefsconncurmiddhnan match_idsrows unmatchedrstarts r/mainr^-s  $ $1Z [F v    D  D HSYKz$y/*A*A*C)DDU VW ??   $(MMK ID ++-CKK  ||~aA [\  01KK 9< Gncb!c!IG!) __5_ )mmQVV[[]AJJ CD ; NI  QYY$% *q#d)T* G54<0 2 + KKHI ():(;<%;a )*JJL 'Hs;I __main__)__doc__r=syspathlibrpandasrrCr?__file__resolveparent PROJECT_ROOTr DataFramer0intr^__name__exitr1r/rms  H~%%'..55  % '/ 902<<0*0 c0 f zHHTVr1