Ë
    ïÏj�-  ã                  ó¢  — U d dl mZ d dlmZ d dlZd dlmZ d dlZd dlZd dl	Z	d dl
Z
d dlmZ d dlmZ d dlmZ d dlmZ d d	lmZ d d
lmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlm Z! d dl"m#Z# d dl$Z$ddl%m&Z& ddl'm(Z( ddl)m*Z* ddl+m,Z, ddl-m.Z. ddl/m0Z0  ejb                  «       Z2e2jg                  dg«        G d„ d e!«      Z da4 G d!„ d"e e«      Zd-d#„Z5i Z6d$e7d%<   ee	 	 	 	 	 	 d.d&„«       «       Z8ee	 	 	 	 d/d'„«       «       Z8e	 	 	 	 d0d(„«       Z8e	 	 	 	 d/d)„«       Z9	 	 	 	 	 d1d*„Z: G d+„ d,«      Z;y)2é    )Úannotations)Ú	GeneratorN)Úcontextmanager)ÚAny)ÚLiteral)Úoverload)ÚColumn©Úcreate_mock_engine)Úinspect)ÚMetaData)ÚString)ÚTable)Útesting)Útext)Úconfig)Úmock)Úeq_)Ú
TablesTest)ÚTestBase)Údrop_all_tables_from_metadataé   )Ú_get_dialect)Ú_get_staging_directoryé   )ÚEnvironmentContext)ÚMigrationContext)Ú
Operations)Úsqla_compatztest.cfgc                  óf  — e Zd Z ej                  «       d„ «       Zedd„«       Z ej                  «       d„ «       Z ej                  «       d„ «       Z	ej                  d„ «       Z
ej                  d„ «       Zej                  d„ «       Zej                  d„ «       Z ej                  «       d	„ «       Zy
)r   c              #  ó®  K  — d –— t        «       }t        j                  |«      D ]«  }t        j                  j	                  ||«      }t        j                  j                  |«      st        j                  j                  |«      rt        j                  |«       Œwt        j                  j                  |«      sŒ—t        j                  |«       Œ­ y ­w©N)r   ÚosÚlistdirÚpathÚjoinÚisfileÚislinkÚunlinkÚisdirÚshutilÚrmtree)ÚselfÚlocationÚfilenameÚ	file_paths       úU/var/www/html/gaurav-v2/venv/lib/python3.12/site-packages/alembic/testing/fixtures.pyÚclear_staging_dirzTestBase.clear_staging_dir*   s   è ø€ ãÜ)Ó+ˆÜŸ
™
 8Ö,ˆHÜŸ™Ÿ™ X¨xÓ8ˆIÜ�w‰w�~‰~˜iÔ(¬B¯G©G¯N©N¸9Ô,EÜ—	‘	˜)Õ$Ü—‘—‘˜yÕ)Ü—‘˜iÕ(ñ -ùs   ‚B:CÂ=Cc              #  óÆ   K  — t        j                  «       }	 t        j                  |«       d –— t        j                  |«       y # t        j                  |«       w xY w­wr"   )r#   ÚgetcwdÚchdir)r-   ÚdirnameÚcurrent_dirs      r1   ÚpushdzTestBase.pushd5   s=   è ø€ ä—i‘i“kˆð	"Ü�H‰H�WÔÛä�H‰H�[Õ!øŒB�H‰H�[Õ!üs   ‚A!˜A ±A!ÁAÁA!c              #  óT   K  — d –— t         j                  j                  dd «       y ­w)NÚALEMBIC_CONFIG)r#   ÚenvironÚpop©r-   s    r1   Úpop_alembic_config_envzTestBase.pop_alembic_config_env>   s   è ø€ ãÜ
�
‰
�‰Ð'¨Õ.ùs   ‚&(c              #  ót   K  — |j                  d¬«      5  t        |«      –— d d d «       y # 1 sw Y   y xY w­w)NT)Ú_per_migration)Úbegin_transactionr   )r-   Úmigration_contexts     r1   Úops_contextzTestBase.ops_contextC   s/   è ø€ à×0Ñ0ÀÐ0ÕEÜÐ.Ó/Ò/÷ F×EÑEüs   ‚8•,£	8¬5±8c                óD   — t        j                  |t        d¬«      ¬«      S )NT)Útransaction_per_migration©Úopts©r   Ú	configureÚdict©r-   Ú
connections     r1   rB   zTestBase.migration_contextH   s   € ä×)Ñ)ØœT¸DÔAô
ð 	
ó    c                óF   — t        j                  |t        dd¬«      ¬«      S )NT)rE   Úas_sqlrF   rH   rK   s     r1   Úas_sql_migration_contextz!TestBase.as_sql_migration_contextN   s!   € ä×)Ñ)ØœT¸DÈÔNô
ð 	
rM   c              #  ó‚   K  — t         j                  j                  «       5 }|a|–— d ad d d «       y # 1 sw Y   y xY w­wr"   )r   ÚdbÚconnectÚ_connection_fixture_connection)r-   Úconns     r1   rL   zTestBase.connectionT   s6   è ø€ ô �Y‰Y×ÑÔ  DØ-1Ð*ØŠJà-1Ð*÷	 !× Ñ üs   ‚?¡	3ª	?³<¸?c              #  óZ   ‡‡K  — dŠdŠˆˆfd„}|–— ‰�‰�‰‰j                   _        yyy­w)z'Restore runners for modified operationsNc                óR   •— | j                   j                  j                  «       Š| Šy r"   )Ú_to_implÚ	_registryÚcopy)Ú_op_clsÚop_clsÚsaved_implss    €€r1   Ú_save_attrsz0TestBase.restore_operations.<locals>._save_attrse   s"   ø€ à!×*Ñ*×4Ñ4×9Ñ9Ó;ˆKØ‰FrM   )rX   rY   )r-   r^   r\   r]   s     @@r1   Úrestore_operationszTestBase.restore_operations^   s?   ùè ø€ ð ˆØˆõ	ð
 ÒàÐ +Ð"9Ø(3ˆF�O‰OÕ%ð #:Ðùs   „'+c              #  óž  K  — ddl m} |j                  «       }||j                  _        |–— |j                  `t
        rft
        j                  «       rRt
        j                  «       }|j                  «        t
        j                  «       5  t        |t
        «       ddd«       yt        |t        j                  «       y# 1 sw Y   yxY w­w)z>Provide bound MetaData for a single test, dropping afterwards.r   )ÚschemaN)Úsqlalchemy.sqlra   r   ÚinstanceÚmetadatarT   Úin_transactionÚget_transactionÚrollbackÚbeginr   r   rR   )r-   Úrequestra   rd   Útranss        r1   rd   zTestBase.metadatao   s™   è ø€ õ 	*à—?‘?Ó$ˆØ$,ˆ×ÑÔ!ØŠØ×ÑÐ%õ +Ü.×=Ñ=Ô?ä2×BÑBÓDˆEØ�N‰NÔÜ/×5Ñ5Õ7Ü-ØÔ<ô÷ 8Ð7ô
 *¨(´F·I±IÕ>÷ 8Ð7üs   ‚B
CÂCÂ$CÃC
ÃCN)ÚreturnzGenerator[None])Ú__name__Ú
__module__Ú__qualname__r   Úfixturer2   r   r8   r>   rC   rB   rP   rL   r_   r   rd   © rM   r1   r   r   )   sè   „ Ø€W‡_�_Óñ)ó ð)ð ò"ó ð"ð €W‡_�_Óñ/ó ð/ð €W‡_�_Óñ0ó ð0ð ‡_�_ñ
ó ð
ð
 ‡_�_ñ
ó ð
ð
 ‡_�_ñ2ó ð2ð ‡_�_ñ4ó ð4ð  €V‡^�^Óñ?ó ñ?rM   r   c                  ó   — e Zd Zy)r   N)rl   rm   rn   rp   rM   r1   r   r   ‹   s   „ ØrM   r   c                ó6   ‡‡— g Šˆˆfd„}t        | |«      Š‰‰fS )Nc                ón   •— ‰j                  t        | j                  ‰j                  ¬«      «      «       y ©N)Údialect)ÚappendÚstrÚcompileru   )ÚsqlÚmultiparamsÚparamsÚbufÚengines      €€r1   Údumpzcapture_db.<locals>.dump’   s#   ø€ Ø�
‰
”3�s—{‘{¨6¯>©>�{Ó:Ó;Õ<rM   r
   )ru   r~   r|   r}   s     @@r1   Ú
capture_dbr   �   s%   ù€ Ø
€Cõ=ô   ¨Ó.€FØ�3ˆ;ÐrM   zdict[Any, Any]Ú_engsc                 ó   — y r"   rp   )Úbytes_ioÚkws     r1   Úcapture_context_bufferr„   œ   s   € ð  rM   c                  ó   — y r"   rp   )rƒ   s    r1   r„   r„   £   s   € ð !rM   c               +  óV  ‡ ‡K  — ‰ j                  dd«      rt        j                  «       }nt        j                  «       }‰ j	                  d|dœ«       t
        j                  Šˆˆ fd„}t        j                  j                  t
        d|«      5  |–— d d d «       y # 1 sw Y   y xY w­w)Nr‚   FÚsqlite)Údialect_nameÚoutput_bufferc                 ó8   •—  |j                   di ‰¤Ž  ‰| i |¤ŽS ©Nrp   ©Úupdate©ÚargÚoptÚconfrƒ   s     €€r1   rI   z)capture_context_buffer.<locals>.configure¶   ó$   ø€ Øˆ�
‰
Ñ�RÒÙ�SÐ ˜CÑ Ð rM   rI   )
r<   ÚioÚBytesIOÚStringIOr�   r   rI   r   ÚpatchÚobject)rƒ   r|   rI   r‘   s   `  @r1   r„   r„   ª   sx   ùè ø€ ð 
‡v�vˆj˜%Ô Ü�j‰j‹l‰ä�k‰k‹mˆà‡I�I˜x¸#Ñ>Ô?Ü×'Ñ'€Dõ!ô 
�‰×	Ñ	Ô-¨{¸IÕ	FØŠ	÷ 
G×	FÑ	Füs   „BB)ÂBÂ	B)ÂB&Â"B)c               +  ó‚  ‡ ‡‡K  — ddl m} ddlm} t	        j
                  «       Š |«       }|j                  «       }|j                  |d«      ˆfd„«       }‰ j                  d|i«       t        j                  Šˆˆ fd„}t        j                  j                  t        d	|«      5  ‰–— d d d «       y # 1 sw Y   y xY w­w)
Nr   )Ú_sqlite_file_dbr   )ÚeventÚbefore_cursor_executec                ó.   •— ‰j                  |dz   «       y )NÚ
)Úwrite)rU   ÚcursorÚ	statementÚ
parametersÚcontextÚexecutemanyr|   s         €r1   Úbcez*capture_engine_context_buffer.<locals>.bceË   s   ø€ à�	‰	�)˜dÑ"Õ#rM   rL   c                 ó8   •—  |j                   di ‰¤Ž  ‰| i |¤ŽS r‹   rŒ   rŽ   s     €€r1   rI   z0capture_engine_context_buffer.<locals>.configureÒ   r’   rM   rI   )Úenvr™   Ú
sqlalchemyrš   r“   r•   rS   Úlistens_forr�   r   rI   r   r–   r—   )	rƒ   r™   rš   ÚengrU   r¤   rI   r|   r‘   s	   `      @@r1   Úcapture_engine_context_bufferrª   ¾   sš   úè ø€ õ %Ý ä
�+‰+‹-€Cá
Ó
€Cà�;‰;‹=€Dà
×Ñ�tÐ4Ó5ó$ó 6ð$ð ‡I�Iˆ|˜TÐ"Ô#Ü×'Ñ'€Dõ!ô 
�‰×	Ñ	Ô-¨{¸IÕ	FØŠ	÷ 
G×	FÑ	Füs   …B B?Â%B3Â*	B?Â3B<Â8B?c                ój  ‡‡‡— i }|rt        |¬«      |d<    G ˆfd„d«      } |«       Š G ˆfd„dt        «      }‰r‰|d<   |r||d<   t        | «      Š|�|‰_        d	‰_        ‰sˆˆfd
„}t        j                  ‰|¬«      }	n‰|d<   d }	 |‰|	|«      }
t        |
«      t        j                  _
        |
S )N)Únaming_conventionÚtarget_metadatac                  ó$   •— e Zd Zd„ Zˆ fd„Zd„ Zy)úop_fixture.<locals>.buffer_c                ó   — g | _         y r"   ©Úlinesr=   s    r1   Ú__init__z$op_fixture.<locals>.buffer_.__init__æ   s	   € ØˆD�JrM   c                óê   •— |j                  «       }t        j                  dd|«      }‰r.t        j                  dd|«      }t        j                  dd|«      }| j                  j	                  |«       y )Nú[\n\t]Ú z    z\;\n*$)ÚstripÚreÚsubr²   rv   )r-   ÚmsgrO   s     €r1   rž   z!op_fixture.<locals>.buffer_.writeé   s[   ø€ Ø—)‘)“+ˆCÜ—&‘&˜ B¨Ó,ˆCÙô —f‘f˜W b¨#Ó.�Ü—f‘f˜Y¨¨CÓ0�à�J‰J×Ñ˜cÕ"rM   c                 ó   — y r"   rp   r=   s    r1   Úflushz!op_fixture.<locals>.buffer_.flushô   s   € ØrM   N)rl   rm   rn   r³   rž   r¼   )rO   s   €r1   Úbuffer_r¯   å   s   ø„ ò	ô		#ó	rM   r½   c                  ó6   •— e Zd Zˆ fd„Zˆ fd„Zˆ fd„Zˆ fd„Zy)úop_fixture.<locals>.ctxc                ó   •— ‰S r"   rp   ©r-   r|   s    €r1   Úget_bufzop_fixture.<locals>.ctx.get_bufú   s   ø€ ØˆJrM   c                ó$   •— g ‰j                   d d  y r"   r±   rÁ   s    €r1   Úclear_assertionsz(op_fixture.<locals>.ctx.clear_assertionsý   s   ø€ ØˆC�I‰I‘a‰LrM   c                ó‚   •— t        ‰j                  |D �cg c]  }t        j                  dd|«      ‘Œ c}«       y c c}w )Nrµ   r¶   )r   r²   r¸   r¹   )r-   ry   Úsr|   s      €r1   Úassert_zop_fixture.<locals>.ctx.assert_   s2   ø€ ô �—	‘	¹cÓB¹c¸œBŸF™F 9¨b°!Õ4¸cÑBÕCùÒBs   –<
c                óŠ   •— ‰j                   D ]  }t        j                  dd|«      |v sŒ y  J d|›d‰j                   ›�«       ‚)Nrµ   r¶   zCould not locate fragment z in )r²   r¸   r¹   )r-   ry   Ústmtr|   s      €r1   Úassert_containsz'op_fixture.<locals>.ctx.assert_contains  sD   ø€ ØŸ	œ	�Ü—6‘6˜) R¨Ó-°Ò5Ùð "ñÚØ—I’Iðó �urM   N)rl   rm   rn   rÂ   rÄ   rÇ   rÊ   )r|   s   €r1   Úctxr¿   ù   s   ø„ ô	ô	ô	Dõ
	rM   rË   rO   Úliteral_bindsTc                ó°   •— t        | t        «      rt        | «      } | j                  sJ ‚t        | j	                  ‰¬«      «      }‰j                  |«       y rt   )Ú
isinstancerw   r   Úsupports_executionrx   rž   )rÉ   Ú
multiparamÚparamry   r|   Úctx_dialects       €€r1   Úexecutezop_fixture.<locals>.execute  sE   ø€ Ü˜$¤Ô$Ü˜D“z�Ø×*Ò*Ð*Ð*Ü�d—l‘l¨;�lÓ7Ó8ˆCà�I‰I�c�NrM   )ru   rÓ   r‰   )r   r   r   Úsupports_native_booleanÚ#non_native_boolean_check_constraintr   ÚMockr   ÚalembicÚopÚ_proxy)ru   rO   r¬   rÌ   Únative_booleanrG   r½   rË   rÓ   rL   r¢   r|   rÒ   s    `         @@r1   Ú
op_fixturerÛ   Ú   sÈ   ú€ ð €DÙÜ"*Ð=NÔ"OˆÐÑ÷ó ñ$ ‹)€CöÔô ñ, ØˆˆX‰ÙØ -ˆˆ_Ñä˜wÓ'€KØÐ!Ø.<ˆÔ+ð ;?ˆÔ7Ùõ	ô —Y‘Y {¸GÔD‰
à #ˆˆ_ÑØˆ
Ù�+˜z¨4Ó0€Gä" 7Ó+„G‡J�JÔØ€NrM   c                  ó0   — e Zd ZdZd„ Zd„ Zd„ Zd„ Zdd„Zy)	ÚAlterColRoundTripFixture)Úalter_columnc                óä   — t         j                  j                  «       | _        t	        j
                  | j                  «      | _        t        | j                  «      | _        t        «       | _
        y r"   )r   rR   rS   rU   r   rI   rË   r   rØ   r   rd   r=   s    r1   ÚsetUpzAlterColRoundTripFixture.setUp5  sE   € Ü—I‘I×%Ñ%Ó'ˆŒ	Ü#×-Ñ-¨d¯i©iÓ8ˆŒÜ˜TŸX™XÓ&ˆŒÜ ›
ˆ�rM   c                óœ   — t        d|«      }t        d|«      }| j                  j                  j                  ||«      rJ d|›d|›d�«       ‚y )NÚqzType objects ú and ú didn't compare as equivalent)r	   rË   ÚimplÚcompare_type)r-   Út1Út2Úc1Úc2s        r1   Ú_compare_typez&AlterColRoundTripFixture._compare_type;  sQ   € Ü�C˜‹_ˆÜ�C˜‹_ˆØ—8‘8—=‘=×-Ñ-Ø�ô
ñ 	LâDFÊÐKó	Lð 
ð 
rM   c                ó¨   — t        d||¬«      }t        d||¬«      }| j                  j                  j                  ||||«      rJ d|›d|›d�«       ‚y )Nrâ   )Úserver_defaultzserver defaults rã   rä   )r	   rË   rå   Úcompare_server_default)r-   rç   Ús1rè   Ús2ré   rê   s          r1   Ú_compare_server_defaultz0AlterColRoundTripFixture._compare_server_defaultB  s[   € Ü�C˜¨BÔ/ˆÜ�C˜¨BÔ/ˆØ—8‘8—=‘=×7Ñ7Ø��B˜ô
ñ 	OâGIÊ2ÐNó	Oð 
ð 
rM   c                ó  — t        j                  | j                  «       | j                  j                  «       5  | j                  j                  | j                  «       d d d «       | j                  j                  «        y # 1 sw Y   Œ$xY wr"   )r   Ú%_safe_rollback_connection_transactionrU   rh   rd   Údrop_allÚcloser=   s    r1   ÚtearDownz!AlterColRoundTripFixture.tearDownI  sT   € Ü×9Ñ9¸$¿)¹)ÔDØ�Y‰Y�_‰_ÕØ�M‰M×"Ñ" 4§9¡9Ô-÷ à�	‰	�‰Õ÷ Ðús   º&BÂBNc                óV  — t        |j                  dd«      |j                  dt        d«      «      |j                  dd«      |j                  dd «      ¬«      }t        d	| j                  |«      }t        j                  | j                  «      5  |j                  | j                  «       t        | j                  «      }|j                  d	«      d
   }| j                  j                  d	|j                  |j                  |j                  �|j                  nd|j                   rdnd|j                  dd «      |j                  dd«      |j                  dd «      |j                  dd «      ¬«	       d d d «       t        | j                  «      }|j                  d	«      d
   }|€|}t#        |d   d|v r|d   n|j                  «       | j%                  |d   |j                  dd   «      «       t#        |d   |j                  d|j                   «      «       | j'                  |d   |j                  dd «      |j                  d|d   «      d|v r|d   j(                  «       y |j                  �%|j                  j*                  j(                  «       y d «       y # 1 sw Y   �Œ.xY w)NÚnameÚcolnameÚtypeé
   ÚnullableTrí   )rü   rí   Úxr   F)Úexisting_typeÚexisting_server_defaultÚexisting_nullablerü   rí   Únew_column_nameÚtype_Údefault)r	   Úgetr   r   rd   r   Ú_ensure_scope_for_ddlrU   Úcreater   Úget_columnsrØ   rÞ   rø   rú   rí   rü   r   rë   rñ   r   r�   )	r-   Úfrom_Úto_ÚcompareÚcolumnÚtÚinspÚold_colÚnew_cols	            r1   Ú_run_alter_colz'AlterColRoundTripFixture._run_alter_colO  sY  € ÜØ�I‰I�f˜iÓ(Ø�I‰I�fœf R›jÓ)Ø—Y‘Y˜z¨4Ó0Ø Ÿ9™9Ð%5°tÓ<ô	
ˆô �#�t—}‘} fÓ-ˆä×.Ñ.¨t¯y©yÕ9Ø�H‰H�T—Y‘YÔÜ˜4Ÿ9™9Ó%ˆDØ×&Ñ& sÓ+¨AÑ.ˆGð �G‰G× Ñ ØØ—‘Ø$Ÿk™kð ×,Ñ,Ð8ð ×)Ò)àà*0¯/ª/¡$¸uàŸ™ ¨TÓ2à"Ÿw™wÐ'7¸Ó?Ø #§¡¨°Ó 5Ø—g‘g˜f dÓ+ð !ô ÷ :ô0 �t—y‘yÓ!ˆØ×"Ñ" 3Ó'¨Ñ*ˆàˆ?ØˆGäØ�F‰OØ%¨Ñ0ˆG�FŠO°f·k±kô	
ð 	×ÑØ�F‰O˜WŸ[™[¨°¸±ÓAô	
ô 	ˆG�JÑ §¡¨Z¸¿¹Ó!IÔJØ×$Ñ$Ø�F‰OØ�K‰K˜	 4Ó(Ø�K‰K˜ ¨¡Ó0ð $ wÑ.ð Ð(Ñ)×.Ñ.õ	
ð ×,Ñ,Ð8ð ×)Ñ)×-Ñ-×2Ñ2õ	
ð õ	
÷M :Ñ9ús   ÂC#JÊJ(r"   )	rl   rm   rn   Ú__requires__rà   rë   rñ   rö   r  rp   rM   r1   rÝ   rÝ   .  s$   „ ð
 %€Lò#òLòOòô=
rM   rÝ   )zpostgresql://)r‚   zLiteral[True]rƒ   r   rk   zGenerator[io.BytesIO])rƒ   r   rk   zGenerator[io.StringIO])rƒ   r   rk   z#Generator[io.StringIO | io.BytesIO])r  FNFN)<Ú
__future__r   Úcollections.abcr   ÚconfigparserÚ
contextlibr   r“   r#   r¸   r+   Útypingr   r   r   r§   r	   r   r   r   r   r   r   r   Úsqlalchemy.testingr   r   Úsqlalchemy.testing.assertionsr   Úsqlalchemy.testing.fixturesr   ÚSQLAlchemyTablesTestr   ÚSQLAlchemyTestBaseÚsqlalchemy.testing.utilr   r×   Ú
assertionsr   r¦   r   Úenvironmentr   Ú	migrationr   Ú
operationsr   Úutilr   ÚConfigParserÚtesting_configÚreadrT   r   r€   Ú__annotations__r„   rª   rÛ   rÝ   rp   rM   r1   Ú<module>r&     s‰  ðÞ "å %Û Ý %Û 	Û 	Û 	Û Ý Ý Ý å Ý )Ý Ý Ý Ý Ý Ý Ý %Ý #Ý -Ý JÝ FÝ Aã Ý $Ý 'Ý ,Ý (Ý #Ý à*�×*Ñ*Ó,€Ø × Ñ �Z�LÔ !ô\?Ð!ô \?ð~ "&Ð ô	�Ð/ô 	óð €€~Ó ð 
Øð Øð Ø#&ð àò ó ó 
ð ð
 
Øð!Ø
ð!àò!ó ó 
ð!ð
 ðØ
ðà(òó ðð& ðØ
ðàòó ðð8 ØØØØóQ÷h^
ò ^
rM   