Ë
    ïÏjà—  ã                  óR
  — 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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r~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&l4m5Z5 d d'l4m6Z6 d(Z7g d)¢Z8	 	 	 	 	 	 d_d*„Z9d`d+„Z:	 	 	 	 	 	 	 	 dad,„Z; ejx                  «       xZ=Z>	 	 	 	 	 	 dbd-„Z?	 	 	 	 	 	 dcd.„Z@	 	 	 	 	 	 ddd/„ZAe>j…                  ejl                  «      	 	 	 	 	 	 ded0„«       ZCe>j…                  ejˆ                  «      	 	 	 	 	 	 dfd1„«       ZEe>j…                  ejŒ                  «      	 	 	 	 	 	 dgd2„«       ZGe>j…                  ej�                  «      dhd3„«       ZIe>j…                  ej”                  «      did4„«       ZK	 	 	 	 	 	 djd5„ZLe>j…                  ejš                  «      dkd6„«       ZNe>j…                  ejž                  «      dld7„«       ZPe>j…                  ej¢                  «      	 	 	 	 	 	 dmd8„«       ZRe>j…                  ej¦                  «      	 	 	 	 	 	 dnd9„«       ZTe>j…                  ejª                  «      d:„ «       ZVe>j…                  ej®                  «      	 	 	 	 	 	 dod;„«       ZXe>j…                  ej²                  «      	 	 	 	 	 	 dpd<„«       ZZe>j…                  ej¶                  «      dqd=„«       Z\e>j…                  ejº                  «      drd>„«       Z^e>j…                  ej¾                  «      	 	 	 	 	 	 dsd?„«       Z` G d@„ dA«      ZadtdB„ZbdCdDdDdEœ	 	 	 	 	 	 	 	 	 	 	 dudF„Zc	 	 	 	 	 	 dvdG„Zd	 	 	 	 	 	 	 	 dwdH„ZedI„ ZfdxdJ„ZgdxdK„Zh	 	 	 	 	 	 	 	 dydL„Zi	 	 	 	 	 	 dzdM„Zjd{dN„Zk	 d|	 	 	 	 	 	 	 d}dO„Zl	 	 	 	 	 	 d~dP„Zm	 	 	 	 	 	 ddQ„ZndxdR„Zo	 d€	 	 	 	 	 	 	 d�dS„Zpd‚dT„Zq	 	 	 	 	 	 dƒdU„Zr	 d„	 	 	 	 	 	 	 	 	 	 	 d…dV„Zs ejx                  «       Zt	 	 	 	 	 	 	 	 d†dW„Zuetj…                  ejT                  «      	 	 	 	 	 	 	 	 d‡dX„«       Zv	 	 	 	 	 	 	 	 dˆdY„Zw	 	 	 	 	 	 d‰dZ„Zxetj…                  ejN                  «      	 	 	 	 	 	 	 	 dŠd[„«       Zyetj…                  ejV                  «      	 	 	 	 	 	 	 	 d‹d\„«       Zzetj…                  ejD                  «      	 	 	 	 	 	 	 	 dŒd]„«       Z{e>j…                  ejø                  «      d�d^„«       Z}e=jý                  «       Z>y)Žé    )Úannotations)ÚStringION)ÚAny)Úcast)ÚTYPE_CHECKING)ÚPythonPrinter)Úschema)Úsql)Útypes)Ú_DialectArgView)Úconv)ÚLabel)Úquoted_nameé   )Úutil)Úops)Úsqla_compat)ÚLiteral)ÚComputed)ÚIdentity)ÚColumnElement)Ú
TextClause)ÚCheckConstraint)ÚColumn)Ú
Constraint)ÚFetchedValue)Ú
ForeignKey)ÚForeignKeyConstraint)ÚIndex)ÚMetaData)ÚPrimaryKeyConstraint)ÚUniqueConstraint)ÚARRAY)Ú
TypeEngine)ÚAutogenContext)ÚConfig)ÚMigrationScript)ÚModifyTableOpséÿ   )z?# WARNING: constraint name is None; this directive will fail asz8# rendered.  Add a name, or use a naming convention; seez6# https://alembic.sqlalchemy.org/en/latest/naming.htmlc                óv   — t        |t        «      rt        t        | «      |«      S t	        j
                  |«      S ©N)Ú
isinstancer   Ú_f_nameÚ_alembic_autogenerate_prefixr   Úconstraint_name_or_none)Úautogen_contextÚnames     úX/var/www/html/gaurav-v2/venv/lib/python3.12/site-packages/alembic/autogenerate/render.pyÚ_render_gen_namer3   <   s2   € ô �$œÔÜÔ3°OÓDÀdÓKÐKä×2Ñ2°4Ó8Ð8ó    c                óò   — t        j                  dt         j                  «      j                  d| «      j	                  «       } t        j                  dt         j                  «      j                  d| «      } | S )NÚ^ú    z +$Ú )ÚreÚcompileÚMÚsubÚstrip)Útexts    r2   Ú_indentr?   F   sR   € Ü�:‰:�dœBŸD™DÓ!×%Ñ% f¨dÓ3×9Ñ9Ó;€DÜ�:‰:�fœbŸd™dÓ#×'Ñ'¨¨DÓ1€DØ€Kr4   c                ó.  — | j                   }t        |j                  |j                  «      D ]I  \  }}t	        t        || «      «      ||j                  <   t	        t        || «      «      ||j                  <   ŒK dj                  t        |«      «      |d<   y )NÚ
Úimports)
rB   ÚzipÚupgrade_ops_listÚdowngrade_ops_listr?   Ú_render_cmd_bodyÚupgrade_tokenÚdowngrade_tokenÚjoinÚsorted)r0   Úmigration_scriptÚtemplate_argsrB   Úupgrade_opsÚdowngrade_opss         r2   Ú _render_python_into_templatevarsrO   L   s�   € ð
 ×%Ñ%€Gä&)Ø×)Ñ)Ð+;×+NÑ+Nö'Ñ"ˆ�]ô 4;Ü˜[¨/Ó:ó4
ˆ�k×/Ñ/Ñ0ô 8?Ü˜]¨OÓ<ó8
ˆ�m×3Ñ3Ò4ð'ð  $Ÿy™y¬°«Ó9€M�)Òr4   c                óB  — t        «       }t        |«      }|j                  d«       d}| j                  D ]5  }t	        ||«      }|xs t        |«      }|D ]  }|j                  |«       Œ Œ7 |s|j                  d«       |j                  d«       |j                  «       S )Nz=# ### commands auto generated by Alembic - please adjust! ###FÚpassz# ### end Alembic commands ###)r   r   Ú	writeliner   Ú	render_opÚboolÚgetvalue)Úop_containerr0   ÚbufÚprinterÚ	has_linesÚopÚlinesÚlines           r2   rF   rF   b   s�   € ô ‹*€CÜ˜CÓ €Gà×ÑØGôð €IØ×ÔˆÜ˜/¨2Ó.ˆØÒ,¤ e£ˆ	ãˆDØ×Ñ˜dÕ#ñ ð	 ñ Ø×Ñ˜&Ô!à×ÑÐ6Ô7à�<‰<‹>Ðr4   c                óh   — t         j                  |«      }t        j                   || |«      «      }|S r+   )Ú	renderersÚdispatchr   Úto_list)r0   rZ   Úrendererr[   s       r2   rS   rS   }   s.   € ô ×!Ñ! "Ó%€HÜ�L‰L™ /°2Ó6Ó7€EØ€Lr4   c                ó8   — dj                  t        | |«      «      S )NrA   )rI   rS   ©r0   rZ   s     r2   Úrender_op_textrd   …   s   € ð �9‰9”Y˜°Ó3Ó4Ð4r4   c                óè  — | j                   }|j                  dd«      }|j                  rºg }|r†| j                  «       5  |j	                  d|j
                  ›d|j                  ›d�«       |j                  D ]  }t        | |«      }|j                  |«       Œ! |j	                  d«       d d d «       |S |j                  D ]  }t        | |«      }|j                  |«       Œ! |S g S # 1 sw Y   |S xY w)NÚrender_as_batchFzwith op.batch_alter_table(z	, schema=z) as batch_op:r8   )	ÚoptsÚgetr   Ú_within_batchÚappendÚ
table_namer	   rS   Úextend)r0   rZ   rg   rf   r[   Út_opÚt_liness          r2   Ú_render_modify_tablero   ‹   sÜ   € ð ×Ñ€DØ—h‘hÐ0°%Ó8€Oà	‡v‚vØˆÙØ ×.Ñ.Õ0Ø—’à—}“} b§i£ið1ôð ŸFœF�DÜ'¨¸Ó>�GØ—L‘L Õ)ð #ð —‘˜RÔ ÷ 1ð ˆð	 Ÿœ�Ü# O°TÓ:�Ø—‘˜WÕ%ð ð ˆàˆ	÷! 1ð ˆús   ¿A,C'Ã'C1c                ó&  — | j                   rd}nd}|j                  t        | «      |j                  |j                  �d|j                  z  nd |j
                  �d|j
                  z  nd |j                  �d|j                  z  d¬«      S d d¬«      S )NzV{prefix}create_table_comment(
{indent}{comment},
{indent}existing_comment={existing}
)z‚{prefix}create_table_comment(
{indent}'{tname}',
{indent}{comment},
{indent}existing_comment={existing},
{indent}schema={schema}
)ú%rú'%s'r7   )ÚprefixÚtnameÚcommentÚexistingr	   Úindent)Ú
_has_batchÚformatr.   rk   ru   Úexisting_commentr	   ©r0   rZ   Útempls      r2   Ú_render_create_table_commentr}   ¨   s±   € ð ×!Ò!ðñ 	ðð 	ð �<‰<Ü+¨OÓ<Ø�m‰mØ%'§Z¡ZÐ%;��r—z‘zÒ!Àð ×"Ñ"Ð.ð �2×&Ñ&Ò&àà%'§Y¡YÐ%:ˆv˜Ÿ	™	Ñ!Øð ó ð ð AEØð ó ð r4   c                óî   — | j                   rd}nd}|j                  t        | «      |j                  |j                  �d|j                  z  nd |j
                  �d|j
                  z  d¬«      S d d¬«      S )NzA{prefix}drop_table_comment(
{indent}existing_comment={existing}
)zm{prefix}drop_table_comment(
{indent}'{tname}',
{indent}existing_comment={existing},
{indent}schema={schema}
)rq   rr   r7   )rs   rt   rv   r	   rw   )rx   ry   r.   rk   rz   r	   r{   s      r2   Ú_render_drop_table_commentr   Ê   sš   € ð ×!Ò!ðñ 	ðð 	ð �<‰<Ü+¨OÓ<Ø�m‰mð ×"Ñ"Ð.ð �2×&Ñ&Ò&àà%'§Y¡YÐ%:ˆv˜Ÿ	™	Ñ!Øð ó 
ð 
ð AEØð ó 
ð 
r4   c                ó  — |j                  «       }|j                  D �cg c]  }t        || «      ‘Œ c}D �cg c]  }|r|‘Œ c}t        |j                  D �cg c]  }t        || |j                  «      ‘Œ c}D �cg c]  }|�|‘Œ c}«      z   }t        |«      t        kD  rddj                  |«      z   dz   }ndj                  |«      }dt        |j                  «      t        | «      |dœz  }|j                  r|dt        |j                  «      z  z  }|j                  }	|	r|dt        |	«      z  z  }|j                  }
|
r|d|
›�z  }t        |j                   «      D ]*  }|d|j#                  d	d
«      ›d|j                   |   ›�z  }Œ, |j$                  r*dj                  d„ |j$                  D «       «      }|d|z  z  }|j&                  �|dt)        |j&                  «      z  z  }|dz  }|S c c}w c c}w c c}w c c}w )Nz*[ú,
Ú]z.%(prefix)screate_table(%(tablename)r,
%(args)s)Ú	tablenamers   Úargsz,
schema=%rz,
comment=%rz,
info=Ú Ú_Ú=ú, c              3  ó&   K  — | ]	  }d |z  –— Œ y­w)rr   N© )Ú.0Úps     r2   Ú	<genexpr>z_add_table.<locals>.<genexpr>  s   è ø€ ÐA±¨A˜V a�Z±ùó   ‚z,
prefixes=[%s]z,
if_not_exists=%rz
))Úto_tableÚcolumnsÚ_render_columnrJ   ÚconstraintsÚ_render_constraintÚ_namespace_metadataÚlenÚMAX_PYTHON_ARGSrI   Ú_identrk   r.   r	   ru   ÚinfoÚkwÚreplaceÚ	_prefixesÚif_not_existsrT   )r0   rZ   ÚtableÚcolÚconsÚrconsr„   Úargs_strr>   ru   r˜   ÚkÚprefixess                r2   Ú
_add_tabler¤   é   s(  € à�K‰K‹M€Eð
 =B¿MºMó
Ù<I°SŒN˜3 Õ0¸Mò
óñ
ˆCñ ò	 	ð
ñô 	ð "×-Ò-ó	ñ .�Dô #Ø˜/¨2×+AÑ+Aõð .ò	ó		
ñ�ð Ð ò ðñ		
ó	ñ€Dô& ˆ4ƒy”?Ò"Ø˜%Ÿ*™* TÓ*Ñ*¨SÑ0‰à—:‘:˜dÓ#ˆà<Ü˜BŸM™MÓ*Ü.¨Ó?Øñ@ñ €Dð
 
‡y‚yØ�¤¨¯	©	Ó!2Ñ2Ñ2ˆà�m‰m€GÙØ�¤&¨£/Ñ1Ñ1ˆà�:‰:€DÙØ�(˜4˜(Ð#Ñ#ˆä�B—E‘EŽ]ˆÙ˜aŸi™i¨¨SÕ1°2·5±5¸²8Ð<Ñ<‰ð ð ‡‚Ø—9‘9ÑA°·²ÓAÓAˆØÐ" XÑ-Ñ-ˆà	×ÑÐ#ØÐ%¬¨R×-=Ñ-=Ó(>Ñ>Ñ>ˆàˆE�M€DØ€Kùòc
ùòùòùò		
s   ŸG0·G5ÁG:
Á:G?
c                óô   — dt        | «      t        |j                  «      dœz  }|j                  r|dt        |j                  «      z  z  }|j                  �|dt        |j                  «      z  z  }|dz  }|S )Nz%(prefix)sdrop_table(%(tname)r)rs   rt   ú, schema=%rz, if_exists=%rÚ))r.   r—   rk   r	   Ú	if_existsrT   )r0   rZ   r>   s      r2   Ú_drop_tabler©   #  sw   € à+Ü.¨Ó?Ü˜Ÿ™Ó&ñ/ñ €Dð 
‡y‚yØ�¤ r§y¡yÓ 1Ñ1Ñ1ˆà	‡|�|ÐØÐ ¤4¨¯©Ó#5Ñ5Ñ5ˆàˆC�K€DØ€Kr4   c           
     ór   — |j                  «       D ��cg c]  \  }}|› dt        || «      › �‘Œ c}}S c c}}w )Nr‡   )ÚitemsÚ_render_potential_expr)r0   Údialect_kwargsÚkeyÚvals       r2   Ú_render_dialect_kwargs_itemsr°   3  sJ   € ð
 '×,Ñ,Ô.ôá.‰HˆC�ð ˆ%ˆqÔ'¨¨_Ó=Ð>Ò?Ø.òð ùó s   ”3c                ór  — |j                  «       }| j                  }|rd}nd}|j                  €J ‚t        | |j                  «      }|j
                  �'|j                  dt        |j
                  «      z  «       |t        | «      t        | |j                  «      t        |j                  j                  «      dj                  t        || «      «      |j                  xs d|j                  j                  r"dt        |j                  j                  «      z  nd|rddj                  |«      z   nddœz  }|S )	NzL%(prefix)screate_index(%(name)r, [%(columns)s], unique=%(unique)r%(kwargs)s)za%(prefix)screate_index(%(name)r, %(table)r, [%(columns)s], unique=%(unique)r%(schema)s%(kwargs)s)zif_not_exists=%rrˆ   Fr¦   r8   )rs   r1   r�   r�   Úuniquer	   Úkwargs)Úto_indexrx   r�   r°   r­   rœ   rj   rT   r.   r3   r1   r—   rI   Ú_get_index_rendered_expressionsr²   r	   ©r0   rZ   ÚindexÚ	has_batchÚtmplrg   r>   s          r2   Ú
_add_indexrº   <  s  € à�K‰K‹M€Eà×*Ñ*€Iáð+ñ 	ð5ð 	ð
 �;‰;Ð"Ð"Ð"ä'¨¸×9MÑ9MÓN€DØ	×ÑÐ#Ø�‰Ð&¬¨b×.>Ñ.>Ó)?Ñ?Ô@ØÜ.¨Ó?Ü  °%·*±*Ó=Ü˜Ÿ™×(Ñ(Ó)Ø—9‘9Ü+¨E°?ÓCó
ð —,‘,Ò' %ð �{‰{×!Ò!ð œV E§K¡K×$6Ñ$6Ó7Ò7àá,0�$˜Ÿ™ 4›Ò(°bññ €Dð €Kr4   c           	     óÈ  — |j                  «       }| j                  }|rd}nd}t        | |j                  «      }|j                  �'|j                  dt        |j                  «      z  «       |t        | «      t        | |j                  «      t        |j                  «      |j                  rdt        |j                  «      z  nd|rddj                  |«      z   nddœz  }|S )Nz(%(prefix)sdrop_index(%(name)r%(kwargs)s)zM%(prefix)sdrop_index(%(name)r, table_name=%(table_name)r%(schema)s%(kwargs)s)zif_exists=%rr¦   r8   rˆ   )rs   r1   rk   r	   r³   )r´   rx   r°   r­   r¨   rj   rT   r.   r3   Ú
index_namer—   rk   r	   rI   r¶   s          r2   Ú_drop_indexr½   d  sÇ   € à�K‰K‹M€Eà×*Ñ*€IáØ9‰ð=ð 	ô (¨¸×9MÑ9MÓN€DØ	‡|�|ÐØ�‰�N¤T¨"¯,©,Ó%7Ñ7Ô8ØÜ.¨Ó?Ü  °"·-±-Ó@Ü˜RŸ]™]Ó+Ø:<¿)º)�M¤F¨2¯9©9Ó$5Ò5ÈÙ,0�$˜Ÿ™ 4›Ò(°bññ €Dð €Kr4   c                ó:   — t        |j                  «       | d«      gS )NT)Ú_uq_constraintÚto_constraintrc   s     r2   Ú_add_unique_constraintrÁ   ~  s   € ô ˜2×+Ñ+Ó-¨ÀÓEÐFÐFr4   c                óR  — |j                  «       }t        t        | |j                  «      «      g}| j                  s-|j                  t        t        |j                  «      «      «       |j                  t        t        |j                  «      «      t        |j                  D �cg c]  }t        |«      ‘Œ c}«      t        |j                  D �cg c]  }t        |«      ‘Œ c}«      g«       g d¢}| j                  s|j                  dd«       |D ]9  }||j                  v sŒ|j                  |   }|€Œ$|j                  |›d|›�«       Œ; t        | |j                  «      }dt!        | «      dj#                  |«      |rddj#                  |«      z   dœz  S ddœz  S c c}w c c}w )	N)Úreferent_schemaÚonupdateÚondeleteÚ	initiallyÚ
deferrableÚ	use_alterÚmatchr   Úsource_schemar‡   z8%(prefix)screate_foreign_key(%(args)s%(dialect_kwargs)s)rˆ   r8   )rs   r„   r­   )rÀ   Úreprr3   Úconstraint_namerx   rj   r—   Úsource_tablerl   Úreferent_tableÚ
local_colsÚremote_colsÚinsertr™   r°   r­   r.   rI   )	r0   rZ   Ú
constraintr„   rž   r³   r¢   Úvaluer­   s	            r2   Ú_add_fk_constraintrÔ   …  s}  € ð ×!Ñ!Ó#€JÜÔ! /°2×3EÑ3EÓFÓGÐH€DØ×%Ò%Ø�‰”Dœ §¡Ó0Ó1Ô2à‡K�Kä”˜×)Ñ)Ó*Ó+Ü¨¯ªÓ7© #”&˜•+¨Ñ7Ó8Ü¨¯ªÓ8© #”&˜•+¨Ñ8Ó9ð	
ôò€Fð ×%Ò%Ø�‰�a˜Ô)ãˆØ�—‘Š:Ø—E‘E˜!‘HˆEØÑ Ø—‘¢q©%Ð0Õ1ð	 ô 2Ø˜×2Ñ2ó€Nð FÜ.¨Ó?Ø—	‘	˜$“á0>ˆD�4—9‘9˜^Ó,Ñ,ñ	Iñ ð ð EGñ	Iñ ð ùò5 8ùÚ8s   Â%FÃF$c                ó   — t        «       ‚r+   )ÚNotImplementedError)rÒ   r0   s     r2   Ú_add_pk_constraintr×   ´  s   € ä
Ó
Ðr4   c                óà  — |j                  «       }t        t        | |j                  «      «      g}| j                  s-|j                  t        t        |j                  «      «      «       |j                  t        |j                  | d¬«      «       | j                  s3|j                  r'|j                  dt        |j                  «      z  «       dt        | «      dj                  |«      dœz  S )NF©Úwrap_in_elementz	schema=%rz+%(prefix)screate_check_constraint(%(args)s)rˆ   ©rs   r„   )rÀ   rË   r3   rÌ   rx   rj   r—   rk   r¬   Úsqltextr	   r.   rI   )r0   rZ   rÒ   r„   s       r2   Ú_add_check_constraintrÝ   ¹  sÁ   € ð ×!Ñ!Ó#€JÜÔ! /°2×3EÑ3EÓFÓGÐH€DØ×%Ò%Ø�‰”Dœ §¡Ó.Ó/Ô0Ø‡K�KÜØ×Ñ Àô	
ôð
 ×%Ò%¨"¯)ª)Ø�‰�K¤&¨¯©Ó"3Ñ3Ô4Ø8Ü.¨Ó?Ø—	‘	˜$“ñ<ñ ð r4   c                óÞ  — t        | «      }t        | |j                  «      }|j                  rt	        |j                  «      nd }|j
                  rt	        |j
                  «      nd }|j                  }g }|j                  t        |«      «       | j                  sC|j                  t        t	        |j                  «      «      «       |�|j                  d|›�«       |�|j                  d|›�«       |�|j                  d|› �«       g }|€8t        j                  d|j                  ›d�«       |j                  t        «       |j                  |› ddj                  |«      › d�«       |S )	Núschema=útype_=z
if_exists=zWAutogenerate rendered a drop_constraint() directive for an unnamed constraint on table z£; the migration will fail unless a constraint name is added to the directive.  Consider using a naming convention so that constraint names are known ahead of time.zdrop_constraint(rˆ   r§   )r.   r3   rÌ   r	   r—   Úconstraint_typer¨   rj   rË   rx   rk   r   Úwarnrl   Ú_UNNAMED_CONSTRAINT_WARNINGrI   )	r0   rZ   rs   r1   r	   Útype_r¨   Úparams_strsr[   s	            r2   Ú_drop_constraintræ   Î  sM  € ô *¨/Ó:€FÜ˜O¨R×-?Ñ-?Ó@€DØ"$§)¢)ŒV�B—I‘IÔ°€FØ*,×*<Ò*<ŒF�2×%Ñ%Ô&À$€EØ—‘€IØ€KØ×Ñ”t˜D“zÔ"Ø×%Ò%Ø×Ñœ4¤ r§}¡}Ó 5Ó6Ô7ØÐØ×Ñ ¨¨
Ð3Ô4ØÐØ×Ñ˜V E 9Ð-Ô.ØÐØ×Ñ˜Z¨	 {Ð3Ô4à€EØ€|Ü�	‰	ð+à�}‰}Ðð  ðô	
ð 	�‰Ô0Ô1à	‡L�L�F�8Ð+¨D¯I©I°kÓ,BÐ+CÀ1ÐEÔFØ€Lr4   c                óð   — |j                   |j                  |j                  |j                  f\  }}}}| j                  rd}nd}|r|dz  }|�|dz  }|dz  }|t        | «      |t        || «      ||dœz  }|S )Nz %(prefix)sadd_column(%(column)s)z*%(prefix)sadd_column(%(tname)r, %(column)sú, schema=%(schema)rz!, if_not_exists=%(if_not_exists)rr§   )rs   rt   Úcolumnr	   rœ   )r	   rk   ré   rœ   rx   r.   r‘   )r0   rZ   r	   rt   ré   rœ   Útemplater>   s           r2   Ú_add_columnrë   ò  s    € ð 	�	‰	Ø
�‰Ø
�	‰	Ø
×Ñð	,Ñ(€FˆE�6˜=ð ×!Ò!Ø5‰à?ˆÙØÐ-Ñ-ˆHØÐ$ØÐ;Ñ;ˆHØ�C‰ˆØÜ.¨Ó?ØÜ  ¨Ó9ØØ&ññ €Dð €Kr4   c                ó  — |j                   |j                  |j                  |j                  f\  }}}}| j                  rd}nd}|r|dz  }|�|dz  }|dz  }|t        | «      t        |«      t        |«      t        |«      |dœz  }|S )Nz %(prefix)sdrop_column(%(cname)r)z*%(prefix)sdrop_column(%(tname)r, %(cname)rrè   z, if_exists=%(if_exists)rr§   )rs   rt   Úcnamer	   r¨   )r	   rk   Úcolumn_namer¨   rx   r.   r—   )r0   rZ   r	   rt   rî   r¨   rê   r>   s           r2   Ú_drop_columnrï     s¤   € ð 	�	‰	Ø
�‰Ø
�‰Ø
�‰ð	-Ñ)€FˆE�; 	ð ×!Ò!Ø5‰à?ˆÙØÐ-Ñ-ˆHØÐ ØÐ3Ñ3ˆHØ�C‰ˆàÜ.¨Ó?Ü˜“Ü˜Ó$Ü˜“.Øññ €Dð €Kr4   c                óT  — |j                   }|j                  }|j                  }|j                  }|j                  }|j
                  }|j                  }|j                  j                  dd «      }	|j                  }
|j                  }|j                  }|j                  }|j                  }d}| j                  rd}nd}|t        | «      ||dœz  }|
�|d|›dt!        |
| «      ›�z  }|durt#        || «      }|d|›d	|›�z  }|�|d|›d
|›�z  }|�|d|›dt!        || «      ›�z  }|�|d|›d|›�z  }|dur|d|›d|›�z  }|�|d|›d|›�z  }|€|�|d|›d|›�z  }|	�|d|›d|	›�z  }|du r|rt#        || «      }|d|›d|›�z  }|r| j                  s|d|›d|›�z  }|dz  }|S )NÚautoincrementz           z %(prefix)salter_column(%(cname)rz+%(prefix)salter_column(%(tname)r, %(cname)r)rs   rt   rí   r�   zexisting_type=Fzserver_default=znew_column_name=rà   z	nullable=zcomment=zexisting_comment=zexisting_nullable=zautoincrement=zexisting_server_default=rß   r§   )rk   rî   Úmodify_server_defaultÚmodify_typeÚmodify_nullableÚmodify_commentÚmodify_namer™   rh   Úexisting_typeÚexisting_nullablerz   Úexisting_server_defaultr	   rx   r.   Ú
_repr_typeÚ_render_server_default)r0   rZ   rt   rí   Úserver_defaulträ   Únullableru   Únewnamerñ   r÷   rø   rz   rù   r	   rw   rê   r>   Úrendereds                      r2   Ú_alter_columnr   *  s
  € ð �M‰M€EØ�N‰N€EØ×-Ñ-€NØ�N‰N€EØ×!Ñ!€HØ×Ñ€GØ�n‰n€GØ—E‘E—I‘I˜o¨tÓ4€MØ×$Ñ$€MØ×,Ñ,ÐØ×*Ñ*ÐØ ×8Ñ8ÐØ�Y‰Y€Fà€Fà×!Ò!Ø5‰à@ˆàÜ.¨Ó?ØØññ €Dð
 Ð ÙÚÜ�} oÔ6ð
ñ 	
ˆð ˜UÑ"Ü)¨.¸/ÓJˆÙªF±HÐ=Ñ=ˆàÐÙªV±WÐ=Ñ=ˆØÐÙ¢6¬:°e¸_Ô+MÐNÑNˆØÐÙ¢f©hÐ7Ñ7ˆØ�eÑÙ¢V©WÐ5Ñ5ˆØÐ#ÙªfÑ6FÐGÑGˆØÐÐ-Ð9ÙªvÑ7HÐIÑIˆØÐ Ùª6±=ÐAÑAˆØ˜ÑÑ#:Ü)Ø# _ó
ˆñ 	²V¹XÐFÑFˆÙ�o×0Ò0Ù¢F©FÐ3Ñ3ˆØˆC�K€DØ€Kr4   c                  ó   — e Zd Zdd„Zdd„Zy)r-   c                ó    — || _         || _        y r+   )rs   r1   )Úselfrs   r1   s      r2   Ú__init__z_f_name.__init__k  s   € ØˆŒØˆ�	r4   c                óL   — | j                   ›dt        | j                  «      ›d�S )Nzf(r§   )rs   r—   r1   )r  s    r2   Ú__repr__z_f_name.__repr__o  s   € Ø ŸK›K¬°·	±	Õ):Ð;Ð;r4   N)rs   Ústrr1   r   ÚreturnÚNone)r  r  )Ú__name__Ú
__module__Ú__qualname__r  r  rŠ   r4   r2   r-   r-   j  s   „ óô<r4   r-   c                óf   — | €| S t        | t        «      rt        | «      S t        | t        «      r| S y)zþproduce a __repr__() object for a string identifier that may
    use quoted_name() in SQLAlchemy 0.9 and greater.

    The issue worked around here is that quoted_name() doesn't have
    very good repr() behavior by itself when unicode is involved.

    N)r,   r   r  )r1   s    r2   r—   r—   s  s6   € ð €|ØˆÜ	�Dœ+Ô	&Ü�4‹yÐÜ	�Dœ#Ô	Øˆð 
r4   TF)rÚ   Úis_server_defaultÚis_indexc          	     óæ  — t        | t        t        f«      rg| D �cg c]  }t        ||«      ‘Œ }}t        | t        «      r*ddj	                  |«      ›t        |«      dk(  rd›d�S d›d�S ddj	                  |«      z  S t        | t        j                  «      rt        t        t        | dd «      «      «      S t        | t        j                  «      r’|j                  j                  j                  | ||¬	«      }|r]t!        |«      }|rd
nd}	|› |	› d|›d�}
|r>t        | t"        «      r.t%        | j&                  «      t(        u r|
d| j&                  ›d�z   S |
S t        |«      S t        | «      S c c}w )NÚ(rˆ   é   Ú,r8   r§   z[%s]r1   )r  r  Úliteral_columnr>   z.label()r,   ÚlistÚtupler¬   rI   r•   Ú	sa_schemar   rË   r—   Úgetattrr
   ÚClauseElementÚmigration_contextÚimplÚrender_ddl_sql_exprÚ_sqlalchemy_autogenerate_prefixr   Útyper1   r  )rÓ   r0   rÚ   r  r  Úitemrÿ   Úsql_textrs   ÚelementÚ	value_strs              r2   r¬   r¬   ƒ  sw  € ô �%œ$¤˜Ô'áFKó
ÙFK¸dÔ" 4¨Õ9Àeð 	ð 
ô �eœUÕ#à—	‘	˜(Ô#Ü˜8“}¨Ò)�Ñ1ðð à/1Ñ1ðð ð
 ˜DŸI™I hÓ/Ñ/Ð/ä	�Eœ9×+Ñ+Ô	,Ü”Fœ7 5¨&°$Ó7Ó8Ó9Ð9Ü	�Eœ3×,Ñ,Ô	-Ø"×4Ñ4×9Ñ9×MÑMØÐ%6Àð Nó 
ˆñ Ü4°_ÓEˆFÙ*2Ñ&¸ˆGØ!˜( 7 )¨1¨X¨L¸Ð:ˆIáÜ˜u¤eÔ,Ü˜Ÿ™Ó$¬Ñ+à  W¨U¯Z©Z¨N¸!Ð#<Ñ<Ð<à Ð ä˜“>Ð!ä�E‹{ÐùòA
s   ›E.c                óÊ   — | j                   D �cg c]I  }t        |t        j                  «      rt	        t        t        |dd «      «      «      nt        ||d¬«      ‘ŒK c}S c c}w )Nr1   T)r  )Úexpressionsr,   r  r   rË   r—   r  r¬   )Úidxr0   Úexps      r2   rµ   rµ   °  sh   € ð —?’?óñ #ˆCô ˜#œy×/Ñ/Ô0ô ”œ  V¨TÓ2Ó3Ô4ä'¨¨_ÀtÔLñMð #ñð ùò s   �AA c           
     ó  — g }|j                   }| j                  r|j                  d| j                  f«       | j                  r|j                  d| j                  f«       |sH|rF| j                  j
                  r0|j                  dt        | j                  j
                  «      f«       |s3| j                  r'|j                  dt        || j                  «      f«       t        || j                  «      }|rít        t        || j                  «      «      g}|s,|t        t        | j                  j                  «      «      gz  }|j                  t        | j                  D �cg c]  }t        |j                  «      ‘Œ c}«      «       |j                  |D ��	cg c]  \  }}	|›d|	›�‘Œ c}	}«       |j                  |«       dt        |«      dj                  |«      dœz  S | j                  D �cg c]   }t        t        |j                  «      «      ‘Œ" }}|j                  |D ��	cg c]  \  }}	|›d|	›�‘Œ c}	}«       |j                  |«       d	t!        |«      dj                  |«      dœz  S c c}w c c}	}w c c}w c c}	}w )
NrÇ   rÆ   r	   r1   r‡   z,%(prefix)screate_unique_constraint(%(args)s)rˆ   rÛ   z$%(prefix)sUniqueConstraint(%(args)s))rx   rÇ   rj   rÆ   r�   r	   r—   r1   r3   r°   r­   rË   r�   rl   r.   rI   r  )
rÒ   r0   Úalterrg   r¸   Údialect_optionsr„   rž   r¢   Úvs
             r2   r¿   r¿   ½  s'  € ð
 #%€Dà×*Ñ*€Ià×ÒØ�‰�\ :×#8Ñ#8Ð9Ô:Ø×ÒØ�‰�[ *×"6Ñ"6Ð7Ô8Ù™ :×#3Ñ#3×#:Ò#:Ø�‰�Xœv j×&6Ñ&6×&=Ñ&=Ó>Ð?Ô@Ù�Z—_’_Ø�‰ØÔ% o°z·±ÓGÐHô	
ô 3Ø˜×2Ñ2ó€Oñ ÜÔ% o°z·±ÓGÓHÐIˆÙØ”Tœ& ×!1Ñ!1×!6Ñ!6Ó7Ó8Ð9Ñ9ˆDØ�‰”D°j×6HÒ6HÓIÑ6H¨sœ& §¡Õ*Ð6HÑIÓJÔKØ�‰±$Ô7±$©$¨!¨Q¢¡1Ò%°$Ò7Ô8Ø�‰�OÔ$Ø=Ü2°?ÓCØ—I‘I˜d“OñA
ñ 
ð 	
ð
 3=×2DÒ2DÓEÑ2D¨3””V˜CŸH™HÓ%Õ&Ð2DˆÐEØ�‰±$Ô7±$©$¨!¨Q¢¡1Ò%°$Ò7Ô8Ø�‰�OÔ$Ø5Ü5°oÓFØ—I‘I˜d“Oñ9
ñ 
ð 	
ùò JùÛ7ùò FùÛ7s   Å$I4ÆI9
Ç3%I?È*J
c                óF   — | j                   d   }|€d|j                  z  S |S )NÚuser_module_prefixz%s.)rg   r  )r0   Útargetrs   s      r2   Ú_user_autogenerate_prefixr.  é  s.   € Ø×!Ñ!Ð"6Ñ7€FØ€~Ø�v×(Ñ(Ñ(Ð(àˆr4   c                ó(   — | j                   d   xs dS )NÚsqlalchemy_module_prefixr8   ©rg   ©r0   s    r2   r  r  ñ  s   € Ø×ÑÐ :Ñ;ÒA¸rÐAr4   c                óB   — | j                   ry| j                  d   xs dS )Nz	batch_op.Úalembic_module_prefixr8   )rx   rg   r2  s    r2   r.   r.   õ  s%   € Ø×!Ò!Øà×#Ñ#Ð$;Ñ<ÒBÀÐBr4   c                ób   — d|j                   v r!|j                   d   }|r || ||«      }|dur|S y)NÚrender_itemFr1  )rä   Úobject_r0   Úrenderrÿ   s        r2   Ú_user_defined_renderr9  ü  sC   € ð ˜×,Ñ,Ñ,Ø ×%Ñ% mÑ4ˆÙÙ˜e W¨oÓ>ˆHØ˜uÑ$Ø�Ør4   c                ó  — t        d| |«      }|dur|S g }g }| j                  rRt        | j                  |«      }|r:t        | j                  «      r|j	                  |«       n|j	                  d|f«       | j
                  �:| j
                  t        j                  k7  r|j	                  d| j
                  f«       | j                  �|j	                  d| j                  f«       | j                  r|j	                  d| j                  f«       | j                  }|r|j	                  dd|z  f«       d	t        |«      t        | j                  «      t        | j                  |«      |r+d
j!                  |D �cg c]  }t#        |«      ‘Œ c}«      d
z   ndd
j!                  |D ��cg c]  \  }}|›d|›�‘Œ c}}| j$                  j'                  «       D �	�cg c]  \  }	}|	›dt)        ||«      ›�‘Œ c}}	z   «      dœz  S c c}w c c}}w c c}}	w )Nré   Frü   rñ   rý   Úsystemru   rq   z8%(prefix)sColumn(%(name)r, %(type)s, %(args)s%(kwargs)s)rˆ   r8   r‡   )rs   r1   r  r„   r³   )r9  rü   rû   Ú*_should_render_server_default_positionallyrj   rñ   r   ÚAUTOINCREMENT_DEFAULTrý   r;  ru   r  r—   r1   rú   r  rI   r  r³   r«   r¬   )
ré   r0   rÿ   r„   rg   ru   ÚargÚkwnamer¯   r®   s
             r2   r‘   r‘     sî  € ô $ H¨f°oÓF€HØ�uÑØˆà€DØ"$€Dà×ÒÜ)Ø×!Ñ! ?ó
ˆñ Ü9Ø×%Ñ%ôð —‘˜HÕ%à—‘Ð-¨xÐ8Ô9ð 	×ÑÐ(Ø× Ñ ¤K×$EÑ$EÒEà�‰�_ f×&:Ñ&:Ð;Ô<à‡�Ð"Ø�‰�Z §¡Ð1Ô2à‡}‚}Ø�‰�X˜vŸ}™}Ð-Ô.à�n‰n€GÙØ�‰�Y  w¡Ð/Ô0ð FÜ1°/ÓBÜ�v—{‘{Ó#Ü˜6Ÿ;™;¨Ó8Ù@D�—	‘	©tÓ4©t¨œ3˜s�8¨tÑ4Ó5¸Ò<È"à�I‰IÙ<@ÔA¹D©[¨V°SšF¡CÒ(¸DÒAð %+§M¡M×$7Ñ$7Ô$9ôñ %:™˜˜Sò Ô2°3¸ÔHòJà$9òñóñIñ ð ùò 5ùó Bùós   Å7G>Æ$HÇH	c                óZ   — t        j                  | «      xs t        j                  | «      S r+   )r   Ú_server_default_is_computedÚ_server_default_is_identity)rü   s    r2   r<  r<  A  s-   € Ü×2Ñ2Øóò Aä	×	0Ñ	0°Ó	@ðAr4   c                óT  — t        d| |«      }|dur|S t        j                  | «      rt        t	        d| «      |«      S t        j
                  | «      rt        t	        d| «      |«      S t        | t        j                  «      r?t        | j                  t        «      r| j                  } n=t        | j                  |d¬«      S t        | t        j                  «      rt        |«      S t        | t        «      r"|r t        t!        j"                  dd| «      «      } t	        t        | «      S )	Nrü   Fr   r   T)r  z^'|'$r8   )r9  r   rA  Ú_render_computedr   rB  Ú_render_identityr,   r  ÚDefaultClauser>  r  r¬   r   Ú_render_fetched_valuerË   r9   r<   )Údefaultr0   Úrepr_rÿ   s       r2   rû   rû   G  sð   € ô
 $Ð$4°g¸ÓO€HØ�uÑØˆä×.Ñ.¨wÔ7Ü¤ Z°Ó 9¸?ÓKÐKÜ	×	0Ñ	0°Ô	9Ü¤ Z°Ó 9¸?ÓKÐKÜ	�GœY×4Ñ4Ô	5Ü�g—k‘k¤3Ô'Ø—k‘k‰Gä)Ø—‘˜_Àôð ô 
�GœY×3Ñ3Ô	4Ü$ _Ó5Ð5ä�'œ3Ô¡EÜ”r—v‘v˜h¨¨GÓ4Ó5ˆä”�WÓÐr4   c                óØ   — t        | j                  |d¬«      }i }| j                  �| j                  |d<   dt        |«      |dj	                  d„ |j                  «       D «       «      dœz  S )NFrÙ   Ú	persistedz(%(prefix)sComputed(%(text)s, %(kwargs)s)rˆ   c              3  ó&   K  — | ]	  }d |z  –— Œ y­w©z%s=%sNrŠ   ©r‹   Úpairs     r2   r�   z#_render_computed.<locals>.<genexpr>q  ó   è ø€ ÐG¹°˜W t�^¹ùrŽ   )rs   r>   r³   )r¬   rÜ   rK  r  rI   r«   )Úcomputedr0   r>   r³   s       r2   rD  rD  d  ss   € ô "Ø×Ñ˜/¸5ô€Dð €FØ×ÑÐ%Ø&×0Ñ0ˆˆ{ÑØ5Ü1°/ÓBØØ—9‘9ÑG¸¿¹¼ÓGÓGñ9ñ ð r4   c                óš   — t        j                  | d¬«      }dt        |«      dj                  d„ |j	                  «       D «       «      dœz  S )NT)r­   z%(prefix)sIdentity(%(kwargs)s)rˆ   c              3  ó&   K  — | ]	  }d |z  –— Œ y­wrM  rŠ   rN  s     r2   r�   z#_render_identity.<locals>.<genexpr>~  rP  rŽ   )rs   r³   )r   Ú_get_identity_options_dictr  rI   r«   )Úidentityr0   r³   s      r2   rE  rE  u  sM   € ô ×3Ñ3Ø ô€Fð ,Ü1°/ÓBØ—9‘9ÑG¸¿¹¼ÓGÓGñ/ñ ð r4   c                ó"   — ddt        | «      iz  S )Nz%(prefix)sFetchedValue()rs   )r  r2  s    r2   rG  rG  ‚  s   € Ø%ØÔ1°/ÓBð)ñ ð r4   c                óÐ  — t        d| |«      }|dur|S t        |j                  d«      r'|j                  j                  j	                  | |«      }nd }t        | «      j                  }|j                  }|s!t        j                  | «      rt        | |«      S |j                  d«      rLt        j                  d|«      }|€J ‚|j                  d«      }|�|j                  d|z  «       |r|S |›d| ›�S |r|S |j                  d	«      rMd
| j                   z  t#        «       v r#t#        «       d
| j                   z     }	 |	| |«      S t%        |«      }
|
›| ›�S t'        || «      }
|
›| ›�S )Nr  Fr  úsqlalchemy.dialectsúsqlalchemy\.dialects\.(\w+)r  z"from sqlalchemy.dialects import %sÚ.zsqlalchemy.z_render_%s_type)r9  Úhasattrr  r  Úrender_typer  r  rB   r   Ú_type_has_variantsÚ_render_Variant_typeÚ
startswithr9   rÉ   ÚgroupÚaddÚ__visit_name__Úglobalsr  r.  )rä   r0   Ú_skip_variantsrÿ   Úimpl_rtÚmodrB   rÉ   ÚdnameÚfnrs   s              r2   rú   rú   ˆ  sj  € ô
 $ F¨E°?ÓC€HØ�uÑØˆäˆ×0Ñ0°&Ô9Ø!×3Ñ3×8Ñ8×DÑDØ�?ó
‰ð ˆä
ˆu‹+×
 Ñ
 €CØ×%Ñ%€Gáœk×<Ñ<¸UÔCÜ# E¨?Ó;Ð;Ø	�‰Ð-Ô	.Ü—‘Ð7¸Ó=ˆØÐ Ð Ð Ø—‘˜A“ˆØÐØ�K‰KÐ<¸uÑDÔEÙØˆNâ#¡UÐ+Ð+Ù	ØˆØ	�‰˜Ô	&Ø˜u×3Ñ3Ñ3´w³yÑ@Ü“Ð,¨u×/CÑ/CÑCÑDˆBÙ�e˜_Ó-Ð-ä4°_ÓEˆFÙ#¡UÐ+Ð+ä*¨?¸EÓBˆÙ¡Ð'Ð'r4   c           	     ó:   — t        t        t        | |dd«      «      S )NÚ	item_typez(.+?\())r   r  Ú_render_type_w_subtype)rä   r0   s     r2   Ú_render_ARRAY_typerl  µ  s#   € ÜÜÜØ�? K°ó	
óð r4   c                ó¼   — t        j                  | «      \  }}t        ||d¬«      }|�|dusJ ‚t        |«      D ]  }||   }|dt        ||d¬«      ›d|›d�z  }Œ! |S )NT)rd  Fz.with_variant(rˆ   r§   )r   Ú_get_variant_mappingrú   rJ   )rä   r0   Ú	base_typeÚvariant_mappingÚbaseÚdialectÚtyps          r2   r^  r^  ¾  sx   € ô "-×!AÑ!AÀ%Ó!HÑ€IˆÜ�i ÀÔF€DØÐ ¨EÑ 1Ð1Ð1Ü˜/Ö*ˆØ˜gÑ&ˆÙÜ�s˜O¸DÖAÚð
ñ 	
‰ð +ð €Kr4   c                óè  — t        | «      }t        | |d «      }|€yt        |«      }t        j                  dd|«      }t	        t        | |«      |«      }t        j                  ||z   d|z  |«      }	|r|›|	›�S t        | «      j                  }
|
j                  d«      r2t        j                  d|
«      }|€J ‚|j                  d«      }|›d|	›�S |
j                  d	«      rt        |«      }|›|	›�S y )
NFz([\(\)])z\\\1z\1%srX  rY  r  rZ  Ú
sqlalchemy)rË   r  r9   r<   rú   r  r  r_  rÉ   r`  r  )rä   r0   ÚattrnameÚregexprs   Ú
outer_reprÚ
inner_typeÚ
inner_reprÚsub_typeÚ
outer_typerf  rÉ   rg  s                r2   rk  rk  Í  sò   € ô �e“€JÜ˜ ¨$Ó/€JØÐØä�jÓ!€Jä—‘˜ W¨jÓ9€JÜœ' %¨Ó2°OÓD€HÜ—‘˜ Ñ+¨W°xÑ-?ÀÓL€JáÙ¡Ð,Ð,ä
ˆu‹+×
 Ñ
 €CØ
‡~�~Ð+Ô,Ü—‘Ð7¸Ó=ˆØÐ Ð Ð Ø—‘˜A“ˆÚ¡Ð,Ð,Ø	�‰˜Ô	%Ü0°ÓAˆÙ¡Ð,Ð,àr4   c                óš   — 	 t         j                  | «      } || ||«      S # t        $ r  t        j                  d| z  «       d| z  cY S w xY w)Nz(No renderer is established for object %rz[Unknown Python object %r])Ú_constraint_renderersr_   Ú
ValueErrorr   râ   )rÒ   r0   Únamespace_metadatara   s       r2   r“   r“   ò  sX   € ð
IÜ(×1Ñ1°*Ó=ˆñ
 ˜
 OÐ5GÓHÐHøô	 ò 9Ü�	‰	Ð<¸zÑIÔJØ+¨jÑ8Ò8ð9ús   ‚! ¡&A
Á	A
c                ó   — t        d| |«      }|dur|S | j                  sy g }| j                  r0|j                  dt	        t        || j                  «      «      f«       dt        |«      dj                  | j                  D �cg c]  }t	        |j                  «      ‘Œ c}|D ��cg c]  \  }}|›d|›�‘Œ c}}z   «      dœz  S c c}w c c}}w )NÚprimary_keyFr1   z(%(prefix)sPrimaryKeyConstraint(%(args)s)rˆ   r‡   rÛ   )r9  r�   r1   rj   rË   r3   r  rI   )rÒ   r0   r€  rÿ   rg   Úcr?  r¯   s           r2   Ú_render_primary_keyr„     sÏ   € ô $ M°:¸ÓO€HØ�uÑØˆà×ÒØà€DØ‡‚Ø�‰Ø”TÔ*¨?¸J¿O¹OÓLÓMÐNô	
ð 6Ü1°/ÓBØ—	‘	Ø#-×#5Ò#5Ó6Ñ#5˜aŒT�!—&‘&�\Ð#5Ñ6Ù:>Ô?¹$©;¨6°3š&¡#Ò&¸$Ò?ñ@ó
ñ9ñ ð ùò 7ùÛ?s   ÂCÂ&C
c                óˆ  — t        j                  | «      \  }}}|�
|€|›d|›�}nt        j                  ||«      }|�}| j                  sq| j                  �e| j                  j
                  �O|�M||j                  v r?|j                  |   j                  j                  |«      }|�t        |j                  «      }|›d|›�}|S )zxImplement a 'safe' version of ForeignKey._get_colspec() that
    won't fail if the remote table can't be resolved.

    rZ  )r   Ú_fk_target_tokensÚ_get_table_keyÚlink_to_nameÚparentr�   Útablesrƒ  rh   r—   r1   )	ÚfkÚmetadata_schemar€  r	   rt   ÚcolnameÚtable_fullnamerž   Úcolspecs	            r2   Ú_fk_colspecr�    sÂ   € ô )×:Ñ:¸2Ó>Ñ€FˆE�7àÐ" v ~Ú$3±UÐ;‰ä$×3Ñ3°E¸6ÓBˆð 	ÐØ—’Ø�I‰IÐ!Ø�I‰I�O‰OÐ'ð Ð*ØÐ"4×";Ñ";Ñ;à$×+Ñ+¨NÑ;×=Ñ=×AÑAÀ'ÓJˆCØˆÜ  §¡Ó*�â'©Ð1€Gà€Nr4   c                ó^  — | j                   r&|j                  dt        | j                   «      f«       | j                  r&|j                  dt        | j                  «      f«       | j                  r&|j                  dt        | j                  «      f«       | j
                  r&|j                  dt        | j
                  «      f«       | j                  r&|j                  dt        | j                  «      f«       | j                  r'|j                  dt        | j                  «      f«       y y )NrÄ   rÅ   rÆ   rÇ   rÈ   rÉ   )rÄ   rj   rË   rÅ   rÆ   rÇ   rÈ   rÉ   )rÒ   rg   s     r2   Ú_populate_render_fk_optsr’  B  sç   € ð ×ÒØ�‰�Z¤ j×&9Ñ&9Ó!:Ð;Ô<Ø×ÒØ�‰�Z¤ j×&9Ñ&9Ó!:Ð;Ô<Ø×ÒØ�‰�[¤$ z×';Ñ';Ó"<Ð=Ô>Ø×ÒØ�‰�\¤4¨
×(=Ñ(=Ó#>Ð?Ô@Ø×ÒØ�‰�[¤$ z×';Ñ';Ó"<Ð=Ô>Ø×ÒØ�‰�Wœd :×#3Ñ#3Ó4Ð5Õ6ð r4   c                óæ  ‡‡— t        d| |«      }|dur|S g }| j                  r0|j                  dt        t	        || j                  «      «      f«       t        | |«       ‰�‰j                  nd Šdt        |«      dj                  d„ | j                  D «       «      dj                  ˆˆfd„| j                  D «       «      dj                  |D ��cg c]  \  }}|›d|›�‘Œ c}}«      d	œz  S c c}}w )
NÚforeign_keyFr1   zC%(prefix)sForeignKeyConstraint([%(cols)s], [%(refcols)s], %(args)s)rˆ   c              3  ól   K  — | ],  }t        t        |j                  j                  «      «      –— Œ. y ­wr+   )rË   r—   r‰  r1   )r‹   Úfs     r2   r�   z&_render_foreign_key.<locals>.<genexpr>m  s'   è ø€ ð Ù5H°””V˜AŸH™HŸM™MÓ*×+Ñ5Hùs   ‚24c              3  óJ   •K  — | ]  }t        t        |‰‰«      «      –— Œ y ­wr+   )rË   r�  )r‹   r–  Úapply_metadata_schemar€  s     €€r2   r�   z&_render_foreign_key.<locals>.<genexpr>p  s)   øè ø€ ð !á,�Aô ”[ Ð$9Ð;MÓN×OÙ,ùs   ƒ #r‡   )rs   ÚcolsÚrefcolsr„   )
r9  r1   rj   rË   r3   r’  r	   r  rI   Úelements)rÒ   r0   r€  rÿ   rg   r?  r¯   r˜  s     `    @r2   Ú_render_foreign_keyrœ  S  s  ù€ ô $ M°:¸ÓO€HØ�uÑØˆà€DØ‡‚Ø�‰Ø”TÔ*¨?¸J¿O¹OÓLÓMÐNô	
ô ˜Z¨Ô.ð &8Ð%CÐ×!Ò!Èð ð	#ô 6°oÓFØ—I‘Iñ Ø5?×5HÒ5Hóó ð —y‘yô !à#×,Ò,ó!ó ð —I‘IÙ<@ÔA¹D©[¨V°SšF¡CÒ(¸DÒAóñ
ñ	
ðùó Bs   ÃC-c                óB   — t        d| |«      }|dur|S t        | |d«      S )Nr²   F)r9  r¿   )rÒ   r0   r€  rÿ   s       r2   Ú_render_unique_constraintrž  {  s.   € ô $ H¨j¸/ÓJ€HØ�uÑØˆä˜* o°uÓ=Ð=r4   c           	     óÐ  — t        d| |«      }|dur|S | j                  rEt        | j                  d«      r/t        | j                  j                  t
        j                  «      ry g }| j                  r0|j                  dt        t        || j                  «      «      f«       dt        |«      |rddj                  d„ |D «       «      z   ndt        | j                  |d¬	«      d
œz  S )NÚcheckFr-  r1   z.%(prefix)sCheckConstraint(%(sqltext)s%(opts)s)rˆ   c              3  ó0   K  — | ]  \  }}|›d |›�–— Œ y­w)r‡   NrŠ   )r‹   r¢   r*  s      r2   r�   z+_render_check_constraint.<locals>.<genexpr>§  s   è ø€ Ð@¹4±4°1°aª©AÔ.¹4ùs   ‚r8   rÙ   )rs   rg   rÜ   )r9  Ú_create_ruler[  r,   r-  Úsqltypesr$   r1   rj   rË   r3   r  rI   r¬   rÜ   )rÒ   r0   r€  rÿ   rg   s        r2   Ú_render_check_constraintr¤  ˆ  sâ   € ô $ G¨Z¸ÓI€HØ�uÑØˆð 	×ÒÜ�J×+Ñ+¨XÔ6ÜØ×#Ñ#×*Ñ*Ü×Ñô
ð
 Ø€DØ‡‚Ø�‰Ø”TÔ*¨?¸J¿O¹OÓLÓMÐNô	
ð <Ü1°/ÓBñ ð �D—I‘IÑ@¹4Ó@Ó@ÒAàä)Ø×Ñ Àô
ñ
?ñ 
ð 
r4   c                ó˜   — t        |j                  t        «      st        d«      ‚dj	                  t        | «      |j                  ¬«      S )NznAutogenerate rendering of SQL Expression language constructs not supported here; please use a plain SQL stringz{prefix}execute({sqltext!r}))rs   rÜ   )r,   rÜ   r  rÖ   ry   r.   rc   s     r2   Ú_execute_sqlr¦  ±  sL   € ä�b—j‘j¤#Ô&Ü!ð@ó
ð 	
ð *×0Ñ0Ü+¨OÓ<Ø—
‘
ð 1ó ð r4   )r0   r%   r1   zsqla_compat._ConstraintNamer  z"quoted_name | str | _f_name | None)r>   r  r  r  )r0   r%   rK   r'   rL   zdict[str, str | Config]r  r	  )rV   zops.OpContainerr0   r%   r  r  )r0   r%   rZ   úops.MigrateOperationr  ú	list[str])r0   r%   rZ   r§  r  r  )r0   r%   rZ   r(   r  r¨  )r0   r%   rZ   zops.CreateTableCommentOpr  r  )r0   r%   rZ   zops.DropTableCommentOpr  r  )r0   r%   rZ   zops.CreateTableOpr  r  )r0   r%   rZ   zops.DropTableOpr  r  )r0   r%   r­   r   r  r¨  )r0   r%   rZ   zops.CreateIndexOpr  r  )r0   r%   rZ   zops.DropIndexOpr  r  )r0   r%   rZ   zops.CreateUniqueConstraintOpr  r¨  )r0   r%   rZ   zops.CreateForeignKeyOpr  r  )r0   r%   rZ   zops.CreateCheckConstraintOpr  r  )r0   r%   rZ   zops.DropConstraintOpr  r¨  )r0   r%   rZ   zops.AddColumnOpr  r  )r0   r%   rZ   zops.DropColumnOpr  r  )r0   r%   rZ   zops.AlterColumnOpr  r  )r1   zquoted_name | str | Noner  ú
str | None)rÓ   r   r0   r%   rÚ   rT   r  rT   r  rT   r  r  )r%  r   r0   r%   r  r¨  )rÒ   r"   r0   r%   r(  rT   r  r  )r0   r%   r  r  )rä   r  r7  r   r0   r%   r  zstr | Literal[False])ré   zColumn[Any]r0   r%   r  r  )rü   r   r  rT   )T)rH  z=None | (FetchedValue | str | TextClause | ColumnElement[Any])r0   r%   rI  rT   r  r©  )rQ  r   r0   r%   r  r  )rU  r   r0   r%   r  r  )F)rä   r$   r0   r%   rd  rT   r  r  )rä   r#   r0   r%   r  r  )rä   r$   r0   r%   r  r  r+   )rä   r$   r0   r%   rv  r  rw  r  rs   r©  r  zstr | None | Literal[False])rÒ   r   r0   r%   r€  úMetaData | Noner  r©  )rÒ   r!   r0   r%   r€  rª  r  r©  )r‹  r   rŒ  r©  r€  rª  r  r  )rÒ   r   rg   zlist[tuple[str, str]]r  r	  )rÒ   r   r0   r%   r€  rª  r  r©  )rÒ   r"   r0   r%   r€  rª  r  r  )rÒ   r   r0   r%   r€  rª  r  r©  )r0   r%   rZ   zops.ExecuteSQLOpr  r  )Ú
__future__r   Úior   r9   Útypingr   r   r   Ú
mako.pygenr   ru  r	   r  r
   r   r£  Úsqlalchemy.sql.baser   Úsqlalchemy.sql.elementsr   r   r   r8   r   Ú
operationsr   r   r   r   r   r   r   Úsqlalchemy.sql.schemar   r   r   r   r   r   r   r    r!   r"   Úsqlalchemy.sql.sqltypesr#   Úsqlalchemy.sql.type_apir$   Úalembic.autogenerate.apir%   Úalembic.configr&   Úalembic.operations.opsr'   r(   r–   rã   r3   r?   rO   Ú
DispatcherÚdefault_renderersr^   rF   rS   rd   Údispatch_forro   ÚCreateTableCommentOpr}   ÚDropTableCommentOpr   ÚCreateTableOpr¤   ÚDropTableOpr©   r°   ÚCreateIndexOprº   ÚDropIndexOpr½   ÚCreateUniqueConstraintOprÁ   ÚCreateForeignKeyOprÔ   ÚCreatePrimaryKeyOpr×   ÚCreateCheckConstraintOprÝ   ÚDropConstraintOpræ   ÚAddColumnOprë   ÚDropColumnOprï   ÚAlterColumnOpr   r-   r—   r¬   rµ   r¿   r.  r  r.   r9  r‘   r<  rû   rD  rE  rG  rú   rl  r^  rk  r~  r“   r„  r�  r’  rœ  rž  r¤  ÚExecuteSQLOpr¦  ÚbranchrŠ   r4   r2   Ú<module>rË     s2  ðõ #å Û 	Ý Ý Ý  å $Ý *Ý Ý (Ý /Ý (Ý )Ý /å Ý Ý áÝå#Ý#Ý5Ý2Ý5Ý,Ý0Ý2Ý0Ý:Ý+Ý.Ý:Ý6Ý-Ý2å7Ý%Ý6Ý5ð €òÐ ð9Ø#ð9à
%ð9ð (ó9óð:Ø#ð:à%ð:ð +ð:ð 
ó	:ð& !0 §¡Ó 1Ð 1Ð �IðØ!ðà#ðð 	óð6Ø#ðØ)=ðàóð5Ø#ð5Ø)=ð5àó5ð ×Ñ˜×*Ñ*Ó+ðØ#ðØ)7ðàòó ,ðð8 ×Ñ˜×0Ñ0Ó1ðØ#ðØ)Aðàòó 2ððB ×Ñ˜×.Ñ.Ó/ðØ#ðØ)?ðàòó 0ðð< ×Ñ˜×)Ñ)Ó*ò6ó +ð6ðr ×Ñ˜Ÿ™Ó(òó )ððØ#ðØ5Dðàóð ×Ñ˜×)Ñ)Ó*ò$ó +ð$ðN ×Ñ˜Ÿ™Ó(òó )ðð2 ×Ñ˜×4Ñ4Ó5ðGØ#ðGØ)EðGàòGó 6ðGð ×Ñ˜×.Ñ.Ó/ð+Ø#ð+Ø)?ð+àò+ó 0ð+ð\ ×Ñ˜×.Ñ.Ó/ñ ó 0ð ð ×Ñ˜×3Ñ3Ó4ðØ#ðØ)Dðàòó 5ðð( ×Ñ˜×,Ñ,Ó-ð Ø#ð Ø)=ð àò ó .ð ðF ×Ñ˜Ÿ™Ó(òó )ðð4 ×Ñ˜×(Ñ(Ó)òó *ðð8 ×Ñ˜×)Ñ)Ó*ð<Ø#ð<Ø):ð<àò<ó +ð<÷~<ñ <óð( !Ø#Øñ*Øð*à#ð*ð ð	*ð
 ð*ð ð*ð 	ó*ðZ
Ø	ð
Ø!/ð
àó
ð)
Ø ð)
à#ð)
ð ð)
ð 	ó	)
òXóBóCð	Øð	Øð	Ø/=ð	àó	ð6Øð6Ø*8ð6àó6órAð ðØJðà#ðð ðð ó	ð:ØðØ)7ðàóð"
Øð
Ø)7ð
àó
óð !ð*(Øð*(à#ð*(ð ð*(ð 	ó	*(óZðØðØ(6ðàóð( ðØðà#ðð ðð ð	ð
 ðð !óðD (˜Ÿ™Ó)Ð ðIØðIà#ðIð (ðIð ó	Ið ×#Ñ# I×$BÑ$BÓCðØ$ðà#ðð (ðð ò	ó Dðð4$Øð$àð$ð (ð$ð 	ó	$ðN7Ø$ð7Ø,Að7à	ó7ð" ×#Ñ# I×$BÑ$BÓCð$Ø$ð$à#ð$ð (ð$ð ò	$ó Dð$ðN ×#Ñ# I×$>Ñ$>Ó?ð	>Ø ð	>à#ð	>ð (ð	>ð 	ò		>ó @ð	>ð ×#Ñ# I×$=Ñ$=Ó>ð%Øð%à#ð%ð (ð%ð ò	%ó ?ð%ðP ×Ñ˜×(Ñ(Ó)ò	ó *ð	ð ×$Ñ$Ó&�	r4   