Ë
    ïÏju  ã                  ól  — d dl mZ d dlm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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%l0m1Z1 d#d&l2m3Z3 d#d'l2m4Z4 d#d(l5m6Z6 d#d)l5m7Z7 d#d*l/m8Z8 d#d+l9m:Z: e	rrd d,lm;Z; d d-l
m<Z< d d.l
m=Z= d d/l>m?Z? d d0l@mAZA d d1lBmCZC d d2lDmEZE d d3lDmFZF d d4lmGZG d d5lmHZH d d6lmIZI d d7lJmKZK d d8lJmLZL d d9lMmNZN dd:l!mOZO dd;l+mPZP d#d<lQmRZR d#d=lSmTZT d#d>lUmVZV  ej®                  eX«      ZY G d?„ d@e-«      ZZ G dA„ dBe$«      Z[ e:e*dC«      	 	 	 	 	 	 dRdD„«       Z\ e:e[dC«      	 	 	 	 	 	 dSdE„«       Z] e:e%dC«      	 	 	 	 	 	 dTdF„«       Z^ e:e)dC«      	 	 	 	 dUdG„«       Z_ e7jÀ                  dH«       e6jÀ                  dHdI«      e3jÂ                  jÅ                  dJ«       G dK„ dLe3jÂ                  «      «       «       «       Zce1jÈ                  jË                  ec«      	 	 	 	 	 	 dVdM„«       Zfe1jÎ                  jË                  e«      	 	 	 	 	 	 	 	 dWdN„«       ZhdXdO„Zi	 	 	 	 	 	 	 	 dYdP„Zj	 	 	 	 	 	 dZdQ„Zky)[é    )Úannotations)ÚSequenceN)ÚAny)Úcast)ÚTYPE_CHECKING)ÚColumn)ÚFloat)ÚIdentity)Úliteral_column)ÚNumeric)Úselect)Útext)Útypes)ÚBIGINT)ÚExcludeConstraint)ÚINTEGER)ÚCreateIndex)ÚColumnClause)Ú
TextClause)ÚFunctionElement)ÚNULLTYPEé   )Úalter_column)Úalter_table)ÚAlterColumn)ÚColumnComment)Úformat_column_name)Úformat_table_name)Úformat_type)ÚIdentityColumnDefault)ÚRenameTable)ÚComparisonResult)ÚDefaultImplé   )Úutil)Úrender)Úops)Ú	schemaobj)ÚBatchOperations)Ú
Operations)Úsqla_compat)Úcompiles)ÚLiteral)ÚIndex)ÚUniqueConstraint)ÚARRAY)ÚPGDDLCompiler)ÚHSTORE)ÚJSON)ÚJSONB)ÚClauseElement)ÚColumnElement)Úquoted_name)ÚMetaData)ÚTable)Ú
TypeEngine)Ú_ServerDefaultArgument)Ú_ReflectedConstraint)ÚAutogenContext)Ú_f_name)ÚMigrationContextc                  óL  ‡ — e Zd ZdZdZej                  ddhfz   Zdd„Zd„ Zd„ Z	dd	ddddddddd
œ
	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 d ˆ fd„Z
d„ Zd„ Z ej                  d«       ej                  d«       ej                  d«       ej                  d«       ej                  d«      fZd!d„Z	 	 	 	 d"d„Z	 	 	 	 	 	 d#d„Z	 	 	 	 	 	 d$d„Z	 	 	 	 	 	 d%d„Zd&d„Z	 	 d'	 	 	 	 	 	 	 	 	 d(ˆ fd„Z	 	 	 	 	 	 d)d„Z	 	 	 	 	 	 d*d„Z	 	 	 	 	 	 d+d„Z	 	 	 	 	 	 d,d„Z	 	 	 	 	 	 d-d„Zˆ xZS ).ÚPostgresqlImplÚ
postgresqlTÚFLOATzDOUBLE PRECISIONc                ó   — |j                   j                  dd «      xs d}|D ]N  }||j                  j                  vsŒ|j                  j	                  t        |t        j                  «      «       ŒP | j                  t        |fi |¤Ž«       y )NÚpostgresql_include© )
ÚkwargsÚgetÚtableÚcÚappend_columnr   ÚsqltypesÚNullTypeÚ_execr   )ÚselfÚindexÚkwrE   Úcols        úS/var/www/html/gaurav-v2/venv/lib/python3.12/site-packages/alembic/ddl/postgresql.pyÚcreate_indexzPostgresqlImpl.create_indexS   su   € ð #Ÿ\™\×-Ñ-Ð.BÀDÓIÒOÈRÐÛ%ˆCØ˜%Ÿ+™+Ÿ-™-Ò'Ø—‘×)Ñ)Ü˜3¤× 1Ñ 1Ó2õð &ð
 	�
‰
”;˜uÑ+¨Ñ+Õ,ó    c                ó”   — |j                   D ]9  }|j                  €Œ|j                  |j                  v sŒ)| j                  |«       Œ; y ©N)ÚconstraintsÚnameÚnamed_constraintsÚdrop_constraint)rO   Ú
batch_implrI   Ú
constraints       rS   Úprep_table_for_batchz#PostgresqlImpl.prep_table_for_batch_   s<   € Ø×+Ô+ˆJà—‘Ñ+Ø—O‘O z×'CÑ'CÒCà×$Ñ$ ZÕ0ñ ,rU   c                ó&  — |j                   r||j                  j                  u ry|}|r(t        j                  d|«      r|j                  dd«      }||k(  }|ryd |||j                  fv r| S |j                  j                  }t        |t        «      rHt        |j                  t        t        f«      st        j                  dd|«      }d|› d�}t        |«      }| j                  }|€J ‚|j!                  t#        t        |«      |k(  «      «       S )NFúnextval\('(.+?)'::regclass\)z
::regclassÚ z^'|'$Ú')Úprimary_keyrI   Ú_autoincrement_columnÚreÚmatchÚreplaceÚserver_defaultÚargÚ
isinstanceÚstrÚtyper   r	   Úsubr   Ú
connectionÚscalarr   )	rO   Úinspector_columnÚmetadata_columnÚrendered_metadata_defaultÚrendered_inspector_defaultÚconn_col_defaultÚdefaults_equalÚmetadata_defaultÚconns	            rS   Úcompare_server_defaultz%PostgresqlImpl.compare_server_defaultg   s0  € ð ×'Ò'Ø ?×#8Ñ#8×#NÑ#NÑNàà5Ðá¤§¡Ø+Ð-=ô!
ð  0×7Ñ7¸ÀbÓIÐà)Ð-FÑFˆÙØàØØ%Ø×*Ñ*ð
ñ 
ð
 &Ð%Ð%à*×9Ñ9×=Ñ=ÐäÐ&¬Ô,ÜÐ.×3Ñ3´g¼uÐ5EÔFÜ#%§6¡6¨(°BÐ8HÓ#IÐ Ø%&Ð'7Ð&8¸Ð#:Ð ä-Ð.>Ó?Ðð
 �‰ˆØÐÐÐØ—;‘;Ü”>Ð"2Ó3Ð7GÑGÓHó
ð 
ð 	
rU   NF)
Únullablerh   rY   Útype_ÚschemaÚautoincrementÚexisting_typeÚexisting_server_defaultÚexisting_nullableÚexisting_autoincrementc       
        óÚ   •— |j                  dd «      }|�|€t        j                  d«      ‚|�"| j                  t	        ||||||	|
|¬«      «       t        ‰| �  ||f||||||	|
||dœ	|¤Ž y )NÚpostgresql_usingz6postgresql_using must be used with the type_ parameter)r{   Úusingr}   r~   r   )	ry   rh   rY   r{   r|   r}   r~   r   r€   )Úpopr%   ÚCommandErrorrN   ÚPostgresqlColumnTypeÚsuperr   )rO   Ú
table_nameÚcolumn_namery   rh   rY   rz   r{   r|   r}   r~   r   r€   rQ   rƒ   Ú	__class__s                  €rS   r   zPostgresqlImpl.alter_columnš   s«   ø€ ð" —‘Ð)¨4Ó0ˆàÐ  Ü×#Ñ#ØHóð ð ÐØ�J‰JÜ$ØØØØ!ØØ"/Ø,CØ&7ô	ôô 	‰ÑØØð	
ð Ø)ØØØ'Ø'Ø$;Ø/Ø#9ñ	
ð ó	
rU   c                ó|  — |j                  d«      r«t        |d   t        t        f«      r‘t	        j
                  d|d   «      }|rut        j                  |t        d«      |j                  d«      ¬«      j                  «       }|r4|\  }}||d   k(  r&t        j                  d||j                  |«       |d= y y y y y y )	NÚdefaultrl   r`   a9  select c.relname, a.attname from pg_class as c join pg_depend d on d.objid=c.oid and d.classid='pg_class'::regclass and d.refclassid='pg_class'::regclass join pg_class t on t.oid=d.refobjid join pg_attribute a on a.attrelid=t.oid and a.attnum=d.refobjsubid where c.relkind='S' and c.oid=cast(:seqname as regclass)r   )ÚseqnamerY   z^Detected sequence named '%s' as owned by integer column '%s(%s)', assuming SERIAL and omitting)rH   rj   r   r   re   rf   r+   Ú_exec_on_inspectorr   ÚgroupÚfirstÚlogÚinforY   )rO   Ú	inspectorrI   Úcolumn_infoÚ	seq_matchr’   r�   Úcolnames           rS   Úautogen_column_reflectz%PostgresqlImpl.autogen_column_reflectÏ   sÚ   € Ø�?‰?˜9Ô%¬*Ø˜Ñ¤'¬6Ð!2ô+
ô Ÿ™Ø/°¸YÑ1GóˆIñ Ü"×5Ñ5ØÜð	;óð &ŸO™O¨AÓ.ô÷ ‘%“'ð ñ  Ø'+Ñ$�G˜WØ +¨fÑ"5Ò5ÜŸ™ð;ð $Ø!ŸJ™JØ#ôð (¨	Ñ2ð 6ð ð# ð+
Ð%rU   c                ó’   — |D �ch c]  }|j                   j                  d«      r|’Œ! }}|D ]  }|j                  |«       Œ y c c}w )NÚduplicates_constraint)r’   rH   Úremove)rO   Úconn_unique_constraintsÚconn_indexesÚmetadata_unique_constraintsÚmetadata_indexesrP   Údoubled_constraintsÚixs           rS   Úcorrect_for_autogen_constraintsz.PostgresqlImpl.correct_for_autogen_constraintsö   sT   € ñ &ó
á%�Ø�z‰z�~‰~Ð5Ô6ò Ø%ð 	ð 
ó &ˆBØ×Ñ Õ#ñ &ùò
s   …$Az( asc nulls last)$z(?<! desc)( nulls last)$z( asc)$z( asc) nulls first$z desc( nulls first)$c                ó  — |j                  «       j                  dd«      j                  dd«      }|j                  �7|j                  |j                  j                  j                  «       › d�d«      }d|v rt	        j
                  dd|«      }|r(|d   dk(  r |d	   d
k(  r|dd	 }|r|d   dk(  r	|d	   d
k(  rŒ| j                  D ]6  }|j                  |«      x}sŒ|j                  d«      \  }}|d | ||d  z   } n |r(|d   dk(  r |d	   d
k(  r|dd	 }|r|d   dk(  r	|d	   d
k(  rŒt	        j                  d«      }|j                  |«      r)|j                  d|«      }t	        j
                  dd|«      }|j                  dd«      }|S )NÚ"ra   rb   Ú.z::z(::[\w ]+\w)r   Ú(éÿÿÿÿÚ)r   z	cast\s*\(zas\s+[^)]+\)Ú )Úlowerrg   rI   rY   re   rm   Ú_default_modifiers_reÚsearchÚspanÚcompilerf   )rO   rP   ÚexprÚrsrf   ÚstartÚendÚcast_res           rS   Ú_cleanup_index_exprz"PostgresqlImpl._cleanup_index_expr  s�  € Ø�z‰z‹|×#Ñ# C¨Ó,×4Ñ4°S¸"Ó=ˆØ�;‰;Ð"à—<‘< 5§;¡;×#3Ñ#3×#9Ñ#9Ó#;Ð"<¸AÐ >ÀÓCˆDà�4‰<ä—6‘6˜/¨2¨tÓ4ˆDá�t˜A‘w #’~¨$¨r©(°cª/Ø˜˜"�:ˆDñ �t˜A‘w #’~¨$¨r©(°c«/ð
 ×,Ô,ˆBØŸ	™	 $›Ð'ˆuÑ'Ø"ŸZ™Z¨›]‘
��sØ˜F˜U�| d¨3¨4 jÑ0�Ùð	 -ñ �t˜A‘w #’~¨$¨r©(°cª/Ø˜˜"�:ˆDñ �t˜A‘w #’~¨$¨r©(°c«/ô —*‘*˜\Ó*ˆØ�=‰=˜ÔØ—;‘;˜r 4Ó(ˆDä—6‘6˜/¨2¨tÓ4ˆDà�|‰|˜C Ó$ˆØˆrU   c                ó<   — |j                   j                  d«      ryy)NÚpostgresql_nulls_not_distinct)Únulls_not_distinctrF   )Údialect_kwargsrH   )rO   Úitems     rS   Ú_dialect_optionszPostgresqlImpl._dialect_options;  s   € ð
 ×Ñ×"Ñ"Ð#BÔCØ*ØrU   c           
     ó  — g }| j                  ||«      }|r|j                  |«       |j                  }|j                  }t        |«      t        |«      k7  r)|j                  dt        |«      › dt        |«      › �«       |rt	        j
                  |«      S g }t        t        ||«      d«      D ]×  \  }\  }	}
| j                  |	«      }| j                  ||«      }| j                  |
«      }| j                  ||«      }||k(  rŒU|j                  «       j                  d«      rJd|v sd|v rB|j                  d|› d|›d�«       t        j                  d	|› d|›d
|j                  ›d�«       Œ¾|j                  d|› d|›d|›�«       ŒÙ | j                  |«      }| j                  |«      }||k7  r|j!                  d|› d|› �«       |rt	        j
                  |«      S |rt	        j"                  |«      S t	        j$                  «       S )Nzexpression number ú to r   Ú_opsr¨   r§   zexpression #z' detected as including operator clause.zExpression #z
 in index a   detected to include an operator clause. Expression compare cannot proceed. Please move the operator clause to the ``postgresql_ops`` dict to enable proper compare of the index expressions: https://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classeszoptions )Ú_compare_index_uniqueÚappendÚexpressionsÚlenr"   Ú	DifferentÚ	enumerateÚzipÚ_compile_elementr³   ÚstripÚendswithr%   ÚwarnrY   r¹   ÚextendÚSkipÚEqual)rO   Úmetadata_indexÚreflected_indexÚmsgÚ
unique_msgÚm_exprsÚr_exprsÚskipÚposÚm_eÚr_eÚ	m_compileÚm_textÚ	r_compileÚr_textÚ	m_optionsÚ	r_optionss                    rS   Úcompare_indexeszPostgresqlImpl.compare_indexesD  s  € ð
 ˆØ×/Ñ/Ø˜Oó
ˆ
ñ Ø�J‰J�zÔ"Ø ×,Ñ,ˆØ!×-Ñ-ˆÜˆw‹<œ3˜w›<Ò'Ø�J‰JÐ+¬C°«L¨>¸¼cÀ'»l¸^ÐLÔMÙä#×-Ñ-¨cÓ2Ð2ØˆÜ(¬¨W°gÓ)>ÀÖB‰OˆC‘�#�sØ×-Ñ-¨cÓ2ˆIØ×-Ñ-¨n¸iÓHˆFà×-Ñ-¨cÓ2ˆIØ×-Ñ-¨n¸iÓHˆFà˜ÒØØ—‘Ó"×+Ñ+¨FÔ3Ø�yÑ  C¨9Ñ$4à—‘Ø" 3 % q¨¨ð 64ð 4ôô —	‘	Ø" 3 % q¨¨°ZØ&×+Ñ+Ð.ð /fðfõð —
‘
˜\¨#¨¨a°	¨}¸DÀÀÐNÕOð5  Cð8 ×)Ñ)¨.Ó9ˆ	Ø×)Ñ)¨/Ó:ˆ	Ø˜	Ò!Ø�J‰J˜ ) ¨D°°Ð<Ô=áÜ#×-Ñ-¨cÓ2Ð2Ùä#×(Ñ(¨Ó.Ð.ä#×)Ñ)Ó+Ð+rU   c                óŠ  — | j                  |«      }| j                  |«      }|j                  }|j                  }||k7  rt        j                  d|› d|› �«      S | j                  |j                  «      }| j                  |j                  «      }||k7  rt        j                  d|› d|› �«      S t        j                  «       S )Nzexpression r»   )Ú_create_metadata_constraint_sigÚ _create_reflected_constraint_sigÚunnamedr"   rÁ   r¹   ÚconstrÊ   )	rO   Úmetadata_constraintÚreflected_constraintÚmetadata_tupÚreflected_tupÚmeta_sigÚconn_sigÚmetadata_doÚconn_dos	            rS   Úcompare_unique_constraintz(PostgresqlImpl.compare_unique_constraint€  sÙ   € ð
 ×;Ñ;Øó
ˆð ×=Ñ=Ø ó
ˆð  ×'Ñ'ˆØ ×(Ñ(ˆØ�xÒÜ#×-Ñ-Ø˜h˜Z t¨H¨:Ð6óð ð ×+Ñ+¨L×,>Ñ,>Ó?ˆØ×'Ñ'¨×(;Ñ(;Ó<ˆØ˜'Ò!Ü#×-Ñ-Ø˜g˜Y d¨;¨-Ð8óð ô  ×%Ñ%Ó'Ð'rU   c                óŒ   — |j                  di «      j                  «       }|j                  d«      s|j                  dd «       |S )NÚdialect_optionsrE   )rH   Úcopyr„   )rO   Úreflected_objectÚkindÚoptionss       rS   Ú adjust_reflected_dialect_optionsz/PostgresqlImpl.adjust_reflected_dialect_optionsœ  sA   € ð #×&Ñ&Ð'8¸"Ó=×BÑBÓDˆØ�{‰{Ð/Ô0Ø�K‰KÐ,¨dÔ3ØˆrU   c                óz   — t        |t        «      r|S |j                  | j                  dddœ¬«      j                  S )NTF)Úliteral_bindsÚinclude_table)ÚdialectÚcompile_kwargs)rj   rk   r­   rô   Ústring)rO   Úelements     rS   rÄ   zPostgresqlImpl._compile_element¥  s=   € Ü�gœsÔ#ØˆNØ�‰Ø—L‘LØ-1ÀEÑJð ó 
÷ ‰&ð	rU   c                ón   •— |r t        |t        «      s|j                  «       }t        ‰| �  |f||dœ|¤ŽS )zdRender a SQL expression that is typically a server default,
        index expression, etc.

        )Úis_server_defaultÚis_index)rj   r   Ú
self_groupr‡   Úrender_ddl_sql_expr)rO   r®   rù   rú   rQ   rŠ   s        €rS   rü   z"PostgresqlImpl.render_ddl_sql_expr­  sD   ø€ ñ  œJ t¬\Ô:Ø—?‘?Ó$ˆDä‰wÑ*Øð
Ø$5Àñ
ØLNñ
ð 	
rU   c                óÈ   — t        |«      j                  }|j                  d«      syt        | d|j                  z  «      r"t        | d|j                  z  «      } |||«      S y)Nzsqlalchemy.dialects.postgresqlFz_render_%s_type)rl   Ú
__module__Ú
startswithÚhasattrÚ__visit_name__Úgetattr)rO   rz   Úautogen_contextÚmodÚmeths        rS   Úrender_typezPostgresqlImpl.render_typeÄ  sa   € ô �5‹k×$Ñ$ˆØ�~‰~Ð>Ô?Øä�4Ð*¨U×-AÑ-AÑAÔBÜ˜4Ð!2°U×5IÑ5IÑ!IÓJˆDÙ˜˜Ó/Ð/àrU   c           	     óN   — t        t        t        j                  ||dd«      «      S )NÚ	text_typez(.+?\(.*text_type=)©r   rk   r&   Ú_render_type_w_subtype©rO   rz   r  s      rS   Ú_render_HSTORE_typez"PostgresqlImpl._render_HSTORE_typeÑ  s,   € ô ÜÜ×)Ñ)Ø�¨Ð5Kóó
ð 	
rU   c           	     óN   — t        t        t        j                  ||dd«      «      S )NÚ	item_typez(.+?\()r	  r  s      rS   Ú_render_ARRAY_typez!PostgresqlImpl._render_ARRAY_typeÛ  s+   € ô ÜÜ×)Ñ)Ø�¨°Zóó
ð 	
rU   c           	     óN   — t        t        t        j                  ||dd«      «      S ©NÚastext_typez(.+?\(.*astext_type=)r	  r  s      rS   Ú_render_JSON_typez PostgresqlImpl._render_JSON_typeå  ó,   € ô ÜÜ×)Ñ)Ø�¨Ð7Oóó
ð 	
rU   c           	     óN   — t        t        t        j                  ||dd«      «      S r  r	  r  s      rS   Ú_render_JSONB_typez!PostgresqlImpl._render_JSONB_typeï  r  rU   )rP   r.   rQ   r   ÚreturnÚNone)rˆ   rk   r‰   rk   ry   úbool | Nonerh   r;   rY   ú
str | Nonerz   úTypeEngine | Noner{   r  r|   r  r}   r  r~   r;   r   r  r€   r  rQ   r   r  r  )rP   r.   r®   rk   r  rk   )r¸   zIndex | UniqueConstraintr  ztuple[Any, ...])rË   r.   rÌ   r.   r  r"   )rá   r/   râ   r/   r  r"   )rí   r<   rî   rk   r  zdict[str, Any])r÷   zClauseElement | strr  rk   )FF)
r®   r5   rù   Úboolrú   r  rQ   r   r  rk   )rz   r:   r  r=   r  zstr | Literal[False])rz   r2   r  r=   r  rk   )rz   r0   r  r=   r  rk   )rz   r3   r  r=   r  rk   )rz   r4   r  r=   r  rk   )Ú__name__rþ   Ú__qualname__Ú__dialect__Útransactional_ddlr#   Útype_synonymsrT   r^   rx   r   r—   r¡   re   r­   rª   r³   r¹   rÛ   ré   rð   rÄ   rü   r  r  r  r  r  Ú__classcell__©rŠ   s   @rS   rA   rA   L   s™  ø„ Ø€KØÐØ×-Ñ-Ø	Ð$Ð%ð1ñ €Mó
-ò1ò1
ðp !%Ø16ØØ#'Ø!Ø%)Ø+/Ø:>Ø)-Ø.2ñ3
àð3
ð ð3
ð
 ð3
ð /ð3
ð ð3
ð !ð3
ð ð3
ð #ð3
ð )ð3
ð "8ð3
ð 'ð3
ð !,ð3
ð ð3
ð  
õ!3
òj%3òN$ð8 	ˆ�
‰
Ð'Ó(Øˆ�
‰
Ð-Ó.Øˆ�
‰
�9ÓØˆ�
‰
Ð(Ó)Øˆ�
‰
Ð)Ó*ðÐó ðDØ,ðà	óð:,àð:,ð ð:,ð 
ó	:,ðx(à-ð(ð /ð(ð 
ó	(ð8Ø 4ðØ<?ðà	óóð #(Øð	
àð
ð  ð
ð ð	
ð
 ð
ð 
õ
ð.ØðØ2@ðà	óð
Øð
Ø.<ð
à	ó
ð
Øð
Ø-;ð
à	ó
ð
Øð
Ø,:ð
à	ó
ð
Øð
Ø-;ð
à	÷
rU   rA   c                  ó0   ‡ — e Zd Z	 	 	 	 	 	 	 	 dˆ fd„Zˆ xZS )r†   c                óŽ   •— |j                  dd «      }t        ‰| �  ||fi |¤Ž t        j                  |«      | _        || _        y )Nrƒ   )r„   r‡   Ú__init__rL   Úto_instancerz   rƒ   )rO   rY   r‰   rz   rQ   rƒ   rŠ   s         €rS   r&  zPostgresqlColumnType.__init__û  sB   ø€ ð —‘�w Ó%ˆÜ‰Ñ˜˜{Ñ1¨bÒ1Ü×)Ñ)¨%Ó0ˆŒ
Øˆ�
rU   )rY   rk   r‰   rk   rz   r:   r  r  )r  rþ   r  r&  r"  r#  s   @rS   r†   r†   ú  s-   ø„ ðØðØ&)ðØ2<ðà	÷ñ rU   r†   rB   c                óx   — t        || j                  | j                  «      ›dt        || j                  d «      ›�S )Nz RENAME TO )r   rˆ   r{   r   Únew_table_name©r÷   ÚcompilerrQ   s      rS   Úvisit_rename_tabler,    s6   € ô
 	�H˜g×0Ñ0°'·.±.ÕAÜ˜( G×$:Ñ$:¸DÔAðð rU   c           	     óê   — t        || j                  | j                  «      ›dt        || j                  «      ›ddt        || j                  «      z  ›d| j                  rd| j                  z  ›�S d›�S )Nr¨   zTYPE %szUSING %sra   )r   rˆ   r{   r   r‰   r   rz   rƒ   r*  s      rS   Úvisit_column_typer.    sn   € ô
 	�H˜g×0Ñ0°'·.±.ÕAÜ�X˜w×2Ñ2Õ3Ø”K ¨'¯-©-Ó8Ó8Ø&-§m¢mˆ
�W—]‘]Ñ"Ð;ð	ð ð :<Ð;ð	ð rU   c                ó   — d}| j                   �8|j                  j                  | j                   t        j                  «       «      nd}|j                  t        || j                  | j                  «      t        || j                  «      |¬«      S )Nz9COMMENT ON COLUMN {table_name}.{column_name} IS {comment}ÚNULL)rˆ   r‰   Úcomment)r1  Úsql_compilerÚrender_literal_valuerL   ÚStringÚformatr   rˆ   r{   r   r‰   )r÷   r+  rQ   Úddlr1  s        rS   Úvisit_column_commentr7    sŒ   € ð F€Cð
 �?‰?Ð&ð 	×Ñ×2Ñ2Ø�O‰OœXŸ_™_Ó.ô	
ð ð ð �:‰:Ü$Ø�g×(Ñ(¨'¯.©.ó
ô ' x°×1DÑ1DÓEØð ó ð rU   c                ó4  — t        || j                  | j                  «      ›dt        || j                  «      ›d�}| j
                  €|dz  }|S | j                  €%|dz  }||j                  | j
                  «      z  }|S | j                  j                  | j
                  | j                  «      \  }}}| j
                  }t        |«      D ]J  }|dk(  r|d|j                  rdndz  z  }Œ|d|j                  t        d	i |t        ||«      i¤Ž«      z  z  }ŒL |S )
Nr¨   zDROP IDENTITYzADD ÚalwayszSET GENERATED %s ÚALWAYSz
BY DEFAULTzSET %s rF   )r   rˆ   r{   r   r‰   rŒ   r~   Úvisit_identity_columnÚimplÚ_compare_identity_defaultÚsortedr9  Úget_identity_optionsr
   r  )r÷   r+  rQ   r   ÚdiffÚ_ÚidentityÚattrs           rS   r;  r;  0  s&  € ô
 	�H˜g×0Ñ0°'·.±.ÕAÜ�X˜w×2Ñ2Õ3ð€Dð ‡�Ðà�ÑˆØˆØ	×	(Ñ	(Ð	0à�‰ˆØ�×.Ñ.¨w¯©Ó?Ñ?ˆØˆð —\‘\×;Ñ;Ø�O‰O˜W×<Ñ<ó
‰
ˆˆa�ð —?‘?ˆÜ˜4–LˆDØ�xÒØÐ+Ø (§¢‘H°\ññ ‘ð ˜	 H×$AÑ$AÜÑ? ¤g¨h¸Ó&=Ð>Ñ?ó%ñ ñ ‘ð !ð ˆrU   Úcreate_exclude_constraintÚbatch_create_exclude_constraintÚexclude_constraintc                  óº   — e Zd ZdZdZ	 	 	 d		 	 	 	 	 	 	 	 	 	 	 	 	 d
d„Ze	 	 	 	 dd„«       Z	 d	 	 	 dd„Ze	 	 	 	 	 	 	 	 	 	 	 	 dd„«       Z	e	 	 	 	 	 	 	 	 	 	 dd„«       Z
y)ÚCreateExcludeConstraintOpz0Represent a create exclude constraint operation.ÚexcludeNc                óf   — || _         || _        || _        || _        || _        || _        || _        y rW   )Úconstraint_namerˆ   ÚelementsÚwherer{   Ú_orig_constraintrQ   )rO   rK  rˆ   rL  rM  r{   rN  rQ   s           rS   r&  z"CreateExcludeConstraintOp.__init__]  s7   € ð  /ˆÔØ$ˆŒØ ˆŒØˆŒ
ØˆŒØ 0ˆÔØˆ�rU   c                ó@  — t        j                  |«      } | |j                  |j                  |j                  D ���cg c]
  \  }}}||f‘Œ c}}}t	        d|j
                  «      |j                  ||j                  |j                  |j                  ¬«	      S c c}}}w )NzColumnElement[bool] | None)rM  r{   rN  Ú
deferrableÚ	initiallyrƒ   )
r+   Ú_table_for_constraintrY   Ú_render_exprsr   rM  r{   rP  rQ  rƒ   )Úclsr]   Úconstraint_tabler®   rY   Úops         rS   Úfrom_constraintz)CreateExcludeConstraintOp.from_constraintq  s™   € ô '×<Ñ<¸ZÓHÐÙØ�O‰OØ×!Ñ!à1;×1IÒ1IõÙ1I™~˜t T¨2��r’
Ð1Ióô Ð3°Z×5EÑ5EÓFØ#×*Ñ*Ø'Ø!×,Ñ,Ø ×*Ñ*Ø×"Ñ"ô
ð 	
ùôs   ¾Bc                ó¤  — | j                   �| j                   S t        j                  |«      }|j                  | j                  | j
                  ¬«      }t        | j                  | j                  | j                  dœ| j                  ¤Ž}|j                  D ]%  \  }}}|j                  t        |t        «      «       Œ' |j                  |«       |S )N)r{   )rY   rM  )rN  r(   ÚSchemaObjectsrI   rˆ   r{   r   rL  rK  rM  rQ   rS  rK   r   r   Úappend_constraint)rO   Úmigration_contextÚ
schema_objÚtÚexclr®   rY   Úopers           rS   Úto_constraintz'CreateExcludeConstraintOp.to_constraint„  s½   € ð × Ñ Ð,Ø×(Ñ(Ð(Ü×,Ñ,Ð->Ó?ˆ
Ø×Ñ˜TŸ_™_°T·[±[ÐÓAˆÜ Ø�]‰]Ø×%Ñ%Ø—*‘*ñ
ð �g‰gñ	
ˆð ×Ôñ	
ØØØà�O‰OœF 4¬Ó2Õ3ð  à	×Ñ˜DÔ!ØˆrU   c                ó:   —  | |||fi |¤Ž}|j                  |«      S )aØ  Issue an alter to create an EXCLUDE constraint using the
        current migration context.

        .. note::  This method is Postgresql specific, and additionally
           requires at least SQLAlchemy 1.0.

        e.g.::

            from alembic import op

            op.create_exclude_constraint(
                "user_excl",
                "user",
                ("period", "&&"),
                ("group", "="),
                where=("group != 'some group'"),
            )

        Note that the expressions work the same way as that of
        the ``ExcludeConstraint`` object itself; if plain strings are
        passed, quoting rules must be applied manually.

        :param name: Name of the constraint.
        :param table_name: String name of the source table.
        :param elements: exclude conditions.
        :param where: SQL expression or SQL string with optional WHERE
         clause.
        :param deferrable: optional bool. If set, emit DEFERRABLE or
         NOT DEFERRABLE when issuing DDL for this constraint.
        :param initially: optional string. If set, emit INITIALLY <value>
         when issuing DDL for this constraint.
        :param schema: Optional schema name to operate within.

        )Úinvoke)rT  Ú
operationsrK  rˆ   rL  rQ   rV  s          rS   rD  z3CreateExcludeConstraintOp.create_exclude_constraintš  s)   € ñV � *¨hÑ=¸"Ñ=ˆØ× Ñ  Ó$Ð$rU   c                ó”   — |j                   j                  |d<    | ||j                   j                  |fi |¤Ž}|j                  |«      S )a3  Issue a "create exclude constraint" instruction using the
        current batch migration context.

        .. note::  This method is Postgresql specific, and additionally
           requires at least SQLAlchemy 1.0.

        .. seealso::

            :meth:`.Operations.create_exclude_constraint`

        r{   )r<  r{   rˆ   rb  )rT  rc  rK  rL  rQ   rV  s         rS   rE  z9CreateExcludeConstraintOp.batch_create_exclude_constraintÈ  sE   € ð& "—‘×-Ñ-ˆˆ8‰Ù� *§/¡/×"<Ñ"<¸hÑMÈ"ÑMˆØ× Ñ  Ó$Ð$rU   )NNN)rK  zsqla_compat._ConstraintNamerˆ   zstr | quoted_namerL  zCSequence[tuple[str, str]] | Sequence[tuple[ColumnClause[Any], str]]rM  z ColumnElement[bool] | str | Noner{   r  rN  zExcludeConstraint | Noner  r  )r]   r   r  rH  rW   )r[  zMigrationContext | Noner  r   )rc  r*   rK  rk   rˆ   rk   rL  r   rQ   r   r  úTable | None)
rc  r)   rK  rk   rL  r   rQ   r   r  re  )r  rþ   r  Ú__doc__Úconstraint_typer&  ÚclassmethodrW  r`  rD  rE  rF   rU   rS   rH  rH  S  s3  „ ñ ;à€Oð 37Ø!Ø59ðà4ðð &ðð
 Pðð 0ðð ðð 3ðð 
óð( ð
Ø*ð
à	"ò
ó ð
ð& <@ðØ!8ðà	óð, ð+%àð+%ð ð+%ð ð	+%ð
 ð+%ð ð+%ð 
ò+%ó ð+%ðZ ð%à#ð%ð ð%ð ð	%ð
 ð%ð 
ò%ó ñ%rU   rH  c                ó:   — t        |j                  «       | d¬«      S )NT)Úalter)Ú_exclude_constraintr`  )r  rV  s     rS   Ú_add_exclude_constraintrl  à  s   € ô ˜r×/Ñ/Ó1°?È$ÔOÐOrU   c                óV   — t        j                  d| |«      }|dur|S t        | |d«      S )NrI  F)r&   Ú_user_defined_renderrk  )r]   r  Únamespace_metadataÚrendereds       rS   Ú!_render_inline_exclude_constraintrq  ç  s9   € ô ×*Ñ*Ø�:˜ó€Hð �uÑØˆä˜z¨?¸EÓBÐBrU   c                óB   — | j                   }|�|j                  d«       y)Nz*from sqlalchemy.dialects import postgresqlzpostgresql.)ÚimportsÚadd)r  rs  s     rS   Ú_postgresql_autogenerate_prefixru  ö  s#   € Ø×%Ñ%€GØÐØ�‰Ð@ÔAØrU   c                ó  ‡ ‡‡— g Š‰j                   }‰ j                  r&‰j                  dt        ‰ j                  «      f«       ‰ j                  r&‰j                  dt        ‰ j                  «      f«       ‰ j
                  r&‰j                  dt        ‰ j
                  «      f«       |sR|rP‰ j                  j                  r:‰j                  dt        j                  ‰ j                  j                  «      f«       |s=‰ j                  r1‰j                  dt        j                  ‰‰ j                  «      f«       ˆˆ ˆfd„}|r¢t        t        j                  ‰‰ j                  «      «      g}|s6|t        t        j                  ‰ j                  j                  «      «      gz  }|j                   |«       «       dt        j                  ‰«      dj                  |«      d	œz  S  |«       }d
t!        ‰«      dj                  |«      d	œz  S )NrP  rQ  rƒ   r{   rY   c            
     óT  •— ‰j                   D � ��cg c]  \  } }}dt        | ‰«      ›d|›d�‘Œ }}} }‰j                  �2|j                  dt	        j
                  ‰j                  ‰«      z  «       |j                  ‰D ��cg c]  \  }}|›d|›�‘Œ c}}«       |S c c}}} w c c}}w )Nr¥   ú, r§   zwhere=%sÚ=)rS  Ú_render_potential_columnrM  r¾   r&   Ú_render_potential_exprrÈ   )	ÚsqltextrY   ÚopstringÚargsÚkÚvr  r]   Úoptss	         €€€rS   Údo_expr_where_optsz/_exclude_constraint.<locals>.do_expr_where_opts  s½   ø€ ð ,6×+CÒ+Cõ

ñ ,DÑ'�˜™xô )ØØ#õò òð ,Dð 	ò 

ð ×ÑÐ'Ø�K‰KØÜ×/Ñ/Ø×$Ñ$ oóñôð 	�‰±$Ô7±$©$¨!¨Q¢¡1Ò%°$Ò7Ô8Øˆùô'

ùó$ 8s   ’BÂB$
z-%(prefix)screate_exclude_constraint(%(args)s)rx  )Úprefixr~  z%%(prefix)sExcludeConstraint(%(args)s))Ú
_has_batchrP  r¾   rk   rQ  rƒ   rI   r{   r&   Ú_identrY   Ú_render_gen_nameÚreprrÈ   Ú_alembic_autogenerate_prefixÚjoinru  )r]   r  rj  Ú	has_batchr‚  r~  r�  s   ``    @rS   rk  rk  ý  s®  ú€ ð
 BD€Dà×*Ñ*€Ià×ÒØ�‰�\¤3 z×'<Ñ'<Ó#=Ð>Ô?Ø×ÒØ�‰�[¤# j×&:Ñ&:Ó";Ð<Ô=Ø×ÒØ�‰�Wœc *×"2Ñ"2Ó3Ð4Ô5Ù™ :×#3Ñ#3×#:Ò#:Ø�‰�XœvŸ}™}¨Z×-=Ñ-=×-DÑ-DÓEÐFÔGÙ�Z—_’_Ø�‰Ø”V×,Ñ,¨_¸j¿o¹oÓNÐOô	
öñ, ä”×(Ñ(¨¸*¿/¹/ÓJÓKð
ˆñ Ø”Tœ&Ÿ-™-¨
×(8Ñ(8×(=Ñ(=Ó>Ó?Ð@Ñ@ˆDØ�‰Ñ&Ó(Ô)Ø>Ü×9Ñ9¸/ÓJØ—I‘I˜d“OñB
ñ 
ð 	
ñ
 "Ó#ˆØ6Ü5°oÓFØ—I‘I˜d“Oñ:
ñ 
ð 	
rU   c           	     óæ   — t        | t        «      r6| j                  rd}nd}|t        j                  |«      | j
                  dœz  S t        j                  | |t        | t        t        f«      ¬«      S )Nz"%(prefix)sliteral_column(%(name)r)z%(prefix)scolumn(%(name)r))rƒ  rY   )Úwrap_in_element)	rj   r   Ú
is_literalr&   Ú_sqlalchemy_autogenerate_prefixrY   r{  r   r   )Úvaluer  Útemplates      rS   rz  rz  <  sr   € ô �%œÔ&Ø×Òà;‰Hà3ˆHàÜ×<Ñ<¸_ÓMØ—J‘Jñ
ñ 
ð 	
ô
 ×,Ñ,ØØÜ& u¬z¼?Ð.KÓLô
ð 	
rU   )r÷   r!   r+  r1   r  rk   )r÷   r†   r+  r1   r  rk   )r÷   r   r+  r1   r  rk   )r÷   r    r+  r1   )r  r=   rV  rH  r  rk   )r]   r   r  r=   ro  r8   r  rk   )r  r=   r  rk   )r]   r   r  r=   rj  r  r  rk   )r�  zCColumnClause[Any] | Column[Any] | TextClause | FunctionElement[Any]r  r=   r  rk   )lÚ
__future__r   Úcollections.abcr   Úloggingre   Útypingr   r   r   Ú
sqlalchemyr   r	   r
   r   r   r   r   r   rL   Úsqlalchemy.dialects.postgresqlr   r   r   Úsqlalchemy.schemar   Úsqlalchemy.sql.elementsr   r   Úsqlalchemy.sql.functionsr   Úsqlalchemy.typesr   Úbaser   r   r   r   r   r   r   r    r!   r<  r"   r#   ra   r%   Úautogenerater&   rc  r'   r(   Úoperations.baser)   r*   r+   Úutil.sqla_compatr,   r-   r.   r/   Ú$sqlalchemy.dialects.postgresql.arrayr0   Ú#sqlalchemy.dialects.postgresql.baser1   Ú%sqlalchemy.dialects.postgresql.hstorer2   Ú#sqlalchemy.dialects.postgresql.jsonr3   r4   r5   r6   r7   Úsqlalchemy.sql.schemar8   r9   Úsqlalchemy.sql.type_apir:   r;   r<   Úautogenerate.apir=   Úautogenerate.renderr>   Úruntime.migrationr?   Ú	getLoggerr  r‘   rA   r†   r,  r.  r7  r;  Úregister_operationÚAddConstraintOpÚregister_add_constraintrH  Ú	renderersÚdispatch_forrl  Ú_constraint_renderersrq  ru  rk  rz  rF   rU   rS   Ú<module>r¯     s  ðõ #å $Û Û 	Ý Ý Ý  å Ý Ý Ý %Ý Ý Ý Ý (Ý 1Ý <Ý 2Ý )Ý 0Ý .Ý 4Ý %å Ý Ý Ý Ý $Ý #Ý Ý 'Ý Ý "Ý Ý Ý !Ý Ý "Ý -Ý (Ý Ý 'áÝå Ý+Ý:ÝAÝ<Ý8Ý9Ý5Ý5Ý3Ý.Ý+Ý2å,Ý*Ý1Ý-Ý4à€g×Ñ˜Ó!€ôk
�[ô k
ô\˜;ô ñ 
ˆ+�|Ó$ðØðØ$1ðàòó %ðñ 
Ð
 Ó-ðØ!ðØ-:ðàòó .ðñ 
ˆ-˜Ó&ðØðØ&3ðàòó 'ðñ* 
Ð
 Ó.ðØ"ðØ.;òó /ððD €×ÑÐ:Ó;Ø#€×#Ñ#ØÐ!Bóð ×Ñ×,Ñ,Ð-AÓBôE% × 3Ñ 3ó E%ó Cóó <ð
E%ðP ×Ñ×ÑÐ8Ó9ðPØ#ðPØ)BðPàòPó :ðPð ×Ñ×*Ñ*Ð+<Ó=ðCØ!ðCà#ðCð !ðCð 	ò	Có >ðCóð<
Ø!ð<
à#ð<
ð ð<
ð 	ó	<
ð~
ØNð
à#ð
ð 	ô
rU   