a
    •˜ëjÜ  ã                   @   sš   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dS )é    )Ú	bindparam)ÚColumn)ÚInteger)ÚMetaData)Úselect)ÚString)ÚTable)Útesting)Útext)Úeq_)Úfixturesc                   @   sà   e Zd ZdZdZdZedd„ ƒZedd„ ƒZdd	„ Z	e
 d
g d¢¡e
 dddg¡dd„ ƒƒZdd„ Zdd„ Ze
 dddg¡e
 dde
jjfde
jjfg¡dd„ ƒƒZdd„ Zdd„ Zdd„ Ze
jjd d!„ ƒZe
jjd"d#„ ƒZd$S )%ÚRowCountTestztest rowcount functionality)Zsane_rowcountTc              	   C   s4   t d|tdtddd�tdtdƒƒtdtd	ƒƒƒ d S )
NÚ	employeesÚemployee_idFT©ZautoincrementZprimary_keyÚnameé2   Ú
departmenté   )r   r   r   r   )ÚclsÚmetadata© r   úe/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/sqlalchemy/testing/suite/test_rowcount.pyÚdefine_tables   s    üözRowCountTest.define_tablesc                 C   s8   g d¢ | _ }| jj}| | ¡ dd„ t|ƒD ƒ¡ d S )N)	)ZAngelaÚA)ZAndrewr   )ZAnandr   )ÚBobÚB)ZBobetter   )ZBuffyr   )ZCharlieÚC)ÚCynthiar   )ZChrisr   c                 S   s    g | ]\}\}}|||d œ‘qS )©r   r   r   r   )Ú.0ÚiÚnÚdr   r   r   Ú
<listcomp><   s   
ÿz,RowCountTest.insert_data.<locals>.<listcomp>)ÚdataÚtablesr   ÚexecuteÚinsertÚ	enumerate)r   Ú
connectionr%   Úemployees_tabler   r   r   Úinsert_data+   s    þþzRowCountTest.insert_datac                 C   sB   | j j}t|jj|jjƒ |jj¡}| |¡ 	¡ }t
|| jƒ d S )N)r&   r   r   Úcr   r   Zorder_byr   r'   Zfetchallr   r%   )Úselfr*   r+   ÚsÚrowsr   r   r   Ú
test_basicB   s    ÿþzRowCountTest.test_basicÚ	statement)ÚupdateÚdeleter(   r   Úclose_firstFc              	   C   sò   | j j}|jj}|jr6| | ¡  |dk¡ddi¡}nž|jr\| | ¡  |dk¡ddi¡}nx|jr’| | ¡ ddddœdd	ddœd
dddœg¡}nB|j	rÌt	|jj
|jjƒ |jjdk¡}| |¡}| ¡  n| ¡  |rà| ¡  |jdv sîJ ‚d S )Nr   r   ÚZé   znone 1ÚXr   é   znone 2é   znone 3)éÿÿÿÿé   )r&   r   r-   r   r3   r'   Úwherer4   r(   r   r   ÚallÚfailÚcloseÚrowcount)r.   r*   r2   r5   r+   r   Úrr/   r   r   r   Ú$test_non_rowcount_scenarios_no_raiseK   s@    þþ


ýþÿ
þ

z1RowCountTest.test_non_rowcount_scenarios_no_raisec                 C   s@   | j j}|jj}| | ¡  |dk¡ddi¡}|jdks<J ‚d S )Nr   r   r6   r<   )r&   r   r-   r   r'   r3   r=   rA   ©r.   r*   r+   r   rB   r   r   r   Útest_update_rowcount1v   s    þz"RowCountTest.test_update_rowcount1c                 C   s>   | j j}|jj}| | ¡  |dk¡ddi¡}t|jdƒ d S )Nr   r   r<   )	r&   r   r-   r   r'   r3   r=   r   rA   rD   r   r   r   Útest_update_rowcount2�   s    þz"RowCountTest.test_update_rowcount2Úimplicit_returningÚdmlr3   r4   c              	   C   sº   |r| j j}n6tdtƒ tdtddd�tdtdƒƒtdtd	ƒƒdd
�}|jj}|j	rz| 	¡  
|dk¡j|jjd d� ¡ }n&|jr˜| ¡  
|dk¡ ¡ }n| ¡  | |¡}t|jdƒ dS )zØnote this test should succeed for all RETURNING backends
        as of 2.0.  In
        Idf28379f8705e403a3c6a937f6a798a042ef2540 we changed rowcount to use
        len(rows) when we have implicit returning

        r   r   FTr   r   r   r   r   )rG   r   r6   )r   r<   N)r&   r   r   r   r   r   r   r-   r   r3   r=   ÚvaluesZreturn_defaultsr4   r?   r'   r   rA   )r.   r*   rG   rH   r+   r   ÚstmtrB   r   r   r   Ú+test_update_delete_rowcount_return_defaults�   s>    
üõÿ
þÿÿÿ
z8RowCountTest.test_update_delete_rowcount_return_defaultsc                 C   s   |  d¡}t|jdƒ d S ©Nz8update employees set department='Z' where department='C'r<   )Zexec_driver_sqlr   rA   ©r.   r*   Úresultr   r   r   Útest_raw_sql_rowcountÅ   s    ÿz"RowCountTest.test_raw_sql_rowcountc                 C   s   |  tdƒ¡}t|jdƒ d S rL   )r'   r
   r   rA   rM   r   r   r   Útest_text_rowcountÌ   s    ÿzRowCountTest.test_text_rowcountc                 C   s8   | j j}|jj}| | ¡  |dk¡¡}t|jdƒ d S )Nr   r<   )	r&   r   r-   r   r'   r4   r=   r   rA   rD   r   r   r   Útest_delete_rowcountÓ   s    ÿz!RowCountTest.test_delete_rowcountc                 C   sX   | j j}| ¡  |jjtdƒk¡jdd�}| |ddiddiddig¡}t	|j
dƒ d S )NÚemp_namer   )r   r   r   Únonexistenté   )r&   r   r3   r=   r-   r   r   rI   r'   r   rA   ©r.   r*   r+   rJ   rB   r   r   r   Útest_multi_update_rowcountÝ   s    ÿþÿýþ	z'RowCountTest.test_multi_update_rowcountc                 C   sP   | j j}| ¡  |jjtdƒk¡}| |ddiddiddig¡}t|j	dƒ d S )NrR   r   r   rS   rT   )
r&   r   r4   r=   r-   r   r   r'   r   rA   rU   r   r   r   Útest_multi_delete_rowcountñ   s    ÿýþ	z'RowCountTest.test_multi_delete_rowcountN)Ú__name__Ú
__module__Ú__qualname__Ú__doc__Ú__requires__Z__backend__Úclassmethodr   r,   r1   r	   Z	variationrC   rE   rF   ÚrequiresZupdate_returningZdelete_returningrK   rO   rP   rQ   Zsane_multi_rowcountrV   rW   r   r   r   r   r      s8   

	)

þþ0

r   N)Z
sqlalchemyr   r   r   r   r   r   r   r	   r
   Zsqlalchemy.testingr   r   Z
TablesTestr   r   r   r   r   Ú<module>	   s   