
    [jM	                     6   S r SSKrSSKrSSKJr  SSKJr  SSKrSSK	r	\" \
5      R                  5       R                  r\R                  R                  S\" \5      5        SSKJr  S\SS4S jrSS	 jrS\4S
 jr\S:X  a  \R0                  " \" 5       5        gg)a-  
Aggiornamento notturno: risultati + quote closing + xG della stagione corrente,
poi regolamento di daily_picks e scoring di tipster e agenti.

Calcola da solo i codici stagione correnti (a luglio 2026 -> '2526' e '2627').

Uso (pensato per lo scheduler, ~03:30):
    python scripts/update_results.py
    N)date)Path)settlescriptreturnc                     [        SU  SSR                  U5       S3SS9  [        R                  " [        R
                  [        [        U -  5      /UQSS9  g )Nz
---  z ---Tflushi  )timeout)printjoin
subprocessrunsys
executablestrSCRIPTS)r   extras     1C:\wamp64\www\Tigertips\scripts\update_results.pyr   r      sJ    	F6(!CHHUO,D
1>NNCNNC&(8$9BEBDQ    c                  h   [         R                  " SSSSS9n U R                  5       n[        R                  " SU 5      nUR
                  (       a  [        S5        U R                  5         g S H  n[        R                  " X#   S	S
9X#'   M     UR                  [        SS9US'   UR                  S/S9nUR                  SS9 H4  nUR                  SUR                  [        UR                   5      45        M6     U R#                  5         U R                  5         [        S[%        U5       35        g )Nz	127.0.0.1root 	tigertips)hostuserpassworddatabasez
        SELECT dp.id, dp.market, dp.selection, dp.line,
               m.home_goals AS hg, m.away_goals AS ag
        FROM daily_picks dp
        JOIN matches m ON m.id = dp.match_id
        WHERE dp.outcome = 'unsettled' AND m.result IS NOT NULL
    zdaily_picks: nulla da regolare)linehgagcoerce)errors   )axisnew_outcome)subsetF)indexz1UPDATE daily_picks SET outcome = %s WHERE id = %szdaily_picks regolate: )pymysqlconnectcursorpdread_sqlemptyr   close
to_numericapplyr   dropna
itertuplesexecuter'   intidcommitlen)conncurdfcdoners         r   settle_daily_picksr@      s   ??&2$/1D
++-C	  

B 
xx./

!beH5 "a0B}99]O9,D__5_)G]]CI.	0 * 	KKMJJL	"3t9+
./r   c                     [         R                  " 5       n U R                  S:  a  U R                  OU R                  S-
  n[	        US-
  5      SS   [	        U5      SS   3[	        U5      SS   [	        US-   5      SS   3/n[	        U5      n[        SS/UQSP76   [        S5        [        SSUS5        [        S	5        [        S
SS9  [        5         [        S5        [        S5        g)N   r%      zdownload_data.pyz	--seasonsz--forcezimport_db.pyzdownload_xg.pyzimport_xg.pyz 
--- regolamento daily_picks ---Tr
   zscore_tipsters.pyzscore_signals.pyr   )r   todaymonthyearr   r   r   r@   )rD   
start_year
seasons_fd	season_uss       r   mainrJ   8   s    JJLE${{a/UZZ!^Ja(,-c*oab.A-BC_QR()#j1n*=ab*A)BCEJJIK@*@i@+y)<	
-T:r   __main__)r   N)__doc__r   r   datetimer   pathlibr   pandasr-   r*   __file__resolveparentr   pathinsertr   score_tipstersr   r   r@   r6   rJ   __name__exit r   r   <module>rY      s     
    
x.
 
 
"
)
) 3w<   !R R R
06c $ zHHTV r   