+
    i0                     j   ^ RI 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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]P*                  4      t ! R R]P.                  ]4      t ! R R]P*                  4      tRtR# )    N)testing)config)fixtures)util)eq_)is_false)is_true)requirements)Table)CheckConstraint)Column)ForeignKeyConstraint)Index)inspect)Integerschema)String)UniqueConstraintc                     a  ] tR t^t o RtRR ltR tRR ltR t]	P                  ]P                  R 4       4       t]	P                  ]	P                  ]P                  R 4       4       4       t]	P                   ]P                  R	 4       4       t]	P                  ]P                  R
 4       4       t]	P&                  ]P                  R 4       4       t]	P&                  ]P                  R 4       4       t]	P,                  ]P                  R 4       4       t]	P0                  ]P                  R 4       4       t]	P,                  ]P                  R 4       4       t]	P0                  ]P                  R 4       4       tRtV tR# )TableDDLTestTNc                ~    \        R V P                  \        R\        RRR7      \        R\	        ^24      4      VR7      # )
test_tableidTFprimary_keyautoincrementdatar   r   metadatar   r   r   )selfr   s   &&{C:\Users\petid\OneDrive\Desktop\Maestro\MAESTRO\maestro-backend\venv\Lib\site-packages\sqlalchemy/testing/suite/test_ddl.py_simple_fixtureTableDDLTest._simple_fixture"   s8    MM4d%H66":&
 	
    c                z    \        R V P                  \        R\        RRR7      \        R\	        ^24      4      4      # )_test_tabler   TFr   _datar   )r!   s   &r"   _underscore_fixture TableDDLTest._underscore_fixture+   s5    MM4d%H7F2J'	
 	
r%   c                l    V P                  VR 7      p\        RVP                  P                  4      pW#3# )r   
test_index)r#   r   cr   )r!   r   tableidxs   &&  r"   _table_index_fixture!TableDDLTest._table_index_fixture3   s1    $$F$3L%'',,/zr%   c                Z   \         P                  P                  4       ;_uu_ 4       pVP                  VP	                  4       P                  R4      4       VP                  VP                  4       4      p\        VP                  4       R4       RRR4       R#   + '       g   i     R# ; i)   N)r3   z	some data)	r   dbbeginexecuteinsertvaluesselectr   first)r!   r.   connresults   &&  r"   _simple_roundtripTableDDLTest._simple_roundtrip8   sg    YY__$LL../?@A\\%,,.1F 01 s   A(BB*	c                    V P                  4       pVP                  \        P                  R R7       V P	                  V4       R# F
checkfirstN)r#   creater   r4   r=   r!   r.   s   & r"   test_create_tableTableDDLTest.test_create_table>   s4     $$&VYY51u%r%   c                    V P                  \        P                  R 7      pVP                  \        P                  RR7       V P                  V4       R# )r   FrA   N)r#   r   test_schemarC   r4   r=   rD   s   & r"   test_create_table_schema%TableDDLTest.test_create_table_schemaE   s?     $$F,>,>$?VYY51u%r%   c                    V P                  4       pVP                  \        P                  R R7       VP	                  \        P                  R R7       R# r@   )r#   rC   r   r4   droprD   s   & r"   test_drop_tableTableDDLTest.test_drop_tableM   s:     $$&VYY51

699
/r%   c                    V P                  4       pVP                  \        P                  R R7       V P	                  V4       R# r@   )r)   rC   r   r4   r=   rD   s   & r"   test_underscore_names"TableDDLTest.test_underscore_namesT   s4     ((*VYY51u%r%   c                    V P                  4       pVP                  VR R7       RVn        VP                  \        P
                  ! V4      4       \        \        V4      P                  R4      RR/4       R# FrA   z	a commentr   textN)	r#   rC   commentr6   r   SetTableCommentr   r   get_table_commentr!   
connectionr.   s   && r"   test_add_table_comment#TableDDLTest.test_add_table_comment[   se     $$&ZE2#611%89J11,?[!	
r%   c                :   V P                  4       pVP                  VR R7       RVn        VP                  \        P
                  ! V4      4       VP                  \        P                  ! V4      4       \        \        V4      P                  R4      RR/4       R# rS   )
r#   rC   rU   r6   r   rV   DropTableCommentr   r   rW   rX   s   && r"   test_drop_table_comment$TableDDLTest.test_drop_table_commentg   s|     $$&ZE2#611%8962259:J11,?&$	
r%   c                   V P                  4       pVP                  \        P                  ! VR R7      4       \	        \        V4      P                  R4      4       VP                  \        P                  ! VR R7      4       R# )Tif_not_existsr   N)r#   r6   r   CreateTabler	   r   	has_tablerX   s   && r"   test_create_table_if_not_exists,TableDDLTest.test_create_table_if_not_existss   s`     $$&6--e4HI
#--l;<6--e4HIr%   c                b   V P                  4       w  r#VP                  \        P                  ! VR R7      4       \	        \        V4      P                  R4      4       \        R\        V4      P                  R4       Uu. uF  pVR,          NK  	  up9   4       VP                  \        P                  ! VR R7      4       \	        R\        V4      P                  R4       Uu. uF  pVR,          NK  	  up9   4       VP                  \        P                  ! VR R7      4       R# u upi u upi )Tra   r   r,   nameN)
r0   r6   r   rc   r	   r   rd   r   get_indexesCreateIndexr!   rY   r.   r/   ixs   &&   r"   test_create_index_if_not_exists,TableDDLTest.test_create_index_if_not_exists}   s    ..0
6--e4HI
#--l;< "*-99,GGB 6

G	
 	6--cFG "*-99,GGB 6

G	
 	6--cFG!s   ?D'
#D,
c                p   V P                  4       pVP                  V4       \        \        V4      P	                  R 4      4       VP                  \        P                  ! VRR7      4       \        \        V4      P	                  R 4      4       VP                  \        P                  ! VRR7      4       R# )r   T	if_existsN)	r#   rC   r	   r   rd   r6   r   	DropTabler   rX   s   && r"   test_drop_table_if_exists&TableDDLTest.test_drop_table_if_exists   s     $$&Z 
#--l;<6++ETBC$..|<=6++ETBCr%   c                   V P                  4       w  r#VP                  V4       \        R \        V4      P	                  R4       Uu. uF  pVR,          NK  	  up9   4       VP                  \        P                  ! VRR7      4       \        R \        V4      P	                  R4       Uu. uF  pVR,          NK  	  up9   4       VP                  \        P                  ! VRR7      4       R# u upi u upi )r,   r   rh   Trp   N)	r0   rC   r	   r   ri   r6   r   	DropIndexr   rk   s   &&   r"   test_drop_index_if_exists&TableDDLTest.test_drop_index_if_exists   s     ..0
Z  "*-99,GGB 6

G	
 	6++C4@A "*-99,GGB 6

G	
 	6++C4@A!s   C.
*C3
 )N)__name__
__module____qualname____firstlineno____sparse_driver_backend__r#   r)   r0   r=   r
   create_tabler   provide_metadatarE   schemasrI   
drop_tablerM   rP   comment_reflectionrZ   r^   table_ddl_if_existsre   index_ddl_if_existsrm   rs   rw   __static_attributes____classdictcell____classdict__s   @r"   r   r      s     $


2 	&  &
 	&   &
 	0  0
 	&  &
 $$	
  %
 $$	
  %
 %%	J  &J %%	H  &H2 %%	D  &D %%	B  &Br%   r   c                       ] tR t^tRtR# )FutureTableDDLTestry   N)rz   r{   r|   r}   r   ry   r%   r"   r   r      s    r%   r   c            	         a  ] tR t^t o RtRtR tR tR tR t	R t
]P                  ! RRRR]P                  P                  P                  4       3R	]P                  P                   P                  4       3R
R7      R 4       tRtV tR# )LongNameBlowoutTestzbtest the creation of a variety of DDL structures and ensure
label length limits pass on backends

Tc           
        R RRP                  R \        ^
4       4       4      ,           /pW1n        \        RV\	        R\
        RR7      RR7       \        R	.R
.4      p\        RV\	        R	4      VRR7       VP                  pVP                  V4       \        P                  P                  P                  '       d0   \        V4      pVP                  R4      pV^ ,          R,          pWX3# VR3# )fkzGforeign_key_%(table_name)s_%(column_0_N_name)s_%(referred_table_name)s__c              3   d   "   T F&  pR P                  R \        ^4       4       4      x  K(  	  R# 5i) c              3   N   "   T F  p\         P                  ! R 4      x  K  	  R# 5iabcdefNrandomchoice.0js   & r"   	<genexpr>3LongNameBlowoutTest.fk.<locals>.<genexpr>.<genexpr>        GYFMM(33Y   #%Njoinranger   is   & r"   r   )LongNameBlowoutTest.fk.<locals>.<genexpr>   -      & GGGU2YGGG&   .0a_things_with_stuffid_long_column_nameTr   )test_needs_fkaidz'a_things_with_stuff.id_long_column_nameb_related_things_of_valuerh   N)r   r   naming_conventionr   r   r   r   rh   
create_allr   requires&foreign_key_constraint_name_reflectionenabledr   get_foreign_keys)	r!   r    rY   
conventionconsactual_nameinspfksreflected_names	   &&&      r"   r   LongNameBlowoutTest.fk   s    '  "2Y 	


 &0"!('tD		
 $G?@
 	' 	
 iiJ'BBJJJ:&D''(CDC VF^N..$$r%   c                `   R RRP                  R \        ^
4       4       4      ,           /pW1n        \        RV\	        R\
        RR7      \	        R\
        RR7      4      pVP                  pVP                  pVP                  V4       \        V4      pVP                  R4      pVR	,          p	Wi3# )
pkz.primary_key_%(table_name)s_%(column_0_N_name)sr   c              3   d   "   T F&  pR P                  R \        ^4       4       4      x  K(  	  R# 5i)r   c              3   N   "   T F  p\         P                  ! R 4      x  K  	  R# 5ir   r   r   s   & r"   r   3LongNameBlowoutTest.pk.<locals>.<genexpr>.<genexpr>  r   r   Nr   r   s   & r"   r   )LongNameBlowoutTest.pk.<locals>.<genexpr>  r   r   r   r   Tr   id_another_long_namerh   )r   r   r   r   r   r   r   rh   r   r   get_pk_constraint)
r!   r    rY   r   ar   r   r   r   r   s
   &&&       r"   r   LongNameBlowoutTest.pk   s     "  "2Y 	

 &0"!('tD)7E	
 }}iiJ'z"##$9:F**r%   c           
        R RRP                  R \        ^
4       4       4      ,           /pW1n        \        RV\	        R\
        RR7      \	        R\
        4      4      p\        R	VP                  P                  VP                  P                  4      pVP                  pVP                  V4       \        V4      pVP                  R4      pV^ ,          R
,          p	Wi3# )rl   z(index_%(table_name)s_%(column_0_N_name)sr   c              3   d   "   T F&  pR P                  R \        ^4       4       4      x  K(  	  R# 5i)r   c              3   N   "   T F  p\         P                  ! R 4      x  K  	  R# 5ir   r   r   s   & r"   r   3LongNameBlowoutTest.ix.<locals>.<genexpr>.<genexpr>  r   r   Nr   r   s   & r"   r   )LongNameBlowoutTest.ix.<locals>.<genexpr>  r   r   r   r   Tr   r   Nrh   )r   r   r   r   r   r   r   r-   r   r   rh   r   r   ri   )
r!   r    rY   r   r   r   r   r   rl   r   s
   &&&       r"   rl   LongNameBlowoutTest.ix  s     "  "2Y 	

 &0"!('tD)73	
 T13322ACC4L4LMiiJ'z"34Av**r%   c           
     l   R RRP                  R \        ^
4       4       4      ,           /pW1n        \        RR4      p\	        RV\        R\        RR7      \        R\        4      V4       VP                  pVP                  V4       \        V4      pVP                  R4      pV^ ,          R	,          pWX3# )
uqz4unique_constraint_%(table_name)s_%(column_0_N_name)sr   c              3   d   "   T F&  pR P                  R \        ^4       4       4      x  K(  	  R# 5i)r   c              3   N   "   T F  p\         P                  ! R 4      x  K  	  R# 5ir   r   r   s   & r"   r   3LongNameBlowoutTest.uq.<locals>.<genexpr>.<genexpr>;  r   r   Nr   r   s   & r"   r   )LongNameBlowoutTest.uq.<locals>.<genexpr>:  r   r   r   r   r   Tr   rh   )r   r   r   r   r   r   r   rh   r   r   get_unique_constraints)	r!   r    rY   r   r   r   r   r   r   s	   &&&      r"   r   LongNameBlowoutTest.uq5  s     "  "2Y 	

 &0" 57MN!('tD)73	
 iiJ'z"(()>?Av**r%   c           
     j   R RRP                  R \        ^
4       4       4      ,           /pW1n        \        R4      p\	        RV\        R\        RR7      \        R	\        4      V4       VP                  pVP                  V4       \        V4      pVP                  R4      pV^ ,          R
,          pWX3# )ckzcheck_constraint_%(table_name)sr   c              3   d   "   T F&  pR P                  R \        ^4       4       4      x  K(  	  R# 5i)r   c              3   N   "   T F  p\         P                  ! R 4      x  K  	  R# 5ir   r   r   s   & r"   r   3LongNameBlowoutTest.ck.<locals>.<genexpr>.<genexpr>W  r   r   Nr   r   s   & r"   r   )LongNameBlowoutTest.ck.<locals>.<genexpr>V  r   r   zsome_long_column_name > 5r   r   Tr   some_long_column_namerh   )r   r   r   r   r   r   r   rh   r   r   get_check_constraints)	r!   r    rY   r   r   r   r   r   r   s	   &&&      r"   r   LongNameBlowoutTest.ckR  s    3 "2Y 

 &0":;!('tD*G4	
 iiJ'z"''(=>Av**r%   r   r   type_)argnamesc                   \        W4      ! W#4      w  rE\        V4      ^8  g   Q hVeY   V^ \        V4       p\        V4      \        V4      8  d%   \        V^ R V^ \        V4      ^,
           4       R# \        We4       R# R# )   N)getattrlenr   )r!   r   r    rY   r   r   overlaps   &&&&   r"   test_long_convention_name-LongNameBlowoutTest.test_long_convention_namen  s     '.d&:'
# ;#%%%%!!c.&9:G7|c+..GAbM>!c'lQ6F#GHG, &r%   ry   N)r   )r   )rl   )rz   r{   r|   r}   __doc__r~   r   r   rl   r   r   r   combinationsr   check_constraint_reflectionas_skipsunique_constraint_reflectionr   r   r   r   s   @r"   r   r      s     
 !%,%\+8+8+:+8 	w;;DDFG	w<<EEGH--r%   r   )r   r   r   )r   r   r   r   r   r   
assertionsr   r   r	   r
   r   r   r   r   r   r   r   r   r   r   TestBaser   FutureEngineMixinr   r   __all__ry   r%   r"   <module>r      s          !   !    $       aB8$$ aBH	33\ 	{-(++ {-| Hr%   