ٰoiQ3 dZddlZddlZddlmZmZmZddlmZiddddddd d d d d d d dddddddddddddddddddddiddddddd dd!dd"dd#d$d%d$d&d$d'd(d)d(d*d(d+d,d-d,d.d,d/d0d1d0id2d0d3d4d5d4d6d4d7d8d9d8d:d8d;d<d=d<d>d<d?d@dAd@dBd@dCdDdEdDdFdDdGdHidIdHdJdHdKdLdMdLdNdLdOdLdPdQdRdQdSdQdTdUdVdUdWdUdXdYdZdYd[dYd\dYd]d^id_d^d`d^dadbdcdbdddbdedbdfdgdhdgdidgdjdkdldkdmdkdndkdodpdqdpdrdpdsdtidudtdvdtdwdxdydxdzdxd{d|d}d|d~d|ddddddddddddddddddiddddddddddddddddddddddddddddddddddidd$dd$dd(dd(dddddddd0dd0dd4dd4dd4ddddddddddidddddddddddd8dd8ddddddDddDddLddLddÓddÓddÓddǓiddǓddʓddʓdd͓dd͓ddbddbddғddғddғdd֓dd֓dd֓dd֓ddۓddۓddۓiddߓddߓddߓddߓdddddddddddddddddddddd|dd dd iddddddddddddddddddddddddddddddddddidddd(dd(d d d d d d d dddddddddLddLddddddddddidddddddd d!d d"d d#d$d%d$d&d'd(d'd)d*d+d*d,d*d-d*d.dbd/dbd0dғid1dғd2dғd3d4d5d4d6d4d7dۓd8dۓd9d:d;d:d<d:d=d:d>d?d@d?dAdxdBdxdCdxdDdEdEdEdFdFdFdGdGdGdHdHdHdI ZdJZ dKZ dLZ e dMk(re yy(Na  Relink Player Props to Scored SportsGame Records Props may be linked to SportsGame records that have no scores (from odds sources). This script finds the matching scored games and updates the gameId references. Run: python3 scripts/relink_props_to_scored_games.py N)datetimetimezone timedelta) defaultdictz atlanta hawksATLhawksatlantazboston celticsBOScelticsbostonz brooklyn netsBKNnetsbrooklynzcharlotte hornetsCHAhornets charlottez chicago bullsCHIbullschicagozcleveland cavaliersCLE cavalierscavs clevelandzdallas mavericksDAL mavericksmavsdallaszdenver nuggetsDENnuggetsdenverzdetroit pistonsDETpistonsdetroitzgolden state warriorsGSWwarriorsz golden statezhouston rocketsHOUrocketshoustonzindiana pacersINDpacersindianazlos angeles clippersLACz la clippersclipperszlos angeles lakersLALz la lakerslakerszmemphis grizzliesMEM grizzliesmemphisz miami heatMIAheatmiamizmilwaukee bucksMILbucks milwaukeezminnesota timberwolvesMIN timberwolveswolves minnesotaznew orleans pelicansNOPpelicansz new orleansznew york knicksNYKknicksznew yorkzoklahoma city thunderOKCthunderz oklahoma cityokcz orlando magicORLmagicorlandozphiladelphia 76ersPHIsixers76ers philadelphiaz phoenix sunsPHXsunsphoenixzportland trail blazersPORz trail blazersblazersportlandzsacramento kingsSACkings sacramentozsan antonio spursSASspursz san antonioztoronto raptorsTORraptorstorontoz utah jazzUTAjazzutahzwashington wizardsWASwizards washingtonzarizona cardinalsARI cardinalsarizonazatlanta falconsfalconszbaltimore ravensBALravens baltimorez buffalo billsBUFbillsbuffalozcarolina panthersCARpantherscarolinaz chicago bearsbearszcincinnati bengalsCINbengals cincinnatizcleveland brownsbrownszdallas cowboyscowboyszdenver broncosbroncosz detroit lionslionszgreen bay packersGBpackersz green bayzhouston texanstexanszindianapolis coltscolts indianapoliszjacksonville jaguarsJAXjaguars jacksonvillezkansas city chiefsKCchiefsz kansas cityzlas vegas raidersLVraidersz las vegaszoakland raiderszlos angeles chargerschargerszlos angeles ramsLARramszmiami dolphinsdolphinszminnesota vikingsvikingsznew england patriotsNEpatriotsz new englandznew orleans saintsNOsaintsznew york giantsNYGgiantsz new york jetsNYJjetszphiladelphia eagleseagleszpittsburgh steelersPITsteelers pittsburghzsan francisco 49ersSF49ersz san francisconinerszseattle seahawksSEAseahawksseattleztampa bay buccaneersTB buccaneersbucsz tampa bayztennessee titansTENtitans tennesseezwashington commanders commandersz anaheim ducksANAducksanaheimzarizona coyotescoyoteszutah hockey clubz boston bruinsbruinszbuffalo sabressabreszcalgary flamesCGYflamescalgaryzcarolina hurricanes hurricaneszchicago blackhawks blackhawkszcolorado avalancheCOL avalanchecoloradoavszcolumbus blue jacketsCBJz blue jacketscolumbusz dallas starsstarszdetroit red wingsz red wingszedmonton oilersEDMoilersedmontonzflorida panthersFLAfloridazlos angeles kingsLAKzla kingszminnesota wildwildzmontreal canadiensMTL canadiensmontrealhabsznashville predatorsNSH predators nashvillepredsznew jersey devilsNJDdevilsz new jerseyznew york islandersNYI islandersznew york rangersNYRrangerszottawa senatorsOTTsenatorsottawasenszphiladelphia flyersflyerszpittsburgh penguinspenguinspenszsan jose sharksSJSsharkszsan josezseattle krakenkrakenzst. louis bluesSTLzst louis bluesbluesz st. louisztampa bay lightningTBL lightningztoronto maple leafsz maple leafsleafszvancouver canucksVANVGKWSHWPG) canucks vancouverzvegas golden knightszgolden knightsvegaszwashington capitalscapitalscapsz winnipeg jetsrwinnipegc|sy|jj}|tvr t|St|dkr|j r|S|j ddS)z#Normalize team name to abbreviationN)lowerstrip TEAM_ALIASESlenisupperupper)name name_lowers A/var/www/html/eventheodds/scripts/relink_props_to_scored_games.pynormalize_teamrusZ ##%J\!J'' 4yA~$,,. ::< cd} t|d5}|D]b}|jds|jdddjjdjddccdddS dddt j jd d jddS#1swY;xYw#t$rYIwxYw) Nz/var/www/html/eventheodds/.envrzSPORTS_DATABASE_URL=="?rSPORTS_DATABASE_URL)open startswithsplitrFileNotFoundErrorosenvironget)env_pathflines r 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 c|tdtdtdtjtjj tdt }tj|}|j}td|jd|j}tdt|d|s/td|j|jd d iStd |jd tt}|jD]}|\}}}} } } t!|} t!| } t#d dD]b}t%|z}|| | t'|f}||j)|| | d|| | t'|f}||j)|| | dddtdt|dtdi}d d d d}|D]}|\}}}} }t!|} t!| } || | t'f}|j+|g}|rMt-|fd}|d||<|dxxdz cc<td| d| dd|dd |d!d"|d#d$ |d%xxdz cc<td&| d| dd'|d( td)|dd*|d%|rtd+|j/D]F\}}|jd,||f|j0}|d-xx|z cc<td.|d/|d0|H|j3td1|d-td2|jd3|j5d }|jd4|j5d }td5|td6|td7td8td9|dtd:|d%td;|d-td|j|j|S)zrun_relinkage..sC6Y9N8T8T4Ur)keyrr rz MATCH: z vs z (z ) -> game_id z (score: r-r)r z NO MATCH: z) - z propsz Matched: z , No match: z' [4] Updating prop gameId references...z UPDATE "PlayerPropLine" SET "gameId" = %s WHERE "gameId" = %s AND result IS NULL r z Updated z props: game_id z -> z Total props relinked: z! [5] Verifying linkage results...z SELECT COUNT(*) FROM "PlayerPropLine" ppl JOIN "SportsGame" sg ON ppl."gameId" = sg.id WHERE ppl.result IS NULL AND sg."homeScore" IS NOT NULL AND ppl.league IN ('nba', 'nfl', 'nhl') z SELECT COUNT(*) FROM "PlayerPropLine" ppl JOIN "SportsGame" sg ON ppl."gameId" = sg.id WHERE ppl.result IS NULL AND sg."homeScore" IS NULL AND ppl.league IN ('nba', 'nfl', 'nhl') z Props now linkable to scores: z" Props still on scoreless games: z= ============================================================zRESULTS:z Games matched: z Games unmatched: z Props relinked: )printrnowrutc isoformatrpsycopg2connectcursorexecutefetchallrcloserlistrrangerstrappendrminitemsrowcountcommitfetchone)db_urlconncurscoreless_games scored_lookuprowgame_idleaguehomeawayrr home_abbr away_abbrdelta lookup_dater key_swapped relink_mapstats old_game_id prop_countmatches best_matchold_idnew_idupdatedlinkablestill_scorelessrs @r run_relinkagerAs (O () F8<< -779: ;< (O ]F   F #D ++-C IJKK llnO HS)**E FG  ;<  A 12KK    %M||~ILFtY J"4( "4( 2q\ E#iU&;;K9i[1ABC #  % %!(( ' "9i[9IJK + & - -!(( /   0 Ic-()): ;< 78JqA >E`AD> VT4J"4( "4( y)S^<##C, W*UVJ&0&6J{ # )  !  Ii[YKr)MR\]aRbQcclmwyEnFmGGHIST`IaHbbcd e *  "  L 4 {"YKtJrGs 22#bUb#Ub,5ubeb'b08bU b#E b,6u b  b !*5 b 3>u b U b $U b -6u b5b#.ub7=ebFQRWbb +Eb4:5bCKEbeb'b08bub(b1:5bUb%/b8Fubub(b1:5beb&ub/8bEb$1%b:DUb%b"-eb6>ub !b !,U!b 5>u!b"%#b" #b")0#b$u%b$&u%b$/:5%b&e'b&&4U'b&=Ee'b&NYZ_'b(E)b($.u)b(7DU)b*u+b*'+b*0:5+b,U-b,%.u-b,7Fu-b,OTUZ-b.U/b.$U/b.-6u/b0%1b0"*51b03:51b0CQRW1b2E3b2"53b2+4U3b4e5b4&5e5b4>G5b4PZ[`5b67b6 '7b60u9b:u;b:(;b:1:5;b<=b<=b<(.u=b>%?b>"+E?b>4@?bBCbB!,UCbB5>uCbDuEbD(EbFGbF (GbF1uKbLUMbL$UMbN%ObN"+EObN4@ObPQbP (QbReSbR'SbTeUbT'UbVUWbV$UWbXYbX )$YbX1tabbcbb )$cbb1ugbh%ibh"-eibjkbj )%kblumbl)%mbl2:5mblCI%mbn5obn#+Eobp5qbp#-eqbp6