Ë
    ¼vëjl=  ã                  ó&  — U d Z ddlmZ ddlZddlmZmZ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mZ dd
lmZmZmZ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Z!dZ" G d„ de«      Z# G d„ d«      Z$ee%e&gdf   Z'de(d<   	 	 	 	 	 	 d#d„Z) ee)«      Z* G d„ de$«      Z+ee%e&gdf   Z,de(d<   	 	 	 	 	 	 d$d„Z- ee-«      Z. ej^                  d«      Z0	 d%	 	 	 	 	 	 	 d&d„Z1ejd                  ejf                  ejh                  d œZ5 G d!„ d"e$«      Z6y)'z&
Utility module to manipulate queries
é    )ÚannotationsN)ÚTYPE_CHECKINGÚAnyÚ
NamedTupleÚ	TypeAliasÚ	TypeGuard)Ú	lru_cache)ÚCallableÚMappingÚSequenceé   )Úerrors)ÚpqÚsql)ÚBufferÚParamsÚQueryÚQueryNoTemplate)ÚPyFormat)ÚTemplate)ÚTemplateProcessor)ÚTransformeri   é2   c                  ó,   — e Zd ZU ded<   ded<   ded<   y)Ú	QueryPartÚbytesÚprez	int | strÚitemr   ÚformatN)Ú__name__Ú
__module__Ú__qualname__Ú__annotations__© ó    úQ/var/www/html/strategist-ai/venv/lib/python3.12/site-packages/psycopg/_queries.pyr   r      s   … Ø	ƒJØ
ƒOØÔr%   r   c                  óŒ   — e Zd ZdZdj	                  «       Zdd„Zdd„Zdd„Ze	dd„«       Z
e		 	 	 	 	 	 	 	 dd„«       Zdd„Zdd	„Zy
)ÚPostgresQueryzO
    Helper to convert a Python query and parameters into Postgres format.
    z^
        query params types formats
        _tx _want_formats _parts _encoding _order
        c                ój   — || _         d | _        d| _        d | _        d | _        |  d| _        d | _        y )Nr$   r%   )Ú_txÚparamsÚtypesÚ_want_formatsÚformatsÚqueryÚ_order)ÚselfÚtransformers     r&   Ú__init__zPostgresQuery.__init__,   s9   € ØˆŒà6:ˆŒà&(ˆŒ
ð 59ˆÔØ37ˆŒáØˆŒ
Ø(,ˆ�r%   c                óŠ  — t        |t        «      r| j                  ||«      S | j                  |«      }|�ht	        |«      t
        k  rt	        |«      t        k  rt        }nt        } ||| j                  j                  «      \  | _        | _        | _        | _        n|| _        dx| _        | _        | j                  |«       y©zÄ
        Set up the query and parameters to convert.

        The results of this function can be obtained accessing the object
        attributes (`query`, `params`, `types`, `formats`).
        N)Ú
isinstancer   Ú_convert_templateÚ_ensure_bytesÚlenÚMAX_CACHED_STATEMENT_LENGTHÚMAX_CACHED_STATEMENT_PARAMSÚ	_query2pgÚ_query2pg_nocacher*   Úencodingr/   r-   r0   Ú_partsÚdump©r1   r/   ÚvarsÚfs       r&   ÚconvertzPostgresQuery.convert;   s¬   € ô �eœXÔ&Ø×)Ñ)¨%°Ó6Ð6à×"Ñ" 5Ó)ˆàÐô �E“
Ô9Ò9Ü˜“IÔ!<Ò<ä(‘ä%�áGHØ�t—x‘x×(Ñ(óHÑDˆDŒJ˜Ô*¨D¬K¸½ð ˆDŒJØ/3Ð3ˆDÔ ¤à�	‰	�$�r%   c                óh  — |�›| j                  | j                  || j                  «      }| j                  €J ‚| j                  j                  || j                  «      | _        | j                  j                  xs d| _        | j                  j                  | _        yd| _        d| _        d| _        y)úŠ
        Process a new set of variables on the query processed by `convert()`.

        This method updates `params` and `types`.
        Nr$   )	Úvalidate_and_reorder_paramsr?   r0   r-   r*   Údump_sequencer+   r,   r.   ©r1   rB   r+   s      r&   r@   zPostgresQuery.dump^   s�   € ð ÐØ×5Ñ5°d·k±kÀ4ÈÏÉÓUˆFØ×%Ñ%Ð1Ð1Ð1ØŸ(™(×0Ñ0°¸×9KÑ9KÓLˆDŒKØŸ™Ÿ™Ò-¨2ˆDŒJØŸ8™8×+Ñ+ˆD�LàˆDŒKØˆDŒJØˆD�Lr%   c                ó  — t        | «      }|t        u s|t        u rd}|S |t        u rd}|S t	        | t
        «      rt	        | t        t        f«      sd}|S t	        | t        «      rd}|S t        dt        | «      j                  › �«      ‚)NTFz8query parameters should be a sequence or a mapping, got )ÚtypeÚlistÚtupleÚdictr6   r   r   Ústrr   Ú	TypeErrorr"   )rB   ÚtÚsequences      r&   Úis_params_sequencez PostgresQuery.is_params_sequenceo   s¡   € ô �‹JˆØ”‰9˜œU™
ØˆHð ˆð ”$‰YØˆHð ˆô ˜œhÔ'´
¸4Ä%ÌÀÔ0NØˆHð ˆô ˜œgÔ&ØˆHð ˆô	 ðÜ˜T›
×/Ñ/Ð0ð2óð r%   c                óJ  ‡— t         j                  ‰«      rwt        ‰«      t        | «      dz
  k7  r1t        j                  dt        | «      dz
  › dt        ‰«      › d�«      ‚‰r(t        | d   j                  t        «      st        d«      ‚‰S ‰r/t        | «      dkD  r!t        | d   d   t        «      st        d«      ‚	 |r|D �cg c]  }‰|   ‘Œ	 c}S yc c}w # t        $ r> t        j                  d	d
j                  t        ˆfd„|xs dD «       «      «      › �«      ‚w xY w)zO
        Verify the compatibility between a query and a set of params.
        r   zthe query has z placeholders but z parameters were passedr   z2named placeholders require a mapping of parametersz=positional placeholders (%s) require a sequence of parametersr$   zquery parameter missing: z, c              3  ó,   •K  — | ]  }|‰vsŒ|–— Œ y ­w©Nr$   )Ú.0ÚirB   s     €r&   ú	<genexpr>z<PostgresQuery.validate_and_reorder_params.<locals>.<genexpr>¢   s   øè ø€ Ò(Q¨qÀ1ÈDÂ=¬Ñ(Qùs   ƒ	�)r(   rS   r9   ÚeÚProgrammingErrorr6   r   ÚintrP   rO   ÚKeyErrorÚjoinÚsorted)ÚpartsrB   Úorderr   s    `  r&   rG   z)PostgresQuery.validate_and_reorder_params‚   s)  ø€ ô ×+Ñ+¨DÔ1Ü�4‹yœC ›J¨™NÒ*Ü×(Ñ(Ø$¤S¨£Z°!¡^Ð$4ð 5Ü˜D›	�{Ð"9ð;óð ñ œJ u¨Q¡x§}¡}´cÔ:ÜÐ TÓUÐUØˆKñ œ˜E›
 Qš¬z¸%À¹(À1¹+ÄsÔ/KÜØSóð ð
ÙØ38Ö9¨4˜D ›JÒ9Ð9àùò :øô ò Ü×(Ñ(ðØŸ	™	¤&Ó(Q°E²K¸RÔ(QÓ"QÓRÐSðUóð ðús   Ã C ÃCÃC ÃC ÃAD"c                óÚ   — t        |t        «      r%|j                  | j                  j                  «      S t        |t
        j                  «      r|j                  | j                  «      S |S rV   )r6   rO   Úencoder*   r>   r   Ú
ComposableÚas_bytes)r1   r/   s     r&   r8   zPostgresQuery._ensure_bytes¥   sK   € Ü�eœSÔ!Ø—<‘< §¡× 1Ñ 1Ó2Ð2Ü˜œsŸ~™~Ô.Ø—>‘> $§(¡(Ó+Ð+àˆLr%   c                ó²  — |�t        d«      ‚t        |d| j                  ¬«      }|j                  «        |j                  | _        |j
                  rp| j                  j                  |j
                  |j                  «      | _        | j                  j                  xs d| _        | j                  j                  | _        y d | _        d| _        d | _        y )NúA'execute()' with string template query doesn't support parametersT©Úserver_paramsÚtxr$   )	rP   r   r*   Úprocessr/   r+   rH   r.   r,   ©r1   r/   rB   Útps       r&   r7   zPostgresQuery._convert_template­   s¡   € ØÐÜØSóð ô ˜u°D¸T¿X¹XÔFˆØ
�
‰
ŒØ—X‘XˆŒ
Ø�9Š9ØŸ(™(×0Ñ0°·±¸B¿J¹JÓGˆDŒKØŸ™Ÿ™Ò-¨2ˆDŒJØŸ8™8×+Ñ+ˆD�LàˆDŒKØˆDŒJØˆD�Lr%   N)r2   r   ©r/   r   rB   úParams | NoneÚreturnÚNone©rB   ro   rp   rq   )rB   r   rp   zTypeGuard[Sequence[Any]])r`   úlist[QueryPart]rB   r   ra   zlist[str] | Nonerp   zSequence[Any])r/   r   rp   r   ©r/   r   rB   ro   rp   rq   )r    r!   r"   Ú__doc__ÚsplitÚ	__slots__r3   rD   r@   ÚstaticmethodrS   rG   r8   r7   r$   r%   r&   r(   r(   "   s}   „ ñð÷ ‰E‹Gð ó
-ó!óF ð" òó ðð$ ð Øð Ø&,ð Ø5Eð à	ò ó ð óDô r%   r(   ú?tuple[bytes, list[PyFormat], list[str] | None, list[QueryPart]]r   Ú	_Query2Pgc                óX  — t        | |«      }d}g }g }t        |d   j                  t        «      r|dd D ]u  }t        |j                  t        «      sJ ‚|j	                  |j
                  «       |j	                  d|j                  dz   z  «       |j	                  |j                  «       Œw �nJt        |d   j                  t        «      �r,i }g }|dd D �]  }t        |j                  t        «      sJ ‚|j	                  |j
                  «       |j                  |vrtdt        |«      dz   z  }||j                  f||j                  <   |j	                  |j                  «       |j	                  |«       |j	                  |j                  «       Œ½||j                     d   |j                  k7  r#t        j                  d|j                  › d�«      ‚|j	                  ||j                     d   «       �Œ" |j	                  |d   j
                  «       dj                  |«      |||fS )	aº  
    Convert Python query and params into something Postgres understands.

    - Convert Python placeholders (``%s``, ``%(name)s``) into Postgres
      format (``$1``, ``$2``)
    - placeholders can be %s, %t, or %b (auto, text or binary)
    - return ``query`` (bytes), ``formats`` (list of formats) ``order``
      (sequence of names used in the query, in the position they appear)
      ``parts`` (splits of queries and placeholders).
    Nr   éÿÿÿÿs   $%dr   zplaceholder 'z' cannot have different formatsr%   )Ú_split_queryr6   r   r\   Úappendr   r   rO   r9   rZ   r[   r^   )	r/   r>   r`   ra   Úchunksr.   ÚpartÚseenÚphs	            r&   r=   r=   Æ   sÐ  € ô ˜ Ó)€EØ"€EØ€FØ€Gä�%˜‘(—-‘-¤Ô%Ø˜#˜2�Jò 	(ˆDÜ˜dŸi™i¬Ô-Ð-Ð-Ø�M‰M˜$Ÿ(™(Ô#Ø�M‰M˜& D§I¡I°¡MÑ2Ô3Ø�N‰N˜4Ÿ;™;Õ'ò		(ô 
�E˜!‘H—M‘M¤3Õ	'Ø24ˆØˆØ˜#˜2�Jó 	2ˆDÜ˜dŸi™i¬Ô-Ð-Ð-Ø�M‰M˜$Ÿ(™(Ô#Ø�y‰y Ñ$Øœs 4›y¨1™}Ñ-�Ø#% t§{¡{Ð"3��T—Y‘Y‘Ø—‘˜TŸY™YÔ'Ø—‘˜bÔ!Ø—‘˜tŸ{™{Õ+à˜Ÿ	™	‘? 1Ñ%¨¯©Ò4Ü×,Ñ,Ø'¨¯	©	 {Ð2QÐRóð ð —‘˜d 4§9¡9™o¨aÑ0Ö1ð	2ð" ‡M�M�%˜‘)—-‘-Ô à�8‰8�FÓ˜W e¨UÐ2Ð2r%   c                  ó,   — e Zd ZdZdZdd„Zdd„Zd	d„Zy)
ÚPostgresClientQueryzI
    PostgresQuery subclass merging query and arguments client-side.
    )Útemplatec                óp  — t        |t        «      r| j                  ||«      S | j                  |«      }|�bt	        |«      t
        k  rt	        |«      t        k  rt        }nt        } ||| j                  j                  «      \  | _        | _        | _        n|| _        d| _        | j                  |«       yr5   )r6   r   r7   r8   r9   r:   r;   Ú_query2pg_clientÚ_query2pg_client_nocacher*   r>   r…   r0   r?   r/   r@   rA   s       r&   rD   zPostgresClientQuery.convert  s—   € ô �eœXÔ&Ø×)Ñ)¨%°Ó6Ð6à×"Ñ" 5Ó)ˆàÐä�E“
Ô9Ò9Ü˜“IÔ!<Ò<ä%5‘ä,�á67¸¸t¿x¹x×?PÑ?PÓ6QÑ3ˆDŒM˜4œ;¨­àˆDŒJØˆDŒKà�	‰	�$�r%   c                óÖ   ‡ — |�_‰ j                  ‰ j                  |‰ j                  «      }t        ˆ fd„|D «       «      ‰ _        ‰ j
                  ‰ j                  z  ‰ _        yd‰ _        y)rF   Nc              3  ó\   •K  — | ]#  }|�‰j                   j                  |«      nd–— Œ% y ­w)Ns   NULL)r*   Ú
as_literal)rW   Úpr1   s     €r&   rY   z+PostgresClientQuery.dump.<locals>.<genexpr>+  s.   øè ø€ ò  ØIJ¨!¨-�—‘×#Ñ# AÔ&¸WÓDñ ùs   ƒ),)rG   r?   r0   rM   r+   r…   r/   rI   s   `  r&   r@   zPostgresClientQuery.dump#  s]   ø€ ð ÐØ×5Ñ5°d·k±kÀ4ÈÏÉÓUˆFÜó  ØNTô ó ˆDŒKð Ÿ™¨¯©Ñ4ˆD�JàˆD�Kr%   c                ó²   — |�t        d«      ‚t        |d| j                  ¬«      }|j                  «        |j                  | _        |j
                  | _        y )Nrg   Frh   )rP   r   r*   rk   r/   r+   rl   s       r&   r7   z%PostgresClientQuery._convert_template2  sK   € ØÐÜØSóð ô ˜u°E¸d¿h¹hÔGˆØ
�
‰
ŒØ—X‘XˆŒ
Ø—i‘iˆ�r%   Nrn   rr   rt   )r    r!   r"   ru   rw   rD   r@   r7   r$   r%   r&   r„   r„      s   „ ñð €Ióó8ô	 r%   r„   ú/tuple[bytes, list[str] | None, list[QueryPart]]Ú_Query2PgClientc                óV  — t        | |d¬«      }d}g }t        |d   j                  t        «      rS|dd D ]J  }t        |j                  t        «      sJ ‚|j	                  |j
                  «       |j	                  d«       ŒL nöt        |d   j                  t        «      rÙi }g }|dd D ]Í  }t        |j                  t        «      sJ ‚|j	                  |j
                  «       |j                  |vrJd}||j                  f||j                  <   |j	                  |j                  «       |j	                  |«       Œ’|j	                  ||j                     d   «       |j	                  |j                  «       ŒÏ |j	                  |d   j
                  «       dj                  |«      ||fS )zX
    Convert Python query and params into a template to perform client-side binding
    F)Úcollapse_double_percentNr   r|   s   %sr%   )	r}   r6   r   r\   r~   r   rO   r   r^   )r/   r>   r`   ra   r   r€   r�   r‚   s           r&   rˆ   rˆ   C  sb  € ô ˜ À%ÔH€EØ"€EØ€Fä�%˜‘(—-‘-¤Ô%Ø˜#˜2�Jò 	!ˆDÜ˜dŸi™i¬Ô-Ð-Ð-Ø�M‰M˜$Ÿ(™(Ô#Ø�M‰M˜%Õ ñ	!ô
 
�E˜!‘H—M‘M¤3Ô	'Ø24ˆØˆØ˜#˜2�Jò 
	(ˆDÜ˜dŸi™i¬Ô-Ð-Ð-Ø�M‰M˜$Ÿ(™(Ô#Ø�y‰y Ñ$Ø�Ø#% t§{¡{Ð"3��T—Y‘Y‘Ø—‘˜TŸY™YÔ'Ø—‘˜bÕ!à—‘˜d 4§9¡9™o¨aÑ0Ô1Ø—‘˜TŸY™YÕ'ð
	(ð ‡M�M�%˜‘)—-‘-Ô à�8‰8�FÓ˜U EÐ)Ð)r%   s"  (?x)
        %                       # a literal %
        (?:
            (?:
                \( ([^)]+) \)   # or a name in (braces)
                .               # followed by a format
            )
            |
            (?:.)               # or any char, really
        )
        c                óº  — g }d}d }t         j                  | «      D ]@  }| ||j                  d«      d    }|j                  ||f«       |j                  d«      d   }ŒB |r|j                  | |d  d f«       n|j                  | d f«       g }d}d }	|t	        |«      k  �r»||   \  }}|€-|j                  t        |dt        j                  «      «       	 |S |j                  d«      x}
dk(  r#|rd}
||dz      \  }}||
z   |z   |f||dz   <   ||= Œ|
dk(  rNt        j                  d| |j                  d«      d   d  j                  «       d   j                  |«      › d�«      ‚|
dk(  rt        j                  d	«      ‚|
d
d  dvr7t        j                  d|j                  d«      j                  |«      › d�«      ‚|j                  d«      r |j                  d«      j                  |«      n|}|	st        |«      }	n"|	t        |«      urt        j                  d«      ‚t        |
d
d     }|j                  t        |||«      «       |dz  }|t	        |«      k  r�Œ»|S )Nr   r   s   %%ó   %s   %(zincomplete placeholder: 'ú's   % zfincomplete placeholder: '%'; if you want to use '%' as an operator you can double it up, i.e. use '%%'r|   s   sbtz8only '%s', '%b', '%t' are allowed as placeholders, got 'z1positional and named placeholders cannot be mixed)Ú_re_placeholderÚfinditerÚspanr~   r9   r   r   ÚAUTOÚgrouprZ   r[   rv   ÚdecoderK   Ú
_ph_to_fmt)r/   r>   r‘   r`   ÚcurÚmr   ÚrvrX   Úphtyper‚   Úpre1Úm1r   r   s                  r&   r}   r}   x  s˜  € ð 9;€EØ
€Cð 	€AÜ×%Ñ% eÓ,ò ˆØ�C˜!Ÿ&™& ›) A™,Ð'ˆØ�‰�c˜1�XÔØ�f‰f�Q‹i˜‰l‰ðñ 	Ø�‰�e˜C˜D�k 4Ð(Õ)à�‰�e˜T�]Ô#à	€Bð 	
€AØ€FØ
Œc�%‹j‹.Ø�q‘‰ˆˆQØˆ9à�I‰I”i  Q¬¯©Ó6Ô7ØðV €IðS —'‘'˜!“*ÐˆB Ò&á&Ø�Ø˜Q ™U‘|‰HˆD�"Ø "™H t™O¨RÐ0ˆE�!�a‘%‰LØ�a�Øà�Š;Ü×$Ñ$ðØ˜1Ÿ6™6 !›9 Q™<˜=Ð)×/Ñ/Ó1°!Ñ4×;Ñ;¸HÓEÐFÀaðIóð ð �5Š[ä×$Ñ$ð@óð ð ��ˆW˜FÑ"Ü×$Ñ$ðØ—W‘W˜Q“Z×&Ñ& xÓ0Ð1°ð4óð ð /0¯g©g°a¬jˆq�w‰w�q‹z× Ñ  Ô*¸aˆáÜ˜$“Z‰FØœ4 ›:Ñ%Ü×$Ñ$ØCóð ô ˜B˜r˜s˜GÑ$ˆØ
�	‰	”)˜C  vÓ.Ô/Ø	ˆQ‰ˆð] Œc�%‹jŒ.ð` €Ir%   )ó   só   tó   bc                  ó$   — e Zd Zdd„Zdd„Zdd„Zy)ÚPostgresRawQueryc                ó²   — t        |t        «      r| j                  ||«      S | j                  |«      | _        d x| _        | _        | j                  |«       y rV   )r6   r   r7   r8   r/   r-   r0   r@   ©r1   r/   rB   s      r&   rD   zPostgresRawQuery.convertÉ  sK   € Ü�eœXÔ&Ø×)Ñ)¨%°Ó6Ð6à×'Ñ'¨Ó.ˆŒ
Ø+/Ð/ˆÔ˜Tœ[Ø�	‰	�$�r%   c                ó‚  — |�¨t         j                  |«      st        d«      ‚t        j                  gt        |«      z  | _        | j                  j                  || j                  «      | _	        | j                  j                  xs d| _
        | j                  j                  | _        y d | _	        d| _
        d | _        y )Nz,raw queries require a sequence of parametersr$   )r(   rS   rP   r   r˜   r9   r-   r*   rH   r+   r,   r.   )r1   rB   s     r&   r@   zPostgresRawQuery.dumpÑ  s‘   € ØÐÜ ×3Ñ3°DÔ9ÜÐ NÓOÐOÜ"*§-¡- ´3°t³9Ñ!<ˆDÔàŸ(™(×0Ñ0°°t×7IÑ7IÓJˆDŒKØŸ™Ÿ™Ò-¨2ˆDŒJØŸ8™8×+Ñ+ˆD�LàˆDŒKØˆDŒJØˆD�Lr%   c                óX   — t        j                  t        | «      j                  › d�«      ‚)Nz! doesn't support template strings)rZ   ÚNotSupportedErrorrK   r    r¨   s      r&   r7   z"PostgresRawQuery._convert_templateß  s+   € Ü×!Ñ!Ü�D‹z×"Ñ"Ð#Ð#DÐEó
ð 	
r%   Nrn   rr   rt   )r    r!   r"   rD   r@   r7   r$   r%   r&   r¦   r¦   È  s   „ óó ô
r%   r¦   )r/   r   r>   rO   rp   ry   )r/   r   r>   rO   rp   rŽ   )ÚasciiT)r/   r   r>   rO   r‘   Úboolrp   rs   )7ru   Ú
__future__r   ÚreÚtypingr   r   r   r   r   Ú	functoolsr	   Úcollections.abcr
   r   r   Ú r   rZ   r   r   Úabcr   r   r   r   Ú_enumsr   Ú_compatr   Ú	_tstringsr   r   r:   r;   r   r(   r   rO   rz   r#   r=   r<   r„   r�   rˆ   r‡   Úcompiler•   r}   r˜   ÚTEXTÚBINARYr›   r¦   r$   r%   r&   ú<module>r»      sx  ðòõ #ã 	ß GÕ GÝ ß 7Ñ 7å ß ß 7Ó 7Ý Ý Ý (áÝ à"Ð Ø Ð ô�
ô ÷[ ñ [ ð~  Ø
ˆC€LÐSÐSñ€	ˆ9ó ð
/3Øð/3Øð/3àDó/3ñn Ð'Ó(€	ô; ˜-ô ; ð| &Ø
ˆC€LÐCÐCñ€�ó ð
"*Øð"*Øð"*à4ó"*ñJ Ð5Ó6Ð ð �"—*‘*ð 
ó 
€ð LPðFØðFØðFØDHðFàóFðT �-‰-Ø
�-‰-Ø
�/‰/ñ€
ô
�}õ 
r%   