Ë
    ¼vëjè7  ã                  ó¬  — d Z ddlmZ ddlZddl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 ddlmZ dd	lmZ dd
l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 ej@                  jB                  Z"ej@                  jF                  Z$ejJ                  jB                  Z!ejJ                  jF                  Z#ejL                  jN                  Z'ejL                  jP                  Z(dZ)de)z  Z*dZ+ejX                  dk(  Z- G d„ dee   «      Z. G d„ de«      Z/ G d„ de/«      Z0 G d„ de/«      Z1d1d„Z2d1d„Z3d2d„Z4d2d„Z5 ejl                  d «      jn                  Z8 ejl                  d!«      jn                  Z9 ejl                  d «      jt                  Z; ejl                  d!«      jt                  Z<d"Z=d#Z>d$Z? ej€                  d%«      ZAd&d'd(d)d*d+d,d-œZBeBfd3d.„ZC ej€                  d/«      ZDeBj‹                  «       D � �ci c]  \  } }|| “Œ
 c}} ZFeFfd3d0„ZGer1ej�                  ZHej’                  ZIej”                  ZJej–                  ZKye2ZHe3ZIe4ZJe5ZKyc c}} w )4z
psycopg copy support
é    )ÚannotationsN)ÚABCÚabstractmethod)ÚTYPE_CHECKINGÚAnyÚGeneric)ÚSequenceé   )Úadapt)Úerrors)Úpq)ÚBufferÚConnectionTypeÚPQGenÚTransformer)Úconnection_summary)Ú_psycopg)Ú	copy_from)Ú
BaseCursori €  é   i   Údarwinc                  ó`   — e Zd ZU dZded<   ddœ	 	 	 dd„Zdd„Zdd„Zdd	„Zdd
„Z	dd„Z
dd„Zy)ÚBaseCopyaõ  
    Base implementation for the copy user interface.

    Two subclasses expose real methods with the sync/async differences.

    The difference between the text and binary format is managed by two
    different `Formatter` subclasses.

    Writing (the I/O part) is implemented in the subclasses by a `Writer` or
    `AsyncWriter` instance. Normally writing implies sending copy data to a
    database, but a different writer might be chosen, e.g. to stream data into
    a file for later use.
    Ú	FormatterÚ	formatterN)Úbinaryc               ó–  — || _         |j                  | _        | j                  j                  | _        |j                  x}rw|j
                  | _        | j                  t        k7  r^| j                  t        k7  rKt        j                  dt        j                  | j                  «      j                  › d�«      ‚t        | _        |€t        |xr |j                  «      }t!        |dd «      xs t#        j$                  |«      }|rt'        |«      | _        d| _        y t+        || j                  j,                  ¬«      | _        d| _        y )NzAthe cursor should have performed a COPY operation; its status is z insteadÚ_tx)ÚencodingF)ÚcursorÚ
connectionÚpgconnÚ_pgconnÚpgresultÚstatusÚ
_directionÚCOPY_INÚCOPY_OUTÚeÚProgrammingErrorr   Ú
ExecStatusÚnameÚboolÚbinary_tuplesÚgetattrr   r   ÚBinaryFormatterr   ÚTextFormatterÚ	_encodingÚ	_finished)Úselfr    r   ÚresultÚtxs        úS/var/www/html/strategist-ai/venv/lib/python3.12/site-packages/psycopg/_copy_base.pyÚ__init__zBaseCopy.__init__L   s  € ð ˆŒØ ×+Ñ+ˆŒØ—‘×-Ñ-ˆŒà—_‘_Ð$ˆ6Ð$Ø$Ÿm™mˆDŒOØ�‰¤'Ò)¨d¯o©oÄÒ.IÜ×(Ñ(ð&Ü&(§m¡m°D·O±OÓ&D×&IÑ&IÐ%JÈ(ðTóð ô
 &ˆDŒOàˆ>Ü˜&Ò9 V×%9Ñ%9Ó:ˆFä! &¨%°Ó6ÒS¼%×:KÑ:KÈFÓ:SˆÙÜ,¨RÓ0ˆDŒNð ˆ�ô +¨2¸¿¹×8NÑ8NÔOˆDŒNàˆ�ó    c                ó¶   — | j                   j                  › d| j                   j                  › �}t        | j                  «      }d|› d|› dt        | «      d›d�S )Nú.ú<ú z at 0xÚxú>)Ú	__class__Ú
__module__Ú__qualname__r   r#   Úid)r4   ÚclsÚinfos      r7   Ú__repr__zBaseCopy.__repr__h   sW   € Ø—‘×*Ñ*Ð+¨1¨T¯^©^×-HÑ-HÐ,IÐJˆÜ! $§,¡,Ó/ˆØ�3�%�q˜˜˜f¤R¨£X¨a L°Ð2Ð2r9   c                ó2   — | j                   rt        d«      ‚y )Nz!copy blocks can be used only once)r3   Ú	TypeError©r4   s    r7   Ú_enterzBaseCopy._enterm   s   € Ø�>Š>ÜÐ?Ó@Ð@ð r9   c                ó¾  — | j                   j                  j                  }|D �cg c]%  }t        |t        «      r|n|j                  |«      ‘Œ' }}| j                  t        k(  r;| j                  j                  j                  || j                  j                  «       y| j                  j                  j                  || j                  j                  «       yc c}w )aá  
        Set the types expected in a COPY operation.

        The types must be specified as a sequence of oid or PostgreSQL type
        names (e.g. ``int4``, ``timestamptz[]``).

        This operation overcomes the lack of metadata returned by PostgreSQL
        when a COPY operation begins:

        - On :sql:`COPY TO`, `!set_types()` allows to specify what types the
          operation returns. If `!set_types()` is not used, the data will be
          returned as unparsed strings or bytes instead of Python objects.

        - On :sql:`COPY FROM`, `!set_types()` allows to choose what type the
          database expects. This is especially useful in binary copy, because
          PostgreSQL will apply no cast rule.

        N)r    ÚadaptersÚtypesÚ
isinstanceÚintÚget_oidr&   r'   r   ÚtransformerÚset_dumper_typesÚformatÚset_loader_types)r4   rM   ÚregistryÚtÚoidss        r7   Ú	set_typeszBaseCopy.set_typesq   sŸ   € ð& —;‘;×'Ñ'×-Ñ-ˆØJOÖPÀQ”Z ¤3Ô'‘¨X×-=Ñ-=¸aÓ-@Ñ@ÐPˆÐPà�?‰?œgÒ%Ø�N‰N×&Ñ&×7Ñ7¸¸d¿n¹n×>SÑ>SÕTà�N‰N×&Ñ&×7Ñ7¸¸d¿n¹n×>SÑ>SÕTùò Qs   ¥*Cc              #  ó   K  — | j                   rt        d«      S t        | j                  «      E d {  –—† }t	        |t        «      r|S d| _         |j
                  }|�|nd| j                  _        t        d«      S 7 ŒI­w)Nr9   Téÿÿÿÿ)r3   Ú
memoryviewr   r#   rN   Úcommand_tuplesr    Ú	_rowcount)r4   ÚresÚnrowss      r7   Ú	_read_genzBaseCopy._read_genŽ   so   è ø€ Ø�>Š>Ü˜c“?Ð"ä" 4§<¡<Ó0×0ˆÜ�cœ:Ô&ØˆJð ˆŒð ×"Ñ"ˆØ).Ð):¡Àˆ�‰ÔÜ˜#‹Ðð 1ús   ‚0A>²A<³A
A>c              #  óÆ   K  — | j                  «       E d {  –—† x}sy | j                  j                  |«      x}€ | j                  «       E d {  –—†  d| _        y |S 7 ŒF7 Œ­w©NT)r`   r   Ú	parse_rowr3   )r4   ÚdataÚrows      r7   Ú_read_row_genzBaseCopy._read_row_gen¡   sb   è ø€ Ø$(§N¡NÓ$4×4Ð5�Ð5Øà—>‘>×+Ñ+¨DÓ1Ð1ˆCÐ:à—~‘~Ó'×'Ð'Ø!ˆDŒNØàˆ
ð 5øð
 (ús!   ‚A!–A—7A!ÁAÁA!ÁA!c              #  ó®   K  — 	 | j                  «       E d {  –—† r	 | j                  «       E d {  –—† rŒy y 7 Œ 7 Œ	# t        j                  $ r Y y w xY w­w©N)r`   r)   ÚQueryCanceledrI   s    r7   Ú_end_copy_out_genzBaseCopy._end_copy_out_gen­   sI   è ø€ ð	Ø"Ÿn™nÓ.×.Ð.Øð #Ÿn™nÓ.×.Ô.øÐ.ùä�‰ò 	Ùð	üs=   ‚A„< —8˜< °:±< ¶A¸< º< ¼AÁAÁAÁA)r    zBaseCursor[ConnectionType, Any]r   zbool | None)ÚreturnÚstr)rk   ÚNone)rM   zSequence[int | str]rk   rm   )rk   zPQGen[Buffer])rk   zPQGen[tuple[Any, ...] | None])rk   zPQGen[None])Ú__name__rA   rB   Ú__doc__Ú__annotations__r8   rF   rJ   rX   r`   rf   rj   © r9   r7   r   r   ;   sK   … ñð Óð QUñØ5ðØBMóó83ó
AóUó:ó&
ôr9   r   c                  ól   — e Zd ZU dZded<   d
d„Zedd„«       Zedd„«       Zedd„«       Z	edd„«       Z
y	)r   z@
    A class which understand a copy format (text, binary).
    z	pq.FormatrS   c                ó>   — || _         t        «       | _        d| _        y ©NF)rQ   Ú	bytearrayÚ_write_bufferÚ	_row_mode)r4   rQ   s     r7   r8   zFormatter.__init__¼   s   € Ø&ˆÔÜ&›[ˆÔØˆ�r9   c                 ó   — y rh   rq   ©r4   rd   s     r7   rc   zFormatter.parse_rowÁ   s   € ØADr9   c                 ó   — y rh   rq   ©r4   Úbuffers     r7   ÚwritezFormatter.writeÄ   s   € Ø58r9   c                 ó   — y rh   rq   )r4   re   s     r7   Ú	write_rowzFormatter.write_rowÇ   s   € Ø7:r9   c                 ó   — y rh   rq   rI   s    r7   ÚendzFormatter.endÊ   s   € Ø r9   N©rQ   r   ©rd   r   rk   ztuple[Any, ...] | None©r|   úBuffer | strrk   r   ©re   úSequence[Any]rk   r   ©rk   r   )rn   rA   rB   ro   rp   r8   r   rc   r}   r   r�   rq   r9   r7   r   r   µ   sN   … ñð Óóð
 ÚDó ØDàÚ8ó Ø8àÚ:ó Ø:àÚ ó Ù r9   r   c                  óN   ‡ — e Zd ZeZddˆ fd„Zd	d„Zd
d„Zdd„Zdd„Z	dd„Z
ˆ xZS )r1   c                ó2   •— t         ‰| �  |«       || _        y rh   )Úsuperr8   r2   )r4   rQ   r   r@   s      €r7   r8   zTextFormatter.__init__Ñ   s   ø€ Ü‰Ñ˜Ô%Ø!ˆ�r9   c                ó:   — d }|rt        || j                  «      }|S rh   )Úparse_row_textrQ   ©r4   rd   Úrvs      r7   rc   zTextFormatter.parse_rowÕ   s!   € Ø%)ˆÙÜ  d×&6Ñ&6Ó7ˆBàˆ	r9   c                ó6   — | j                  |«      }d| _        |S rb   ©Ú_ensure_bytesÚ_signature_sent©r4   r|   rd   s      r7   r}   zTextFormatter.writeÜ   ó   € Ø×!Ñ! &Ó)ˆØ#ˆÔØˆr9   c                óÈ   — d| _         t        || j                  | j                  «       t	        | j                  «      t
        kD  r| j                  t        «       c}| _        |S y©NTr9   )rw   Úformat_row_textrQ   rv   ÚlenÚBUFFER_SIZEru   ©r4   re   r|   s      r7   r   zTextFormatter.write_rowá   sU   € ð ˆŒä˜˜T×-Ñ-¨t×/AÑ/AÔBÜˆt×!Ñ!Ó"¤[Ò0Ø)-×);Ñ);¼Y»[Ð&ˆF�DÔ&ØˆMàr9   c                ó>   — | j                   t        «       c}| _         |S rh   )rv   ru   r{   s     r7   r�   zTextFormatter.endí   s   € Ø%)×%7Ñ%7¼»Ð"ˆ�Ô"Øˆr9   c                ó\   — t        |t        «      r|j                  | j                  «      S |S rh   )rN   rl   Úencoder2   ry   s     r7   r’   zTextFormatter._ensure_bytesñ   s&   € Ü�dœCÔ Ø—;‘;˜tŸ~™~Ó.Ð.ð
 ˆKr9   )zutf-8)rQ   r   r   rl   rƒ   r„   r†   rˆ   ©rd   r…   rk   r   )rn   rA   rB   ÚTEXTrS   r8   rc   r}   r   r�   r’   Ú__classcell__©r@   s   @r7   r1   r1   Î   s&   ø„ Ø€Fö"óóó

ó÷r9   r1   c                  óL   ‡ — e Zd ZeZdˆ fd„Zdd„Zd	d„Zd
d„Zdd„Z	dd„Z
ˆ xZS )r0   c                ó2   •— t         ‰| �  |«       d| _        y rt   )r‹   r8   r“   )r4   rQ   r@   s     €r7   r8   zBinaryFormatter.__init__þ   s   ø€ Ü‰Ñ˜Ô%Ø$ˆÕr9   c                óî   — d }| j                   sG|d t        t        «       t        k7  rt        j                  d«      ‚d| _         |t        t        «      d  }|t
        k7  rt        || j                  «      }|S )Nz5binary copy doesn't start with the expected signatureT)r“   r™   Ú_binary_signaturer)   Ú	DataErrorÚ_binary_trailerÚparse_row_binaryrQ   rŽ   s      r7   rc   zBinaryFormatter.parse_row  sw   € Ø%)ˆà×#Ò#ØÐ,”cÔ+Ó,Ð-Ô1BÒBÜ—k‘kØKóð ð $(ˆDÔ ØœÔ-Ó.Ð0Ð1ˆDà”?Ò"Ü! $¨×(8Ñ(8Ó9ˆBàˆ	r9   c                ó6   — | j                  |«      }d| _        |S rb   r‘   r”   s      r7   r}   zBinaryFormatter.write  r•   r9   c                ó   — d| _         | j                  s | xj                  t        z  c_        d| _        t	        || j
                  | j                  «       t        | j                  «      t        kD  r| j                  t        «       c}| _        |S yr—   )	rw   r“   rv   r¦   Úformat_row_binaryrQ   r™   rš   ru   r›   s      r7   r   zBinaryFormatter.write_row  sx   € ð ˆŒà×#Ò#Ø×ÒÔ"3Ñ3ÕØ#'ˆDÔ ä˜#˜t×/Ñ/°×1CÑ1CÔDÜˆt×!Ñ!Ó"¤[Ò0Ø)-×);Ñ);¼Y»[Ð&ˆF�DÔ&ØˆMàr9   c                ó  — | j                   s3| xj                  t        z  c_        | xj                  t        z  c_        n%| j                  r| xj                  t        z  c_        | j                  t        «       c}| _        |S rh   )r“   rv   r¦   r¨   rw   ru   r{   s     r7   r�   zBinaryFormatter.end'  sf   € ð ×#Ò#Ø×ÒÔ"3Ñ3ÕØ×Ò¤/Ñ1Öà�^Š^ð ×Ò¤/Ñ1Õà%)×%7Ñ%7¼»Ð"ˆ�Ô"Øˆr9   c                ó<   — t        |t        «      rt        d«      ‚|S )Nz6cannot copy str data in binary mode: use bytes instead)rN   rl   rH   ry   s     r7   r’   zBinaryFormatter._ensure_bytes:  s   € Ü�dœCÔ ÜÐTÓUÐUð
 ˆKr9   r‚   rƒ   r„   r†   rˆ   rŸ   )rn   rA   rB   ÚBINARYrS   r8   rc   r}   r   r�   r’   r¡   r¢   s   @r7   r0   r0   û   s&   ø„ Ø€Fõ%óó ó
ó ÷&r9   r0   c                ó¾   — | s|dz  }y|j                  | t        gt        | «      z  «      }|D ](  }||�t        j	                  t
        |«      ndz  }|dz  }Œ* d|dd y)z6Convert a row of objects to the data to send for copy.ó   
Nó   \Nó   	rZ   )Údump_sequenceÚPY_TEXTr™   Ú_dump_reÚsubÚ	_dump_sub©re   r6   ÚoutÚadaptedÚbs        r7   Ú_format_row_textr½   D  sn   € áØˆu‰ˆØà×Ñ˜s¤W I´°C³Ñ$8Ó9€GØò ˆØ¨Q¨]Œx�|‰|œI qÔ)ÀÑFˆØˆu‰‰ðð €Cˆˆ�Hr9   c                óÖ   — |j                  | t        gt        | «      z  «      }|t        t        | «      «      z  }|D ]*  }|�|t	        t        |«      «      z  }||z  }Œ"|t
        z  }Œ, y)z=Convert a row of objects to the data to send for binary copy.N)r´   Ú	PY_BINARYr™   Ú
_pack_int2Ú
_pack_int4Ú_binary_nullr¹   s        r7   Ú_format_row_binaryrÃ   R  sl   € à×Ñ˜s¤Y K´#°c³(Ñ$:Ó;€GØŒ:”c˜#“hÓÑ€CØò  ˆØˆ=Ø”:œc !›fÓ%Ñ%ˆCØ�1‰H‰Cà”<Ñ‰Cñ r9   c                óD  — t        | t        «      st        | «      } | j                  d«      st        j                  d«      ‚| j                  d«      }|d   d d |d<   |D �cg c]#  }|dk(  rd nt        j                  t        |«      ‘Œ% }}|j                  |«      S c c}w )Nr±   z(bad copy data: field delimiter not foundr³   rZ   r²   )
rN   ÚbytesÚendswithr)   r§   ÚsplitÚ_load_rer·   Ú	_load_subÚload_sequence)rd   r6   ÚfieldsÚfre   s        r7   Ú_parse_row_textrÍ   ^  s’   € Ü�dœEÔ"Ü�T‹{ˆØ�=‰=˜ÔÜ�k‰kÐDÓEÐEØ�Z‰Z˜Ó€FØ˜‘˜C˜R�€Fˆ2�JØHNÖ
OÀ1�1˜’;‰4¤H§L¡L´¸AÓ$>Ñ>Ð
O€CÐ
OØ×Ñ˜CÓ Ð ùò Ps   Á"(Bc                ó¶  — g }t        | «      }|dk  rt        j                  d«      ‚t        | d«      d   }d}t	        |«      D ]ƒ  }|dz   |kD  rt        j                  d«      ‚t        | |«      d   }|dz  }|dk\  r:||z   |kD  rt        j                  d«      ‚|j                  | |||z    «       ||z  }Œs|j                  d «       Œ… |j                  |«      S )Né   z&bad copy data: fields number truncatedr   r   z%bad copy data: field length truncatedz$bad copy data: length exceeding data)r™   r)   r§   Ú_unpack_int2ÚrangeÚ_unpack_int4ÚappendrÊ   )rd   r6   re   Úlen_dataÚnfieldsÚposÚiÚlengths           r7   Ú_parse_row_binaryrÙ   i  sè   € Ø!€CÜ�4‹y€HØ�!‚|Ü�k‰kÐBÓCÐCÜ˜4 Ó# AÑ&€GØ
€CÜ�7‹^ò ˆØ�‰7�XÒÜ—+‘+ÐEÓFÐFÜ˜d CÓ(¨Ñ+ˆØˆq‰ˆØ�QŠ;Ø�V‰|˜hÒ&Ü—k‘kÐ"HÓIÐIØ�J‰J�t˜C #¨¡,Ð/Ô0Ø�6‰M‰Cà�J‰J�tÕðð ×Ñ˜CÓ Ð r9   z!hz!is   PGCOPY
ÿ
         s   ÿÿs   ÿÿÿÿs
   [	
\\]s   \bs   \ts   \ns   \vs   \fs   \rs   \\)ó   r³   r±   ó   ó   ó   ó   \c                ó*   — || j                  d«         S ©Nr   ©Úgroup©ÚmÚ__maps     r7   r¸   r¸   ™  ó   € Ø�—‘˜“ÑÐr9   s   \\[btnvfr\\]c                ó*   — || j                  d«         S rà   rá   rã   s     r7   rÉ   rÉ   ¡  ræ   r9   )re   r‡   r6   r   rº   ru   rk   rm   )rd   r   r6   r   rk   ztuple[Any, ...])rä   zre.Match[bytes]rå   zdict[bytes, bytes]rk   rÅ   )Lro   Ú
__future__r   ÚreÚsysÚstructÚabcr   r   Útypingr   r   r   Úcollections.abcr	   Ú r   r   r)   r   r   r   r   r   Úpq.miscr   Ú_cmoduler   Ú
generatorsr   Ú_cursor_baser   ÚPyFormatr    rµ   r¯   r¿   ÚFormatr+   r'   r(   rš   ÚMAX_BUFFER_SIZEÚ
QUEUE_SIZEÚplatformÚPREFER_FLUSHr   r   r1   r0   r½   rÃ   rÍ   rÙ   ÚStructÚpackrÀ   rÁ   Úunpack_fromrÐ   rÒ   r¦   r¨   rÂ   Úcompiler¶   Ú
_dump_replr¸   rÈ   ÚitemsÚ
_load_replrÉ   r˜   r¬   r�   r©   )ÚkÚvs   00r7   ú<module>r     sJ  ðñõ #ã 	Û 
Û ß #ß .Ñ .Ý $å Ý Ý ß ;Ó ;Ý 'Ý Ý !áÝ(à
�.‰.×
Ñ
€Ø�N‰N×!Ñ!€	à	‡y�y‡~�~€Ø	�‰×	Ñ	€à
�-‰-×
Ñ
€Ø�=‰=×!Ñ!€ð
 €ð
 �k‘/€ð €
ð �|‰|˜xÑ'€ôwˆw�~Ñ&ô wôt!�ô !ô2*�Iô *ôZF�iô FóRó	 ó!ó!ð. ˆV�]‰]˜4Ó ×%Ñ%€
ØˆV�]‰]˜4Ó ×%Ñ%€
Øˆv�}‰}˜TÓ"×.Ñ.€Øˆv�}‰}˜TÓ"×.Ñ.€ðð ð
 €Ø"€àˆ2�:‰:Ð+Ó,€àØØØØØØñ€
ð ?Iô ð ˆ2�:‰:Ð)Ó*€Ø)×/Ñ/Ó1×2‘t�q˜!ˆa�‰dÓ2€
ð ?Iô ñ
 Ø×.Ñ.€OØ ×2Ñ2ÐØ×,Ñ,€NØ×0Ñ0Ñð '€OØ*ÐØ$€NØ(Ñùó% 3s   Ç=I