
    -hY                     z    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)Stringc                   L    \ rS rSrSrSrSr\S 5       r\S 5       r	S r
S 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:\Users\ROHAN GUPTA\OneDrive\Desktop\mathbuddy-assessment\venv\Lib\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+   r,   r   r.   r/   r0   r   r1   r2   r3   r4   s       r   test_delete"SimpleUpdateDeleteTest.test_delete6   s    KK  qxxz//!<=;;>>!!zzQqxxz2213366:;DDF	"	
r    N)__name__
__module____qualname____firstlineno__run_deletes__requires____backend__classmethodr   r$   r8   r<   __static_attributes__r>   r   r   r   r      sA    K%LK
 
 
 

	
r   r   )r   N) r   
assertionsr   schemar   r   r   r	   
TablesTestr   __all__r>   r   r   <module>rM      s3         0
X00 0
f &r   