+
    }¯³jû&  ã                   ól  € ^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(                  ]P*                  4      t ! R R]P$                  4      t ! R R]P*                  4      tR# )é   )Úconfig)Úfixtures)Úeq_)Úis_true)Úrequirements)Únormalize_sequence)ÚColumn)ÚTable)Úinspect)ÚInteger)ÚMetaData)ÚSequence)ÚString)Útestingc                   ó  a € ] tR t^t o RtRtRt]R 4       tR t	R t
R t]P                  R 4       tR tR	 t]P$                  ! RRR
R7      ]P&                  P(                  R 4       4       t]P&                  P(                  R 4       tRtV tR# )ÚSequenceTestTÚeachc                óú  € \        R V\        R\        \        \        \        R4      4      RR7      \        R\        ^24      4      4       \        RV\        R\        \        \        \        R\        RR7      4      RR7      \        R\        ^24      4      4       \        RV\        R\        \        \        \        R	4      4      RR7      \        R\        ^24      4      R
R7       \        P                  P                  P                  '       dm   \        RV\        R\        \        \        \        R\        P                  R7      4      RR7      \        R\        ^24      4      R
\        P                  R7       R# R# )Úseq_pkÚidÚ
tab_id_seqT©Úprimary_keyÚdataÚ
seq_opt_pk)Ú	data_typeÚoptionalÚseq_no_returningÚnoret_id_seqF)Úimplicit_returningÚseq_no_returning_schÚnoret_sch_id_seq©Úschema©r    r$   N)r
   r	   r   r   r   r   r   r   ÚrequiresÚschemasÚenabledÚtest_schema©ÚclsÚmetadatas   &&Úg/home/luca/screen-checking/.venv/lib/python3.14/site-packages/sqlalchemy/testing/suite/test_sequence.pyÚdefine_tablesÚSequenceTest.define_tables   sG  € äØØÜØÜÜ"¤6¬8°LÓ+AÓBØ ô	ô �6œ6 "›:Ó&ô
	
ô 	ØØÜØÜÜ"ÜÜ˜\´WÀtÔLóð !ôô �6œ6 "›:Ó&ô	
ô 	ØØÜØÜÜ"¤6¬8°NÓ+CÓDØ ô	ô �6œ6 "›:Ó&Ø$õ	
ô ×Ñ×#Ñ#×+×+Ð+ÜØ&ØÜØÜÜ&ÜÜ Ø.´v×7IÑ7Iôóð !%ô
ô �vœv b›zÓ*Ø#(Ü×)Ñ)÷!ñ ,ó    c                óÎ   € VP                  V P                  P                  P                  4       \	        R R7      4       V P                  V P                  P                  V4       R# ©ú	some data©r   N)ÚexecuteÚtablesr   ÚinsertÚdictÚ_assert_round_trip©ÚselfÚ
connections   &&r-   Útest_insert_roundtripÚ"SequenceTest.test_insert_roundtrip]   sD   € Ø×Ñ˜4Ÿ;™;×-Ñ-×4Ñ4Ó6¼À+Ô8NÔOØ×Ñ §¡× 2Ñ 2°JÖ?r0   c                óô   € VP                  V P                  P                  P                  4       \	        R R7      4      p\        VP                  \        P                  P                  P                  34       R# r2   )r5   r6   r   r7   r8   r   Úinserted_primary_keyr   ÚdbÚdialectÚdefault_sequence_base©r;   r<   Úrs   && r-   Útest_insert_lastrowidÚ"SequenceTest.test_insert_lastrowida   sW   € Ø×ÑØ�K‰K×Ñ×%Ñ%Ó'¬°;Ô)?ó
ˆô 	Ø×"Ñ"¤W§Z¡Z×%7Ñ%7×%MÑ%MÐ$Oö	
r0   c                óè   € VP                  V P                  P                  P                  P                  P
                  4      p\        V\        P                  P                  P                  4       R # ©N)Úscalarr6   r   Úcr   Údefaultr   r   rA   rB   rC   rD   s   && r-   Útest_nextval_directÚ SequenceTest.test_nextval_directi   sH   € Ø×Ñ˜dŸk™k×0Ñ0×2Ñ2×5Ñ5×=Ñ=Ó>ˆÜˆAŒw�z‰z×!Ñ!×7Ñ7Ö8r0   c                ó®   € VP                  V P                  P                  P                  4       \	        R R7      4      p\        VP                  R4       R# )r3   r4   N)é   )r5   r6   r   r7   r8   r   r@   rD   s   && r-   Útest_optional_seqÚSequenceTest.test_optional_seqm   sA   € à×ÑØ�K‰K×"Ñ"×)Ñ)Ó+¬T°{Ô-Có
ˆô 	ˆA×"Ñ" DÖ)r0   c                óÀ   € VP                  VP                  4       4      P                  4       p\        V\        P
                  P                  P                  R 34       R# )r3   N)r5   ÚselectÚfirstr   r   rA   rB   rC   )r;   ÚtableÚconnÚrows   &&& r-   r9   ÚSequenceTest._assert_round_tript   s>   € Ø�l‰l˜5Ÿ<™<›>Ó*×0Ñ0Ó2ˆÜˆC”'—*‘*×$Ñ$×:Ñ:¸KÐHÖIr0   c                óÎ   € VP                  V P                  P                  P                  4       \	        R R7      4       V P                  V P                  P                  V4       R# r2   )r5   r6   r   r7   r8   r9   r:   s   &&r-   Ú+test_insert_roundtrip_no_implicit_returningÚ8SequenceTest.test_insert_roundtrip_no_implicit_returningx   sI   € Ø×ÑØ�K‰K×(Ñ(×/Ñ/Ó1´4¸[Ô3Iô	
ð 	×Ñ §¡× <Ñ <¸jÖIr0   r    )Úargnamesc                ól  € \        R \        4       \        R\        \	        \
        \        RRR7      4      RR7      \        R\        ^24      4      VRR7      pVP                  R\
        P                  /R	7      pVP                  VP                  4       \        R
R7      4       V P                  W14       R# )r!   r   r"   Ú
alt_schemar#   Tr   r   r%   ©Úschema_translate_mapr3   r4   N)r
   r   r	   r   r   r   r   r   Úexecution_optionsr)   r5   r7   r8   r9   )r;   r<   r    r   s   &&& r-   Útest_insert_roundtrip_translateÚ,SequenceTest.test_insert_roundtrip_translate~   sª   € ô !Ø"Ü‹JÜØÜÜ"ÜœHÐ%7ÀÔMóð !ôô �6œ6 "›:Ó&Ø1Øô
Ðð   ×1Ñ1Ø".´×0BÑ0BÐ!Cð 2ó 
ˆ
ð 	×ÑÐ+×2Ñ2Ó4´dÀÔ6LÔMØ×ÑÐ 0Ö=r0   c                óþ   € \        \        \        R RR7      4      pVP                  R\        P                  /R7      pVP                  V4      p\        V\        P                  P                  P                  4       R# )r"   r_   r#   r`   N)r   r   r   rb   r)   rJ   r   r   rA   rB   rC   )r;   r<   ÚseqrE   s   &&  r-   Ú$test_nextval_direct_schema_translateÚ1SequenceTest.test_nextval_direct_schema_translate—   sj   € ä Ü”HÐ/¸ÔEó
ˆð  ×1Ñ1Ø".´×0BÑ0BÐ!Cð 2ó 
ˆ
ð ×Ñ˜cÓ"ˆÜˆAŒw�z‰z×!Ñ!×7Ñ7Ö8r0   © N©Ú	sequences)T)F)Ú__name__Ú
__module__Ú__qualname__Ú__firstlineno__Ú__requires__Ú__sparse_driver_backend__Úrun_create_tablesÚclassmethodr.   r=   rF   rM   r   Úsequences_optionalrQ   r9   r[   r   Úcombinationsr&   r'   rc   rg   Ú__static_attributes__Ú__classdictcell__©Ú__classdict__s   @r-   r   r      s¸   ø‡ € Ø!€LØ $ÐàÐàñ;ó ð;òz@ò
ò9ð ×$Ñ$ñ*ó %ð*òJòJð ×Ò˜' 8Ð6JÔKØ×Ñ×Ññ>ó ó Lð>ð. ×Ñ×Ññ	9ó ö	9r0   r   c                   ó.   a € ] tR t^¤t o RtRtR tRtV tR# )ÚSequenceCompilerTestTc                ó¼  € \        R \        4       \        R\        \	        \
        \        R4      4      4      \        R\        4      4      pVP                  4       P                  ^R7      pVP                  P                  RVP                  R7      P                  \	        \
        \        R4      4      4      pV P                  VRV: R2R	VP                  R
7       R# )ÚxÚyÚy_seqÚq)r€   N)Ú	statementrB   zINSERT INTO x (y, q) VALUES (z, 5)T)Úliteral_bindsrB   )r
   r   r	   r   r   r   r   r7   ÚvaluesrB   Ústatement_compilerÚvisit_sequenceÚassert_compile)r;   r<   rV   ÚstmtÚseq_nextvals   &&   r-   Ú!test_literal_binds_inline_compileÚ6SequenceCompilerTest.test_literal_binds_inline_compile¨   sÁ   € ÜØÜ‹JÜØ”WÔ0´¼À'Ó9JÓKóô �3œÓ ó
ˆð �|‰|‹~×$Ñ$ qÐ$Ó)ˆà ×(Ñ(×;Ñ;Ø J×$6Ñ$6ð <ó 
ç
‰.Ô+¬F´H¸WÓ4EÓFÓ
Gð 	ð 	×ÑÙÛ5@ÐBØØ×&Ñ&ð	 	ö 	
r0   ri   Nrj   )	rl   rm   rn   ro   rp   rq   r‰   rv   rw   rx   s   @r-   r{   r{   ¤   s   ø‡ € Ø!€LØ $Ð÷
ð 
r0   r{   c                   óª  a € ] tR t^¿t o RtRtRt]R 4       tR t	R t
R t]P                  P                  R 4       tR t]P                  P                  R	 4       t]P                  P                  R
 4       t]P                  P                  R 4       tR t]P                  P                  R 4       t]P                  P                  R 4       tRtV tR# )ÚHasSequenceTestNTc           
     ó¬  € \        \        \        R VR7      4       \        \        \        RVRRR7      4       \        P                  P
                  P                  '       dU   \        \        \        R \        P                  VR7      4       \        \        \        R\        P                  VR7      4       \        RV\        R\        RR	7      4       R
# )Úuser_id_seq©r,   Ú	other_seqT)r,   Ú
nomaxvalueÚ
nominvalue)r$   r,   Ú
schema_seqÚuser_id_tabler   r   N)r   r   r   r   r&   r'   r(   r)   r
   r	   r   r*   s   &&r-   r.   ÚHasSequenceTest.define_tablesÅ   sª   € äœ6¤8¨MÀHÔ#MÔNÜÜÜØØ!ØØô	ô	
ô ×Ñ×#Ñ#×+×+Ð+ÜÜÜØ!¬&×*<Ñ*<Àxôôô ÜÜØ ¬×);Ñ);Àhôôô 	ØØÜ�4œ¨dÔ3ö	
r0   c                óN   € \        \        V4      P                  R 4      R4       R# )rŽ   TN©r   r   Úhas_sequencer:   s   &&r-   Útest_has_sequenceÚ!HasSequenceTest.test_has_sequenceä   s   € ÜŒG�JÓ×,Ñ,¨]Ó;¸TÖBr0   c                ó¼  € \        V4      p\        VP                  R 4      R4       \        \        \        RVR7      4      p\        VP                  R4      R4       VP                  V4        \        VP                  R4      R4       VP                  4        \        VP                  R4      R4       VP                  V4       R#   TP                  T4       i ; i)rŽ   TÚnew_seqr�   FN)	r   r   r˜   r   r   r   ÚcreateÚclear_cacheÚdrop)r;   r<   r,   ÚinspÚsss   &&&  r-   Útest_has_sequence_cacheÚ'HasSequenceTest.test_has_sequence_cacheç   s©   € Ü�zÓ"ˆÜˆD×Ñ˜mÓ,¨dÔ3Ü¤¬°ÀXÔ(NÓOˆÜˆD×Ñ˜iÓ(¨%Ô0Ø
�	‰	�*Ôð	 Ü�×!Ñ! )Ó,¨eÔ4Ø×ÑÔÜ�×!Ñ! )Ó,¨dÔ3à�G‰G�JÖøˆB�G‰G�JÕús   Á/AC ÃCc                óN   € \        \        V4      P                  R 4      R4       R# )r”   FNr—   r:   s   &&r-   Útest_has_sequence_other_objectÚ.HasSequenceTest.test_has_sequence_other_objectô   ó   € ÜŒG�JÓ×,Ñ,¨_Ó=¸uÖEr0   c                ón   € \        \        V4      P                  R \        P                  R7      R4       R# )rŽ   r#   TN©r   r   r˜   r   r)   r:   s   &&r-   Útest_has_sequence_schemaÚ(HasSequenceTest.test_has_sequence_schema÷   s2   € äÜ�JÓ×,Ñ,Ø¤f×&8Ñ&8ð -ó ð ö		
r0   c                óN   € \        \        V4      P                  R 4      R4       R# )Úsome_sequenceFNr—   r:   s   &&r-   Útest_has_sequence_negÚ%HasSequenceTest.test_has_sequence_neg   r§   r0   c                ón   € \        \        V4      P                  R \        P                  R7      R4       R# )r­   r#   FNr©   r:   s   &&r-   Útest_has_sequence_schemas_negÚ-HasSequenceTest.test_has_sequence_schemas_neg  s2   € äÜ�JÓ×,Ñ,Ø¬×(:Ñ(:ð -ó ð ö		
r0   c                ón   € \        \        V4      P                  R \        P                  R7      R4       R# )Úother_sequencer#   FNr©   r:   s   &&r-   Ú'test_has_sequence_default_not_in_remoteÚ7HasSequenceTest.test_has_sequence_default_not_in_remote  s2   € äÜ�JÓ×,Ñ,Ø ¬×);Ñ);ð -ó ð ö		
r0   c                óN   € \        \        V4      P                  R 4      R4       R# )r“   FNr—   r:   s   &&r-   Ú'test_has_sequence_remote_not_in_defaultÚ7HasSequenceTest.test_has_sequence_remote_not_in_default  s   € äŒG�JÓ×,Ñ,¨\Ó:¸EÖBr0   c                ó¨   € R R0p\        \        V4      P                  4       4      p\        VP	                  V4      V8H  4       \        RV9  4       R# )r�   rŽ   r“   N)Úsetr   Úget_sequence_namesr   Úintersection)r;   r<   ÚexpÚress   &&  r-   Útest_get_sequence_namesÚ'HasSequenceTest.test_get_sequence_names  sI   € Ø˜MÐ*ˆä”'˜*Ó%×8Ñ8Ó:Ó;ˆÜ�× Ñ  Ó%¨Ñ,Ô-Ü� CÑ'Ö(r0   c                ól   € \        \        V4      P                  \        P                  R 7      . 4       R# )r#   N)r   r   r¼   r   Útest_schema_2r:   s   &&r-   Ú*test_get_sequence_names_no_sequence_schemaÚ:HasSequenceTest.test_get_sequence_names_no_sequence_schema   s0   € äÜ�JÓ×2Ñ2Ü×+Ñ+ð 3ó ð ö		
r0   c                ó‚   € \        \        \        V4      P                  \        P
                  R 7      4      RR.4       R# )r#   r“   rŽ   N)r   Úsortedr   r¼   r   r)   r:   s   &&r-   Ú(test_get_sequence_names_sequences_schemaÚ8HasSequenceTest.test_get_sequence_names_sequences_schema)  s=   € äÜÜ˜
Ó#×6Ñ6Ü!×-Ñ-ð 7ó óð
 ˜=Ð)ö	
r0   ri   rj   )rl   rm   rn   ro   Úrun_deletesrp   rq   rs   r.   r™   r¢   r¥   r   r&   r'   rª   r®   r±   rµ   r¸   rÀ   rÄ   rÈ   rv   rw   rx   s   @r-   rŒ   rŒ   ¿   s  ø‡ € Ø€Kà!€LØ $Ðàñ
ó ð
ò<Cò òFð ×Ñ×Ññ
ó ð
òFð ×Ñ×Ññ
ó ð
ð ×Ñ×Ññ
ó ð
ð ×Ñ×ÑñCó ðCò)ð ×Ñ×Ññ
ó ð
ð ×Ñ×Ññ
ó ö
r0   rŒ   c                   ó.   a € ] tR tRt o RtRtR tRtV tR# )ÚHasSequenceTestEmptyi5  Tc                óL   € \        \        V4      P                  4       . 4       R # rI   )r   r   r¼   r:   s   &&r-   Ú#test_get_sequence_names_no_sequenceÚ8HasSequenceTestEmpty.test_get_sequence_names_no_sequence9  s   € ÜÜ�JÓ×2Ñ2Ó4Øö	
r0   ri   Nrj   )	rl   rm   rn   ro   rp   rq   rÎ   rv   rw   rx   s   @r-   rÌ   rÌ   5  s   ø‡ € Ø!€LØ $Ð÷
ð 
r0   rÌ   N)Ú r   r   Ú
assertionsr   r   r   Ú	provisionr   r$   r	   r
   r   r   r   r   r   r   Ú
TablesTestr   ÚAssertsCompiledSQLÚTestBaser{   rŒ   rÌ   ri   r0   r-   Ú<module>rÖ      s‡   ðõ Ý Ý Ý  Ý !Ý *Ý Ý Ý Ý Ý Ý Ý Ý ôH9�8×&Ñ&ô H9ôV
˜7×5Ñ5°x×7HÑ7Hô 
ô6s
�h×)Ñ)ô s
ôl
˜8×,Ñ,ö 
r0   