U d=d?d@d@dfdAdBZ4d?S)D)sql)tokens)recurseimtdi'c Cstdk r|tkrdStdk r.t|jtkr.dSg}d}t|}t|D]\}}||}|jr^qF|jrt||st |||dqF|j |j r| |qF|j |j rFz |} Wntk rYqFYnX|} ||| | || | 7}qFdS)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_listidxtokentidxZopen_idxZ close_idxr!X/var/www/html/mysite/school/venv/lib/python3.8/site-packages/sqlparse/engine/grouping.pyrs4      rcCst|tjdSN)rrSquareBracketsrr!r!r"group_bracketsGsr&cCst|tjdSr#)rr Parenthesisr%r!r!r"group_parenthesisKsr(cCst|tjdSr#)rrCaser%r!r!r" group_caseOsr*cCst|tjdSr#)rrIfr%r!r!r"group_ifSsr,cCst|tjdSr#)rrForr%r!r!r" group_forWsr.cCst|tjdSr#)rrBeginr%r!r!r" group_begin[sr0cCs8dd}dd}dd}|}}t|tj||||dS)NcSs|tjdS)Nz::rT Punctuationrr!r!r"r`szgroup_typecasts..matchcSs|dk Sr#r!r4r!r!r"validcszgroup_typecasts..validcSs||fSr#r!rpidxr nidxr!r!r"postfszgroup_typecasts..post_groupr Identifierrrr5r9 valid_prev valid_nextr!r!r"group_typecasts_s r@cCs8dd}dd}dd}dd}t|tj||||dS) NcSs|jtjjkSr#)ttyper2KeywordZTZCastr4r!r!r"rnszgroup_tzcasts..matchcSs|dk Sr#r!r4r!r!r"r>qsz!group_tzcasts..valid_prevcSs*|dk o(|jp(|tjdp(|jtjjSNAS)r rr2rBr TypedLiteralrr4r!r!r"r?ts   z!group_tzcasts..valid_nextcSs||fSr#r!r6r!r!r"r9{szgroup_tzcasts..postr:rrr>r?r9r!r!r" group_tzcastsms rGc Csddd}dd}dd}dd}d d }d d }t|tj||||d dt|tj||||dddS)NcSst|tjjdS)Nm)rrrErr4r!r!r"rsz"group_typed_literal..matchcSs t|tjSr#)rrrEr4r!r!r"match_to_extendsz,group_typed_literal..match_to_extendcSs|dk Sr#r!r4r!r!r"r>sz'group_typed_literal..valid_prevcSs|dk o|jtjjSr#)rrrErr4r!r!r"r?sz'group_typed_literal..valid_nextcSs|dk o|jtjjSr#)rrrEM_EXTENDr4r!r!r" valid_finalsz(group_typed_literal..valid_finalcSs||fSr#r!r6r!r!r"r9sz!group_typed_literal..postFextendT)r;rrE)rrrJr>r?rLr9r!r!r"group_typed_literalsrOcCs8dd}dd}dd}dd}t|tj||||dS) NcSs<tjdftjdftjdffD]\}}|||rdSqdS)N.z->z->>TF)r2r3Operatorr)rrAvaluer!r!r"rs  zgroup_period..matchcSs(tjtjf}tjtjjf}t|||dSNit)rr$r<r2NameStringSymbolr)rsqlclsttypesr!r!r"r>s z group_period..valid_prevcSsdSNTr!r4r!r!r"r?sz group_period..valid_nextcSsZtjtjf}tjtjjtjtjjf}|dk r4||nd}t |||d}|rR||fS||fSrS) rr$Functionr2rWrXrYWildcardSingler)rr7r r8rZr[next_r?r!r!r"r9s  zgroup_period..postr:rFr!r!r" group_periods  racCs8dd}dd}dd}dd}t|tj||||dS) NcSs|jo|jdkSrC) is_keyword normalizedr4r!r!r"rszgroup_as..matchcSs|jdkp|j S)NNULL)rcrbr4r!r!r"r>szgroup_as..valid_prevcSs&tjtjtjf}t||d o$|dk SNrV)r2DMLDDLCTEr)rr[r!r!r"r?szgroup_as..valid_nextcSs||fSr#r!r6r!r!r"r9szgroup_as..postr:rFr!r!r"group_ass rjcCs8dd}dd}dd}|}}t|tj||||dS)NcSs|tjdS)Nz:=)rr2 Assignmentr4r!r!r"rszgroup_assignment..matchcSs|dk o|jtjfkSr#)rAr2rBr4r!r!r"r5szgroup_assignment..validcSs,tjdf}|j||d\}}|p"|}||fS)N;rIr)r2r3 token_next_by)rr7r r8Z m_semicolonZsnidx_r!r!r"r9s zgroup_assignment..post)r;rrkr=r!r!r"group_assignments rpc sftjtjtjtjtjftttdd}fdd}dd}|}}t |tj ||||dddS) NcSs|jtjjkSr#)rAr2rQ Comparisonr4r!r!r"rszgroup_comparison..matchcs2t|drdS|r*|jr*|jdkr*dSdSdS)N)rVrUTrdF)rrbrcr4rZr[r!r"r5s zgroup_comparison..validcSs||fSr#r!r6r!r!r"r9szgroup_comparison..postFrM) rr'r]r< OperationrE T_NUMERICALT_STRINGT_NAMEr;rqr=r!rrr"group_comparisons   rwcCsJtjjtjf}|j|d\}}|rF|tj|||j||d\}}qdS)NrfrVr)r2rXrYrWrnrrr<)rr[r rr!r!r"group_identifiers rycCsd|jtjjd\}}|r`||\}}t|tjtjdrH| tj|||jtjj|d\}}qdS)NrHrTrm) rnrOverr token_nextrr'r2rWr)rr rr8r`r!r!r" group_overs r|c sbtjtjtjftjtjjfdd}fdd}dd}dd}t|tj||||d d d dS) NcSs t|tjSr#)rrr$r4r!r!r"rszgroup_arrays..matchcst|dSrSrr4rrr!r"r>sz group_arrays..valid_prevcSsdSr\r!r4r!r!r"r?sz group_arrays..valid_nextcSs||fSr#r!r6r!r!r"r9szgroup_arrays..postTF)rNr) rr$r<r]r2rWrXrYr;rFr!rrr" group_arrays s r~c sjttttjtjtjtjtjtj fdd}fdd}dd}|}}t |tj||||dddS) NcSst|tjtjfdSre)rr2rQr^r4r!r!r"r$szgroup_operator..matchcs t|dp|o|tjdS)NrT)Z CURRENT_DATEZ CURRENT_TIMECURRENT_TIMESTAMP)rrr2rBr4rrr!r"r5's zgroup_operator..validcSstj||_||fSr#)r2rQrAr6r!r!r"r9-s zgroup_operator..postFrM) rtrurvrr$r'r]r<rsrEr;r=r!rrr"group_operators    rc stjdftjtjtjtjtjtjft t t tjtj tj fdd}fdd}dd}|}}t|tj||||dd dS) N)nullrolecSs|tjdS)N,r1r4r!r!r"r=sz$group_identifier_list..matchcst|dS)N)rUrIrVr}r4Zm_rolerZr[r!r"r5@sz$group_identifier_list..validcSs||fSr#r!r6r!r!r"r9Csz#group_identifier_list..postTrM)r2rBrr]r)r<rqIdentifierListrsrtrurvCommentr^r;r=r!rr"group_identifier_list6s$   rcCsp|jtjd\}}|rl|jdd|d\}}|dk rV|j|dd\}}|tj|||jtj|d\}}qdS)NrfcSst|tjdp|jSre)rr2r is_newline)tkr!r!r"Pz group_comments..)rF)skip_wsrx)rnr2rtoken_not_matching token_prevrrrr reidxendr!r!r"group_commentsKs rcCs|jtjjd\}}|r|jtjj|d\}}|dkrB|jd}n|j|d}||}|tj|||jtjj|d\}}qdS)NrHrmr) rnrWhererr_groupable_tokensr token_indexrrr!r!r" group_whereXs  rcCs~tjtjtjtjtjtjf}|j|tj d\}}|rz| |\}}t |tjrb|j tj||dd|j|tj |d\}}q0dS)NrTTrM)rUrVr) rr'r]r)r<rsrqrnr2Numberr{rr)rZI_ALIASr rr8r`r!r!r" group_aliasedis rc Csd}d}d}|jD]6}|jdkr(d}|jdkr:d}|jdkrd}q|rZ|rZ|sZdS|jtjd\}}|r||\}}t|tj r||\} } | rt| tj r| } n|} | tj || |jtj|d\}}qldS)NFZCREATETZTABLErDrfrx) rrRupperrnr2rWr{rrr'rzrr]) rZ has_createZ has_tableZhas_asZ tmp_tokenr rr8r`Zover_idxZoverrr!r!r"group_functionsvs,    rcCsh|jtjjd\}}|rd||\}}t|tjtjdrL| tj|||}|jtjj|d\}}qdS)z,Group together Identifier and Asc/Desc tokenrfrTrxN) rnr2rBOrderrrrr<rrrr rr7prev_r!r!r" group_ordersrcCsb|jtjd\}}|r^||\}}t|tjrH|jtj||dd|}|jtj|d\}}qdS)N)rUTrM)rUr)rnrrrr TokenListrrr!r!r"align_commentss rcCsb|jtjdfd\}}|}d}|rBt|tjr2|}||\}}q|dkr^|jtj||dddS)NZVALUESrHrTrM) rnr2rBrrr'r{rValues)rr r start_idxend_idxr!r!r" group_valuess rcCsHtttttttttt t t t t tttttttttttfD] }||q6|Sr#)rr&r(r*r,r.r0r|rrrar~ryrr@rGrOrrwrjrrprrr)stmtfuncr!r!r"groups8 rcCsdSr\r!rfr!r!r"rrrcCsdSr\r!rfr!r!r"rrNTc  Cstdk r|tkrdStdk r.t|jtkr.dSd} d\} } t|} t| D]\} }| | }|dkrdqJ|jrlqJ|r|jrt||st |||||||d|d ||r | |\}}| r || r ||r ||| ||\}}|j ||||d}| ||7} ||} } qJ||} } qJdS)zDGroups together tokens that are joined by a middle token. i.e. x < yNr)NNTrrM) rr r rr r r rrr;r{r)rrrr>r?r9rNrrrr7rrrrr r8r`Zfrom_idxZto_idxgrpr!r!r"r;s>      r;)r)5sqlparserrr2sqlparse.utilsrrrr rIntegerZFloatrtrXr_rYrurWZ Placeholderrvrr&r(r*r,r.r0r@rGrOrarjrprwr<ryrzr|r~rrrrrrrr]rrrrrr;r!r!r!r"sb   -         %