+
    i                         ^ RI Ht ^ RI Ht ^ RI Ht ^ RI Ht ^ RI Ht ^ RI Ht ^RIHt ^RI	H
t
 ^R	I	Ht ^R
I	Ht ^RI	Ht ^RI	Ht  ! R R]]4      t ! R R]]4      t ! R R]]4      tR# )    )Column)ForeignKeyConstraint)Integer)MetaData)String)Table)AutogenFixtureTest)combinations)configeq_)mock)TestBasec                      a  ] tR t^t o RtRtR tR tR tR t	]
P                  P                  R 4       tR t]
P                  P                  R 4       tR	 tR
 tRtV tR# )AutogenerateForeignKeysTestTc                   \        4       p\        4       p\        R V\        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^24      RR7      \        R	\        ^
4      R
R7      \        R\        ^
4      4      \        R.R.4      4       \        R V\        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^24      RR7      \        R	\        ^
4      R
R7      \        R\        ^
4      4      4       V P                  W4      pV P                  V^ ,          RRR.R R.RR7       R# )
some_tabletestTprimary_keyuseridnameFnullablea1xserver_defaulttest2some_table.test	remove_fkservergeneratedconditional_nameNr   r   r   r   r   r   _fixture_assert_fk_diffselfm1m2diffss   &   ڀC:\Users\petid\OneDrive\Desktop\Maestro\MAESTRO\maestro-backend\venv\Lib\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                   \        4       p\        4       p\        R V\        R\        RR7      \        R\	        ^
4      4      4       \        RV\        R\        RR7      \        R\	        ^24      RR7      \        R	\	        ^
4      R
R7      \        R\	        ^
4      4      4       \        R V\        R\        RR7      \        R\	        ^
4      4      4       \        RV\        R\        RR7      \        R\	        ^24      RR7      \        R	\	        ^
4      R
R7      \        R\	        ^
4      4      \        R.R.4      4       V P                  W4      pV P                  V^ ,          RRR.R R.4       R# )r   r   Tr   r   r   r   Fr   r   r   r   r    r!   add_fkN)r   r   r   r   r   r   r'   r(   r)   s   &   r.   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	<&	
r1   c                   \        4       p\        4       p\        R V\        R\        RR7      \        R\	        ^
4      4      4       \        RV\        R\        RR7      \        R\	        ^24      RR7      \        R	\	        ^
4      R
R7      \        R\        4      \        R.R.4      4       \        R V\        R\        RR7      \        R\	        ^
4      4      4       \        RV\        R\        RR7      \        R\	        ^24      RR7      \        R	\	        ^
4      R
R7      \        R\        4      \        R.R.4      4       V P                  W4      p\        V. 4       R# )r   r   Tr   r   r   r   Fr   r   r   r   r    some_table.idN)r   r   r   r   r   r   r'   r   r)   s   &   r.   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r1   c                H   \        4       p\        4       p\        R V\        R\        ^
4      RR7      \        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^24      RR	7      \        R
\        ^
4      RR7      \        R\        ^
4      4      \        R\        ^
4      4      \        RR.RR.4      4       \        R V\        R\        ^
4      RR7      \        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^24      RR	7      \        R
\        ^
4      RR7      \        R\        ^
4      4      \        R\        ^
4      4      \        RR.RR.4      4       V P                  W4      p\        V. 4       R# )r   id_1Tr   id_2r   r   r   Fr   r   r   r   
other_id_1
other_id_2some_table.id_1some_table.id_2Nr   r   r   r   r   r   r'   r   r)   s   &   r.   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r1   c                   \        4       p\        4       p\        R V\        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^24      RR7      \        R	\        ^
4      R
R7      \        R\        ^
4      4      \        R.R.RR7      4       \        R V\        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^24      RR7      \        R	\        ^
4      R
R7      \        R\        ^
4      4      \        R	.R.RR7      4       V P                  W4      pV P                  V^ ,          RRR.R R.RR7       V P                  V^,          RRR	.R R.RR7       R# )r   r   Tr   r   r   r   Fr   r   r   r   r    r!   MyFKr   myfkr"   r3   Nr&   r)   s   &   r.   1test_casing_convention_changed_so_put_drops_firstMAutogenerateForeignKeysTest.test_casing_convention_changed_so_put_drops_first   sx   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 	 	
 	!HFH 	 	
r1   c                \   \        4       p\        4       p\        R V\        R\        ^
4      RR7      \        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^24      RR	7      \        R
\        ^
4      RR7      \        R\        ^
4      4      \        R\        ^
4      4      4       \        R V\        R\        ^
4      RR7      \        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^24      RR	7      \        R
\        ^
4      RR7      \        R\        ^
4      4      \        R\        ^
4      4      \        RR.RR.RR7      4       V P                  W4      pV P                  V^ ,          RRRR.R RR.RR7       R# )r   r;   Tr   r<   r   r   r   Fr   r   r   r   r=   r>   r?   r@   fk_test_namerF   r3   Nr&   r)   s   &   r.   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 	 	
r1   c                \   \        4       p\        4       p\        R V\        R\        ^
4      RR7      \        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^24      RR	7      \        R
\        ^
4      RR7      \        R\        ^
4      4      \        R\        ^
4      4      \        RR.RR.RR7      4       \        R V\        R\        ^
4      RR7      \        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^24      RR	7      \        R
\        ^
4      RR7      \        R\        ^
4      4      \        R\        ^
4      4      4       V P                  W4      pV P                  V^ ,          RRRR.R RR.RR7       R# )r   r;   Tr   r<   r   r   r   Fr   r   r   r   r=   r>   r?   r@   rK   rF   r"   r$   Nr&   r)   s   &   r.   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+ 	 	
r1   c                   \        4       p\        4       p\        R V\        R\        ^
4      RR7      \        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^
4      4      \        R\        ^
4      4      4       \        R V\        R\        ^
4      R	RR
7      \        R\        ^
4      RRR
7      4       \        RV\        R\        RR7      \        R\        ^
4      RR7      \        R\        ^
4      RR7      \        RR.RR.RR7      4       V P                  W4      pV P                  V^ ,          RRRR.R RR.RR7       R# )r   r;   Tr   r<   r   r   r=   r>   tid1keyr   tid2oid1rT   oid2some_table.tid1some_table.tid2rK   rF   r3   Nr&   r)   s   &   r.   test_add_fk_colkeys/AutogenerateForeignKeysTest.test_add_fk_colkeysv  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 	 	
r1   c                   \        4       p\        4       p\        R V\        R\        ^
4      RR7      \        R\        ^
4      RR7      4       \        RV\        R\        RR7      \        R\        ^
4      4      \        R\        ^
4      4      \        RR.R	R
.4      4       \        R V\        R\        ^
4      RRR7      \        R\        ^
4      RRR7      4       \        RV\        R\        RR7      \        R\        ^
4      RR7      \        R\        ^
4      RR7      \        RR.RR.4      4       V P                  W4      p\        V. 4       R# )r   r;   Tr   r<   r   r   r=   r>   r?   r@   rR   rS   rU   rV   rW   rX   rY   rZ   NrA   r)   s   &   r.   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r1    N)!foreign_key_constraint_reflection)__name__
__module____qualname____firstlineno____backend____requires__r/   r4   r8   rB   r   requirementsforeign_key_name_reflectionrH   rL   no_name_normalizerO   r[   r^   __static_attributes____classdictcell____classdict__s   @r.   r   r      s     K9L-
^)
V(T0d 44;
 5;
z4
l **5
 +5
n1
f+ +r1   r   c                      a  ] tR tRt o RtRt]! R	R
4      ]P                  P                  R 4       4       t
R t]! R	R
4      ]P                  P                  R 4       4       tRtV tR# )IncludeHooksTesti  Tc           
     H   \        4       p\        4       p\        R V\        R\        RR7      4      p\        RV\        R\        4      \        R\        4      4      pVP	                  \        VP                  P                  .VP                  P                  .RR7      4       VP	                  \        VP                  P                  .VP                  P                  .R	R7      4       \        R V\        R\        RR7      4      p\        RV\        R\        4      \        R\        4      4       VR
8X  d   R pV P                  W#VR7      pMVR8X  d   R pV P                  W#VR7      pV P                  X^ ,          RRR.R R.R	R7       \        \        V4      ^4       R# )refr   Tr   tr   yfk1rF   fk2objectc                 t    \        V \        4      ;'       d    VR 8H  ;'       d    T;'       d    VR8H  '       * # foreign_key_constraintru   
isinstancer   object_r   type_	reflected
compare_tos   &&&&&r.   include_objectBIncludeHooksTest.test_remove_connection_fk.<locals>.include_object  sJ    w(<= & &!99& &!& & 	 r1   object_filtersr   c           	      f    V R 8X  d*   VR8X  d   R# \        VR4       \        VRRRRRR/4       R	# R# )
ru   indexTrz   schema_nameN
table_namers   schema_qualified_table_nameFr   r   r   parent_namess   &&&r.   include_name@IncludeHooksTest.test_remove_connection_fk.<locals>.include_name  sF    5='#78$)4(#93 !r1   name_filtersr"   r$   Nr   r   r   r   append_constraintr   cr   r   rt   r'   r(   r   len)	r*   	hook_typer+   r,   rr   t1r   r-   r   s	   &&       r.   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r1   c           
        \        4       p\        4       p\        R V\        R\        RR7      4       \        RV\        R\        4      \        R\        4      4       \        R V\        R\        RR7      4      p\        RV\        R\        4      \        R\        4      4      pVP	                  \        VP                  P                  .VP                  P                  .RR7      4       VP	                  \        VP                  P                  .VP                  P                  .R	R7      4       R
 pV P                  WVR7      pV P                  V^ ,          RRR.R R.R	R7       \        \        V4      ^4       R# )rr   r   Tr   rs   r   rt   ru   rF   rv   c                 ~    \        V \        4      ;'       d"    VR 8H  ;'       d    V'       * ;'       d    VR8H  '       * # ry   r{   r}   s   &&&&&r.   r   =IncludeHooksTest.test_add_metadata_fk.<locals>.include_objectL  sL    7$89 " "55" "!M" " EM	 r1   r   r3   Nr   )r*   r+   r,   rr   t2r   r-   s   &      r.   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r1   c                   \        4       p\        4       p\        R V\        R\        RR7      4      p\        RV\        R\        RR7      \        R\        RR7      4       \        RV\        R\        4      \        R\        4      \        R	\        4      4      pVP	                  \        VP                  P                  .VP                  P                  .R
R7      4       VP	                  \        VP                  P                  .VP                  P                  .RR7      4       \        R V\        R\        RR7      4       \        RV\        R\        RR7      \        R\        RR7      4      p\        RV\        R\        4      \        R\        4      \        R	\        4      4      pVP	                  \        VP                  P                  VP                  P                  .VP                  P                  VP                  P                  .R
R7      4       VP	                  \        VP                  P                  VP                  P                  .VP                  P                  VP                  P                  .RR7      4       VR8X  d   R pV P                  W#VR7      p	MVR8X  d   R p
V P                  W#V
R7      p	VR8X  d\   V P                  X	^ ,          RRR.R R.RR7       V P                  V	^,          RRRR	.RRR.RR7       \        \        V	4      ^4       R# VR8X  d:   \        X	 Uu0 uF  q^ ,          V^,          P                   3kK   	  up0 Rm4       R# R# u upi )ref_aaTr   ref_bbrs   r   rt   zru   rF   rv   rw   c                 `    \        V \        4      ;'       d    VR 8H  ;'       d    VR8H  '       * # ry   r{   r}   s   &&&&&r.   r   7IncludeHooksTest.test_change_fk.<locals>.include_object  s;    w(<= & &!99& & r1   r   r   c           	      f    VR 8X  d   R# V R8X  d!   \        VR4       \        VRRRRRR/4       R	# R# )
r   Tru   rz   r   Nr   rs   r   Fr   r   s   &&&r.   r   5IncludeHooksTest.test_change_fk.<locals>.include_name  sF    G#5=78$)4(#93 !r1   r   r"   r3   N>   r3   ru   r3   rv   r"   rv   )r   r   r   r   r   r   r   r   r   rt   r   r   r'   r(   r   r   r   )r*   r   r+   r,   r1ar   r2br   r   r-   r   ds   &&          r.   test_change_fkIncludeHooksTest.test_change_fk[  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   :$M,r`   N)fk_names)rw   rF   )rb   rc   rd   re   rf   rg   r
   r   rh   rj   r   r   r   rk   rl   rm   s   @r.   rp   rp     sv     K L+y)**K + *KZ/b +y)**l + *lr1   rp   c                     a  ] tR tRt o RtR t]P                  P                  R 4       t	]P                  P                  R 4       t
R t]P                  P                  R 4       t]P                  P                  R 4       t]P                  P                  R	 4       t]P                  P"                  R
 4       t]P                  P&                  R 4       t]P                  P*                  R 4       t]P                  P                  R 4       t]P                  P"                  R 4       t]P                  P"                  R 4       t]P                  P                  ]P                  P                  R 4       4       t]P                  P6                  R 4       t]P                  P6                  R 4       t]P                  P<                  ]P                  P6                  R 4       4       t]P                  P<                  ]P                  P6                  R 4       4       t ]P                  P6                  ]P                  P<                  R 4       4       t!]P                  P6                  ]P                  P<                  R 4       4       t"]P                  P6                  ]P                  P<                  R 4       4       t#]P                  P<                  R 4       t$]P                  PJ                  R 4       t&Rt'V t(R# )AutogenerateFKOptionsTesti  Tc                P   \        4       p\        4       p\        R V\        R\        RR7      \        R\	        ^
4      4      4       \        RV\        R\        RR7      \        R\	        ^24      RR7      \        R	\        4      \        R	.R
.3/ VB 4       \        R V\        R\        RR7      \        R\	        ^
4      4      4       \        RV\        R\        RR7      \        R\	        ^24      RR7      \        R	\        4      \        R	.R
.3/ VB 4       V P                  W44      # )r   r   Tr   r   r   r   Fr   tidr7   )r   r   r   r   r   r   r'   )r*   old_optsnew_optsr+   r,   s   &&&  r.   _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$$r1   c                    V P                  / R R/4      pV P                  V^ ,          RRR.RR.RRR	7       V P                  V^,          R
RR.RR.RR7       R# )ondeletecascader"   r   r   r   r   Nr#   r   r%   r3   r   r   r(   r*   r-   s   & r.   test_add_ondelete+AutogenerateFKOptionsTest.test_add_ondelete  ~    %%b:y*AB!HGF. 	 		
 	!HGF 	 	
r1   c                    V P                  R R// 4      pV P                  V^ ,          RRR.RR.RRR7       V P                  V^,          R	RR.RR.R
R7       R
# )r   CASCADEr"   r   r   r   r   r#   r   r3   Nr   r   r   s   & r.   test_remove_ondelete.AutogenerateFKOptionsTest.test_remove_ondelete  ~    %%z9&=rB!HGF. 	 		
 	!HGF 	 	
r1   c                J    V P                  RR/RR/4      p\        V. 4       R# )test case sensitivityr   caSCAdeCasCadeNr   r   r   s   & r.   test_nochange_ondelete0AutogenerateFKOptionsTest.test_nochange_ondelete'  s,    %%#j)%<
 	E2r1   c                    V P                  / R R/4      pV P                  V^ ,          RRR.RR.RRR	7       V P                  V^,          R
RR.RR.RR7       R# )onupdater   r"   r   r   r   r   Nr#   r   r%   r3   r   r   r   s   & r.   test_add_onupdate+AutogenerateFKOptionsTest.test_add_onupdate.  r   r1   c                    V P                  R R// 4      pV P                  V^ ,          RRR.RR.RRR7       V P                  V^,          R	RR.RR.R
R7       R
# )r   r   r"   r   r   r   r   r#   r   r3   Nr   r   r   s   & r.   test_remove_onupdate.AutogenerateFKOptionsTest.test_remove_onupdateG  r   r1   c                J    V P                  RR/RR/4      p\        V. 4       R# )r   r   r   r   Nr   r   s   & r.   test_nochange_onupdate0AutogenerateFKOptionsTest.test_nochange_onupdate`  s.     %%#j)%<
 	E2r1   c                J    V P                  RR/RR/4      p\        V. 4       R# )6test the RESTRICT option which MySQL doesn't report onr   restrictNr   r   s   & r.   test_nochange_ondelete_restrict9AutogenerateFKOptionsTest.test_nochange_ondelete_restricth  .     %%$z:&>
 	E2r1   c                J    V P                  RR/RR/4      p\        V. 4       R# )r   r   r   Nr   r   s   & r.   test_nochange_onupdate_restrict9AutogenerateFKOptionsTest.test_nochange_onupdate_restrictq  r   r1   c                J    V P                  RR/RR/4      p\        V. 4       R# )<test the NO ACTION option which generally comes back as Noner   	no actionNr   r   s   & r.   test_nochange_ondelete_noaction9AutogenerateFKOptionsTest.test_nochange_ondelete_noactionz  .     %%%
K'@
 	E2r1   c                J    V P                  RR/RR/4      p\        V. 4       R# )r   r   r   Nr   r   s   & r.   test_nochange_onupdate_noaction9AutogenerateFKOptionsTest.test_nochange_onupdate_noaction  r   r1   c                    V P                  RR/RR/4      pV P                  V^ ,          RRR.RR.R	\        P                  R
R7	       V P                  V^,          RRR.RR.R	RR7       R	# )r   r   r   r   r"   r   r   r   r   Nr#   r   r   r%   r3   r   r   r   r(   r   ANYr   s   & r.   "test_change_ondelete_from_restrict<AutogenerateFKOptionsTest.test_change_ondelete_from_restrict  s     %%$z9&=
 	!HGFXX. 	 
	
 	!HGF 	 		
r1   c                    V P                  RR/RR/4      pV P                  V^ ,          RRR.RR.\        P                  R	R
R7	       V P                  V^,          RRR.RR.RR	R7       R	# )r   r   r   r   r"   r   r   r   r   Nr#   r   r3   r   r   r   s   & r.   "test_change_onupdate_from_restrict<AutogenerateFKOptionsTest.test_change_onupdate_from_restrict  s     %%$z9&=
 	!HGFXX. 	 
	
 	!HGF 	 		
r1   c                    V P                  R RRR/R RRR/4      pV P                  V^ ,          RRR.RR	.RRR
R7	       V P                  V^,          RRR.RR	.RRR7       R# )r   r   r   zSET NULLRESTRICTr"   r   r   r   r   r#   r   r3   r   Nr   r   s   & r.   test_ondelete_onupdate_combo6AutogenerateFKOptionsTest.test_ondelete_onupdate_combo  s     %%J
;Z<

 	!HGF. 	 
	
 	!HGF 	 		
r1   c                    V P                  / R R/4      pV P                  V^ ,          RRR.RR.RRR	7       V P                  V^,          R
RR.RR.RR7       R# )	initiallydeferredr"   r   r   r   r   Nr#   r   r%   r3   r   r   r   s   & r.   test_add_initially_deferred5AutogenerateFKOptionsTest.test_add_initially_deferred  s~    %%b;
*CD!HGF. 	 		
 	!HGF  	 	
r1   c                    V P                  R R// 4      pV P                  V^ ,          RRR.RR.RRR	R
7	       V P                  V^,          RRR.RR.RR7       R# )r   r   r"   r   r   r   r   DEFERREDTr#   r   
deferrabler%   r3   Nr   r   r   s   & r.   test_remove_initially_deferred8AutogenerateFKOptionsTest.test_remove_initially_deferred  s    %%{J&?D!HGF . 	 
	
 	!HGF 	 	
r1   c                    V P                  / R RRR/4      pV P                  V^ ,          RRR.RR.R	R
R7       V P                  V^,          RRR.RR.RRR7       R	# )r   	immediater  Tr"   r   r   r   r   Nr#   r   r3   r   r  r   r   s   & r.   ,test_add_initially_immediate_plus_deferrableFAutogenerateFKOptionsTest.test_add_initially_immediate_plus_deferrable  s     %%k<>
 	!HGF. 	 		
 	!HGF! 	 		
r1   c                    V P                  R RRR// 4      pV P                  V^ ,          RRR.RR.R	RR
R7	       V P                  V^,          RRR.RR.R	R	R7       R	# )r   r
  r  Tr"   r   r   r   r   Nr#   r  r3   r  r   r   s   & r.   /test_remove_initially_immediate_plus_deferrableIAutogenerateFKOptionsTest.test_remove_initially_immediate_plus_deferrable;  s     %%+|T:B
 	!HGF. 	 
	
 	!HGF 	 		
r1   c                R    V P                  R RRR/R RRR/4      p\        V. 4       R# )r  Tr   r
  Nr   r   s   & r.   *test_add_initially_deferrable_nochange_oneDAutogenerateFKOptionsTest.test_add_initially_deferrable_nochange_oneY  s7     %%4k:4k:

 	E2r1   c                R    V P                  R RRR/R RRR/4      p\        V. 4       R# )r  Tr   r   Nr   r   s   & r.   *test_add_initially_deferrable_nochange_twoDAutogenerateFKOptionsTest.test_add_initially_deferrable_nochange_twoc  7     %%4j94j9

 	E2r1   c                R    V P                  R RRR/R RRR/4      p\        V. 4       R# )r  Nr   r   r   r   s   & r.   ,test_add_initially_deferrable_nochange_threeFAutogenerateFKOptionsTest.test_add_initially_deferrable_nochange_threem  r  r1   c                    V P                  / R R/4      pV P                  V^ ,          RRR.RR.RRR	7       V P                  V^,          R
RR.RR.RR7       R# )r  Tr"   r   r   r   r   Nr#   r  r%   r3   r  r   r   s   & r.   test_add_deferrable-AutogenerateFKOptionsTest.test_add_deferrablew  s~    %%b<*>?!HGF. 	 		
 	!HGF 	 	
r1   c                    V P                  R R// 4      pV P                  V^ ,          RRR.RR.RRR7       V P                  V^,          R	RR.RR.R
R7       R
# )r  Tr"   r   r   r   r   r#   r  r3   Nr  r   r   s   & r.   test_remove_deferrable0AutogenerateFKOptionsTest.test_remove_deferrable  s~    %%|T&:B?!HGF. 	 		
 	!HGF 	 	
r1   r`   N))rb   rc   rd   re   rf   r   r   rh   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!  rk   rl   rm   s   @r.   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
r1   r   N)
sqlalchemyr   r   r   r   r   r   _autogen_fixturesr	   testingr
   r   r   r   r   r   rp   r   r`   r1   r.   <module>r/     s^     +     1 #    D"4h DNr)8 rj[
 2H [
r1   