+
    }¯³j/  ã                   ó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   &&Úb/home/luca/screen-checking/.venv/lib/python3.14/site-packages/sqlalchemy/testing/suite/test_ddl.pyÚ_simple_fixtureÚTableDDLTest._simple_fixture"   s8   € ÜØØ�M‰MÜ�4œ¨dÀ%ÔHÜ�6œ6 "›:Ó&Øô
ð 	
ó    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   € ÜØØ�M‰MÜ�4œ¨dÀ%ÔHÜ�7œF 2›JÓ'ó	
ð 	
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   € Ü�Y‰Y�_‰_×Ô $Ø�L‰L˜Ÿ™›×.Ñ.Ð/?Ó@ÔAØ—\‘\ %§,¡,£.Ó1ˆFÜ�—‘“Ð 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   € ð ×$Ñ$Ó&ˆØ�‰”V—Y‘Y¨5ˆÔ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×,>Ñ,>Ð$Ó?ˆØ�‰”V—Y‘Y¨5ˆÔ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:   € ð ×$Ñ$Ó&ˆØ�‰”V—Y‘Y¨5ˆÔ1Ø�
‰
”6—9‘9¨ˆ
Ö/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   € ð ×(Ñ(Ó*ˆØ�‰”V—Y‘Y¨5ˆÔ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   € ð ×$Ñ$Ó&ˆØ�‰�Z¨EˆÔ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|   € ð ×$Ñ$Ó&ˆØ�‰�Z¨EˆÔ2Ø#ˆŒØ×Ñœ6×1Ò1°%Ó8Ô9Ø×Ñœ6×2Ò2°5Ó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×-Ò-¨eÀ4ÔHÔIä”˜
Ó#×-Ñ-¨lÓ;Ô<Ø×Ñœ6×-Ò-¨eÀ4Ô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×-Ò-¨eÀ4ÔHÔIÜ”˜
Ó#×-Ñ-¨lÓ;Ô<ÜØô " *Ó-×9Ñ9¸,ÔGóáG�Bð �6—
�
ÙGññô	
ð 	×Ñœ6×-Ò-¨cÀÔFÔGäØô " *Ó-×9Ñ9¸,ÔGóáG�Bð �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×+Ò+¨E¸TÔBÔCä”˜Ó$×.Ñ.¨|Ó<Ô=à×Ñœ6×+Ò+¨E¸TÔ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óáG�Bð �6—
�
ÙGññô	
ð 	×Ñœ6×+Ò+¨C¸4Ô@ÔAäØô " *Ó-×9Ñ9¸,ÔGóáG�Bð �6—
�
ÙGññô	
ð 	×Ñœ6×+Ò+¨C¸4Ô@Ö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>Ö   ó   é € ÐG¹Y¸œFŸMšM¨(×3Ð3»Yùó   ‚#%N©ÚjoinÚrange©rš   Úis   & r"   rœ   Ú)LongNameBlowoutTest.fk.<locals>.<genexpr>Õ   ó-   é € ð á&˜ð —G‘GÑG¼UÀ2¼YÓ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  € àð 'ð —‘ñ ä" 2œYóó õ	ð

ˆ
ð &0Ô"äØ!ØÜÐ(¬'¸tÔDØõ		
ô $ØˆGÐ?Ð@ó
ˆô 	Ø'ØÜØóð Øõ	
ð —i‘iˆà×Ñ˜JÔ'ä×Ñ×BÑB×J×JÐJÜ˜:Ó&ˆDØ×'Ñ'Ð(CÓDˆCØ  �V F�^ˆ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¶   € àð "ð —‘ñ ä" 2œYóó õð	
ˆ
ð &0Ô"äØ!ØÜÐ(¬'¸tÔDÜÐ)¬7ÀÔEó	
ˆð �}‰}ˆØ—i‘iˆà×Ñ˜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Ñ   € àð "ð —‘ñ ä" 2œYóó õð	
ˆ
ð &0Ô"äØ!ØÜÐ(¬'¸tÔDÜÐ)¬7Ó3ó	
ˆô �T˜1Ÿ3™3×2Ñ2°A·C±C×4LÑ4LÓMˆØ—i‘iˆà×Ñ˜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¾   € àð "ð —‘ñ ä" 2œYóó õð	
ˆ
ð &0Ô"äÐ 5Ð7MÓNˆÜØ!ØÜÐ(¬'¸tÔDÜÐ)¬7Ó3Øô	
ð —i‘iˆà×Ñ˜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à—‘ñ ä" 2œYóó õð
ˆ
ð &0Ô"äÐ:Ó;ˆÜØ!ØÜÐ(¬'¸tÔDÜÐ*¬GÓ4Øô	
ð —i‘iˆà×Ñ˜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 +Ó.Ô.Ü�G˜A˜b�M >°!´c¸'³lÀQÕ6FÐ#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%   