Ë
    ïÏj#  ã                  ó0  — 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 erBd 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!  G d„ d«      Z"y)é    )Úannotations)ÚSequence)ÚAny)ÚTYPE_CHECKING©Úschema)ÚColumn)Ú
Constraint)ÚIndex)ÚInteger)ÚNULLTYPEé   )Úutil)Úsqla_compat)ÚColumnElement)Ú
TextClause)ÚCheckConstraint)Ú
ForeignKey)ÚForeignKeyConstraint)ÚMetaData)ÚPrimaryKeyConstraint)ÚTable)ÚUniqueConstraint)Ú
TypeEngine)ÚMigrationContextc                  ó  — e Zd Z	 d	 	 	 dd„Z	 d	 	 	 	 	 	 	 	 	 dd„Z	 	 	 	 	 	 	 d	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 dd„Z	 d	 	 	 	 	 	 	 	 	 dd„Z	 d	 	 	 	 	 	 	 	 	 dd„Z	 d	 	 	 	 	 	 	 	 	 dd„Zdd„Z	dd	„Z
dd
„Z	 d	 	 	 	 	 	 	 	 	 dd„Zdd„Zy)ÚSchemaObjectsNc                ó   — || _         y ©N)Úmigration_context)Úselfr    s     úY/var/www/html/gaurav-v2/venv/lib/python3.12/site-packages/alembic/operations/schemaobj.pyÚ__init__zSchemaObjects.__init__$   s   € ð "3ˆÕó    c                ó   — | j                  «       }|D �cg c]  }t        j                  |t        «      ‘Œ }}t        j                  ||g|¢­d|iŽ}	t        j
                  |D �cg c]  }|	j                  |   ‘Œ c}d|i|¤Ž}
|
S c c}w c c}w ©Nr   Úname)ÚmetadataÚ	sa_schemar	   r   r   r   Úc)r!   r'   Ú
table_nameÚcolsr   Ú
dialect_kwÚmÚnÚcolumnsÚtÚps              r"   Úprimary_key_constraintz$SchemaObjects.primary_key_constraint)   s˜   € ð �M‰M‹OˆÙ:>Ó?¹$°Q”9×#Ñ# A¤xÕ0¸$ˆÐ?Ü�O‰O˜J¨ÐC¨GÒC¸FÑCˆô ×*Ñ*Ù"Ó#™d˜ˆa�c‰c�!‹f˜dÑ#ð
Ø*.ð
Ø2<ñ
ˆð ˆùò @ùò
 $s   •!BÁ%Bc           
     ó0  — | j                  «       }||k(  r|	|
k(  r||z   }nB|}t        j                  ||g|D �cg c]  }t        j                  |t        «      ‘Œ c}¢­d|
iŽ t        j                  ||gt        j                  |«      D �cg c]  }t        j                  |t        «      ‘Œ c}¢­d|	iŽ}|
r|
›d|›�n|}||d<   t        j                  ||D �cg c]	  }|›d|›�‘Œ c}f|||||dœ|¤Ž}|j                  |«       |S c c}w c c}w c c}w )Nr   Ú.Úmatch)r'   ÚonupdateÚondeleteÚ
deferrableÚ	initially)	r(   r)   r   r	   r   r   Úunique_listr   Úappend_constraint)r!   r'   ÚsourceÚreferentÚ
local_colsÚremote_colsr7   r8   r9   Úsource_schemaÚreferent_schemar:   r6   r-   r.   Út1_colsr/   Út1ÚtnameÚfs                       r"   Úforeign_key_constraintz$SchemaObjects.foreign_key_constraint;   s]  € ð  �M‰M‹OˆØ�XÒ -°?Ò"BØ  ;Ñ.‰Gà ˆGÜ�O‰OØØðñ :EÓE¹°A”)×"Ñ" 1¤hÕ/¸ÑEòð 'ò	ô �_‰_ØØð
ô
 ×)Ñ)¨'Ô2óá2�Aô × Ñ  ¤HÕ-Ø2ñò
ð !ñ
ˆñ ò '©Ñ1àð 	ð $ˆ
�7Ñä×*Ñ*ØÙ+6Ó7©; aš™qÒ!¨;Ñ7ð	
ð ØØØ!Øñ	
ð ñ	
ˆð 	×Ñ˜QÔàˆùòE Fùòùò" 8s   ¹!D	
Â!D
ÃD
c           
     óB  — t        j                  || j                  «       g|D �cg c]  }t        j                  |t        «      ‘Œ c}¢­d|iŽ}||d<   t        j
                  |D �cg c]  }|j                  |   ‘Œ c}i |¤Ž}|j                  |«       |S c c}w c c}w r&   )r)   r   r(   r	   r   r   r*   r<   )	r!   r'   r=   r?   r   Úkwr/   r1   Úuqs	            r"   Úunique_constraintzSchemaObjects.unique_constraintw   s§   € ô �O‰OØØ�M‰M‹Oð
ñ 6@Ó@±Z°Œi×Ñ˜q¤(Õ+°ZÑ@ò
ð ñ	
ˆð ˆˆ6‰
Ü×'Ñ'¹*Ó)E¹*°Q¨!¯#©#¨a«&¸*Ñ)EÐLÈÑLˆð 	
×Ñ˜BÔØˆ	ùò Aùò *Fs   ¥!B
Á'Bc                óÖ   — t        j                  || j                  «       t        j                  dt        «      |¬«      }t        j
                  |fd|i|¤Ž}|j                  |«       |S )NÚxr   r'   )r)   r   r(   r	   r   r   r<   )r!   r'   r=   Ú	conditionr   rI   r1   Úcks           r"   Úcheck_constraintzSchemaObjects.check_constraintŒ   s`   € ô �O‰OØØ�M‰M‹OÜ×Ñ˜S¤'Ó*Øô	
ˆô ×&Ñ& yÑB°tÐB¸rÑBˆØ	×Ñ˜BÔØˆ	r$   c           
     óR  — | j                  ||¬«      }d„ t        j                  t        j                  d„ t        j                  dœ}	 ||   } ||¬«      }|j                  |«       |S # t        $ r3}	t        ddj                  t        d„ |D «       «      «      z  «      |	‚d }	~	ww xY w)	Nr   c                ó2   — t        j                  g g | ¬«      S )N©r'   )r)   r   rS   s    r"   Ú<lambda>z2SchemaObjects.generic_constraint.<locals>.<lambda>¨   s   € ¤y×'EÑ'EØ�B˜Tõ(r$   c                ó0   — t        j                  d| ¬«      S )NÚ rS   )r)   r   rS   s    r"   rT   z2SchemaObjects.generic_constraint.<locals>.<lambda>­   s   € ¤)×";Ñ";¸BÀTÕ"Jr$   )Ú
foreignkeyÚprimaryÚuniqueÚcheckNrS   z'type' can be one of %sz, c              3  ó2   K  — | ]  }t        |«      –— Œ y ­wr   )Úrepr)Ú.0rM   s     r"   Ú	<genexpr>z3SchemaObjects.generic_constraint.<locals>.<genexpr>µ   s   è ø€ Ð":±E¨q¤4¨§7±Eùs   ‚)
Útabler)   r   r   r
   r<   ÚKeyErrorÚ	TypeErrorÚjoinÚsorted)
r!   r'   r+   Útype_r   rI   r1   ÚtypesÚconstÚkes
             r"   Úgeneric_constraintz SchemaObjects.generic_constraintž   s²   € ð �J‰J�z¨&ˆJÓ1ˆñô !×5Ñ5Ü×0Ñ0ÙJÜ×&Ñ&ñ(
ˆð
	Ø˜%‘LˆEñ ˜tÔ$ˆEØ×Ñ Ô&ØˆLøô ò 	ÜØ)Ø—)‘)œFÑ":±EÓ":Ó:Ó;ñ<óð ðûð	ús   Á	A* Á*	B&Á3.B!Â!B&c                óà   — i }| j                   �Ld| j                   j                  v r4| j                   j                  d   }t        |d«      r|j                  |d<   t	        j
                  di |¤ŽS )NÚtarget_metadataÚnaming_convention© )r    ÚoptsÚhasattrrk   r)   r   )r!   rI   Úmts      r"   r(   zSchemaObjects.metadata¼   sn   € Øˆà×"Ñ"Ð.Ø! T×%;Ñ%;×%@Ñ%@Ñ@à×'Ñ'×,Ñ,Ð->Ñ?ˆBÜ�rÐ.Ô/Ø*,×*>Ñ*>�Ð&Ñ'Ü×!Ñ!Ñ' BÑ'Ð'r$   c                óf  — | j                  «       }|D �cg c]5  }t        |t        «      r#|j                  �t	        j
                  |«      n|‘Œ7 }}|j                  dd«      }|r|D ]  }dx|_        |_        Œ t        j                  ||g|¢­i |¤Ž}|D �	cg c]M  }	t        |	t        t        f«      r5t        |	dd «      |ur$t        |	dd «      �t	        j
                  |	|¬«      n|	‘ŒO }
}	|
D ]  }|j                  |«       Œ |j                  D ]  }| j!                  ||«       Œ |S c c}w c c}	w )NÚ_constraints_includedFÚparent)Útarget_table)r(   Ú
isinstancer	   r_   r   Ú_copyÚpoprY   Úindexr)   r   r
   r   Úgetattrr<   Úforeign_keysÚ_ensure_table_for_fk)r!   r'   r0   rI   r.   r*   r,   rq   r1   ÚelemÚconstraintsrf   rF   s                r"   r_   zSchemaObjects.tableÇ   sU  € Ø�M‰M‹Oˆñ ó
á�Ü˜!œVÔ$ð %&§G¡GÐ$7ŒK×Ñ˜aÔ ¸QÑ>Øð 	ð 
ð !#§¡Ð'>ÀÓ FÐÙ Û�Ø%*Ð*�”˜1�7ð ô �O‰O˜D !Ð1 dÒ1¨bÑ1ˆñ  ó	
ñ  �Ü˜$¤¬UÐ 3Ô4ô ˜4 ¨4Ó0¸Ñ9Ü˜D (¨DÓ1Ð=ô ×!Ñ! $°QÕ7ð ñð
  ð 	ð 	
ó !ˆEØ×Ñ Õ&ð !ð —”ˆAØ×%Ñ% a¨Õ+ð  àˆùòE
ùò$	
s   •:D)ÂAD.c                ó0   — t        j                  ||fi |¤ŽS r   )r)   r	   )r!   r'   rd   rI   s       r"   ÚcolumnzSchemaObjects.columnî   s   € Ü×Ñ  eÑ2¨rÑ2Ð2r$   c           
     óø   — t        j                  |xs d| j                  «       |¬«      }||d<   t        j                  |g|D �cg c]"  }t        j
                  j                  ||«      ‘Œ$ c}¢­i |¤Ž}|S c c}w )NÚno_tabler   Ú_table)r)   r   r(   r   r   r   Ú_textual_index_column)	r!   r'   Ú	tablenamer0   r   rI   r1   r/   Úidxs	            r"   rw   zSchemaObjects.indexñ   sƒ   € ô �O‰OØÒ#˜Ø�M‰M‹OØô
ˆð
 ˆˆ8‰Ü�o‰oØð
áDKÓLÁG¸qŒd×Ñ×4Ñ4°Q¸Õ:ÀGÑLò
ð ñ
ˆð
 ˆ
ùò Ms   Á'A7
c                óp  — t        j                  |«      r¡t        j                  |«      \  }}}t        j                  ||«      }||j                  vrt        j                  |||¬«      }n|j                  |   }|�9||j                  vr*|j                  t        j                  |t        «      «       yyyy)zUcreate a placeholder Table object for the referent of a
        ForeignKey.

        r   N)r   Ú_fk_target_is_namedÚ_fk_target_tokensÚ_get_table_keyÚtablesr)   r   r*   Úappend_columnr	   r   )r!   r(   ÚfkÚsnamerE   ÚcnameÚ	table_keyÚrel_ts           r"   rz   z"SchemaObjects._ensure_table_for_fk  s    € ô
 ×*Ñ*¨2Ô.Ü"-×"?Ñ"?ÀÓ"CÑˆE�5˜%Ü#×2Ñ2°5¸%Ó@ˆIØ §¡Ñ/Ü!Ÿ™¨¨xÀÔF‘à Ÿ™¨	Ñ2�ØÐ  U°%·'±'Ñ%9Ø×#Ñ#¤I×$4Ñ$4°U¼HÓ$EÕFð &:Ð ð /r$   r   )r    zMigrationContext | NoneÚreturnÚNone)
r'   ú)sqla_compat._ConstraintNameDefined | Noner+   Ústrr,   úSequence[str]r   ú
str | Noner�   r   )NNNNNNN)r'   r’   r=   r“   r>   r“   r?   ú	list[str]r@   r–   r7   r•   r8   r•   r9   zbool | NonerA   r•   rB   r•   r:   r•   r6   r•   r�   r   )
r'   r’   r=   r“   r?   r”   r   r•   r�   r   )
r'   r’   r=   r“   rN   z%str | TextClause | ColumnElement[Any]r   r•   r�   r   )
r'   r’   r+   r“   rd   r•   r   r•   r�   r   )r�   r   )r'   r“   r�   r   )r'   r“   rd   r   r�   r	   )
r'   r•   rƒ   r•   r0   z/Sequence[str | TextClause | ColumnElement[Any]]r   r•   r�   r   )r(   r   r‹   r   r�   r‘   )Ú__name__Ú
__module__Ú__qualname__r#   r3   rG   rK   rP   rh   r(   r_   r~   rw   rz   rl   r$   r"   r   r   #   sð  „ à;?ð3Ø!8ð3à	ó3ð "ðà7ðð ðð ð	ð
 ðð 
óð2  $Ø#Ø"&Ø$(Ø&*Ø $Ø ð:à7ð:ð ð:ð ð	:ð
 ð:ð ð:ð ð:ð ð:ð  ð:ð "ð:ð $ð:ð ð:ð ð:ð 
ó:ðB "ðà7ðð ðð "ð	ð
 ðð 
óð4 "ðà7ðð ðð 9ð	ð
 ðð 
óð. "ðà7ðð ðð ð	ð
 ðð 
óó<	(ó%óN3ð "ðàðð ðð Að	ð
 ðð 
óô*Gr$   r   N)#Ú
__future__r   Úcollections.abcr   Útypingr   r   Ú
sqlalchemyr   r)   Úsqlalchemy.sql.schemar	   r
   r   Úsqlalchemy.typesr   r   rV   r   r   Úsqlalchemy.sql.elementsr   r   r   r   r   r   r   r   r   Úsqlalchemy.sql.type_apir   Úruntime.migrationr   r   rl   r$   r"   Ú<module>r£      s]   ðõ #å $Ý Ý  å *Ý (Ý ,Ý 'Ý $Ý %å Ý áÝ5Ý2Ý5Ý0Ý:Ý.Ý:Ý+Ý6Ý2å4÷pGò pGr$   