a
    •˜ëjÔ^  ã                   @   s  d dl Z ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ dd	lmZ dd
lmZ ddlm	Z	 ddlm
Z
 ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddl m!Z! G d d!„ d!ej"ƒZ#G d"d#„ d#ej"ƒZ$G d$d%„ d%ej%ƒZ&G d&d'„ d'ej"ƒZ'G d(d)„ d)ej%ƒZ(G d*d+„ d+ej"ƒZ)G d,d-„ d-ej"ƒZ*G d.d/„ d/ej+e*ƒZ,G d0d1„ d1ej"ƒZ-G d2d3„ d3ej%ƒZ.dS )4é    Né   )Útestingé   )Úassert_raises)Úconfig)Úengines)Úeq_)Úfixtures)Úis_not_none)Úis_true)Úmock)Úne_)Úprovide_metadata)Úexpect_raises)Úexpect_raises_message)Úrequirements)Ú set_default_schema_on_connection)ÚColumn)ÚTableé   )Ú	bindparam)Údialects)Úevent)Úexc)ÚInteger)Úliteral_column)Úselect)ÚString)ÚCompiled)Úinspect_getfullargspecc                   @   s   e Zd ZdZdd„ ZdS )ÚPingTestTc                 C   sD   t j ¡ �&}tt jj |jj¡ƒ W d   ƒ n1 s60    Y  d S ©N)r   ÚdbÚconnectr   ÚdialectZdo_pingÚ
connectionÚdbapi_connection)ÚselfÚconn© r)   úd/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_dialect.pyÚtest_do_ping,   s    ÿzPingTest.test_do_pingN)Ú__name__Ú
__module__Ú__qualname__Ú__backend__r+   r)   r)   r)   r*   r    )   s   r    c                   @   s:   e Zd ZdZdd„ Zejeeƒ ƒd�dd„ ƒZdd„ Z	d	S )
ÚArgSignatureTestaË  test that all visit_XYZ() in :class:`_sql.Compiler` subclasses have
    ``**kw``, for #8988.

    This test uses runtime code inspection.   Does not need to be a
    ``__backend__`` test as it only needs to run once provided all target
    dialects have been imported.

    For third party dialects, the suite would be run with that third
    party as a "--dburi", which means its compiler classes will have been
    imported by the time this test runs.

    c                  c   sR   t jD ]} |  d¡st d|  ¡ qtg}|rN| d¡}| | ¡ ¡ |V  q*d S )NÚ_zsqlalchemy.dialects.%sr   )	r   Ú__all__Ú
startswithÚ	importlibÚimport_moduler   ÚpopÚextendÚ__subclasses__)ÚdÚstackÚclsr)   r)   r*   Ú_all_subclassesA   s    


z ArgSignatureTest._all_subclasses)Úparamsc                 c   s   |j V  d S r!   )Úparam)r'   Úrequestr)   r)   r*   Úall_subclassesM   s    zArgSignatureTest.all_subclassesc                 C   sL   |}|j D ]<}| d¡r
t||ƒ}t|ƒ}t|jd|j› d|› d�ƒ q
d S )NÚvisit_zCompiler visit method Ú.z:() does not accommodate for **kw in its argument signature)Ú__dict__r3   Úgetattrr   r
   Úvarkwr,   )r'   r@   r;   ÚkÚmethZinspr)   r)   r*   Ú test_all_visit_methods_accept_kwQ   s    


þz1ArgSignatureTest.test_all_visit_methods_accept_kwN)
r,   r-   r.   Ú__doc__r<   r   ÚfixtureÚlistr@   rH   r)   r)   r)   r*   r0   3   s
   
r0   c                   @   s:   e Zd ZdZdZdZedd„ ƒZej	dd„ ƒZ
dd	„ Zd
S )ÚExceptionTestz¶Test basic exception wrapping.

    DBAPIs vary a lot in exception behavior so to actually anticipate
    specific exceptions from real round trips, we need to be conservative.

    ÚeachTc              	   C   s(   t d|tdtddd�tdtdƒƒƒ d S )NÚ	manual_pkÚidTF©Úprimary_keyZautoincrementÚdataé2   ©r   r   r   r   ©r;   Úmetadatar)   r)   r*   Údefine_tablesl   s    üzExceptionTest.define_tablesc                 C   sx   t j ¡ �Z}| ¡ }| | jj ¡ dddœ¡ tt	j
|j| jj ¡ dddœƒ | ¡  W d   ƒ n1 sj0    Y  d S )Nr   Úd1©rO   rR   )r   r"   r#   ÚbeginÚexecuteÚtablesrN   Úinsertr   r   ZIntegrityErrorÚrollback)r'   r(   Útransr)   r)   r*   Útest_integrity_erroru   s    ÿ
üz"ExceptionTest.test_integrity_errorc                 C   s    t j ¡ �‚}z| ttdƒƒ¡ ds(J ‚W nD tjyn } z*t|ƒ}t|j	ƒt|ƒv sZJ ‚W Y d }~n
d }~0 0 t
|tƒs~J ‚W d   ƒ n1 s’0    Y  d S )Nu   mÃ©ilF)r   r"   r#   r[   r   r   r   Ú
DBAPIErrorÚstrÚorigÚ
isinstance)r'   r(   ÚerrÚerr_strr)   r)   r*   Útest_exception_with_non_ascii†   s    ,z+ExceptionTest.test_exception_with_non_asciiN)r,   r-   r.   rI   Úrun_deletesr/   ÚclassmethodrW   r   Z$duplicate_key_raises_integrity_errorr`   rg   r)   r)   r)   r*   rL   `   s   

rL   c                   @   sl   e Zd ZdZdZdd„ Zdd„ Zdd„ Zd	d
„ Ze	j
jdd„ ƒZe	j
je	j
jdd„ ƒƒZe	j
jdd„ ƒZdS )ÚIsolationLevelTestT©Úisolation_levelc                 C   sF   t  t¡}|d }|d }t|ƒ d|g¡}|r8| ¡ S t d¡ d S )NÚdefaultÚ	supportedÚ
AUTOCOMMITz(no non-default isolation level available)r   Úget_isolation_levelsr   ÚsetÚ
differencer6   Z	skip_test)r'   Úlevelsrm   rn   Úsr)   r)   r*   Ú _get_non_default_isolation_level�   s    
z3IsolationLevelTest._get_non_default_isolation_levelc                 C   s   t tjjjt t¡d ƒ d S )Nrm   )r   r   r"   r$   Zdefault_isolation_levelr   rp   )r'   r)   r)   r*   Útest_default_isolation_level©   s    þz/IsolationLevelTest.test_default_isolation_levelc                 C   s€   |   ¡ }tj ¡ �Z}| ¡ }t||ƒ |j|d� t| ¡ |ƒ |j 	|j
j¡ t| ¡ |ƒ W d   ƒ n1 sr0    Y  d S )Nrk   )ru   r   r"   r#   Úget_isolation_levelr   Úexecution_optionsr   r$   Úreset_isolation_levelr%   r&   )r'   Znon_defaultr(   Úexistingr)   r)   r*   Ú test_non_default_isolation_level¯   s    
ÿz3IsolationLevelTest.test_non_default_isolation_levelc              	   C   sÊ   t  t¡}|d }t|ƒ dg¡D ]¢}tj ¡ �H}|j|d� t| 	¡ |ƒ | 
¡ }| ¡  t| 	¡ |ƒ W d   ƒ n1 s~0    Y  tj ¡ �"}t| 	¡ |d ƒ W d   ƒ q"1 sº0    Y  q"d S )Nrn   ro   rk   rm   )r   rp   r   rq   rr   r"   r#   rx   r   rw   rZ   r^   )r'   rs   Z
all_levelsÚlevelr(   r_   r)   r)   r*   Útest_all_levelsÁ   s    
,þz"IsolationLevelTest.test_all_levelsc              
   C   s^   |}t tjdd|jjd t t¡d ¡f ƒ� |j	dd� W d  ƒ n1 sP0    Y  dS )z4test for the new get_isolation_level_values() methodúNInvalid value '%s' for isolation_level. Valid isolation levels for '%s' are %sÚFOOú, rn   rk   N)
r   r   ÚArgumentErrorr$   ÚnameÚjoinr   rp   r   rx   )r'   Úconnection_no_transr%   r)   r)   r*   Ú#test_invalid_level_execution_option×   s    ÿýþþz6IsolationLevelTest.test_invalid_level_execution_optionc              
   C   sf   |t dd�d�}ttjdd|jjd t t	¡d ¡f ƒ� | 
¡  W d  ƒ n1 sX0    Y  dS )z…test for the new get_isolation_level_values() method
        and support for the dialect-level 'isolation_level' parameter.

        r   rk   ©Úoptionsr~   r€   rn   N)Údictr   r   r�   r$   r‚   rƒ   r   rp   r   r#   )r'   Útesting_engineÚengr)   r)   r*   Útest_invalid_level_engine_paramê   s    ÿýþþz2IsolationLevelTest.test_invalid_level_engine_paramc                 C   sð   t  t¡}|d }tt|d ƒ |dg¡ƒd }|d|id�}| ¡ �}t| ¡ |ƒ W d   ƒ n1 sj0    Y  | ¡ �*}|j	|d� t| ¡ |ƒ W d   ƒ n1 s¬0    Y  | ¡ �}t| ¡ |ƒ W d   ƒ n1 sâ0    Y  d S )Nrm   rn   ro   r   rl   r†   rk   )
r   rp   r   Úsortedrq   rr   r#   r   rw   rx   )r'   r‰   rs   rm   rn   Úer(   r)   r)   r*   Ú%test_dialect_user_setting_is_restored  s    
ÿü
,
,
z8IsolationLevelTest.test_dialect_user_setting_is_restoredN)r,   r-   r.   r/   Ú__requires__ru   rv   r{   r}   r   ÚrequiresZget_isolation_level_valuesr…   Z#dialect_level_isolation_level_paramr‹   Ú independent_readonly_connectionsrŽ   r)   r)   r)   r*   rj   ˜   s   
rj   c                   @   s–   e Zd ZdZdZdZedd„ ƒZddd„Zd	d
„ Z	dd„ Z
dd„ Zejje dg d¢¡e dddg¡dd„ ƒƒƒZejje dddg¡dd„ ƒƒZdS )ÚAutocommitIsolationTestrM   )Ú
autocommitTc              	   C   s,   t d|tdtddd�tdtdƒƒdd� d S )	NÚ
some_tablerO   TFrP   rR   rS   )Ztest_needs_acidrT   rU   r)   r)   r*   rW     s    ûz%AutocommitIsolationTest.define_tablesFc                 C   s²   |r| j jj|dd� | ¡  | ¡ }| | j j ¡ dddœ¡ | ¡  t| 	t
| j jjjƒ¡|rfdnd ƒ | ¡  | ¡ �" | | j j ¡ ¡ W d   ƒ n1 s¤0    Y  d S )NT)Z
checkfirstr   z	some datarY   )r\   r”   ÚcreateÚcommitrZ   r[   r]   r^   r   Úscalarr   ÚcrO   Údelete)r'   r(   r“   Úensure_tabler_   r)   r)   r*   Ú_test_conn_autocommits)  s    ÿ
þ
z.AutocommitIsolationTest._test_conn_autocommitsc                 C   s<   |}|j dd�}|  |d¡ |j |jj¡ |  |d¡ d S )Nro   rk   TF)rx   r›   r$   ry   r%   r&   )r'   r„   r(   Úc2r)   r)   r*   Útest_autocommit_on=  s
    z*AutocommitIsolationTest.test_autocommit_onc                 C   s   |}|   |d¡ d S )NF)r›   ©r'   r„   r(   r)   r)   r*   Útest_autocommit_offF  s    z+AutocommitIsolationTest.test_autocommit_offc                 C   sB   |}|j dd�}|  |d¡ |j t t¡d d� |  |d¡ d S )Nro   rk   Trm   F)rx   r›   r   rp   r   rž   r)   r)   r*   Ú.test_turn_autocommit_off_via_default_iso_levelJ  s    ÿÿzFAutocommitIsolationTest.test_turn_autocommit_off_via_default_iso_levelÚautocommit_setting)ÚfalseÚengineÚoptionÚblock_rollbackc                 C   sÌ   i }t |ƒrd|d< |jr"d|d< ||d�}| ¡ }|jrF|jdd� | j||jpV|jdd� tjj|j	d|j	j
d	��}| ¡  W d   ƒ n1 s”0    Y  |js¨|s¼t|jt ¡ gƒ nt|jg ƒ d S )
NTÚskip_autocommit_rollbackro   rl   r†   rk   )rš   r^   )Úwraps)Úboolr£   r#   r¤   rx   r›   r   ÚpatchÚobjectr%   r^   Úcloser¢   r   Z
mock_callsÚcall)r'   r‰   r¡   r¥   Úkwr£   r(   Zcheck_rollbackr)   r)   r*   Útest_autocommit_blockX  s,    

ýÿ&
z-AutocommitIsolationTest.test_autocommit_blockÚuse_dialect_settingc                 C   sà   |r|ddid�}n|ƒ j dd�}t t¡}|d }| ¡ �}|  |d¡ W d  ƒ n1 s^0    Y  | ¡ �(}|j |d� |  |d¡ W d  ƒ n1 sž0    Y  | ¡ �}|  |d¡ W d  ƒ n1 sÒ0    Y  dS )	ztest #10147rl   ro   r†   rk   rm   TNF)rx   r   rp   r   r#   r›   )r'   r‰   r¯   r�   rs   rm   r(   r)   r)   r*   Ú#test_dialect_autocommit_is_restoredw  s    ÿ

*
*
z;AutocommitIsolationTest.test_dialect_autocommit_is_restoredN)F)r,   r-   r.   rh   r�   r/   ri   rW   r›   r�   rŸ   r    r   r�   r¦   Z	variationr®   r‘   r°   r)   r)   r)   r*   r’     s    
	
	r’   c                   @   s   e Zd Zedd„ ƒZdS )ÚEscapingTestc              	   C   sÖ   | j }td|tdtdƒƒƒ}| tj¡ tj ¡ ��}| | 	¡ t
dd�¡ | | 	¡ t
dd�¡ t| t|jjƒ |jjtdƒk¡¡dƒ t| t|jjƒ |jjtdƒk¡¡dƒ W d	  ƒ n1 sÈ0    Y  d	S )
z|test that the DBAPI accommodates for escaped / nonescaped
        percent signs in a way that matches the compiler

        ÚtrR   rS   zsome % value)rR   zsome %% other valuez'some % value'z'some %% other value'N)rV   r   r   r   r•   r   r"   rZ   r[   r]   rˆ   r   r—   r   r˜   rR   Úwherer   )r'   Úmr²   r(   r)   r)   r*   Útest_percent_sign_round_trip•  s,    ÿÿú	ÿÿúz)EscapingTest.test_percent_sign_round_tripN)r,   r-   r.   r   rµ   r)   r)   r)   r*   r±   ”  s   r±   c                   @   s4   e Zd ZdZdZdd„ Zdd„ Zdd„ Zd	d
„ ZdS )Ú WeCanSetDefaultSchemaWEventsTestT)Zdefault_schema_name_switchc                 C   sL   t jjj}t ¡ }| ¡ � W d   ƒ n1 s00    Y  t|jj|ƒ d S r!   )r   r"   r$   Údefault_schema_namer   r‰   r#   r   )r'   r·   rŠ   r)   r)   r*   Útest_control_caseº  s
    

z2WeCanSetDefaultSchemaWEventsTest.test_control_casec                 C   sx   t jjj}t ¡ }t |d¡dd„ ƒ}| ¡ �(}|j 	|¡}t
|t jƒ W d   ƒ n1 s\0    Y  t
|jj|ƒ d S )Nr#   c                 S   s   t t| tjƒ d S r!   ©r   r   Útest_schema©r&   Zconnection_recordr)   r)   r*   Ú
on_connectÈ  s    ÿzMWeCanSetDefaultSchemaWEventsTest.test_wont_work_wo_insert.<locals>.on_connect)r   r"   r$   r·   r   r‰   r   Úlistens_forr#   Ú_get_default_schema_namer   rº   )r'   r·   rŠ   r¼   r(   Úwhat_it_should_ber)   r)   r*   Útest_wont_work_wo_insertÃ  s    



*z9WeCanSetDefaultSchemaWEventsTest.test_wont_work_wo_insertc                 C   st   t  ¡ }tj|ddd�dd„ ƒ}| ¡ �(}|j |¡}t|tj	ƒ W d   ƒ n1 sV0    Y  t|jj
tj	ƒ d S )Nr#   T©r]   c                 S   s   t t| tjƒ d S r!   r¹   r»   r)   r)   r*   r¼   ×  s    ÿzRWeCanSetDefaultSchemaWEventsTest.test_schema_change_on_connect.<locals>.on_connect)r   r‰   r   r½   r#   r$   r¾   r   r   rº   r·   )r'   rŠ   r¼   r(   r¿   r)   r)   r*   Útest_schema_change_on_connectÔ  s    

*z>WeCanSetDefaultSchemaWEventsTest.test_schema_change_on_connectc                 C   sœ   t  ¡ }tj|ddd�dd„ ƒ}| ¡ �P}| ¡ }|j |¡}t|t	j
ƒ | ¡  |j |¡}t|t	j
ƒ W d   ƒ n1 s~0    Y  t|jjt	j
ƒ d S )Nr#   TrÁ   c                 W   s   t t| tjƒ d S r!   r¹   )r&   Úargr)   r)   r*   r¼   æ  s    ÿz\WeCanSetDefaultSchemaWEventsTest.test_schema_change_works_w_transactions.<locals>.on_connect)r   r‰   r   r½   r#   rZ   r$   r¾   r   r   rº   r^   r·   )r'   rŠ   r¼   r(   r_   r¿   r)   r)   r*   Ú'test_schema_change_works_w_transactionsã  s    

*zHWeCanSetDefaultSchemaWEventsTest.test_schema_change_works_w_transactionsN)	r,   r-   r.   r/   r�   r¸   rÀ   rÂ   rÄ   r)   r)   r)   r*   r¶   µ  s   	r¶   c                   @   s   e Zd ZdS )Ú&FutureWeCanSetDefaultSchemaWEventsTestN)r,   r-   r.   r)   r)   r)   r*   rÅ   ø  s   rÅ   c                   @   s€   e Zd ZdZejdddddddd	d
dddddddddddddd�Zeejj	dd„ ƒƒZ
ejdd„ ƒZedd„ ƒZedd „ ƒZd!S )"ÚDifficultParametersTestT)Zboring)zper cent)z
per % cent)z%percent)zpar(ens))zpercent%(ens)yah)zcol:ons)Z_starts_with_underscore)zdot.s)zmore :: %colons%)Ú_name)Z___name)z[BracketsAndCase])Z	42numbers)zpercent%signs)z
has spaces)z	/slashes/)zmore/slashes)zq?marks)Z1param)z1col:onÚ	paramname)Úargnamesc              	   C   sú   |}t d|tdtdd�t|tdƒdd�ƒ}| |¡ | | ¡  dd|d	i¡¡ t|j	| ƒ 
|j	| d	k¡}t| |¡d	ƒ t|j	| ƒ 
|j	| t|ƒk¡}| ||d	i¡ ¡ }t|j| d	ƒ t|j	| ƒ 
|j	|  d	d
g¡¡}| |¡ ¡  d S )Nr²   rO   T)rQ   rS   F)Znullabler   z	some namezsome other_name)r   r   r   r   r•   r[   r]   Úvaluesr   r˜   r³   r   r—   r   ÚfirstÚ_mappingÚin_)r'   rÈ   r%   rV   r‚   r²   ÚstmtÚrowr)   r)   r*   Ú!test_round_trip_same_named_column  s$    ü
"ÿz9DifficultParametersTest.test_round_trip_same_named_columnc              
   c   sv   t d|tdtƒtdtdƒƒtdtdƒƒƒ}| |¡ | | ¡ dddd	œd
ddd	œdddd	œdddd	œg¡ |V  d S )NÚmytableÚmyidr‚   rS   Údescr   ÚaZa_desc)rÒ   r‚   rÓ   r   ÚbZb_descr   r˜   Zc_descé   r9   Zd_desc)r   r   r   r   r•   r[   r]   )r'   rV   r%   rÑ   r)   r)   r*   Úmultirow_fixtureB  s"    û




üþ	z(DifficultParametersTest.multirow_fixturec                 C   sD   |}t |jjƒ |jjt|dd�k¡}| ||di¡}t|dƒ d S )NÚx©Úvaluer˜   r   )r   r˜   rÒ   r³   r‚   r   r—   r   ©r'   rÈ   r%   r×   Ztbl1rÎ   Úresr)   r)   r*   Ú test_standalone_bindparam_escapeY  s    ÿz8DifficultParametersTest.test_standalone_bindparam_escapec                 C   s`   |}t |jjƒ |jj t|ddgd�¡¡ |jj¡}| ||ddgi¡ 	¡ }t
|ddgƒ d S )NrÔ   rÕ   rÙ   r9   r   rÖ   )r   r˜   rÒ   r³   r‚   rÍ   r   Zorder_byZscalarsÚallr   rÛ   r)   r)   r*   Ú*test_standalone_bindparam_escape_expandingd  s    ÿþÿzBDifficultParametersTest.test_standalone_bindparam_escape_expandingN)r,   r-   r.   r/   r   ÚcombinationsZtough_parametersr   r   Zunusual_column_name_charactersrÐ   rJ   r×   rÝ   rß   r)   r)   r)   r*   rÆ   þ  sD   ê&


rÆ   c                   @   sf   e Zd ZdZdZedd„ ƒZejdd„ ƒZ	dd„ Z
d	d
„ Zejjdd„ ƒZdd„ Zdd„ Zdd„ ZdS )ÚReturningGuardsTestz=test that the various 'returning' flags are set appropriatelyTc              	   C   s(   t d|tdtddd�tdtdƒƒƒ d S )Nr²   rO   TFrP   rR   rS   rT   rU   r)   r)   r*   rW   x  s    üz!ReturningGuardsTest.define_tablesc                    s   | j j‰‡ ‡fdd„}|S )Nc              
      s0  |   ˆjj¡} |rÂ|s„ttjdˆ jj› dˆ jj› d�ƒ�: ˆ  	| |dddi|dddi|d	dd
ig¡ W d   ƒ qÀ1 sx0    Y  n<ˆ  	| |dddi|dddi|d	dd
ig¡}t
| ¡ g d¢ƒ nj|�sttjƒ�$ ˆ  	| |dddi¡ W d   ƒ n1 sü0    Y  n$ˆ  	| |dddi¡}t
| ¡ dgƒ d S )NzDialect z\+zW with current server capabilities does not support .*RETURNING when executemany is usedr   rR   rX   r   Úd2r   Úd3)©r   )r   )r   rä   )Z	returningr˜   rO   r   r   ZStatementErrorr$   r‚   Zdriverr[   r   rÞ   r   ra   )rÎ   ZexecutemanyZid_param_nameZexpect_successÚresult©r%   r²   r)   r*   Úgo…  sB    ÿþ


ýþ$	


ýþÿ$ÿz(ReturningGuardsTest.run_stmt.<locals>.go)r\   r²   )r'   r%   rç   r)   ræ   r*   Úrun_stmt�  s    /zReturningGuardsTest.run_stmtc                 C   s&   | j j}| ¡ }||dd|jjƒ d S )NFrO   )r\   r²   r]   r$   Zinsert_returning©r'   r%   rè   r²   rÎ   r)   r)   r*   Útest_insert_single¶  s    z&ReturningGuardsTest.test_insert_singlec                 C   s&   | j j}| ¡ }||dd|jjƒ d S )NTrO   )r\   r²   r]   r$   Zinsert_executemany_returningré   r)   r)   r*   Útest_insert_many½  s
    ÿz$ReturningGuardsTest.test_insert_manyc                 C   s`   | j j}| | ¡ dddœdddœdddœg¡ | ¡  |jjtdƒk¡}||d	d|j	j
ƒ d S ©
Nr   rX   rY   r   râ   r   rã   Úb_idF)r\   r²   r[   r]   Úupdater³   r˜   rO   r   r$   Zupdate_returningré   r)   r)   r*   Útest_update_singleÆ  s    ýþ	z&ReturningGuardsTest.test_update_singlec                 C   s`   | j j}| | ¡ dddœdddœdddœg¡ | ¡  |jjtdƒk¡}||d	d|j	j
ƒ d S ©
Nr   rX   rY   r   râ   r   rã   rí   T)r\   r²   r[   r]   rî   r³   r˜   rO   r   r$   Zupdate_executemany_returningré   r)   r)   r*   Útest_update_many×  s    ýþ	ÿz$ReturningGuardsTest.test_update_manyc                 C   s`   | j j}| | ¡ dddœdddœdddœg¡ | ¡  |jjtdƒk¡}||d	d|j	j
ƒ d S rì   )r\   r²   r[   r]   r™   r³   r˜   rO   r   r$   Zdelete_returningré   r)   r)   r*   Útest_delete_singleé  s    ýþ	z&ReturningGuardsTest.test_delete_singlec                 C   s`   | j j}| | ¡ dddœdddœdddœg¡ | ¡  |jjtdƒk¡}||d	d|j	j
ƒ d S rð   )r\   r²   r[   r]   r™   r³   r˜   rO   r   r$   Zdelete_executemany_returningré   r)   r)   r*   Útest_delete_manyù  s    ýþ	ÿz$ReturningGuardsTest.test_delete_manyN)r,   r-   r.   rI   r/   ri   rW   r   rJ   rè   rê   rë   r�   Z&update_returning_dialect_not_supportedrï   rñ   rò   ró   r)   r)   r)   r*   rá   s  s   

4	
rá   )/r4   Ú r   r   r   r   r   r	   r
   r   r   r   r   Z
assertionsr   r   r   Z	provisionr   Zschemar   r   r   r   r   r   r   r   r   r   Zsql.compilerr   Úutilr   ZTestBaser    r0   Z
TablesTestrL   rj   r’   r±   r¶   ZFutureEngineMixinrÅ   rÆ   rá   r)   r)   r)   r*   Ú<module>
   sP   
-8 |!C
ÿu