
    g                         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
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\\5      r " S S\\5      r " S S\\5      rg)    )Column)ForeignKeyConstraint)Integer)MetaData)String)Table   )AutogenFixtureTest   )combinations)configeq_)mock)TestBasec                       \ rS rSrSrSrS rS rS rS r	S r
S	 r\R                  R                  S
 5       rS rS rSrg)AutogenerateForeignKeysTest   T)!foreign_key_constraint_reflectionc                 h   [        5       n[        5       n[        SU[        S[        S5      SS95        [        SU[        S[        SS9[        S[        S	5      S
S9[        S[        S5      SS9[        S[        S5      5      [        S/S/5      5        [        SU[        S[        S5      SS95        [        SU[        S[        SS9[        S[        S	5      S
S9[        S[        S5      SS9[        S[        S5      5      5        U R                  X5      nU R                  US   SSS/SS/SS9  g )N
some_tabletest
   Tprimary_keyuseridname2   Fnullablea1xserver_defaulttest2some_table.testr   	remove_fkservergeneratedconditional_namer   r   r   r   r   r   _fixture_assert_fk_diffselfm1m2diffss       n/Users/Alptekin/Desktop/izin_takip/venv/lib/python3.13/site-packages/alembic/testing/suite/test_autogen_fks.pytest_remove_fk*AutogenerateForeignKeysTest.test_remove_fk   s2   ZZ66":48	
 	4d366":64C87F2J' '->,?@	
 	66":48	
 	4d366":64C87F2J'	
 b%!HIH. 	 	
    c                    [        5       n[        5       n[        SU[        S[        SS9[        S[	        S5      5      5        [        SU[        S[        SS9[        S[	        S	5      S
S9[        S[	        S5      SS9[        S[	        S5      5      5        [        SU[        S[        SS9[        S[	        S5      5      5        [        SU[        S[        SS9[        S[	        S	5      S
S9[        S[	        S5      SS9[        S[	        S5      5      [        S/S/5      5        U R                  X5      nU R                  US   SSS/SS/5        g )Nr   r   Tr   r   r   r   r   r   Fr    r"   r#   r$   r&   r'   r   add_fk)r   r   r   r   r   r   r-   r.   r/   s       r4   test_add_fk'AutogenerateForeignKeysTest.test_add_fkC   s9   ZZ4d366":&		
 	4d366":64C87F2J'	
 	4d366":&		
 	4d366":64C87F2J' '->,?@	
 b%!Hh	<&	
r7   c                    [        5       n[        5       n[        SU[        S[        SS9[        S[	        S5      5      5        [        SU[        S[        SS9[        S[	        S	5      S
S9[        S[	        S5      SS9[        S[        5      [        S/S/5      5        [        SU[        S[        SS9[        S[	        S5      5      5        [        SU[        S[        SS9[        S[	        S	5      S
S9[        S[	        S5      SS9[        S[        5      [        S/S/5      5        U R                  X5      n[        U/ 5        g )Nr   r   Tr   r   r   r   r   r   Fr    r"   r#   r$   r&   some_table.id)r   r   r   r   r   r   r-   r   r/   s       r4   test_no_change*AutogenerateForeignKeysTest.test_no_changen   s%   ZZ4d366":&		
 	4d366":64C87G$ '_,=>	
 	4d366":&		
 	4d366":64C87G$ '_,=>	
 b%E2r7   c                 
   [        5       n[        5       n[        SU[        S[        S5      SS9[        S[        S5      SS95        [        SU[        S[        SS9[        S	[        S
5      SS9[        S[        S5      SS9[        S[        S5      5      [        S[        S5      5      [        SS/SS/5      5        [        SU[        S[        S5      SS9[        S[        S5      SS95        [        SU[        S[        SS9[        S	[        S
5      SS9[        S[        S5      SS9[        S[        S5      5      [        S[        S5      5      [        SS/SS/5      5        U R                  X5      n[        U/ 5        g )Nr   id_1r   Tr   id_2r   r   r   r   Fr    r"   r#   r$   
other_id_1
other_id_2some_table.id_1some_table.id_2r   r   r   r   r   r   r-   r   r/   s       r4   test_no_change_composite_fk7AutogenerateForeignKeysTest.test_no_change_composite_fk   si   ZZ66":4866":48		
 	4d366":64C8<,<, |,"$56	
 	66":4866":48		
 	4d366":64C8<,<, |,"$56	
 b%E2r7   c                    [        5       n[        5       n[        SU[        S[        S5      SS95        [        SU[        S[        SS9[        S[        S	5      S
S9[        S[        S5      SS9[        S[        S5      5      [        S/S/SS95        [        SU[        S[        S5      SS95        [        SU[        S[        SS9[        S[        S	5      S
S9[        S[        S5      SS9[        S[        S5      5      [        S/S/SS95        U R                  X5      nU R                  US   SSS/SS/[        R                  R                  R                  (       a  SOS S9  U R                  US   SSS/SS/SS9  g )Nr   r   r   Tr   r   r   r   r   Fr    r"   r#   r$   r&   r'   MyFKr   myfkr   r(   r	   r9   )r   r   r   r   r   r   r-   r.   r   requirementsfk_namesenabledr/   s       r4   1test_casing_convention_changed_so_put_drops_firstMAutogenerateForeignKeysTest.test_casing_convention_changed_so_put_drops_first   s   ZZ66":48	
 	4d366":64C87F2J' '->,?fM	
 	66":48	
 	4d366":64C87F2J' $*;)<6J	
 b%!HIH!..77??T 	 	
 	!HFH 	 	
r7   c                 
   [        5       n[        5       n[        SU[        S[        S5      SS9[        S[        S5      SS95        [        SU[        S[        SS9[        S	[        S
5      SS9[        S[        S5      SS9[        S[        S5      5      [        S[        S5      5      5        [        SU[        S[        S5      SS9[        S[        S5      SS95        [        SU[        S[        SS9[        S	[        S
5      SS9[        S[        S5      SS9[        S[        S5      5      [        S[        S5      5      [        SS/SS/SS95        U R                  X5      nU R                  US   SSSS/SSS/SS9  g )Nr   rA   r   Tr   rB   r   r   r   r   Fr    r"   r#   r$   rC   rD   rE   rF   fk_test_namerL   r   r9   r,   r/   s       r4   test_add_composite_fk_with_name;AutogenerateForeignKeysTest.test_add_composite_fk_with_name  s   ZZ66":4866":48		
 	4d366":64C8<,<,	
 	66":4866":48		
 	4d366":64C8<,<, |,"$56#	
 b%!H<(V 	 	
r7   c                 
   [        5       n[        5       n[        SU[        S[        S5      SS9[        S[        S5      SS95        [        SU[        S[        SS9[        S	[        S
5      SS9[        S[        S5      SS9[        S[        S5      5      [        S[        S5      5      [        SS/SS/SS95        [        SU[        S[        S5      SS9[        S[        S5      SS95        [        SU[        S[        SS9[        S	[        S
5      SS9[        S[        S5      SS9[        S[        S5      5      [        S[        S5      5      5        U R                  X5      nU R                  US   SSSS/SSS/SS9  g )Nr   rA   r   Tr   rB   r   r   r   r   Fr    r"   r#   r$   rC   rD   rE   rF   rT   rL   r   r(   r*   r,   r/   s       r4   test_remove_composite_fk4AutogenerateForeignKeysTest.test_remove_composite_fk=  s   ZZ66":4866":48		
 	4d366":64C8<,<, |,"$56#	
 	66":4866":48		
 	4d366":64C8<,<,	
 b%!H<(V+ 	 	
r7   c                 r   [        5       n[        5       n[        SU[        S[        S5      SS9[        S[        S5      SS95        [        SU[        S[        SS9[        S	[        S5      5      [        S
[        S5      5      5        [        SU[        S[        S5      SSS9[        S[        S5      SSS95        [        SU[        S[        SS9[        S	[        S5      SS9[        S
[        S5      SS9[        SS/SS/SS95        U R                  X5      nU R                  US   SSS	S
/SSS/SS9  g )Nr   rA   r   Tr   rB   r   r   rC   rD   tid1keyr   tid2oid1r]   oid2some_table.tid1some_table.tid2rT   rL   r   r9   r,   r/   s       r4   test_add_fk_colkeys/AutogenerateForeignKeysTest.test_add_fk_colkeysu  sH   ZZ66":4866":48		
 	4d3<,<,	
 	66":6tD66":6tD		
 	4d3<8<8  "$56#	
 b%!H<(V 	 	
r7   c                 r   [        5       n[        5       n[        SU[        S[        S5      SS9[        S[        S5      SS95        [        SU[        S[        SS9[        S	[        S5      5      [        S
[        S5      5      [        S	S
/SS/5      5        [        SU[        S[        S5      SSS9[        S[        S5      SSS95        [        SU[        S[        SS9[        S	[        S5      SS9[        S
[        S5      SS9[        SS/SS/5      5        U R                  X5      n[        U/ 5        g )Nr   rA   r   Tr   rB   r   r   rC   rD   rE   rF   r[   r\   r^   r_   r`   ra   rb   rc   rG   r/   s       r4   test_no_change_colkeys2AutogenerateForeignKeysTest.test_no_change_colkeys  s1   ZZ66":4866":48		
 	4d3<,<, |,"$56
	
 	66":6tD66":6tD		
 	4d3<8<8  #46G"H		
 b%E2r7    N)__name__
__module____qualname____firstlineno____backend____requires__r5   r:   r>   rH   rQ   rU   r   rN   no_name_normalizerX   rd   rg   __static_attributes__ri   r7   r4   r   r      s\    K9L-
^)
V(T0d;
z4
l **5
 +5
n1
f+r7   r   c                       \ rS rSrSrSr\" SS5      \R                  R                  S 5       5       r
S r\" SS5      \R                  R                  S 5       5       rS	rg
)IncludeHooksTesti  T)rO   )objectrL   c           
         [        5       n[        5       n[        SU[        S[        SS95      n[        SU[        S[        5      [        S[        5      5      nUR	                  [        UR                  R                  /UR                  R                  /SS	95        UR	                  [        UR                  R                  /UR                  R                  /S
S	95        [        SU[        S[        SS95      n[        SU[        S[        5      [        S[        5      5        US:X  a  S nU R                  X#US9nOUS:X  a  S nU R                  X#US9nU R                  WS   SSS/SS/S
S9  [        [        U5      S5        g )Nrefr   Tr   tr#   yfk1rL   fk2rt   c                 n    [        U [        5      =(       a    US:H  =(       a    U=(       a    US:H  (       + $ Nforeign_key_constraintry   
isinstancer   object_r   type_	reflected
compare_tos        r4   include_objectBIncludeHooksTest.test_remove_connection_fk.<locals>.include_object   s;    w(<= &!99&!& 	 r7   object_filtersr   c                 X    U S:X  a$  US:X  a  g[        US5        [        US SSS.5        gg)Nry   indexTr}   rw   schema_name
table_nameschema_qualified_table_nameFr   r   r   parent_namess      r4   include_name@IncludeHooksTest.test_remove_connection_fk.<locals>.include_name  s@    5='#78$+/*-;> !r7   name_filtersr   r(   r*   r	   r   r   r   r   append_constraintr   cr#   r   rx   r-   r.   r   len)	r0   	hook_typer1   r2   rv   t1r   r3   r   s	            r4   test_remove_connection_fk*IncludeHooksTest.test_remove_connection_fk  sz    ZZ4d3

 3 3 	
 	 "$$&&CEEHH:EB	
 	 "$$&&CEEHH:EB	
 4d3

 	3 3 		
   MM"MHE&  " MM"|MDE!HEF" 	 	
 	CJr7   c           
         [        5       n[        5       n[        SU[        S[        SS95        [        SU[        S[        5      [        S[        5      5        [        SU[        S[        SS95      n[        SU[        S[        5      [        S[        5      5      nUR	                  [        UR                  R                  /UR                  R                  /SS	95        UR	                  [        UR                  R                  /UR                  R                  /S
S	95        S nU R                  XUS9nU R                  US   SSS/SS/S
S	9  [        [        U5      S5        g )Nrv   r   Tr   rw   r#   rx   ry   rL   rz   c                 x    [        U [        5      =(       a    US:H  =(       a    U(       + =(       a    US:H  (       + $ r|   r~   r   s        r4   r   =IncludeHooksTest.test_add_metadata_fk.<locals>.include_objectK  s=    7$89 "55"!M" EM	 r7   r   r   r9   r	   r   )r0   r1   r2   rv   t2r   r3   s          r4   test_add_metadata_fk%IncludeHooksTest.test_add_metadata_fk)  sE   ZZ4d3	

 	3 3 		
 4d3

 3 3 	
 	 "$$&&CEEHH:EB	
 	 "$$&&CEEHH:EB	
	 b^D!HhcUED6 	 	
 	CJr7   c                 b   [        5       n[        5       n[        SU[        S[        SS95      n[        SU[        S[        SS9[        S[        SS95        [        SU[        S[        5      [        S	[        5      [        S
[        5      5      nUR	                  [        UR                  R                  /UR                  R                  /SS95        UR	                  [        UR                  R                  /UR                  R                  /SS95        [        SU[        S[        SS95        [        SU[        S[        SS9[        S[        SS95      n[        SU[        S[        5      [        S	[        5      [        S
[        5      5      nUR	                  [        UR                  R                  UR                  R                  /UR                  R                  UR                  R                  /SS95        UR	                  [        UR                  R                  UR                  R                  /UR                  R                  UR                  R                  /SS95        US:X  a  S nU R                  X#US9n	OUS:X  a  S n
U R                  X#U
S9n	US:X  aL  U R                  W	S   SSS	/SS/SS9  U R                  U	S   SSS	S
/SSS/SS9  [        [        U	5      S5        g US:X  a1  [        W	 Vs1 s H  oS   US   R                   4iM     sn1 Sk5        g g s  snf )Nref_aaTr   ref_bbrw   r#   rx   zry   rL   rz   rt   c                 \    [        U [        5      =(       a    US:H  =(       a    US:H  (       + $ r|   r~   r   s        r4   r   7IncludeHooksTest.test_change_fk.<locals>.include_object  s1    w(<= &!99& r7   r   r   c                 X    US:X  a  gU S:X  a  [        US5        [        US SSS.5        gg)Nr   Try   r}   rw   r   Fr   r   s      r4   r   5IncludeHooksTest.test_change_fk.<locals>.include_name  s@    G#5=78$+/*-;> !r7   r   r   r(   r	   r9      >   r9   ry   r9   rz   r(   rz   )r   r   r   r   r   r   r   r#   r   rx   r   r   r-   r.   r   r   r   )r0   r   r1   r2   r1ar   r2br   r   r3   r   ds               r4   test_change_fkIncludeHooksTest.test_change_fkZ  s    ZZ3T2

 	3T23T2		
 3 3 3 
 	 "$$&&CEEGG95A	
 	 "$$&&CEEGG95A	
 	3T2	

 3T23T2	
 3 3 3 
 	  35577CEEGG"45	

 	  35577CEEGG"45	
   MM"MHE&  $ MM"|MDE   a+sSE7SE !    ac
c
 !  E
A& ,12EqA$!		"E2L !2s   L,ri   N)rj   rk   rl   rm   rn   ro   r   r   rN   rp   r   r   r   rq   ri   r7   r4   rs   rs     ss    K L+y)**K + *KZ/b +y)**l + *lr7   rs   c                      \ rS rSrSrS r\R                  R                  S 5       r	\R                  R                  S 5       r
S r\R                  R                  S 5       r\R                  R                  S 5       r\R                  R                  S	 5       r\R                  R"                  S
 5       r\R                  R&                  S 5       r\R                  R*                  S 5       r\R                  R                  S 5       r\R                  R"                  S 5       r\R                  R"                  S 5       r\R                  R                  \R                  R                  S 5       5       r\R                  R6                  S 5       r\R                  R6                  S 5       r\R                  R<                  \R                  R6                  S 5       5       r\R                  R<                  \R                  R6                  S 5       5       r \R                  R6                  \R                  R<                  S 5       5       r!\R                  R6                  \R                  R<                  S 5       5       r"\R                  R6                  \R                  R<                  S 5       5       r#\R                  R<                  S 5       r$\R                  RJ                  S 5       r&Sr'g)AutogenerateFKOptionsTesti  Tc                 ,   [        5       n[        5       n[        SU[        S[        SS9[        S[	        S5      5      5        [        SU[        S[        SS9[        S[	        S	5      S
S9[        S[        5      [        S/S/40 UD65        [        SU[        S[        SS9[        S[	        S5      5      5        [        SU[        S[        SS9[        S[	        S	5      S
S9[        S[        5      [        S/S/40 UD65        U R                  X45      $ )Nr   r   Tr   r   r   r   r   r   Fr    tidr=   )r   r   r   r   r   r   r-   )r0   old_optsnew_optsr1   r2   s        r4   _fk_opts_fixture*AutogenerateFKOptionsTest._fk_opts_fixture  s   ZZ4d366":&		
 	4d366":65'" %?*;HxH	
 	4d366":&		
 	4d366":65'" %?*;HxH	
 }}R$$r7   c                     U R                  0 SS05      nU R                  US   SSS/SS/S S	S
9  U R                  US   SSS/SS/SS9  g )Nondeletecascader   r(   r   r   r   r   r)   r   r+   r	   r9   r   r   r.   r0   r3   s     r4   test_add_ondelete+AutogenerateFKOptionsTest.test_add_ondelete  ~    %%b:y*AB!HGF. 	 		
 	!HGF 	 	
r7   c                     U R                  SS00 5      nU R                  US   SSS/SS/SS	S
9  U R                  US   SSS/SS/S S9  g )Nr   CASCADEr   r(   r   r   r   r   r)   r   r	   r9   r   r   r   s     r4   test_remove_ondelete.AutogenerateFKOptionsTest.test_remove_ondelete  ~    %%z9&=rB!HGF. 	 		
 	!HGF 	 	
r7   c                 H    U R                  SS0SS05      n[        U/ 5        g)test case sensitivityr   caSCAdeCasCadeNr   r   r   s     r4   test_nochange_ondelete0AutogenerateFKOptionsTest.test_nochange_ondelete&  s,    %%#j)%<
 	E2r7   c                     U R                  0 SS05      nU R                  US   SSS/SS/S S	S
9  U R                  US   SSS/SS/SS9  g )Nonupdater   r   r(   r   r   r   r   r)   r   r+   r	   r9   r   r   r   s     r4   test_add_onupdate+AutogenerateFKOptionsTest.test_add_onupdate-  r   r7   c                     U R                  SS00 5      nU R                  US   SSS/SS/SS	S
9  U R                  US   SSS/SS/S S9  g )Nr   r   r   r(   r   r   r   r   r)   r   r	   r9   r   r   r   s     r4   test_remove_onupdate.AutogenerateFKOptionsTest.test_remove_onupdateF  r   r7   c                 H    U R                  SS0SS05      n[        U/ 5        g)r   r   r   r   Nr   r   s     r4   test_nochange_onupdate0AutogenerateFKOptionsTest.test_nochange_onupdate_  s.     %%#j)%<
 	E2r7   c                 H    U R                  SS0SS05      n[        U/ 5        g)6test the RESTRICT option which MySQL doesn't report onr   restrictNr   r   s     r4   test_nochange_ondelete_restrict9AutogenerateFKOptionsTest.test_nochange_ondelete_restrictg  .     %%$z:&>
 	E2r7   c                 H    U R                  SS0SS05      n[        U/ 5        g)r   r   r   Nr   r   s     r4   test_nochange_onupdate_restrict9AutogenerateFKOptionsTest.test_nochange_onupdate_restrictp  r   r7   c                 H    U R                  SS0SS05      n[        U/ 5        g)<test the NO ACTION option which generally comes back as Noner   	no actionNr   r   s     r4   test_nochange_ondelete_noaction9AutogenerateFKOptionsTest.test_nochange_ondelete_noactiony  .     %%%
K'@
 	E2r7   c                 H    U R                  SS0SS05      n[        U/ 5        g)r   r   r   Nr   r   s     r4   test_nochange_onupdate_noaction9AutogenerateFKOptionsTest.test_nochange_onupdate_noaction  r   r7   c                     U R                  SS0SS05      nU R                  US   SSS/SS	/S
[        R                  SS9	  U R                  US   SSS/SS	/S
SS9  g
)r   r   r   r   r   r(   r   r   r   r   Nr)   r   r   r+   r	   r9   r   r   r   r.   r   ANYr   s     r4   "test_change_ondelete_from_restrict<AutogenerateFKOptionsTest.test_change_ondelete_from_restrict  s     %%$z9&=
 	!HGFXX. 	 
	
 	!HGF 	 		
r7   c                     U R                  SS0SS05      nU R                  US   SSS/SS	/[        R                  S
SS9	  U R                  US   SSS/SS	/SS
S9  g
)r   r   r   r   r   r(   r   r   r   r   Nr)   r   r	   r9   r   r   r   s     r4   "test_change_onupdate_from_restrict<AutogenerateFKOptionsTest.test_change_onupdate_from_restrict  s     %%$z9&=
 	!HGFXX. 	 
	
 	!HGF 	 		
r7   c                     U R                  SSS.SSS.5      nU R                  US   SSS/S	S
/SSSS9	  U R                  US   SSS/S	S
/SSS9  g )Nr   zSET NULLr   RESTRICTr   r(   r   r   r   r   r)   r   r	   r9   r   r   s     r4   test_ondelete_onupdate_combo6AutogenerateFKOptionsTest.test_ondelete_onupdate_combo  s     %%"
;#<

 	!HGF. 	 
	
 	!HGF 	 		
r7   c                     U R                  0 SS05      nU R                  US   SSS/SS/S S	S
9  U R                  US   SSS/SS/SS9  g )N	initiallydeferredr   r(   r   r   r   r   r)   r  r+   r	   r9   r  r   r   s     r4   test_add_initially_deferred5AutogenerateFKOptionsTest.test_add_initially_deferred  s~    %%b;
*CD!HGF. 	 		
 	!HGF  	 	
r7   c                     U R                  SS00 5      nU R                  US   SSS/SS/S	S
SS9	  U R                  US   SSS/SS/S S9  g )Nr  r  r   r(   r   r   r   r   DEFERREDTr)   r  
deferrabler+   r	   r9   r  r   r   s     r4   test_remove_initially_deferred8AutogenerateFKOptionsTest.test_remove_initially_deferred  s    %%{J&?D!HGF . 	 
	
 	!HGF 	 	
r7   c                     U R                  0 SSS.5      nU R                  US   SSS/SS	/S S
S9  U R                  US   SSS/SS	/SSS9  g )N	immediateTr  r
  r   r(   r   r   r   r   r)   r  r	   r9   r   r   s     r4   ,test_add_initially_immediate_plus_deferrableFAutogenerateFKOptionsTest.test_add_initially_immediate_plus_deferrable  s     %%k>
 	!HGF. 	 		
 	!HGF! 	 		
r7   c                     U R                  SSS.0 5      nU R                  US   SSS/SS	/S SS
S9	  U R                  US   SSS/SS	/S S S9  g )Nr  Tr  r   r(   r   r   r   r   r)   r	  r	   r9   r   r   s     r4   /test_remove_initially_immediate_plus_deferrableIAutogenerateFKOptionsTest.test_remove_initially_immediate_plus_deferrable:  s     %%%T:B
 	!HGF. 	 
	
 	!HGF 	 		
r7   c                 L    U R                  SSS.SSS.5      n[        U/ 5        g )NTr  r
  r  r   r   s     r4   *test_add_initially_deferrable_nochange_oneDAutogenerateFKOptionsTest.test_add_initially_deferrable_nochange_oneX  s/     %%k:k:

 	E2r7   c                 L    U R                  SSS.SSS.5      n[        U/ 5        g )NTr  r  r   r   s     r4   *test_add_initially_deferrable_nochange_twoDAutogenerateFKOptionsTest.test_add_initially_deferrable_nochange_twob  /     %%j9j9

 	E2r7   c                 L    U R                  S SS.S SS.5      n[        U/ 5        g )Nr  r  r   r   s     r4   ,test_add_initially_deferrable_nochange_threeFAutogenerateFKOptionsTest.test_add_initially_deferrable_nochange_threel  r  r7   c                     U R                  0 SS05      nU R                  US   SSS/SS/S S	S
9  U R                  US   SSS/SS/SS9  g Nr
  Tr   r(   r   r   r   r   r)   )r
  r+   r	   r9   )r
  r   r   s     r4   test_add_deferrable-AutogenerateFKOptionsTest.test_add_deferrablev  s~    %%b<*>?!HGF. 	 		
 	!HGF 	 	
r7   c                     U R                  SS00 5      nU R                  US   SSS/SS/SS	S
9  U R                  US   SSS/SS/S S9  g r!  r   r   s     r4   test_remove_deferrable0AutogenerateFKOptionsTest.test_remove_deferrable  s~    %%|T&:B?!HGF. 	 		
 	!HGF 	 	
r7   ri   N)(rj   rk   rl   rm   rn   r   r   rN   fk_ondelete_is_reflectedr   r   r   fk_onupdate_is_reflectedr   r   fk_onupdater   fk_ondelete_restrictr   fk_onupdate_restrictr   fk_ondelete_noactionr   r   r   r   r   fk_initiallyr  r  fk_deferrabler  r  r  r  r  r"  fk_deferrable_is_reflectedr%  rq   ri   r7   r4   r   r     s*   K$%L 11
 2
0 11
 2
0 11
 2
0 11
 2
0 $$ % -- . -- . -- . $$ % --
 .
> --
 .
> 1111
 2 2
: %%
 &
0 %%
 &
2 &&%%
 & '
6 &&%%
 & '
8 %%&& ' & %%&& ' & %%&& ' & &&
 '
0 33
 4
r7   r   N)
sqlalchemyr   r   r   r   r   r   _autogen_fixturesr
   testingr   r   r   r   r   r   rs   r   ri   r7   r4   <module>r3     s^     +     1 #    C"4h CLr)8 rj[
 2H [
r7   