a
    ï½„g¹6 ã                   @  sì  d dl mZ d dlZd dlmZ d dl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Zd dlmZ d dl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  mZ d dlZ d dlm!Z!m"Z"m#Z#m$Z$m%Z%m&Z&m'Z'm(Z(m)Z)m*Z* d dl+m,Z- d dl.m/Z/m0Z0 d dl1m2Z2 d dl3m4Z4 d dl5m6Z6m7Z7m8Z8m9Z9m:Z:m;Z;m<Z< e�r\d dl=Z=ej> ?d¡Z@ejAdd„ ƒZBdd„ ZCddœdd„ZDddœdd„ZEddœdd„ZFdd„ ZGdd œd!d"„ZHd#d$œd%d&„ZId#d$œd'd(„ZJd#dd)œd*d+„ZKd,d-„ ZLd.d/œd0d1„ZMdd2œd3d4„ZNejAd5d6„ ƒZOejAd7d8„ ƒZPejAd9d:„ ƒZQejAd;d<„ ƒZRejAd=d>„ ƒZSd?d@„ ZTdAdB„ ZUddCdDœdEdF„ZVddCdGœdHdI„ZWejAdJdK„ ƒZXejAdLdM„ ƒZYejAdNdO„ ƒZZejAdPdQ„ ƒZ[ejAdRdS„ ƒZ\ejAdTdU„ ƒZ]ejAdVdW„ ƒZ^ejAdXdY„ ƒZ_ejAdZd[„ ƒZ`ejAd\d]„ ƒZaejAd^d_„ ƒZbejAd`da„ ƒZcejAdbdc„ ƒZdejAddde„ ƒZeejAdfdg„ ƒZfejAdhdi„ ƒZgejAdjdk„ ƒZhejAdldm„ ƒZiejAdndo„ ƒZjejAdpdq„ ƒZkejAdrds„ ƒZlejAdtdu„ ƒZmejAdvdw„ ƒZnejAdxdy„ ƒZoejAdzd{„ ƒZpejAd|d}„ ƒZqejAd~d„ ƒZrejAd€d�„ ƒZsejAd‚dƒ„ ƒZtejAd„d…„ ƒZuejvdKej>jwd†�ejvdQej>jwd†�gZxejvdMej>jwd†�ejvdSej>jwd†�gZyejvdOej>jwd†�ejvdUej>jwd†�gZzejvdWej>jwd†�ejvd]ej>jwd†�gZ{ejvdYej>jwd†�ejvdeej>jwd†�gZ|ejvd[ej>jwd†�ejvdgej>jwd†�gZ}g d‡¢Z~g dˆ¢Zg d‰¢Z€exe{ e~ Z�eye| e Z‚eze} e€ Zƒd{ejvd_ej>jwd†�gZ„ejvdaej>jwd†�ejvd}ej>jwd†�gZ…ejvdcej>jwd†�ejvdej>jwd†�gZ†e�d�g e„ Z‡e‚dƒg e… Zˆeƒd…g e† Z‰ej> ŠdŠe‡¡d‹dŒ„ ƒZ‹ej> ŠdŠe‡¡d�dŽ„ ƒZŒej> ŠdŠe‡¡d�d�„ ƒZ�ej> ŠdŠe‡¡d‘d’„ ƒZŽej> ŠdŠe‡¡ej> Šd“dd”g¡d•d–„ ƒƒZ�ej> ŠdŠe‡¡ej> Šd—d˜d™g¡dšd›„ ƒƒZ�ej> ŠdŠe‡¡dœd�„ ƒZ‘ej> ŠdŠeˆ¡dždŸ„ ƒZ’ej> ŠdŠeˆ¡d d¡„ ƒZ“ej> ŠdŠe‚¡d¢d£„ ƒZ”ej> ŠdŠeˆ¡d¤d¥„ ƒZ•ej> ŠdŠe‚¡d¦d§„ ƒZ–ej> ŠdŠe‚¡d¨d©„ ƒZ—ej> ŠdŠe�¡dªd«„ ƒZ˜ej> ŠdŠe‰¡d¬d­„ ƒZ™ej> ŠdŠex¡d®d¯„ ƒZšej> ŠdŠe{¡ej> Šd°d±d²g¡d³d´„ ƒƒZ›ej> ŠdŠe{¡dµd¶„ ƒZœej> ŠdŠe‡¡d·d¸„ ƒZ�ej> ŠdŠex¡d¹dº„ ƒZžej> ŠdŠe{¡d»d¼„ ƒZŸd½d¾„ Z d¿dÀ„ Z¡dÁdÂ„ Z¢dÃdÄ„ Z£ej> ŠdŠeˆ¡dÅdÆ„ ƒZ¤ej> ŠdŠeˆ¡dÇdÈ„ ƒZ¥ej> ŠdŠeˆ¡dÉdÊ„ ƒZ¦ej> ŠdŠeˆ¡dËdÌ„ ƒZ§ej> ŠdŠeˆ¡dÍdÎ„ ƒZ¨ej> ŠdŠe‡¡dÏdÐ„ ƒZ©ej> ŠdŠe‡¡dÑdÒ„ ƒZªej> ŠdŠe‡¡dÓdÔ„ ƒZ«ej> ŠdŠe‡¡dÕdÖ„ ƒZ¬ej> ŠdŠe‡¡d×dØ„ ƒZ­ej> ŠdŠe‡¡dÙdÚ„ ƒZ®ej> ŠdŠe‡¡dÛdÜ„ ƒZ¯ej> ŠdŠe‡¡dÝdÞ„ ƒZ°ej> ŠdŠeˆ¡dßdà„ ƒZ±ej> ŠdŠe‰¡dádâ„ ƒZ²ej> ŠdŠe‰¡ej> Šdãg dä¢¡ej> Šdåe4j³dædçfe4j³dèdéfe4j;dædçfe4j<dèdéfg¡dêdë„ ƒƒƒZ´ej> ŠdŠe‰¡dìdí„ ƒZµej> ŠdŠe‡¡dîdï„ ƒZ¶ej> ŠdŠe‡¡dðdñ„ ƒZ·ej> ŠdŠe‡¡ej> Šdòg dó¢¡dôdõ„ ƒƒZ¸ej> ŠdŠe‡¡död÷„ ƒZ¹ej> ŠdŠe‡¡dødù„ ƒZºej> ŠdŠe‡¡ej> Šdúde»e¼e»e¼dûœg¡düdý„ ƒƒZ½ej> ŠdŠe‡¡dþdÿ„ ƒZ¾ej> ŠdŠe‡¡�d �d„ ƒZ¿ej> ŠdŠe‡¡�d�d„ ƒZÀej> ŠdŠe‡¡�d�d„ ƒZÁej> ŠdŠe‡¡�d�d„ ƒZÂej> ŠdŠe‡¡�d�d	„ ƒZÃej> ŠdŠe‡¡�d
�d„ ƒZÄej> ŠdŠe‡¡�d�d„ ƒZÅej> ŠdŠe‡¡�d�d„ ƒZÆej> ŠdŠe‡¡�d�d„ ƒZÇej> ŠdŠe‡¡�d�d„ ƒZÈej> ŠdŠe‡¡�d�d„ ƒZÉej> ŠdŠeˆ¡�d�d„ ƒZÊ�d�d„ ZËej> ŠdŠe‡¡�d�d„ ƒZÌej> ŠdŠe�¡�d�d„ ƒZÍej> ŠdŠe�¡ej> Š�d�d�d �d!�d"�d#�d$�d%�d&�d'�d(�d)�d*�d+�d,e»e Îe»¡jÏ�d-k�rP�d.n�d/fg¡�d0�d1„ ƒƒZÐej> ŠdŠe�¡ej> Š�d2�d3�d4g¡�d5�d6„ ƒƒZÑej> ŠdŠe‡¡�d7�d8„ ƒZÒe Ó�d9¡ej> ŠdŠe‡¡�d:�d;„ ƒƒZÔej> ŠdŠe‚¡�d<�d=„ ƒZÕej> ŠdŠe‚¡�d>�d?„ ƒZÖej> ŠdŠe‡¡�d@�dA„ ƒZ×�dB�dC„ ZØe Ódé¡�dD�dE„ ƒZÙe Ódé¡�dF�dG„ ƒZÚ�dH�dI„ ZÛ�dJ�dK„ ZÜ�dL�dM„ ZÝej> ŠdŠe�¡�dN�dO„ ƒZÞej> ŠdŠe�¡�dP�dQ„ ƒZßej> ŠdŠe‡¡�dR�dS„ ƒZàej> ŠdŠeˆ¡�dT�dU„ ƒZáej> ŠdŠe‚¡�dV�dW„ ƒZâej> ŠdŠe‚¡�dX�dY„ ƒZãej> ŠdŠe‚¡�dZ�d[„ ƒZäej> ŠdŠeƒ¡�d\�d]„ ƒZåej> ŠdŠe�¡�d^�d_„ ƒZæej> ŠdŠeƒ¡�d`�da„ ƒZçej> ŠdŠe{¡ej> Š�dbd�dcgg¡�dd�de„ ƒƒZèej> ŠdŠe{¡�df�dg„ ƒZéej> ŠdŠe{¡�dh�di„ ƒZêej> ŠdŠe�¡�dj�dk„ ƒZëej> ŠdŠe�¡�dl�dm„ ƒZìej> ŠdŠe�¡�dn�do„ ƒZíej> ŠdŠeƒ¡�dp�dq„ ƒZîej> ŠdŠe�¡�dr�ds„ ƒZïej> ŠdŠe�¡�dt�du„ ƒZðej> ŠdŠe�¡�dv�dw„ ƒZñej> ŠdŠe�¡�dx�dy„ ƒZòej> ŠdŠe�¡�dz�d{„ ƒZóej> ŠdŠe�¡�d|�d}„ ƒZôej> ŠdŠe�¡�d~�d„ ƒZõej> ŠdŠe�¡�d€�d�„ ƒZöej> ŠdŠe‡¡�d‚�dƒ„ ƒZ÷ej> ŠdŠe‡¡�d„�d…„ ƒZøej> ŠdŠe‡¡�d†�d‡„ ƒZùej> ŠdŠe�¡�dˆ�d‰„ ƒZúej> ŠdŠe�¡�dŠ�d‹„ ƒZûej> ŠdŠe�¡�dŒ�d�„ ƒZüej> ŠdŠe�¡�dŽ�d�„ ƒZýej> ŠdŠe�¡�d��d‘„ ƒZþej> ŠdŠe�¡ej> Š�d’�d“ejÿgi�d“ejÿ giejÿ g�d”g�d•œg¡�d–�d—„ ƒƒ�Z ej> ŠdŠe�¡�d˜�d™„ ƒ�Zej> ŠdŠe‡¡�dš�d›„ ƒ�Zej> ŠdŠe‡¡�dœ�d�„ ƒ�Zej> ŠdŠe�¡�dž�dŸ„ ƒ�Zej> ŠdŠe‡¡�d �d¡„ ƒ�Z�d¢�d£„ �Z�d¤�d¥„ �Zej> ŠdŠe‡¡ej> Š�d¦�d§�d¨g¡�d©�dª„ ƒƒ�Zej> ŠdŠe‡¡ej> Š�d¦�d§�d«g¡�d¬�d­„ ƒƒ�Z	ej> ŠdŠe‡¡ej> Š�d¦g �d®¢¡�d¯�d°„ ƒƒ�Z
ejAd.�d±œ�d²�d³„ƒ�ZejA�d´�dµ„ ƒ�Zej> ŠdŠe‡¡�d¶�d·„ ƒ�Zej> ŠdŠe‡¡ej> Š�d¸e�j�d¹g¡ej> Š�d¦�d§�d¨g¡�dº�d»„ ƒƒƒ�Z�d¼�d½„ �Z�d¾�d¿„ �Z�dÀ�dÁ„ �Z�dÂ�dÃ„ �Z�dÄ�dÅ„ �Z�dÆ�dÇ„ �ZejA�dÈ�dÉ„ ƒ�Z�dÊ�dË„ �Zej>jw�dÌ�dÍ„ ƒ�Zej>jw�dÎ�dÏ„ ƒ�Z�dÐ�dÑ„ �Z�dÒ�dÓ„ �Zej> Š�dÔ�dÕ�dÖg¡�d×�dØ„ ƒ�Z�dÙ�dÚ„ �Z�dÛ�dÜ„ �Z�dÝ�dÞ„ �Z�dß�dà„ �Z �dá�dâ„ �Z!�d÷�dã�dä„�Z"�då�dæ„ �Z#�dç�dè„ �Z$�dé�dê„ �Z%�dë�dì„ �Z&�dí�dî„ �Z'�dï�dð„ �Z(�dñ�dò„ �Z)�dó�dô„ �Z*�dõ�dö„ �Z+dS (ø  é    )ÚannotationsN)Úclosing)ÚdateÚdatetimeÚtimeÚ	timedelta)ÚStringIO©ÚPath)ÚTYPE_CHECKING)Úlib)Úpa_version_under13p0Úpa_version_under14p1)Úimport_optional_dependency)
Ú	DataFrameÚIndexÚ
MultiIndexÚSeriesÚ	TimestampÚconcatÚ
date_rangeÚisnaÚto_datetimeÚto_timedelta)ÚArrowStringArrayÚStringArray)ÚVersion)Úsql)ÚSQLAlchemyEngineÚSQLDatabaseÚSQLiteDatabaseÚ
get_engineÚpandasSQL_builderÚread_sql_queryÚread_sql_tablez=ignore:Passing a BlockManager to DataFrame:DeprecationWarningc                   C  s$   ddddœddddœdd	d
dœdœS )Nz1SELECT * FROM iris WHERE Name=? AND SepalLength=?z7SELECT * FROM iris WHERE `Name`=%s AND `SepalLength`=%sz7SELECT * FROM iris WHERE "Name"=%s AND "SepalLength"=%s)ÚsqliteÚmysqlÚ
postgresqlz]
                SELECT * FROM iris WHERE Name=:name AND SepalLength=:length
                zw
                SELECT * FROM iris WHERE
                `Name`=%(name)s AND `SepalLength`=%(length)s
                zw
                SELECT * FROM iris WHERE
                "Name"=%(name)s AND "SepalLength"=%(length)s
                z&SELECT * FROM iris WHERE Name LIKE '%'z(SELECT * FROM iris WHERE `Name` LIKE '%'z(SELECT * FROM iris WHERE "Name" LIKE '%')Úread_parametersÚread_named_parametersÚread_no_parameters_with_percent© r+   r+   r+   ú[/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/site-packages/pandas/tests/io/test_sql.pyÚsql_stringsE   s    ýøýír-   c            
      C  s‚   dd l } ddl m}m}m}m}m}m} t| jƒtdƒkr>|n|}|ƒ }|d||d|ƒ|d|ƒ|d|ƒ|d|ƒ|d	|d
ƒƒƒ}	|	S )Nr   )ÚColumnÚDoubleÚFloatÚMetaDataÚStringÚTablez2.0.0ÚirisÚSepalLengthÚ
SepalWidthZPetalLengthZ
PetalWidthÚNameéÈ   )	Ú
sqlalchemyr.   r/   r0   r1   r2   r3   r   Ú__version__)
r9   r.   r/   r0   r1   r2   r3   ÚdtypeÚmetadatar4   r+   r+   r,   Úiris_table_metadatab   s     	ù	r=   r
   )Ú	iris_filec                 C  sŒ   d}|   ¡ }| |¡ |jd dd��D}t |¡}t|ƒ d}g }dd„ |D ƒ}| ||¡ W d   ƒ n1 sn0    Y  | ¡  |  ¡  d S )Nz³CREATE TABLE iris (
            "SepalLength" REAL,
            "SepalWidth" REAL,
            "PetalLength" REAL,
            "PetalWidth" REAL,
            "Name" TEXT
        )úutf-8©ÚnewlineÚencodingz&INSERT INTO iris VALUES(?, ?, ?, ?, ?)c                 S  s>   g | ]6}t |d  ƒt |d ƒt |d ƒt |d ƒ|d f‘qS ©r   é   é   é   é   ©Úfloat©Ú.0Úrowr+   r+   r,   Ú
<listcomp>Œ   s   ú



ûz0create_and_load_iris_sqlite3.<locals>.<listcomp>)	ÚcursorÚexecuteÚopenÚcsvÚreaderÚnextÚexecutemanyÚcloseÚcommit©Úconnr>   ÚstmtÚcurÚcsvfilerR   Úrecordsr+   r+   r,   Úcreate_and_load_iris_sqlite3{   s    

ø*r]   c              	   C  s    d}|   ¡ �x}| |¡ |jd dd��@}t |¡}t|ƒ d}dd„ |D ƒ}| ||¡ W d   ƒ n1 sl0    Y  W d   ƒ n1 sŠ0    Y  |  ¡  d S )NzãCREATE TABLE iris (
            "SepalLength" DOUBLE PRECISION,
            "SepalWidth" DOUBLE PRECISION,
            "PetalLength" DOUBLE PRECISION,
            "PetalWidth" DOUBLE PRECISION,
            "Name" TEXT
        )r?   r@   z+INSERT INTO iris VALUES($1, $2, $3, $4, $5)c                 S  s>   g | ]6}t |d  ƒt |d ƒt |d ƒt |d ƒ|d f‘qS rC   rH   rJ   r+   r+   r,   rM   ¬   s   ú



ûz3create_and_load_iris_postgresql.<locals>.<listcomp>)rN   rO   rP   rQ   rR   rS   rT   rV   rW   r+   r+   r,   Úcreate_and_load_iris_postgresql�   s    


øHr^   c           	   	     sÂ   ddl m} tƒ }|jd dd��Ž}t |¡}t|ƒ‰ ‡ fdd„|D ƒ}||ƒ |¡}|  ¡ �4}|j	|dd� |j
|d	� | |¡ W d   ƒ n1 s–0    Y  W d   ƒ n1 s´0    Y  d S )
Nr   ©Úinsertr?   r@   c                   s   g | ]}t tˆ |ƒƒ‘qS r+   ©ÚdictÚziprJ   ©Úheaderr+   r,   rM   Ä   ó    z(create_and_load_iris.<locals>.<listcomp>T©Z
checkfirst©Úbind)r9   r`   r=   rP   rQ   rR   rS   ÚvaluesÚbeginÚdropÚcreaterO   )	rX   r>   r`   r4   r[   rR   ÚparamsrY   Úconr+   rd   r,   Úcreate_and_load_iris¼   s    

rp   c                 C  sÆ   d}t | tjƒr$|  ¡ }| |¡ nžtddd�}|r|t | |jƒr||  ¡ �}| |¡ W d   ƒ n1 sh0    Y  |  ¡  nFddlm} ||ƒ}|  	¡ �}| |¡ W d   ƒ n1 s¸0    Y  d S )Nz+CREATE VIEW iris_view AS SELECT * FROM irisúadbc_driver_manager.dbapiÚignore©Úerrorsr   ©Útext)
Ú
isinstanceÚsqlite3Ú
ConnectionrN   rO   r   rV   r9   rv   rk   )rX   rY   rZ   Úadbcrv   ro   r+   r+   r,   Úcreate_and_load_iris_viewÌ   s    
(

r{   Ústr)Údialectc                 C  s¤   ddl m}m}m}m}m}m}m}m} | dkr4|n|}	| dkrD|n|}
|ƒ }|d||d|ƒ|d|	ƒ|d|ƒ|d|ƒ|d	|ƒ|d
|ƒ|d|
ƒ|d|ƒ|d|
ƒƒ}|S )Nr   )ÚTEXTÚBooleanr.   ÚDateTimer0   ÚIntegerr1   r3   r%   ÚtypesÚTextColÚDateColÚ
IntDateColÚIntDateOnlyColÚFloatColÚIntColÚBoolColÚIntColWithNullÚBoolColWithNull)	r9   r~   r   r.   r€   r0   r�   r1   r3   )r}   r~   r   r.   r€   r0   r�   r1   r3   Z	date_typeZ	bool_typer<   r‚   r+   r+   r,   Útypes_table_metadataß   s$    (õrŒ   z
list[dict])Ú
types_datac                 C  s~   d}d}t | tjƒr4|  ¡ }| |¡ | ||¡ nF|  ¡ �&}| |¡ | ||¡ W d   ƒ n1 sh0    Y  |  ¡  d S )Na”  CREATE TABLE types (
                    "TextCol" TEXT,
                    "DateCol" TEXT,
                    "IntDateCol" INTEGER,
                    "IntDateOnlyCol" INTEGER,
                    "FloatCol" REAL,
                    "IntCol" INTEGER,
                    "BoolCol" INTEGER,
                    "IntColWithNull" INTEGER,
                    "BoolColWithNull" INTEGER
                )ze
                INSERT INTO types
                VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)
                )rw   rx   ry   rN   rO   rT   rV   )rX   r�   rY   Zins_stmtrZ   r+   r+   r,   Úcreate_and_load_types_sqlite3þ   s    


*rŽ   c                 C  sR   |   ¡ �.}d}| |¡ d}| ||¡ W d   ƒ n1 s<0    Y  |  ¡  d S )NaÍ  CREATE TABLE types (
                        "TextCol" TEXT,
                        "DateCol" TIMESTAMP,
                        "IntDateCol" INTEGER,
                        "IntDateOnlyCol" INTEGER,
                        "FloatCol" DOUBLE PRECISION,
                        "IntCol" INTEGER,
                        "BoolCol" BOOLEAN,
                        "IntColWithNull" INTEGER,
                        "BoolColWithNull" BOOLEAN
                    )zy
                INSERT INTO types
                VALUES($1, $2::timestamp, $3, $4, $5, $6, $7, $8, $9)
                )rN   rO   rT   rV   )rX   r�   rZ   rY   r+   r+   r,   Ú create_and_load_types_postgresql  s    

*r�   )r�   r}   c              	   C  sþ   ddl m} ddlm} t|ƒ}||ƒ |¡}t| |ƒr®|  ¡ �\} |  ¡ �4 |j	| dd� |j
| d� |  |¡ W d   ƒ n1 s„0    Y  W d   ƒ qú1 s¢0    Y  nL|  ¡ �4 |j	| dd� |j
| d� |  |¡ W d   ƒ n1 sð0    Y  d S )Nr   r_   ©ÚEngineTrg   rh   )r9   r`   Úsqlalchemy.enginer‘   rŒ   rj   rw   Úconnectrk   rl   rm   rO   )rX   r�   r}   r`   r‘   r‚   rY   r+   r+   r,   Úcreate_and_load_types5  s    


H
r”   c              	   C  sV  ddl m}m}m}m}m} ddlm} |ƒ }|d||d|dd�ƒƒ}ddidd	ig}	||ƒ |	¡}
t	| |ƒrä|  
¡ �\} |  ¡ �4 |j| dd
� |j| d� |  |
¡ W d   ƒ n1 sº0    Y  W d   ƒ n1 sØ0    Y  nN|  ¡ �4 |j| dd
� |j| d� |  |
¡ W d   ƒ n1 �s(0    Y  tddd�tddd�g}t|dd�S )Nr   )r.   r€   r1   r3   r`   r�   ÚdatetzÚDateColWithTzT)Útimezonez2000-01-01 00:00:00-08:00z2000-06-01 00:00:00-07:00rg   rh   z2000-01-01 08:00:00ÚUTC©Útzz2000-06-01 07:00:00©Úname)r9   r.   r€   r1   r3   r`   r’   r‘   rj   rw   r“   rk   rl   rm   rO   r   r   )rX   r.   r€   r1   r3   r`   r‘   r<   r•   Zdatetz_datarY   Zexpected_datar+   r+   r,   Úcreate_and_load_postgres_datetzI  s0    ÿÿü


H
*

þr�   r   ©Úframec                 C  sV   | j jd j}| jd }t|tjƒs(J ‚t |tg d¢| j	dd�¡ | j
dv sRJ ‚d S )Nr   ©çffffff@g      @gffffffö?çš™™™™™É?úIris-setosa)Úindexrœ   ))é–   é   )é   r¦   )ÚdtypesÚilocÚtypeÚ
issubclassÚnpÚfloatingÚtmÚassert_series_equalr   ÚcolumnsÚshape)rŸ   ZpytyperL   r+   r+   r,   Úcheck_iris_framev  s    
ÿr²   )Ú
table_namec                 C  sl  d|› �}t ddd�}t| tjƒr<|  ¡ }| |¡ ¡ d S |rŒt| |jƒrŒ|  ¡ �&}| |¡ | ¡ d W  d   ƒ S 1 s€0    Y  nÜddlm} ddl	m
} t| tƒ�rzV|| ƒ}| ¡ �(} |  |¡ ¡ W  d   ƒ W | ¡  S 1 � sò0    Y  W | ¡  n
| ¡  0 nTt| |ƒ�rZ|  ¡ �} |  |¡ ¡ W  d   ƒ S 1 �sN0    Y  n|  |¡ ¡ S d S )Nz SELECT count(*) AS count_1 FROM rq   rr   rs   r   )Úcreate_enginer�   )r   rw   rx   ry   rN   rO   Úfetchoner9   r´   r’   r‘   r|   r“   Úexec_driver_sqlZ
scalar_oneÚdispose)rX   r³   rY   rz   rZ   r´   r‘   Úenginer+   r+   r,   Ú
count_rows€  s.    


,
þ
0r¹   c                 C  s   | ddddƒ}t |ƒS )NÚioÚdatarQ   ziris.csvr	   )ÚdatapathÚ	iris_pathr+   r+   r,   r½   œ  s    r½   c                   C  s0   ddddddddddœ	dd	d
ddddd d dœ	gS )NÚfirstú2000-01-03 00:00:00i wði’·2g333333$@rD   F©	rƒ   r„   r…   r†   r‡   rˆ   r‰   rŠ   r‹   ú2000-01-04 00:00:00i 'âPi\¸2r+   r+   r+   r+   r,   r�   ¢  s*    ÷÷ôr�   c              
   C  s2   ddddddddddœ	}t | ƒ}|| ¡   |¡S )Nr|   Úint64rI   rÀ   )r   ÚkeysÚastype)r�   r¨   Údfr+   r+   r,   Útypes_data_frame¾  s    ÷rÆ   c                  C  s   g d¢} g d¢}t || d�S )N)r¤   ÚAÚBÚCÚD))r¿   gNÿ\^ï?g9\›x`|@g%Ú TO×¿gá(nIŽò¿)rÁ   gî}ÒCÄð?çc×^ÜV¥¿g~q"B¶Ä¿gˆ”æÐ4Ë?)ú2000-01-05 00:00:00gGà Í¿èß?ç2rÂ¹eç?gˆŽ>Ý¦4á¿gÑ‘öÙRŠõ?)ú2000-01-06 00:00:00gÔ?{mXìñ?ç$ôó­ùù?gnk3¥AÓm?gØ
S«›å?©r°   ©r   ©r°   r»   r+   r+   r,   Útest_frame1Ï  s    rÓ   c                  C  s   g d¢} g d¢}t || d�S )N)r¤   rÇ   rÈ   ))r¿   iÿÿÿgZØÓÍÿ¿)rÁ   iãÿÿÿrË   )rÌ   i N  rÍ   )rÎ   iÍ�ûÿrÏ   rÐ   rÑ   rÒ   r+   r+   r,   Útest_frame3ó  s    rÔ   c           
      C  sÌ   t | tjƒr(|  d¡}dd„ | ¡ D ƒS tddd�}|r°t | |jƒr°g }|  ¡  ¡  ¡ }|D ]N}|d  |d D ]8}|d	  |d
 D ]"}|d dkr„|d }| 	|¡ q„qpq\|S ddl
m}	 |	| ƒ ¡ S d S )Nz0SELECT name FROM sqlite_master WHERE type='view'c                 S  s   g | ]}|d  ‘qS ©r   r+   )rK   Úviewr+   r+   r,   rM     rf   z!get_all_views.<locals>.<listcomp>rq   rr   rs   Zcatalog_nameÚcatalog_db_schemasZdb_schema_nameÚdb_schema_tablesÚ
table_typerÖ   r³   r   ©Úinspect)rw   rx   ry   rO   Úfetchallr   Úadbc_get_objectsÚread_allÚ	to_pylistÚappendr9   rÛ   Zget_view_names)
rX   Úcrz   ÚresultsÚinfoÚcatalogÚschemaÚtableÚ	view_namerÛ   r+   r+   r,   Úget_all_viewsÿ  s$    
rè   c           
      C  s¼   t | tjƒr(|  d¡}dd„ | ¡ D ƒS tddd�}|r t | |jƒr g }|  ¡  ¡  ¡ }|D ]>}|d D ]0}|d D ]"}|d	 d
krt|d }| 	|¡ qtqhq\|S ddl
m}	 |	| ƒ ¡ S d S )Nz1SELECT name FROM sqlite_master WHERE type='table'c                 S  s   g | ]}|d  ‘qS rÕ   r+   )rK   ræ   r+   r+   r,   rM     rf   z"get_all_tables.<locals>.<listcomp>rq   rr   rs   r×   rØ   rÙ   ræ   r³   r   rÚ   )rw   rx   ry   rO   rÜ   r   rÝ   rÞ   rß   rà   r9   rÛ   Zget_table_names)
rX   rá   rz   râ   rã   rä   rå   ræ   r³   rÛ   r+   r+   r,   Úget_all_tables  s     
ré   zLsqlite3.Connection | sqlalchemy.engine.Engine | sqlalchemy.engine.Connection)r³   rX   c              	   C  sä   t |tjƒr,| dt | ¡› �¡ | ¡  n´tddd�}|r„t ||jƒr„| ¡ �"}| d| › d�¡ W d   ƒ qà1 sx0    Y  n\| 	¡ �D}t 
|¡�}| | ¡ W d   ƒ n1 s¸0    Y  W d   ƒ n1 sÖ0    Y  d S )NzDROP TABLE IF EXISTS rq   rr   rs   zDROP TABLE IF EXISTS "ú")rw   rx   ry   rO   r   Ú_get_valid_sqlite_namerV   r   rN   rk   r   Ú
drop_table)r³   rX   rz   rZ   ro   Údbr+   r+   r,   rì   0  s    

2
rì   )rç   rX   c                 C  sâ   dd l }t|tjƒr4| dt | ¡› �¡ | ¡  nªtddd�}|rŒt||jƒrŒ| 	¡ �"}| d| › d�¡ W d   ƒ qÞ1 s€0    Y  nR|j
jj | ¡}| d|› �¡}| ¡ �}| |¡ W d   ƒ n1 sÔ0    Y  d S )Nr   zDROP VIEW IF EXISTS rq   rr   rs   zDROP VIEW IF EXISTS "rê   )r9   rw   rx   ry   rO   r   rë   rV   r   rN   r¸   r}   Zidentifier_preparerZquote_identifierrv   rk   )rç   rX   r9   rz   rZ   Zquoted_viewrY   ro   r+   r+   r,   Ú	drop_viewC  s    

2
ÿ
rî   c                  c  st   t  d¡} t  d¡}| jdd|jjji| jjd�}|V  t|ƒD ]}t	||ƒ q@t
|ƒD ]}t||ƒ qX| ¡  d S )Nr9   Úpymysqlz*mysql+pymysql://root@localhost:3306/pandasZclient_flag)Zconnect_argsÚ	poolclass)ÚpytestÚimportorskipr´   Ú	constantsZCLIENTZMULTI_STATEMENTSÚpoolÚNullPoolrè   rî   ré   rì   r·   )r9   rï   r¸   rÖ   Útblr+   r+   r,   Úmysql_pymysql_engineZ  s    

ýr÷   c                 c  s   t | |ƒ t| ƒ | V  d S ©N©rp   r{   )r÷   r½   r+   r+   r,   Úmysql_pymysql_engine_irisk  s    
rú   c                 c  s   t | |dƒ | V  d S )Nr&   ©r”   )r÷   r�   r+   r+   r,   Úmysql_pymysql_engine_typesr  s    rü   c                 c  s2   |   ¡ �}|V  W d   ƒ n1 s$0    Y  d S rø   ©r“   )r÷   rX   r+   r+   r,   Úmysql_pymysql_connx  s    
rþ   c                 c  s2   |   ¡ �}|V  W d   ƒ n1 s$0    Y  d S rø   rý   )rú   rX   r+   r+   r,   Úmysql_pymysql_conn_iris~  s    
rÿ   c                 c  s2   |   ¡ �}|V  W d   ƒ n1 s$0    Y  d S rø   rý   )rü   rX   r+   r+   r,   Úmysql_pymysql_conn_types„  s    
r   c                  c  sh   t  d¡} t  d¡ | jd| jjd�}|V  t|ƒD ]}t||ƒ q4t|ƒD ]}t||ƒ qL| 	¡  d S )Nr9   Zpsycopg2z=postgresql+psycopg2://postgres:postgres@localhost:5432/pandas©rð   ©
rñ   rò   r´   rô   rõ   rè   rî   ré   rì   r·   )r9   r¸   rÖ   rö   r+   r+   r,   Úpostgresql_psycopg2_engineŠ  s    

þr  c                 c  s   t | |ƒ t| ƒ | V  d S rø   rù   )r  r½   r+   r+   r,   Úpostgresql_psycopg2_engine_irisš  s    
r  c                 c  s   t | |dƒ | V  d S )NÚpostgresrû   )r  r�   r+   r+   r,   Ú postgresql_psycopg2_engine_types¡  s    r  c                 c  s2   |   ¡ �}|V  W d   ƒ n1 s$0    Y  d S rø   rý   )r  rX   r+   r+   r,   Úpostgresql_psycopg2_conn§  s    
r  c                  c  s†   t  d¡ ddlm}  d}|  |¡�N}|V  t|ƒD ]}t||ƒ q4t|ƒD ]}t||ƒ qL| 	¡  W d   ƒ n1 sx0    Y  d S )NÚadbc_driver_postgresqlr   ©Údbapiz4postgresql://postgres:postgres@localhost:5432/pandas)
rñ   rò   r  r
  r“   rè   rî   ré   rì   rV   )r
  ÚurirX   rÖ   rö   r+   r+   r,   Úpostgresql_adbc_conn­  s    
r  c                 c  s€   dd l }| }z| d¡ W n& |jy@   | ¡  t||ƒ Y n0 z| d¡ W n$ |jyt   | ¡  t|ƒ Y n0 |V  d S ©Nr   r4   Z	iris_view)Úadbc_driver_managerÚadbc_get_table_schemaÚProgrammingErrorÚrollbackr^   r{   )r  r½   ÚmgrrX   r+   r+   r,   Úpostgresql_adbc_iris¼  s    r  c                 c  sZ   dd l }| }z| d¡ W n4 |jyN   | ¡  dd„ |D ƒ}t||ƒ Y n0 |V  d S )Nr   r‚   c                 S  s   g | ]}t | ¡ ƒ‘qS r+   ©Útuplerj   ©rK   Úentryr+   r+   r,   rM   Ù  rf   z)postgresql_adbc_types.<locals>.<listcomp>)r  r  r  r  r�   )r  r�   r  rX   Únew_datar+   r+   r,   Úpostgresql_adbc_typesÏ  s    r  c                 c  s2   |   ¡ �}|V  W d   ƒ n1 s$0    Y  d S rø   rý   )r  rX   r+   r+   r,   Úpostgresql_psycopg2_conn_irisà  s    
r  c                 c  s2   |   ¡ �}|V  W d   ƒ n1 s$0    Y  d S rø   rý   )r  rX   r+   r+   r,   Úpostgresql_psycopg2_conn_typesæ  s    
r  c                  c  sB   t  d¡ t ¡ �} d| › �V  W d   ƒ n1 s40    Y  d S )Nr9   ú
sqlite:///)rñ   rò   r®   Úensure_cleanr›   r+   r+   r,   Ú
sqlite_strì  s    

r  c                 c  s^   t  d¡}|j| |jjd�}|V  t|ƒD ]}t||ƒ q*t|ƒD ]}t||ƒ qB| 	¡  d S )Nr9   r  r  )r  r9   r¸   rÖ   rö   r+   r+   r,   Úsqlite_engineó  s    
r  c                 c  s2   |   ¡ �}|V  W d   ƒ n1 s$0    Y  d S rø   rý   )r  rX   r+   r+   r,   Úsqlite_connÿ  s    
r   c                 C  s2   t  d¡}| | ¡}t||ƒ t|ƒ | ¡  | S )Nr9   )rñ   rò   r´   rp   r{   r·   )r  r½   r9   r¸   r+   r+   r,   Úsqlite_str_iris  s    


r!  c                 c  s   t | |ƒ t| ƒ | V  d S rø   rù   )r  r½   r+   r+   r,   Úsqlite_engine_iris  s    
r"  c                 c  s2   |   ¡ �}|V  W d   ƒ n1 s$0    Y  d S rø   rý   )r"  rX   r+   r+   r,   Úsqlite_conn_iris  s    
r#  c                 C  s,   t  d¡}| | ¡}t||dƒ | ¡  | S )Nr9   r%   )rñ   rò   r´   r”   r·   )r  r�   r9   r¸   r+   r+   r,   Úsqlite_str_types  s
    

r$  c                 c  s   t | |dƒ | V  d S )Nr%   rû   )r  r�   r+   r+   r,   Úsqlite_engine_types%  s    r%  c                 c  s2   |   ¡ �}|V  W d   ƒ n1 s$0    Y  d S rø   rý   )r%  rX   r+   r+   r,   Úsqlite_conn_types+  s    
r&  c               	   c  s´   t  d¡ ddlm}  t ¡ �‚}d|› �}|  |¡�N}|V  t|ƒD ]}t||ƒ qDt	|ƒD ]}t
||ƒ q\| ¡  W d   ƒ n1 sˆ0    Y  W d   ƒ n1 s¦0    Y  d S )NÚadbc_driver_sqliter   r	  zfile:)rñ   rò   r'  r
  r®   r  r“   rè   rî   ré   rì   rV   )r
  rœ   r  rX   rÖ   rö   r+   r+   r,   Úsqlite_adbc_conn1  s    


r(  c                 c  s€   dd l }| }z| d¡ W n& |jy@   | ¡  t||ƒ Y n0 z| d¡ W n$ |jyt   | ¡  t|ƒ Y n0 |V  d S r  )r  r  r  r  r]   r{   )r(  r½   r  rX   r+   r+   r,   Úsqlite_adbc_irisA  s    r)  c              	   c  s    dd l }| }z| d¡ W nz |jy”   | ¡  g }|D ]B}t|d ƒ|d< |d d urjt|d ƒ|d< | t| ¡ ƒ¡ q:t||ƒ | 	¡  Y n0 |V  d S )Nr   r‚   r‰   r‹   )
r  r  r  r  Úintrà   r  rj   rŽ   rV   )r(  r�   r  rX   r  r  r+   r+   r,   Úsqlite_adbc_typesS  s    
r+  c               	   c  s^   t  t d¡¡�:} | �}|V  W d   ƒ n1 s20    Y  W d   ƒ n1 sP0    Y  d S )Nú:memory:)Ú
contextlibr   rx   r“   ©Zclosing_connrX   r+   r+   r,   Úsqlite_buildini  s    r/  c                 c  s   t | |ƒ t| ƒ | V  d S rø   )r]   r{   )r/  r½   r+   r+   r,   Úsqlite_buildin_irisp  s    
r0  c                 c  s"   dd„ |D ƒ}t | |ƒ | V  d S )Nc                 S  s   g | ]}t | ¡ ƒ‘qS r+   r  r  r+   r+   r,   rM   y  rf   z(sqlite_buildin_types.<locals>.<listcomp>)rŽ   )r/  r�   r+   r+   r,   Úsqlite_buildin_typesw  s    
r1  )Zmarks)r  r   r  )r"  r#  r!  )r%  r&  r$  rX   c                 C  s    |  | ¡} |jd| ddd� d S )NÚtestrà   F©rœ   ro   Ú	if_existsr¤   )ÚgetfixturevalueÚto_sql)rX   rÓ   Úrequestr+   r+   r,   Útest_dataframe_to_sqlÓ  s    
r8  c                 C  sN   | dkr |j  tjjddd�¡ | | ¡} |jd d… }|jd| ddd	� d S )
Nr  z7postgres ADBC driver cannot insert index with null typeT©ÚreasonÚstrictr   r2  rà   Fr3  )ÚnodeÚ
add_markerrñ   ÚmarkÚxfailr5  r©   r6  )rX   rÓ   r7  Zempty_dfr+   r+   r,   Útest_dataframe_to_sql_emptyÚ  s    þÿ
r@  c              	   C  sü   t  d¡ ttjdgdd�tjtdddƒgdd�tjtdddƒgdd�tjtdƒgdd�tjd	gd
d�dœƒ}d| v r¤| dkrŒ|jdgd�}t	ršt
}d}q¬d }d}nt}d}| | ¡} tj||dd��" |jd| ddd� W d   ƒ n1 sî0    Y  d S )NÚpyarrowrD   zint8[pyarrow]©r;   éç  útimestamp[ns][pyarrow]zdate32[day][pyarrow]zduration[ns][pyarrow]Úazstring[pyarrow])r*  r   r   r   Ústringrz   r(  r   rÐ   zis_sparse is deprecatedÚ zthe 'timedelta'F)ÚmatchÚcheck_stacklevelÚ
test_arrowÚreplacer3  )rñ   rò   r   ÚpdÚarrayr   r   r   rl   r   ÚDeprecationWarningÚUserWarningr5  r®   Úassert_produces_warningr6  )rX   r7  rÅ   Úexp_warningÚmsgr+   r+   r,   Ú"test_dataframe_to_sql_arrow_dtypesé  s0    
ÿùÿ
rS  c                 C  sL   t  d¡ tdtjtdddƒ|gdd�iƒ}| | ¡} |jd| dd	d
� d S )NrA  r   rC  rD   rD  rB  rJ  rK  Fr3  )rñ   rò   r   rL  rM  r   r5  r6  )rX   r7  Znulls_fixturerÅ   r+   r+   r,   Ú*test_dataframe_to_sql_arrow_dtypes_missing  s    
ÿÿÿ
rT  ÚmethodÚmultic                 C  s–   |dkr(d| v r(|j  tjjddd�¡ | | ¡} t| dd��.}|j|d|d� | d¡s^J ‚W d   ƒ n1 sr0    Y  t	| dƒt
|ƒks’J ‚d S )	NrV  rz   z)'method' not implemented for ADBC driversTr9  ©Zneed_transactionÚ
test_frame©rU  )r<  r=  rñ   r>  r?  r5  r"   r6  Ú	has_tabler¹   Úlen)rX   rU  rÓ   r7  Ú	pandasSQLr+   r+   r,   Útest_to_sql  s    ÿÿ
,r]  zmode, num_row_coef)rK  rD   )rà   rE   c                 C  s‚   |  | ¡} t| dd��>}|j|ddd� |j|d|d� | d¡sFJ ‚W d   ƒ n1 sZ0    Y  t| dƒ|t|ƒ ks~J ‚d S )NTrW  rX  Úfail©r4  ©r5  r"   r6  rZ  r¹   r[  )rX   ÚmodeZnum_row_coefrÓ   r7  r\  r+   r+   r,   Útest_to_sql_exist+  s    
,rb  c              	   C  sš   |  | ¡} t| dd��p}|j|ddd� | d¡s6J ‚d}tjt|d��  |j|ddd� W d   ƒ n1 sn0    Y  W d   ƒ n1 sŒ0    Y  d S )NTrW  rX  r^  r_  z!Table 'test_frame' already exists©rH  )r5  r"   r6  rZ  rñ   ÚraisesÚ
ValueError)rX   rÓ   r7  r\  rR  r+   r+   r,   Útest_to_sql_exist_fail6  s    
rf  c                 C  s\   |  | ¡} td| ƒ}t|ƒ t d| ¡}t|ƒ t d| ¡}|jdksJJ ‚d|jv sXJ ‚d S )NúSELECT * FROM irisúSELECT * FROM iris where 0=1©r   r¦   r6   )r5  r#   r²   rL  Úread_sqlr±   r°   ©rX   r7  Ú
iris_framer+   r+   r,   Útest_read_iris_queryB  s    

rm  c                 C  s”   d| v r |j  tjjddd�¡ | | ¡} ttd| dd�ƒ}t|ƒ tt	j
d| dd�ƒ}t|ƒ tt	j
d| dd�ƒ}|jd	ks‚J ‚d
|jv s�J ‚d S )Nrz   ú,'chunksize' not implemented for ADBC driversTr9  rg  é   ©Ú	chunksizerh  ri  r6   )r<  r=  rñ   r>  r?  r5  r   r#   r²   rL  rj  r±   r°   rk  r+   r+   r,   Útest_read_iris_query_chunksizeN  s    þÿ
rr  c           
      C  s¢   d| v r |j  tjjddd�¡ | | ¡} ddlm}m}m	}m
} |ƒ }t| tƒrZ|| ƒn| }|d||d�}t||ƒ| d	d
dœd�}	t|	ƒ t| tƒrž| ¡  d S )Nrz   rn  Tr9  r   )r1   r3   r´   Úselectr4   )Zautoload_withr£   r¡   ©rœ   Úlength©rn   )r<  r=  rñ   r>  r?  r5  r9   r1   r3   r´   rs  rw   r|   r#   r²   r·   )
rX   r7  r1   r3   r´   rs  r<   Zautoload_conr4   rl  r+   r+   r,   Ú.test_read_iris_query_expression_with_parametera  s$    þÿ
ÿ
rw  c                 C  sv   d| v r |j  tjjddd�¡ |d  ¡ D ]\}}|| v r, qRq,td| › d�ƒ‚| | ¡} t|| dd	�}t	|ƒ d S )
Nrz   rn  Tr9  r(   zNo part of z( found in sql_strings['read_parameters']©r£   r¡   rv  )
r<  r=  rñ   r>  r?  ÚitemsÚKeyErrorr5  r#   r²   )rX   r7  r-   rí   Úqueryrl  r+   r+   r,   Ú*test_read_iris_query_string_with_parameter}  s    þÿ
r|  c                 C  s4   |  | ¡} td| ƒ}t|ƒ t d| ¡}t|ƒ d S )Nr4   )r5  r$   r²   rL  rj  rk  r+   r+   r,   Útest_read_iris_table‘  s
    

r}  c                 C  sb   d| v r|j  tjjdd�¡ | | ¡} ttd| dd�ƒ}t|ƒ tt	j
d| dd�ƒ}t|ƒ d S )Nrz   ú+chunksize argument NotImplemented with ADBC©r:  r4   ro  rp  )r<  r=  rñ   r>  r?  r5  r   r$   r²   rL  rj  rk  r+   r+   r,   Útest_read_iris_table_chunksize›  s    ÿ
r€  c                   sŒ   |  | ¡} g ‰ ‡ fdd„}t| dd��.}|j|d|d� | d¡sFJ ‚W d   ƒ n1 sZ0    Y  ˆ dgksrJ ‚t| dƒt|ƒksˆJ ‚d S )Nc                   s2   ˆ  d¡ ‡ fdd„|D ƒ}| | j ¡ |¡ d S )NrD   c                   s   g | ]}t tˆ |ƒƒ‘qS r+   ra   rJ   ©rÃ   r+   r,   rM   °  rf   z8test_to_sql_callable.<locals>.sample.<locals>.<listcomp>)rà   rO   ræ   r`   )Zpd_tablerX   rÃ   Ú	data_iterr»   ©Úcheckr�  r,   Úsample®  s    
z$test_to_sql_callable.<locals>.sampleTrW  rX  rY  rD   r`  )rX   rÓ   r7  r…  r\  r+   rƒ  r,   Útest_to_sql_callable¨  s    
,r†  c                 C  sæ   | }|dkr |  tjjdd�¡ | | ¡} t d| ¡}t|jj	j
tjƒsLJ ‚t|jj	j
tjƒsbJ ‚d|v r‚t|jj	j
tjƒs˜J ‚nt|jj	j
tjƒs˜J ‚t|jj	j
tjƒs®J ‚d|v rÌt|jj	j
tƒsâJ ‚nt|jj	j
tjƒsâJ ‚d S )Nr1  ú;sqlite_buildin connection does not implement read_sql_tabler  r‚   r'   )Úapplymarkerrñ   r>  r?  r5  r   r$   r«   r‡   r;   rª   r¬   r­   rˆ   Úintegerr‰   Úbool_rŠ   r‹   Úobject©rX   r7  Ú	conn_namerÅ   r+   r+   r,   Útest_default_type_conversionº  s$    ÿÿ
rŽ  c           	   	   C  s   |  | ¡} ddlm} ddlm} tg d¢g d¢dœƒ}|jd| dd	� d
}||ƒ}t| |ƒrº|  ¡ �B}| 	¡ � | 
|¡ W d   ƒ n1 s�0    Y  W d   ƒ qì1 s®0    Y  n2|  	¡ � |  
|¡ W d   ƒ n1 sâ0    Y  t d| ¡}t ||¡ t d| ¡}t ||¡ d S )Nr   ru   r�   ©rD   rE   rF   ©çš™™™™™¹?r¢   ç333333Ó?©rE  ÚbrX  F©rœ   ro   r¤   z}DROP PROCEDURE IF EXISTS get_testdb;

    CREATE PROCEDURE get_testdb ()

    BEGIN
        SELECT * FROM test_frame;
    ENDzCALL get_testdb();)r5  r9   rv   r’   r‘   r   r6  rw   r“   rk   rO   r   r#   r®   Úassert_frame_equalrj  )	rX   r7  rv   r‘   rÅ   ÚprocZengine_connÚres1Úres2r+   r+   r,   Útest_read_procedureÚ  s"    



H
(rš  Úexpected_countrE   zSuccess!c                   s‚   ‡ fdd„}|  | ¡} tddgddgddgd	œƒ}|jd
| d|d�}ˆ d u rZ|d u sfJ ‚n|ˆ ksfJ ‚t d
| ¡}t ||¡ d S )Nc                   sª   |j }| ¡ �ˆ}tƒ }t |¡}| |¡ | d¡ d dd„ |D ƒ¡}| jrb| j› d| j	› �}	n| j	}	d|	› d|› d�}
|j
|
|d	� W d   ƒ n1 sœ0    Y  ˆ S )
Nr   z, c                 S  s   g | ]}d |› d �‘qS )rê   r+   )rK   Úkr+   r+   r,   rM     rf   zVtest_copy_from_callable_insertion_method.<locals>.psql_insert_copy.<locals>.<listcomp>Ú.zCOPY z (z) FROM STDIN WITH CSV)r   Úfile)Ú
connectionrN   r   rQ   ÚwriterÚ	writerowsÚseekÚjoinrå   rœ   Zcopy_expert)ræ   rX   rÃ   r‚  Z
dbapi_connrZ   Zs_bufr   r°   r³   Ú	sql_query©r›  r+   r,   Úpsql_insert_copy  s    



,zBtest_copy_from_callable_insertion_method.<locals>.psql_insert_copyrD   rE   r‘  r¢   rE  Ún©Úcol1Úcol2Zcol3rX  F)rœ   ro   r¤   rU  ©r5  r   r6  r   r$   r®   r–  )rX   r›  r7  r¦  ÚexpectedÚresult_countÚresultr+   r¥  r,   Ú(test_copy_from_callable_insertion_methodÿ  s    
ÿr¯  c              	     s�  |  | ¡} ddlm‰  ddlm} ddlm} ‡ fdd„}|dƒ}t| |ƒr¨|  ¡ �B}| 	¡ � | 
|¡ W d   ƒ n1 s~0    Y  W d   ƒ qÚ1 sœ0    Y  n2|  	¡ � |  
|¡ W d   ƒ n1 sÐ0    Y  tg d¢gtd	ƒd
�}|jd| ddd� tg d¢gtd	ƒd
�}|jd| dd|d�}	t d| ¡}
t |
|¡ |	dk�sRJ ‚tj| dd��}| d¡ W d   ƒ n1 �s‚0    Y  d S )Nr   r_   r�   ru   c                   s<   ‡ fdd„|D ƒ}ˆ| j ƒ |¡jdgd�}| |¡}|jS )Nc                   s   g | ]}t tˆ |ƒƒ‘qS r+   ra   rJ   r�  r+   r,   rM   0  rf   z\test_insertion_method_on_conflict_do_nothing.<locals>.insert_on_conflict.<locals>.<listcomp>rE  )Zindex_elements)ræ   rj   Zon_conflict_do_nothingrO   Úrowcount©ræ   rX   rÃ   r‚  r»   rY   r®  r_   r�  r,   Úinsert_on_conflict/  s    
ÿþÿ
zHtest_insertion_method_on_conflict_do_nothing.<locals>.insert_on_conflictzx
    CREATE TABLE test_insert_conflict (
        a  integer PRIMARY KEY,
        b  numeric,
        c  text
    );
    ©rD   çÍÌÌÌÌÌ @rE  ÚabcrÐ   Útest_insert_conflictrà   Fr3  ©rD   gš™™™™™	@r”  ©rœ   ro   r¤   r4  rU  TrW  )r5  Zsqlalchemy.dialects.postgresqlr`   r’   r‘   Úsqlalchemy.sqlrv   rw   r“   rk   rO   r   Úlistr6  r   r$   r®   r–  r   rì   )rX   r7  r‘   rv   r²  Ú
create_sqlro   r¬  Z	df_insertÚinsertedr®  r\  r+   r_   r,   Ú,test_insertion_method_on_conflict_do_nothing&  s>    

ÿ	


H
(ÿûr½  c                 C  s~   d| v sd| v r$|  tjjdd�¡ | | ¡} tg d¢g d¢gtdƒd�}|jd	| d
ddd� tj	d	| dd�}t
 ||¡ d S )Nr%   r&   z2test for public schema only specific to postgresqlr  r³  )rE   gÍÌÌÌÌÌ@r”  rµ  rÐ   Ztest_public_schemarà   FÚpublic)rœ   ro   r4  r¤   rå   ©rå   )rˆ  rñ   r>  r?  r5  r   rº  r6  r   r$   r®   r–  )rX   r7  Ú	test_dataZdf_outr+   r+   r,   Útest_to_sql_on_public_schema`  s"    ÿÿ
ûrÁ  c              	     s�  |  | ¡} ddlm‰  ddlm} ddlm} ‡ fdd„}|dƒ}t| |ƒr¨|  ¡ �B}| 	¡ � | 
|¡ W d   ƒ n1 s~0    Y  W d   ƒ qÚ1 sœ0    Y  n2|  	¡ � |  
|¡ W d   ƒ n1 sÐ0    Y  tg d¢gtd	ƒd
�}|jd| ddd� tg d¢gtd	ƒd
�}|jd| dd|d�}	t d| ¡}
t |
|¡ |	dk�sRJ ‚tj| dd��}| d¡ W d   ƒ n1 �s‚0    Y  d S )Nr   r_   r�   ru   c                   sH   ‡ fdd„|D ƒ}ˆ| j ƒ |¡}|j|jj|jjd�}| |¡}|jS )Nc                   s   g | ]}t tˆ |ƒƒ‘qS r+   ra   rJ   r�  r+   r,   rM   ‚  rf   zXtest_insertion_method_on_conflict_update.<locals>.insert_on_conflict.<locals>.<listcomp>)r”  rá   )ræ   rj   Zon_duplicate_key_updater¼  r”  rá   rO   r°  r±  r_   r�  r,   r²  �  s
    
zDtest_insertion_method_on_conflict_update.<locals>.insert_on_conflictzv
    CREATE TABLE test_insert_conflict (
        a INT PRIMARY KEY,
        b FLOAT,
        c VARCHAR(10)
    );
    r³  rµ  rÐ   r¶  rà   Fr3  r·  r¸  rE   TrW  )r5  Zsqlalchemy.dialects.mysqlr`   r’   r‘   r¹  rv   rw   r“   rk   rO   r   rº  r6  r   r$   r®   r–  r   rì   )rX   r7  r‘   rv   r²  r»  ro   rÅ   r¬  r¼  r®  r\  r+   r_   r,   Ú(test_insertion_method_on_conflict_updatex  s:    
ÿ	


H
(ûrÂ  c           
   
   C  s&  |  | ¡} ddlm} ddlm} dt ¡ j› �}dt ¡ j› �}|d|› d|› d|› d	|› d
�	ƒ}t| |ƒrÊ|  	¡ �B}| 
¡ � | |¡ W d   ƒ n1 s 0    Y  W d   ƒ qü1 s¾0    Y  n2|  
¡ � |  |¡ W d   ƒ n1 sò0    Y  t|| ƒ}tdgddœƒ}	t ||	¡ d S )Nr   r�   ru   Zgroup_Zgroup_view_z
    CREATE TABLE zF (
        group_id INTEGER,
        name TEXT
    );
    INSERT INTO z- VALUES
        (1, 'name');
    CREATE VIEW z
    AS
    SELECT * FROM z;
    rD   rœ   ©Zgroup_idrœ   )r5  r’   r‘   r¹  rv   ÚuuidÚuuid4Úhexrw   r“   rk   rO   r$   r   r®   r–  )
rX   r7  r‘   rv   r³   rç   Zsql_stmtro   r®  r¬  r+   r+   r,   Útest_read_view_postgres­  s2    
ÿÿùÿÿ


H
(
rÇ  c                 C  sV   d}d}d}|   |¡ |   |¡ |   |¡ t d| ¡}tdgddœƒ}t ||¡ d S )Nz<
CREATE TABLE groups (
   group_id INTEGER,
   name TEXT
);
z,
INSERT INTO groups VALUES
    (1, 'name');
z1
CREATE VIEW group_view
AS
SELECT * FROM groups;
zSELECT * FROM group_viewrD   rœ   rÃ  )rO   rL  rj  r   r®   r–  )r/  Úcreate_tableZinsert_intoZcreate_viewr®  r¬  r+   r+   r,   Útest_read_view_sqliteÑ  s    


rÉ  c              	   C  sl   t jtdd��J tjtdd�� t d| ¡ W d   ƒ n1 s@0    Y  W d   ƒ n1 s^0    Y  d S )Nz+pandas.io.sql.execute requires a connectionrc  úP`pandas.io.sql.execute` is deprecated and will be removed in the future version.úselect * from iris)rñ   rd  Ú	TypeErrorr®   rP  ÚFutureWarningr   rO   )r"  r+   r+   r,   Útest_execute_typeerrorê  s    þrÎ  c                 C  s>   t jtdd�� t d| ¡ W d   ƒ n1 s00    Y  d S )NrÊ  rc  rË  )r®   rP  rÍ  r   rO   )r#  r+   r+   r,   Útest_execute_deprecatedô  s
    þrÏ  c                 C  s6   d| v rdS d| v rdS d| v r$dS t d| › �ƒ‚d S )Nr'   r%   r&   zunsupported connection: )re  )r�  r+   r+   r,   Úflavorþ  s    rÐ  c              	   C  s¬   d| v r |j  tjjddd�¡ | }| | ¡} |d t|ƒ }d}t| ƒ�F}| ¡ � |j	||d�}W d   ƒ n1 sx0    Y  W d   ƒ n1 s–0    Y  t
|ƒ d S )Nrz   ú)'params' not implemented for ADBC driversTr9  r(   rx  rv  ©r<  r=  rñ   r>  r?  r5  rÐ  r"   Úrun_transactionÚ
read_queryr²   ©rX   r7  r-   r�  r{  rn   r\  rl  r+   r+   r,   Útest_read_sql_iris_parameter	  s    þÿ


JrÖ  c              	   C  s²   d| v r |j  tjjddd�¡ | }| | ¡} |d t|ƒ }dddœ}t| ƒ�F}| ¡ � |j	||d	�}W d   ƒ n1 s~0    Y  W d   ƒ n1 sœ0    Y  t
|ƒ d S )
Nrz   rÑ  Tr9  r)   r£   r¡   rt  rv  rÒ  rÕ  r+   r+   r,   Ú"test_read_sql_iris_named_parameter  s    þÿ



Jr×  c              	   C  s´   d| v sd| v r,d| vr,|  tjjdd�¡ | }| | ¡} |d t|ƒ }t| ƒ�F}| ¡ � |j|d d�}W d   ƒ n1 s€0    Y  W d   ƒ n1 sž0    Y  t	|ƒ d S )Nr&   r'   rz   zbroken testr  r*   rv  )
rˆ  rñ   r>  r?  r5  rÐ  r"   rÓ  rÔ  r²   )rX   r7  r-   r�  r{  r\  rl  r+   r+   r,   Ú,test_read_sql_iris_no_parameter_with_percent0  s    


JrØ  c                 C  s"   |  | ¡} t d| ¡}t|ƒ d S )NzSELECT * FROM iris_view)r5  r   r#   r²   rk  r+   r+   r,   Útest_api_read_sql_viewC  s    
rÙ  c                 C  s\   d| v r|j  tjjdd�¡ | | ¡} d}tj|| dd�}t || ¡}t 	t
|ƒ|¡ d S )Nrz   r~  r  z1SELECT * FROM iris_view WHERE "SepalLength" < 0.0r¦   rp  )r<  r=  rñ   r>  r?  r5  r   r#   r®   r–  r   )rX   r7  r{  Z
with_batchZwithout_batchr+   r+   r,   Ú*test_api_read_sql_with_chunksize_no_resultJ  s    ÿ
rÚ  c                 C  sp   |  | ¡} t d| ¡rNtj| dd��}| d¡ W d   ƒ n1 sD0    Y  t |d| ¡ t d| ¡slJ ‚d S )NrÓ   TrW  )r5  r   rZ  r   rì   r6  )rX   r7  rÓ   r\  r+   r+   r,   Útest_api_to_sqlW  s    
(rÛ  c                 C  s¸   |  | ¡} t d| ¡rNtj| dd��}| d¡ W d   ƒ n1 sD0    Y  tj|d| dd� t d| ¡spJ ‚d}tjt|d��" tj|d| dd� W d   ƒ n1 sª0    Y  d S )NÚtest_frame2TrW  r^  r_  z"Table 'test_frame2' already existsrc  )	r5  r   rZ  r   rì   r6  rñ   rd  re  )rX   r7  rÓ   r\  rR  r+   r+   r,   Útest_api_to_sql_failb  s    
(rÝ  c                 C  s¤   |  | ¡} t d| ¡rNtj| dd��}| d¡ W d   ƒ n1 sD0    Y  tj|d| dd� tj|d| dd� t d| ¡s‚J ‚t|ƒ}t| dƒ}||ks J ‚d S )NrÔ   TrW  r^  r_  rK  ©r5  r   rZ  r   rì   r6  r[  r¹   ©rX   r7  rÓ   r\  Znum_entriesZnum_rowsr+   r+   r,   Útest_api_to_sql_replaceq  s    
(
rà  c                 C  s¸   |  | ¡} t d| ¡rNtj| dd��}| d¡ W d   ƒ n1 sD0    Y  tj|d| dd�dkshJ ‚tj|d| dd�dks‚J ‚t d| ¡s’J ‚dt|ƒ }t| dƒ}||ks´J ‚d S )	NÚtest_frame4TrW  r^  r_  rG   rà   rE   rÞ  rß  r+   r+   r,   Útest_api_to_sql_appendƒ  s    
(
râ  c                 C  s|   |  | ¡} t d| ¡rNtj| dd��}| d¡ W d   ƒ n1 sD0    Y  tj|d| dd� t d| ¡}t ||¡ d S )NZtest_frame5TrW  F©r¤   zSELECT * FROM test_frame5)	r5  r   rZ  r   rì   r6  rj  r®   r–  )rX   r7  rÔ   r\  r®  r+   r+   r,   Útest_api_to_sql_type_mapping–  s    
(rä  c                 C  s–   |  | ¡} t d| ¡rNtj| dd��}| d¡ W d   ƒ n1 sD0    Y  ttjddd�dd�}tj|d| d	d
� t 	d| ¡}t
 | ¡ |¡ d S )NZtest_seriesTrW  r¦   rÂ   rB  Zseriesr›   Frã  zSELECT * FROM test_series)r5  r   rZ  r   rì   r   r¬   Úaranger6  r#   r®   r–  Úto_frame)rX   r7  r\  ÚsÚs2r+   r+   r,   Útest_api_to_sql_series£  s    
(ré  c                 C  sÂ   | }|  | ¡} t d| ¡rRtj| dd��}| d¡ W d   ƒ n1 sH0    Y  tj|d| d� tjd| d�}d|v rˆ|jddid	�}|j|_|j	ddd
� |j 
t¡ d |j_t ||¡ d S )NÚtest_frame_roundtripTrW  ©ro   ú"SELECT * FROM test_frame_roundtriprz   Ú__index_level_0__Úlevel_0rÐ   ©Zinplace)r5  r   rZ  r   rì   r6  r#   Úrenamer¤   Ú	set_indexrÄ   r*  rœ   r®   r–  ©rX   r7  rÓ   r�  r\  r®  r+   r+   r,   Útest_api_roundtrip°  s    
(ró  c                 C  sž   d| v r|j  tjjdd�¡ | | ¡} t d| ¡rltj| dd��}| 	d¡ W d   ƒ n1 sb0    Y  tj
|d| ddd	� tjd
| d�}t ||¡ d S )Nrz   r~  r  rê  TrW  FrE   )ro   r¤   rq  rì  rë  )r<  r=  rñ   r>  r?  r5  r   rZ  r   rì   r6  r#   r®   r–  )rX   r7  rÓ   r\  r®  r+   r+   r,   Útest_api_roundtrip_chunksizeÅ  s"    ÿ
(ûrô  c                 C  sf   |  | ¡} t | ¡�*}| d¡}| ¡ }| ¡  W d   ƒ n1 sD0    Y  t|ƒg d¢ksbJ ‚d S ©Nrg  r    )r5  r   r"   rO   rµ   rU   rº  )rX   r7  Ú
pandas_sqlÚiris_resultsrL   r+   r+   r,   Útest_api_execute_sqlÛ  s    

&rø  c              	   C  s  | }|  | ¡} t d| ¡}d|v s@d|v s@t|jjjtjƒr@J ‚tjd| dgd�}t|jjjtjƒshJ ‚|j 	¡ t
dddd	d	d	ƒt
ddd
d	d	d	ƒgksšJ ‚tjd| ddid�}t|jjjtjƒsÄJ ‚|j 	¡ t
dddd	d	d	ƒt
ddd
d	d	d	ƒgksöJ ‚tjd| dgd�}t|jjjtjƒ�s J ‚|j 	¡ t
dddd	d	d	ƒt
dddd	d	d	ƒgk�sTJ ‚tjd| ddid�}t|jjjtjƒ�s€J ‚|j 	¡ t
dddd	d	d	ƒt
dddd	d	d	ƒgk�s´J ‚tjd| ddid�}t|jjjtjƒ�sàJ ‚|j 	¡ t
dƒt
dƒgk�s J ‚d S )NúSELECT * FROM typesr&   r  r„   ©Úparse_datesiÐ  rD   rF   r   rG   ú%Y-%m-%d %H:%M:%Sr…   iÂ  é   é   iÝ  rç  r†   z%Y%m%dz
2010-10-10z
2010-12-12)r5  r   r#   r«   r„   r;   rª   r¬   Ú
datetime64Útolistr   r…   r†   rŒ  r+   r+   r,   Útest_api_date_parsingæ  sZ    
þ
ýþ
þ
ÿþýþr  Úerror)rr   ÚraiseÚcoercezread_sql, text, moderù  )r9   Úfallbackr‚   r9   c           
      C  sÂ   | }|  | ¡} |dkr2|dkr2| tjjdd�¡ | ddi¡}||| dd|iid�}	d	|v r‚|	d
  t¡|	d
< |	d  t¡|	d< |dkr²| ddddœ¡}ts²|d  d¡|d< t	 
|	|¡ d S )Nr‚   r1  z failing combination of argumentsr  r„   údatetime64[ns]rt   )ro   rû  r  r‰   r‹   r  Úint32)r…   r†   rˆ   zdatetime64[us])r5  rˆ  rñ   r>  r?  rÄ   r*  rI   r   r®   r–  )
rX   r7  rj  rv   ra  r  rÆ   r�  r¬  r®  r+   r+   r,   Ú!test_api_custom_dateparsing_error  s4    
ÿÿýýÿr  c                 C  sP   |  | ¡} tjd| dddgd�}t|jjjtjƒs6J ‚t|j	jjtjƒsLJ ‚d S )Nrù  r„   r…   )Ú	index_colrû  )
r5  r   r#   r«   r¤   r;   rª   r¬   rÿ  r…   ©rX   r7  rÅ   r+   r+   r,   Útest_api_date_and_indexU  s    
ür  c           	      C  sR  | }|  | ¡} t d| ¡rRtj| dd��}| d¡ W d   ƒ n1 sH0    Y  ttddgdd�ƒ ¡ }|dkrˆ|j 	t
jjd	d
�¡ d|v r tršt}q¤d }nt}tj|dd�� |jd| d�}W d   ƒ n1 sÖ0    Y  |dksìJ ‚t d| ¡}|dk�r0ttjddddd�tjddddd�gdd�}n|d  d¡}t |d |¡ d S )NZtest_timedeltaTrW  z00:00:01z00:00:03Úfoor›   r(  z.sqlite ADBC driver doesn't implement timedeltar  rz   F)rI  ©rœ   ro   rE   zSELECT * FROM test_timedeltar  r   i@B )ÚmonthsÚdaysÚmicrosecondsÚnanosecondsiÀÆ- rÂ   )r5  r   rZ  r   rì   r   r   ræ  r<  r=  rñ   r>  r?  r   rN  rO  r®   rP  r6  r#   rL  Z
DateOffsetrÄ   r¯   )	rX   r7  r�  r\  rÅ   rQ  r­  r®  r¬  r+   r+   r,   Útest_api_timedeltad  s<    
(ÿÿ,
þûr  c                 C  sx   | }|  | ¡} tdddgiƒ}d|v r,d}nd}tjt|d��& |jd| d	�d u sVJ ‚W d   ƒ n1 sj0    Y  d S )
NrE  y      ð?      ð?y               @rz   zdatatypes not supportedzComplex datatypes not supportedrc  Ztest_complexrë  )r5  r   rñ   rd  re  r6  )rX   r7  r�  rÅ   rR  r+   r+   r,   Útest_api_complex_raises“  s    
r  zindex_name,index_label,expected))NNr¤   )NÚother_labelr  )Ú
index_nameNr  )r  r  r  )r   NÚ0)Nr   r  c           	      C  s¼   d| v r|j  tjjdd�¡ | | ¡} t d| ¡rltj| dd��}| 	d¡ W d   ƒ n1 sb0    Y  t
dtdƒiƒ}||j_d	}tj|d| |d
� t || ¡}|jd |ks¸J ‚d S )Nrz   ú-index_label argument NotImplemented with ADBCr  Útest_index_labelTrW  r©  rG   úSELECT * FROM test_index_label)Úindex_labelr   )r<  r=  rñ   r>  r?  r5  r   rZ  r   rì   r   Úranger¤   rœ   r6  r#   r°   )	rX   r7  r  r  r¬  r\  Ú
temp_framer{  rŸ   r+   r+   r,   Útest_api_to_sql_index_label¡  s    ÿ
(r  c           	      C  sD  | }d|v r$|  tjjddd�¡ nd|v rB|j tjjdd�¡ | | ¡} t d| ¡r�tj	| d	d
��}| 
d¡ W d   ƒ n1 s†0    Y  d}tdtdƒit ddg¡d�}t |d| ¡}||ksÌJ ‚t d| ¡}|jd dksêJ ‚|jd dksüJ ‚tj|d| dddgd�}||k�s"J ‚t d| ¡}|jd d…  ¡ ddgk�sNJ ‚ddg|j_tj|d| dd�}||k�szJ ‚t d| ¡}|jd d…  ¡ ddgk�s¦J ‚tj|d| dddgd�}||k�sÌJ ‚t d| ¡}|jd d…  ¡ ddgk�søJ ‚d}tjt|d��$ tj|d| ddd� W d   ƒ n1 �s60    Y  d S )Nr&   z/MySQL can fail using TEXT without length as keyFr9  rz   r  r  r  TrW  rG   r©  )ZA0ÚA1)ÚB0ZB1rã  r  r   rî  rD   Zlevel_1rK  rÇ   rÈ   )r4  r  rE   r_  rÉ   rÊ   zALength of 'index_label' should match number of levels, which is 2rc  )rˆ  rñ   r>  r?  r<  r=  r5  r   rZ  r   rì   r   r  r   Zfrom_productr6  r#   r°   r   r¤   Únamesrd  re  )	rX   r7  r�  r\  Zexpected_row_countr  r®  rŸ   rR  r+   r+   r,   Ú&test_api_to_sql_index_label_multiindexÅ  sv    ÿÿÿ
(
þû  û ûr!  c                 C  s    |  | ¡} t d| ¡rNtj| dd��}| d¡ W d   ƒ n1 sD0    Y  tjddgg d¢ddgd	�}|jd| d
� tjd| ddgd�}t	j
||dd� d S )NZtest_multiindex_roundtripTrW  ©rD   r´  Úline1©rE   ç      ø?Úline2©rÇ   rÈ   rÉ   rÇ   rÈ   ©r°   r¤   r  z'SELECT * FROM test_multiindex_roundtrip©r	  ©Zcheck_index_type)r5  r   rZ  r   rì   r   Úfrom_recordsr6  r#   r®   r–  )rX   r7  r\  rÅ   r®  r+   r+   r,   Útest_api_multiindex_roundtrip  s    
(ý
ÿr,  r;   ©rÇ   rÈ   c           	      C  sÀ   | }|  | ¡} t d| ¡rRtj| dd��}| d¡ W d   ƒ n1 sH0    Y  tddgddggdd	gd
�}|jd| d�dks„J ‚| |¡}d|v rœd}nd}tj|| |d�}t	 
||¡ d S )NZtest_dtype_argumentTrW  ç333333ó?g333333@çffffff@g333333@rÇ   rÈ   rÐ   r  rE   r  z(SELECT "A", "B" FROM test_dtype_argumentz$SELECT A, B FROM test_dtype_argument©ro   r;   )r5  r   rZ  r   rì   r   r6  rÄ   r#   r®   r–  )	rX   r7  r;   r�  r\  rÅ   r¬  r{  r®  r+   r+   r,   Útest_api_dtype_argument#  s    
(
r1  c                 C  s<   |  | ¡} tddgddggddgd�}tj|d| dd	� d S )
NrD   rE   rF   rG   r   rÐ   Ztest_frame_integer_col_namesrK  r_  )r5  r   r   r6  r
  r+   r+   r,   Útest_api_integer_col_namesC  s    
r2  c                 C  sJ   d| v r |j  tjjddd�¡ | | ¡} tj|d| d�}d|v sFJ ‚d S )Nrz   ú-'get_schema' not implemented for ADBC driversTr9  r2  rë  ÚCREATE©r<  r=  rñ   r>  r?  r5  r   Ú
get_schema©rX   r7  rÓ   r»  r+   r+   r,   Útest_api_get_schemaJ  s    þÿ
r8  c                 C  sL   d| v r |j  tjjddd�¡ | | ¡} tj|d| dd�}d|v sHJ ‚d S )	Nrz   r3  Tr9  r2  Úpypi)ro   rå   zCREATE TABLE pypi.r5  r7  r+   r+   r,   Útest_api_get_schema_with_schemaX  s    þÿ
r:  c                 C  s”   d| v r |j  tjjddd�¡ | }| | ¡} tddgddgd	œƒ}|d
krRd}nddlm} |}t	j
|d| d|id�}d|v s„J ‚d|v s�J ‚d S )Nrz   r3  Tr9  çš™™™™™ñ?r.  r´  çš™™™™™@r“  r/  ÚINTEGERr   )r�   r2  r”  r0  r4  )r<  r=  rñ   r>  r?  r5  r   r9   r�   r   r6  )rX   r7  r�  Zfloat_framer;   r�   r»  r+   r+   r,   Útest_api_get_schema_dtypesg  s"    þÿ
r>  c                 C  s¬   d| v r |j  tjjddd�¡ | }| | ¡} tddgddgd	œƒ}tj|d
| dd�}d|v rdd}nd}||v stJ ‚tj|d
| ddgd�}d|v r˜d}nd}||v s¨J ‚d S )Nrz   r3  Tr9  r;  r.  r´  r<  )ÚCol1ZCol2r2  r?  )ro   rÃ   r&   z'CONSTRAINT test_pk PRIMARY KEY (`Col1`)z'CONSTRAINT test_pk PRIMARY KEY ("Col1")rÇ   rÈ   z)CONSTRAINT test_pk PRIMARY KEY (`A`, `B`)z)CONSTRAINT test_pk PRIMARY KEY ("A", "B"))	r<  r=  rñ   r>  r?  r5  r   r   r6  )rX   r7  rÓ   r�  rŸ   r»  Zconstraint_sentencer+   r+   r,   Útest_api_get_schema_keys  s(    þÿ
r@  c                 C  s¾  d| v r|j  tjjdd�¡ | }| | ¡} t d| ¡rptj| dd��}| 	d¡ W d   ƒ n1 sf0    Y  t
tj d¡ d¡td	ƒd
�}|jd| dd� t d| ¡}t
ƒ }d}g d¢}tjd| dd�D ]0}	t||	gdd�}t|	ƒ|| ksôJ ‚|d7 }qÌt ||¡ |dk�rVtjtdd��  tjd| dd� W d   ƒ n1 �sJ0    Y  ndt
ƒ }
d}g d¢}tjd| dd�D ]4}	t|
|	gdd�}
t|	ƒ|| k�s¢J ‚|d7 }�qxt ||
¡ d S )Nrz   r~  r  Ztest_chunksizeTrW  rE   )é   r¦   ZabcderÐ   Fr•  zselect * from test_chunksizer   )r¦   r¦   r¦   r¦   rE   r¦   rp  ©Zignore_indexrD   r/  rG  rc  )r<  r=  rñ   r>  r?  r5  r   rZ  r   rì   r   r¬   ÚrandomÚdefault_rngÚstandard_normalrº  r6  r#   r   r[  r®   r–  rd  ÚNotImplementedErrorr$   )rX   r7  r�  r\  rÅ   r˜  r™  ÚiÚsizesÚchunkÚres3r+   r+   r,   Útest_api_chunksize_readœ  sB    ÿ
(ÿ

2rK  c                 C  sð   | dkrFt ddd�}|d urFt|jƒtdƒk rF|j tjjddd�¡ | | ¡} t	 
d	| ¡r”t	j| dd
��}| d	¡ W d   ƒ n1 sŠ0    Y  tg d¢g d¢dœƒ}| ¡ }|d  d¡|d< |jd	| dd� t	 d| ¡}t ||¡ d S )Nr  r  rr   rs   z0.9.0z:categorical dtype not implemented for ADBC postgres driverTr9  Ztest_categoricalrW  r�  )úJohn P. Doez	Jane DoverL  )Z	person_idÚperson_namerM  ÚcategoryFr•  zSELECT * FROM test_categorical)r   r   r:   r<  r=  rñ   r>  r?  r5  r   rZ  r   rì   r   ÚcopyrÄ   r6  r#   r®   r–  )rX   r7  rz   r\  rÅ   Údf2Úresr+   r+   r,   Útest_api_categoricalÍ  s.    þÿ
(þÿrR  c                 C  s~   |  | ¡} t d| ¡rNtj| dd��}| d¡ W d   ƒ n1 sD0    Y  tddgddggdd	gd
�}|jd| dd� d S )NZtest_unicodeTrW  rD   rE   rF   rG   õ   Ã©r”  rÐ   Fr•  )r5  r   rZ  r   rì   r   r6  )rX   r7  r\  rÅ   r+   r+   r,   Útest_api_unicode_column_nameî  s    
(rT  c                 C  sª   | }|  | ¡} t d| ¡rRtj| dd��}| d¡ W d   ƒ n1 sH0    Y  tg d¢dtjdgdœƒ}|jd| dd	� d
|v rŠd}nd}t 	|| ¡}t
 ||¡ d S )Nzd1187b08-4943-4c8d-a7f6TrW  ©r   rD   rE   r¢   r/  r-  Fr•  r  z'SELECT * FROM "d1187b08-4943-4c8d-a7f6"z'SELECT * FROM `d1187b08-4943-4c8d-a7f6`)r5  r   rZ  r   rì   r   r¬   Únanr6  r#   r®   r–  )rX   r7  r�  r\  rÅ   r{  rQ  r+   r+   r,   Útest_api_escaped_table_nameú  s    
(rW  c                 C  sø   d| v rDt  d¡}t|jƒtdƒkr,| dv sD|j t jjddd�¡ | | ¡} t	 
d| ¡r’t	j| dd	��}| d¡ W d   ƒ n1 sˆ0    Y  tg d
¢g d¢ddœƒ}|jd| dd� t d| ¡}tg d¢g d¢g d¢gg d¢d�}t ||¡ d S )Nrz   rA  z16.0)r(  r  z!pyarrow->pandas throws ValueErrorTr9  Ú
test_tablerW  r�  r�  rD   ©rE  r”  rá   Fr•  z)SELECT a, b, a +1 as a, c FROM test_table)rD   r‘  rE   rD   )rE   r¢   rF   rD   )rF   r’  rG   rD   )rE  r”  rE  rá   rÐ   )rñ   rò   r   r:   r<  r=  r>  r?  r5  r   rZ  r   rì   r   r6  rL  rj  r®   r–  )rX   r7  Úpar\  rÅ   r®  r¬  r+   r+   r,   Ú#test_api_read_sql_duplicate_columns	  s.    
ÿþÿÿ
(þr[  c                 C  sf   | }|dkr |  tjjdd�¡ | | ¡} t |d| ¡ ddg}tjd| |d�}|j 	¡ |ksbJ ‚d S )Nr/  úNot Implementedr  rX  rÇ   rÈ   rÐ   )
rˆ  rñ   r>  r?  r5  r   r6  r$   r°   r   )rX   r7  rÓ   r�  Úcolsr®  r+   r+   r,   Útest_read_table_columns-	  s    
r^  c                 C  sÊ   | }|dkr |  tjjdd�¡ | | ¡} t |d| ¡ tjd| dd�}|jj	dgksZJ ‚tjd| ddgd�}|jj	ddgks‚J ‚tjd| ddgd	d
gd�}|jj	ddgks°J ‚|j
 ¡ d	d
gksÆJ ‚d S )Nr/  r\  r  rX  r¤   r)  rÇ   rÈ   rÉ   rÊ   )r	  r°   )rˆ  rñ   r>  r?  r5  r   r6  r$   r¤   r   r°   r   )rX   r7  rÓ   r�  r®  r+   r+   r,   Útest_read_table_index_col=	  s    
ÿr_  c                 C  sr   | dkr|  tjjdd�¡ | | ¡} t d| ¡}t d| ¡}t 	||¡ t 
d| ¡}t d| ¡}t 	||¡ d S )Nr0  r‡  r  rg  r4   )rˆ  rñ   r>  r?  r5  r   r#   rj  r®   r–  r$   )rX   r7  Úiris_frame1Úiris_frame2r+   r+   r,   Útest_read_sql_delegateT	  s    ÿÿ
rb  c              
   C  s  | }ddl m} ddlm} |dƒ|dƒg}|D ]œ}t||ƒrš| ¡ �B}| ¡ � | |¡ W d   ƒ n1 sp0    Y  W d   ƒ qÌ1 sŽ0    Y  q0| ¡ � | |¡ W d   ƒ q01 sÂ0    Y  q0t 	d ¡�( t
 d|¡ t
 d|¡ W d   ƒ n1 �s0    Y  d S )Nr   ru   r�   z,CREATE TABLE invalid (x INTEGER, y UNKNOWN);z0CREATE TABLE other_table (x INTEGER, y INTEGER);Zother_tablezSELECT * FROM other_table)r9   rv   r’   r‘   rw   r“   rk   rO   r®   rP  r   r$   r#   )r   rX   rv   r‘   Z
query_listr{  r+   r+   r,   Útest_not_reflect_all_tablesg	  s     þ


H
*rc  c              	   C  sÒ   | }|dksd|v r(|  tjjdd�¡ | | ¡} tjtdd��F t 	| ¡�}| 
dd¡ W d   ƒ n1 sn0    Y  W d   ƒ n1 sŒ0    Y  t d ¡� |jd	| d
� W d   ƒ n1 sÄ0    Y  d S )Nr/  rz   zDoes not raise warningr  z¶The provided table name 'TABLE1' is not found exactly as such in the database after writing the table, possibly due to case sensitivity issues. Consider using lower case table names.rc  ZTABLE1rG  ZCaseSensitiver  )rˆ  rñ   r>  r?  r5  r®   rP  rO  r   r   Zcheck_case_sensitiver6  )rX   r7  rÓ   r�  rí   r+   r+   r,   Ú(test_warning_case_insensitive_table_name€	  s    
ýHrd  c                 C  s„   |  | ¡} ddlm} tdtddgdd�iƒ}t | ¡�8}tjd||d	�}t|j	j
d j|ƒsbJ ‚W d   ƒ n1 sv0    Y  d S )
Nr   )Ú	TIMESTAMPr   ú2014-12-12 01:54ú2014-12-11 02:54T©ÚutcÚ	test_typerž   )r5  r9   re  r   r   r   r   ÚSQLTablerw   ræ   rá   rª   )rX   r7  re  rÅ   rí   ræ   r+   r+   r,   Útest_sqlalchemy_type_mapping˜	  s    
ÿrl  zinteger, expected)Zint8ÚSMALLINT)ZInt8rm  )Zuint8rm  )ZUInt8rm  )Zint16rm  )ZInt16rm  )Zuint16r=  )ZUInt16r=  )r  r=  )ZInt32r=  )Zuint32ÚBIGINT)ZUInt32rn  )rÂ   rn  )ÚInt64rn  rÂ   rn  r=  c                 C  sx   |  | ¡} tddgdg|d�}t | ¡�0}tjd||d�}t|jjjj	ƒ}W d   ƒ n1 s^0    Y  ||kstJ ‚d S )Nr   rD   rE  ©r°   r;   rj  rž   )
r5  r   r   r   rk  r|   ræ   rá   rE  rª   )rX   r7  r‰  r¬  rÅ   rí   ræ   r®  r+   r+   r,   Útest_sqlalchemy_integer_mapping§	  s    
.rq  r‰  Zuint64ZUInt64c              	   C  sŠ   |  | ¡} tddgdg|d�}t | ¡�N}tjtdd��  tjd||d� W d   ƒ n1 s^0    Y  W d   ƒ n1 s|0    Y  d S )	Nr   rD   rE  rp  z1Unsigned 64 bit integer datatype is not supportedrc  rj  rž   )r5  r   r   r   rñ   rd  re  rk  )rX   r7  r‰  rÅ   rí   r+   r+   r,   Ú(test_sqlalchemy_integer_overload_mappingÇ	  s    
ÿrr  c           
      C  sª   t  d¡ | | ¡} t ¡ �V}d| }d}|j||ddd� t ||¡}t ||¡}d}t 	||¡}	W d   ƒ n1 sx0    Y  t 
||¡ t 
||¡ t 
||	¡ d S )Nr9   r  r4   rK  Fr3  rg  )rñ   rò   r5  r®   r  r6  r   rj  r$   r#   r–  )
rX   r7  rÓ   rœ   Údb_uriræ   rÜ  rÔ   r{  rá  r+   r+   r,   Útest_database_uri_stringÔ	  s    


*rt  Úpg8000c                 C  sV   t  d¡ | | ¡} d}t jtdd�� t d|¡ W d   ƒ n1 sH0    Y  d S )Nr9   z)postgresql+pg8000://user:pass@host/dbnameru  rc  zselect * from table)rñ   rò   r5  rd  ÚImportErrorr   rj  )rX   r7  rs  r+   r+   r,   Ú(test_pg8000_sqlalchemy_passthrough_erroré	  s
    

rw  c                 C  sf   | }|  | ¡} ddlm} d|v r,|dƒ}n|dƒ}tj|| ddid�}t|d	 ƒ}|dhksbJ ‚d S )
Nr   ru   r  z%select * from iris where "Name"=:namez#select * from iris where name=:namerœ   zIris-versicolorrv  r7   )r5  r9   rv   r   rj  Úset)rX   r7  r�  rv   Z	name_textÚiris_dfÚ	all_namesr+   r+   r,   Útest_query_by_text_objõ	  s    

r{  c                 C  sl   |  | ¡} ddlm}m} tƒ }||ƒ |jj|dƒk¡}tj	|| ddid�}t
|d ƒ}|dhkshJ ‚d S )Nr   )Ú	bindparamrs  rœ   r£   rv  r7   )r5  r9   r|  rs  r=   Úwhererá   r7   r   rj  rx  )rX   r7  r|  rs  r4   Zname_selectry  rz  r+   r+   r,   Útest_query_by_select_obj
  s    
r~  c                 C  sl   | }|dkr |  tjjdd�¡ | | ¡} tg d¢g d¢dœƒ}|jd| dd	� t d| ¡}t	 
||¡ d S )
Nr/  r\  r  rU  ©rF   rG   r¦   )rÇ   z%_variationZtest_column_percentageFr•  )rˆ  rñ   r>  r?  r5  r   r6  r   r$   r®   r–  )rX   r7  r�  rÅ   rQ  r+   r+   r,   Útest_column_with_percentage
  s    
r€  c              	   C  sº   t  ¡ �’}tt |¡ƒ�*}tj| d|dd�dks4J ‚W d   ƒ n1 sH0    Y  tt |¡ƒ�}t d|¡}W d   ƒ n1 s‚0    Y  W d   ƒ n1 s 0    Y  t  | |¡ d S )NZtest_frame3_legacyFrã  rG   z!SELECT * FROM test_frame3_legacy;)	r®   r  r   rx   r“   r   r6  r#   r–  )rÔ   rœ   rX   r®  r+   r+   r,   Útest_sql_open_close%
  s    
8Hr�  c                  C  sF   d} d}t jt|d�� t d| ¡ W d   ƒ n1 s80    Y  d S )Nzmysql://root@localhost/pandasz-Using URI string without sqlalchemy installedrc  rg  )rñ   rd  rv  r   rj  )rX   rR  r+   r+   r,   Útest_con_string_import_error3
  s    r‚  c               	   C  sv   G dd„ dƒ} t  | dƒ¡�F}t t¡� t d|¡ W d   ƒ n1 sJ0    Y  W d   ƒ n1 sh0    Y  d S )Nc                   @  s*   e Zd Zddœdd„Zdd„ Zdd„ Zd	S )
zhtest_con_unknown_dbapi2_class_does_not_error_without_sql_alchemy_installed.<locals>.MockSqliteConnectionÚNone©Úreturnc                 _  s   t j|i |¤Ž| _d S rø   )rx   ry   rX   )ÚselfÚargsÚkwargsr+   r+   r,   Ú__init__>
  s    zqtest_con_unknown_dbapi2_class_does_not_error_without_sql_alchemy_installed.<locals>.MockSqliteConnection.__init__c                 S  s   t | j|ƒS rø   )ÚgetattrrX   )r†  rœ   r+   r+   r,   Ú__getattr__A
  s    zttest_con_unknown_dbapi2_class_does_not_error_without_sql_alchemy_installed.<locals>.MockSqliteConnection.__getattr__c                 S  s   | j  ¡  d S rø   )rX   rU   )r†  r+   r+   r,   rU   D
  s    zntest_con_unknown_dbapi2_class_does_not_error_without_sql_alchemy_installed.<locals>.MockSqliteConnection.closeN)Ú__name__Ú
__module__Ú__qualname__r‰  r‹  rU   r+   r+   r+   r,   ÚMockSqliteConnection=
  s   r�  r,  zSELECT 1)r-  r   r®   rP  rO  r   rj  )r�  rX   r+   r+   r,   ÚJtest_con_unknown_dbapi2_class_does_not_error_without_sql_alchemy_installed;
  s    
r�  c                 C  sl   | }t  d|¡}t  d|¡}t ||¡ d}tjt j|d�� t  d|¡ W d   ƒ n1 s^0    Y  d S )Nrg  z9Execution failed on sql 'iris': near "iris": syntax errorrc  r4   )r   r#   rj  r®   r–  rñ   rd  ÚDatabaseError)r0  rX   r`  ra  rR  r+   r+   r,   Útest_sqlite_read_sql_delegateL
  s    r’  c                 C  s   t  | d¡}d|v sJ ‚d S )Nr2  r4  )r   r6  )rÓ   r»  r+   r+   r,   Útest_get_schema2W
  s    r“  c                 C  s|   | }t dtddgdd�iƒ}t |¡}tjd||d�}| ¡ }| d¡D ].}| ¡ d	  d
¡dkrH| ¡ d dksHJ ‚qHd S )Nr   rf  rg  Trh  rj  rž   Ú
r   rê   rD   re  )r   r   r   r    ZSQLiteTableZ
sql_schemaÚsplitÚstrip)r/  rX   rÅ   rí   ræ   rå   Úcolr+   r+   r,   Útest_sqlite_type_mapping]
  s    ÿ
r˜  c                 C  sÒ   | dkrt  d¡ | | ¡} ddlm} tg d¢g d¢dœƒ}tj| dd	��$}| |d
¡dksbJ ‚W d   ƒ n1 sv0    Y  || ƒ}| 	d
¡s–J ‚tj| dd	��}| 
d
¡ W d   ƒ n1 sÄ0    Y  d S )Nr  ú#sqlite_str has no inspection systemr   rÚ   ©ç      ð?ç       @ç      @ç      @©rž  r�  rœ  r›  ©ÚoneÚtwoTrW  r  rG   )rñ   Úskipr5  r9   rÛ   r   r   r   r6  rZ  rì   ©rX   r7  rÛ   r  r\  Úinspr+   r+   r,   Útest_create_tableo
  s    

2r¦  c              	   C  s   | dkrt  d¡ | | ¡} ddlm} tg d¢g d¢dœƒ}t | ¡�Â}| ¡ �$ | 	|d¡d	kshJ ‚W d   ƒ n1 s|0    Y  || ƒ}| 
d¡sœJ ‚| ¡ � | d¡ W d   ƒ n1 sÄ0    Y  z| ¡  W n tyì   Y n0 | 
d¡rüJ ‚W d   ƒ n1 �s0    Y  d S )
Nr  r™  r   rÚ   rš  rŸ  r   r  rG   )rñ   r£  r5  r9   rÛ   r   r   r   rÓ  r6  rZ  rì   Úclear_cacheÚAttributeErrorr¤  r+   r+   r,   Útest_drop_table„
  s"    


2
(r©  c                 C  s¬   | dkrt  d¡ | }| | ¡} t| ƒ}| ¡ �. | |d¡dksFJ ‚| d¡}W d   ƒ n1 sd0    Y  d|v r†|jddid	�}|jdd
d� d |j	_
t ||¡ d S )Nr  r™  rê  rG   rì  rz   rí  rî  rÐ   Trï  )rñ   r£  r5  r"   rÓ  r6  rÔ  rð  rñ  r¤   rœ   r®   r–  rò  r+   r+   r,   Útest_roundtripž
  s    


(rª  c              	   C  sŒ   |  | ¡} t| ƒ�R}| ¡ �* | d¡}| ¡ }| ¡  W d   ƒ n1 sL0    Y  W d   ƒ n1 sj0    Y  t|ƒg d¢ksˆJ ‚d S rõ  )r5  r"   rÓ  rO   rµ   rU   rº  )rX   r7  r\  r÷  rL   r+   r+   r,   Útest_execute_sql´
  s    



Dr«  c                 C  s$   |  | ¡} tjd| d�}t|ƒ d S )Nr4   rë  )r5  r   r$   r²   rk  r+   r+   r,   Útest_sqlalchemy_read_table¿
  s    
r¬  c                 C  s8   |  | ¡} tjd| ddgd�}t |jtddgƒ¡ d S )Nr4   r5   )ro   r°   ZSepalLength__1)r5  r   r$   r®   Zassert_index_equalr°   r   rk  r+   r+   r,   Ú"test_sqlalchemy_read_table_columnsÆ
  s
    

ÿr­  c                 C  sN   |  | ¡} d}tjt|d�� tjd| d� W d   ƒ n1 s@0    Y  d S )Nz!Table this_doesnt_exist not foundrc  Zthis_doesnt_existrë  )r5  rñ   rd  re  r   r$   )rX   r7  rR  r+   r+   r,   Útest_read_table_absent_raisesÏ
  s    
r®  c                 C  sÂ   | }|dkrt  d¡ n$d|v s(d|v r<| t jjdd�¡ | | ¡} t d| ¡}t|j	j
jtjƒshJ ‚t|jj
jtjƒs~J ‚t|jj
jtjƒs”J ‚t|jj
jtjƒsªJ ‚t|jj
jtƒs¾J ‚d S )Nr  ú.types tables not created in sqlite_str fixturer&   r%   z#boolean dtype not inferred properlyr  r‚   )rñ   r£  rˆ  r>  r?  r5  r   r$   r«   r‡   r;   rª   r¬   r­   rˆ   r‰  r‰   rŠ  rŠ   r‹   r‹  rŒ  r+   r+   r,   Ú'test_sqlalchemy_default_type_conversion×
  s    ÿ
r°  c                 C  sN   |  | ¡} tddgid�}|jd| dd�dks2J ‚t d| ¡}t ||¡ d S )NÚi64l            )r»   Útest_bigintFr•  rD   r«  ©rX   r7  rÅ   r®  r+   r+   r,   r²  î
  s
    
r²  c                 C  sd   | }|dkrt  d¡ nd|v r4| t jjdd�¡ | | ¡} t d| ¡}t|j	j
jtjƒs`J ‚d S )Nr  r¯  r%   z"sqlite does not read date properlyr  r‚   )rñ   r£  rˆ  r>  r?  r5  r   r$   r«   r„   r;   rª   r¬   rÿ  rŒ  r+   r+   r,   Útest_default_date_loadù
  s    ÿ
r´  rû  r–   c                 C  s6   |  | ¡} t| ƒ}td| |d�}|j}t ||¡ d S )Núselect * from datetzrú  )r5  r�   r#   r–   r®   r¯   )rX   r7  rû  r¬  rÅ   r—  r+   r+   r,   Ú!test_datetime_with_timezone_query	  s
    
r¶  c                 C  sB   |  | ¡} t| ƒ}tttd| dd�ƒdd�}|j}t ||¡ d S )Nrµ  rD   rp  TrB  )r5  r�   r   rº  r#   r–   r®   r¯   )rX   r7  r¬  rÅ   r—  r+   r+   r,   Ú+test_datetime_with_timezone_query_chunksize  s    
þr·  c                 C  s2   |  | ¡} t| ƒ}t d| ¡}t || ¡ ¡ d S )Nr•   )r5  r�   r   r$   r®   r–  ræ  )rX   r7  r¬  r®  r+   r+   r,   Ú!test_datetime_with_timezone_table%  s    
r¸  c                 C  sÎ   | }|  | ¡} tdtdddd�iƒ}|jd| dd�dks<J ‚d	|v rZ|d j d
¡|d< n|d j d ¡|d< t d| ¡}t	 
||¡ t d| ¡}d|v r¾t|jd tƒs®J ‚t|d ƒ|d< t	 
||¡ d S )NrÇ   ú2013-01-01 09:00:00rF   ú
US/Pacific©Úperiodsrš   Ztest_datetime_tzFr•  r'   r˜   zSELECT * FROM test_datetime_tzr%   ©r   rÇ   )r5  r   r   r6  ÚdtZ
tz_convertZtz_localizer   r$   r®   r–  r#   rw   Úlocr|   r   )rX   r7  r�  r¬  r®  r+   r+   r,   Ú%test_datetime_with_timezone_roundtrip-  s     
ÿrÀ  c                 C  sj   |  | ¡} tdtdddƒidgd�}|jd| dd�dks<J ‚t d| ¡}ttjgdgd	�}t 	||¡ d S )
Nr   i'  rD   r   rã  Ztest_datetime_obbFr•  rÐ   )
r5  r   r   r6  r   r$   rL  ZNaTr®   r–  )rX   r7  r»   r®  r¬  r+   r+   r,   Útest_out_of_bounds_datetimeL  s    
rÁ  c                 C  sn   |  | ¡} tdddd� d ¡}tdtdƒi|d�}|jd| dd	�dksJJ ‚tjd| dd
�}tj	||dd� d S )Nz
2018-01-01r¦   Z6h©r¼  ÚfreqÚnumsrã  Z	foo_tableZ	info_date)rœ   ro   r  r)  F)Zcheck_names)
r5  r   Z
_with_freqr   r  r6  r   r$   r®   r–  )rX   r7  Údatesr¬  r®  r+   r+   r,   Ú"test_naive_datetimeindex_roundtripW  s    
rÆ  c                 C  sH  | }|  | ¡} t d| ¡}d|v r&tntj}t|jjj	|ƒs@J ‚tjd| dgd�}t|jjj	tjƒshJ ‚tjd| ddid�}t|jjj	tjƒs’J ‚tjd| dddiid�}t|jjj	tjƒsÀJ ‚tjd| dgd�}t|j
jj	tjƒsèJ ‚tjd| ddid�}t|j
jj	tjƒ�sJ ‚tjd| dd	diid�}t|j
jj	tjƒ�sDJ ‚d S )
Nr‚   r%   r„   rú  rü  Úformatr…   rç  Úunit)r5  r   r$   r‹  r¬   rÿ  r«   r„   r;   rª   r…   )rX   r7  r�  rÅ   Úexpected_typer+   r+   r,   Útest_date_parsingd  s*    

ýrÊ  c                 C  sÊ   | }|  | ¡} ttddd�t d¡dœƒ}|jd| d�dks@J ‚t d| ¡}|jdd	d
�}t	 
||¡ t d| ¡}|jdd	d
�}d|v rºt|jd tƒsœJ ‚t|d ƒ|d< t	 
||¡ nt	 
||¡ d S )Nr¹  rF   ©r¼  r�  r-  Útest_datetimer  r¤   rD   )ZaxisúSELECT * FROM test_datetimer%   r½  rÇ   )r5  r   r   r¬   rå  r6  r   r$   rl   r®   r–  r#   rw   r¿  r|   r   ©rX   r7  r�  rÅ   r®  r+   r+   r,   rÌ  „  s     
ÿrÌ  c                 C  sÀ   | }|  | ¡} ttddd�t d¡dœƒ}tj|jd< |jd| dd	�dksNJ ‚t 	d| ¡}t
 ||¡ t d
| ¡}d|v r°t|jd tƒsŽJ ‚t|d dd�|d< t
 ||¡ nt
 ||¡ d S )Nr¹  rF   rË  r�  r-  ©rD   rÇ   rÌ  Fr•  rÍ  r%   r½  rÇ   r  rs   )r5  r   r   r¬   rå  rV  r¿  r6  r   r$   r®   r–  r#   rw   r|   r   rÎ  r+   r+   r,   Útest_datetime_NaT�  s    
ÿrÐ  c                 C  sr   |  | ¡} ttdddƒtdddƒgdgd�}|jd| dd�dksDJ ‚td| ƒ}|d }t|d ƒ}t ||¡ d S )	NéÞ  rD   rE   rE  rÐ   Ú	test_dateFr•  )r5  r   r   r6  r$   r   r®   r¯   )rX   r7  rÅ   rQ  r®  r¬  r+   r+   r,   Útest_datetime_dateµ  s    
"
rÓ  c                 C  s  | }|  | ¡} ttdddƒtdddƒgdgd�}|jd| dd	�d
ksHJ ‚td| ƒ}t ||¡ |}tj|d|dd�d
ks|J ‚t d|¡}| 	dd„ ¡}t ||¡ tj|d| dd�d
ks¼J ‚d|v rêt d| ¡}| 	dd„ ¡}t ||¡ t d| ¡}t ||¡ d S )Né	   r   rD   é   rE  rÐ   Ú	test_timeFr•  rE   Z
test_time2rã  zSELECT * FROM test_time2c                 S  s
   |   d¡S ©Nz%H:%M:%S.%f©Ústrftime©Ú_r+   r+   r,   Ú<lambda>Ñ  rf   z$test_datetime_time.<locals>.<lambda>Z
test_time3r%   zSELECT * FROM test_time3c                 S  s
   |   d¡S r×  rØ  rÚ  r+   r+   r,   rÜ  ×  rf   )
r5  r   r   r6  r$   r®   r–  r   r#   Úmap)rX   r7  r/  r�  rÅ   rQ  r   Úrefr+   r+   r,   Útest_datetime_timeÂ  s$    
"
rß  c                 C  sn   |  | ¡} tdtjd�}tdtjd�}t||dœƒ}|jd| dd�dksLJ ‚t d| ¡}t	j
||dd	d
� d S )Ni  rB  g        )Ús1rè  Ztest_read_writeFr•  rD   T)Zcheck_dtypeZcheck_exact)r5  r   r¬   r  Úfloat32r   r6  r   r$   r®   r–  )rX   r7  rà  rè  rÅ   rP  r+   r+   r,   Útest_mixed_dtype_insertÝ  s    
râ  c                 C  sp   |  | ¡} tg d¢dtjdgdœƒ}|jd| dd�dks<J ‚t d| ¡}t ||¡ t 	d	| ¡}t ||¡ d S )
NrU  r¢   r/  r-  Útest_nanFr•  rF   úSELECT * FROM test_nan)
r5  r   r¬   rV  r6  r   r$   r®   r–  r#   r³  r+   r+   r,   Útest_nan_numericì  s    
rå  c                 C  sŽ   |  | ¡} tg d¢tjtjtjgdœƒ}|jd| dd�dks@J ‚t d| ¡}t ||¡ |d  	d¡|d< d |d< t 
d	| ¡}t ||¡ d S )
NrU  r-  rã  Fr•  rF   rÈ   r‹  rä  )r5  r   r¬   rV  r6  r   r$   r®   r–  rÄ   r#   r³  r+   r+   r,   Útest_nan_fullcolumnü  s    
ræ  c                 C  sz   |  | ¡} tg d¢ddtjgdœƒ}|jd| dd�dks<J ‚d |jd	< t d| ¡}t 	||¡ t 
d
| ¡}t 	||¡ d S )NrU  rE  r”  r-  rã  Fr•  rF   ©rE   rÈ   rä  )r5  r   r¬   rV  r6  r¿  r   r$   r®   r–  r#   r³  r+   r+   r,   Útest_nan_string  s    

rè  c              	   C  sF  d| v r |j  tjjddd�¡ | }| | ¡} tjddgg d¢dgd	�}d
}t| ƒ�L}| 	¡ �$ | 
||¡dkstJ ‚W d   ƒ n1 sˆ0    Y  W d   ƒ n1 s¦0    Y  |dv �rt d|› d�| ¡}g }|jD ](}t d|› d�| ¡}	| |	j ¡ ¡ qØn,ddlm}
 |
| ƒ}| |¡}dd„ |D ƒ}|dggk�sBJ ‚d S )Nrz   z)ADBC implementation does not create indexTr9  r"  r$  r'  rÇ   r(  Ztest_to_sql_saves_indexrE   >   r/  r  zASELECT * FROM sqlite_master WHERE type = 'index' AND tbl_name = 'ú'zPRAGMA index_info(ú)r   rÚ   c                 S  s   g | ]}|d  ‘qS )Zcolumn_namesr+   )rK   rG  r+   r+   r,   rM   D  rf   z*test_to_sql_save_index.<locals>.<listcomp>)r<  r=  rñ   r>  r?  r5  r   r+  r"   rÓ  r6  r   r#   rœ   rà   r   r9   rÛ   Zget_indexes)rX   r7  r�  rÅ   Ztbl_namer\  ZixsZix_colsZix_nameZix_inforÛ   r¥  r+   r+   r,   Útest_to_sql_save_index!  s>    ÿÿ
ÿ

P
ÿý

rë  c              	   C  s”   | }|  | ¡} d}|dkr6d|vr6ddlm} ||ƒ}t| ƒ�B}| ¡ �}| |¡ W d   ƒ n1 sh0    Y  W d   ƒ n1 s†0    Y  d S )Nú'CREATE TABLE test_trans (A INT, B TEXT)r/  rz   r   ru   )r5  r9   rv   r"   rÓ  rO   )rX   r7  r�  rY   rv   r\  Útransr+   r+   r,   Útest_transactionsI  s    


rî  c              	   C  sÂ  | }|  | ¡} t| ƒ��”}| ¡ �P}d}d|v s:t|tƒrF| |¡ nddlm} ||ƒ}| |¡ W d   ƒ n1 sx0    Y  G dd„ dtƒ}d}t|t	ƒr´ddlm} ||ƒ}z>| ¡ �"}| |¡ |dƒ‚W d   ƒ n1 sæ0    Y  W n |�y   Y n0 | ¡ � | 
d	¡}	W d   ƒ n1 �s20    Y  t|	ƒdk�sNJ ‚| ¡ �$}| |¡ | 
d	¡}
W d   ƒ n1 �s‚0    Y  t|
ƒd
k�sžJ ‚W d   ƒ n1 �s´0    Y  d S )Nrì  rz   r   ru   c                   @  s   e Zd ZdS )z1test_transaction_rollback.<locals>.DummyExceptionN)rŒ  r�  rŽ  r+   r+   r+   r,   ÚDummyExceptionh  s   rï  z/INSERT INTO test_trans (A,B) VALUES (1, 'blah')r  zSELECT * FROM test_transrD   )r5  r"   rÓ  rw   r    rO   r9   rv   Ú	Exceptionr   rÔ  r[  )rX   r7  r�  r\  rí  rY   rv   rï  Zins_sqlrQ  r™  r+   r+   r,   Útest_transaction_rollbackY  s8    

(


*
*

*rñ  c           
   	   C  sø   | dkr|  tjjdd�¡ | | ¡} ddlm} ddlm} d}t	j
||| d�}|jd d… }||ƒ}t| |ƒrÎ|  ¡ �B}| ¡ � | |¡ W d   ƒ n1 s¤0    Y  W d   ƒ qØ1 sÂ0    Y  n
|  |¡ t	 || ¡}	tj|	|d	d
� d S )Nr  z(test does not support sqlite_str fixturer  r   ru   r�   Útest_get_schema_create_tablerë  Fr*  )rˆ  rñ   r>  r?  r5  r9   rv   r’   r‘   r   r6  r©   rw   r“   rk   rO   r$   r®   r–  )
rX   r7  rÔ   rv   r‘   rö   r»  Zblank_test_dfZnewconZreturned_dfr+   r+   r,   rò  ƒ  s$    ÿ



H
rò  c                 C  sÌ  | dkrt  d¡ | | ¡} ddlm}m} ddlm} ddg}dd	g}t||d
�}|j	d| d�dksjJ ‚|j	d| d|id�dks†J ‚|ƒ }|j
| d� |jd jd j}	t|	|ƒs¸J ‚d}
t jt|
d��$ |j	d| dtid� W d   ƒ n1 sô0    Y  |j	d| d|dƒid�dk�s J ‚|j
| d� |jd jd j}	t|	|ƒ�sNJ ‚|	jdk�s^J ‚|j	d| |d�dk�sxJ ‚|j
| d� |jd jd j}|jd jd j}t||ƒ�s¸J ‚t||ƒ�sÈJ ‚d S )Nr  r™  r   )r~   r2   ©r1   rÇ   rÈ   ©gš™™™™™é?T©gÍÌÌÌÌÌì?NrÐ   Ú
dtype_testr  rE   Údtype_test2©rœ   ro   r;   rh   z&The type of B is not a SQLAlchemy typerc  r  Zdtype_test3é
   Úsingle_dtype_test)rñ   r£  r5  r9   r~   r2   Úsqlalchemy.schemar1   r   r6  ÚreflectÚtablesr°   rª   rw   rd  re  r|   ru  )rX   r7  r~   r2   r1   r]  r»   rÅ   ÚmetaZsqltyperR  ZsqltypeaZsqltypebr+   r+   r,   Ú
test_dtype¡  s8    

2"rÿ  c                 C  s4  | dkrt  d¡ | }| | ¡} ddlm}m}m}m} ddlm	} t
dd gƒt
tddd	ƒd gƒt
d	d gd
d�t
dd gƒdœ}t|ƒ}	d}
|	j|
| d�dks J ‚t |
| ¡}|ƒ }|j| d� d|v rÊ|n|}|j|
 j}t|d j|ƒsîJ ‚t|d j|ƒ�sJ ‚t|d j|ƒ�sJ ‚t|d j|ƒ�s0J ‚d S )Nr  r™  r   )r   r€   r0   r�   ró  TéÜ  r¦   rD   r‹  rB  r;  ©ÚBoolÚDateÚIntr0   Únotna_dtype_testr  rE   rh   r&   r  r  r  r0   )rñ   r£  r5  r9   r   r€   r0   r�   rû  r1   r   r   r   r6  r   r$   rü  rý  r°   rw   rª   )rX   r7  r�  r   r€   r0   r�   r1   r]  rÅ   rö   rÛ  rþ  Zmy_typeÚcol_dictr+   r+   r,   Útest_notna_dtypeË  s.    



ür  c              	   C  s„  | dkrt  d¡ | | ¡} ddlm}m}m} ddlm} d}t	t
|gdd�t
|gd	d�t
|gd	d�t
d
gdd�t
d
gdd�dœƒ}|jd| ddd|dd�id�dks¬J ‚t d| ¡}t |d jd d¡t |d jd d¡ksèJ ‚|ƒ }	|	j| d� |	jd j}
t|
d jƒt|
d jƒk�s(J ‚t|
d j|ƒ�s>J ‚t|
d j|ƒ�sTJ ‚t|
d j|ƒ�sjJ ‚t|
d j|ƒ�s€J ‚d S )Nr  r™  r   )Ú
BigIntegerr0   r�   ró  gñYÉBÊÀó?rá  rB  Úfloat64r¦   r  rÂ   )Úf32Úf64Ú
f64_as_f32Úi32r±  Ztest_dtypesFrK  r  é   )Ú	precision)rœ   ro   r¤   r4  r;   rD   r  é   rh   r
  r  r±  )rñ   r£  r5  r9   r  r0   r�   rû  r1   r   r   r6  r   r$   r¬   Úroundr©   rü  rý  r°   r|   rª   rw   )rX   r7  r  r0   r�   r1   ÚVrÅ   rQ  rþ  r  r+   r+   r,   Útest_double_precisionð  sD    

ûÿûùÿ
0"r  c                   sp   |  | ¡} ddlm‰  dd„ ‰dd„ ‰‡‡fdd„‰‡ ‡fd	d
„}tdg d¢iƒjd| d�dksdJ ‚|| ƒ d S )Nr   r�   c                 S  s   d}t j|| d�S )Nz'SELECT test_foo_data FROM test_foo_datarë  )r   r#   )rŸ  r{  r+   r+   r,   Útest_select,  s    z3test_connectable_issue_example.<locals>.test_selectc                 S  s   |j d| dd� d S )NÚtest_foo_datarà   )rœ   ro   r4  )r6  )rŸ  r»   r+   r+   r,   Útest_append0  s    z3test_connectable_issue_example.<locals>.test_appendc                   s   ˆ| ƒ}ˆ | |ƒ d S rø   r+   )rX   Zfoo_data)r  r  r+   r,   Útest_connectable3  s    z8test_connectable_issue_example.<locals>.test_connectablec              	     sp   t | ˆ ƒrd|  ¡ �@}| ¡ � ˆ|ƒ W d   ƒ n1 s:0    Y  W d   ƒ ql1 sX0    Y  nˆ| ƒ d S rø   )rw   r“   rk   )ZconnectablerX   )r‘   r  r+   r,   Úmain9  s
    


Fz,test_connectable_issue_example.<locals>.mainr  rU  r  rF   )r5  r’   r‘   r   r6  )rX   r7  r  r+   )r‘   r  r  r  r,   Útest_connectable_issue_example$  s    
	ÿÿr  Úinputr  Úbar)r  Úinfe0c           	      C  sÔ   t |ƒ}| }| | ¡} d|v r t d¡}t|jƒtdƒk r\d|jv r\tjjdd�}| 	|¡ d}tj
t|d��  |jd	| d
d� W d   ƒ qÐ1 s”0    Y  n0|jd	| d
d�dks¸J ‚t d	| ¡}t ||¡ d S )Nr&   rï   z1.0.3r  zGH 36465r  zinf cannot be used with MySQLrc  ZfoobarFr•  rD   )r   r5  rñ   rò   r   r:   r°   r>  r?  rˆ  rd  re  r6  r   r$   r®   Zassert_equal)	rX   r7  r  rÅ   r�  rï   r>  rR  rQ  r+   r+   r,   Útest_to_sql_with_negative_npinfH  s    


0r  c              	     s  | dkrt  d¡ | | ¡} ddlm‰ m‰m‰m} ddlm	}m
} d}td|giƒ}|ƒ }G ‡ ‡‡fdd	„d	|ƒ}|| ƒ�x}	|	 ¡ �P |	 ¡ } |j | ¡ |	 ||d
�¡ |	 ¡  tj||jƒ| d�}
W d   ƒ n1 sÜ0    Y  W d   ƒ n1 sú0    Y  t |
|¡ d S )Nr  z&test does not work with str connectionr   )r.   r�   ÚUnicoders  )ÚSessionÚdeclarative_basezHello, World!Úspamc                      s6   e Zd ZdZddgiZ” ”dd�Z” ”dƒdd�Zd	S )
z'test_temporary_table.<locals>.TemporaryZ	temp_testÚprefixesÚ	TEMPORARYT©Zprimary_keyrÕ  F)ZnullableN)rŒ  r�  rŽ  Ú__tablename__Z__table_args__Úidr!  r+   ©r.   r�   r  r+   r,   Ú	Temporary~  s   
r(  )r!  )r   ro   )rñ   r£  r5  r9   r.   r�   r  rs  Úsqlalchemy.ormr  r   r   rk   rŸ  Z	__table__rm   ÚaddÚflushr   r#   r!  r®   r–  )rX   r7  rs  r  r   rÀ  r¬  ZBaser(  ÚsessionrÅ   r+   r'  r,   Útest_temporary_tableh  s"    



Pr-  c              	   C  sœ   | dksd| v r$|  tjjdd�¡ | | ¡} d}t| ƒ�N}tjt|d��  |j|ddd	� W d   ƒ n1 sp0    Y  W d   ƒ n1 sŽ0    Y  d S )
Nr/  rz   z9SQLiteDatabase/ADBCDatabase does not raise for bad enginer  z*engine must be one of 'auto', 'sqlalchemy'rc  rÓ   Z
bad_engine©r¸   )	rˆ  rñ   r>  r?  r5  r"   rd  re  r6  )rX   r7  rÓ   rR  r\  r+   r+   r,   Útest_invalid_engineŽ  s    ÿÿ

r/  c              	   C  s¢   |  | ¡} t| ƒ�^}| ¡ �6 |j|ddd�dks6J ‚| d¡sDJ ‚W d  ƒ n1 sX0    Y  W d  ƒ n1 sv0    Y  t|ƒ}t| dƒ}||ksžJ ‚dS )z `to_sql` with the `engine` paramrÓ   Úautor.  rG   N)r5  r"   rÓ  r6  rZ  r[  r¹   rß  r+   r+   r,   Útest_to_sql_with_sql_enginež  s    


J
r1  c              
   C  sÊ   |  | ¡} t dd¡�  t| ƒ�Z}| ¡ �2 | |d¡dks@J ‚| d¡sNJ ‚W d   ƒ n1 sb0    Y  W d   ƒ n1 s€0    Y  t|ƒ}t| dƒ}||ks¨J ‚W d   ƒ n1 s¼0    Y  d S )Núio.sql.enginer9   rÓ   rG   ©	r5  rL  Úoption_contextr"   rÓ  r6  rZ  r[  r¹   rß  r+   r+   r,   Útest_options_sqlalchemy­  s    


J
r5  c              
   C  sÊ   |  | ¡} t dd¡�  t| ƒ�Z}| ¡ �2 | |d¡dks@J ‚| d¡sNJ ‚W d   ƒ n1 sb0    Y  W d   ƒ n1 s€0    Y  t|ƒ}t| dƒ}||ks¨J ‚W d   ƒ n1 s¼0    Y  d S )Nr2  r0  rÓ   rG   r3  rß  r+   r+   r,   Útest_options_auto¼  s    


J
r6  c                   C  sÀ   t  d¡ ttdƒtƒsJ ‚t dd¡�4 ttdƒtƒs<J ‚ttdƒtƒsNJ ‚W d   ƒ n1 sb0    Y  t dd¡�4 ttdƒtƒsŒJ ‚ttdƒtƒsžJ ‚W d   ƒ n1 s²0    Y  d S )Nr9   r2  r0  )rñ   rò   rw   r!   r   rL  r4  r+   r+   r+   r,   Útest_options_get_engineË  s    
0r7  c                   C  s   d S rø   r+   r+   r+   r+   r,   Ú"test_get_engine_auto_error_messageØ  s    r8  Úfuncrj  r#   c                 C  s  | }|  | ¡} d}|}	|	j|| ddd� t d|¡�* tt|ƒd|› �| |d�}
W d   ƒ n1 sd0    Y  ||||ƒ}t |
|¡ d|v r¢| tj	j
d	d
�¡ t d|¡�N tt|ƒd|› �| |dd�}||||ƒ}|D ]}
t |
|¡ qÜW d   ƒ n1 �s0    Y  d S )Nr2  FrK  ©rœ   ro   r¤   r4  úmode.string_storageúSelect * from ©Údtype_backendrz   z(adbc does not support chunksize argumentr  rF   )ro   r>  rq  )r5  r6  rL  r4  rŠ  r®   r–  rˆ  rñ   r>  r?  ©rX   r7  Zstring_storager9  r>  Údtype_backend_dataÚdtype_backend_expectedr�  ræ   rÅ   r®  r¬  Úiteratorr+   r+   r,   Útest_read_sql_dtype_backendß  s2    
ÿ$ÿürC  r$   c                 C  s  d| v r$d| vr$|  tjjdd�¡ | }| | ¡} d}|}	|	j|| ddd� t d	|¡�$ tt|ƒ|| |d
�}
W d   ƒ n1 s‚0    Y  ||||ƒ}t	 
|
|¡ d|v r°d S t d	|¡�H tt|ƒ|| |dd�}||||ƒ}|D ]}
t	 
|
|¡ qäW d   ƒ n1 �s0    Y  d S )Nr%   rz   zhSQLite actually returns proper boolean values via read_sql_table, but before pytest refactor was skippedr  r2  FrK  r:  r;  r=  rF   )r>  rq  )rˆ  rñ   r>  r?  r5  r6  rL  r4  rŠ  r®   r–  r?  r+   r+   r,   Ú!test_read_sql_dtype_backend_table
  s6    þÿ	
2ürD  )rj  r$   r#   c                 C  sn   |  | ¡} d}|}|j|| ddd� d}tjt|d��$ tt|ƒ|| dd� W d   ƒ n1 s`0    Y  d S )	Nr2  FrK  r:  zPdtype_backend numpy is invalid, only 'numpy_nullable' and 'pyarrow' are allowed.rc  Únumpyr=  )r5  r6  rñ   rd  re  rŠ  rL  )rX   r7  r9  r@  ræ   rÅ   rR  r+   r+   r,   Ú)test_read_sql_invalid_dtype_backend_table:  s    
ÿrF  r„  c                
   C  sb   t tdtjdgdd�tg d¢dd�tdtjdgdd�tg d	¢dd�g d
¢g d¢g d¢g d¢dœƒS )NrD   rF   ro  rB  r�  r%  ç      @ÚFloat64©r%  rœ  rG  )TFN©TFTrY  ©rE  r”  N©rE  r”  rá   ÚdÚeÚfÚgÚh)r   r   r¬   rV  r+   r+   r+   r,   r@  J  s    øÿr@  c                  C  s   ddœdd„} | S )Nr   r„  c              
     sž  | dkr>t tjg d¢tjd�ƒ}t tjddtjgtjd�ƒ}nr|dkr‚t d¡‰ddlm	‰  ˆ ˆ g d¢¡ƒ}ˆ ˆ g d	¢¡ƒ}n.t d¡‰t
ˆ g d¢¡ƒ}t
ˆ g d	¢¡ƒ}ttd
tjdgdd�tg d¢dd�tdtjdgdd�tg d¢dd�tddtjgdd�tg d¢dd�||dœƒ‰|dk�rZt d¡‰ddlm	‰  t‡ ‡‡fdd„ˆjD ƒƒ‰d|v �snd|v �rš|dk�rŠˆ dddœ¡‰nˆ dddœ¡‰ˆS )NÚpythonrY  rB  rE  r”  rA  r   )ÚArrowExtensionArrayrK  rD   rF   ro  r�  r%  rG  rH  rI  TFÚbooleanrJ  rL  c                   s$   i | ]}|ˆ ˆj ˆ| d d�ƒ“qS )T)Zfrom_pandas)rM  )rK   r—  ©rS  rÅ   rZ  r+   r,   Ú
<dictcomp>�  s   ÿz8dtype_backend_expected.<locals>.func.<locals>.<dictcomp>r&   r%   Únumpy_nullable)rN  rO  zint64[pyarrow])r   r¬   rM  Zobject_rL  ZNArñ   rò   Zpandas.arraysrS  r   r   r   rV  r°   rÄ   )Zstorager>  r�  Zstring_arrayZstring_array_nar+   rU  r,   r9  \  sF    

øÿ

þÿ
z$dtype_backend_expected.<locals>.funcr+   )r9  r+   r+   r,   rA  Z  s    3rA  c                 C  s†   d| v r|j  tjjdd�¡ | | ¡} dddœ}tddgd	� |¡}| ¡ }|j	d
| ddd� t
d| |dd�D ]}t ||¡ qpd S )Nrz   r~  r  rÂ   r‹  r“  rE  r”  rÐ   r2  FrK  r:  zSELECT * FROM testrD   )r;   rq  )r<  r=  rñ   r>  r?  r5  r   rÄ   rO  r6  r#   r®   r–  )rX   r7  r¨   rÅ   r¬  r®  r+   r+   r,   Útest_chunksize_empty_dtypes’  s     ÿ

ü
rX  r>  rW  c                 C  s˜   |  | ¡} d}tg d¢ddœƒ}|j|| ddd� tt|ƒd|› �| d	tji|d
�}ttg d¢tjd�tg d¢|dkszdndd�dœƒ}t 	||¡ d S )Nr2  r�  r¦   r“  FrK  r:  r<  rE  )r;   r>  rB  )r¦   r¦   r¦   rW  rÂ   ro  )
r5  r   r6  rŠ  rL  r¬   r	  r   r®   r–  )rX   r7  r9  r>  ræ   rÅ   r®  r¬  r+   r+   r,   Útest_read_sql_dtype¨  s&    
üþþÿ	rY  c                 C  st   | }d}t ddddœddddœgƒ}| d|¡ tjt|d��" |jd|d dd	� W d   ƒ n1 sf0    Y  d S )
NzxStarting with pandas version 3.0 all arguments of to_sql except for the arguments 'name' and 'con' will be keyword-only.rD   rE   rF   r'  Zexamplerc  rK  r_  )r   r6  r®   rP  rÍ  )r  rX   rR  rÅ   r+   r+   r,   Útest_keyword_deprecationÄ  s    ÿrZ  c                 C  sj   | }t dddgidd�}|jd|dd�dks0J ‚t d ¡� t d|¡ W d   ƒ n1 s\0    Y  d S )	NrE  rD   rE   rÂ   rB  Ztest_bigintwarningFr•  )r   r6  r®   rP  r   r$   ©r  rX   rÅ   r+   r+   r,   Útest_bigint_warningÒ  s
    r\  c                 C  s^   | }t ddgddgdœƒ}tjtdd��" |jd|d	d
d� W d   ƒ n1 sP0    Y  d S )NrD   rE   rF   rG   ©r©  rª  zEmpty table name specifiedrc  rG  rK  Fr3  )r   rñ   rd  re  r6  r[  r+   r+   r,   Útest_valueerror_exceptionÜ  s    r^  c           
        s  | }ddl m‰ m‰m‰ ddlm}m} |ƒ }G ‡ ‡‡fdd„d|ƒ}| ¡ � |j 	|¡ W d   ƒ n1 sp0    Y  ||d�}|ƒ �`}t
ddgdd	gd
œƒ}|jd|ddd�dks¼J ‚| ¡  | |j|j¡}	t
|	ƒ}W d   ƒ n1 sð0    Y  t|jƒddgk�sJ ‚d S )Nr   ©r.   r�   r2   )r   Úsessionmakerc                      s(   e Zd ZdZ” ”dd�Z” ”dƒƒZdS )z,test_row_object_is_named_tuple.<locals>.TestrX  Tr$  é2   N)rŒ  r�  rŽ  r%  r&  Ústring_columnr+   r_  r+   r,   ÚTestõ  s   rc  rh   rD   ZhelloZworld)r&  rb  rX  FrK  r:  rE   r&  rb  )r9   r.   r�   r2   r)  r   r`  rk   r<   Z
create_allr   r6  rV   r{  r&  rb  rº  r°   )
r  rX   r   r`  Z	BaseModelrc  r  r,  rÅ   Z
test_queryr+   r_  r,   Útest_row_object_is_named_tupleã  s$    
*
ÿÿ&rd  c                 C  sž   | }t  d¡ d}tdddgiƒ}|j||ddd� t d	d
¡� t||ƒ}W d   ƒ n1 s`0    Y  d}tdddgi|tdg|d�d�}t 	||¡ d S )NrA  r2  rE  ÚxÚyFrK  )ro   r¤   r4  zfuture.infer_stringTzstring[pyarrow_numpy]rB  )r;   r°   )
rñ   rò   r   r6  rL  r4  r$   r   r®   r–  )r  rX   ræ   rÅ   r®  r;   r¬  r+   r+   r,   Útest_read_sql_string_inference
  s    
(ÿrg  c                 C  sT   | }t dtddddƒgidd�}|jd|dd	d
� t d|¡jd }|dksPJ ‚d S ©NÚtiä  rý  é   r  rB  r2  rK  F)r4  r¤   úselect * from test©r   r   z2020-12-31 12:00:00.000000)r   r   r6  rL  rj  r©   )r  rX   rÅ   r®  r+   r+   r,   Útest_roundtripping_datetimes  s
    rm  c               	   c  sd   t  tjdtjd�¡�:} | �}|V  W d   ƒ n1 s80    Y  W d   ƒ n1 sV0    Y  d S )Nr,  )Zdetect_types)r-  r   rx   r“   ZPARSE_DECLTYPESr.  r+   r+   r,   Úsqlite_builtin_detect_types&  s    ÿrn  c                 C  sX   | }t dtddddƒgidd�}|jd|dd	d
� t d|¡jd }|tdƒksTJ ‚d S rh  )r   r   r6  rL  rj  r©   r   )rn  rX   rÅ   r®  r+   r+   r,   Ú)test_roundtripping_datetimes_detect_types/  s
    ro  c           
   	   C  s^  | }t ddgddgddgdœƒ}| ¡ �L}| ¡ �$ | d¡ | d	¡ W d   ƒ n1 s\0    Y  W d   ƒ n1 sz0    Y  |jd
|dd�dksœJ ‚|jd|ddd�dks¶J ‚|jd|ddd�dksÐJ ‚t d
|¡}t ||¡ t d|¡}t ||¡ tjd|dd�}t ||¡ tjd|dd�}t ||¡ d}t	j
t|d��  tjd|dd� W d   ƒ n1 �sr0    Y  | ¡ �N}| ¡ �$ | d¡ | d	¡ W d   ƒ n1 �sº0    Y  W d   ƒ n1 �sÚ0    Y  |jd|ddd�dk�s J ‚|jd|dddd� |jd|dddd�dk�s2J ‚tjd|dd�}	t t||gdd�|	¡ d S )NrD   rE   r‘  r¢   rE  r§  r¨  z$DROP SCHEMA IF EXISTS other CASCADE;zCREATE SCHEMA other;Ztest_schema_publicFr•  Ztest_schema_public_explicitr¾  )rœ   ro   r¤   rå   Ztest_schema_otherÚotherr¿  z!Table test_schema_other not foundrc  )rœ   ro   rå   r¤   rK  )rœ   ro   rå   r¤   r4  rà   TrB  )r   r“   rk   r¶   r6  r   r$   r®   r–  rñ   rd  re  r   )
r  rX   rÅ   ro   r˜  r™  rJ  Zres4rR  rQ  r+   r+   r,   Útest_psycopg2_schema_support8  sl    


Füúÿ
ÿ0


Jÿûûùÿ
rq  c           	   	   C  sð   | }ddl m} |dƒ}| ¡ �B}| ¡ � | |¡ W d   ƒ n1 sJ0    Y  W d   ƒ n1 sh0    Y  d}t ||¡}tdtddd�gd	 gd
dgd	 d�}t	 
||¡ tj|dd��}| d¡ W d   ƒ n1 sâ0    Y  d S )Nr   ru   zÐ
    CREATE TABLE person
    (
        id serial constraint person_pkey primary key,
        created_dt timestamp with time zone
    );

    INSERT INTO person
        VALUES (1, '2021-01-01T00:00:00Z');
    zHSELECT * FROM "person" AS p1 INNER JOIN "person" AS p2 ON p1.id = p2.id;rD   Z2021r˜   r™   rE   r&  Z
created_dtrÐ   TrW  Zperson)r¹  rv   r“   rk   rO   rL  rj  r   r   r®   r–  r   r   rì   )	r  rX   rv   rÈ  ro   r¤  r®  r¬  r\  r+   r+   r,   Útest_self_join_date_columnsƒ  s"    ÿ

Fÿÿrr  c              	   C  sÒ   | }t g d¢g d¢dœƒ}t |¡�š}| ¡ �$ | |d¡dksDJ ‚W d   ƒ n1 sX0    Y  | d¡spJ ‚| ¡ � | d¡ W d   ƒ n1 s˜0    Y  | d¡r°J ‚W d   ƒ n1 sÄ0    Y  d S )Nrš  rŸ  r   Zdrop_test_framerG   )r   r   r   rÓ  r6  rZ  rì   )r  rX   r  r\  r+   r+   r,   Útest_create_and_drop_table§  s    
2
(rs  c                 C  s^   | }t tdddƒtdddƒgdgd�}|jd|dd�dks>J ‚td	|ƒ}t || t¡¡ d S )
NrÑ  rD   rE   rE  rÐ   rÒ  Fr•  zSELECT * FROM test_date)r   r   r6  r#   r®   r–  rÄ   r|   )r/  rX   rÅ   rQ  r+   r+   r,   Útest_sqlite_datetime_date¶  s
    "
rt  Útz_awareFTc                 C  s”   |}| s"t dddƒt dddƒg}n$tdddd�}t| ¡ ƒ d	d
„ ¡}t|dgd�}|jd|dd�dkslJ ‚td|ƒ}| dd
„ ¡}t 	||¡ d S )NrÔ  r   rD   rÕ  r¹  rE   rº  r»  c                 S  s   |   ¡ S rø   )Útimetz)r¾  r+   r+   r,   rÜ  Ç  rf   z+test_sqlite_datetime_time.<locals>.<lambda>rE  rÐ   rÖ  Fr•  zSELECT * FROM test_timec                 S  s
   |   d¡S r×  rØ  rÚ  r+   r+   r,   rÜ  Î  rf   )
r   r   r   Zto_pydatetimerÝ  r   r6  r#   r®   r–  )ru  r/  rX   Ztz_timesZtz_dtrÅ   rQ  r¬  r+   r+   r,   Útest_sqlite_datetime_time¿  s    
rw  c           
      C  sR   |   d|› d�¡}|D ] \}}}}}}	||kr|  S qtd|› d|› d�ƒ‚d S )NzPRAGMA table_info(rê  zTable z	, column z
 not found)rO   re  )
rX   ræ   ÚcolumnZrecsZcidrœ   ÚctypeZnot_nullÚdefaultÚpkr+   r+   r,   Úget_sqlite_column_typeÒ  s
    
r|  c                 C  s  | }ddg}ddg}t ||d�}|jd|d�dks6J ‚|jd	|dd
id�dksRJ ‚t|ddƒdksfJ ‚t|d	dƒd
kszJ ‚d}tjt|d��$ |jd|dtid� W d   ƒ n1 s¶0    Y  |jd|d
d�dksØJ ‚t|ddƒd
ksìJ ‚t|ddƒd
k�sJ ‚d S )NrÇ   rÈ   rô  rõ  rÐ   rö  r  rE   r÷  ÚSTRINGrø  r=  z!B \(<class 'bool'>\) not a stringrc  r  rú  )r   r6  r|  rñ   rd  re  Úbool)r/  rX   r]  r»   rÅ   rR  r+   r+   r,   Útest_sqlite_test_dtypeÚ  s    2r  c                 C  s´   | }t dd gƒt tdddƒd gƒt dd gdd�t dd gƒdœ}t|ƒ}d	}|j||d
�dks`J ‚t||dƒdkstJ ‚t||dƒdksˆJ ‚t||dƒdksœJ ‚t||dƒdks°J ‚d S )NTr   r¦   rD   r‹  rB  r;  r  r  r  rE   r  r=  r  re  r  r0   ZREAL)r   r   r   r6  r|  )r/  rX   r]  rÅ   rö   r+   r+   r,   Útest_sqlite_notna_dtypeð  s    

ür€  c                 C  sæ   | }t ddgddggddgd�}d}tjt|d	�� |jd
|d� W d   ƒ n1 sV0    Y  tg d¢ƒD ]t\}}|j||d�dksŠJ ‚t ||¡ t ddgddggd|gd�}d|d›�}|j||d�dksÔJ ‚t ||¡ qld S )NrD   rE   rF   rG   rE  r”  rÐ   z$Empty table or column name specifiedrc  rG  r  )
ztest_weird_name]ztest_weird_name[ztest_weird_name`ztest_weird_name"ztest_weird_name'z_b.test_weird_name_01-30z"_b.test_weird_name_01-30"Z99beginswithnumberZ12345rS  Ztest_weird_col_namerM  )r   rñ   rd  re  r6  Ú	enumerater   Ztable_exists)r/  rX   rÅ   rR  ZndxZ
weird_namerP  Zc_tblr+   r+   r,   Útest_sqlite_illegal_names  s    ,ÿr‚  c                 G  sŽ   t djtdjtjdjtdjtdjtdjtd ƒdd„ tj	djt
dji	}g }|D ]4}t|tƒrft|ƒrfd }|t|ƒ }| ||ƒ¡ qL| t|ƒ S )Nz'{}'z{:.8f}z{:d}c                 S  s   dS )NZNULLr+   )re  r+   r+   r,   rÜ  +  rf   zformat_query.<locals>.<lambda>z{:.10f}z'{!s}')r   rÇ  r|   r¬   Zstr_ÚbytesrI   r*  rª   r	  r~  rw   r   rà   r  )r   r‡  Z_formattersZprocessed_argsÚargÚ	formatterr+   r+   r,   Úformat_query#  s"    ÷r†  c                 C  sL   t  |¡�}| | ¡ ¡ }W d  ƒ n1 s.0    Y  |du rDdS t|ƒS )z#Replace removed sql.tquery functionN)r   r"   rO   rÜ   rº  )r{  ro   rö  rQ  r+   r+   r,   Útquery:  s    ,r‡  c                 C  s  t tj d¡ d¡ttdƒtd�tdddd�d	�}t	j
|d
| dd�dksLJ ‚t	 d| ¡}|j|_|}t ||¡ dgt|ƒ |d< | ¡ }tt t|ƒ¡tjd�d }| ¡ |d< t	j
|d| dd�dksÌJ ‚t	jd| dd�}| ¡ }||_d|j_t ||¡ d S )NrE   ©rù  rG   ÚABCDrB  ú
2000-01-01rù  rÈ   rÂ  r(  rX  Fr•  zselect * from test_tablerE  ÚtxtZIdxZtest_table2zselect * from test_table2r)  )r   r¬   rC  rD  rE  r   rº  r‹  r   r   r6  rj  r¤   r®   r–  r[  rO  rå  rÂ   rœ   )r/  rŸ   r®  r¬  Zframe2Znew_idxr+   r+   r,   Útest_xsqlite_basicA  s(    ýrŒ  c           	      C  sÀ   t tj d¡ d¡ttdƒtd�tdddd�d	�}tj	|j
d
< t |d¡}|  ¡ }| |¡ d}| ¡ D ]$\}}t|g|¢R Ž }t|| d� qh|  ¡  tjd| d�}|j|_tj||dd� d S )NrE   rˆ  r‰  rB  rŠ  rù  rÈ   rÂ  r(  rl  r2  z(INSERT INTO test VALUES (%s, %s, %s, %s)rë  rk  gü©ñÒMbP?)Zrtol)r   r¬   rC  rD  rE  r   rº  r‹  r   rV  r©   r   r6  rN   rO   Ziterrowsr†  r‡  rV   rj  r¤   r®   r–  )	r/  rŸ   r»  rZ   ÚinsrÛ  rL   Zfmt_sqlr®  r+   r+   r,   Útest_xsqlite_write_row_by_row\  s"    ý
rŽ  c                 C  sÔ   t tj d¡ d¡ttdƒtd�tdddd�d	�}t	 
|d
¡}|  ¡ }| |¡ d}|jd }t	 | ¡� }| |t|ƒ¡ W d   ƒ n1 sŽ0    Y  |  ¡  t	 d| ¡}|jd d… |_t ||d d… ¡ d S )NrE   rˆ  r‰  rB  rŠ  rù  rÈ   rÂ  r(  r2  z$INSERT INTO test VALUES (?, ?, ?, ?)r   rk  rD   )r   r¬   rC  rD  rE  r   rº  r‹  r   r   r6  rN   rO   r©   r"   r  rV   rj  r¤   r®   r–  )r/  rŸ   r»  rZ   r�  rL   rö  r®  r+   r+   r,   Útest_xsqlite_executes  s     ý

.r�  c                 C  sÀ   t tj d¡ d¡ttdƒtd�tdddd�d	�}t	 
|d
¡}| ¡ }|D ]6}| d¡}t|ƒdkrJ|d dkrJ|d dksJJ ‚qJt	j
|d
ddgd�}| ¡ }d|v sªJ ‚|  ¡ }| |¡ d S )NrE   rˆ  r‰  rB  rŠ  rù  rÈ   rÂ  r(  r2  ú r   rÇ   rD   ZDATETIMEr�  zPRIMARY KEY ("A", "B"))r   r¬   rC  rD  rE  r   rº  r‹  r   r   r6  Ú
splitlinesr•  r[  rN   rO   )r/  rŸ   r»  ÚlinesÚlineÚtokensrZ   r+   r+   r,   Útest_xsqlite_schemaˆ  s     ý
r•  c              	   C  s’   d}|   ¡ }| |¡ t | ¡�^}| d¡ | d¡ tjtjdd�� | d¡ W d   ƒ n1 sf0    Y  W d   ƒ n1 s„0    Y  d S )Núc
    CREATE TABLE test
    (
    a TEXT,
    b TEXT,
    c REAL,
    PRIMARY KEY (a, b)
    );
    ú,INSERT INTO test VALUES("foo", "bar", 1.234)z,INSERT INTO test VALUES("foo", "baz", 2.567)zExecution failed on sqlrc  z(INSERT INTO test VALUES("foo", "bar", 7))rN   rO   r   r"   rñ   rd  r‘  )r/  r»  rZ   rö  r+   r+   r,   Útest_xsqlite_execute_failœ  s    	


r˜  c               	   C  s¾   d} t  t d¡¡�V}| ¡ }| | ¡ t |¡�}| d¡ W d   ƒ n1 sR0    Y  W d   ƒ n1 sp0    Y  d}tj	tj
|d�� td|d� W d   ƒ n1 s°0    Y  d S )Nr–  r,  r—  z$Cannot operate on a closed database.rc  rk  rë  )r-  r   rx   r“   rN   rO   r   r"   rñ   rd  r  r‡  )r»  rX   rZ   rö  rR  r+   r+   r,   Ú&test_xsqlite_execute_closed_connection±  s    	
Fr™  c                 C  s0   t dt d¡iƒ}tj|| ddd�dks,J ‚d S )NÚFromr¦   ZtestkeywordsF©ro   rœ   r¤   )r   r¬   Zonesr   r6  )r/  rÅ   r+   r+   r,   Ú$test_xsqlite_keyword_as_column_namesÇ  s    rœ  c                 C  sp   t ddgdgd�}tj|| ddd�dks,J ‚| }tdd	„ | d
¡D ƒƒ}|dksTJ ‚t d
|¡}t ||¡ d S )NrD   rE   Zc0rÐ   Úmono_dfFr›  c                 s  s   | ]}|d  V  qdS )r   Nr+   )rK   Zmy_c0r+   r+   r,   Ú	<genexpr>Ô  rf   z4test_xsqlite_onecolumn_of_integer.<locals>.<genexpr>zselect * from mono_dfrF   )r   r   r6  ÚsumrO   rj  r®   r–  )r/  r�  Zcon_xZthe_sumr®  r+   r+   r,   Ú!test_xsqlite_onecolumn_of_integerÌ  s    r   c                 C  sÌ  t ddgddgdœƒ}t g d¢g d¢dœƒ}d}d	|› �}d
}tjt|d��" tj|| |dd� W d   ƒ n1 st0    Y  t|| ƒ tj|| |dd� d}tjt|d��" tj|| |dd� W d   ƒ n1 sÔ0    Y  tj|| |ddd� t|| d�ddgk�sJ ‚tj|| |ddd�dk�s*J ‚t|| d�g d¢k�sDJ ‚t|| ƒ tj|| |ddd�dk�slJ ‚t|| d�ddgk�s†J ‚tj|| |ddd�dk�s¤J ‚t|| d�g d¢k�s¾J ‚t|| ƒ d S )NrD   rE   rÇ   rÈ   r]  r  )rÉ   rÊ   ÚEZtable_if_existszSELECT * FROM z*'notvalidvalue' is not valid for if_existsrc  Znotvalidvalue)rŸ   ro   rœ   r4  r^  z&Table 'table_if_exists' already existsrK  F)rŸ   ro   rœ   r4  r¤   rë  rÏ  rç  rF   )©rF   rÉ   ©rG   rÊ   ©r¦   r¡  rà   )rÏ  rç  r¢  r£  r¤  )r   rñ   rd  re  r   r6  rì   r‡  )r/  Zdf_if_exists_1Zdf_if_exists_2r³   Z
sql_selectrR  r+   r+   r,   Útest_xsqlite_if_existsÜ  s†    
ü$
ÿü$ûûùÿ

ûùÿ
ûùÿ
r¥  )N(,  Ú
__future__r   r-  r   rQ   r   r   r   r   rº   r   Úpathlibr
   rx   Útypingr   rÄ  rE  r¬   rñ   Zpandas._libsr   Zpandas.compatr   r   Zpandas.compat._optionalr   Zpandas.util._test_decoratorsÚutilZ_test_decoratorsÚtdZpandasrL  r   r   r   r   r   r   r   r   r   r   Zpandas._testingZ_testingr®   Zpandas.core.arraysr   r   Zpandas.util.versionr   Z	pandas.ior   Zpandas.io.sqlr   r   r    r!   r"   r#   r$   r9   r>  ÚfilterwarningsZ
pytestmarkZfixturer-   r=   r]   r^   rp   r{   rŒ   rŽ   r�   r”   r�   r²   r¹   r½   r�   rÆ   rÓ   rÔ   rè   ré   rì   rî   r÷   rú   rü   rþ   rÿ   r   r  r  r  r  r  r  r  r  r  r  r  r   r!  r"  r#  r$  r%  r&  r(  r)  r+  r/  r0  r1  Úparamrí   Zmysql_connectableZmysql_connectable_irisZmysql_connectable_typesZpostgresql_connectableZpostgresql_connectable_irisZpostgresql_connectable_typesZsqlite_connectableZsqlite_connectable_irisZsqlite_connectable_typesZsqlalchemy_connectableZsqlalchemy_connectable_irisZsqlalchemy_connectable_typesZadbc_connectableZadbc_connectable_irisZadbc_connectable_typesZall_connectableZall_connectable_irisZall_connectable_typesZparametrizer8  r@  rS  rT  r]  rb  rf  rm  rr  rw  r|  r}  r€  r†  rŽ  rš  r¯  r½  rÁ  rÂ  rÇ  rÉ  rÎ  rÏ  rÐ  rÖ  r×  rØ  rÙ  rÚ  rÛ  rÝ  rà  râ  rä  ré  ró  rô  rø  r  rj  r  r  r  r  r  r!  r,  r*  rI   r1  r2  r8  r:  r>  r@  rK  rR  rT  rW  r[  r^  r_  rb  rc  rd  rl  r;   rœ   rq  rr  rt  Zskip_if_installedrw  r{  r~  r€  r�  r‚  r�  r’  r“  r˜  r¦  r©  rª  r«  r¬  r­  r®  r°  r²  r´  r¶  r·  r¸  rÀ  rÁ  rÆ  rÊ  rÌ  rÐ  rÓ  rß  râ  rå  ræ  rè  rë  rî  rñ  rò  rÿ  r  r  r  Úinfr  r-  r/  r1  r5  r6  r7  r8  rC  rD  rF  r@  rA  rX  Z
no_defaultrY  rZ  r\  r^  rd  rg  rm  rn  ro  rq  rr  rs  rt  rw  r|  r  r€  r‚  r†  r‡  rŒ  rŽ  r�  r•  r˜  r™  rœ  r   r¥  r+   r+   r+   r,   Ú<module>   sÈ  0$
ÿ
"-




#



















	










þþþþþþ
ÿ
ÿþþþÿÿ


!
	





	



$%
9

4
#


















7

ý
øþ(

.
þ
I
üþ	
0 "ñþ




'))$3#0þ%).7
'		J#	 