o Šº6ié<ã@sªddlmZddlmZddlmZmZdZdZej ej j ej jfZej ej jej jfZejejjfZdCdd„Zdd „Zd d„Zdd „Zdd„Zdd„Zdd„Zdd„Zdd„Zdd„Zdd„Zdd„Zdd„Z d d!„Z!eej"ƒd"d#„ƒZ#eej$ƒd$d%„ƒZ%d&d'„Z&d(d)„Z'd*d+„Z(eej)ƒd,d-„ƒZ*eej+ƒd.d/„ƒZ,eƒd0d1„ƒZ-eej.ƒd2d3„ƒZ/eej"ƒd4d5„ƒZ0eƒd6d7„ƒZ1d8d9„Z2d:d;„Z3dd=„d?d@d@dfdAdB„Z4d?S)Dé)Úsql)Útokens)ÚrecurseÚimtédi'c Csètdur |tkr dStdurt|jƒtkrdSg}d}t|ƒ}t|ƒD]N\}}||}|jr/q#|jr@t||ƒs@t |||dƒq#|j |jŽrL| |¡q#|j |j Žrqz| ¡} Wn tyaYq#w|} | || | ¡|| | 7}q#dS)z*Groups Tokens that have beginning and end.Nré)ÚMAX_GROUPING_DEPTHÚMAX_GROUPING_TOKENSÚlenrÚlistÚ enumerateÚ is_whitespaceÚis_groupÚ isinstanceÚ_group_matchingÚmatchÚM_OPENÚappendÚM_CLOSEÚpopÚ IndexErrorÚgroup_tokens)ÚtlistÚclsÚdepthÚopensÚtidx_offsetÚ token_listÚidxÚtokenÚtidxÚopen_idxÚ close_idx©r#ú]/var/www/hoanhtaovolam_webdjango/env/lib/python3.10/site-packages/sqlparse/engine/grouping.pyrs8ý€ärcCót|tjƒdS©N)rrÚSquareBrackets©rr#r#r$Úgroup_bracketsGór)cCr%r&)rrÚParenthesisr(r#r#r$Úgroup_parenthesisKr*r,cCr%r&)rrÚCaser(r#r#r$Ú group_caseOr*r.cCr%r&)rrÚIfr(r#r#r$Úgroup_ifSr*r0cCr%r&)rrÚForr(r#r#r$Ú group_forWr*r2cCr%r&)rrÚBeginr(r#r#r$Úgroup_begin[r*r4cCó8dd„}dd„}dd„}|}}t|tj||||ƒdS)NcSó| tjd¡S)Nz::©rÚTÚPunctuation©rr#r#r$r`ózgroup_typecasts..matchcSó|duSr&r#r:r#r#r$Úvalidcózgroup_typecasts..validcSó||fSr&r#©rÚpidxr Únidxr#r#r$Úpostfr>zgroup_typecasts..post©Ú_grouprÚ Identifier©rrr=rCÚ valid_prevÚ valid_nextr#r#r$Úgroup_typecasts_s rJcCó8dd„}dd„}dd„}dd„}t|tj||||ƒdS) NcSó|jtjjkSr&)Úttyper8ÚKeywordÚTZCastr:r#r#r$rnr;zgroup_tzcasts..matchcSr<r&r#r:r#r#r$rHqr>z!group_tzcasts..valid_prevcSs*|duo|jp| tjd¡p|jtjjŽS©NÚAS)r rr8rNrÚTypedLiteralrr:r#r#r$rItsÿýz!group_tzcasts..valid_nextcSr?r&r#r@r#r#r$rC{r>zgroup_tzcasts..postrD©rrrHrIrCr#r#r$Ú group_tzcastsms rTc Csddd„}dd„}dd„}dd„}d d „}dd„}t|tj||||d dt|tj||||dddS)NcSst|tjjdS)N©Úm)rrrRrr:r#r#r$r‡r*z"group_typed_literal..matchcSót|tjƒSr&)rrrRr:r#r#r$Úmatch_to_extendŠóz,group_typed_literal..match_to_extendcSr<r&r#r:r#r#r$rHr>z'group_typed_literal..valid_prevcSó|duo |jtjjŽSr&)rrrRrr:r#r#r$rIóz'group_typed_literal..valid_nextcSrZr&)rrrRÚM_EXTENDr:r#r#r$Úvalid_final“r[z(group_typed_literal..valid_finalcSs||fSr&r#r@r#r#r$rC–r>z!group_typed_literal..postF©ÚextendT)rErrR)rrrXrHrIr]rCr#r#r$Úgroup_typed_literalsÿ ÿr`cCrK) NcSs<tjdftjdftjdffD] \}}| ||¡rdSqdS)NÚ.z->z->>TF)r8r9ÚOperatorr)rrMÚvaluer#r#r$r sþÿzgroup_period..matchcSs(tjtjf}tjtjjf}t|||dS©N©ÚiÚt)rr'rFr8ÚNameÚStringÚSymbolr)rÚsqlclsÚttypesr#r#r$rH¨sz group_period..valid_prevcSódS©NTr#r:r#r#r$rIsz group_period..valid_nextcSsZtjtjf}tjtjjtjtjjf}|dur||nd}t |||d}|r)||fS||fSrd) rr'ÚFunctionr8rhrirjÚWildcardÚSingler)rrAr rBrkrlÚnext_rIr#r#r$rC±s zgroup_period..postrDrSr#r#r$Úgroup_periodŸs rscCrK) NcSs|jo|jdkSrP)Ú is_keywordÚ normalizedr:r#r#r$r¾r*zgroup_as..matchcSs|jdkp|jS)NÚNULL)rurtr:r#r#r$rHÁszgroup_as..valid_prevcSs&tjtjtjf}t||do|duS©N©rg)r8ÚDMLÚDDLÚCTEr)rrlr#r#r$rIÄszgroup_as..valid_nextcSr?r&r#r@r#r#r$rCÈr>zgroup_as..postrDrSr#r#r$Úgroup_as½s r|cCr5)NcSr6)Nz:=)rr8Ú Assignmentr:r#r#r$rÏr;zgroup_assignment..matchcSs|duo |jtjfvSr&)rMr8rNr:r#r#r$r=Òr[zgroup_assignment..validcSs,tjdf}|j||d\}}|p|}||fS)Nú;©rVr)r8r9Ú token_next_by)rrAr rBÚm_semicolonÚsnidxÚ_r#r#r$rCÕs zgroup_assignment..post)rErr}rGr#r#r$Úgroup_assignmentÎs r„c sftjtjtjtjtjf‰ttt‰dd„}‡‡fdd„}dd„}|}}t |tj ||||dddS) NcSrLr&)rMr8rbÚ Comparisonr:r#r#r$rär;zgroup_comparison..matchcs.t|ˆˆdr dS|r|jr|jdkrdSdS)N)rgrfTrvF)rrtrur:©rkrlr#r$r=çs zgroup_comparison..validcSr?r&r#r@r#r#r$rCïr>zgroup_comparison..postFr^)rr+rorFÚ OperationrRÚT_NUMERICALÚT_STRINGÚT_NAMErEr…rGr#r†r$Úgroup_comparisonßsÿ ÿr‹cCsPtjjtjf}|j|d\}}|r&| tj||¡|j||d\}}|sdSdS)Nrx©rgr)r8rirjrhr€rrrF)rrlr rr#r#r$Úgroup_identifier÷sþrcCsj|jtjjd\}}|r3| |¡\}}t|tjtjdr$| tj||¡|jtjj|d\}}|sdSdS)NrUrer) r€rÚOverrÚ token_nextrr+r8rhr)rr rrBrrr#r#r$Ú group_oversürc sbtjtjtjf‰tjtjjf‰dd„}‡‡fdd„}dd„}dd„}t|tj||||d d ddS)NcSrWr&)rrr'r:r#r#r$rrYzgroup_arrays..matchcst|ˆˆdSrd©rr:r†r#r$rHr;z group_arrays..valid_prevcSrmrnr#r:r#r#r$rIsz group_arrays..valid_nextcSs||fSr&r#r@r#r#r$rCr>zgroup_arrays..postTF)r_r) rr'rFror8rhrirjrErSr#r†r$Úgroup_arrayss ÿr’c sjttt‰tjtjtjtjtjtj f‰dd„}‡‡fdd„}dd„}|}}t |tj||||dddS) NcSst|tjtjfdSrw)rr8rbrpr:r#r#r$r$szgroup_operator..matchcs t|ˆˆdp|o| tjd¡S)Nre)ÚCURRENT_DATEÚCURRENT_TIMEÚCURRENT_TIMESTAMP)rrr8rNr:r†r#r$r='sþÿzgroup_operator..validcSstj||_||fSr&)r8rbrMr@r#r#r$rC-szgroup_operator..postFr^)rˆr‰rŠrr'r+rorFr‡rRrErGr#r†r$Úgroup_operatorsÿ ÿr–c s†tjdf‰tjtjtjtjtjtjf‰t t ttjtjtj f‰dd„}‡‡‡fdd„}dd„}|}}t|tj||||dd dS) N)ÚnullÚrolecSr6)Nú,r7r:r#r#r$r=r;z$group_identifier_list..matchcst|ˆˆˆdS)N)rfrVrgr‘r:©Úm_rolerkrlr#r$r=@r*z$group_identifier_list..validcSr?r&r#r@r#r#r$rCCr>z#group_identifier_list..postTr^)r8rNrror-rFr…ÚIdentifierListr‡rˆr‰rŠÚCommentrprErGr#ršr$Úgroup_identifier_list6s ÿ ÿ ÿržcCsv|jtjd\}}|r9|jdd„|d\}}|dur+|j|dd\}}| tj||¡|jtj|d\}}|sdSdS)NrxcSst|tjdp |jSrw)rr8rÚ is_newline)Útkr#r#r$ÚPsz group_comments..)rF)Úskip_wsrŒ)r€r8rÚtoken_not_matchingÚ token_prevrr©rr rÚeidxÚendr#r#r$Úgroup_commentsKs ÿùr¨cCsŒ|jtjjd\}}|rD|jtjj|d\}}|dur!|jd}n|j|d}| |¡}| tj||¡|jtjj|d\}}|sdSdS)NrUréÿÿÿÿr) r€rÚWhererrÚ_groupable_tokensrÚtoken_indexrr¥r#r#r$Úgroup_whereXs õrcCs„tjtjtjtjtjtjf}|j|tj d\}}|r@| |¡\}}t|tjƒr1|jtj||dd|j|tj |d\}}|sdSdS)NreTr^)rfrgr) rr+ror-rFr‡r…r€r8ÚNumberrrr)rÚI_ALIASr rrBrrr#r#r$Ú group_aliasedisÿür°cCsâd}d}d}|jD]}|j ¡dkrd}|j ¡dkrd}|jdkr$d}q |r-|r-|s-dS|jtjd\}}|ro| |¡\}}t|tj ƒra| |¡\} } | rWt| tj ƒrW| }n|}| tj||¡|jtj|d\}}|s8dSdS)NFÚCREATETÚTABLErQrxrŒ) rrcÚupperr€r8rhrrrr+rŽrro)rÚ has_createÚ has_tableÚhas_asÚ tmp_tokenr rrBrrÚover_idxÚoverr¦r#r#r$Úgroup_functionsvs0 €÷rºcCsn|jtjjd\}}|r5| |¡\}}t|tjtjdr&| tj||¡|}|jtjj|d\}}|sdSdS)z,Group together Identifier and Asc/Desc tokenrxrerŒN) r€r8rNÚOrderr¤rrrFr®r©rr rrAÚprev_r#r#r$Úgroup_order’sûr¾cCsh|jtjd\}}|r2| |¡\}}t|tjƒr$|jtj||dd|}|jtj|d\}}|sdSdS)N)rfTr^)rfr)r€rrr¤rÚ TokenListrr¼r#r#r$Úalign_commentsžsûrÀcCsh|jtjdfd\}}|}d}|r"t|tjƒr|}| |¡\}}|s|dkr2|jtj||dddSdS)NÚVALUESrUr©Tr^) r€r8rNrrr+rrÚValues)rr rÚ start_idxÚend_idxr#r#r$Úgroup_values©sýÿrÅcCsHtttttttttt t ttt tttttttttttfD]}||ƒq|Sr&)r¨r)r,r.r0r2r4rrºrrsr’rr¾rJrTr`r–r‹r|r°r„rÀržrÅ)ÚstmtÚfuncr#r#r$Úgroupµs8ã rÈcCrmrnr#rxr#r#r$r¡Úór¡cCrmrnr#rxr#r#r$r¡ÛrÉNTc Cstdur |tkr dStdurt|jƒtkrdSd} d\} }t|ƒ}t|ƒD]a\} }| | }|dkr2q%|jr6q%|rN|jrNt||ƒsNt |||||||d|dƒ ||ƒr| |¡\}}|r||ƒr||ƒr||| ||ƒ\}}|j||||d}| ||7} ||} }q%||} }q%dS)zDGroups together tokens that are joined by a middle token. i.e. x < yNr)NNTrr^)rr r rrrr rrrErr)rrrrHrIrCr_rrrrAr½rrrr rBrrÚfrom_idxÚto_idxÚgrpr#r#r$rEÙs8 ÿ êrE)r)5Úsqlparserrr8Úsqlparse.utilsrrrr r®ÚIntegerÚFloatrˆrirqrjr‰rhÚPlaceholderrŠrr)r,r.r0r2r4rJrTr`rsr|r„r‹rFrrŽrr’r–ržrr¨rªrr°rorºr¾rÀrÅrÈrEr#r#r#r$Úsd - %ú