,i<4ddlmZddlmZddlmZmZdZdZejejjejjfZ ejejjejjfZej"ej"j$fZd&dZdZdZd Zd Zd Zd Zd ZdZdZdZdZdZ dZ!eejDdZ#eejHdZ%dZ&dZ'dZ(eejRdZ*eejVdZ,edZ-eej\dZ/eejDdZ0edZ1dZ2d Z3d!d"d#d$d$dfd%Z4y#)')sql)tokens)recurseimtdi'c(t |tkDrytt|jtkDryg}d}t |}t |D]\}}||z }|j r|jrt||st|||dzA|j|jr|j|l|j|js |j} |} |j!|| | || | z z }y#t$rYwxYw)z*Groups Tokens that have beginning and end.Nr)MAX_GROUPING_DEPTHMAX_GROUPING_TOKENSlenrlist enumerate is_whitespaceis_group isinstance_group_matchingmatchM_OPENappendM_CLOSEpop IndexError group_tokens) tlistclsdepthopens tidx_offset token_listidxtokentidxopen_idx close_idxs L/var/www/mymood/env/lib/python3.12/site-packages/sqlparse/engine/grouping.pyrrs%%2D*D& u|| 2 2 EKeJ + U[      >>*UC"8 E3 2  5;; # LL  U[[#++ &  99; I   sHi 8 9x/ /K9,,  sD DDc8t|tjyN)rrSquareBracketsrs r%group_bracketsr*GsE3--.c8t|tjyr')rr Parenthesisr)s r%group_parenthesisr.KsE3??+r+c8t|tjyr')rrCaser)s r% group_caser1OsE388$r+c8t|tjyr')rrIfr)s r%group_ifr4SsE366"r+c8t|tjyr')rrForr)s r% group_forr7WsE377#r+c8t|tjyr')rrBeginr)s r% group_beginr:[sE399%r+cZd}d}d}|x}}t|tj||||y)NcB|jtjdS)Nz::rT Punctuationr!s r%rzgroup_typecasts..match`s{{1==$//r+c |duSr'r@s r%validzgroup_typecasts..validc D  r+c ||fSr'rBrpidxr"nidxs r%postzgroup_typecasts..postf Tzr+_groupr IdentifierrrrCrI valid_prev valid_nexts r%group_typecastsrQ_s30!$#J 5#..%ZFr+cXd}d}d}d}t|tj||||y)NcP|jtjjk(Sr')ttyper>KeywordTZCastr@s r%rzgroup_tzcasts..matchns{{aii....r+c |duSr'rBr@s r%rOz!group_tzcasts..valid_prevqrDr+c|duxrW|jxsI|jtjdxs'|jtj j SNAS)rrr>rUr TypedLiteralrr@s r%rPz!group_tzcasts..valid_nexttsSD     6{{199d+ 6u{{C,,445 r+c ||fSr'rBrFs r%rIzgroup_tzcasts..post{rJr+rKrrrOrPrIs r% group_tzcastsr^ms./!  5#..%ZFr+c d}d}d}d}d}d}t|tj||||dt|tj||||d y) NcLt|tjjS)Nm)rrr[rr@s r%rz"group_typed_literal..matchs5C,,3344r+c6t|tjSr')rrr[r@s r%match_to_extendz,group_typed_literal..match_to_extends%!1!122r+c |duSr'rBr@s r%rOz'group_typed_literal..valid_prevrDr+c\|duxr'|jtjjSr')rrr[rr@s r%rPz'group_typed_literal..valid_nexts)D K[U[[#2B2B2J2J%KKr+c\|duxr'|jtjjSr')rrr[M_EXTENDr@s r% valid_finalz(group_typed_literal..valid_finals)D L[U[[#2B2B2K2K%LLr+c ||fSr'rBrFs r%rIz!group_typed_literal..postrJr+FextendT)rLrr[)rrrdrOrPrirIs r%group_typed_literalrms^ 53!LM 5#""E:z  5#""OZ r+cXd}d}d}d}t|tj||||y)NctjdftjdftjdffD]\}}|j||syy)N.z->z->>TF)r>r?Operatorr)r!rTvalues r%rzgroup_period..matchsNmmS1jj$/jj%02LE5{{5%( 2 r+ctjtjf}tjtj j f}t|||SNit)rr(rMr>NameStringSymbolrr!sqlclsttypess r%rOz group_period..valid_prevs;##S^^3(5Ff--r+cyNTrBr@s r%rPz group_period..valid_nextsr+c(tjtjf}tjtj j tjtj jf}|||nd}t|||}|r||fS||fSrt) rr(Functionr>rxryrzWildcardSingler)rrGr"rHr|r}next_rPs r%rIzgroup_period..postso##S\\1!**ahhooE#/d T&F3 )d|;d|;r+rKr]s r% group_periodrs.. < 5#..%ZFr+cXd}d}d}d}t|tj||||y)Nc<|jxr|jdk(SrY) is_keyword normalizedr@s r%rzgroup_as..matchs|jdk(xs |j S)NNULL)rrr@s r%rOzgroup_as..valid_prevs!6)A1A1A-AAr+ctjtjtjf}t || xr|duSNrw)r>DMLDDLCTEr)r!r}s r%rPzgroup_as..valid_nexts4quu$u''=E,==r+c ||fSr'rBrFs r%rIzgroup_as..postrJr+rKr]s r%group_asrs/=B> 5#..%ZFr+cZd}d}d}|x}}t|tj||||y)NcB|jtjdS)Nz:=)rr> Assignmentr@s r%rzgroup_assignment..matchs{{1<<..r+cH|duxr|jtjfvSr')rTr>rUr@s r%rCzgroup_assignment..valids!D DU[[ %DDr+cftjdf}|j||\}}|xs|}||fS)N;rbr )r>r? token_next_by)rrGr"rH m_semicolonsnidx_s r%rIzgroup_assignment..posts<mmS( &&$&?q}Tzr+)rLrrrNs r%group_assignmentrs4/E $#J 5#..%ZFr+c *tjtjtjtjtj ft tztzd}fd}d}|x}}t|tj||||dy)NcP|jtjjk(Sr')rTr>rq Comparisonr@s r%rzgroup_comparison..matchs{{ajj3333r+c`t|ry|r|jr|jdk(ryy)N)rwrvTrF)rrrr{s r%rCzgroup_comparison..valids0 u& ) u''E,<,<,Fr+c ||fSr'rBrFs r%rIzgroup_comparison..postrJr+Frk) rr-rrM Operationr[ T_NUMERICALT_STRINGT_NAMErLrrrrCrIrOrPr|r}s @@r%group_comparisonrsqoos||S^^mmS--/F 8 #f ,F4$#J 5#..% z47r+ctjjtjf}|j |\}}|r;|j t j|||j ||\}}|r:yy)Nrrwr )r>ryrzrxrrrrM)rr}r"r!s r%group_identifierrsfhhooqvv &F%%%/KD%  3>>46))F)= e r+c|jtjj\}}|r|j |\}}t |tj tjr!|jtj|||jtjj|\}}|ryy)Nrarur) rrOverr token_nextrr-r>rxr)rr"r!rHrs r% group_overrs%%%8KD% &&t, e u166 2   sxxt 4))CHHOO)F e r+c tjtjtjftj tj jfd}fd}d}d}t|tj||||ddy)Nc6t|tjSr')rrr(r@s r%rzgroup_arrays..matchs%!3!344r+c t|Srtrr{s r%rOz group_arrays..valid_prevs5Ff--r+cyrrBr@s r%rPz group_arrays..valid_nextsr+c ||fSr'rBrFs r%rIzgroup_arrays..postrJr+TF)rlr) rr(rMrr>rxryrzrL)rrrOrPrIr|r}s @@r% group_arraysr sg    =F VVQXX__ $F5. 5#..% z4eEr+c Httztztjtj tj tjtjtjfd}fd}d}|x}}t|tj||||dy)NcXt|tjtjfSr)rr>rqrr@s r%rzgroup_operator..match$s5QZZ455r+clt|xs$|xr |jtjdS)Nru) CURRENT_DATE CURRENT_TIMECURRENT_TIMESTAMP)rrr>rUr{s r%rCzgroup_operator..valid's:5Ff-HG%++ EG Hr+c:tj||_||fSr')r>rqrTrFs r%rIzgroup_operator..post-sJJd Tzr+Frk) rrrrr(r-rrMrr[rLrs @@r%group_operatorrsz 8 #f ,F  #//3<<nncmmS-=-=?F6H $#J 5#-- z47r+c tjdftjtjtj tj tjtjfttztztjtjtjfzd}fd}d}|x}}t|tj||||dy)N)nullrolecB|jtjdS)N,r=r@s r%rz$group_identifier_list..match=s{{1==#..r+c"t|S)N)rvrbrwr)r!m_roler|r}s r%rCz$group_identifier_list..valid@s5Ff77r+c ||fSr'rBrFs r%rIz#group_identifier_list..postCrJr+Trk)r>rUrrr0rMrIdentifierListrrrrCommentrrL) rrrCrIrOrPrr|r}s @@@r%group_identifier_listr6s YY( (FllCHHcnncnn  #--1FH$v-AIIqzz23F/8$#J 5#$$e z46r+c>|jtj\}}|rx|jd|\}}|7|j |d\}}|j t j|||jtj|\}}|rwyy)NrcTt|tjxs |jSr)rr>r is_newline)tks r%z group_comments..Pss2+rtoken_not_matching token_prevrrrr"r!eidxends r%group_commentsrKs%% %2KD% ,, <$-H c ?((u(=ID#   s{{D$ 7))AII4)@ e r+c|jtjj\}}|r|jtjj|\}}||j d}n|j |dz }|j|}|jtj|||jtjj|\}}|ryy)Nrarr ) rrWhererr_groupable_tokensr token_indexrrs r% group_whererXs%% (8(8%9KD% ''#))*;*;'F c ;))"-C,,tax(C  % 399dD1))CII,<,<$)G e r+ctjtjtjtjtj tj f}|j|tj\}}|rz|j|\}}t|tjr#|jtj||d|j|tj|\}}|ryyy)NruTrk)rvrwr ) rr-rr0rMrrrr>Numberrrr)rI_ALIASr"r!rHrs r% group_aliasedris chh}}cnn.G%%188%rxrrrr-rrr) r has_create has_tablehas_as tmp_tokenr"r!rHrover_idxoverrs r%group_functionsrvsJI F\\ ?? "h .J ?? "g -I ??d "F "i%%%/KD% &&t, e eS__ -"--d3NHd 42   s||T4 8))AFF)= e r+c|jtjj\}}|r|j |\}}t |t jtjr#|jt j|||}|jtjj|\}}|ryy)z,Group together Identifier and Asc/Desc tokenrrurN) rr>rUOrderrrrrMrrrr"r!rGprev_s r% group_orderrs%% %8KD% &&t, e u!(( 3   s~~tT :D))AIIOO)F e r+cD|jtj\}}|r{|j|\}}t |tj r%|j tj ||d|}|jtj|\}}|rzyy)N)rvTrk)rvr )rrrrr TokenListrrs r%align_commentsrs%% %4KD% &&t, e eS]] +   s}}dD  FD))CKKT)B e r+c|jtjdf\}}|}d}|r3t|tj r|}|j |\}}|r3|dk7r$|jtj||dyy)NVALUESrarTrk) rr>rUrrr-rrValues)rr"r! start_idxend_idxs r% group_valuesrs%%H(=%>KD%IG  eS__ -G&&t, e "} 3::y'$Gr+ctttttt t tttttttttt t"t$t&t(t*t,t.t0fD] }|| |Sr')rr*r.r1r4r7r:rrrrrrrrQr^rmrrrrrrrr)stmtfuncs r%grouprsl ;> T ?@ Kr+cyrrBrs r%rrr+cyrrBrs r%rrrr+NTc t |tkDrytt|jtkDryd} d\} } t |} t | D]\} }| | z }|dkr|j r|r.|jr"t||st|||||||d|dz ||rV|j|\}}| r@|| r8||r0||| ||\}}|j||||}| ||z z } ||} } ||} } y)zDGroups together tokens that are joined by a middle token. i.e. x < yNr)NNTr rk) r r r rr rrrrrLrr)rrrrOrPrIrlrrrrGrrr r!r"rHrfrom_idxto_idxgrps r%rLrLs-%%2D*D& u|| 2 2KKD%eJ + U[  !8      u~~j.D 5#uj*uqy 2 <**40KD%E*z%/@#'tT4#@ &((hv(Nv00 &eEe-,r+)r)5sqlparserrr>sqlparse.utilsrrr r rIntegerFloatrryrrzrrx Placeholderrrr*r.r1r4r7r:rQr^rmrrrrrMrrrrrrrrrrrrrrrrrrLrBr+r%r s ' xx))188>>: HHahhooqxx 7 &&!&&$$ %*0Z/,%#$& GG(<G<G"G"70 >> GGE(7.6*  A A  H H   K  K >>6 GG C C H!J%$ +"r+