Ë
    3ýj•  ã                   óÜ   — d Z ddlZddlmZ ddlmZmZmZ ddlm	Z	 ddl
mZ ddlmZ ddlmZ dd	lmZ 	 dd
l
mZ  e«       ZdZdZ ee«      Zd„ Z G d„ d«      Zy# e$ r	 dd
lmZ Y Œ.w xY w)zSQLAlchemy session.é    N)Úregister_after_fork)Úcreate_engineÚinspectÚtext)ÚDatabaseError)Úsessionmaker)ÚNullPool)Ú
get_logger)Ú get_exponential_backoff_interval)Údeclarative_base)ÚSessionManageré
   c                 ó$   — | j                  «        y ©N)Ú_after_fork)Úsessions    úZ/root/telegram-saas/.venv/lib/python3.12/site-packages/celery/backends/database/session.pyÚ_after_fork_cleanup_sessionr      s   € Ø×ÑÕó    c                   óD   — e Zd ZdZdd„Zd„ Zd„ Zdd„Zd„ Zd„ Z	d	„ Z
d
„ Zy)r   zManage SQLAlchemy sessions.Nc                 óx   — i | _         i | _        d| _        d| _        || _        t
        �t        | t        «       y y )NF)Ú_enginesÚ	_sessionsÚforkedÚpreparedÚengine_callbackr   r   )Úselfr   s     r   Ú__init__zSessionManager.__init__#   s<   € ØˆŒØˆŒØˆŒØˆŒØ.ˆÔÜÐ*Ü Ô&AÕBð +r   c                 ó   — d| _         y )NT)r   )r   s    r   r   zSessionManager._after_fork,   s	   € Øˆ�r   c                 ó²  — | j                   r	 | j                  |   S ddh}|j                  «       D ��ci c]  \  }}|j                  d«      s||vr||“Œ }}}t        |fdt        i|¤Ž}| j                  �| j	                  |«       |S # t        $ r= t        |fi |¤Ž}| j                  �| j	                  |«       || j                  |<   |cY S w xY wc c}}w )NÚmax_overflowÚ	echo_poolÚpoolÚ	poolclass)r   r   ÚKeyErrorr   r   ÚitemsÚ
startswithr	   )r   ÚdburiÚkwargsÚengineÚunsupported_nullpool_kwargsÚkÚvs          r   Ú
get_enginezSessionManager.get_engine/   sï   € Ø�;Š;ðØ—}‘} UÑ+Ð+ð ,:¸;Ð*GÐ'à!'§¡£÷Ù˜˜AØ—|‘| FÔ+°Ð9TÑ0Tð �1‘ðˆFñ ô # 5ÑG´HÐGÀÑGˆFØ×#Ñ#Ð/Ø×$Ñ$ VÔ,ØˆMøô ò Ü& uÑ7°Ñ7�Ø×'Ñ'Ð3Ø×(Ñ(¨Ô0Ø'-�—‘˜eÑ$Ø’ðüós   ŽB
 ´"CÂ
ACÃCc                 óÐ   —  | j                   |fi |¤Ž}| j                  r:|s|| j                  vrt        |¬«      | j                  |<   || j                  |   fS |t        |¬«      fS )N)Úbind)r.   r   r   r   )r   r(   Úshort_lived_sessionsr)   r*   s        r   Úcreate_sessionzSessionManager.create_sessionD   sc   € Ø �—‘ Ñ1¨&Ñ1ˆØ�;Š;Ù# u°D·N±NÑ'BÜ(4¸&Ô(A�—‘˜uÑ%Ø˜4Ÿ>™>¨%Ñ0Ð0Ð0Ø”|¨Ô0Ð0Ð0r   c                 óš   — | j                   j                  |d«       | j                  j                  |d«      }|�|j                  «        yy)z7Dispose cached engine/session state for a database URI.N)r   Úpopr   Údispose)r   r(   r*   s      r   Ú
invalidatezSessionManager.invalidateL   sA   € à�‰×Ñ˜5 $Ô'Ø—‘×"Ñ" 5¨$Ó/ˆØÐØ�N‰NÕð r   c                 ó"  — | j                   s=d}	 	 t        j                  j                  |«       	 | j                  |«       d| _         y y # t        $ r9 |t
        k  r,t        d|dd«      }t        j                  |dz  «       |dz  }n‚ Y nw xY wŒ�)Nr   Tr   iè  é   )
r   ÚResultModelBaseÚmetadataÚ
create_allr   ÚPREPARE_MODELS_MAX_RETRIESr   ÚtimeÚsleepÚ_migrate_missing_columns)r   r*   ÚretriesÚsleep_amount_mss       r   Úprepare_modelszSessionManager.prepare_modelsS   s¡   € Ø�}Š}ð
 ˆGØðÜ#×,Ñ,×7Ñ7¸Ô?ð Ø×)Ñ)¨&Ô1Ø ˆD�Mð+ øô %ò ØÔ!;Ò;Ü*JØ ¨¨tó+˜ô Ÿ
™
 ?°TÑ#9Ô:Ø 1™™àñ  ðúð s   ‘A Á?BÂBc           
      óª  — 	 t        |«      }|j                  j                  }t        j                  j
                  j                  «       D �]  }|j                  }|j                  }|j                  ||¬«      sŒ0|j                  ||¬«      D �ch c]  }|d   ’Œ	 }}|j                  D ]®  }|j                  |vsŒ|j                  sŒ|j                  j                  |j                  «      }	|j                  |«      }
|j!                  |j                  «      }d|
› d|› d|	› �}	 |j#                  «       5 }|j%                  t'        |«      «       ddd«       Œ° �Œ yc c}w # 1 sw Y   ŒxY w# t(        $ r-}t*        j-                  d|j                  |||«       Y d}~Œ÷d}~ww xY w# t(        $ r }t*        j-                  d|«       Y d}~yd}~ww xY w)	z:Add missing nullable columns to existing tables if needed.)ÚschemaÚnamezALTER TABLE z ADD COLUMN ú NzdFailed to add missing column %r to table %r. To enable storing task children, execute: %s. Error: %sz0Failed to inspect or migrate database tables: %s)r   ÚdialectÚidentifier_preparerr9   r:   ÚtablesÚvaluesrE   rD   Ú	has_tableÚget_columnsÚcolumnsÚnullableÚtypeÚcompileÚformat_tableÚquote_identifierÚbeginÚexecuter   Ú	ExceptionÚloggerÚwarning)r   r*   Ú	inspectorÚpreparerÚtableÚactual_namerD   ÚcolÚexisting_colsÚcol_typeÚ
table_nameÚcol_nameÚ
alter_stmtÚconnÚexcs                  r   r?   z'SessionManager._migrate_missing_columnsk   s­  € ð	TÜ ›ˆIØ—~‘~×9Ñ9ˆHÜ(×1Ñ1×8Ñ8×?Ñ?ÓAó �Ø#Ÿj™j�ØŸ™�Ø ×*Ñ*¨;¸vÐ*ÔFØà+4×+@Ñ+@ÀÐU[Ð+@Ó+\ö!Ø$'�C˜“Kð!�ð !ð !Ÿ=™=ò �CØ—x‘x }Ò4¸¿»Ø#&§8¡8×#3Ñ#3°F·N±NÓ#C˜Ø%-×%:Ñ%:¸5Ó%A˜
Ø#+×#<Ñ#<¸S¿X¹XÓ#F˜Ø'3°J°<¸|ÈHÈ:ÐUVÐW_ÐV`Ð%a˜
ðØ!'§¡£ð ?°4Ø $§¡¬T°*Ó-=Ô >÷?øòñùò
!÷?ð ?ûä(ò Ü"ŸN™Nð!Zà #§¡¨+°zÀ3÷ñ ûðûô ò 	TÜ�N‰NÐMÈs×SÑSûð	Túsy   ‚BF) ÂEÂF) Â<F) Ã	AF) Ä&E0Ä6E$ÅE0ÅF) ÅF) Å$E-Å)E0Å0	F&Å9#F!ÆF) Æ!F&Æ&F) Æ)	GÆ2GÇGc                 ó^   —  | j                   |fi |¤Ž\  }}| j                  |«        |«       S r   )r2   rB   )r   r(   r)   r*   r   s        r   Úsession_factoryzSessionManager.session_factoryŠ   s3   € Ø-˜$×-Ñ-¨eÑ>°vÑ>‰ˆ�Ø×Ñ˜FÔ#Ù‹yÐr   r   )F)Ú__name__Ú
__module__Ú__qualname__Ú__doc__r   r   r.   r2   r6   rB   r?   re   © r   r   r   r       s/   „ Ù%óCòòó*1òò!ò0Tó>r   r   )ri   r=   Úkombu.utils.compatr   Ú
sqlalchemyr   r   r   Úsqlalchemy.excr   Úsqlalchemy.ormr   Úsqlalchemy.poolr	   Úcelery.utils.logr
   Úcelery.utils.timer   r   ÚImportErrorÚsqlalchemy.ext.declarativer9   Ú__all__r<   rf   rV   r   r   rj   r   r   ú<module>ru      so   ðÙ Û å 2ß 3Ñ 3Ý (Ý 'Ý $å 'Ý >ð<Ý/ñ
 #Ó$€à
€àÐ á	�HÓ	€ò÷mò møð# ò <ç;ð<ús   ¶A ÁA+Á*A+