+ R'' T'B B""Q\\"2 t{{ a BN'''5 5%3 rN) __name__ __module__ __qualname____firstlineno____doc__rr+__static_attributes____classdictcell__ __classdict__s@rrrs1= 6 6rrcha]tRt^*toRtR tRtRtRtRt Rt Rt RRlt R t R tR tR tVtR #)TokenzBase class for all other classes in this module. It represents a single token and has two instance attributes: ``value`` is the unchanged value of the token and ``ttype`` is the type of the token. ch\V4pW nWnRVnRVnV\ P 9VnVP\ P9Vn VP\ P9Vn VP'dVP4Vn R#TVn R#)NF)strvaluettypeparentis_grouprr$ is_keywordr% is_whitespaceNewline is_newlineupper normalized)rr<r;s&&&r__init__Token.__init__=swE     199,!ZZ1<<7** 1+/???%++-rcVP#Nr;rs&r__str__ Token.__str__Hs zzrcVP4pVP4pVPR4'dVPR4'dRMRpRP!RR\ V4/\ 4B#)'"z"<{cls} {q}{value}{q} at 0x{id:2X}>idr-)_get_repr_name_get_repr_value startswithendswithformatrPlocals)rclsr;qs& r__repr__Token.__repr__Osl!!#$$&##C((U^^C-@-@Cc3::%$x%!8% %rcX\VP4PR4R,#)r )r:r<splitrJs&rrQToken._get_repr_nameWs 4::$$S)"--rc\V4p\V4^8dVR,R,p\P!RRV4#):NNz...z\s+ )r:r&resub)rraws& rrRToken._get_repr_valueZs6$i s8a<b'E/Cvvfc3''rc# "VxR#5i)zResolve subgroups.Nr-rJs&rflatten Token.flatten`s  s c aaSPVJpV'dVfV#\V\4'dV3pV'dkSP'd\P M^oV3RlV4p\ ;QJdV3RlV4F 'gK R# R#!V3RlV44#SP'd RV4pSPV9#)a$Checks whether the token matches the given arguments. *ttype* is a token type as defined in `sqlparse.tokens`. If it does not match, ``False`` is returned. *values* is a list of possible values for this token. For match to be considered valid, the token value needs to be in this list. For tokens of type ``Keyword`` the comparison is case-insensitive. For convenience, a single value can be given passed as a string. If *regex* is ``True``, the given values are treated as regular expressions. Partial matches are allowed. Defaults to ``False``. c3R<"TFp\P!VS4xK R#5irH)rccompile).0vflags& r Token.match..zs:6abjjD))6s$'c3X<"TFqPSP4xK! R#5irH)searchrD)rmpatternrs& rrprq|sMf7~~doo66fs'*TFc3@"TFqP4xK R#5irH)rC)rmrns& rrprqs0Aggiis)r< isinstancer:r?rc IGNORECASEanyrD)rr<valuesregex type_matchedrosf&&& @rr Token.matchdszzU* v~  fc " "YF $(OOO2==D:6:F3MfM33 M3 M3MfMM M ???00F&((rc pVPpV'd"\W!4'dR#VPpK)R#)zReturns ``True`` if this token is within *group_cls*. Use this method for example to check if an identifier is within a function: ``t.within(sql.Function)``. TF)r=rv)r group_clsr=s&& rwithin Token.withins* &,,]]Frc VPV8H#)zr?rBr@rDr=r<r;NF)r.r/r0r1r2 __slots__rErKrYrQrRrhr rrrr3r4r5s@rr8r8*sI I F%.( )> $rr8c aa]tRt^toRtRtRV3RlltRtRtRt Rt R Rlt R t R t R t]R 4tR!R ltR"RltR#RltRtRtR"RltR$RltR%RltR"RltRtR&RltRtRtRtRtRt R'Rlt!Rt"Vt#V;t$#)( TokenListzkA group of tokens. It has an additional instance attribute ``tokens`` which holds a list of child-tokens. rc<T;'g.VnVPUu.uFp\VRV4NK p\SV` RRP RVP444RVnR#uupi)r=Nc38"TFqPxK R#5irHrIrmtokens& rrp%TokenList.__init__..s&L u{{ T)rsetattrsuperrEjoinr>)rrr __class__s&& rrETokenList.__init__s^ll 59[[A[E$ '[A rww&L &LLM  BsA2cNRPRVP444#)rc38"TFqPxK R#5irHrIrs& rrp$TokenList.__str__..s?u{{r)rrhrJs&rrKTokenList.__str__sww? ???rc,\VP4#rH)iterrrJs&r__iter__TokenList.__iter__sDKK  rc(VPV,#rHr)ritems&&r __getitem__TokenList.__getitem__s{{4  rc,\V4P#rH)typer.rJs&rrQTokenList._get_repr_namesDz"""rc  \VP4p\VP4FwrgVP4pVP 4p We^, 8Hp V 'dRMRp V P R4'dV P R4'dRMRp \V V V RV RV V V 2 VR7VP'gKVe W!8gKV 'dRMR p VPW^,W4V ,4K R#) zPretty-print the object tree.z`- z|- rNrOrb)fileNz z| ) r&rr rQrRrSrTprintr> _pprint_tree)r max_depthdepthf_pre token_countrrrWr;lastprerX parent_pres&&&&& rrTokenList._pprint_trees$++& #DKK0JC&&(C))+E?+D%UC'',,1D1D#A TF3%uAcU!A3ugaS9 B~~~9#48I&*U ""9ai:rhrrs& rrhTokenList.flattens5 [[E~~~ ==?** !*s5A AA c#d"VPFpVP'gKVxK R#5irH)rr>rs& r get_sublistsTokenList.get_sublistss![[E~~~ !s0 0cVP#rHrrJs&r_groupable_tokensTokenList._groupable_tokenss {{rc RVfR#\V\\34'gV3pV'dVeQh\V^, RR4pM$Vf\ VP 4p\W#4pVF4pVP V,pVFpV!V4'gKWg3uu# K6 R#)znext token that match functionsNr\NN)rvlisttupleranger&r) rfuncsstartrr"indexesrrfuncs &&&&& r_token_matchingTokenList._token_matchings =%$//HE ; ;EAIr2.G{$++&E'GCKK$E;;:% rc DaaVV3RlpVPV4^,#)zReturns the first child token. If *skip_ws* is ``True`` (the default), whitespace tokens are ignored. if *skip_cm* is ``True`` (default: ``False``), comments are ignored too. c<S;'dVP;'g+S;'d!\V\P\R7'*#)r ir@rrCommenttkskip_cmskip_wss&rmatcher&TokenList.token_first..matcher D 55R%5%5II#GGB!))w(GJ Jrr)rrrrs&ff r token_firstTokenList.token_firsts! J##G,Q//rcJaaaV^, pVPVVV3RlWE4#)c <\VSSS4#rH)r)rrrr s&r)TokenList.token_next_by..ss2q!Q/?rr)rrrr rrs&fff&&rr#TokenList.token_next_bys  q##$?JJrc\V\\34'gV3MTpVUu.uFq33RlNK ppVPW4#uupi)cV!V4'*#rHr-)rrs&&rr.TokenList.token_not_matching..s 48|r)rvrrr)rrrrs&&& rtoken_not_matchingTokenList.token_not_matchingsG *54- @ @e@EF3F##E//GsAc2VPW4^,#)rr)rrrs&&&rtoken_matchingTokenList.token_matchings##E/22rc *VPWVRR7#)zReturns the previous token relative to *idx*. If *skip_ws* is ``True`` (the default) whitespace tokens are ignored. If *skip_cm* is ``True`` comments are ignored. ``None`` is returned if there's no previous token. T)_reverse) token_next)rrrrs&&&&r token_prevTokenList.token_prevssWtDDrc XaaVfR#V^, pVV3RlpVPWQVR7#)zReturns the next token relative to *idx*. If *skip_ws* is ``True`` (the default) whitespace tokens are ignored. If *skip_cm* is ``True`` comments are ignored. ``None`` is returned if there's no next token. c<S;'dVP;'g+S;'d!\V\P\R7'*#rrrs&rr%TokenList.token_next..matcher1rrr!rr)rrrrrrs&&ff& rrTokenList.token_next&s7 ;  q J##G(#CCrc \V\4'dTMVPV4pW PVRP V4,#)zReturn list index of token.N)rvint token_indexrindex)rrrs&&&rrTokenList.token_index6s?#E3//T5E5Ee5L{{56*00777rc TpVPV,pW4,pV'd\W!4'dzVPV^,VpTp V PPV4VPV^,V1V ;PRP RV44, unM+VPWgpV!V4p V .VPWg%W nVF p WnK V #)z+Replace tokens by an instance of *grp_cls*.rc38"TFqPxK R#5irHrIrs& rrp)TokenList.group_tokens..Ms D))r)rrvextendr;rr=) rgrp_clsrr include_endr start_idxend_idx subtokensgrprs &&&&&& r group_tokensTokenList.group_tokens;s  I&# j00 IM':IC JJ  i ( IM'12 II D) DD DI I6I)$C.1UDKK *JEL rc \V\4'gVPV4pWnVPP W4R#)zInserts *token* before *where*.N)rvrrr=rinsert)rwherers&&&r insert_beforeTokenList.insert_beforeYs6%%%$$U+E  5(rc \V\4'gVPV4pVPWR7wrEWnVfVP P V4R#VP PWB4R#)zInserts *token* after *where*.rN)rvrrrr=rappendr)rrrrnidxnext_s&&&& r insert_afterTokenList.insert_after`s_%%%$$U+Eooeo=  = KK  u % KK  t +rc &VP4RJ#)z(Returns ``True`` if an alias is present.N)r+rJs&r has_aliasTokenList.has_aliasks~~t++rc R#)rNr-rJs&rr+TokenList.get_aliasorc RVP4;'gVP4#)zReturns the name of this identifier. This is either it's alias or it's real name. The returned valued can be considered as the name under which the object corresponding to this identifier is known within the current statement. )r+rrJs&rget_nameTokenList.get_namess"~~774#5#5#77rc R#)r Nr-rJs&rrTokenList.get_real_name|rrc VP\PR3R7wrVPV4wr#Ve\ VP 4#R#)zdReturn name of the parent object if any. A parent object is identified by the first occurring dot. r rN)r#rrrrr;)rrr)prev_s& rget_parent_nameTokenList.get_parent_namesK ''1==#*>'? ??7+-2->}U[[)HDHrc (V'dVPVRM VPpV'd \V4MTp\P\P\P P .pV'd VP\P4VFspVPV9d\VP4u#\V\\34'gKIV'dVP4u#VP!4u# R#)z/Returns the name of the first token with a nameN)rreversedrNameWildcardStringSymbolr r$r<rr;rv IdentifierFunctionrr)rrr"rr rtypesrs&&&&& rrTokenList._get_first_names'*ST"t{{%,&!&QXX__5  LL #E{{e#$U[[11EJ#9::09u**,Ou~~?OO r)r>rrH)NNr)r+NF)TF)NNNr\N)TFFr+)T)NFFF)%r.r/r0r1r2rrErKrrrQrrrhrpropertyrrrr#rrrrrrr rrr+rrrrr3r4 __classcell__)rr6s@@rrrs I @!!#O"  , 0K0 3ED 8 <) ,,8IPPrrc*a]tRtRtoRtRtRtVtR#) StatementizRepresents a SQL statement.c ZVPRR7pVfR#VP\PP\PP 39d VP #VP\PP8XdVPV4pVeVPVRR7wr!\V\\34'gK7VPVRR7wr!VfKRVP\PP8XgK}VP #R#)aReturns the type of a statement. The returned value is a string holding an upper-cased reprint of the first DML or DDL keyword. If the first token in this group isn't a DML or DDL keyword "UNKNOWN" is returned. Whitespaces and comments at the beginning of the statement are ignored. T)rUNKNOWNr ) rr<rr$DMLDDLrDCTErrrvr'IdentifierList)rrtidxs& rget_typeStatement.get_types   . = [[QYY]]AIIMM: :## # [[AIIMM )##E*D""oodDoA ej.%ABB"&//$/"EKD( % qyy}} <$///rr-N)r.r/r0r1r2r8r3r4r5s@rr0r0s%""rr0c<a]tRtRtoRtRtRtRtRtRt Vt R#) r'izFRepresents an identifier. Identifiers may have aliases or typecasts. c NVP\PR7wrVRJ#)z7Return ``True`` if this identifier contains a wildcard.rN)r#rr$)rr)rs& r is_wildcardIdentifier.is_wildcards&%% %3D  rc VP\PR3R7wrVPVRR7wr4V'd VP#R#)z ?Fhhoot#GyyNNHrrRcla]tRtRtoRt]P R3t]P R3t] R4t Rt Vt R#) ParenthesisizTokens between parenthesis.()c VP^R#rr\rrJs&rrParenthesis._groupable_tokens{{1R  rr-N r.r/r0r1r2rrr[r]r-rr3r4r5s@rr`r`s6% ]]C FmmS G !!rr`cla]tRtRtoRt]P R3t]P R3t] R4t Rt Vt R#)rIizTokens between square brackets[]c VP^R#rdrrJs&rr SquareBrackets._groupable_tokensrfrr-Nrgr5s@rrIrIs6( ]]C FmmS G !!rrIc]tRtRtRtRtR#) Assignmenti z An assignment like 'var := val;'r-Nr.r/r0r1r2r3r-rrrnrn s*rrncR]tRtRtRt]P R3t]P R3tRt R#)Ifiz7An 'if' clause with possible 'else if' or 'else' parts.IFzEND IFr-N r.r/r0r1r2rr$r[r]r3r-rrrqrqs A YY_Fii!GrrqcR]tRtRtRt]P R3t]P R3tRt R#)Foriz A 'FOR' loop.zEND LOOPr-N)FORFOREACHrsr-rrrurus" YY* *Fii#GrrucDa]tRtRtoRt]R4t]R4tRtVt R#) Comparisoniz/A comparison used for example in WHERE clauses.c(VP^,#r,rrJs&rleftComparison.lefts{{1~rc(VPR,#rdrrJs&rrightComparison.right!s{{2rr-N) r.r/r0r1r2r-r{r~r3r4r5s@rryrys.9 rryc*a]tRtRtoRtRtRtVtR#)ri&z A comment.cVP;'d9VP^,P\PP8H#r,)rr<rr MultilinerJs&r is_multilineComment.is_multiline)s1{{JJt{{1~33qyy7J7JJJrr-N)r.r/r0r1r2rr3r4r5s@rrr&sKKrrcR]tRtRtRt]P R3t]P R3tRt R#)Wherei-zA WHERE clause.WHEREr-N) ORDER BYzGROUP BYLIMITUNIONz UNION ALLEXCEPT INTERSECTHAVING RETURNINGINTOrsr-rrrr-s& YY Fii44Grrc6]tRtRtRt]P R3tRtR#)Overi5zAn OVER clause.OVERr-N) r.r/r0r1r2rr$r[r3r-rrrr5s YY FrrcR]tRtRtRt]P R3t]P R3tRt R#)Havingi:zA HAVING clause.rr-N)rrrsr-rrrr:s" YY Fii..Grrcfa]tRtRtoRt]P R3t]P R3tRRlt Rt Vt R#) Casei@zAA CASE statement with one or more WHEN and possibly an ELSE part.CASEENDc V^p^p.pTpVPEFpVP\PR4'g(V'd"VP\P 9dKSVP\PR4'dVP ..34TpMVP\PR4'dTpMdVP\PR4'dVP R.34TpM(VP\PR4'dRpV'dV'gVP ..34WR8Xd#VR,^,P V4EKgWS8XgEKpVR,^,P V4EK V#)zUReturns a list of 2-tuples (condition, value). If an ELSE exists condition is None. rWHENTHENELSENrr\)rr rr$r<r%r )rr CONDITIONVALUEretmoders&& r get_casesCase.get_casesEs.  [[E{{199f--'ekkQ\\>YQYY// B8$ QYY//QYY// D":&QYY..C B8$ B !!%(B !!%(9!> rr-Nr) r.r/r0r1r2rr$r[r]rr3r4r5s@rrr@s.K YY FiiG**rrc0a]tRtRtoRtRtRtRtVtR#)r(irzA function or procedure call.c BVP\R7^,p.pVPFop\V\4'dVP 4u#\ V\\\3\PR7'gK^VPV4Kq V#)zReturn a list of parameters.r)rr ) r#r`rrvr6rOrr(r'rRrLiteralr )r parenthesisresultrs& rget_parametersFunction.get_parametersus}((;(7:  ''E%00,,..Ux\Byy"" e$ (  rc vVP\R7pV'gR#V^,PR,#)zReturn the window if it exists.rNr\)r#rr)r over_clauses& r get_windowFunction.get_windows0((4(0 1~$$R((rr-N) r.r/r0r1r2rrr3r4r5s@rr(r(rs' ))rr(cR]tRtRtRt]P R3t]P R3tRt R#)BeginizA BEGIN/END block.BEGINrr-Nrsr-rrrrs! YY FiiGrrc]tRtRtRtRtR#) OperationizGrouping of operationsr-Nror-rrrrs rrc]tRtRtRtRtR#)ValuesizGrouping of valuesr-Nror-rrrrsrrc]tRtRtRtRtR#)CommandizGrouping of CLI commands.r-Nror-rrrrs#rr)r2rcsqlparserrsqlparse.utilsrrrr8rr0r'r6rRr`rIrnrqruryrrrrrr(rrrrr-rrrs6M -664qqhzPzPz% %P))> Y O9O!)!!Y!++"" $)$  KiK4I49 /Y/ /9/d)~y).I ! !Y$i$r