ó
    úÞ jÀ  ã                   ó¨   • S SK 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g)é    N)ÚColumn)ÚInteger)ÚMetaData)ÚTable)Úsqla_compaté   )ÚAutogenFixtureTesté   )Útesting)Úconfig)Úeq_)Úis_true)ÚTestBasec                   ó*  • \ rS rSrSrSrS rS rS rS r	\
R                  " S\" S	S
94\" S	S
9S4\" S	S
9\" S	SS94\" SS9\" SS94\" SSSSS9\" SSSSS94\" SSSS9\" SSSS945      \R                  R                  S 5       5       rS rS rSrg)ÚAutogenerateIdentityTesté   )Úidentity_columnsTc                 óh  • [        5       n[        5       n[        SU[        S[        R                  5      5        [        SU[        S[        R                  5      [        S[
        [        R                  " SSS9SS95        U R                  X5      n[        US	   S	   S
5        [        US	   S   S5        [        US	   S   R                  S5        US	   S   R                  n[        [        U[        R                  5      5        [        UR                  S5        [        UR                  S5        g )NÚuserÚotherÚidé   é   ©ÚstartÚ	incrementT©Úprimary_keyr   Ú
add_columné   r
   )r   r   r   ÚsaÚTextr   ÚIdentityÚ_fixturer   ÚnameÚidentityr   Ú
isinstancer   r   )ÚselfÚm1Úm2ÚdiffsÚis        Úe/var/www/html/gaurav/venv/lib/python3.13/site-packages/alembic/testing/suite/test_autogen_identity.pyÚtest_add_identity_columnÚ1AutogenerateIdentityTest.test_add_identity_column   sï   € Ü‹ZˆÜ‹Zˆäˆf�bœ& ¬"¯'©'Ó2Ô3äØØÜ�7œBŸG™GÓ$ÜØÜÜ—’ !¨qÑ1Ø ñ	ô	
	
ð —‘˜bÓ%ˆäˆE�!‰H�Q‰K˜Ô&ÜˆE�!‰H�Q‰K˜Ô ÜˆE�!‰H�Q‰K×Ñ˜dÔ#Ø�!‰H�Q‰K× Ñ ˆä”
˜1œbŸk™kÓ*Ô+ÜˆA�G‰G�QŒÜˆA�K‰K˜Õó    c                 ó   • [        5       n[        5       n[        SU[        S[        [        R
                  " SSS9SS95        [        SU5        U R                  X5      n[        US   S   S	5        [        US   S   S5        US   S   n[        UR                  S5        [        [        UR                  [        R
                  5      5        [        UR                  R                  S5        [        UR                  R                  S5        g )
Nr   r   r    r
   r   Tr   r   Úremove_column)r   r   r   r   r!   r#   r$   r   r%   r   r'   r&   r   r   )r(   r)   r*   r+   Úcs        r-   Útest_remove_identity_columnÚ4AutogenerateIdentityTest.test_remove_identity_column1   sÕ   € Ü‹ZˆÜ‹ZˆäØØÜØÜÜ—’ !¨qÑ1Ø ñ	ô		
ô 	ˆf�bÔà—‘˜bÓ%ˆäˆE�!‰H�Q‰K˜Ô)ÜˆE�!‰H�Q‰K˜Ô Ø�!‰H�Q‰KˆÜˆA�F‰F�DÔä”
˜1Ÿ:™:¤r§{¡{Ó3Ô4ÜˆA�J‰J×Ñ˜aÔ ÜˆA�J‰J× Ñ  !Õ$r0   c           
      óÚ   • [        5       n[        5       nX4 H3  n[        R                  " SS9n[        SU[	        S[
        U5      5        M5     U R                  X5      n[        U/ 5        g )Nr    ©r   r   r   )r   r!   r#   r   r   r   r$   r   )r(   r)   r*   ÚmÚid_r+   s         r-   Útest_no_change_identity_columnÚ7AutogenerateIdentityTest.test_no_change_identity_columnM   sX   € Ü‹ZˆÜ‹Zˆà“ˆAÜ—+’+ AÑ&ˆCÜ�&˜!œV D¬'°3Ó7Ö8ñ ð —‘˜bÓ%ˆäˆE�2�r0   c                 óü  • [        5       n[        5       n[        R                  (       a  SSS.nOSSS.n[        SU[	        S[
        [        R                  " SS95      5        [        R                  " SSS0UD6n[        SU[	        S[
        U5      5        U R                  X5      n[        R                  R                  S	:X  a+  [        [        U5      S
5        [        US   S   S   S5        g [        U/ 5        g )NT)Úoracle_on_nullÚoracle_order)Úon_nullÚorderr   r   r    r7   r   Úoracler   r   Úmodify_default© )r   r   Úidentity_has_dialect_kwargsr   r   r   r!   r#   r$   r   Údbr%   r   Úlenr   )r(   r)   r*   Úargsr9   r+   s         r-   Útest_dialect_kwargs_changesÚ4AutogenerateIdentityTest.test_dialect_kwargs_changesY   sÂ   € Ü‹ZˆÜ‹Zˆä×2×2Ø&*¸DÑA‰Dà#¨dÑ3ˆDäˆf�bœ& ¤w´·²À!Ñ0DÓEÔFÜ�kŠkÑ* Ð* TÑ*ˆÜˆf�bœ& ¤w°Ó4Ô5à—‘˜bÓ%ˆÜ�9‰9�>‰>˜XÓ%Ü”C˜“J Ô"Ü��a‘˜‘˜A‘Ð 0Õ1ä��r�Nr0   Nr    r7   r   r   F)Úalwaysr   r   éd   )r   ÚminvalueÚmaxvalueÚcycleé
   r
   i'  )r   r   rM   i  c           	      óv  • U(       a  [         R                  " S0 UD64OSnU(       a  [         R                  " S0 UD64OSn[        5       n[        5       n[        SU[	        S[
        /UQ76 [	        S[         R                  5      5        [        SU[	        S[
        /UQ76 [	        S[         R                  5      5        U R                  XV5      n[        [        US   5      S5        US   S   n[        US   S5        [        US   S5        [        US	   S5        US
   nUS   n	S n
U
" X5        U
" X)5        g )NrC   r   r   r   r   r   rB   r    r
   r   é   c                 óÒ   • U (       aR  [        [        U[        R                  5      5        U R	                  5        H  u  p#[        [        X5      U5        M     g [        US;   5        g )N)NF)r   r'   r!   r#   Úitemsr   Úgetattr)ÚkwÚidtÚkÚvs       r-   ÚcheckÚ<AutogenerateIdentityTest.test_change_identity.<locals>.check›   sG   € ÞÜœ
 3¬¯©Ó4Ô5ØŸH™HžJ‘D�AÜœ ›¨Ö+ò 'ô ˜˜}Ñ,Õ-r0   )
r!   r#   r   r   r   r   r"   r$   r   rF   )r(   ÚbeforeÚafterÚ
arg_beforeÚ	arg_afterr)   r*   r+   ÚoldÚnewrY   s              r-   Útest_change_identityÚ-AutogenerateIdentityTest.test_change_identitym   s  € ö  28”b—k’kÑ+ FÑ+Ñ-¸Rˆ
Þ/4”R—[’[Ñ) 5Ñ)Ñ+¸"ˆ	ä‹ZˆÜ‹ZˆäØØÜ�4œÐ. :Ò.Ü�7œBŸG™GÓ$ô		
ô 	ØØÜ�4œÐ- 9Ò-Ü�7œBŸG™GÓ$ô		
ð —‘˜bÓ%ˆäŒC��a‘‹M˜1ÔØ�a‘˜‘ˆÜˆE�!‰HÐ&Ô'ÜˆE�!‰H�fÔÜˆE�!‰H�dÔØ�A‰hˆØ�A‰hˆò	.ñ 	ˆfÔÙˆeÕr0   c                 ó¦  • [        5       n[        5       n[        SU[        S[        5      [        S[        R
                  5      5        [        SU[        S[        [        R                  " SSS95      [        S[        R
                  5      5        U R                  X5      n[        [        US   5      S5        US   S   n[        US   S	5        [        US   S5        [        US
   S5        [        US   S 5        US   n[        [        U[        R                  5      5        [        UR                  S5        [        UR                  S5        g )Nr   r   r   r    éè  ©r   rM   r   r   rB   r
   r   rQ   )r   r   r   r   r!   r"   r#   r$   r   rF   r   r'   r   rM   )r(   r)   r*   r+   Úaddeds        r-   Útest_add_identity_to_columnÚ4AutogenerateIdentityTest.test_add_identity_to_column¦   s  € Ü‹ZˆÜ‹ZˆäØØÜ�4œÓ!Ü�7œBŸG™GÓ$ô		
ô 	ØØÜ�4œ¤"§+¢+°AÀÑ"EÓFÜ�7œBŸG™GÓ$ô		
ð —‘˜bÓ%ˆäŒC��a‘‹M˜1ÔØ�a‘˜‘ˆÜˆE�!‰HÐ&Ô'ÜˆE�!‰H�fÔÜˆE�!‰H�dÔÜˆE�!‰H�dÔØ�a‘ˆä”
˜5¤"§+¡+Ó.Ô/ÜˆE�K‰K˜ÔÜˆE�N‰N˜DÕ!r0   c                 óN  • [        5       n[        5       n[        SU[        S[        [        R
                  " SSS95      [        S[        R                  5      5        [        SU[        S[        5      [        S[        R                  5      5        U R                  X5      n[        [        US   5      S5        US   S   n[        US   S	5        [        US   S5        [        US
   S5        [        US   S 5        US   n[        [        U[        R
                  5      5        g )Nr   r   r    rd   re   r   r   r   rB   r
   rQ   r   )r   r   r   r   r!   r#   r"   r$   r   rF   r   r'   )r(   r)   r*   r+   Úremoveds        r-   Ú test_remove_identity_from_columnÚ9AutogenerateIdentityTest.test_remove_identity_from_columnÆ   sï   € Ü‹ZˆÜ‹ZˆäØØÜ�4œ¤"§+¢+°AÀÑ"EÓFÜ�7œBŸG™GÓ$ô		
ô 	ØØÜ�4œÓ!Ü�7œBŸG™GÓ$ô		
ð —‘˜bÓ%ˆäŒC��a‘‹M˜1ÔØ�a‘˜‘ˆÜˆE�!‰HÐ&Ô'ÜˆE�!‰H�fÔÜˆE�!‰H�dÔÜˆE�!‰H�dÔØ˜‘(ˆä”
˜7¤B§K¡KÓ0Õ1r0   rC   )Ú__name__Ú
__module__Ú__qualname__Ú__firstlineno__Ú__requires__Ú__backend__r.   r4   r:   rH   r   ÚcombinationsÚdictr   ÚrequirementsÚidentity_columns_alterra   rg   rk   Ú__static_attributes__rC   r0   r-   r   r      sÞ   † Ø(€LØ€Kòò:%ò8
òð( ×ÒØ	‰t˜!‰}ÐÙ	�A‰˜ÐÙ	�A‰™ 1°Ñ2Ð3Ù	�UÑ	™T¨Ñ.Ð/á�q 1¨s¸$Ñ?Ù�q 1¨s¸%Ñ@ð	
ñ
 �r Q°Ñ6Ù�r Q°Ñ6ð	
óð ×Ñ×/Ñ/ñ(ó 0óð(òT"õ@2r0   r   )Ú
sqlalchemyr!   r   r   r   r   Úalembic.utilr   Ú_autogen_fixturesr	   Ú r   r   r   r   r   r   rC   r0   r-   Ú<module>r|      s:   ðÛ Ý Ý Ý Ý å $Ý 1Ý Ý Ý Ý Ý ôR2Ð1°8õ R2r0   