Ë
    ¼vëjþ  ã                  óB  — U d Z ddlmZ ddlZddlmZmZ ddlmZm	Z	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 erddlmZ ddlmZ eeeedf   f   Zded<   ej>                  j@                  Z ej>                  jB                  Z! G d„ de«      Z" G d„ d«      Z#y)z!
Support for prepared statements
é    )ÚannotationsN)ÚIntEnumÚauto)ÚTYPE_CHECKINGÚAnyÚ	TypeAlias)ÚOrderedDictÚdeque)ÚSequenceé   )Úpq)ÚPQGen)ÚPostgresQuery)ÚPGresult)ÚBaseConnection.r   ÚKeyc                  ó6   — e Zd Z e«       Z e«       Z e«       Zy)ÚPrepareN)Ú__name__Ú
__module__Ú__qualname__r   ÚNOÚYESÚSHOULD© ó    úS/var/www/html/strategist-ai/venv/lib/python3.12/site-packages/psycopg/_preparing.pyr   r      s   „ Ù	‹€BÙ
‹&€CÙ‹V�Fr   r   c                  ó  — e Zd ZU dZded<   dZded<   dd„Zedd„«       Z	 d	 	 	 	 	 dd
„Z	 e
j                  d«      j                  f	 	 	 	 	 	 	 dd„Zedd„«       Zdd„Z	 	 	 	 	 	 	 	 dd„Z	 	 	 	 	 	 	 	 	 	 dd„Zdd„Zdd„Zy	)ÚPrepareManageré   z
int | NoneÚprepare_thresholdéd   ÚintÚprepared_maxc                ó€   — t        «       | _        t        «       | _        d| _        t	        t
        d z     «       | _        y )Nr   )r	   Ú_countsÚ_namesÚ_prepared_idxr
   ÚbytesÚ	_to_flush©Úselfs    r   Ú__init__zPrepareManager.__init__*   s3   € ä.9«mˆŒô 0;«}ˆŒð ˆÔäœu t™|Ñ,Ó.ˆ�r   c                ó2   — | j                   | j                  fS ©N)ÚqueryÚtypes)r0   s    r   ÚkeyzPrepareManager.key6   s   € à—‘˜UŸ[™[Ð)Ð)r   Nc                óÌ  — |du s| j                   €t        j                  dfS | j                  j	                  | j                  |«      x}«      x}rt        j                  |fS | j                  j	                  |d«      }|| j                   k\  s|rDd| j                  › �j                  «       }| xj                  dz  c_        t        j                  |fS t        j                  dfS )zP
        Check if a query is prepared, tell back whether to prepare it.
        Fr   r   Ú_pg3_r   )r!   r   r   r'   Úgetr2   r   r&   r(   Úencoder   )r,   r0   Úpreparer2   ÚnameÚcounts         r   r5   zPrepareManager.get:   sË   € ð �eÑ˜t×5Ñ5Ð=ä—:‘:˜s�?Ð"à—;‘;—?‘?¨$¯(©(°5«/Ð#9 3Ó:Ð:ˆ4Ð:ä—;‘; Ð$Ð$à—‘× Ñ   aÓ(ˆØ�D×*Ñ*Ò*©gà˜4×-Ñ-Ð.Ð/×6Ñ6Ó8ˆDØ×Ò !Ñ#ÕÜ—>‘> 4Ð'Ð'ô —:‘:˜s�?Ð"r   s5   ^(?:DROP|ALTER|ROLLBACK|DISCARD ALL|DEALLOCATE ALL)\bc                óÊ   — | j                   s|t        j                  k(  rD|D ]?  }|j                  t        k7  rŒ|j
                  x}sŒ& ||«      sŒ/| j                  «       c S  y)zÏCheck if we need to discard our entire state: it should happen on
        rollback or on dropping objects, because the same object may get
        recreated and postgres would fail internal lookups.
        F)r'   r   r   ÚstatusÚ
COMMAND_OKÚcommand_statusÚclear)r,   ÚprepÚresultsÚ_PrepareManager__should_clearÚresultÚcmdstats         r   Ú_should_discardzPrepareManager._should_discardR   s]   € ð �;Š;˜$¤'§.¡.Ò0Ø!ò (�Ø—=‘=¤JÒ.ØØ%×4Ñ4Ð4�GÑ4¹.ÈÕ:QØŸ:™:›<Ò'ð	(ð
 r   c                óh   — t        | «      dk7  ryt        | d   j                  cxk7  r	t        k7  ry yy)zCReturn False if 'results' are invalid for prepared statement cache.r   Fr   T)Úlenr<   r;   Ú	TUPLES_OK)r@   s    r   Ú_check_resultszPrepareManager._check_resultsf   s7   € ô ˆw‹<˜1Òàä˜ ™×*Ñ*Ô7¬iÒ7àð 8ñ r   c                ó:  — t        | j                  «      | j                  kD  r| j                  j                  d¬«       t        | j                  «      | j                  kD  r;| j                  j                  d¬«      d   }| j
                  j                  |«       yy)z Evict an old value from the cache.

        If it was prepared, deallocate it. Do it only once: if the cache was
        resized, deallocate gradually.
        F)Úlastr   N)rF   r&   r$   Úpopitemr'   r*   Úappend)r,   r8   s     r   Ú_rotatezPrepareManager._rotates   sz   € ô ˆt�|‰|Ó˜t×0Ñ0Ò0Ø�L‰L× Ñ  eÐ Ô,äˆt�{‰{Ó˜d×/Ñ/Ò/Ø—;‘;×&Ñ&¨EÐ&Ó2°1Ñ5ˆDØ�N‰N×!Ñ! $Õ'ð 0r   c                óÚ  — | j                   €y| j                  |«      x}| j                  v rb|t        j                  u r| j                  |= || j
                  |<   y| j                  |xx   dz  cc<   | j                  j                  |«       y|| j
                  v r| j
                  j                  |«       y|t        j                  u r|| j
                  |<   |S d| j                  |<   |S )zÒHandle 'query' for possible addition to the cache.

        If a new entry has been added, return its key. Return None otherwise
        (meaning the query is already in cache or cache is not enabled).
        Nr   )r!   r2   r&   r   r   r'   Úmove_to_end)r,   r0   r?   r8   r2   s        r   Úmaybe_add_to_cachez!PrepareManager.maybe_add_to_cache€   sÛ   € ð ×!Ñ!Ð)Øà—8‘8˜E“?Ð"ˆC t§|¡|Ñ3Ø”w—~‘~Ñ%Ø—L‘L Ð%Ø#'�—‘˜CÑ ð ð —‘˜SÓ! QÑ&Ó!Ø—‘×(Ñ(¨Ô-Øà�D—K‘KÑØ�K‰K×#Ñ# CÔ(Øð ”w—~‘~Ñ%Ø#'�—‘˜CÑ ð ˆJð %&�—‘˜SÑ!ØˆJr   c                óÞ   — | j                  ||«      ry| j                  |«      s9| j                  j                  |d«       | j                  j                  |d«       y| j                  «        y)z’Validate cached entry with 'key' by checking query 'results'.

        Possibly record a command to perform maintenance on database side.
        N)rD   rH   r'   Úpopr&   rM   )r,   r2   r?   r8   r@   s        r   ÚvalidatezPrepareManager.validate    sT   € ð ×Ñ  gÔ.Øà×"Ñ" 7Ô+Ø�K‰K�O‰O˜C Ô&Ø�L‰L×Ñ˜S $Õ'à�L‰L�Nr   c                óð   — | j                   j                  «        | j                  rP| j                  j                  «        | j                  j                  «        | j                  j	                  d«       yy)z—Clear the cache of the maintenance commands.

        Clear the internal state and prepare a command to clear the state of
        the server.
        NTF)r&   r>   r'   r*   rL   r+   s    r   r>   zPrepareManager.clear°   sS   € ð 	�‰×ÑÔØ�;Š;Ø�K‰K×ÑÔØ�N‰N× Ñ Ô"Ø�N‰N×!Ñ! $Ô'Øàr   c              #  óª   K  — | j                   rA| j                   j                  «       }|j                  |«      E d{  –—†  | j                   rŒ@yy7 Œ­w)zÑ
        Generator to send the commands to perform periodic maintenance

        Deallocate unneeded command in the server, or flush the prepared
        statements server state entirely if necessary.
        N)r*   ÚpopleftÚ_deallocate)r,   Úconnr8   s      r   Úmaintain_genzPrepareManager.maintain_gen¿   sA   è ø€ ð �nŠnØ—>‘>×)Ñ)Ó+ˆDØ×'Ñ'¨Ó-×-Ð-ð �n�nà-ús   ‚;A½A¾AÁA)ÚreturnÚNone)r0   r   rZ   r   r/   )r0   r   r7   zbool | NonerZ   ztuple[Prepare, bytes])r?   r   r@   úSequence[PGresult]rA   r   rZ   Úbool)r@   r\   rZ   r]   )r0   r   r?   r   r8   r)   rZ   z
Key | None)
r2   r   r?   r   r8   r)   r@   r\   rZ   r[   )rZ   r]   )rX   zBaseConnection[Any]rZ   zPQGen[None])r   r   r   r!   Ú__annotations__r$   r-   Ústaticmethodr2   r5   ÚreÚcompileÚmatchrD   rH   rM   rP   rS   r>   rY   r   r   r   r   r   #   s  … à$%Ð�zÓ%ð €L�#Óó
/ð ò*ó ð*ð <@ð#Ø"ð#Ø-8ð#à	ó#ð8 )˜bŸj™jØEó
ç
‰%ðàðð $ðð ð	ð 
óð( ò
ó ð
ó(ðØ"ðØ*1ðØ9>ðà	óð@ØðØ%ðØ-2ðØ=Oðà	óó ô	.r   r   )$Ú__doc__Ú
__future__r   r`   Úenumr   r   Útypingr   r   r   Úcollectionsr	   r
   Úcollections.abcr   Ú r   Úabcr   Ú_queriesr   Úpq.abcr   Ú_connection_baser   Útupler)   r#   r   r^   Ú
ExecStatusr<   rG   r   r   r   r   r   ú<module>rp      s…   ðòõ #ã 	ß ß 0Ñ 0ß *Ý $å Ý Ý #áÝ Ý0à�u˜e C¨ H™oÐ-Ñ.€€YÓ .à�]‰]×%Ñ%€
Ø�M‰M×#Ñ#€	ôˆgô ÷e.ò e.r   