a
    xˆc  ã                   @   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 G dd„ dejƒZdS )é    )Ú	bindparam)ÚColumn)ÚInteger)Ú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	d
d„ Z
dd„ Zejj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   úi/home/yuhw/wc/wire-cell-python/wcpy/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>3   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_basic9   s    ÿþzRowCountTest.test_basicc                 C   s@   | j j}|jj}| | ¡  |dk¡ddi¡}|jdks<J ‚d S )Nr   r   ÚZé   )r#   r   r*   r   r$   ÚupdateÚwhereÚrowcount©r+   r'   r(   r   Úrr   r   r   Útest_update_rowcount1B   s    þz"RowCountTest.test_update_rowcount1c                 C   s>   | j j}|jj}| | ¡  |dk¡ddi¡}t|jdƒ d S )Nr   r   r0   )	r#   r   r*   r   r$   r1   r2   r
   r3   r4   r   r   r   Útest_update_rowcount2M   s    þz"RowCountTest.test_update_rowcount2c                 C   sP   | j j}|jj}| ¡  |dk¡j|jjd d� ¡ }| |¡}t	|j
dƒ d S )Nr   r/   )r   r0   )r#   r   r*   r   r1   r2   ÚvaluesZreturn_defaultsr$   r
   r3   )r+   r'   r(   r   Ústmtr5   r   r   r   Ú$test_update_rowcount_return_defaultsY   s    ÿ
þÿ
z1RowCountTest.test_update_rowcount_return_defaultsc                 C   s   |  d¡}t|jdƒ d S ©Nz8update employees set department='Z' where department='C'r0   )Zexec_driver_sqlr
   r3   ©r+   r'   Úresultr   r   r   Útest_raw_sql_rowcounth   s    ÿz"RowCountTest.test_raw_sql_rowcountc                 C   s   |  tdƒ¡}t|jdƒ d S r;   )r$   r	   r
   r3   r<   r   r   r   Útest_text_rowcounto   s    ÿzRowCountTest.test_text_rowcountc                 C   s8   | j j}|jj}| | ¡  |dk¡¡}t|jdƒ d S )Nr   r0   )	r#   r   r*   r   r$   Údeleter2   r
   r3   r4   r   r   r   Útest_delete_rowcountv   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   r1   r2   r*   r   r   r8   r$   r
   r3   ©r+   r'   r(   r9   r5   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 )NrB   r   r   rC   rD   )
r#   r   r@   r2   r*   r   r   r$   r
   r3   rE   r   r   r   Útest_multi_delete_rowcount”   s    ÿýþ	z'RowCountTest.test_multi_delete_rowcountN)Ú__name__Ú
__module__Ú__qualname__Ú__doc__Ú__requires__Z__backend__Úclassmethodr   r)   r.   r6   r7   r   ÚrequiresZsane_rowcount_w_returningr:   r>   r?   rA   Zsane_multi_rowcountrF   rG   r   r   r   r   r      s&   

	


r   N)Z
sqlalchemyr   r   r   r   r   r   r   r	   Zsqlalchemy.testingr
   r   Z
TablesTestr   r   r   r   r   Ú<module>   s   