R jQ&SrSSKrSSKJr SSKJrJr "SS5r"SS5r "S S \ 5r "S S \ 5r "S S\\ 5r "SS\ 5r "SS\ 5r"SS\ 5r"SS\ 5r"SS\ 5r"SS\ 5r"SS\ 5r"SS\ 5r"SS \ 5r"S!S"\ 5r"S#S$\ 5r"S%S&\ 5r"S'S(\ 5r"S)S*\\ 5r"S+S,\ 5r"S-S.\ 5r"S/S0\ 5r"S1S2\ 5rg)3zFThis module contains classes representing syntactical elements of SQL.Ntokens)imt remove_quotesc$\rSrSrSrSrSrSrg)NameAliasMixinz'Implements get_real_name and get_alias.cdUR[RS4S9upURUSS9$)7Returns the real name (object name) of this identifier..mT) real_name) token_next_byT Punctuation_get_first_name)selfdot_idx_s 8D:\diplom_project\venv\Lib\site-packages\sqlparse/sql.py get_real_nameNameAliasMixin.get_real_names8''1==#*>'? ##Gt#<<cUR[RS4S9upUbURUS-SS9$UR[RS9up4[ UR 5S:aUbURSS 9$gg) 2Returns the alias for this identifier or ``None``.ASr NT)keywordstreverse)rrKeywordr Whitespacelenr)rkw_idxkwrwss r get_aliasNameAliasMixin.get_aliass''199d*;'<  >'' T'B B""Q\\"2 t{{ a BN'''5 5%3 rN)__name__ __module__ __qualname____firstlineno____doc__rr+__static_attributes__r-rrrrs1= 6rrc\\rSrSrSrSrSrSrSrSr Sr S r SS jr S r S rS rSrg)Token'zBase 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. )valuettypeparent normalized is_keywordis_group is_whitespace is_newlinecb[U5nX lXlSUlSUlU[ R ;UlUR[ R;Ul UR[ R;Ul UR(aUR5Ul gUUl g)NF)strr7r8r9r<rr%r;r&r=Newliner>upperr:)rr8r7s r__init__Token.__init__2suE     199,!ZZ1<<7** 1+/??%++-rcUR$Nr7rs r__str__ Token.__str__=s zzrcUR5nUR5nURS5(aURS5(aSOSnSR"SS[ U50[ 5D6$)N'"z"<{cls} {q}{value}{q} at 0x{id:2X}>idr-)_get_repr_name_get_repr_value startswithendswithformatrNlocals)rclsr7qs r__repr__Token.__repr__Dsl!!#$$&##C((U^^C-@-@Cc3::%$x%!8% %rcP[UR5RS5S$)Nr )r@r8splitrHs rrOToken._get_repr_nameLs 4::$$S)"--rcv[U5n[U5S:aUSSS-n[R"SSU5$)Nz...z\s+ )r@r'resub)rraws rrPToken._get_repr_valueOs8$i s8a<bq'E/Cvvfc3''rc## Uv g7f)zResolve subgroups.Nr-rHs rflatten Token.flattenUs  sc~^URULnU(aUcU$[U[5(aU4nU(a[UR(a[R OSmU4SjU5nUH%nUR UR5(dM% g gUR(a SU5nURU;$)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``. rc3R># UHn[R"UT5v M g7frF)racompile).0vflags r Token.match..os:6abjjD))6s$'TFc3@# UHoR5v M g7frF)rB)rkrls rrnrows0Aggiis)r8 isinstancer@r;ra IGNORECASEsearchr:)rr8valuesregex type_matchedpatternrms @rmatch Token.matchYszzU* v~  fc " "YF $(OO2==D:6:F!>>$//22" ??00F&((rcvURnU(a&[X!5(agURnU(aM&g)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)r9rq)r group_clsr9s rwithin Token.within{s3 &,,]]Ffrc URU:H$)zr=r:r9r8r7NF)r.r/r0r1r2 __slots__rCrIrWrOrPrfrxr|rrr3r-rrr5r5'sBU=(d /UlURVs/sHn[USU5PM n[TU] S[ U55 SUlgs snf)Nr9T)rsetattrsuperrCr@r<)rrtoken __class__s rrCTokenList.__init__sMl 59[[A[E$ '[A s4y)  BsAcNSRSUR555$)Nc38# UHoRv M g7frFrG)rkrs rrn$TokenList.__str__..s?u{{s)joinrfrHs rrITokenList.__str__sww? ???rc,[UR5$rF)iterrrHs r__iter__TokenList.__iter__sDKK  rc URU$rFr)ritems r __getitem__TokenList.__getitem__s{{4  rc,[U5R$rF)typer.rHs rrOTokenList._get_repr_namesDz"""rc [UR5n[UR5HupgUR5nUR 5n XeS- :Hn U (aSOSn U R S5(aU R S5(aSOSn [UU USUSU U U 3 US9 UR(dMUbX!:dMU (aS OS n URXS-X4U -5 M g) zPretty-print the object tree.rz`- z|- rLrMr`)fileNz z| ) r'r enumeraterOrPrQrRprintr< _pprint_tree)r max_depthdepthf_pre token_countidxrrUr7lastprerV parent_pres rrTokenList._pprint_trees$++& #DKK0JC&&(C))+E?+D%UC'',,1D1D#A TF3%uAcU!A3ugaS9 B~~~9#48I&*U ""9ai:T=(a UR=(d& T=(a [U[R[S9(+$N)r!ir=rrCommenttkskip_cmskip_wss rmatcher&TokenList.token_first..matcher8 5R%5%5I#GB!))w(GJ Jrrr)rrrrs `` r token_firstTokenList.token_firsts! J##G,Q//rcB^^^US- nURUUU4SjXE5$)Nrc >[UTTT5$rF)r)rrrr!s r)TokenList.token_next_by.. ss2q!Q/?rr)rrrr!rrs ``` rrTokenList.token_next_bys  q##$?JJrc^[U[[45(dU4OUnUV^s/sH mU4SjPM nnURX5$s snf)Nc>T"U5(+$rFr-)rrs rr.TokenList.token_not_matching..s RLr)rqrrr)rrrrs `rtoken_not_matchingTokenList.token_not_matching sG *54- @ @e5:;UT(U;##E//T=(a UR=(d& T=(a [U[R[S9(+$rrrs rr%TokenList.token_next..matcher)rrr#r)rrrrrrs `` rrTokenList.token_nexts4 ; q J##G(#CCrc[U[5(aUOURU5nX RUSR U5-$)zReturn list index of token.N)rqint token_indexrindex)rrrs rrTokenList.token_index.s?#E3//T5E5Ee5L{{56*00777rcvUnURUnX4-nU(ab[X!5(aRURUS-UnUn U RRU5 URUS-U2 [U5U lO+URXgnU"U5n U /URXg&X lUH n XlM U $)z+Replace tokens by an instance of *grp_cls*.r)rrqextendr@r7r9) rgrp_clsrr include_endr start_idxend_idx subtokensgrprs r group_tokensTokenList.group_tokens3s  I&# j00 IM':IC JJ  i ( IM'12E CI I6I)$C.1UDKK *JEL rc[U[5(dURU5nXlURR X5 g)zInserts *token* before *where*.N)rqrrr9rinsert)rwherers r insert_beforeTokenList.insert_beforeQs6%%%$$U+E  5(rc[U[5(dURU5nURXS9upEXlUcUR R U5 gUR RXB5 g)zInserts *token* after *where*.rN)rqrrrr9rappendr)rrrrnidxnext_s r insert_afterTokenList.insert_afterXs_%%%$$U+Eooeo=  = KK  u % KK  t +rc&UR5SL$)z(Returns ``True`` if an alias is present.N)r+rHs r has_aliasTokenList.has_aliascs~~t++rcg)rNr-rHs rr+TokenList.get_aliasgrcPUR5=(d UR5$)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+rrHs rget_nameTokenList.get_nameks~~74#5#5#77rcg)r Nr-rHs rrTokenList.get_real_nametrrcUR[RS4S9upURU5up#Ub[ UR 5$S$)zdReturn name of the parent object if any. A parent object is identified by the first occurring dot. r r N)rrrrrr7)rrrprev_s rget_parent_nameTokenList.get_parent_namexsK ''1==#*>'? ??7+-2->}U[[)HDHrcU(aURUSO URnU(a [U5OUn[R[R[R R /nU(aUR[R5 UHpnURU;a[UR5s $[U[[45(dMGU(aUR5s $UR!5s $ g)z/Returns the name of the first token with a nameN)rreversedrNameWildcardStringSymbolrr%r8rr7rq IdentifierFunctionrr)rrr$rrrtypesrs rrTokenList._get_first_names'*ST"t{{%,&!&QXX__5  LL #E{{e#$U[[11EJ#9::09u**,Ou~~?OO r)r<rrF)NrNr)rNF)TF)NNNrZN)TFF)r)T)NFFF)$r.r/r0r1r2rrCrIrrrOrrrfrpropertyrrrrrrrrrrrr r r+rrrrr3 __classcell__)rs@rrrs I @!!#O"  , 0K0 3ED 8 =A!<) ,,8IAF"'PPrrc\rSrSrSrSrSrg) StatementizRepresents a SQL statement.c4URSS9nUcgUR[RR[RR 4;a UR $UR[RR:XaURU5nUb{URUSS9up![U[[45(aIURUSS9up!Ub4UR[RR:Xa UR $UbM{g)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) rr8rr%DMLDDLr:CTErrrqr IdentifierList)rrtidxs rget_typeStatement.get_types   . = [[QYY]]AIIMM: :## # [[AIIMM )##E*D""oodDoA ej.%ABB"&//$/"EKD( % qyy}} <$///"rr-N)r.r/r0r1r2r/r3r-rrr'r's %"rr'c0\rSrSrSrSrSrSrSrSr g) r izFRepresents an identifier. Identifiers may have aliases or typecasts. cHUR[RS9upUSL$)z7Return ``True`` if this identifier contains a wildcard.r N)rrr)rrrs r is_wildcardIdentifier.is_wildcards&%% %3D  rcUR[RS4S9upURUSS9up4U(a UR$S$)z ?Fhhoot#GyyNNHrrIc`\rSrSrSr\R S4r\R S4r\ S5r Sr g) ParenthesisizTokens between parenthesis.()c URSS$NrrZrrHs rrParenthesis._groupable_tokens{{1R  rr-N r.r/r0r1r2rrrRrTr$rr3r-rrrWrWs3% ]]C FmmS G !!rrWc`\rSrSrSr\R S4r\R S4r\ S5r Sr g)r@izTokens between square brackets[]c URSS$r[rrHs rr SquareBrackets._groupable_tokensr]rr-Nr^r-rrr@r@s3( ]]C FmmS G !!rr@c\rSrSrSrSrg) Assignmentiz An assignment like 'var := val;'r-Nr.r/r0r1r2r3r-rrreres*rrecP\rSrSrSr\R S4r\R S4rSr g)Ifiz7An 'if' clause with possible 'else if' or 'else' parts.IFzEND IFr-N r.r/r0r1r2rr%rRrTr3r-rrrhrhs A YY_Fii!GrrhcP\rSrSrSr\R S4r\R S4rSr g)Fori z A 'FOR' loop.)FORFOREACHzEND LOOPr-Nrjr-rrrlrl s" YY* *Fii#Grrlc8\rSrSrSr\S5r\S5rSrg) Comparisoniz/A comparison used for example in WHERE clauses.c URS$NrrrHs rleftComparison.lefts{{1~rc URS$)NrZrrHs rrightComparison.rights{{2rr-N) r.r/r0r1r2r$rsrvr3r-rrrprps+9 rrpc\rSrSrSrSrSrg)riz A comment.cUR=(a4 URSR[RR:H$rr)rr8rr MultilinerHs r is_multilineComment.is_multiline!s.{{Jt{{1~33qyy7J7JJJrr-N)r.r/r0r1r2r{r3r-rrrrs KrrcP\rSrSrSr\R S4r\R S4rSr g)Wherei%zA WHERE clause.WHERE) ORDER BYzGROUP BYLIMITUNIONz UNION ALLEXCEPT INTERSECTHAVING RETURNINGINTOr-Nrjr-rrr~r~%s& YY Fii44Grr~c4\rSrSrSr\R S4rSrg)Overi-zAn OVER clause.OVERr-N) r.r/r0r1r2rr%rRr3r-rrrr-s YY FrrcP\rSrSrSr\R S4r\R S4rSr g)Havingi2zA HAVING clause.r)rrr-Nrjr-rrrr2s" YY Fii..GrrcZ\rSrSrSr\R S4r\R S4rSSjr Sr g) Casei8zAA CASE statement with one or more WHEN and possibly an ELSE part.CASEENDc$SnSn/nUnURGHvnUR[RS5(aM+U(a UR[R ;aMRUR[RS5(aUR //45 UnOUR[RS5(aUnObUR[RS5(aUR S/45 UnO'UR[RS5(aSnU(aU(dUR //45 XR:XaUS S R U5 GMWXS:XdGM_US SR U5 GMy U$) zUReturns a list of 2-tuples (condition, value). If an ELSE exists condition is None. rr"rWHENTHENELSENrrZr)rrxrr%r8r&r)rr CONDITIONVALUEretmoders r get_casesCase.get_cases=s3  [[E{{199f--U[[ALL8QYY// B8$ QYY//QYY// D":&QYY..C B8$ B !!%(B !!%(?!D rr-Nr) r.r/r0r1r2rr%rRrTrr3r-rrrr8s&K YY FiiG-rrc$\rSrSrSrSrSrSrg)r!imzA function or procedure call.c*UR[S9Sn/nURHjn[U[5(aUR 5s $[ U[[[4[RS9(dMYURU5 Ml U$)zReturn a list of parameters.rr)rr!) rrWrrqr-rFrr!r rIrLiteralr)r parenthesisresultrs rget_parametersFunction.get_parametersps}((;(7:  ''E%00,,..Ux\Byy"" e$ (  rc\UR[S9nU(dgUSRS$)zReturn the window if it exists.rNrrZ)rrr)r over_clauses r get_windowFunction.get_window|s0((4(0 1~$$R((rr-N)r.r/r0r1r2rrr3r-rrr!r!ms' )rr!cP\rSrSrSr\R S4r\R S4rSr g)BeginizA BEGIN/END block.BEGINrr-Nrjr-rrrrs! YY FiiGrrc\rSrSrSrSrg) OperationizGrouping of operationsr-Nrfr-rrrrs rrc\rSrSrSrSrg)ValuesizGrouping of valuesr-Nrfr-rrrrsrrc\rSrSrSrSrg)CommandizGrouping of CLI commands.r-Nrfr-rrrrs#rr)r2rasqlparserrsqlparse.utilsrrrr5rr'r r-rIrWr@rerhrlrprr~rrrr!rrrrr-rrrs6M -66.ll^zPzPz% %P))> Y O9O!)!!Y!++"" $)$  KiK4I49 /Y/ 292j)~y).I ! !Y$i$r