jQdZddlZddlmZddlmZmZGddZGddZ Gd d e Z Gd d e Z Gd dee Z Gdde Z Gdde ZGdde ZGdde ZGdde ZGdde ZGdde ZGdde ZGdd e ZGd!d"e ZGd#d$e ZGd%d&e ZGd'd(e ZGd)d*ee ZGd+d,e ZGd-d.e ZGd/d0e ZGd1d2e ZdS)3zFThis module contains classes representing syntactical elements of SQL.Ntokens)imt remove_quotesceZdZdZdZdZdS)NameAliasMixinz'Implements get_real_name and get_alias.cz|tjdf\}}||dS)7Returns the real name (object name) of this identifier..mT) real_name) token_next_byT Punctuation_get_first_name)selfdot_idx_s [/var/www/finuniver-perm.ru/html/portfolio/venv/lib/python3.11/site-packages/sqlparse/sql.py get_real_namezNameAliasMixin.get_real_names>''1=#*>'?? ##Gt#<<<c2|tjdf\}}|||dzdS|tj\}}t |jdkr||d SdSdS) 2Returns the alias for this identifier or ``None``.ASr NT)keywordstreverse)rrKeywordr Whitespacelenr)rkw_idxkwrwss r get_aliaszNameAliasMixin.get_aliass''19d*;'<<  >'' T'BB B""Q\"222 t{  a  BN'''55 5 NNrN)__name__ __module__ __qualname____doc__rr)rrrrs811=== 6 6 6 6 6rrcTeZdZdZdZdZdZdZdZdZ dZ dd Z d Z d Z d ZdS)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. )valuettypeparent normalized is_keywordis_group is_whitespace is_newlinec&t|}||_||_d|_d|_|t jv|_|jt jv|_ |jt j v|_ |jr| n||_ dS)NF)strr1r2r3r6rr#r5r$r7Newliner8upperr4)rr2r1s r__init__zToken.__init__2svE     19,!Z1<7* 1+/?E%++---rc|jSNr1rs r__str__z Token.__str__=s zrc|}|}|dr|drdnd}djddt |it S)N'"z"<{cls} {q}{value}{q} at 0x{id:2X}>idr.)_get_repr_name_get_repr_value startswithendswithformatrFlocals)rclsr1qs r__repr__zToken.__repr__Ds!!##$$&&##C(( IU^^C-@-@ ICCc:3:%%$xx%!88%% %rc\t|jddS)Nr )r:r2splitrAs rrGzToken._get_repr_nameLs#4:$$S))"--rct|}t|dkr |dddz}tjdd|S)Nz...z\s+ )r:r%resub)rraws rrHzToken._get_repr_valueOsA$ii s88a<<bqb'E/Cvfc3'''rc#K|VdS)zResolve subgroups.Nr.rAs rflattenz Token.flattenUs rFc|j|u}|r||St|tr|f}|rG|jr tjndfd|D}|D]}||jrdS dS|jr d|D}|j|vS)alChecks 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``. Nrc3BK|]}tj|VdSr?)rWcompile).0vflags r zToken.match..os/::abjD))::::::rTFc3>K|]}|VdSr?)r<)r_r`s rrbzToken.match..ws*00Aaggii000000r)r2 isinstancer:r5rW IGNORECASEsearchr4)rr2valuesregex type_matchedpatternras @rmatchz Token.matchYszU*  v~  fc " " YF  $(O:2==D::::6:::F!  >>$/22 44 5 ? 100000F&((rcN|j}|rt||rdS|j}|dS)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)r3rd)r group_clsr3s rwithinz Token.within{sB  #&),, t]F #urc|j|kS)zz&TokenList.__init__..s%AAAE$ ' 'AAArT)rsuperr=r:r6)rr __class__s` rr=zTokenList.__init__sVl AAAAT[AAAA s4yy))) rcddd|DS)Nc3$K|] }|jV dSr?r@)r_r|s rrbz$TokenList.__str__..s$??uu{??????r)joinr[rAs rrBzTokenList.__str__s+ww?? ??????rc*t|jSr?)iterrrAs r__iter__zTokenList.__iter__sDK   rc|j|Sr?r)ritems r __getitem__zTokenList.__getitem__s{4  rc*t|jSr?)typer*rAs rrGzTokenList._get_repr_namesDzz""rrrc t|j}t|jD]\}}|}|} ||dz k} | rdnd} | dr| drdnd} t|| |d|d| | | ||jr,|||kr$| rd nd } | ||dz||| zdS) zPretty-print the object tree.rz`- z|- rDrErV)fileNz z| ) r%r enumeraterGrHrIrJprintr6 _pprint_tree)r max_depthdepthf_pre token_countidxr|rMr1lastprerN parent_pres rrzTokenList._pprint_trees0$+&& #DK00 O OJC&&((C))++E;?+D*%%UC'',,M1D1DM#A T93999c99A9u9a99 B B B B~ O9#4 8I8I&*5UU ""9eaiD:.matcher9 5R%5I#GB!)w(G(G(GJ Jrrr)rrrrs `` r token_firstzTokenList.token_firstsC J J J J J J##G,,Q//rrQcJ|dz }|fd||S)Nrc(t|Sr?)r)rrr rs rz)TokenList.token_next_by.. ss2q!Q/?/?rr)rrr rrrs ``` rrzTokenList.token_next_bys6 q##$?$?$?$?$?$?cJJJrct|ttfs|fn|}d|D}|||S)Ncg|]fdS)c| Sr?r.)rrs rrz9TokenList.token_not_matching...sRLrr.)r_rs @rr}z0TokenList.token_not_matching..s#;;;T((((;;;r)rdrrrrrrs rtoken_not_matchingzTokenList.token_not_matching sI *54- @ @Ke;;U;;;##E3///rc:|||dS)Nrrrs rtoken_matchingzTokenList.token_matchings##E3//22rc4||||dS)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_prevzTokenList.token_prevssGWtDDDrcT|dS|dz }fd}||||S)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. Nrrc^r|jp"o t|tjt Srrrs rrz%TokenList.token_next..matcher)rrr!r)rrrrrrs `` rrzTokenList.token_nextsZ ;: q J J J J J J##GS(#CCCrct|tr|n||}||j|d|zS)zReturn list index of token.N)rdint token_indexrindex)rr|rs rrzTokenList.token_index.sL#E3//LT5E5Ee5L5Lt{566*007777rcf|}|j|}||z}|r`t||rP|j|dz|}|} | j||j|dz|=t|| _n.|j||}||} | g|j||<|| _|D] } | | _ | S)z+Replace tokens by an instance of *grp_cls*.r)rrdextendr:r1r3) rgrp_clsrr include_endr start_idxend_idx subtokensgrpr|s r group_tokenszTokenList.group_tokens3s  I& #  j00  IM'$9:IC J  i ( ( ( IM'12E CII Ig$56I')$$C.1UDK ') *CJ  EELL rct|ts||}||_|j||dS)zInserts *token* before *where*.N)rdrrr3rinsert)rwherer|s r insert_beforezTokenList.insert_beforeQsL%%% ,$$U++E  5%(((((rct|ts||}|||\}}||_||j|dS|j||dS)zInserts *token* after *where*.rN)rdrrrr3rappendr)rrr|rnidxnext_s r insert_afterzTokenList.insert_afterXs%%% ,$$U++EooeWo== e = K  u % % % % % K  tU + + + + +rc.|duS)z(Returns ``True`` if an alias is present.N)r)rAs r has_aliaszTokenList.has_aliascs~~t++rcdS)rNr.rAs rr)zTokenList.get_aliasgtrcR|p|S)aReturns 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)rrAs rget_namezTokenList.get_nameks%~~74#5#5#7#77rcdS)r Nr.rAs rrzTokenList.get_real_nametrrc|tjdf\}}||\}}|t |jndS)ztReturn name of the parent object if any. A parent object is identified by the first occurring dot. r r N)rrrrrr1)rrrprev_s rget_parent_namezTokenList.get_parent_namexsT ''1=#*>'?? ??7++5-2->}U[)))DHrc|r|j|dn|j}|rt|n|}tjtjtjjg}|r|tj|D]i}|j |vrt|j cSt|ttfr,|r|n|cSjdS)z/Returns the name of the first token with a nameN)rreversedrNameWildcardStringSymbolrr#r2rr1rd IdentifierFunctionrr)rrr"rrrtypesr|s rrzTokenList._get_first_names'*:STT""t{%,8&!!!&QX_5  $ LL # # # P PE{e##$U[11111EJ#9:: P09Ou**,,,u~~?O?OOOO P P Prr?)NrNr)rNF)TF)NNNrQN)TFF)r)T)NFFF)"r*r+r,r-rvr=rBrrrGrrr[rpropertyrrrrrrrrrrrrrr)rrrr __classcell__)rs@rrxrxsC I @@@!!!!!!###OOOO"    X, 0 0 0 0KKKK000 333EEEEDDDD 8888 =A!<))) , , , ,,,,888IIIAF"'PPPPPPPPrrxceZdZdZdZdS) StatementzRepresents a SQL statement.c|d}|dS|jtjjtjjfvr|jS|jtjjkr||}|u| |d\}}t|ttfr=| |d\}}|!|jtjjkr|jS|udS)aMReturns 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)rNUNKNOWNr) rr2rr#DMLDDLr4CTErrrdrIdentifierList)rr|tidxs rget_typezStatement.get_types   .. =9 [QY]AIM: : :# # [AIM ) )##E**D""oodDoAA eej.%ABB0"&//$/"E"EKD%( % qy} < <$//"yrN)r*r+r,r-rr.rrrrs)%%"""""rrc*eZdZdZdZdZdZdZdS)rzNRepresents an identifier. Identifiers may have aliases or typecasts. cP|tj\}}|duS)z7Return ``True`` if this identifier contains a wildcard.rN)rrr)rrr|s r is_wildcardzIdentifier.is_wildcards)%% %335D  rc|tjdf\}}||d\}}|r|jndS)z ?Fhot#GyNNHHHrrcLeZdZdZejdfZejdfZedZ dS) ParenthesiszTokens between parenthesis.()c |jddSNrrQrrAs rrzParenthesis._groupable_tokens{1R4  rN r*r+r,r-rrrr rrr.rrr#r#sK%% ]C FmS G !!X!!!rr#cLeZdZdZejdfZejdfZedZ dS)rzTokens between square brackets[]c |jddSr'rrAs rrz SquareBrackets._groupable_tokensr(rNr)r.rrrrsK(( ]C FmS G !!X!!!rrceZdZdZdS) Assignmentz An assignment like 'var := val;'Nr*r+r,r-r.rrr/r/s****rr/c6eZdZdZejdfZejdfZdS)Ifz7An 'if' clause with possible 'else if' or 'else' parts.IFzEND IFNr*r+r,r-rr#rr r.rrr2r2s+AA Y_Fi!GGGrr2c6eZdZdZejdfZejdfZdS)Forz A 'FOR' loop.)FORFOREACHzEND LOOPNr4r.rrr6r6 s- Y* *Fi#GGGrr6c>eZdZdZedZedZdS) Comparisonz/A comparison used for example in WHERE clauses.c|jdSNrrrAs rleftzComparison.lefts{1~rc|jdS)NrQrrAs rrightzComparison.rights{2rN)r*r+r,r-rr=r?r.rrr:r:sN99 XXrr:ceZdZdZdZdS)rz A comment.cZ|jo$|jdjtjjkSr<)rr2rr MultilinerAs r is_multilinezComment.is_multiline!s"{Jt{1~3qy7JJJrN)r*r+r,r-rCr.rrrrs.KKKKKrrc6eZdZdZejdfZejdfZdS)WherezA WHERE clause.WHERE) ORDER BYzGROUP BYLIMITUNIONz UNION ALLEXCEPT INTERSECTHAVING RETURNINGINTONr4r.rrrErE%s1 Y Fi44GGGrrEc$eZdZdZejdfZdS)OverzAn OVER clause.OVERN)r*r+r,r-rr#rr.rrrPrP-s  Y FFFrrPc6eZdZdZejdfZejdfZdS)HavingzA HAVING clause.rL)rGrHNr4r.rrrSrS2s- Y Fi..GGGrrSc>eZdZdZejdfZejdfZddZdS)CasezAA CASE statement with one or more WHEN and possibly an ELSE part.CASEENDFcd}d}g}|}|jD]^}|tjdr$|r|jtjvr:|tjdr|ggf|}n|tjdr|}n\|tjdr|dgf|}n"|tjdrd}|r|s|ggf||kr#|d d |7||kr!|d d|`|S) zeReturns a list of 2-tuples (condition, value). If an ELSE exists condition is None. rr rVWHENTHENELSENrWrQr)rrkrr#r2r$r)rr CONDITIONVALUEretmoder|s r get_caseszCase.get_cases=s  [ ) )E{{19f--  U[AL88QY//  B8$$$ QY// QY//  D":&&&QY..  %C % B8$$$y  B !!%((((B !!%((( rNru) r*r+r,r-rr#rr r`r.rrrUrU8sFKK Y FiG------rrUceZdZdZdZdZdS)rzA function or procedure call.c<|td}g}|jD]p}t|tr|cSt |tttftj r| |q|S)zReturn a list of parameters.rr)rr) rr#rrdrrrrrrrLiteralr)r parenthesisresultr|s rget_parameterszFunction.get_parametersps((;(77:  ' % %E%00 %,,.....Ux\By""" % e$$$ rcf|t}|sdS|djdS)zReturn the window if it exists.rcNrrQ)rrPr)r over_clauses r get_windowzFunction.get_window|s7((4(00  41~$R((rN)r*r+r,r-rgrjr.rrrrms8''   )))))rrc6eZdZdZejdfZejdfZdS)BeginzA BEGIN/END block.BEGINrWNr4r.rrrlrls, Y FiGGGrrlceZdZdZdS) OperationzGrouping of operationsNr0r.rrroros    rroceZdZdZdS)ValueszGrouping of valuesNr0r.rrrqrqsrrqceZdZdZdS)CommandzGrouping of CLI commands.Nr0r.rrrsrss####rrs)r-rWsqlparserrsqlparse.utilsrrrr0rxrrrrr#rr/r2r6r:rrErPrSrUrrlrorqrsr.rrrvs=ML --------66666666.llllllll^zPzPzPzPzPzPzPzPz%%%%% %%%P))))))))>     Y   OOOOO9OOO!!!!!)!!!!!!!!Y!!!++++++++"""""""" $$$$$)$$$        KKKKKiKKK44444I4449 /////Y/// 222229222j)))))~y))).I !!!!! !!!Y$$$$$i$$$$$r