§
    Ò¬¸j[]  ã                  ó¾  — U d dl mZ d dl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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& erNd dl'Z'd dlm(Z( d dl)m*Z* d dl+Z,d dlm-Z- e'j.        dk    rd dlm/Z/ nd dl0m/Z/ d dl1m2Z2 d dl3m4Z4 d dlm5Z5 d dl6m7Z7m8Z8m9Z9 h d£Z:de;d<    G d„ d¦  «        Z< G d„ d¦  «        Z=dS )é    )ÚannotationsN)Ú	CoroutineÚIterableÚSequence)Úsuppress)Ú	ParameterÚ	signature)ÚTYPE_CHECKINGÚAnyÚFinalÚcast)Ú	functions)Úparse_versionÚqualified_type_name)ÚN_INFER_DEFAULT)ÚDuplicateErrorÚModuleUpgradeRequiredErrorÚUnsuitableSQLError)ÚARROW_DRIVER_REGISTRY)ÚODBCCursorProxyÚOracleCursorProxyÚSurrealDBCursorProxy)Údtype_from_cursor_description)Ú
_run_async)ÚIterator)ÚTracebackType)ÚArrowDriverProperties)é   é   )ÚSelf©Ú
TextClause)Ú
Selectable©Ú	DataFrame)ÚConnectionOrCursorÚCursorÚ
SchemaDict>   ÚUSEÚDROPÚALTERÚGRANTÚCREATEÚDELETEÚINSERTÚREVOKEÚUPDATEÚUPSERTÚVACUUMÚANALYZEÚREPLACEzFinal[set[str]]Ú_INVALID_QUERY_TYPESc                  ó"   — e Zd ZdZdd„Zdd
„ZdS )ÚCloseAfterFrameIterzDAllows cursor close to be deferred until the last batch is returned.Úframesr   Úcursorr'   ÚreturnÚNonec               ó"   — || _         || _        d S ©N)Ú_iter_framesÚ_cursor)Úselfr9   r:   s      úl/root/private/project/pallet_detection_v2/.venv/lib/python3.11/site-packages/polars/io/database/_executor.pyÚ__init__zCloseAfterFrameIter.__init__B   s   € Ø"ˆÔØˆŒˆˆó    úIterator[DataFrame]c              #  ó„   K  — | j         E d {V —† t          | j        d¦  «        r| j                             ¦   «          d S d S )NÚclose)r?   Úhasattrr@   rG   ©rA   s    rB   Ú__iter__zCloseAfterFrameIter.__iter__F   sY   è è € ØÔ$Ð$Ð$Ð$Ð$Ð$Ð$Ð$å�4”< Ñ)Ô)ð 	!ØŒL×ÒÑ Ô Ð Ð Ð ð	!ð 	!rD   N)r9   r   r:   r'   r;   r<   )r;   rE   )Ú__name__Ú
__module__Ú__qualname__Ú__doc__rC   rJ   © rD   rB   r8   r8   ?   sB   € € € € € ØNÐNðð ð ð ð!ð !ð !ð !ð !ð !rD   r8   c                  ón  — e Zd ZU dZdZded<   dLd	„ZdMd„ZdNd„ZdOd„Z	e
dPd„¦   «         ZdQd„Ze
dRd„¦   «         ZdSd$„Ze
dTd)„¦   «         ZdUd*„ZdVd.„ZdVd/„ZdWd2„Ze
dXd5„¦   «         Ze
dXd6„¦   «         Ze
dXd7„¦   «         Ze
dXd8„¦   «         Ze
dYd9„¦   «         ZdZd:„Zd[d>„Zd\dB„ZdCdDdEœd]dH„ZddCdCedIœd^dK„ZdCS )_ÚConnectionExecutorzIAbstraction for querying databases with user-supplied connection objects.FÚboolÚcan_close_cursorÚ
connectionr&   r;   r<   c                óŒ  — t          |t          ¦  «        rdn?t          |¦  «        j                             dd¦  «        d                              ¦   «         | _        | j        dk    rt          |¬¦  «        }n*| j        dk    rt          |d¦  «        rt          |¦  «        }|  
                    |¦  «        | _        d | _        d S )	NÚarrow_odbc_proxyú.é   r   Ú	surrealdb)ÚclientÚoracledbÚfetch_df_all)Ú
isinstancer   ÚtyperL   ÚsplitÚlowerÚdriver_namer   rH   r   Ú_normalise_cursorr:   Úresult)rA   rT   s     rB   rC   zConnectionExecutor.__init__T   sÀ   € õ ˜*¥oÑ6Ô6ðFÐÐå�jÑ!Ô!Ô,×2Ò2°3¸Ñ:Ô:¸1Ô=×CÒCÑEÔEð 	Ôð
 Ô˜{Ò*Ð*Ý-°ZÐ@Ñ@Ô@ˆJˆJØÔ Ò+Ð+µ¸
ÀNÑ0SÔ0SÐ+Ý*¨:Ñ6Ô6ˆJà×,Ò,¨ZÑ8Ô8ˆŒØˆŒˆˆrD   r    c                ó   — | S r>   rO   rI   s    rB   Ú	__enter__zConnectionExecutor.__enter__b   s   € ØˆrD   Úexc_typeútype[BaseException] | NoneÚexc_valúBaseException | NoneÚexc_tbúTracebackType | Nonec                ó,  — |                       | j        ¦  «        r@ddlm} t	          | j        |¦  «        r#t          |                      ¦   «         ¦  «         d S d S | j        r0t          | j        d¦  «        r| j         	                    ¦   «          d S d S d S )Nr   )ÚAsyncConnectionrG   )
Ú_is_alchemy_asyncr:   Úsqlalchemy.ext.asynciorm   r]   r   Ú_close_async_cursorrS   rH   rG   )rA   rf   rh   rj   rm   s        rB   Ú__exit__zConnectionExecutor.__exit__e   s¸   € ð ×!Ò! $¤+Ñ.Ô.ð 	 Ø>Ð>Ð>Ð>Ð>Ð>å˜$œ+ Ñ7Ô7ð 7Ý˜4×3Ò3Ñ5Ô5Ñ6Ô6Ð6Ð6Ð6ð7ð 7àÔ"ð 	 ¥w¨t¬{¸GÑ'DÔ'Dð 	 ØŒK×ÒÑÔÐÐÐð	 ð 	 ð 	 ð 	 rD   Ústrc                óB   — dt          | ¦  «        j        › d| j        ›d�S )Nú<z module=ú>)r^   rK   ra   rI   s    rB   Ú__repr__zConnectionExecutor.__repr__u   s'   € ØE•4˜‘:”:Ô&ÐEÐE°Ô0@ÐEÐEÐEÐErD   Údfr%   Úschema_overridesr(   c                ó„   ‡— | j         Šˆfd„|                     ¦   «         D ¦   «         x}r|                      |¦  «        } | S )z&Apply schema overrides to a DataFrame.c                ó„   •— g | ]<\  }}|‰v ¯	|‰|         k    ¯t          j        |¦  «                             |¦  «        ‘Œ=S rO   )ÚFÚcolr   )Ú.0r|   ÚdtypeÚexisting_schemas      €rB   ú
<listcomp>z7ConnectionExecutor._apply_overrides.<locals>.<listcomp>|   sU   ø€ ð 
ð 
ð 
á��UØ�oÐ%Ð%¨%°?À3Ô3GÒ*GÐ*Gõ ŒE�#‰JŒJ�OŠO˜EÑ"Ô"à*GÐ*GÐ*GrD   )ÚschemaÚitemsÚwith_columns)rw   rx   Ú	cast_colsr   s      @rB   Ú_apply_overridesz#ConnectionExecutor._apply_overridesx   sb   ø€ ð œ)ˆð
ð 
ð 
ð 
à.×4Ò4Ñ6Ô6ð
ñ 
ô 
ð 
ˆ9ð 	,ð
 —’ Ñ+Ô+ˆBØˆ	rD   c              ƒ  óä   K  — | j         rdt          | j        d¦  «        rQddlm} t          |¦  «        5  | j                             ¦   «         ƒ d {V —† d d d ¦  «         d S # 1 swxY w Y   d S d S d S )NrG   r   )ÚAsyncContextNotStarted)rS   rH   r:   Úsqlalchemy.ext.asyncio.excr‡   r   rG   )rA   r‡   s     rB   rp   z&ConnectionExecutor._close_async_cursor„   sã   è è € ØÔ ð 	*¥W¨T¬[¸'Ñ%BÔ%Bð 	*ØIÐIÐIÐIÐIÐIåÐ0Ñ1Ô1ð *ð *Ø”k×'Ò'Ñ)Ô)Ð)Ð)Ð)Ð)Ð)Ð)Ð)ð*ð *ð *ñ *ô *ð *ð *ð *ð *ð *ð *ð *øøøð *ð *ð *ð *ð *ð *ð	*ð 	*ð 	*ð 	*s   ´ A!Á!A%Á(A%Úmodule_nameÚminimum_versionc           	     óR  — t          | ¦  «        }t          t          ¦  «        5  d}dD ]9}t          t	          ||d¦  «        x}t
          ¦  «        rt          |¦  «        } nŒ:|r*|t          |¦  «        k     rd| › d|› �}t          |¦  «        ‚ddd¦  «         dS # 1 swxY w Y   dS )z<Check the module version against a minimum required version.N)Ú__version__Úversionz)`read_database` queries require at least z	 version )Ú
__import__r   ÚAttributeErrorr]   Úgetattrrr   r   r   )r‰   rŠ   ÚmodÚmodule_versionÚversion_attrÚverÚmsgs          rB   Ú_check_module_versionz(ConnectionExecutor._check_module_version‹   s  € õ ˜Ñ%Ô%ˆÝ•nÑ%Ô%ð 	6ð 	6Ø59ˆNØ :ð ð �Ý¥W¨S°,ÀÑ%EÔ%EÐE˜cÅsÑKÔKð Ý%2°3Ñ%7Ô%7�NØ�Eðð ð 6 .µ=ÀÑ3QÔ3QÒ"QÐ"QØiÀ+ÐiÐiÐXgÐiÐi�Ý0°Ñ5Ô5Ð5ð	6ð 	6ð 	6ñ 	6ô 	6ð 	6ð 	6ð 	6ð 	6ð 	6ð 	6ð 	6øøøð 	6ð 	6ð 	6ð 	6ð 	6ð 	6s   ¤A+BÂB Â#B Údriver_propertiesr   Ú
batch_sizeú
int | NoneÚiter_batchesúIterable[pa.RecordBatch]c             #  óB  K  — |d         }|r|€J|d         } t          | j        |¦  «        ¦   «         }t          |t          ¦  «        r
|E d{V —† dS |V — dS |d         r|gng }|d         }t          | j        |¦  «        }	|s |	|Ž E d{V —† dS 	  |	|Ž }
|
sdS |
V — Œ)zGYield Arrow data as a generator of one or more RecordBatches or Tables.Úfetch_batchesNÚ	fetch_allÚexact_batch_sizeÚrepeat_batch_calls)r�   rc   r]   r   )rA   r—   r˜   rš   r�   Úfetch_methodÚresÚsizer    Úfetchmany_arrowÚarrows              rB   Ú_fetch_arrowzConnectionExecutor._fetch_arrow™   s  è è € ð *¨/Ô:ˆØð 	 ˜}Ð4Ø,¨[Ô9ˆLØ4•'˜$œ+ |Ñ4Ô4Ñ6Ô6ˆCå˜#�xÑ(Ô(ð Ø���������à�	�	�	�	�	à#4Ð5GÔ#HÐP�J�<�<ÈbˆDØ!2Ð3GÔ!HÐÝ% d¤k°=ÑAÔAˆOØ%ð  Ø*˜?¨DÐ1Ð1Ð1Ð1Ð1Ð1Ð1Ð1Ð1Ð1ð Ø+˜O¨TÐ2�EØ ð Ø˜Ø�K�K�Kð	 rD   rc   r'   Ú
is_alchemyúIterable[Sequence[Any]]c               óž   — |                       ¦   «         }|r,|s(t          |d         t          t          t          f¦  «        r|nd„ |D ¦   «         S )zCFetch row data in a single call, returning the complete result set.r   c                ó,   — g | ]}t          |¦  «        ‘ŒS rO   ©Útuple©r}   Úrows     rB   r€   z5ConnectionExecutor._fetchall_rows.<locals>.<listcomp>¾   s   € Ð-Ð-Ð- •%˜‘*”*Ð-Ð-Ð-rD   )Úfetchallr]   Úlistr¬   Údict)rc   r§   Úrowss      rB   Ú_fetchall_rowsz!ConnectionExecutor._fetchall_rows·   s\   € ð �ŠÑ Ô ˆð ð.Ø#ð.Ý'1°$°q´'½DÅ%ÍÐ;NÑ'OÔ'Oð.ˆDˆDà-Ð-¨Ð-Ñ-Ô-ð	
rD   c             #  ó¶   K  — 	 |                      |¦  «        }|sdS |s(t          |d         t          t          t          f¦  «        r|V — nd„ |D ¦   «         V — ŒW)zDFetch row data incrementally, yielding over the complete result set.Tr   c                ó,   — g | ]}t          |¦  «        ‘ŒS rO   r«   r­   s     rB   r€   z6ConnectionExecutor._fetchmany_rows.<locals>.<listcomp>Ì   s   € Ð2Ð2Ð2 c•u˜S‘z”zÐ2Ð2Ð2rD   N)Ú	fetchmanyr]   r°   r¬   r±   )rA   rc   r˜   r§   r²   s        rB   Ú_fetchmany_rowsz"ConnectionExecutor._fetchmany_rowsÁ   sy   è è € ð	3Ø×#Ò# JÑ/Ô/ˆDØð 3Ø�Øð 3�z¨$¨q¬'µD½%ÅÐ3FÑGÔGð 3Ø�
�
�
�
à2Ð2¨TÐ2Ñ2Ô2Ð2Ð2Ð2ð	3rD   úSchemaDict | NoneÚinfer_schema_lengthú&DataFrame | Iterator[DataFrame] | Nonec               ó�  ‡ ‡‡‡— ddl mŠ 	 ‰ j                             d¦  «        rdn‰ j        }t	          j        |g ¦  «        }t          |d¬¦  «        D ]º\  }}|d         x}	rK|dk    rdn‰ j        }
	 ‰                      |
|	¦  «         n$# t          $ r |t          |¦  «        k     rY ŒU‚ w xY w|r$|d	         r|sd
‰ j        › d�}t          |¦  «        ‚ˆˆˆ fd„‰                      |||¬¦  «        D ¦   «         }|r|nt          |¦  «        c S n5# t          $ r(Šd}t          ˆfd„|D ¦   «         ¦  «        s‚ Y dŠ‹ndŠ‹ww xY wdS )z5Return resultset data in Arrow format for frame init.r   r$   Úadbc_ÚadbcrX   )ÚstartrŠ   Úadbc_driver_managerrŸ   zCannot set `iter_batches` for z- without also setting a non-zero `batch_size`c              3  ó~   •K  — | ]7}t          |‰¦  «        r‰                     |‰pi ¦  «        n
 ‰|¦  «        V — Œ8d S r>   )r]   r…   )r}   Úbatchr%   rx   rA   s     €€€rB   ú	<genexpr>z1ConnectionExecutor._from_arrow.<locals>.<genexpr>ø   sp   øè è € ð 	ð 	ð õ " %¨Ñ3Ô3ð*�D×)Ò)¨%Ð2BÐ2HÀbÑJÔJÐJà"˜ 5Ñ)Ô)ð	ð 	ð 	ð 	ð 	ð 	rD   )rš   r˜   )zdoes not support Apache Arrowz$Apache Arrow format is not supportedc              3  ó:   •K  — | ]}|t          ‰¦  «        v V — Œd S r>   )rr   )r}   ÚeÚerrs     €rB   rÂ   z1ConnectionExecutor._from_arrow.<locals>.<genexpr>
  s-   øè è € ÐBÐB¨�q�C ™HœH�}ÐBÐBÐBÐBÐBÐBrD   N)Úpolarsr%   ra   Ú
startswithr   ÚgetÚ	enumerater–   r   ÚlenÚ
ValueErrorr¦   ÚnextÚ	ExceptionÚany)rA   r˜   rš   rx   r¹   ÚdriverÚdriver_properties_listÚir—   r”   Údriver_to_checkr•   r9   Úarrow_not_supportedr%   rÅ   s   `  `          @@rB   Ú_from_arrowzConnectionExecutor._from_arrowÎ   sA  øøøø€ ð 	%Ð$Ð$Ð$Ð$Ð$ð2	ð Ô*×5Ò5°gÑ>Ô>ÐT��ÀDÔDTð õ &;Ô%>¸vÀrÑ%JÔ%JÐ"Ý(1Ð2HÐPQÐ(RÑ(RÔ(Rð #@ð #@Ñ$�Ð$Ø+Ð,=Ô>Ð>�3ð ð 28¸6Ò1AÐ1AÐ-Ð-ÀtÔGWð $ð
Ø×2Ò2°?ÀCÑHÔHÐHÐHøÝ5ð ð ð Ø�sÐ#9Ñ:Ô:Ò:Ð:Ø$˜HØðøøøð
  ð *Ø%Ð&8Ô9ð*ØBLð*ðG¸Ô9Ið Gð Gð Gð õ % S™/œ/Ð)ð	ð 	ð 	ð 	ð 	ð 	ð "&×!2Ò!2Ø)Ø%1Ø#-ð "3ñ "ô "ð		ñ 	ô 	�ð ".Ð?�v�vµ4¸±<´<Ð?Ð?Ð?ðG#@øõH ð 	ð 	ð 	ð#Ðõ ÐBÐBÐBÐBÐ.AÐBÑBÔBÑBÔBð Øðð ð ð ð øøøøð	øøøð ˆts=   ŒA'D Á4BÂ
D ÂB,Â(D Â*B,Â,A#D Ä
EÄD>Ä>Ec               óì  ‡‡‡‡— ddl mŠ |r|sd}t          |¦  «        ‚t          | j        x}t
          ¦  «        x}rt          | j        ¦  «        | _        	 t          | j        d¦  «        �rQ| j        dk    x}r{t          | j        d¦  «        rd„ | j        j	        j
        D ¦   «         }	nxt          | j        d¦  «        rd	„ | j        j        j        D ¦   «         }	nGd
| j        ›�}t          |¦  «        ‚t          | j        d¦  «        rd„ | j        j
        D ¦   «         }	ng }	|                      |	‰pi ¬¦  «        Šd„ |	D ¦   «         Šˆˆˆˆfd„|r|                      | j        ||¬¦  «        n|                      | j        |¬¦  «        gD ¦   «         }
|r|
nt!          |
¦  «        	 |r|                     ¦   «          S S 	 |r|                     ¦   «          dS dS # |r|                     ¦   «          w w xY w)z.Return resultset data row-wise for frame init.r   r$   zFCannot set `iter_batches` without also setting a non-zero `batch_size`r¯   Ú
sqlalchemyr:   c                ó2   — g | ]}|d          |dd…         f‘ŒS ©r   rX   NrO   ©r}   Úds     rB   r€   z1ConnectionExecutor._from_rows.<locals>.<listcomp>&  s5   € ð 'ð 'ð 'Ø./˜Q˜qœT 1 Q R R¤5˜Mð'ð 'ð 'rD   Ú	_metadatac                ó   — g | ]}|d f‘ŒS r>   rO   )r}   Úks     rB   r€   z1ConnectionExecutor._from_rows.<locals>.<listcomp>*  s   € Ð&UÐ&UÐ&U°Q¨¨4 yÐ&UÐ&UÐ&UrD   z0Unable to determine metadata from query result; Údescriptionc                ó2   — g | ]}|d          |dd…         f‘ŒS rØ   rO   rÙ   s     rB   r€   z1ConnectionExecutor._from_rows.<locals>.<listcomp>0  s(   € Ð"RÐ"RÐ"R°Q A a¤D¨!¨A¨B¨B¬% =Ð"RÐ"RÐ"RrD   )rÞ   rx   c                ó   — g | ]\  }}|‘ŒS rO   rO   )r}   ÚnmÚ_s      rB   r€   z1ConnectionExecutor._from_rows.<locals>.<listcomp>8  s   € Ð!>Ð!>Ð!>©¨¨Q "Ð!>Ð!>Ð!>rD   c              3  ó<   •K  — | ]} ‰|‰pd ‰‰d¬¦  «        V — Œd S )Nr®   )Údatar�   rx   r¹   ÚorientrO   )r}   r²   r%   r¹   Úresult_columnsrx   s     €€€€rB   rÂ   z0ConnectionExecutor._from_rows.<locals>.<genexpr>9  s^   øè è € ð ð ð ð �IØ!Ø-Ð5°Ø)9Ø,?Ø$ðñ ô ðð ð ð ð ð rD   )r˜   r§   )r§   N)rÆ   r%   rË   r]   rc   r   r   rH   ra   r:   rÞ   rÛ   ÚkeysÚ_inject_type_overridesr·   r³   rÌ   rG   )rA   r˜   rš   rx   r¹   r•   Úoriginal_resultÚis_asyncr§   Úcursor_descr9   r%   ræ   s      ``      @@rB   Ú
_from_rowszConnectionExecutor._from_rows  s©  øøøø€ ð 	%Ð$Ð$Ð$Ð$Ð$àð 	" 
ð 	"àXð õ ˜S‘/”/Ð!å!°T´[Ð"@ /Å)ÑLÔLÐLˆ8ð 	2Ý$ T¤[Ñ1Ô1ˆDŒKð-	(Ý�t”{ JÑ/Ô/ñ (@Ø"&Ô"2°lÒ"BÐC�:ð %Ý˜tœ{¨HÑ5Ô5ð .ð'ð 'Ø37´;Ô3EÔ3Qð'ñ 'ô '˜˜õ ! ¤¨kÑ:Ô:ð .Ø&UÐ&U¸$¼+Ô:OÔ:TÐ&UÑ&UÔ&U˜˜à`ÐQUÔQ\Ð`Ð`˜Ý(¨™oœoÐ-å˜Tœ[¨-Ñ8Ô8ð %Ø"RÐ"R¸$¼+Ô:QÐ"RÑ"RÔ"R�K�Kà"$�Kà#'×#>Ò#>Ø +Ø&6Ð&<¸"ð $?ñ $ô $Ð ð "?Ð!>°+Ð!>Ñ!>Ô!>�ðð ð ð ð ð ð ð (ðW˜×,Ò,Ø œKØ'1Ø'1ð -ñ ô ð ð #×1Ò1°$´+È*Ð1ÑUÔUÐVðñ ô �ð$ ".Ð?�v�vµ4¸±<´<Ð?ð ð (Ø×%Ò%Ñ'Ô'Ð'Ð'ð(ð àð (Ø×%Ò%Ñ'Ô'Ð'Ð'Ð'ð(ð (øˆxð (Ø×%Ò%Ñ'Ô'Ð'Ð'ð(øøøs   ÁEG ÇG3rÞ   úlist[tuple[str, Any]]c                óÆ   — t          ¦   «         }|D ]O\  }}||v rd|›d�}t          |¦  «        ‚|�||vrt          |¦  «        }|�|||<   |                     |¦  «         ŒP|S )a»  
        Attempt basic dtype inference from a cursor description.

        Notes
        -----
        This is limited; the `type_code` description attr may contain almost anything,
        from strings or python types to driver-specific codes, classes, enums, etc.
        We currently only do the additional inference from string/python type values.
        (Further refinement will require per-driver module knowledge and lookups).
        zcolumn z2 appears more than once in the query/result cursor)Úsetr   r   Úadd)rA   rÞ   rx   Ú
dupe_checkrá   Údescr•   r~   s           rB   rè   z)ConnectionExecutor._inject_type_overridesQ  s“   € õ ‘U”Uˆ
Ø#ð 	ð 	‰HˆB�Ø�ZÐÐØX ÐXÐXÐX�Ý$ SÑ)Ô)Ð)ØÐ! bÐ0@Ð&@Ð&@Ý5°dÑ;Ô;�ØÐ$Ø+0Ð$ RÑ(Ø�NŠN˜2ÑÔÐÐàÐrD   Úconnr   c                ó`   — 	 ddl m}m}m} t	          | |||f¦  «        S # t
          $ r Y dS w xY w)z2Check if the given connection is SQLALchemy async.r   )rm   ÚAsyncSessionÚasync_sessionmakerF)ro   rm   rõ   rö   r]   ÚImportError)ró   rm   rõ   rö   s       rB   rn   z$ConnectionExecutor._is_alchemy_asyncm  su   € ð		ðð ð ð ð ð ð ð ð ð õ ˜d _°lÐDVÐ$WÑXÔXÐXøÝð 	ð 	ð 	Ø�5�5ð	øøøs   ‚ Ÿ
-¬-c                ó‚   — ddl m} t          | |¦  «        rdS 	 ddlm} t          | |¦  «        S # t
          $ r Y dS w xY w)z5Check if the given connection is a SQLAlchemy Engine.r   )ÚEngineT)ÚAsyncEngineF)Úsqlalchemy.enginerù   r]   ro   rú   r÷   )ró   rù   rú   s      rB   Ú_is_alchemy_enginez%ConnectionExecutor._is_alchemy_engine{  sv   € ð 	-Ð,Ð,Ð,Ð,Ð,å�d˜FÑ#Ô#ð 	Ø�4ð	Ø:Ð:Ð:Ð:Ð:Ð:å˜d KÑ0Ô0Ð0øÝð 	ð 	ð 	Ø�5�5ð	øøøs   š0 °
>½>c                óf   — t          | ¦  «        j                             dd¦  «        d         dk    S )zCCheck if the given connection is a SQLAlchemy object (of any kind).rW   rX   r   rÖ   )r^   rL   r_   )ró   s    rB   Ú_is_alchemy_objectz%ConnectionExecutor._is_alchemy_object‰  s-   € õ �D‰zŒzÔ$×*Ò*¨3°Ñ2Ô2°1Ô5¸ÒEÐErD   c                ó˜   — ddl m} ddlm}m} t          | |||f¦  «        rdS 	 ddl m} t          | |¦  «        S # t          $ r Y dS w xY w)z=Check if the given connection is a SQLAlchemy Session object.r   )rõ   )ÚSessionÚsessionmakerT)rö   F)ro   rõ   Úsqlalchemy.ormr   r  r]   rö   r÷   )ró   rõ   r   r  rö   s        rB   Ú_is_alchemy_sessionz&ConnectionExecutor._is_alchemy_sessionŽ  s–   € ð 	8Ð7Ð7Ð7Ð7Ð7Ø8Ð8Ð8Ð8Ð8Ð8Ð8Ð8å�d˜\¨7°LÐAÑBÔBð 	Ø�4ð	ØAÐAÐAÐAÐAÐAå˜dÐ$6Ñ7Ô7Ð7øÝð 	ð 	ð 	Ø�5�5ð	øøøs   ¥; »
A	ÁA	c                ó‚   — 	 ddl m} t          | |¦  «        rdS ddlm} t          | |¦  «        S # t
          $ r Y dS w xY w)z8Check if the given result is a SQLAlchemy Result object.r   )ÚCursorResultT)ÚAsyncResultF)rû   r  r]   ro   r  r÷   )rc   r  r  s      rB   Ú_is_alchemy_resultz%ConnectionExecutor._is_alchemy_resultž  st   € ð
	Ø6Ð6Ð6Ð6Ð6Ð6å˜& ,Ñ/Ô/ð Ø�tà:Ð:Ð:Ð:Ð:Ð:å˜f kÑ2Ô2Ð2øÝð 	ð 	ð 	Ø�5�5ð	øøøs   ‚0 š0 °
>½>c                ó.  — | j         dk    �r|                      |¦  «        r|S |j        j        dk    r2d| _         |j                             ¦   «                              ¦   «         S |j        j        dk    r	d| _         |S |j        j        dk    rYt          |j                             ¦   «         j        x}d¦  «        r+d| _         d| _        t          d	t          |¦  «        ¦  «        S |                      |¦  «        rd| _        |                     ¦   «         S |S t          |d
¦  «        r9t          |j        x}¦  «        rt          d	 |¦   «         ¦  «        n|}d| _        |S t          |d¦  «        r|S dt          |¦  «        ›d�}t          |¦  «        ‚)zCNormalise a connection object such that we have the query executor.rÖ   zdatabricks-sql-pythonÚ
databricksÚduckdb_engineÚduckdbr[   r\   Tr'   r:   ÚexecutezUnrecognised connection type z!; no 'execute' or 'cursor' method)ra   r  ÚenginerÏ   Úraw_connectionr:   rH   Údriver_connectionrS   r   r   rü   ÚconnectÚcallabler   Ú	TypeError)rA   ró   Úraw_connr:   r•   s        rB   rb   z$ConnectionExecutor._normalise_cursor­  s¸  € àÔ˜|Ò+Ñ+Ø×'Ò'¨Ñ-Ô-ð  Ø�ð ”;Ô%Ð)@Ò@Ð@Ø'3�DÔ$Øœ;×5Ò5Ñ7Ô7×>Ò>Ñ@Ô@Ð@Ø”[Ô'¨?Ò:Ð:Ø'/�DÔ$Ø�KØ”[Ô'¨:Ò5Ð5½'Ø $¤× :Ò :Ñ <Ô <Ô NÐN�HØ"ñ;ô ;Ð5ð (2�DÔ$Ø,0�DÔ)Ý Õ*;¸HÑ*EÔ*EÑFÔFÐFØ×,Ò,¨TÑ2Ô2ð  à,0�DÔ)ØŸ<š<™>œ>Ð)à�Kå�T˜8Ñ$Ô$ð 
	õ -5¸t¼{Ð5J°VÑ,KÔ,KÐW•�X˜v˜v™xœxÑ(Ô(Ð(ÐQWð ð %)ˆDÔ!ØˆMå�T˜9Ñ%Ô%ð 	àˆKð+Õ,?ÀÑ,EÔ,Eð +ð +ð +ð 	õ ˜‰nŒnÐrD   Úqueryr"   Úoptionsc              ‹  ó‚  K  — |                       | j        ¦  «        }|r| j                             ¦   «         n| j        }t          |dd¦  «        � |j        |fi |¤Žƒ d{V —†S |4 ƒd{V —†}|rt          |d¦  «        s|j        } |j        |fi |¤Žƒ d{V —†}|cddd¦  «        ƒd{V —† S # 1 ƒd{V —†swxY w Y   dS )z5Execute a query using an async SQLAlchemy connection.Úsync_connectionNr  )r  r:   Úbeginr�   r  rH   Úsession)rA   r  r  Ú
is_sessionr:   ró   rc   s          rB   Ú_sqlalchemy_async_executez,ConnectionExecutor._sqlalchemy_async_executeÚ  sŠ  è è € à×-Ò-¨d¬kÑ:Ô:ˆ
Ø(2ÐC�”×"Ò"Ñ$Ô$Ð$¸¼ˆõ �6Ð,¨dÑ3Ô3Ð?Ø'˜œ¨Ð9Ð9°Ð9Ð9Ð9Ð9Ð9Ð9Ð9Ð9Ð9àð 	ð 	ð 	ð 	ð 	ð 	ð 	˜TØð $¥'¨$°	Ñ":Ô":ð $Ø”|�Ø'˜4œ<¨Ð9Ð9°Ð9Ð9Ð9Ð9Ð9Ð9Ð9Ð9ˆFØð		ð 	ð 	ð 	ñ 	ô 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	ð 	øøøð 	ð 	ð 	ð 	ð 	ð 	s   Á,/B.Â.
B8Â;B8ústr | TextClause | Selectableúdict[str, Any]ú9tuple[Any, dict[str, Any], str | TextClause | Selectable]c                óÊ  — ddl m} ddlm} ddlm} d}d}t          | j        |¦  «        r6d|v r2d|vr.|                     ¦   «         }| 	                    d¦  «        |d<   d}| 
                    |¦  «        }|                      | j        ¦  «        }	|	s–t          |t          ¦  «        r�t          | j        d¦  «        rl| j        j        }t          ||¦  «        rt          |¦  «        }t          |t           ¦  «        r+t#          d	„ |D ¦   «         ¦  «        st%          |¦  «        ||<   n t          |t          ¦  «        r ||¦  «        }|€|	r| j        n| j        j        }|||fS )
z<Prepare a query for execution using a SQLAlchemy connection.r   )r   )Útextr!   Ú
parametersNÚparamsÚexec_driver_sqlc              3  óN   K  — | ] }t          |t          t          f¦  «        V — Œ!d S r>   )r]   r±   r¬   ©r}   Úps     rB   rÂ   z7ConnectionExecutor._sqlalchemy_setup.<locals>.<genexpr>  sA   è è € ð 4ð 4Ø12•
˜1�t¥U˜mÑ,Ô,ð4ð 4ð 4ð 4ð 4ð 4rD   )r  r   Úsqlalchemy.sqlr   Úsqlalchemy.sql.elementsr"   r]   r:   ÚcopyÚpoprÈ   rn   r   rH   r#  rr   r°   Úallr¬   r  r  )
rA   r  r  r   r   r"   Ú	param_keyÚcursor_executer"  rê   s
             rB   Ú_sqlalchemy_setupz$ConnectionExecutor._sqlalchemy_setupê  s¶  € ð 	+Ð*Ð*Ð*Ð*Ð*Ø'Ð'Ð'Ð'Ð'Ð'Ø6Ð6Ð6Ð6Ð6Ð6à ˆ	Øˆå�t”{ GÑ,Ô,ð	!à Ð'Ð'Ø Ð'Ð'à—l’l‘n”nˆGØ '§¢¨LÑ 9Ô 9ˆG�HÑØ ˆIà—’˜YÑ'Ô'ˆØ×)Ò)¨$¬+Ñ6Ô6ˆàð	 å˜6¥8Ñ,Ô,ð	 õ ˜œÐ%6Ñ7Ô7ð	 ð
 "œ[Ô8ˆNÝ˜% Ñ,Ô,ð #Ý˜E™
œ
�Ý˜&¥$Ñ'Ô'ð 3µð 4ð 4Ø6<ð4ñ 4ô 4ñ 1ô 1ð 3õ &+¨6¡]¤]�˜	Ñ"øå˜�sÑ#Ô#ð 	 Ø�D˜‘K”KˆEàÐ!à2:ÐS�Ô.Ð.ÀÄÔ@Sð ð ˜w¨Ð-Ð-rD   NT)r  Úselect_queries_onlyúdict[str, Any] | Noner/  c               óè  ‡— |rtt          |t          ¦  «        r_t          j        dt          j        dd|¦  «        ¦  «        }|sdn|                     d¦  «        x}t          v r|› d�}t          |¦  «        ‚‰pi Š|                      | j	        ¦  «        r|  
                    |‰¦  «        \  }Š}n| j	        j        }	 t          |¦  «        j        }n# t          $ r i }Y nw xY w‰r+t          d„ |                     ¦   «         D ¦   «         ¦  «        r
 ||fi ‰¤Ž}	nˆfd„|p‰D ¦   «         }
 ||g|
¢R Ž }	|	�|	d	u r| j	        n|	}	| j        d
k    r|                      |	¦  «        r|	j	        }	|	| _        | S )z-Execute a query and reference the result set.z\w{3,}z/\*(.|[\r\n])*?\*/Ú r   z( statements are not valid 'read' queriesc              3  óT   K  — | ]#}|j         t          j        t          j        fv V — Œ$d S r>   )Úkindr   ÚKEYWORD_ONLYÚPOSITIONAL_OR_KEYWORDr%  s     rB   rÂ   z-ConnectionExecutor.execute.<locals>.<genexpr>1  sH   è è € ð 
ð 
àð ŒF•yÔ-­yÔ/NÐOÐOð
ð 
ð 
ð 
ð 
ð 
rD   c              3  ó4   •K  — | ]}‰r|‰v ¯‰|         V — Œd S r>   rO   )r}   Úor  s     €rB   rÂ   z-ConnectionExecutor.execute.<locals>.<genexpr>7  s=   øè è € ð "ð "Ø Àð"ØKLÐPWÈ<È<�˜”
È<È<È<È<ð"ð "rD   NTr  )r]   rr   ÚreÚsearchÚsubÚgroupr6   r   rþ   r:   r.  r  r	   r!  rË   rÎ   Úvaluesra   r  rc   )rA   r  r  r/  ÚqÚ
query_typer•   r-  r"  rc   Úpositional_optionss     `        rB   r  zConnectionExecutor.execute  só  ø€ ð ð 	.¥:¨eµSÑ#9Ô#9ð 	.Ý”	˜)¥R¤VÐ,AÀ2ÀuÑ%MÔ%MÑNÔNˆAØ()Ð9˜b˜b¨q¯wªw°q©z¬zÐ9�
Õ>RÐRÐRØ#ÐMÐMÐM�Ý(¨Ñ-Ô-Ð-à�-˜Rˆà×"Ò" 4¤;Ñ/Ô/ð 	1Ø-1×-CÒ-CÀEÈ7Ñ-SÔ-SÑ*ˆN˜G U Uà!œ[Ô0ˆNð	Ý˜~Ñ.Ô.Ô9ˆFˆFøÝð 	ð 	ð 	ØˆFˆFˆFð	øøøð ð 		@�#ð 
ð 
à—]’]‘_”_ð
ñ 
ô 
ñ 
ô 
ð 		@ð $�^ EÐ5Ð5¨WÐ5Ð5ˆFˆFð"ð "ð "ð "Ø%+Ð%6¨wð"ñ "ô "Ðð $�^ EÐ?Ð,>Ð?Ð?Ð?ˆFð "( °6¸T°>°>�”�ÈˆØÔ˜xÒ'Ð'¨D×,CÒ,CÀFÑ,KÔ,KÐ'Ø”]ˆFàˆŒØˆs   Â>C ÃC"Ã!C")rš   r˜   rx   r¹   úDataFrame | Iterator[DataFrame]c               ó0  — | j         €d}t          |¦  «        ‚| j        }|o|x}rd| _        | j        | j        fD ];} |||||¬¦  «        }	|	�(|r"t          |	| j        ¬¦  «        }
d„ |
D ¦   «         }	|	c S Œ<d| j        ›d| j        ›�}t          |¦  «        ‚)	zÏ
        Convert the result set to a DataFrame.

        Wherever possible we try to return arrow-native data directly; only
        fall back to initialising with row-level data if no other option.
        Nz.cannot return a frame before executing a queryF)r˜   rš   rx   r¹   )r:   c              3  ó   K  — | ]}|V — Œd S r>   rO   )r}   rw   s     rB   rÂ   z/ConnectionExecutor.to_polars.<locals>.<genexpr>h  s"   è è € Ð7Ð7 B˜RÐ7Ð7Ð7Ð7Ð7Ð7rD   zCurrently no support for z connection )	rc   ÚRuntimeErrorrS   rÔ   rì   r8   r:   ra   ÚNotImplementedError)rA   rš   r˜   rx   r¹   r•   Ú	can_closeÚdefer_cursor_closeÚ
frame_initÚframeÚframe_cursors              rB   Ú	to_polarszConnectionExecutor.to_polarsD  sù   € ð Œ;ÐØBˆCÝ˜sÑ#Ô#Ð#àÔ)ˆ	à".Ð"<°9Ð=Ðð 	*Ø$)ˆDÔ!ð ÔØŒOð
ð 	ð 	ˆJð �JØ%Ø)Ø!1Ø$7ð	ñ ô ˆEð Ð Ø%ð 8Ý#6°uÀTÄ[Ð#QÑ#QÔ#Q�LØ7Ð7¨,Ð7Ñ7Ô7�EØ���ð	 !ð X¨Ô(8ÐWÐWÈÌÐWÐWð 	õ " #Ñ&Ô&Ð&rD   )rT   r&   r;   r<   )r;   r    )rf   rg   rh   ri   rj   rk   r;   r<   )r;   rr   )rw   r%   rx   r(   r;   r%   )r;   r<   )r‰   rr   rŠ   rr   r;   r<   )r—   r   r˜   r™   rš   rR   r;   r›   )rc   r'   r§   rR   r;   r¨   )rc   r'   r˜   r™   r§   rR   r;   r¨   )
r˜   r™   rš   rR   rx   r¸   r¹   r™   r;   rº   )rÞ   rí   rx   r(   r;   r(   )ró   r   r;   rR   )rc   r   r;   rR   )ró   r   r;   r'   )r  r"   r  r   r;   r   )r  r  r  r  r;   r  )r  r  r  r0  r/  rR   r;   r    )
rš   rR   r˜   r™   rx   r¸   r¹   r™   r;   rA  )rK   rL   rM   rN   rS   Ú__annotations__rC   re   rq   rv   Ústaticmethodr…   rp   r–   r¦   r³   r·   rÔ   rì   rè   rn   rü   rþ   r  r  rb   r  r.  r  r   rK  rO   rD   rB   rQ   rQ   M   s—  € € € € € € ØSÐSð #ÐÐ"Ð"Ð"Ñ"ð ð  ð  ð  ðð ð ð ð ð  ð  ð  ð Fð Fð Fð Fð ð	ð 	ð 	ñ „\ð	ð*ð *ð *ð *ð ð6ð 6ð 6ñ „\ð6ð ð  ð  ð  ð< ð
ð 
ð 
ñ „\ð
ð3ð 3ð 3ð 3ð?ð ?ð ?ð ?ðB@(ð @(ð @(ð @(ðD ð  ð  ð  ð8 ðð ð ñ „\ðð ðð ð ñ „\ðð ðFð Fð Fñ „\ðFð ðð ð ñ „\ðð ðð ð ñ „\ðð+ð +ð +ð +ðZð ð ð ð ).ð ).ð ).ð ).ð^ *.Ø$(ð-ð -ð -ð -ð -ð -ðd #Ø!%Ø.2Ø*9ð*'ð *'ð *'ð *'ð *'ð *'ð *'ð *'rD   rQ   )>Ú
__future__r   r9  Úcollections.abcr   r   r   Ú
contextlibr   Úinspectr   r	   Útypingr
   r   r   r   rÆ   r   r{   Úpolars._utils.variousr   r   Úpolars.datatypesr   Úpolars.exceptionsr   r   r   Ú"polars.io.database._arrow_registryr   Ú"polars.io.database._cursor_proxiesr   r   r   Úpolars.io.database._inferencer   Úpolars.io.database._utilsr   Úsysr   Útypesr   ÚpyarrowÚpar   Úversion_infor    Útyping_extensionsr(  r"   Úsqlalchemy.sql.expressionr#   r%   Úpolars._typingr&   r'   r(   r6   rL  r8   rQ   rO   rD   rB   ú<module>rb     sÒ  ðØ "Ð "Ð "Ð "Ð "Ð "Ð "à 	€	€	€	Ø 9Ð 9Ð 9Ð 9Ð 9Ð 9Ð 9Ð 9Ð 9Ð 9Ø Ð Ð Ð Ð Ð Ø (Ð (Ð (Ð (Ð (Ð (Ð (Ð (Ø 2Ð 2Ð 2Ð 2Ð 2Ð 2Ð 2Ð 2Ð 2Ð 2Ð 2Ð 2à !Ð !Ð !Ð !Ð !Ð !Ø DÐ DÐ DÐ DÐ DÐ DÐ DÐ DØ ,Ð ,Ð ,Ð ,Ð ,Ð ,ðð ð ð ð ð ð ð ð ð ð
 EÐ DÐ DÐ DÐ DÐ Dðð ð ð ð ð ð ð ð ð ð
 HÐ GÐ GÐ GÐ GÐ GØ 0Ð 0Ð 0Ð 0Ð 0Ð 0àð FØ€J€J€JØ(Ð(Ð(Ð(Ð(Ð(Ø#Ð#Ð#Ð#Ð#Ð#àÐÐÐàHÐHÐHÐHÐHÐHà
Ô˜7Ò"Ð"ØÐÐÐÐÐÐà*Ð*Ð*Ð*Ð*Ð*à2Ð2Ð2Ð2Ð2Ð2Ø4Ð4Ð4Ð4Ð4Ð4à Ð Ð Ð Ð Ð ØEÐEÐEÐEÐEÐEÐEÐEÐEÐEð)ð )ð )Ð ð ð ð ñ ð"!ð !ð !ð !ð !ñ !ô !ð !ða'ð a'ð a'ð a'ð a'ñ a'ô a'ð a'ð a'ð a'rD   