GIF89a=( õ' 7IAXKgNgYvYx\%wh…hŽth%ˆs%—x¨}9®Œ©€&©‰%¶†(¹–.¹5·œD¹&Çš)ÇŸ5ǘ;Í£*È¡&Õ²)ׯ7×µ<Ñ»4ï°3ø‘HÖ§KͯT÷¨Yÿšqÿ»qÿÔFØ !ù ' !ÿ NETSCAPE2.0 , =( þÀ“pH,È¤rÉl:ŸÐ¨tJ­Z¯Ø¬vËíz¿à°xL.›Ïè´zÍn»ßð¸|N¯Ûïø¼~Ïïûÿ€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§gª«ªE¯°¨¬ª±²Œ¹º¹E¾­”´ÂB¶¯ §Åȸ»ÑD¾¿Á•ÄÅ®° ÝH¾ÒLÀÆDÙ«D¶BÝïðÀ¾DÑÑÔTÌÍíH òGö¨A RÎڐ |¥ ٭&ºìE8œ¹kGÔAÞpx­a¶­ã R2XB®åE8I€Õ6Xî:vT)äžþÀq¦è³¥ì仕F~%xñ  4#ZÔ‰O|-4Bs‘X:= QÉ œš lºÒyXJŠGȦ|s hÏíK–3l7·B|¥$'7Jީܪ‰‡àá”Dæn=Pƒ ¤Òëí‰`䌨ljóá¯Éüv>á–Á¼5 ½.69ûϸd«­ºÀûnlv©‹ªîf{¬ÜãPbŸ  l5‘ޝpß ´ ˜3aÅùäI«O’ý·‘áÞ‡˜¾Æ‚ÙÏiÇÿ‹Àƒ #öó)pâš Þ½ ‘Ý{ó)vmÞü%D~ 6f s}ŃƒDØW Eþ`‡þ À…L8xá†ç˜{)x`X/> Ì}mø‚–RØ‘*|`D=‚Ø_ ^ð5 !_…'aä“OÚ—7âcð`D”Cx`ÝÂ¥ä‹éY¹—F¼¤¥Š?¡Õ™ n@`} lď’ÄÉ@4>ñd œ à‘vÒxNÃ×™@žd=ˆgsžG±æ ´²æud &p8Qñ)ˆ«lXD©øÜéAžHìySun jª×k*D¤LH] †¦§C™Jä–´Xb~ʪwStŽ6K,°£qÁœ:9ت:¨þªl¨@¡`‚ûÚ ».Û¬¯t‹ÆSÉ[:°=Š‹„‘Nåû”Ìî{¿ÂA ‡Rà›ÀÙ6úë°Ÿð0Ä_ ½;ÃϱîÉì^ÇÛÇ#Ëë¼ôº!±Ä˜íUîÅÇ;0L1óÁµö«p% AÀºU̬ݵ¼á%霼€‡¯Á~`ÏG¯»À× ­²± =4ªnpð3¾¤³¯­ü¾¦îuÙuµÙ®|%2ÊIÿür¦#0·ÔJ``8È@S@5ê¢ ö×Þ^`8EÜ]ý.뜃Âç 7 ú ȉÞj œ½Dç zý¸iþœÑÙûÄë!ˆÞÀl§Ïw‹*DçI€nEX¯¬¼ &A¬Go¼QföõFç°¯;é¦÷îŽêJ°îúôF5¡ÌQ|îúöXªæ»TÁÏyñêï]ê² o óÎC=öõ›ÒÓPB@ D×½œä(>èCÂxŽ`±«Ÿ–JЀ»Û á¤±p+eE0`ëŽ`A Ú/NE€Ø†À9‚@¤à H½7”à‡%B‰`Àl*ƒó‘–‡8 2ñ%¸ —€:Ù1Á‰E¸àux%nP1ð!‘ðC)¾P81lÑɸF#ˆ€{´âé°ÈB„0>±û °b¡Š´±O‚3È–Ù()yRpbµ¨E.Z‘D8ÊH@% òŒx+%Ù˜Æcü »¸˜fõ¬b·d`Fê™8èXH"ÉÈ-±|1Ô6iI, 2““¬$+](A*jÐ QTÂo‰.ÛU슬Œã„Ž`¯SN¡–¶Äåyše¯ª’­¬‚´b¦Éož œ)åyâ@Ì®3 ÎtT̉°&Ø+žLÀf"Ø-|žçÔ>‡Ðv¦Ðžì\‚ Q1)Ž@Žh#aP72”ˆ™¨$‚ !ù " , =( …7IAXG]KgNgYvYxR"k\%w]'}hŽth%ˆg+ˆs%—r.—m3šx3˜x¨}9®€&©€+¨‡7§‰%¶†(¹–.¹œD¹&ǘ;Í•&ײ)×»4ïÌ6ò§KÍ þ@‘pH,È¤rÉl:ŸÐ¨tJ­Z¯Ø¬vËíz¿à°xL.›Ïè´zÍn»ßð¸|N¯Ûïø¼~Ïïûÿ€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§g «¬ E ±± ¨­¶°ººE Á´”·®C¬²§Ç¶Œ»ÓDÃÕƷ¯Ê±H½ºM×ÁGÚ¬D¶BËÁ½î½DÓôTÏÛßîG»ôõC×CÌ l&âž:'òtU³6ɹ#·Ø)€'Ü.6±&ëÍÈ» K(8p0N?!æ2"ÛˆNIJX>R¼ÐO‚M '¡¨2¸*Ÿþ>#n↠å@‚<[:¡Iïf’ ¤TÚ˘CdbÜÙ“[«ŽEú5MBo¤×@€`@„€Êt W-3 ¶Ÿ¡BíêäjIÝ…Eò9[T…$íêﯧ„…•s»Óȳ¹€ÅÚdc®UUρ#±Ùïldj?´í¼²`\ŽÁðÞu|3'ÖŒ]ë6 ¶S#²‡˜FKLÈ *N E´‘áäŠ$˜›eÄYD„ºq«.è촁ƒs \-ÔjA 9²õ÷å- üúM[Âx(ís÷ì®x€|í¡Ù’p¦‚ ŽkÛTÇDpE@WÜ ²Ç]kŠ1¨ þ€·Yb ÓÁ‰l°*n0 ç™—žzBdОu¾7ĉBl€â‰-ºx~|UåU‰  h*Hœ|e"#"?vpÄiŠe6^ˆ„+qâŠm8 #VÇá ‘å–ÄV„œ|Аè•m"сœn|@›U¶ÆÎž—Špb¥G¨ED”€±Úê2FÌIç? >Éxå Œ± ¡¤„%‘žjŸ‘ꄯ<Ìaà9ijÐ2˜D¦È&›†Z`‚å]wþ¼Â:ç6àB¤7eFJ|õÒ§Õ,¨äàFÇ®cS·Ê¶+B°,‘Þ˜ºNûãØ>PADÌHD¹æž«ÄÀnÌ¥}­#Ë’ë QÀÉSÌÂÇ2ÌXÀ{æk²lQÁ2«ÊðÀ¯w|2Í h‹ÄÂG€,m¾¶ë3ÐÙ6-´ÅE¬L°ÆIij*K½ÀÇqï`DwVÍQXœÚÔpeœ±¬Ñ q˜§Tœ½µƒ°Œìu Â<¶aØ*At¯lmEØ ü ôÛN[P1ÔÛ¦­±$ÜÆ@`ùåDpy¶yXvCAyåB`ŽD¶ 0QwG#¯ æš[^Äþ $ÀÓÝǦ{„L™[±úKÄgÌ;ï£S~¹ìGX.ôgoT.»åˆ°ùŸûù¡?1zö¦Ÿž:ÅgÁ|ìL¹ „®£œŠ‚à0œ]PÁ^p F<"•ç?!,ñ‡N4—…PÄ Á„ö¨Û:Tè@hÀ‹%táÿ:ø-žI<`þ‹p I….)^ 40D#p@ƒj4–؀:²‰1Øâr˜¼F2oW¼#Z†;$Q q” ‘ ÂK¦ñNl#29 !’F@¥Bh·ᏀL!—XFóLH‘Kh¤.«hE&JòG¨¥<™WN!€ÑÙÚˆY„@†>Œž19J" 2,/ &.GXB%ÌRÈ9B6¹W]’î×ÔW¥’IÎ$ ñ‹ÓŒE8YÆ ¼³™ñA5“à®Q.aŸB€&Ø©³ JÁ—! ¦t)K%tœ-¦JF bòNMxLôþ)ÐR¸Ð™‘ èÝ6‘O!THÌ„HÛ ‰ !ù ) , =( …AXKgNgYvYxR"k\%wh…hŽh%ˆg+ˆs%—r.—x3˜x¨}9®€&©€+¨Œ,©‡7§‰%¶†(¹–.¹5·&Çš)ǘ;Í•&×£*Ȳ)ׯ7×»4ï°3øÌ6ò‘HÖ§KÍ»Hó¯T÷¨Yÿ»qÿÇhÿ þÀ”pH,È¤rÉl:ŸÐ¨tJ­Z¯Ø¬vËíz¿à°xL.›Ïè´zÍn»ßð¸|N¯Ûïø¼~Ïïûÿ€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§g ª« E$±²¨ª­ · °²½$E$ÂÕ««D· Í ¿¦Ç¶¸ÌŒ¾³CÃÅÆ E ééH½MÛÂGâªD­ çBêêϾD²ÒaÀà€Š1r­ðÓ¤ ÔožzU!L˜C'¾yW½UGtäÇïÙllê0×àÂuGþ)AÀs[þ·xì ÁxO%ƒûX2ó—  P£n›R/¡ÑšHše+êDm?# —‘Ç£6¡8íJ¡ŸâDiäªM¥Ö„ôj“¬¹£5oQ7°- <‡ *´lãÓŒ2r/a!l)dÈ A™ÈE¢ôÔ͆…ð ;Ö˜c ¡%ß‚’Ùˆâ¸b½—pe~C"BíëÚHïeF2§æŠ8qb t_`urŠeü wÅu3êæPv§h•"ß`íÍxçLĹÜÖ3á  ~Öº“®›¸ÏMDfJÙ °„ÛµáWõ%§œ‚à©–‚X ÓØ)@®Ñ›Eþ´wëuÅSxb8y\mÖzœ¥§ZbºE—ÂLªÌw!y(>¡™wú=Ç|ÅÝs¢d €CÁW)HÜcC$€L Ä7„r.á\{)@ð` @ äXÈ$PD” `šaG:§æˆOˆ72EÐamn]ù"ŒcÊxÑŒ° &dR8`g«iÙŸLR!¦P …d’ä¡“¦ðÎTƒ¦ià|À _ ¥ Qi#¦Šg›Æ ›noMµ ›V ã£)p ç£ÎW…š=Âeªk§†j„ ´®1ß²sÉxéW«jšl|0¯B0Û, \jÛ´›6±¬¶C ÛíWþï|ëÙ‹¸ñzĸV {ì;Ýñn¼òVˆm³I¼³.Ðã¤PN¥ ²µ¼„µCã+¹ÍByî£Ñ¾HŸ›ëê 7ìYÆFTk¨SaoaY$Dµœìï¿Ã29RÈkt Çïfñ ÇÒ:ÀÐSp¹3ÇI¨â¥DZÄ ü9Ïýögñ½­uÔ*3)O‘˜Ö[_hv ,àî×Et Ÿé¶BH€ Õ[ü±64M@ÔSÌM7dÐl5-ÄÙU܍´©zߌ3Ô€3ž„ „ ¶ÛPô½5×g› êÚ˜kN„Ý…0Îj4€Ìë°“#{þÕ3S2çKÜ'ợlø¼Ú2K{° {Û¶?žm𸧠ËI¼nEò='êüóºè^üæÃ_Û=°óž‚ì#Oý¿Í'¡½áo..ÏYìnüñCœO±Áa¿¢Kô½o,üÄËbö²çºíï{ËC Ú— "”Ï{ËK ÍÒw„õ±Oz dÕ¨à:$ ƒô—«v»] A#ð «€¿šéz)Rx׿ˆ¥‚d``èw-îyÏf×K!ð€þ­Ð|ìPľ„=Ì`ý(f” 'Pa ¥ÐBJa%Ðâf§„%Š¡}FàáÝ×6>ÉäŠG"éŽè=ø!oа^FP¼Ø©Q„ÀCÙÁ`(Ž\ÄÝ® ©Â$<n@dÄ E#ììUÒI! ‚#lù‹`k¦ÐÇ'Rró’ZýNBÈMF Í[¤+‹ðɈ-áwj¨¥þ8¾rá ,VÂh„"|½œ=×G_¦Ñ™EØ 0i*%̲˜Æda0mV‚k¾)›;„&6 p>ÓjK “¦Ç# âDÂ:ûc?:R Ó¬fÞéI-Ì“•Ã<ä=™Ï7˜3œ¨˜c2ŒW ,ˆ”8(T™P‰F¡Jhç"‚ ; 403WebShell
403Webshell
Server IP : 104.21.83.152  /  Your IP : 216.73.216.195
Web Server : LiteSpeed
System : Linux premium229.web-hosting.com 4.18.0-553.45.1.lve.el8.x86_64 #1 SMP Wed Mar 26 12:08:09 UTC 2025 x86_64
User : akhalid ( 749)
PHP Version : 8.3.22
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /opt/hc_python/lib/python3.12/site-packages/alembic/operations/__pycache__/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /opt/hc_python/lib/python3.12/site-packages/alembic/operations/__pycache__/batch.cpython-312.pyc
�

y��g+i���ddlmZddlmZddlmZddlmZddlmZddlmZddlmZddlm	Z	dd	l
mZdd
l
mZddl
m
Z
ddl
mZdd
l
mZddl
mZddl
mZddl
mZddl
mZddl
mZddlmZddlmZddlmZddlmZddlmZddlm Z ddlm!Z!ddlm"Z"ddlm#Z#ddlm$Z$ddlm%Z%ddlm&Z&dd lm'Z'dd!lm(Z(dd"lm)Z)er0dd#lm*Z*dd$l+m,Z,dd%l-m.Z.dd&l-m/Z/dd'l0m1Z1dd(lm2Z2dd)l3m4Z4dd*l5m6Z6Gd+�d,�Z7Gd-�d.�Z8y/)0�)�annotations)�Any)�Dict)�List)�Optional)�Tuple)�
TYPE_CHECKING)�Union)�CheckConstraint)�Column)�ForeignKeyConstraint)�Index)�MetaData)�PrimaryKeyConstraint��schema)�select)�Table)�types)�SchemaEventTarget)�OrderedDict)�topological�)�exc)�_columns_for_constraint)�_copy)�_copy_expression)�_ensure_scope_for_ddl)�_fk_is_self_referential)�_idx_table_bound_expressions)�_is_type_bound)�_remove_column_from_collection)�_resolve_for_variant)�constraint_name_defined)�constraint_name_string)�Literal)�Dialect)�ColumnClause)�quoted_name)�Function)�
Constraint)�
TypeEngine)�DefaultImplc��eZdZd�Zedd��Zedd��Zdd�Zdd�Zdd�Z	dd�Z
dd�Zdd	�Zdd
�Z
d�Zdd�Zdd
�Zd�Zd�Zd�Zd�Zd�Zy)�BatchOperationsImplc	���||_||_||_|dvrtd��||_||_||_t|�|_||_	t|	�|_
|jjdt|jjdd���|jdjd|jj f�|
|_||_g|_y)N)�auto�always�neverz4recreate may be one of 'auto', 'always', or 'never'.�	listeners��column_reflect)�
operations�
table_namer�
ValueError�recreate�	copy_from�
table_args�dict�table_kwargs�reflect_args�reflect_kwargs�
setdefault�list�get�append�impl�autogen_column_reflect�naming_convention�partial_reordering�batch)�selfr7r8rr:r;r<r>r?r@rGrHs            �G/opt/hc_python/lib/python3.12/site-packages/alembic/operations/batch.py�__init__zBatchOperationsImpl.__init__7s���%���$�������6�6��F��
�!��
�"���$��� ��.���(���"�>�2������&�&���d�1�1�5�5�k�2�F�G�	
�	
���K�(�/�/�
�z���E�E�F�	
�"3���"4�����
�c�B�|jjjS�N)r7rE�dialect�rJs rKrPzBatchOperationsImpl.dialect\s�����#�#�+�+�+rMc�.�|jjSrO)r7rErQs rKrEzBatchOperationsImpl.impl`s�����#�#�#rMc��|jdk(r%|jjj|�S|jdk(ryy)Nr1r2TF)r:r7rE�requires_recreate_in_batchrQs rK�_should_recreatez$BatchOperationsImpl._should_recreateds;���=�=�F�"��?�?�'�'�B�B�4�H�H�
�]�]�h�
&��rMc	��|j�}t|jj�5|s?|jD].\}}}t|jj|�}||i|���0�n�|jrt|j��}n
t�}|j�|j}d}n�|jjjrNtjd|jjjj�d|j �d���t#|j |g|j$��|j&|jj)�d�|j*��}d}t-|j||j.|j0||j2��}	|jD]\}}}t|	|�}||i|���|	j5|j�ddd�y#1swYyxYw)	N)rGFzEThis operation cannot proceed in --sql mode; batch mode with dialect zF requires a live database connection with which to reflect the table "z�". To generate a batch SQL migration script using table "move and copy", a complete Table object should be passed to the "copy_from" argument of the batch_alter_table() method so that table reflection can be skipped.)r�
autoload_withT)rH)rUrrE�
connectionrI�getattrr7rGrr;�migration_context�as_sqlr�CommandErrorrP�namer8rr?r�get_bindr@�ApplyBatchImplr<r>rH�_create)
rJ�should_recreate�opname�arg�kw�fn�m1�existing_table�	reflected�
batch_impls
          rK�flushzBatchOperationsImpl.flushls����/�/�1��
"�4�9�9�#7�#7�
8�"�'+�z�z�O�F�C�� ����!5�!5�v�>�B���N�r�N�(2��)�)�!�D�4J�4J�K�B�!��B��>�>�-�%)�^�^�N� %�I����8�8�?�?�!�.�.�7�#���@�@�H�H�M�M�N�O5�59�_�_�4E�F9�	
9���&+�����&�
�*�*�&� $�{�{�&*�o�o�&>�&>�&@�	&��-�-�
&�N�!%�I�+��I�I�"��O�O��%�%��'+�'>�'>�
�
�(,�z�z�O�F�C�� ��V�4�B���N�r�N�(2��"�"�4�9�9�-�i9�
8�
8�s�G
H�Hc�@�|jjd||f�y)N�alter_column�rIrD�rJrcrds   rKrlz BatchOperationsImpl.alter_column�����
�
���>�3��3�4rMc��d|vsd|vr%|j�stjd��|jj	d||f�y)N�
insert_before�insert_afterz^Can't specify insert_before or insert_after when using ALTER; please specify recreate='always'�
add_column)rUrr\rIrDrns   rKrszBatchOperationsImpl.add_column�sP���r�!�^�r�%9��'�'�)��"�"�:��
�	
�
�
���<��b�1�2rMc�@�|jjd||f�y)N�drop_columnrmrns   rKruzBatchOperationsImpl.drop_column�s���
�
���=�#�r�2�3rMc�B�|jjd|fif�y)N�add_constraintrm�rJ�consts  rKrwz"BatchOperationsImpl.add_constraint�s���
�
���+�e�X�r�:�;rMc�B�|jjd|fif�y)N�drop_constraintrmrxs  rKr{z#BatchOperationsImpl.drop_constraint�s���
�
���,�u�h��;�<rMc�@�|jjd||f�y)N�rename_tablermrns   rKr}z BatchOperationsImpl.rename_table�rorMc�B�|jjd|f|f�y)N�create_indexrm�rJ�idxrds   rKrz BatchOperationsImpl.create_index�s���
�
���>�C�6�2�6�7rMc�B�|jjd|f|f�y)N�
drop_indexrmr�s   rKr�zBatchOperationsImpl.drop_index�s���
�
���<�#���4�5rMc�B�|jjd|fif�y)N�create_table_commentrm�rJ�tables  rKr�z(BatchOperationsImpl.create_table_comment�s���
�
���1�E�8�R�@�ArMc�B�|jjd|fif�y)N�drop_table_commentrmr�s  rKr�z&BatchOperationsImpl.drop_table_comment�s���
�
���/�%��2�>�?rMc��td��)Nz Can't create table in batch mode��NotImplementedErrorr�s  rK�create_tablez BatchOperationsImpl.create_table�s��!�"D�E�ErMc��td��)NzCan't drop table in batch moder�r�s  rK�
drop_tablezBatchOperationsImpl.drop_table�s��!�"B�C�CrMc�B�|jjd|fif�y)N�create_column_commentrm�rJ�columns  rKr�z)BatchOperationsImpl.create_column_comment�s���
�
���2�V�I�r�B�CrMN)�returnr')r�r-)r��bool�r��None�ryr+r�r�)r�rrdrr�r�)�__name__�
__module__�__qualname__rL�propertyrPrErUrjrlrsrurwr{r}rr�r�r�r�r�r�r5rMrKr/r/6s���#�J�,��,��$��$��7.�r5�3�4�<�=�5�8�6�B�@�F�D�DrMr/c�<�eZdZ	d													dd�Zedd��Zdd�Zdd�Zdd�Zdd�Z							dd�Z
dd�Z						d																	dd
�Z								dd�Z
		d 									d!d�Z						d"d
�Zd�Zd�Zd�Zd#d�Zd#d�Zd$d�Zd$d�Zd�Zy	)%r_c�^�||_||_||_||_|j	|j
�|_d|_||_d|_	td�|jjD��|_t|j�|_||_|j!�y)Nr5c3�<K�|]}|jd|if���y�w��exprN)r])�.0�cs  rK�	<genexpr>z*ApplyBatchImpl.__init__.<locals>.<genexpr>�s!����,
�+7�a�Q�V�V�f�a�[�!�<�s�)rEr�r<r>�_calc_temp_namer]�temp_table_name�	new_tablerH�add_col_orderingrr��column_transfersrB�existing_orderingrh�_grab_table_elements)rJrEr�r<r>rhrHs       rKrLzApplyBatchImpl.__init__�s�����	���
�$���(���#�3�3�E�J�J�?���*.���"4���
�	
��!,�,
�+/�:�:�<�<�,
�!
���"&�d�&;�&;�!<���"����!�!�#rMc��d|zddS)Nz_alembic_tmp_%sr�2r5)�cls�	tablenames  rKr�zApplyBatchImpl._calc_temp_name�s��!�I�-�q��4�4rMc��|jj}t�|_|jjD]j}t||��}dx|_|_t|jt�r|j|jusJ�||j|j<�li|_g|_
i|_i|_i|_|jj"D]�}t%|�r�|j&rt|t(�r
|js�8t+|j�r||j|j<�g|jj-|���|j&sT|jjD];}|j"D]*}|js�||f|j|j<�,�=|jjD]}||j|j<�|jj.D]5}|j0j3||jj.|��7y)NrF)r�rr�columnsr�r�unique�index�
isinstance�typerr]�named_constraints�unnamed_constraints�col_named_constraints�indexes�new_indexes�constraintsr!rhrr%rD�kwargsr>rA)rJrr��c_copyry�colr��ks        rKr�z#ApplyBatchImpl._grab_table_elements�s������"�"��/:�}��������A��1�V�,�F�+0�0�F�M�F�L��!�&�&�"3�4��{�{�!�&�&�0�0�0�#)�D�L�L���� ��9;���#%�� �%'��"�)+���-/����Z�Z�+�+�E��e�$������u�o�6��
�
�
�'��
�
�3�5:��&�&�u�z�z�2��(�(�/�/��6�,�"�~�~��z�z�|�|�� �_�_�E��z�z�BE�u���2�2�5�:�:�>�-�$�
�:�:�%�%�C�%(�D�L�L����"�&����"�"�A����(�(��D�J�J�,=�,=�a�,@�A�#rMc�x��t�}t�j�}�jrD�jD]4}t	|�D]$\}}|dkDs�|j||dz
|f��&�6n<t	�j�D]$\}}|dkDs�|j||dz
|f��&|j�j�|D�cgc]}|d|dk7s�|��}}ttj||d���}t�fd�|D���_t�fd�|D���_ycc}w)Nr�T)�deterministic_orderc3�@�K�|]}|�j|f���y�wrO)r��r�r�rJs  �rKr�zMApplyBatchImpl._adjust_self_columns_for_partial_reordering.<locals>.<genexpr>=s�����"I��A�A�t�|�|�A��#7����c3�@�K�|]}|�j|f���y�wrO)r�r�s  �rKr�zMApplyBatchImpl._adjust_self_columns_for_partial_reordering.<locals>.<genexpr>>s%�����,
�3:�a�Q��%�%�a�(�)�7�r�)
�setrBr�rH�	enumerate�addr��updater�r�sortrr�)	rJ�pairs�
col_by_idx�tuple_r��elem�p�
pairs_list�sorted_s	`        rK�+_adjust_self_columns_for_partial_reorderingz:ApplyBatchImpl._adjust_self_columns_for_partial_reordering$s)�������$�,�,�'�
��"�"��1�1��#,�V�#4�K�E�4��q�y��	�	�6�%�!�)�#4�d�";�<�$5�2�
 )��)?�)?�@���t��1�9��I�I�z�%�!�)�4�d�;�<� A�	���T�*�*�+�
"'�7��A�!�A�$�!�A�$�,�a��
�7�����Z���N�
��#�"I��"I�I��� +�,
�3:�,
�!
����
8s�D7�D7c�x�|j�Jd��t�}|jj}|js|j
r|j
�t|j|gt|jj��t|j�z��d|i|j��x|_}t|jj��|jzD]�}t!|�D�chc]}|j"��}}|j%|j&�s�At)|t*�r2t-|�rt/|||j��}nt/||��}nt/|||��}t)|t*�r|j1||�|j3|���ycc}w)NzCan only create new table oncer)r�target_tabler)r�rr�rrHr�r�rr�rBr��valuesr<r>r�r�r�key�issubsetr�r�r
rr�_setup_referent�append_constraint)rJ�mrr�ryr��
const_columns�
const_copys        rK�_transfer_elements_to_new_tablez.ApplyBatchImpl._transfer_elements_to_new_tableBs����~�~�%�G�'G�G�%��J�����"�"���"�"�d�&;�&;��<�<�>�%*�� � �
�&
��4�<�<�&�&�(�)�D����,A�A�&
��	&
�
���&
�	
����
��'�'�.�.�0�1�D�4L�4L�L�
�-D�E�,J�K�,J�q�Q�U�U�,J�M�K� �)�)�$�*?�*?�@���%�!5�6�*�5�1�"'��f�4�:�:�"�J�"'�u�V�!<�J�"��&�y��
��%�!5�6��$�$�Q��.��'�'�
�3�=
M��Ks�F7c��|j�J�g}|jj�D]�}|jr�t	|j
gt
|�D�cgc]}t||j���c}��|j|jd�|j��}|j|���|jj�D]}}|jt	|j
g|jj�D�cgc]}|jj|��c}��d|ji|j����|Scc}wcc}w)N)r��_tabler�)r�r�r��_column_flagrr]r rr�r�rDr�r��keysr�)rJr��idx_existingr��idx_copyr�r�s       rK� _gather_indexes_from_both_tablesz/ApplyBatchImpl._gather_indexes_from_both_tablestsO���~�~�)�)�)��� �L�L�/�/�1�L��(�(����!�!�	�
!=�\� J�� J��%�T�4�>�>�:� J��	�#�*�*�
�~�~�	��%�%�	�H�
�J�J�x� �!2�$�%�%�,�,�.�E��J�J���J�J��8=�}�}�7I�7I�7K�L�7K��d�n�n�&�&�s�+�7K�L�� �<�<���l�l�	�
�/��
��%��Ms�E� Ec
���|jdj�}|jd�}|d}t|�dk(r|d}nd}||jk7�rtj||�}dd�}||jvrs|j|}	|jD]T}
||
�jd�d}||	jvs�,|	jt|tj���Vyt||g|jD�
cgc]}
||
�jd�d��c}
D�cgc]}t|tj���c}��d|i�yycc}
wcc}w)	Nr�.����c�"�|j�SrO)�_get_colspec)r�s rK�colspecz/ApplyBatchImpl._setup_referent.<locals>.colspec�s���(�(�*�*rM���r)r�r)�elementsr��split�lenr��
sql_schema�_get_table_key�tablesr��
append_columnr�sqltypes�NULLTYPEr)
rJ�metadata�
constraint�spec�parts�tname�referent_schemar�r��tr��colname�ns
             rKr�zApplyBatchImpl._setup_referent�si���"�"�1�%�2�2�4���
�
�3����b�	���u�:��?�#�A�h�O�"�O��D�(�(�(��+�+�E�?�C�C�
+��h�o�o�%��O�O�C�(��&�/�/�D�%�d�m�1�1�#�6�r�:�G��a�c�c�)�����w��8I�8I�(J�K�0�
����)3�(;�(;�"�(;��$�D�M�/�/��4�R�8�(;�"��"�A��q�(�"3�"3�4�"���+��)��$"��s�!E
�1!E"
c��|j�|j||j�|j�J�|j	|j�	|j|jj
�j�jtd�|jj�D��t|jj�D�cgc]}d|vr|d��
c}���|j|j�|j|j |jj"|jj$��|jj"|j_	|j'�D]}|j)|��	|j |j_ycc}w#|j |j_wxYw#|j|j��xYw)Nc3�.K�|]
\}}d|vr|���y�wr�r5)r�r��transfers   rKr�z)ApplyBatchImpl._create.<locals>.<genexpr>�s$�����+H�K�A�x�!�X�-��+H�s�r�r)r��prep_table_for_batchr�r�r��_exec�insert�inline�from_selectrBr��itemsrr�r�r}r�r]rr�r)rJ�op_implrr�s    rKr`zApplyBatchImpl._create�s����,�,�.��$�$�T�4�:�:�6��~�~�)�)�)����T�^�^�,� 	;��M�M����%�%�'��������+/�+@�+@�+F�+F�+H���
�-1�,A�,A�,H�,H�,J��,J��%��1�%�V�,�,J���

�
�$
���t�z�z�*�

� � ��$�$�d�j�j�o�o�d�j�j�>O�>O�
!�
�#'�*�*�/�/�D�N�N��
;��@�@�B�C��(�(��-�C�'+�&:�&:����#��+��*'+�&:�&:����#��	����t�~�~�.��s+�BG(�G�-'G(�&G�G(�G%�(HNc	��|j|}
|j|}|��||k7r�||
_||d<|	jdd�}|ret	|	d|j
j�}
t|
t�r2|
jr&|jj|
jd�|�utj|�}t|
jt�r"dx|
j_|
j_|j
j!|
||�||
_
|�||
_|dur.|�d|
_n$t'j(|�j+|
�|�t-|�|
_|dur||
_yy)Nr]�
existing_typeF)r�r�r]rCr#rErPr�rr��popr��to_instancer��_create_events�create_constraint�cast_for_batch_migrate�nullable�server_defaultr��
DefaultClause�_set_parentr��
autoincrement�comment)rJr8�column_namerrr]�type_rrrd�existing�existing_transferr�resolved_existing_types              rKrlzApplyBatchImpl.alter_column�s����<�<��,��,0�,A�,A�+�,N������ 3�!�H�M�(,��f�%��F�F�?�D�9�M��)=���'����):�):�*�&��5�7H�I�.�3�3��*�*�.�.�.�3�3���
���(�(��/�E��(�-�-�):�;����
�
�,��M�M�3�
�I�I�,�,��+�U�
�"�H�M��� (�H����&��%�*.��'��(�(�"���+�h�'��$�%)�-�%8�H�"��%��&�H�� rMc�F�|j}t|�D��cic]\}}||��
}}}|jsz|r:|s8||vr||dz}|t|�kr||}nt	|j
�|}|r<|s:||vr||dz
}|dk\r)||}n#|j
D�	�
cic]\}	}
|
|	��
c}
}	|}|r|xj
||ffz
c_|r|xj
||ffz
c_|js%|s"|s|r|xj
|d|ffz
c_yyyyycc}}wcc}
}	w)Nr�rr�)r�r�rHr�r=r�)rJr�rqrr�
index_cols�ir]�col_indexesr��a�bs           rK�"_setup_dependencies_for_add_columnz1ApplyBatchImpl._setup_dependencies_for_add_column.ss���+�+�
�.7�
�.C�D�.C�7�1�d�t�Q�w�.C��D��&�&��$�#�{�2�)�,�7�!�;����Z��0�,6�s�O�M�)-�T�-B�-B�(C�(�)�
��#�$��3�)�-�8�1�<���!�8�+5�c�?�L�.2�-B�-B�(�-B�T�Q��A�q�D�-B�(�'�()����!�!�w�
�&>�%@�@�!���!�!�|�W�&=�%?�?�!��'�'�!� ���!�!�z�"�~�w�&?�%A�A�!��!�"�(��EE��0(s�
D�
Dc���|j|j||�t||jj��|j
|j<i|j|j<y)Nr)r"r]rr�rr�r�)rJr8r�rqrrrds      rKrszApplyBatchImpl.add_column^sV��	
�/�/��K�K���	
�
%*�&����9J�9J�$K����V�[�[�!�-/����f�k�k�*rMc��|j|jjjvr*t	|jjj|�|j|j=|j
|j=|jj|j�d|vrNt|dt�r:|djr*|jj|djd�yyyy)Nr)r]r��primary_keyr�r"r�r��remover�rr�r)rJr8r�rds    rKruzApplyBatchImpl.drop_columnns����;�;�$�*�*�0�0�8�8�8�*��
�
�&�&�.�.��
�
�L�L����%��!�!�&�+�+�.����%�%�f�k�k�2�
�r�!��2�o�.�0A�B��?�#�(�(��"�"�&�&��?�#�(�(�$�
�)�C�
"rMc��y)a^the batch table creation function will issue create_column_comment
        on the real "impl" as part of the create table process.

        That is, the Column object will have the comment on it already,
        so when it is received by add_column() it will be a normal part of
        the CREATE TABLE and doesn't need an extra step here.

        Nr5r�s  rKr�z$ApplyBatchImpl.create_column_comment���rMc��y)z�the batch table creation function will issue create_table_comment
        on the real "impl" as part of the create table process.

        Nr5r�s  rKr�z#ApplyBatchImpl.create_table_comment�r(rMc��y)z�the batch table creation function will issue drop_table_comment
        on the real "impl" as part of the create table process.

        Nr5r�s  rKr�z!ApplyBatchImpl.drop_table_comment�r(rMc��t|j�std��t|tj
�rQ|jj|jvr/|jj|jj�t|j�r||j|j<y|jj|�y)N�Constraint must have a name)
r$r]r9r�r�rr�r%r�r&r%r�rDrxs  rKrwzApplyBatchImpl.add_constraint�s���&�u�z�z�2��:�;�;��e�Z�<�<�=��z�z�%�%��)A�)A�A��(�(�/�/��
�
�0F�0F�G�!�%�*�*�-�16�D�"�"�5�:�:�.��$�$�+�+�E�2rMc�\�|jstd��	|j|jvr�|jj|j�\}}t	|j
|jj�D]N}|j|jk(s�|j
|jjj|��Pndt|j�r&|jj|j�}n)||jvr|jj|�t|t�r0|j
D] }d|j
|j_
�"yy#t$r&t|�rYytd|jz��wxYw)Nr,FzNo such constraint: '%s')r]r9r�rrBr�r�r&r%r�r�r�rr%�KeyErrorr!)rJryr��	col_consts    rKr{zApplyBatchImpl.drop_constraint�sR���z�z��:�;�;�	?��z�z�T�7�7�7�!�7�7�;�;�E�J�J�G�
��U�!%�d�l�l�3�8�8�&<�&H�&H�!I�I� �~�~����3����S�X�X�.�:�:�A�A�)�L�"J�(��
�
�3��.�.�2�2�5�:�:�>���$�2�2�2��(�(�/�/��6��%�!5�6� �=�=�C�9>�D�L�L����*�6�)�7���	F��e�$�
��7�%�*�*�D�E�E�	F�s�BE<�"BE<�<F+�F+c�6�||j|j<yrO)r�r]�rJr�s  rKrzApplyBatchImpl.create_index�s��%(�������"rMc�~�	|j|j=y#t$rtd|jz��wxYw)NzNo such index: '%s')r�r]r.r9r1s  rKr�zApplyBatchImpl.drop_index�s;��	?����S�X�X�&���	?��2�S�X�X�=�>�>�	?�s��"<c��td��)N�TODOr�rns   rKr}zApplyBatchImpl.rename_table�s
��!�&�)�)rM)r5)rEr-r�rr<�tupler>zDict[str, Any]rhr�rHr5r�r�)r�zUnion[quoted_name, str]r��strr�)r�zList[Index])r�rr�r
r�r�)r	r-r�r�)NFNNNF)r8r6rr6rzOptional[bool]rz)Optional[Union[Function[Any], str, bool]]r]�
Optional[str]rzOptional[TypeEngine]rz&Optional[Union[bool, Literal['auto']]]rzUnion[str, Literal[False]]r�r�)r�r6rqr7rrr7r�r�)NN)
r8r6r�zColumn[Any]rqr7rrr7r�r�)r8r6r�z%Union[ColumnClause[Any], Column[Any]]r�r�r�)r�rr�r�)r�r�r�rL�classmethodr�r�r�r�r�r�r`rlr"rsrur�r�r�rwr{rr�r}r5rMrKr_r_�s���%'�$��$��$��	$�
%�$��
$�"�$�
�$�:�5��5�,B�\
�<04�d�B#� �#�.B�#�	
�#�J';�Z$(�DI�"�&*�@D�.3�I'��I'��I'�!�	I'�
B�I'��
I'�$�I'�>�I'�,�I'�
�I'�V.B��.B�%�.B�$�	.B�

�.B�h(,�&*�0��0��0�%�	0�
$�0�
�0� ���6��

��0���
3�?�8)�?�*rMr_N)9�
__future__r�typingrrrrrr	r
�
sqlalchemyrrr
rrrrr�rrrr��sqlalchemy.sql.schemar�sqlalchemy.utilrr�utilr�util.sqla_compatrrrrrr r!r"r#r$r%r&�sqlalchemy.enginer'�sqlalchemy.sql.elementsr(r)�sqlalchemy.sql.functionsr*r+�sqlalchemy.sql.type_apir,�ddl.implr-r/r_r5rMrK�<module>rEs���#������ ��&��+���+�+���(�3�'�'��6�$�/�4�6�;�-�=�3�6�5���)�4�3�1�0�2�&�[D�[D�|z*�z*rM

Youez - 2016 - github.com/yon3zu
LinuXploit