Ë
    3ýjÞ;  ã                   ó^  — d Z ddlZddlZddlmZ ddl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 ddlmZ ddlmZmZm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$  ejL                  e'«      Z(dZ)eeee$fZ*ed„ «       Z+ G d„ de«      Z,y# e%$ r	  ed«      ‚w xY w)z SQLAlchemy result store backend.é    N)Úcontextmanager)ÚdatetimeÚtimezone)Úensure_bytes)Ústates)ÚBaseBackend)ÚImproperlyConfigured)Úresult_from_tuple)Úsymbol_by_name)Úmaybe_timedeltaé   )ÚTaskÚTaskExtendedÚTaskSet)ÚSessionManager)ÚDatabaseErrorÚInterfaceErrorÚInvalidRequestError)Údefer)Úflag_modified)ÚStaleDataErrorziThe database result backend requires SQLAlchemy to be installed. See https://pypi.org/project/SQLAlchemy/)ÚDatabaseBackendc              #   óž   K  — 	 d –— 	 | j                  «        y # t         $ r | j                  «        ‚ w xY w# | j                  «        w xY w­w©N)Ú	ExceptionÚrollbackÚclose)Úsessions    ú[/root/telegram-saas/.venv/lib/python3.12/site-packages/celery/backends/database/__init__.pyÚsession_cleanupr    )   sD   è ø€ ðÜð
 	�‰�øô	 ò Ø×ÑÔØðûð 	�‰�üs!   ‚A„ ‰Aš5µ8 ¸A
Á
Ac                   óÂ   ‡ — e Zd ZdZdZeZeZdˆ fd„	Z	e
d„ «       Zd„ Zd„ Zd„ Zdd„Zdd	„Z	 	 dd
„Z	 	 dd„Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zd„ Zdˆ fd„	Zˆ xZS )r   zThe database result backend.g      à?c                 óP  •— t        ‰
| �  dt        |dœ|¤Ž | j                  j                  }|j                  d«      r| j                  €d| _        |j                  d«      r| j                  €d| _        | j                  rt        | _
        |xs |xs |j                  | _        t        |j                  xs i fi |xs i ¤Ž| _        |j!                  d|j"                  «      | _        |j&                  xs i }|j(                  xs i }| j                  j+                  |j!                  d«      |j!                  d«      ¬«       | j,                  j+                  |j!                  d	«      |j!                  d	«      ¬«       | j                  st/        d
«      ‚|j!                  d|j0                  «      }t3        |t4        «      rt7        |«      }|�%t9        |«      st/        dj;                  |«      «      ‚t=        |¬«      | _        |j@                  }	|	du r| jC                  «        y y )N)Úexpires_typeÚurlÚresult_backend_always_retryTÚresult_backend_max_retriesé   Úshort_lived_sessionsÚtask)ÚschemaÚnameÚgroupzTMissing connection string! Do you have the database_url setting set to a real value?Úengine_callbackz3database_engine_callback must be callable, got {!r})r-   © )"ÚsuperÚ__init__r   ÚappÚconfÚvalue_set_forÚalways_retryÚmax_retriesÚextended_resultr   Útask_clsÚdatabase_urlr$   ÚdictÚdatabase_engine_optionsÚengine_optionsÚgetÚdatabase_short_lived_sessionsr(   Údatabase_table_schemasÚdatabase_table_namesÚ	configureÚtaskset_clsr	   Údatabase_engine_callbackÚ
isinstanceÚstrr   ÚcallableÚformatr   Úsession_managerÚdatabase_create_tables_at_setupÚ_create_tables)ÚselfÚdburir;   r$   Úkwargsr2   ÚschemasÚ
tablenamesr-   Úcreate_tables_at_setupÚ	__class__s             €r   r0   zDatabaseBackend.__init__>   s  ø€ ô 	‰Ñð 	,¤oØ ñ	,Ø$*ò	,à�x‰x�}‰}ˆð ×!Ñ!Ð"?Ô@ÀD×DUÑDUÐD]Ø $ˆDÔØ×!Ñ!Ð">Ô?À4×CSÑCSÐC[Ø ˆDÔà×ÒÜ(ˆDŒMàÒ4˜%Ò4 4×#4Ñ#4ˆŒô
 #Ø×(Ñ(Ò.¨Bñ
àÒ# ñ
ˆÔð %+§J¡JØ"Ø×.Ñ.ó%0ˆÔ!ð ×-Ñ-Ò3°ˆØ×.Ñ.Ò4°"ˆ
Ø�‰×ÑØ—;‘;˜vÓ&Ø—‘ Ó'ð 	 ô 	)ð 	×Ñ×"Ñ"Ø—;‘;˜wÓ'Ø—‘ Ó(ð 	#ô 	*ð �xŠxÜ&ð=ó>ð >ð !Ÿ*™*Ø˜t×<Ñ<ó>ˆä�o¤sÔ+Ü,¨_Ó=ˆOØÐ&¬x¸Ô/HÜ&ØE×LÑLØ#ó%ó&ð &ô  .Ø+ô -ˆÔð "&×!EÑ!EÐØ! TÑ)Ø×ÑÕ!ð *ó    c                 óN   — | j                   j                  j                  dd«      S )NÚextendedÚresult)r1   r2   Úfind_value_for_key©rJ   s    r   r6   zDatabaseBackend.extended_result|   s   € à�x‰x�}‰}×/Ñ/°
¸HÓEÐErQ   c                 ó"   — t        |t        «      S r   )rC   ÚRETRYABLE_DB_ERRORS©rJ   Úexcs     r   Úexception_safe_to_retryz'DatabaseBackend.exception_safe_to_retry€   s   € Ü˜#Ô2Ó3Ð3rQ   c                 óN   — | j                   j                  | j                  «       y r   )rG   Ú
invalidater$   rY   s     r   Úon_backend_retryable_errorz*DatabaseBackend.on_backend_retryable_errorƒ   s   € Ø×Ñ×'Ñ'¨¯©Õ1rQ   c                 ó:   — | j                  | j                  «       y)z#Create the task and taskset tables.N)Ú_ensure_retryableÚResultSessionrV   s    r   rI   zDatabaseBackend._create_tables†   s   € à×Ñ˜t×1Ñ1Õ2rQ   c                 ó„   — |€| j                   } |j                  d| j                  | j                  dœ| j                  ¤ŽS )N)rK   r(   r.   )rG   Úsession_factoryr$   r(   r;   )rJ   rG   s     r   ra   zDatabaseBackend.ResultSessionŠ   sM   € ØÐ"Ø"×2Ñ2ˆOØ.ˆ×.Ñ.ð #Ø—(‘(Ø!%×!:Ñ!:ñ#ð ×!Ñ!ñ#ð 	#rQ   c                 ó  — |j                  | j                  «      }|r|j                  «       j                  «       }	 t	        |j                  | j                  j                  |k(  «      «      }|xr |d   S # t        $ rÿ}t        |«      j                  «       }g }d|v rDt        | j                  d«      r.|j                  t        | j                  j                  «      «       d|v rDt        | j                  d«      r.|j                  t        | j                  j                  «      «       |rLt	         |j                  |Ž j                  | j                  j                  |k(  «      «      }|xr |d   cY d}~S ‚ d}~ww xY w)zJQuery task by id, falling back to deferring missing columns from database.r   ÚchildrenÚstampsN)Úqueryr7   Úwith_for_updateÚpopulate_existingÚlistÚfilterÚtask_idr   rD   ÚlowerÚhasattrÚappendr   re   rf   Úoptions)	rJ   r   rl   Ú
for_updaterg   ÚtasksrZ   Úexc_strÚdeferss	            r   Ú_query_taskzDatabaseBackend._query_task’   s4  € à—‘˜dŸm™mÓ,ˆÙà×)Ñ)Ó+×=Ñ=Ó?ˆEð	Ü˜Ÿ™ d§m¡m×&;Ñ&;¸wÑ&FÓGÓHˆEØÒ%˜U 1™XÐ%øÜò 	Ü˜#“h—n‘nÓ&ˆGØˆFØ˜WÑ$¬°·±À
Ô)KØ—‘œe D§M¡M×$:Ñ$:Ó;Ô<Ø˜7Ñ"¤w¨t¯}©}¸hÔ'GØ—‘œe D§M¡M×$8Ñ$8Ó9Ô:ÙÜ˜]˜UŸ]™]¨FÐ3×:Ñ:Ø—M‘M×)Ñ)¨WÑ4óó �ð Ò)  q¡Õ)Øûð	ús$   ½9A7 Á7	E?Â C3E:Å3E?Å9E:Å:E?c                 óÞ  — | j                  «       }t        |«      5  | j                  ||«      }|r| j                  ||d¬«      }|s:| j                  |«      }||_        |j                  |«       |j                  «        n'|j                  t        j                  k(  r
	 ddd«       y| j                  |||||¬«       t        |d«       |j                  «        ddd«       y# 1 sw Y   yxY w)z1Store return value and state of an executed task.T)rq   N)Ú	tracebackÚrequestÚstatus)ra   r    ru   r7   rl   ÚaddÚflushry   r   ÚSUCCESSÚ_update_resultr   Úcommit)	rJ   rl   rT   Ústaterw   rx   rL   r   r)   s	            r   Ú_store_resultzDatabaseBackend._store_result©   sÛ   € ð ×$Ñ$Ó&ˆÜ˜WÓ%ñ 	Ø×#Ñ# G¨WÓ5ˆDÙð
 ×'Ñ'¨°ÀTÐ'ÓJ�ÙØ—}‘} WÓ-�Ø&�”Ø—‘˜DÔ!Ø—‘•Ø—‘¤§¡Ò.ð ÷#	ð 	ð& ×Ñ  f¨e¸yÐRYÐÔZô ˜$ Ô)Ø�N‰NÔ÷1	÷ 	ñ 	ús   œBC#Â(2C#Ã#C,c           	      óŒ  — | j                  t        | j                  |«      «      |||dd¬«      }| j                  j                  j
                  D �cg c]  }|j                  dvr|j                  ‘Œ }}|D ]   }|j                  |«      }	t        |||	«       Œ" t        |d«      rhd| j                  j                  j
                  v rF|j                  d«      }
|
r&t        |dt        | j                  |
«      «      «       nt        |dd «       t        |d«      r¡d| j                  j                  j
                  v r~|j                  d«      }|rO|D �ci c]  }||v sŒ||j                  |«      “Œ }}||dœ}t        |dt        | j                  |«      «      «       y t        |dd «      €t        |dd «       y y y y c c}w c c}w )	NFT)rT   r   rw   rx   Úformat_dateÚencode>   Úidrf   rl   re   re   rf   Ústamped_headers)r…   rf   )Ú_get_result_metar   rƒ   r7   Ú	__table__Úcolumnsr+   r<   Úsetattrrn   Úgetattr)rJ   r)   rT   r   rw   rx   ÚmetaÚcolumnrˆ   Úvaluere   r…   ÚhÚstamps_dataÚstamps_infos                  r   r}   zDatabaseBackend._update_resultÇ   s¼  € ð ×$Ñ$¬L¸¿¹ÀVÓ9LÓ,MÐUZØ/8À'Ø16¸tð %ó Eˆð .2¯]©]×-DÑ-D×-LÑ-Lö R 6Ø—k‘kÐ)PÑPð —;“;ð Rˆð Rð ò 	)ˆFØ—H‘H˜VÓ$ˆEÜ�D˜& %Õ(ð	)ô �4˜Ô$¨°t·}±}×7NÑ7N×7VÑ7VÑ)VØ—x‘x 
Ó+ˆHÙÜ˜˜j¬,°t·{±{À8Ó7LÓ*MÕNä˜˜j¨$Ô/ä�4˜Ô" x°4·=±=×3JÑ3J×3RÑ3RÑ'RØ"Ÿh™hÐ'8Ó9ˆOÙà,;öØ'(¸qÀDºy�A�t—x‘x “{‘Nð�ð ð (7Ø)ñ�ô ˜˜h¬°T·[±[ÀÓ5MÓ(NÕOÜ˜˜x¨Ó.Ð6Ü˜˜h¨Õ-ð 7ð (SÐ"ùò#Rùò(s   Á!F<Å	GÅGc                 óD  — | j                  «       }t        |«      5  | j                  ||«      }|s-| j                  |«      }t        j
                  |_        d|_        |j                  «       }| j                  |d   «      |d<   |j                  dd«      �| j                  |d   «      |d<   |j                  dd«      �| j                  |d   «      |d<   |j                  dd«      �| j                  |d   «      |d<   |j                  dd«      }|�Y	 | j                  |«      }t        |t        «      r7d|v r|d   |d<   d|v r't        |d   t        «      r|j                  |d   «       | j#                  |«      cddd«       S # t         $ r Y Œ%w xY w# 1 sw Y   yxY w)z$Get task meta-data for a task by id.NrT   ÚargsrL   re   rf   r…   )ra   r    ru   r7   r   ÚPENDINGry   rT   Úto_dictÚ_decode_stored_resultr<   ÚdecodeÚpoprC   r9   Úupdater   Úmeta_from_decoded)rJ   rl   r   r)   ÚdataÚ
raw_stampsr�   s          r   Ú_get_task_meta_forz"DatabaseBackend._get_task_meta_forï   s™  € à×$Ñ$Ó&ˆÜ˜WÓ%ñ 	0Ø×#Ñ# G¨WÓ5ˆDÙØ—}‘} WÓ-�Ü$Ÿn™n�”Ø"�”Ø—<‘<“>ˆDØ!×7Ñ7¸¸X¹ÓGˆD�‰NØ�x‰x˜ Ó%Ð1Ø#Ÿ{™{¨4°©<Ó8��V‘Ø�x‰x˜ $Ó'Ð3Ø!%§¡¨T°(©^Ó!<��X‘Ø�x‰x˜
 DÓ)Ð5Ø#'§;¡;¨t°JÑ/?Ó#@��ZÑ ØŸ™ (¨DÓ1ˆJØÐ%ðØ"&§+¡+¨jÓ"9�KÜ! +¬tÔ4Ø,°Ñ;Ø6AÐBSÑ6T˜DÐ!2Ñ3Ø# {Ñ2´zÀ+ÈhÑBWÔY]Ô7^Ø ŸK™K¨°HÑ(=Ô>ð ×)Ñ)¨$Ó/÷3	0ñ 	0øô. !ò Ùðú÷/	0ð 	0ús1   œC8FÄAFÅ-FÆ	FÆFÆFÆFÆFc                 óÌ   — |€|S t        |«      }	 | j                  |«      S # t        $ r8 |dd dk7  r‚ t        j	                  dd¬«       t        j                  |«      cY S w xY w)a_  Decode a value stored in the ``result`` column.

        Rows written before the fix for celery/celery#3025 always stored a
        raw pickle blob regardless of the configured ``result_serializer``,
        so a row that can't be decoded with the current serializer, but
        looks like a pickle payload (starts with the pickle protocol 2+
        marker that every pickle Celery/kombu produces starts with), is
        assumed to be one of those and is unpickled directly instead.
        Anything else re-raises the original decode error instead of
        blindly unpickling arbitrary bytes.
        Nr   ó   €z•Task result payload could not be decoded using the configured result_serializer; falling back to pickle for backward compatibility with pre-fix data.T)Úexc_info)r   r–   r   ÚloggerÚwarningÚpickleÚloads)rJ   Úpayloads     r   r•   z%DatabaseBackend._decode_stored_result  s{   € ð ˆ?ØˆNÜ˜wÓ'ˆð	)Ø—;‘;˜wÓ'Ð'øÜò 	)ð �r˜ˆ{˜gÒ%ØÜ�N‰Nð@ð ð	 ô ô —<‘< Ó(Ò(ð	)ús   ‘" ¢>A#Á"A#c                 ó<   — | j                  | j                  |¬«      S )ziCheck if a result exists in the database for the given task ID.

        .. versionadded:: 5.7.0
        )rl   )r`   Ú_task_result_exists)rJ   rl   s     r   Útask_result_existsz"DatabaseBackend.task_result_exists+  s'   € ð
 ×%Ñ%Ø×$Ñ$¨gð &ó 7ð 	7rQ   c                 ó  — | j                  «       }t        |«      5  |j                  | j                  «      j	                  | j                  j
                  |k(  «      j                  «       d ucd d d «       S # 1 sw Y   y xY wr   )ra   r    rg   r7   rk   rl   Úfirst©rJ   rl   r   s      r   r¦   z#DatabaseBackend._task_result_exists3  sh   € Ø×$Ñ$Ó&ˆÜ˜WÓ%ñ 	"Ø—=‘= §¡Ó/×6Ñ6Ø—‘×%Ñ%¨Ñ0óç‰e‹g˜Tð"÷	"÷ 	"ò 	"ús   œAA7Á7B c                 ó@  — | j                  «       }t        |«      5  t        | j                  | j	                  |«      «      «      }| j                  ||«      }|j                  |«       |j                  «        |j                  «        |cddd«       S # 1 sw Y   yxY w)z&Store the result of an executed group.N)	ra   r    r   rƒ   Úprepare_valuerA   rz   r{   r~   )rJ   Úgroup_idrT   r   r�   r,   s         r   Ú_save_groupzDatabaseBackend._save_group:  s   € à×$Ñ$Ó&ˆÜ˜WÓ%ñ 	Ü  §¡¨T×-?Ñ-?ÀÓ-GÓ!HÓIˆEØ×$Ñ$ X¨uÓ5ˆEØ�K‰K˜ÔØ�M‰MŒOØ�N‰NÔØ÷	÷ 	ò 	ús   œA.BÂBc                 ó   — | j                  «       }t        |«      5  |j                  | j                  «      j	                  | j                  j
                  |k(  «      j                  «       }|rL|j                  «       }| j                  |d   «      }|€|nt        || j                  «      |d<   |cddd«       S 	 ddd«       y# 1 sw Y   yxY w)zGet meta-data for group by id.rT   N)ra   r    rg   rA   rk   Ú
taskset_idr©   r”   r•   r
   r1   )rJ   r­   r   r,   rš   r�   s         r   Ú_restore_groupzDatabaseBackend._restore_groupE  s¾   € à×$Ñ$Ó&ˆÜ˜WÓ%ñ 		Ø—M‘M $×"2Ñ"2Ó3×:Ñ:Ø× Ñ ×+Ñ+¨xÑ7ó9ß9>¹»ð áØ—}‘}“�Ø×2Ñ2°4¸±>ÓB�à"˜]‘EÔ0AÀ%ÈÏÉÓ0Rð �X‘ð ÷		ñ 		ð ÷		÷ 		ñ 		ús   œBCÃCc                 óB  — | j                  «       }t        |«      5  |j                  | j                  «      j	                  | j                  j
                  |k(  «      j                  «        |j                  «        |j                  «        ddd«       y# 1 sw Y   yxY w)z!Delete meta-data for group by id.N)	ra   r    rg   rA   rk   r°   Údeleter{   r~   )rJ   r­   r   s      r   Ú_delete_groupzDatabaseBackend._delete_groupS  sx   € à×$Ñ$Ó&ˆÜ˜WÓ%ñ 	Ø�M‰M˜$×*Ñ*Ó+×2Ñ2Ø× Ñ ×+Ñ+¨xÑ7ó9ß9?¹¼Ø�M‰MŒOØ�N‰NÔ÷		÷ 	ñ 	ús   œA0BÂBc                 ó"  — | j                  «       }t        |«      5  |j                  | j                  «      j	                  | j                  j
                  |k(  «      j                  «        |j                  «        ddd«       y# 1 sw Y   yxY w)zForget about result.N)ra   r    rg   r7   rk   rl   r³   r~   rª   s      r   Ú_forgetzDatabaseBackend._forget\  sj   € à×$Ñ$Ó&ˆÜ˜WÓ%ñ 	Ø�M‰M˜$Ÿ-™-Ó(×/Ñ/°·±×0EÑ0EÈÑ0PÓQ×XÑXÔZØ�N‰NÔ÷	÷ 	ñ 	ús   œA BÂBc                 ó:   — | j                  | j                  «       y)zDelete expired meta-data.N)r`   Ú_cleanuprV   s    r   ÚcleanupzDatabaseBackend.cleanupc  s   € à×Ñ˜tŸ}™}Õ-rQ   c                 ó*  — | j                  «       }| j                  }t        j                  t        j
                  «      }t        |«      5  |j                  | j                  «      j                  | j                  j                  ||z
  k  «      j                  «        |j                  | j                  «      j                  | j                  j                  ||z
  k  «      j                  «        |j                  «        d d d «       y # 1 sw Y   y xY wr   )ra   Úexpiresr   Únowr   Úutcr    rg   r7   rk   Ú	date_doner³   rA   r~   )rJ   r   r»   r¼   s       r   r¸   zDatabaseBackend._cleanupg  sÆ   € Ø×$Ñ$Ó&ˆØ—,‘,ˆÜ�l‰lœ8Ÿ<™<Ó(ˆÜ˜WÓ%ñ 	Ø�M‰M˜$Ÿ-™-Ó(×/Ñ/Ø—‘×'Ñ'¨3°©=Ñ9ó;ß;A¹6¼8Ø�M‰M˜$×*Ñ*Ó+×2Ñ2Ø× Ñ ×*Ñ*¨c°G©mÑ<ó>ß>D¹f¼hØ�N‰NÔ÷	÷ 	ñ 	ús   ÁB5D	Ä	Dc                 ó–   •— |si n|}|j                  | j                  | j                  | j                  dœ«       t        ‰| �  ||«      S )N)rK   r»   r;   )r˜   r$   r»   r;   r/   Ú
__reduce__)rJ   r’   rL   rP   s      €r   rÀ   zDatabaseBackend.__reduce__r  sH   ø€ Ù!‘ vˆØ�‰Ø—h‘hØŸ™Ø#×2Ñ2ñ4ô	5ô ‰wÑ! $¨Ó/Ð/rQ   )NNNr   )F)NN)r.   N)Ú__name__Ú
__module__Ú__qualname__Ú__doc__Úsubpolling_intervalr   r7   r   rA   r0   Úpropertyr6   r[   r^   rI   ra   ru   r€   r}   rœ   r•   r§   r¦   r®   r±   r´   r¶   r¹   r¸   rÀ   Ú__classcell__)rP   s   @r   r   r   4   s¦   ø„ Ù&ð Ðà€HØ€Kõ<"ð| ñFó ðFò4ò2ò3ó#óð. ?CØ"óð< =AØ#ó&.òP0ò<)ò<7ò"ò	òòòò.ò	÷0ñ 0rQ   r   )-rÄ   Úloggingr¢   Ú
contextlibr   r   r   Úkombu.utils.encodingr   Úceleryr   Úcelery.backends.baser   Úcelery.exceptionsr	   Úcelery.resultr
   Úcelery.utils.importsr   Úcelery.utils.timer   Úmodelsr   r   r   r   r   Úsqlalchemy.excr   r   r   Úsqlalchemy.ormr   Úsqlalchemy.orm.attributesr   Úsqlalchemy.orm.excr   ÚImportErrorÚ	getLoggerrÁ   r    Ú__all__rX   r    r   r.   rQ   r   ú<module>rÙ      sº   ðÙ &Û Û Ý %ß 'å -å Ý ,Ý 2Ý +Ý /Ý -ç /Ñ /Ý #ð4ßQÑQÝ$Ý7Ý1ð 
ˆ×	Ñ	˜8Ó	$€à
€ð ØØØð	Ð ð ñó ðôD0�kõ D0øð9 ò 4Ù
ð	3ó4ð 4ð4ús   ÁB ÂB,