Ë
    3ýj*€  ã                  óx  — 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	rxd 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 d4lGmHZH d d5lmIZI d d6lmJZJ d d7lmKZK d d8lLmMZM d d9lLmNZN d d:lOmPZP dd;l!mQZQ dd<l+mRZR d#d=lSmTZT d#d>lUmVZV d#d?lWmXZX  ej²                  eZ«      Z[ G d@„ dAe-«      Z\ G dB„ dCe$«      Z] e:e*dD«      	 	 	 	 	 	 dSdE„«       Z^ e:e]dD«      	 	 	 	 	 	 dTdF„«       Z_ e:e%dD«      	 	 	 	 	 	 dUdG„«       Z` e:e)dD«      	 	 	 	 dVdH„«       Za e7jÄ                  dI«       e6jÄ                  dIdJ«      e3jÆ                  jÉ                  dK«       G dL„ dMe3jÆ                  «      «       «       «       Zee1jÌ                  jÏ                  ee«      	 	 	 	 	 	 dWdN„«       Zhe1jÒ                  jÏ                  e«      	 	 	 	 	 	 	 	 dXdO„«       ZjdYdP„Zk	 	 	 	 	 	 	 	 dZdQ„Zl	 	 	 	 	 	 d[dR„Zmy)\é    )Ú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)ÚDOMAIN)ÚClauseElement)ÚColumnElement)Úquoted_name)ÚMetaData)ÚTable)Ú
TypeEngine)Ú_ServerDefaultArgument)Ú_ReflectedConstraint)ÚAutogenContext)Ú_f_name)ÚMigrationContextc                  ó*  ‡ — 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Z ej                  dez   ej"                  ej$                  z  «      Z ej                  dez   dz   ej"                  ej$                  z  «      Zd'd„Zd(ˆ fd„Z	 	 	 	 d)d„Z	 	 	 	 	 	 d*d„Z	 	 	 	 	 	 d+d„Z	 	 	 	 	 	 d,d„Zd-d„Z	 	 d.	 	 	 	 	 	 	 	 	 d/ˆ fd„Z	 	 	 	 	 	 d0d„Z	 	 	 	 	 	 d1d „Z	 	 	 	 	 	 d2d!„Z	 	 	 	 	 	 d3d"„Z 	 	 	 	 	 	 d4d#„Z!	 	 	 	 	 	 d5d$„Z"ˆ xZ#S )6Ú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ÚkwrF   Úcols        úP/root/telegram-saas/.venv/lib/python3.12/site-packages/alembic/ddl/postgresql.pyÚcreate_indexzPostgresqlImpl.create_indexT   sz   € ð #Ÿ\™\×-Ñ-Ð.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)rP   Ú
batch_implrJ   Ú
constraints       rT   Úprep_table_for_batchz#PostgresqlImpl.prep_table_for_batch`   sA   € Ø×+Ñ+ò 	1ˆJà—‘Ñ+Ø—O‘O z×'CÑ'CÒCà×$Ñ$ ZÕ0ñ	1rV   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_keyrJ   Ú_autoincrement_columnÚreÚmatchÚreplaceÚserver_defaultÚargÚ
isinstanceÚstrÚtyper   r	   Úsubr   Ú
connectionÚscalarr   )	rP   Úinspector_columnÚmetadata_columnÚrendered_metadata_defaultÚrendered_inspector_defaultÚconn_col_defaultÚdefaults_equalÚmetadata_defaultÚconns	            rT   Úcompare_server_defaultz%PostgresqlImpl.compare_server_defaulth   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ó
ð 
ð 	
rV   NF)
Únullableri   rZ   Ú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€   )	rz   ri   rZ   r|   r}   r~   r   r€   r�   )Úpopr%   ÚCommandErrorrO   ÚPostgresqlColumnTypeÚsuperr   )rP   Ú
table_nameÚcolumn_namerz   ri   rZ   r{   r|   r}   r~   r   r€   r�   rR   r„   Ú	__class__s                  €rT   r   zPostgresqlImpl.alter_column›   s«   ø€ ð" —‘Ð)¨4Ó0ˆàÐ  Ü×#Ñ#ØHóð ð ÐØ�J‰JÜ$ØØØØ!ØØ"/Ø,CØ&7ô	ôô 	‰ÑØØð	
ð Ø)ØØØ'Ø'Ø$;Ø/Ø#9ñ	
ð ó	
rV   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Údefaultrm   ra   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   )ÚseqnamerZ   z^Detected sequence named '%s' as owned by integer column '%s(%s)', assuming SERIAL and omitting)rI   rk   r   r   rf   rg   r+   Ú_exec_on_inspectorr   ÚgroupÚfirstÚlogÚinforZ   )rP   Ú	inspectorrJ   Úcolumn_infoÚ	seq_matchr“   rŽ   Úcolnames           rT   Ú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ð ð# ð+
Ð%rV   c                ó’   — |D �ch c]  }|j                   j                  d«      r|’Œ! }}|D ]  }|j                  |«       Œ y c c}w )NÚduplicates_constraint)r“   rI   Úremove)rP   Úconn_unique_constraintsÚconn_indexesÚmetadata_unique_constraintsÚmetadata_indexesrQ   Údoubled_constraintsÚixs           rT   Úcorrect_for_autogen_constraintsz.PostgresqlImpl.correct_for_autogen_constraints÷   sW   € ð &ö
àØ�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)$ab  
        (?:"[^"]+"|\w+)(?:\.(?:"[^"]+"|\w+))?    # name, "char", schema.name
        (?:\s+(?:varying|precision))?            # character varying
        (?:\s*\(\s*\d+(?:\s*,\s*\d+)?\s*\))?     # (10), (10, 2)
        (?:\s+with(?:out)?\s+time\s+zone)?       # timestamp with time zone
        (?:\s*\[\s*\d*\s*\])*                    # text[]
        z::\s*z\bcast\s*\((.*?)\s+as\s+z\s*\)c                óÆ  — |j                  «       j                  dd«      j                  dd«      }|j                  �7|j                  |j                  j                  j                  «       › d�d«      }| j                  j                  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Œd	}|r"| j                  j                  d
|«      \  }}|rŒ"|j                  dd«      }|S )Nú"rb   rc   ú.r   ú(éÿÿÿÿú)r   z\1ú )Úlowerrh   rJ   rZ   Ú_cast_rern   Ú_default_modifiers_reÚsearchÚspanÚ_cast_fn_reÚsubn)rP   rQ   ÚexprÚrsrg   ÚstartÚendÚns           rT   Ú_cleanup_index_exprz"PostgresqlImpl._cleanup_index_expr+  s‚  € Ø�z‰z‹|×#Ñ# C¨Ó,×4Ñ4°S¸"Ó=ˆØ�;‰;Ð"à—<‘< 5§;¡;×#3Ñ#3×#9Ñ#9Ó#;Ð"<¸AÐ >ÀÓCˆDð �}‰}× Ñ   TÓ*ˆá�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«/ð ˆÙØ×&Ñ&×+Ñ+¨E°4Ó8‰GˆD�!ò ð �|‰|˜C Ó$ˆØˆrV   c                óV   •— t         ‰| �  | j                  j                  d|«      «      S )Nrb   )rˆ   Ú_normalize_computed_defaultr«   rn   )rP   Úsqltextr‹   s     €rT   r¸   z*PostgresqlImpl._normalize_computed_defaultK  s+   ø€ ô ‰wÑ2Ø�M‰M×Ñ˜b 'Ó*ó
ð 	
rV   c                ó<   — |j                   j                  d«      ryy)NÚpostgresql_nulls_not_distinct)Únulls_not_distinctrG   )Údialect_kwargsrI   )rP   Úitems     rT   Ú_dialect_optionszPostgresqlImpl._dialect_optionsU  s   € ð
 ×Ñ×"Ñ"Ð#BÔCØ*ØrV   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%   ÚwarnrZ   r¿   ÚextendÚSkipÚEqual)rP   Ú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                    rT   Úcompare_indexeszPostgresqlImpl.compare_indexes^  s  € ð
 ˆØ×/Ñ/Ø˜Oó
ˆ
ñ Ø�J‰J�zÔ"Ø ×,Ñ,ˆØ!×-Ñ-ˆÜˆw‹<œ3˜w›<Ò'Ø�J‰JÐ+¬C°«L¨>¸¼cÀ'»l¸^ÐLÔMÙä#×-Ñ-¨cÓ2Ð2ØˆÜ(¬¨W°gÓ)>ÀÓBò 	P‰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	Pð8 ×)Ñ)¨.Ó9ˆ	Ø×)Ñ)¨/Ó:ˆ	Ø˜	Ò!Ø�J‰J˜ ) ¨D°°Ð<Ô=áÜ#×-Ñ-¨cÓ2Ð2Ùä#×(Ñ(¨Ó.Ð.ä#×)Ñ)Ó+Ð+rV   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Ð   )	rP   Úmetadata_constraintÚreflected_constraintÚmetadata_tupÚreflected_tupÚmeta_sigÚconn_sigÚmetadata_doÚconn_dos	            rT   Úcompare_unique_constraintz(PostgresqlImpl.compare_unique_constraintš  sÙ   € ð
 ×;Ñ;Øó
ˆð ×=Ñ=Ø ó
ˆð  ×'Ñ'ˆØ ×(Ñ(ˆØ�xÒÜ#×-Ñ-Ø˜h˜Z t¨H¨:Ð6óð ð ×+Ñ+¨L×,>Ñ,>Ó?ˆØ×'Ñ'¨×(;Ñ(;Ó<ˆØ˜'Ò!Ü#×-Ñ-Ø˜g˜Y d¨;¨-Ð8óð ô  ×%Ñ%Ó'Ð'rV   c                óŒ   — |j                  di «      j                  «       }|j                  d«      s|j                  dd «       |S )NÚdialect_optionsrF   )rI   Úcopyr…   )rP   Úreflected_objectÚkindÚoptionss       rT   Ú adjust_reflected_dialect_optionsz/PostgresqlImpl.adjust_reflected_dialect_options¶  sA   € ð #×&Ñ&Ð'8¸"Ó=×BÑBÓDˆØ�{‰{Ð/Ô0Ø�K‰KÐ,¨dÔ3ØˆrV   c                óz   — t        |t        «      r|S |j                  | j                  dddœ¬«      j                  S )NTF)Úliteral_bindsÚinclude_table)ÚdialectÚcompile_kwargs)rk   rl   Úcompilerú   Ústring)rP   Úelements     rT   rÊ   zPostgresqlImpl._compile_element¿  s=   € Ü�gœsÔ#ØˆNØ�‰Ø—L‘LØ-1ÀEÑJð ó 
÷ ‰&ð	rV   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)rk   r   Ú
self_grouprˆ   Úrender_ddl_sql_expr)rP   r±   r   r  rR   r‹   s        €rT   r  z"PostgresqlImpl.render_ddl_sql_exprÇ  sD   ø€ ñ  œJ t¬\Ô:Ø—?‘?Ó$ˆDä‰wÑ*Øð
Ø$5Àñ
ØLNñ
ð 	
rV   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)rm   Ú
__module__Ú
startswithÚhasattrÚ__visit_name__Úgetattr)rP   r{   Úautogen_contextÚmodÚmeths        rT   Úrender_typezPostgresqlImpl.render_typeÞ  sa   € ô �5‹k×$Ñ$ˆØ�~‰~Ð>Ô?Øä�4Ð*¨U×-AÑ-AÑAÔBÜ˜4Ð!2°U×5IÑ5IÑ!IÓJˆDÙ˜˜Ó/Ð/àrV   c           	     óN   — t        t        t        j                  ||dd«      «      S )NÚ	text_typez(.+?\(.*text_type=)©r   rl   r&   Ú_render_type_w_subtype©rP   r{   r
  s      rT   Ú_render_HSTORE_typez"PostgresqlImpl._render_HSTORE_typeë  s,   € ô ÜÜ×)Ñ)Ø�¨Ð5Kóó
ð 	
rV   c           	     óN   — t        t        t        j                  ||dd«      «      S )NÚ	item_typez(.+?\()r  r  s      rT   Ú_render_ARRAY_typez!PostgresqlImpl._render_ARRAY_typeõ  s+   € ô ÜÜ×)Ñ)Ø�¨°Zóó
ð 	
rV   c           	     óN   — t        t        t        j                  ||dd«      «      S ©NÚastext_typez(.+?\(.*astext_type=)r  r  s      rT   Ú_render_JSON_typez PostgresqlImpl._render_JSON_typeÿ  ó,   € ô ÜÜ×)Ñ)Ø�¨Ð7Oóó
ð 	
rV   c           	     óN   — t        t        t        j                  ||dd«      «      S r  r  r  s      rT   Ú_render_JSONB_typez!PostgresqlImpl._render_JSONB_type	  r  rV   c                ó¶  — t        |«      }t        t        j                  |j                  «      «      t        j
                  |j                  |«      g}|j                  �|j                  d|j                  z  «       t        |dd «      }|�|j                  d|z  «       |j                  �4|j                  dt        j                  |j                  |d¬«      z  «       |j                  �|j                  d|j                  z  «       |j                  r|j                  d«       |j                  �4|j                  d	t        j                  |j                  |d
¬«      z  «       |j                  �1|j                  dt        j                  |j                  «      z  «       |j                   dur|j                  d«       |›ddj#                  |«      ›d�S )Nzcollation=%rÚcollation_schemazcollation_schema=%rz
default=%sT©Úwrap_in_elementzconstraint_name=%rznot_null=Truezcheck=%sFz	schema=%rzcreate_type=FalsezDOMAIN(ú, r¨   )Ú_postgresql_autogenerate_prefixÚreprr&   Ú_identrZ   Ú
_repr_typeÚ	data_typeÚ	collationrÄ   r	  r�   Ú_render_potential_exprÚconstraint_nameÚnot_nullÚcheckr|   Úcreate_typeÚjoin)rP   r{   r
  ÚprefixÚargsr  s         rT   Ú_render_DOMAIN_typez"PostgresqlImpl._render_DOMAIN_type  s‡  € ô 1°ÓAˆä”—‘˜uŸz™zÓ*Ó+Ü×Ñ˜eŸo™o¨Ó?ð
ˆð �?‰?Ð&Ø�K‰K˜¨¯©Ñ8Ô9ä" 5Ð*<¸dÓCÐØÐ'Ø�K‰KÐ-Ð0@Ñ@ÔAØ�=‰=Ð$Ø�K‰KØÜ×/Ñ/Ø—M‘M ?ÀDôñôð × Ñ Ð,Ø�K‰KÐ,¨u×/DÑ/DÑDÔEØ�>Š>Ø�K‰K˜Ô(Ø�;‰;Ð"Ø�K‰KØÜ×/Ñ/Ø—K‘K À%ôñôð �<‰<Ð#Ø�K‰K˜¤f§m¡m°E·L±LÓ&AÑAÔBØ×Ñ DÑ(Ø�K‰KÐ+Ô,Ú!'¨¯©°4­Ð9Ð9rV   )rQ   r.   rR   r   ÚreturnÚNone)r‰   rl   rŠ   rl   rz   úbool | Noneri   r<   rZ   ú
str | Noner{   úTypeEngine | Noner|   r5  r}   r4  r~   r6  r   r<   r€   r4  r�   r4  rR   r   r2  r3  )rQ   r.   r±   rl   r2  rl   )r¹   rl   r2  rl   )r¾   zIndex | UniqueConstraintr2  ztuple[Any, ...])rÑ   r.   rÒ   r.   r2  r"   )rç   r/   rè   r/   r2  r"   )ró   r=   rô   rl   r2  zdict[str, Any])rþ   zClauseElement | strr2  rl   )FF)
r±   r6   r   Úboolr  r7  rR   r   r2  rl   )r{   r;   r
  r>   r2  zstr | Literal[False])r{   r2   r
  r>   r2  rl   )r{   r0   r
  r>   r2  rl   )r{   r3   r
  r>   r2  rl   )r{   r4   r
  r>   r2  rl   )r{   r5   r
  r>   r2  rl   )$Ú__name__r  Ú__qualname__Ú__dialect__Útransactional_ddlr#   Útype_synonymsrU   r_   ry   r   r˜   r¢   rf   rü   r¬   Ú_type_name_reÚIÚXr«   r¯   r¶   r¸   r¿   rá   rï   rö   rÊ   r  r  r  r  r  r  r1  Ú__classcell__©r‹   s   @rT   rB   rB   M   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ÓØˆ�
‰
Ð(Ó)Øˆ�
‰
Ð)Ó*ðÐð€Mð ˆr�z‰z˜( ]Ñ2°B·D±D¸2¿4¹4±KÓ@€Hð �"—*‘*Ø# mÑ3°hÑ>ÀÇÁÀrÇtÁtÁó€Kóõ@
ðØ,ðà	óð:,àð:,ð ð:,ð 
ó	:,ðx(à-ð(ð /ð(ð 
ó	(ð8Ø 4ðØ<?ðà	óóð #(Øð	
àð
ð  ð
ð ð	
ð
 ð
ð 
õ
ð.ØðØ2@ðà	óð
Øð
Ø.<ð
à	ó
ð
Øð
Ø-;ð
à	ó
ð
Øð
Ø,:ð
à	ó
ð
Øð
Ø-;ð
à	ó
ð$:Øð$:Ø.<ð$:à	÷$:rV   rB   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__rM   Úto_instancer{   r„   )rP   rZ   rŠ   r{   rR   r„   r‹   s         €rT   rD  zPostgresqlColumnType.__init__;  sB   ø€ ð —‘�w Ó%ˆÜ‰Ñ˜˜{Ñ1¨bÒ1Ü×)Ñ)¨%Ó0ˆŒ
Øˆ�
rV   )rZ   rl   rŠ   rl   r{   r;   r2  r3  )r8  r  r9  rD  r@  rA  s   @rT   r‡   r‡   :  s-   ø„ ðØðØ&)ðØ2<ðà	÷ñ rV   r‡   rC   c                óx   — t        || j                  | j                  «      ›dt        || j                  d «      ›�S )Nz RENAME TO )r   r‰   r|   r   Únew_table_name©rþ   ÚcompilerrR   s      rT   Úvisit_rename_tablerJ  D  s6   € ô
 	�H˜g×0Ñ0°'·.±.ÕAÜ˜( G×$:Ñ$:¸DÔAðð rV   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 %srb   )r   r‰   r|   r   rŠ   r   r{   r„   rH  s      rT   Úvisit_column_typerL  N  sn   € ô
 	�H˜g×0Ñ0°'·.±.ÕAÜ�X˜w×2Ñ2Õ3Ø”K ¨'¯-©-Ó8Ó8Ø&-§m¢mˆ
�W—]‘]Ñ"Ð;ð	ð ð :<Ð;ð	ð rV   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)rO  Úsql_compilerÚrender_literal_valuerM   ÚStringÚformatr   r‰   r|   r   rŠ   )rþ   rI  rR   ÚddlrO  s        rT   Úvisit_column_commentrU  Z  sŒ   € ð F€Cð
 �?‰?Ð&ð 	×Ñ×2Ñ2Ø�O‰OœXŸ_™_Ó.ô	
ð ð ð �:‰:Ü$Ø�g×(Ñ(¨'¯.©.ó
ô ' x°×1DÑ1DÓEØð ó ð rV   c                ó8  — t        || j                  | j                  «      ›dt        || j                  «      ›d�}| j
                  €|dz  }|S | j                  dv r%|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 IDENTITY)NFzADD ÚalwayszSET GENERATED %s ÚALWAYSz
BY DEFAULTzSET %s rG   )r   r‰   r|   r   rŠ   r�   r   Úvisit_identity_columnÚimplÚ_compare_identity_defaultÚsortedrW  Úget_identity_optionsr
   r	  )rþ   rI  rR   r   ÚdiffÚ_ÚidentityÚattrs           rT   rY  rY  p  s/  € ô
 	�H˜g×0Ñ0°'·.±.ÕAÜ�X˜w×2Ñ2Õ3ð€Dð ‡�Ðà�ÑˆØˆØ	×	(Ñ	(¨MÑ	9ð 	�‰ˆØ�×.Ñ.¨w¯©Ó?Ñ?ˆØˆð —\‘\×;Ñ;Ø�O‰O˜W×<Ñ<ó
‰
ˆˆa�ð —?‘?ˆÜ˜4“Lò 	ˆDØ�xÒØÐ+Ø (§¢‘H°\ññ ‘ð ˜	 H×$AÑ$AÜÑ? ¤g¨h¸Ó&=Ð>Ñ?ó%ñ ñ ‘ð	ð ˆrV   Ú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 rX   )r*  r‰   ÚelementsÚwherer|   Ú_orig_constraintrR   )rP   r*  r‰   ri  rj  r|   rk  rR   s           rT   rD  z"CreateExcludeConstraintOp.__init__ž  s7   € ð  /ˆÔØ$ˆŒØ ˆŒØˆŒ
ØˆŒØ 0ˆÔØˆ�rV   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)rj  r|   rk  Ú
deferrableÚ	initiallyr„   )
r+   Ú_table_for_constraintrZ   Ú_render_exprsr   rj  r|   rm  rn  r„   )Úclsr^   Úconstraint_tabler±   rZ   Úops         rT   Úfrom_constraintz)CreateExcludeConstraintOp.from_constraint²  s™   € ô '×<Ñ<¸ZÓHÐÙØ�O‰OØ×!Ñ!à1;×1IÑ1I÷ð Ù-˜t T¨2��r’
ôô Ð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|   )rZ   rj  )rk  r(   ÚSchemaObjectsrJ   r‰   r|   r   ri  r*  rj  rR   rp  rL   r   r   Úappend_constraint)rP   Úmigration_contextÚ
schema_objÚtÚexclr±   rZ   Úopers           rT   Úto_constraintz'CreateExcludeConstraintOp.to_constraintÅ  sÄ   € ð × Ñ Ð,Ø×(Ñ(Ð(Ü×,Ñ,Ð->Ó?ˆ
Ø×Ñ˜TŸ_™_°T·[±[ÐÓAˆÜ Ø�]‰]Ø×%Ñ%Ø—*‘*ñ
ð �g‰gñ	
ˆð ×Ñò		4ñ 
ØØØà�O‰OœF 4¬Ó2Õ3ð	4ð 	
×Ñ˜DÔ!ØˆrV   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)rq  Ú
operationsr*  r‰   ri  rR   rs  s          rT   rb  z3CreateExcludeConstraintOp.create_exclude_constraintÛ  s)   € ñV � *¨hÑ=¸"Ñ=ˆØ× Ñ  Ó$Ð$rV   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|   )rZ  r|   r‰   r  )rq  r€  r*  ri  rR   rs  s         rT   rc  z9CreateExcludeConstraintOp.batch_create_exclude_constraint	  sE   € ð& "—‘×-Ñ-ˆˆ8‰Ù� *§/¡/×"<Ñ"<¸hÑMÈ"ÑMˆØ× Ñ  Ó$Ð$rV   )NNN)r*  zsqla_compat._ConstraintNamer‰   zstr | quoted_nameri  zCSequence[tuple[str, str]] | Sequence[tuple[ColumnClause[Any], str]]rj  z ColumnElement[bool] | str | Noner|   r5  rk  zExcludeConstraint | Noner2  r3  )r^   r   r2  rf  rX   )rx  zMigrationContext | Noner2  r   )r€  r*   r*  rl   r‰   rl   ri  r   rR   r   r2  úTable | None)
r€  r)   r*  rl   ri  r   rR   r   r2  r‚  )r8  r  r9  Ú__doc__Úconstraint_typerD  Úclassmethodrt  r}  rb  rc  rG   rV   rT   rf  rf  ”  s3  „ ñ ;à€Oð 37Ø!Ø59ðà4ðð &ðð
 Pðð 0ðð ðð 3ðð 
óð( ð
Ø*ð
à	"ò
ó ð
ð& <@ðØ!8ðà	óð, ð+%àð+%ð ð+%ð ð	+%ð
 ð+%ð ð+%ð 
ò+%ó ð+%ðZ ð%à#ð%ð ð%ð ð	%ð
 ð%ð 
ò%ó ñ%rV   rf  c                ó:   — t        |j                  «       | d¬«      S )NT)Úalter)Ú_exclude_constraintr}  )r
  rs  s     rT   Ú_add_exclude_constraintr‰  !  s   € ô ˜r×/Ñ/Ó1°?È$ÔOÐOrV   c                óV   — t        j                  d| |«      }|dur|S t        | |d«      S )Nrg  F)r&   Ú_user_defined_renderrˆ  )r^   r
  Únamespace_metadataÚrendereds       rT   Ú!_render_inline_exclude_constraintrŽ  (  s9   € ô ×*Ñ*Ø�:˜ó€Hð �uÑØˆä˜z¨?¸EÓBÐBrV   c                óB   — | j                   }|�|j                  d«       y)Nz*from sqlalchemy.dialects import postgresqlzpostgresql.)ÚimportsÚadd)r
  r�  s     rT   r#  r#  7  s#   € Ø×%Ñ%€GØÐØ�‰Ð@ÔAØrV   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 )Nrm  rn  r„   r|   rZ   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"  r¨   zwhere=%sú=)rp  Ú_render_potential_columnrj  rÄ   r&   r)  rÎ   )	r¹   rZ   Úopstringr0  ÚkÚvr
  r^   Úoptss	         €€€rT   Údo_expr_where_optsz/_exclude_constraint.<locals>.do_expr_where_optsT  s¶   ø€ ð ,6×+CÑ+C÷

ð 

ñ (�˜™xô )ØØ#õò òð

ˆò 

ð ×ÑÐ'Ø�K‰KØÜ×/Ñ/Ø×$Ñ$ oóñôð 	�‰°$×7©$¨!¨Q¢¡1Ò%Ó7Ô8Øˆùô'

ùó$ 8s   ’BÂB$
z-%(prefix)screate_exclude_constraint(%(args)s)r"  )r/  r0  z%%(prefix)sExcludeConstraint(%(args)s))Ú
_has_batchrm  rÄ   rl   rn  r„   rJ   r|   r&   r%  rZ   Ú_render_gen_namer$  rÎ   Ú_alembic_autogenerate_prefixr.  r#  )r^   r
  r‡  Ú	has_batchrš  r0  r™  s   ``    @rT   rˆ  rˆ  >  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ñ:
ñ 
ð 	
rV   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/  rZ   r   )	rk   r   Ú
is_literalr&   Ú_sqlalchemy_autogenerate_prefixrZ   r)  r   r   )Úvaluer
  Útemplates      rT   r•  r•  }  sr   € ô �%œÔ&Ø×Òà;‰Hà3ˆHàÜ×<Ñ<¸_ÓMØ—J‘Jñ
ñ 
ð 	
ô
 ×,Ñ,ØØÜ& u¬z¼?Ð.KÓLô
ð 	
rV   )rþ   r!   rI  r1   r2  rl   )rþ   r‡   rI  r1   r2  rl   )rþ   r   rI  r1   r2  rl   )rþ   r    rI  r1   )r
  r>   rs  rf  r2  rl   )r^   r   r
  r>   rŒ  r9   r2  rl   )r
  r>   r2  rl   )r^   r   r
  r>   r‡  r7  r2  rl   )r¢  zCColumnClause[Any] | Column[Any] | TextClause | FunctionElement[Any]r
  r>   r2  rl   )nÚ
__future__r   Úcollections.abcr   Úloggingrf   Útypingr   r   r   Ú
sqlalchemyr   r	   r
   r   r   r   r   r   rM   Ú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!   rZ  r"   r#   rb   r%   Úautogenerater&   r€  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   Ú*sqlalchemy.dialects.postgresql.named_typesr5   r6   r7   r8   Úsqlalchemy.sql.schemar9   r:   Úsqlalchemy.sql.type_apir;   r<   r=   Úautogenerate.apir>   Úautogenerate.renderr?   Úruntime.migrationr@   Ú	getLoggerr8  r’   rB   r‡   rJ  rL  rU  rY  Úregister_operationÚAddConstraintOpÚregister_add_constraintrf  Ú	renderersÚdispatch_forr‰  Ú_constraint_renderersrŽ  r#  rˆ  r•  rG   rV   rT   ú<module>rÃ     s  ðõ #å $Û Û 	Ý Ý Ý  å Ý Ý Ý %Ý Ý Ý Ý (Ý 1Ý <Ý 2Ý )Ý 0Ý .Ý 4Ý %å Ý Ý Ý Ý $Ý #Ý Ý 'Ý Ý "Ý Ý Ý !Ý Ý "Ý -Ý (Ý Ý 'áÝå Ý+Ý:ÝAÝ<Ý8Ý9ÝAÝ5Ý5Ý3Ý.Ý+Ý2å,Ý*Ý1Ý-Ý4à€g×Ñ˜Ó!€ôj:�[ô j:ôZ˜;ô ñ 
ˆ+�|Ó$ðØðØ$1ðàòó %ðñ 
Ð
 Ó-ðØ!ðØ-:ðàòó .ðñ 
ˆ-˜Ó&ðØðØ&3ðàòó 'ðñ* 
Ð
 Ó.ð Ø"ð Ø.;ò ó /ð ðF €×ÑÐ:Ó;Ø#€×#Ñ#ØÐ!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ð
à#ð
ð 	ô
rV   