U
    x^                     @   sn   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ZdS )   )config)fixtures)eq_)Column)Table   )Integer)Stringc                   @   s<   e Zd ZdZdZedd Zedd Zdd Zd	d
 Z	dS )SimpleUpdateDeleteTestZeachTc                 C   s&   t d|tdtddtdtd d S )Nplain_pkidT)Zprimary_keydata2   )r   r   r   r	   )clsmetadata r   S/tmp/pip-install-dq5v43_d/SQLAlchemy/sqlalchemy/testing/suite/test_update_delete.pydefine_tables   s    z$SimpleUpdateDeleteTest.define_tablesc                 C   s2   t j| jj dddddddddg d S )N   d1)r   r   r   Zd2r   d3)r   dbexecutetablesr   insert)r   r   r   r   insert_data   s    
z"SimpleUpdateDeleteTest.insert_datac                 C   sl   | j j}tjj| |jjdkdd}|j	r4t
|jr>t
ttj| |jj dddg d S )Nr   d2_new)r   r   r   )r   r   r   r   )r   r   r   r   r   updatewherecr   	is_insertAssertionErrorreturns_rowsr   selectorder_byfetchallselftrr   r   r   test_update"   s    "

z"SimpleUpdateDeleteTest.test_updatec                 C   sf   | j j}tj| |jjdk}|j	r0t
|jr:t
ttj| |jj ddg d S )Nr   r   r   )r   r   r   r   r   deleter    r!   r   r"   r#   r$   r   r%   r&   r'   r(   r   r   r   test_delete-   s    

z"SimpleUpdateDeleteTest.test_deleteN)
__name__
__module____qualname__Zrun_deletesZ__backend__classmethodr   r   r,   r.   r   r   r   r   r
   
   s   


r
   )r
   N) r   r   Z
assertionsr   Zschemar   r   r   r	   Z
TablesTestr
   __all__r   r   r   r   <module>   s   .