
    [h                         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
ej
                  ZdZdS )   )fixtures)eq_)Column)Table   )Integer)String)testingc                   
   e Zd ZdZdZdZed             Zed             Zd Z	d Z
 ej        dg d	          ej        j        d
                         Z ej        dg d	          ej        j        d                         ZdS )SimpleUpdateDeleteTesteach)sane_rowcountTc                     t          d|t          dt          d          t          dt          d                               d S )Nplain_pkidT)primary_keydata2   )r   r   r   r	   )clsmetadatas     z/var/www/api.easyaligner.net/htdocs/venv_linux/lib/python3.11/site-packages/sqlalchemy/testing/suite/test_update_delete.pydefine_tablesz$SimpleUpdateDeleteTest.define_tables   sI    4d33366"::&&		
 	
 	
 	
 	
    c                     |                     | j        j                                        dddddddddg           d S )N   d1)r   r   r   d2r   d3)executetablesr   insert)r   
connections     r   insert_dataz"SimpleUpdateDeleteTest.insert_data    s^    J&&(($''$''$''	
 	
 	
 	
 	
r   c                    | j         j        }|                    |                                                    |j        j        dk              t          d                    }|j        rJ |j	        rJ |j
        dk    sJ t          |                    |                                                    |j        j                                                            g d           d S )Nr   d2_newr   r   r   r   r   r%   r   r   )r    r   r   updatewherecr   dict	is_insertreturns_rowsrowcountr   selectorder_byfetchallselfr"   trs       r   test_updatez"SimpleUpdateDeleteTest.test_update+   s    K HHJJQSVq[))4X+>+>+>
 
 ;>!!!zQqxxzz22136::;;DDFF111	
 	
 	
 	
 	
r   c                    | j         j        }|                    |                                                    |j        j        dk                        }|j        rJ |j        rJ |j	        dk    sJ t          |                    |                                                    |j        j                                                            ddg           d S )Nr   r   r(   r*   )r    r   r   deleter,   r-   r   r/   r0   r1   r   r2   r3   r4   r5   s       r   test_deletez"SimpleUpdateDeleteTest.test_delete9   s    K qxxzz//!<<==;>!!!zQqxxzz22136::;;DDFF	"	
 	
 	
 	
 	
r   criteria)rowsnorowsemptyinc                    | j         j        }|                                                    |j        j        |j        j                  }|j        r$|                    |j        j        dk              }ny|j	        r$|                    |j        j        dk              }nN|j
        r3|                    |j        j                            g                     }n|                                 |                    |t          d                    }|j        rJ |j        sJ t#          |                                ddg           |j	        r$t#          |                                dg           n"t#          |                                g            t#          |                    |                                                    |j        j                                                            |j	        rg dng d	           d S )
N
   r   r%   r&   r   r   r)   r'   r(   r   r   r*   )r    r   r+   	returningr-   r   r   r?   r,   r>   r@   in_failr   r.   r/   r0   r   keysallr2   r3   r4   r6   r"   r=   r7   stmtr8   s         r   test_update_returningz,SimpleUpdateDeleteTest.test_update_returningD   s    K xxzz##ACFACH55? 	::acfl++DD] 	::acfk**DD 	::acfjjnn--DDMMOOOtTx%8%8%899;~AFFHHtVn%%%= 	-))))qxxzz22136::;;DDFF =75555666	
 	
 	
 	
 	
r   c                    | j         j        }|                                                    |j        j        |j        j                  }|j        r$|                    |j        j        dk              }ny|j	        r$|                    |j        j        dk              }nN|j
        r3|                    |j        j                            g                     }n|                                 |                    |          }|j        rJ |j        sJ t!          |                                ddg           |j	        r$t!          |                                dg           n"t!          |                                g            t!          |                    |                                                    |j        j                                                            |j	        rddgng d           d S )	NrB   r   r   r   rD   r(   r*   rC   )r    r   r;   rE   r-   r   r   r?   r,   r>   r@   rF   rG   r   r/   r0   r   rH   rI   r2   r3   r4   rJ   s         r   test_delete_returningz,SimpleUpdateDeleteTest.test_delete_returningg   s    K xxzz##ACFACH55? 	::acfl++DD] 	::acfk**DD 	::acfjjnn--DDMMOOOt$$;~AFFHHtVn%%%= 	)%%%%qxxzz22136::;;DDFF =7I&&666	
 	
 	
 	
 	
r   N)__name__
__module____qualname__run_deletes__requires____backend__classmethodr   r#   r9   r<   r
   	variationrequiresupdate_returningrL   delete_returningrN    r   r   r   r      s        K%LK
 
 [
 
 
 [

 
 
	
 	
 	
 Wz#@#@#@AA&
 
 '& BA
B Wz#@#@#@AA&
 
 '& BA
 
 
r   r   )r   N) r   
assertionsr   schemar   r   r   r	   r
   
TablesTestr   __all__rZ   r   r   <module>r`      s                                             v
 v
 v
 v
 v
X0 v
 v
 v
r &r   