/usr/local/lib/python3.9/site-packages/sqlparse/__pycache__
a Ұ�hnQ � @ s� d Z ddlZddlmZ ddlmZmZ G dd� d�ZG dd� d�Z G d d � d e �Z G d d � d e �Z G d d� dee �Z G dd� de �Z G dd� de �ZG dd� de �ZG dd� de �ZG dd� de �ZG dd� de �ZG dd � d e �ZG d d � d e �ZG d d � d e �ZG d!d"� d"e �ZG d#d$� d$e �ZG d%d&� d&e �ZG d'd(� d(e �ZG d)d*� d*ee �ZG d+d,� d,e �ZG d-d.� d.e �Z G d/d0� d0e �Z G d1d2� d2e �Z dS )3zFThis module contains classes representing syntactical elements of SQL.� N��tokens)�imt� remove_quotesc @ s e Zd ZdZdd� Zdd� ZdS )�NameAliasMixinz'Implements get_real_name and get_alias.c C s$ | j tjdfd�\}}| j|dd�S )�7Returns the real name (object name) of this identifier.�.��mT)� real_name)� token_next_by�T� Punctuation�_get_first_name)�self�dot_idx�_� r �6/usr/local/lib/python3.9/site-packages/sqlparse/sql.py� get_real_name s z NameAliasMixin.get_real_namec C sh | j tjdfd�\}}|dur0| j|d dd�S | j tjd�\}}t| j�dkrd|durd| jdd �S dS ) �2Returns the alias for this identifier or ``None``.ZASr N� T)�keywords��t� ��reverse)r r �Keywordr � Whitespace�lenr )r Zkw_idx�kwr �wsr r r � get_alias s zNameAliasMixin.get_aliasN)�__name__� __module__� __qualname__�__doc__r r# r r r r r s r c @ sf e Zd ZdZdZdd� Zdd� Zdd� Zd d � Zd d � Z d d� Z ddd�Z dd� Z dd� Z dd� ZdS )�Tokenz�Base 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. )�value�ttype�parent� normalized� is_keyword�is_group� is_whitespace� is_newlinec C s` t |�}|| _|| _d | _d| _|tjv | _| jtjv | _ | jtj v | _ | jrV|� � n|| _ d S )NF)�strr) r* r+ r. r r r- r r/ ZNewliner0 �upperr, )r r* r) r r r �__init__2 s zToken.__init__c C s | j S �N�r) �r r r r �__str__= s z Token.__str__c C sF | � � }| �� }|�d�r(|�d�r(dnd}djf dt| �it� ��S )N�'�"z"<{cls} {q}{value}{q} at 0x{id:2X}>�id)�_get_repr_name�_get_repr_value� startswith�endswith�formatr: �locals)r �clsr) �qr r r �__repr__D s ��zToken.__repr__c C s t | j��d�d S )Nr ���)r1 r* �splitr6 r r r r; L s zToken._get_repr_namec C s2 t | �}t|�dkr$|d d� d }t�dd|�S )N� � z...z\s+� )r1 r �re�sub)r �rawr r r r< O s zToken._get_repr_valuec c s | V dS )zResolve subgroups.Nr r6 r r r �flattenU s z Token.flattenFc s� | j |u }|r|du r|S t|t�r*|f}|rp| jr:tjnd� � fdd�|D �}|D ]}|�| j�rT dS qTdS | jr�dd� |D �}| j|v S )a, Checks whether the token matches the given arguments. *ttype* is a token type. If this token doesn't match the given token type. *values* is a list of possible values for this token. The values are OR'ed together so if only one of the values matches ``True`` is returned. Except for keyword tokens the comparison is case-sensitive. For convenience it's OK to pass in a single string. If *regex* is ``True`` (default is ``False``) the given values are treated as regular expressions. Nr c 3 s | ]}t �|� �V qd S r4 )rI �compile��.0�v��flagr r � <genexpr>o � z Token.match.<locals>.<genexpr>TFc s s | ]}|� � V qd S r4 )r2 rN r r r rS w rT )r* � isinstancer1 r- rI � IGNORECASE�searchr, )r r* �values�regexZ type_matched�patternr rQ r �matchY s z Token.matchc C s$ | j }|r t||�rdS |j }qdS )z�Returns ``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+ rU )r Z group_clsr+ r r r �within{ s z Token.withinc C s | j |kS )z<Returns ``True`` if this token is a direct child of *other*.�r+ )r �otherr r r � is_child_of� s zToken.is_child_ofc C s" | j }|r ||krdS |j }qdS )z7Returns ``True`` if *other* is in this tokens ancestry.TFr] )r r^ r+ r r r � has_ancestor� s zToken.has_ancestorN)F)r$ r% r& r' � __slots__r3 r7 rC r; r< rL r[ r\ r_ r` r r r r r( ' s " r( c s e Zd ZdZdZd?� fdd� Zdd� Zdd � Zd d � Zd d � Z d@dd�Z dd� Z dd� Z dd� Z edd� �ZdAdd �ZdBd d �ZdCd!d"�Zd#d$� Zd%d&� ZdDd'd(�ZdEd)d*�ZdFd+d,�ZdGd-d.�Zd/d0� ZdHd1d2�Zd3d4� Zd5d6� Z d7d8� Z d9d:� Z d;d<� Z dId=d>�Z � Z!S )J� TokenListzwA group of tokens. It has an additional instance attribute ``tokens`` which holds a list of child-tokens. r Nc s: |pg � _ � fdd�� j D � t� �d t� �� d� _d S )Nc s g | ]}t |d � ��qS r] )�setattr�rO �tokenr6 r r � <listcomp>� rT z&TokenList.__init__.<locals>.<listcomp>T)r �superr3 r1 r. )r r �� __class__r6 r r3 � s zTokenList.__init__c C s d� dd� | �� D ��S )N� c s s | ] }|j V qd S r4 r5 rd r r r rS � rT z$TokenList.__str__.<locals>.<genexpr>)�joinrL r6 r r r r7 � s zTokenList.__str__c C s t | j�S r4 )�iterr r6 r r r �__iter__� s zTokenList.__iter__c C s | j | S r4 r )r �itemr r r � __getitem__� s zTokenList.__getitem__c C s t | �jS r4 )�typer$ r6 r r r r; � s zTokenList._get_repr_namer rj c C s� t | j�}t| j�D ]�\}}|�� }|�� } ||d k} | r@dnd} | �d�r\| �d�r\dnd} tdjf i t � ��|d� |j r|du s�||k r| r�d nd } |� ||d ||| � qdS ) z Pretty-print the object tree.r z`- z|- r8 r9 z${_pre}{pre}{idx} {cls} {q}{value}{q})�fileNz z| ) r r � enumerater; r< r= r> �printr? r@ r. � _pprint_tree)r � max_depth�depth�f�_preZ token_count�idxre rA r) �last�prerB Z parent_prer r r rt � s �� zTokenList._pprint_treec C sH d}| � � D ]6}|t|j� }|| kr2|k r>n n| S |}q dS )z-Returns the token that is on position offset.r N)rL r r) )r �offsetry re �endr r r �get_token_at_offset� s z TokenList.get_token_at_offsetc c s, | j D ] }|jr |�� E dH q|V qdS )znGenerator yielding ungrouped tokens. This method is recursively called for all child tokens. N)r r. rL �r re r r r rL � s zTokenList.flattenc c s | j D ]}|jr|V qd S r4 )r r. r r r r � get_sublists� s zTokenList.get_sublistsc C s | j S r4 r r6 r r r �_groupable_tokens� s zTokenList._groupable_tokensFc C s� |du r dS t |ttf�s |f}|rB|du s0J �t|d dd�}n |du rTt| j�}t||�}|D ]0}| j| }|D ] }||�rt||f S qtqbdS )z next token that match functionsNr rD �NN)rU �list�tuple�ranger r ) r �funcs�startr} r Zindexesry re �funcr r r �_token_matching� s zTokenList._token_matchingTc s � �fdd�}| � |�d S )z�Returns 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 �r | j p � o t| tjtd� S �N)r �i�r/ r r �Comment�Ztk��skip_cm�skip_wsr r �matcher s �z&TokenList.token_first.<locals>.matcherr �r� )r r� r� r� r r� r � token_first� s zTokenList.token_firstrD c s" |d7 }| � � ��fdd�||�S )Nr c s t | � ���S r4 )r r� �r� r r r r �<lambda> rT z)TokenList.token_next_by.<locals>.<lambda>r� )r r� r r ry r} r r� r r s zTokenList.token_next_byc C s2 t |ttf�s|fn|}dd� |D �}| �||�S )Nc s g | ]� � fd d��qS )c s � | � S r4 r r� �r� r r r� rT z9TokenList.token_not_matching.<locals>.<listcomp>.<lambda>r )rO r r� r rf rT z0TokenList.token_not_matching.<locals>.<listcomp>)rU r� r� r� �r r� ry r r r �token_not_matching s z TokenList.token_not_matchingc C s | � ||�d S )Nr r� r� r r r �token_matching s zTokenList.token_matchingc C s | j |||dd�S )z�Returns 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)r ry r� r� r r r � token_prev s zTokenList.token_prevc s2 |du r dS |d7 }� �fdd�}| j |||d�S )z�Returns 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. Nr� r c s �r | j p � o t| tjtd� S r� r� r� r� r r r� * s �z%TokenList.token_next.<locals>.matcherr r� )r ry r� r� r� r� r r� r r� s zTokenList.token_nextc C s0 t |t�r|n| �|�}|| j|d� �|� S )zReturn list index of token.N)rU �int� token_indexr �index)r re r� r r r r� / s zTokenList.token_indexc C s� |}| j | }|| }|rbt||�rb| j |d |� }|} | j �|� | j |d |�= t|�| _n,| j ||� }||�} | g| j ||�< | | _|D ] } | | _q�| S )z+Replace tokens by an instance of *grp_cls*.r )r rU �extendr1 r) r+ ) r Zgrp_clsr� r} Z include_endr� Z start_idxZend_idxZ subtokens�grpre r r r � group_tokens4 s zTokenList.group_tokensc C s, t |t�s| �|�}| |_| j�||� dS )z Inserts *token* before *where*.N)rU r� r� r+ r �insert)r �wherere r r r � insert_beforeR s zTokenList.insert_beforec C sT t |t�s| �|�}| j||d�\}}| |_|du rB| j�|� n| j�||� dS )z Inserts *token* after *where*.�r� N)rU r� r� r� r+ r �appendr� )r r� re r� �nidx�next_r r r � insert_afterY s zTokenList.insert_afterc C s | � � duS )z(Returns ``True`` if an alias is present.N)r# r6 r r r � has_aliasd s zTokenList.has_aliasc C s dS )r Nr r6 r r r r# h s zTokenList.get_aliasc C s | � � p| �� S )a Returns 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# r r6 r r r �get_namel s zTokenList.get_namec C s dS )r Nr r6 r r r r u s zTokenList.get_real_namec C s: | j tjdfd�\}}| �|�\}}|dur6t|j�S dS )ztReturn name of the parent object if any. A parent object is identified by the first occurring dot. r r N)r r r r� r r) )r r r Zprev_r r r �get_parent_namey s zTokenList.get_parent_namec C s� |r| j |d� n| j }|r$t|�n|}tjtjtjjg}|rJ|�tj� |D ]B}|j |v rjt |j � S t |t tf�rN|r�|�� n|�� S qNdS )z/Returns the name of the first token with a nameN)r �reversedr �Name�Wildcard�String�Symbolr� r r* r r) rU � Identifier�Functionr r� )r ry r r r r �typesre r r r r � s zTokenList._get_first_name)N)Nr Nrj )r NF)TF)NNNrD N)TF)TFF)r )TF)T)NFFF)"r$ r% r& r' ra r3 r7 rm ro r; rt r~ rL r� �propertyr� r� r� r r� r� r� r� r� r� r� r� r� r# r� r r� r � __classcell__r r rh r rb � sD � �rb c @ s e Zd ZdZdd� ZdS )� StatementzRepresents a SQL statement.c C s� | j dd�}|du rdS |jtjjtjjfv r4|jS |jtjjkr�| �|�}|dur�| j |dd�\}}t |t t f�rL| j |dd�\}}|durL|jtjjkrL|jS qLdS )aM Returns 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)r� N�UNKNOWNr� ) r� r* r r ZDMLZDDLr, ZCTEr� r� rU r� �IdentifierList)r re Ztidxr r r �get_type� s �zStatement.get_typeN)r$ r% r& r' r� r r r r r� � s r� c @ s0 e Zd ZdZdd� Zdd� Zdd� Zdd � Zd S ) r� zNRepresents an identifier. Identifiers may have aliases or typecasts. c C s | j tjd�\}}|duS )z7Return ``True`` if this identifier contains a wildcard.r N)r r r� )r r re r r r � is_wildcard� s zIdentifier.is_wildcardc C s6 | j tjdfd�\}}| j|dd�\}}|r2|jS dS )z<Returns the typecast or ``None`` of this object as a string.z::r Fr� N)r r r r� r) )r Zmidx�markerr� r� r r r � get_typecast� s zIdentifier.get_typecastc C s" | j tjjd�\}}|r |jS dS )z5Returns the ordering or ``None`` as uppercase string.r N)r r r ZOrderr, )r r Zorderingr r r � get_ordering� s zIdentifier.get_orderingc c s* | j D ] }t|t�r|j dd� V qdS )z(Returns an iterator of index token listsr rD N)r rU �SquareBracketsr r r r �get_array_indices� s z Identifier.get_array_indicesN)r$ r% r& r' r� r� r� r� r r r r r� � s r� c @ s e Zd ZdZdd� ZdS )r� z.A list of :class:`~sqlparse.sql.Identifier`'s.c c s* | j D ] }|js|�tjd�s|V qdS )zkReturns the identifiers. Whitespaces and punctuations are not included in this generator. �,N)r r/ r[ r r r r r r �get_identifiers� s z IdentifierList.get_identifiersN)r$ r% r& r' r� r r r r r� � s r� c @ s< e Zd ZdZejjdfejdfgZej j dfZ ejdfZ dS )� TypedLiteralzEA typed literal, such as "date '2001-09-28'" or "interval '2 hours'".N� TIMESTAMP)ZDAYZHOURZMINUTEZMONTHZSECONDZYEAR) r$ r% r& r' r r� �Builtinr �M_OPENr� �Single�M_CLOSEZM_EXTENDr r r r r� � s r� c @ s0 e Zd ZdZejdfZejdfZedd� �Z dS )� ParenthesiszTokens between parenthesis.�(�)c C s | j dd� S �Nr rD r r6 r r r r� � s z Parenthesis._groupable_tokensN� r$ r% r& r' r r r� r� r� r� r r r r r� � s r� c @ s0 e Zd ZdZejdfZejdfZedd� �Z dS )r� z Tokens between square brackets�[�]c C s | j dd� S r� r r6 r r r r� � s z SquareBrackets._groupable_tokensNr� r r r r r� � s r� c @ s e Zd ZdZdS )� Assignmentz An assignment like 'var := val;'N�r$ r% r& r' r r r r r� s r� c @ s$ e Zd ZdZejdfZejdfZdS )�Ifz7An 'if' clause with possible 'else if' or 'else' parts.ZIFzEND IFN�r$ r% r& r' r r r� r� r r r r r� s r� c @ s$ e Zd ZdZejdfZejdfZdS )�Forz A 'FOR' loop.)ZFORZFOREACHzEND LOOPNr� r r r r r� s r� c @ s( e Zd ZdZedd� �Zedd� �ZdS )� Comparisonz/A comparison used for example in WHERE clauses.c C s | j d S �Nr r r6 r r r �left s zComparison.leftc C s | j d S )NrD r r6 r r r �right s zComparison.rightN)r$ r% r& r' r� r� r� r r r r r� s r� c @ s e Zd ZdZdd� ZdS )r� z A comment.c C s | j o| j d jtjjkS r� )r r* r r� � Multiliner6 r r r � is_multiline" s zComment.is_multilineN)r$ r% r& r' r� r r r r r� s r� c @ s$ e Zd ZdZejdfZejdfZdS )�WherezA WHERE clause.ZWHERE) �ORDER BYzGROUP BY�LIMITZUNIONz UNION ALLZEXCEPT�HAVINGZ RETURNINGZINTONr� r r r r r� & s r� c @ s e Zd ZdZejdfZdS )�OverzAn OVER clause.ZOVERN)r$ r% r& r' r r r� r r r r r� . s r� c @ s$ e Zd ZdZejdfZejdfZdS )�HavingzA HAVING clause.r� )r� r� Nr� r r r r r� 3 s r� c @ s. e Zd ZdZejdfZejdfZddd�ZdS ) �CasezAA CASE statement with one or more WHEN and possibly an ELSE part.�CASE�ENDFc C s� d}d}g }|}| j D ]�}|�tjd�r,qn~|r@|jtjv r@qnj|�tjd�rb|�g g f� |}nH|�tjd�rv|}n4|�tjd�r�|�dg f� |}n|�tjd�r�d}|r�|s�|�g g f� ||kr�|d d �|� q||kr|d d �|� q|S ) zeReturns a list of 2-tuples (condition, value). If an ELSE exists condition is None. r r r� ZWHENZTHEN�ELSENr� rD r )r r[ r r r* r r� )r r� Z CONDITIONZVALUE�ret�modere r r r � get_cases> s4 zCase.get_casesN)F) r$ r% r& r' r r r� r� r� r r r r r� 9 s r� c @ s e Zd ZdZdd� Zdd� ZdS )r� z A function or procedure call.c C sZ | j td�d }g }|jD ]:}t|t�r4|�� S t|ttt ft j d�r|� |� q|S )z Return a list of parameters.�r� r )r� r ) r r� r rU r� r� r r� r� r� r �Literalr� )r Z parenthesis�resultre r r r �get_parametersq s � zFunction.get_parametersc C s" | j td�}|sdS |d jd S )z Return the window if it exists.r� Nr rD )r r� r )r Z over_clauser r r � get_window} s zFunction.get_windowN)r$ r% r& r' r� r� r r r r r� n s r� c @ s$ e Zd ZdZejdfZejdfZdS )�BeginzA BEGIN/END block.ZBEGINr� Nr� r r r r r� � s r� c @ s e Zd ZdZdS )� OperationzGrouping of operationsNr� r r r r r� � s r� c @ s e Zd ZdZdS )�ValueszGrouping of valuesNr� r r r r r� � s r� c @ s e Zd ZdZdS )�CommandzGrouping of CLI commands.Nr� r r r r r� � s r� ) r' rI Zsqlparser r Zsqlparse.utilsr r r r( rb r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r r r �<module> s8 o ( 5
.
Edit
..
Edit
__init__.cpython-39.pyc
Edit
__main__.cpython-39.pyc
Edit
cli.cpython-39.pyc
Edit
exceptions.cpython-39.pyc
Edit
formatter.cpython-39.pyc
Edit
keywords.cpython-39.pyc
Edit
lexer.cpython-39.pyc
Edit
sql.cpython-39.pyc
Edit
tokens.cpython-39.pyc
Edit
utils.cpython-39.pyc
Edit