
    ,h                         S SK Jr  S SKJr  S SKJr  S SKJr  SSK Jr  SSK Jr  SSK J	r	   " S	 S
\R                  5      rSrg)   )fixtures)eq_)Column)Table   )Integer)String)testingc                      \ rS rSrSrSrSr\S 5       r\S 5       r	S r
S r\R                  " S	/ S
Q5      \R                  R                  S 5       5       r\R                  " S	/ S
Q5      \R                  R"                  S 5       5       rSrg)SimpleUpdateDeleteTest   each)sane_rowcountTc                 `    [        SU[        S[        SS9[        S[        S5      5      5        g )Nplain_pkidT)primary_keydata2   )r   r   r   r	   )clsmetadatas     c/var/www/auris/envauris/lib/python3.13/site-packages/sqlalchemy/testing/suite/test_update_delete.pydefine_tables$SimpleUpdateDeleteTest.define_tables   s*    4d366":&		
    c                     UR                  U R                  R                  R                  5       SSS.SSS.SSS./5        g )N   d1)r   r   r   d2r   d3)executetablesr   insert)r   
connections     r   insert_data"SimpleUpdateDeleteTest.insert_data    sC    JJ&&($'$'$'	
r   c                    U R                   R                  nUR                  UR                  5       R	                  UR
                  R                  S:H  5      [        SS95      nUR                  (       a   eUR                  (       a   eUR                  S:X  d   e[        UR                  UR                  5       R                  UR
                  R                  5      5      R                  5       / SQ5        g )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_update"SimpleUpdateDeleteTest.test_update+   s    KK  HHJQSSVVq[)4X+>
 ;;>>!!zzQqxxz2213366:;DDF1	
r   c                    U R                   R                  nUR                  UR                  5       R	                  UR
                  R                  S:H  5      5      nUR                  (       a   eUR                  (       a   eUR                  S:X  d   e[        UR                  UR                  5       R                  UR
                  R                  5      5      R                  5       SS/5        g )Nr   r   r+   r-   )r"   r   r!   deleter/   r0   r   r2   r3   r4   r   r5   r6   r7   r8   s       r   test_delete"SimpleUpdateDeleteTest.test_delete9   s    KK  qxxz//!<=;;>>!!zzQqxxz2213366:;DDF	"	
r   criteria)rowsnorowsemptyinc                    U R                   R                  nUR                  5       R                  UR                  R
                  UR                  R                  5      nUR                  (       a)  UR                  UR                  R
                  S:H  5      nOUR                  (       a)  UR                  UR                  R
                  S:H  5      nOVUR                  (       a5  UR                  UR                  R
                  R                  / 5      5      nOUR                  5         UR                  U[        SS95      nUR                  (       a   eUR                   (       d   e[#        UR%                  5       SS/5        UR                  (       a  [#        UR'                  5       S/5        O[#        UR'                  5       / 5        [#        UR                  UR)                  5       R+                  UR                  R
                  5      5      R-                  5       UR                  (       a	  / SQ5        g / S	Q5        g )
N
   r   r(   r)   r   r   r,   r*   r+   r   r   r-   )r"   r   r.   	returningr0   r   r   rD   r/   rC   rE   in_failr!   r1   r2   r3   r   keysallr5   r6   r7   r9   r$   rB   r:   stmtr;   s         r   test_update_returning,SimpleUpdateDeleteTest.test_update_returningD   si    KK  xxz##ACCFFACCHH5??::accffl+D]]::accffk*D::accffjjn-DMMOtTx%89;;~~~AFFHtVn%==-)qxxz2213366:;DDF == 6	

 7	
r   c                 t   U R                   R                  nUR                  5       R                  UR                  R
                  UR                  R                  5      nUR                  (       a)  UR                  UR                  R
                  S:H  5      nOUR                  (       a)  UR                  UR                  R
                  S:H  5      nOVUR                  (       a5  UR                  UR                  R
                  R                  / 5      5      nOUR                  5         UR                  U5      nUR                  (       a   eUR                  (       d   e[!        UR#                  5       SS/5        UR                  (       a  [!        UR%                  5       S/5        O[!        UR%                  5       / 5        [!        UR                  UR'                  5       R)                  UR                  R
                  5      5      R+                  5       UR                  (       a	  SS/5        g / SQ5        g )	NrG   r   r   r   rI   r+   r-   rH   )r"   r   r?   rJ   r0   r   r   rD   r/   rC   rE   rK   rL   r!   r2   r3   r   rM   rN   r5   r6   r7   rO   s         r   test_delete_returning,SimpleUpdateDeleteTest.test_delete_returningg   sg    KK  xxz##ACCFFACCHH5??::accffl+D]]::accffk*D::accffjjn-DMMOt$;;~~~AFFHtVn%==)%qxxz2213366:;DDF == I&	

 7	
r    N)__name__
__module____qualname____firstlineno__run_deletes__requires____backend__classmethodr   r%   r<   r@   r
   	variationrequiresupdate_returningrQ   delete_returningrT   __static_attributes__rV   r   r   r   r      s    K%LK
 
 
 

	
 z#@A&&
 ' B
B z#@A&&
 ' B
r   r   )r   N) r   
assertionsr   schemar   r   r   r	   r
   
TablesTestr   __all__rV   r   r   <module>ri      s8          v
X00 v
r &r   