OwlCyberSecurity - MANAGER
Edit File: sql.pyc
� T��ac @ s[ d Z d d l m Z d d l Z d d l m Z d d l m Z m Z m Z d d l m Z m Z d f d � � YZ e d e f d � � Y� Z e d e f d � � Y� Z d e f d � � YZ d e e f d � � YZ d e f d � � YZ d e f d � � YZ d e f d � � YZ d e f d � � YZ d e f d � � YZ d e f d � � YZ d e f d � � YZ d e f d � � YZ d! e f d" � � YZ d# e f d$ � � YZ d% e f d& � � YZ d' e f d( � � YZ d) e e f d* � � YZ d+ e f d, � � YZ! d- e f d. � � YZ" d/ e f d0 � � YZ# d1 e f d2 � � YZ$ d S(3 sF This module contains classes representing syntactical elements of SQL.i����( t print_functionN( t tokens( t string_typest text_typet unicode_compatible( t imtt remove_quotest NameAliasMixinc B s e Z d Z d � Z d � Z RS( s' Implements get_real_name and get_alias.c C s4 | j d t j d f � \ } } | j | d t �S( s7 Returns the real name (object name) of this identifier.t mt .t real_name( t token_next_byt Tt Punctuationt _get_first_namet True( t selft dot_idxt _( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_real_name s !c C s� | j d t j d f � \ } } | d k rD | j | d d t �S| j d t j � \ } } t | j � d k r� | d k r� | j d t � Sd S( s2 Returns the alias for this identifier or ``None``.R t ASi t keywordst ti t reverseN( R R t Keywordt NoneR R t Whitespacet lenR ( R t kw_idxt kwR t ws( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_alias s ! !( t __name__t __module__t __doc__R R ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR s t Tokenc B sq e Z d Z d Z d � Z d � Z d � Z d � Z d � Z d � Z e d � Z d � Z d � Z d � Z RS( s� 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. t valuet ttypet parentt normalizedt is_keywordt is_groupt is_whitespacec C sy t | � } | | _ | | _ d | _ t | _ | t j k | _ | j t j k | _ | j rl | j � n | | _ d S( N( R R$ R% R R& t FalseR) R R R( R R* t upperR' ( R R% R$ ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt __init__6 s c C s | j S( N( R$ ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt __str__@ s c C s^ | j � } | j � } | j d � r< | j d � r< d n d } d j d t | � t � � S( Nt 'u "u 'u" <{cls} {q}{value}{q} at 0x{id:2X}>t id( t _get_repr_namet _get_repr_valuet startswitht endswitht formatR0 t locals( R t clsR$ t q( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt __repr__G s * c C s t | j � j d � d S( NR i����( t strR% t split( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR1 O s c C sB t | � } t | � d k r/ | d d } n t j d d | � S( Ni i s ...s \s+t ( R R t ret sub( R t raw( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR2 R s c c s | Vd S( s Resolve subgroups.N( ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt flattenX s c s� | j | k } | s" | d k r& | St | t � rA | f } n | r� | j rY t j n d � � f d � | D� } x$ | D] } | j | j � r| t Sq| Wt S| j r� d � | D� } n | j | k S( s, 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. i c 3 s! | ] } t j | � � Vq d S( N( R= t compile( t .0t v( t flag( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pys <genexpr>r s c s s | ] } | j � Vq d S( N( R, ( RB RC ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pys <genexpr>z s N( R% R t isinstanceR R( R= t IGNORECASEt searchR' R R+ ( R R% t valuest regext type_matchedt pattern( ( RD sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt match\ s c C s6 | j } x& | r1 t | | � r% t S| j } q Wt S( s� 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)``. ( R& RE R R+ ( R t group_clsR& ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt within~ s c C s | j | k S( s< Returns ``True`` if this token is a direct child of *other*.( R& ( R t other( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt is_child_of� s c C s3 | j } x# | r. | | k r" t S| j } q Wt S( s7 Returns ``True`` if *other* is in this tokens ancestry.( R& R R+ ( R RO R& ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt has_ancestor� s ( R$ R% R& R' R( R) R* ( R R! R" t __slots__R- R. R9 R1 R2 R@ R+ RL RN RP RQ ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR# * s " t TokenListc B sa e Z d Z d Z d d � Z d � Z d � Z d � Z d � Z d d d d d � Z d � Z d � Z d � Z e d � � Z d d e d � Z e e d � Z d d d d d d � Z d � Z d � Z e e d � Z e e e d � Z d d � Z e e d � Z d � Z e d � Z d � Z d � Z d � Z d � Z d � Z! d e e e d � Z" RS(! sw A group of tokens. It has an additional instance attribute ``tokens`` which holds a list of child-tokens. R c C sa | p g | _ g | j D] } t | d | � ^ q t t | � j d t | � � t | _ d S( NR& ( R t setattrt superRS R- R R R R) ( R R t token( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR- � s & c C s d j d � | j � D� � S( Nu c s s | ] } | j Vq d S( N( R$ ( RB RV ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pys <genexpr>� s ( t joinR@ ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR. � s c C s t | j � S( N( t iterR ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt __iter__� s c C s | j | S( N( R ( R t item( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt __getitem__� s c C s t | � j S( N( t typeR ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR1 � s i t c C s t | j � } x� t | j � D]� \ } } | j � } | j � } | | d k } | r_ d n d } | j d � r� | j d � r� d n d } t d j t � � d | �| j r | d k s� | | k r | r� d n d } | j | | d | | | � q q Wd S( s Pretty-print the object tree.i u `- u |- R/ u "u 'u$ {_pre}{pre}{idx} {cls} {q}{value}{q}t fileu u | N( R R t enumerateR1 R2 R3 R4 t printR5 R6 R) R t _pprint_tree( R t max_deptht deptht ft _pret token_countt idxRV R7 R$ t lastt preR8 t parent_pre( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyRa � s * !c C sZ d } xM | j � D]? } | t | j � } | | k oC | k n rL | S| } q Wd S( s- Returns the token that is on position offset.i N( R@ R R$ ( R t offsetRg RV t end( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_token_at_offset� s c c sE x> | j D]3 } | j r8 x! | j � D] } | Vq& Wq | Vq Wd S( sn Generator yielding ungrouped tokens. This method is recursively called for all child tokens. N( R R) R@ ( R RV RZ ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR@ � s c c s) x" | j D] } | j r | Vq q Wd S( N( R R) ( R RV ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_sublists� s c C s | j S( N( R ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt _groupable_tokens� s c C s� | d k r d St | t t f � s1 | f } n | r� | d k sI t � x� t | d d d � D]: } | j | } x$ | D] } | | � rz | | f Sqz Wq` WnT xQ t | j | | !d | �D]3 \ } } x$ | D] } | | � r� | | f Sq� Wq� Wd S( s next token that match functionsi i����t startN( NN( R RE t listt tuplet AssertionErrort rangeR R_ ( R t funcsRp Rl R Rg RV t func( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt _token_matching� s ) c s# � � f d � } | j | � d S( s� 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 | d t j d t � S( NR t i( R* R R t Comment( t tk( t skip_cmt skip_ws( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt matcher s i ( Rw ( R R| R{ R} ( ( R{ R| sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt token_first� s i����c s, | d 7} | j � � � f d � | | � S( Ni c s t | � � � � S( N( R ( Rz ( Rx R R ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt <lambda> R] ( Rw ( R Rx R R Rg Rl ( ( Rx R R sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR s c sV t | t t f � s | f n | } g | D] � � f d � ^ q+ } | j | | � S( Nc s � | � S( N( ( Rz ( Rv ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR R] ( RE Rq Rr Rw ( R Ru Rg ( ( Rv sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt token_not_matching s $"c C s | j | | � d S( Ni ( Rw ( R Ru Rg ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt token_matching s c C s | j | | | d t �S( s� 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( t token_nextR ( R Rg R| R{ ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt token_prev s c sB | d k r d S| d 7} � � f d � } | j | | d | �S( s� 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. i c s/ � r | j p- � o- t | d t j d t � S( NR Rx ( R* R R Ry ( Rz ( R{ R| ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR} / s R N( NN( R Rw ( R Rg R| R{ R� R} ( ( R{ R| sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� $ s c C s< t | t � r | n | j | � } | | j | j | � S( s Return list index of token.( RE t intt token_indexR t index( R RV Rp ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� 4 s $c C s� | } | j | } | | } | r t | | � r | j | d | !} | } | j j | � | j | d | 5t | � | _ n8 | j | | !} | | � } | g | j | | +| | _ x | D] } | | _ q� W| S( s+ Replace tokens by an instance of *grp_cls*.i ( R RE t extendR R$ R& ( R t grp_clsRp Rl t include_endR� t start_idxt end_idxt subtokenst grpRV ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt group_tokens9 s c C sA t | t � s! | j | � } n | | _ | j j | | � d S( s Inserts *token* before *where*.N( RE R� R� R& R t insert( R t whereRV ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt insert_beforeW s c C s{ t | t � s! | j | � } n | j | d | �\ } } | | _ | d k rd | j j | � n | j j | | � d S( s Inserts *token* after *where*.R| N( RE R� R� R� R& R R t appendR� ( R R� RV R| t nidxt next_( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt insert_after^ s c C s | j � d k S( s( Returns ``True`` if an alias is present.N( R R ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt has_aliasi s c C s d S( s2 Returns the alias for this identifier or ``None``.N( R ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR m s c C s | j � p | j � S( s 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 ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_nameq s c C s d S( s7 Returns the real name (object name) of this identifier.N( R ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR z s c C sS | j d t j d f � \ } } | j | � \ } } | d k rO t | j � Sd S( st Return 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 R t prev_( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_parent_name~ s !c C s� | r | j | n | j } | r. t | � n | } t j t j t j j g } | rh | j t j � n xY | D]Q } | j | k r� t | j � St | t t f � ro | r� | j � S| j � Sqo Wd S( s/ Returns the name of the first token with a nameN( R t reversedR t Namet Wildcardt Stringt SymbolR� R R% R R$ RE t Identifiert FunctionR R� ( R Rg R R R R t typesRV ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR � s N(# R R! R" RR R R- R. RY R[ R1 Ra Rm R@ Rn t propertyRo R+ Rw R R~ R R� R� R� R� R� R� R� R� R� R R� R R� R ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyRS � s> t Statementc B s e Z d Z d � Z RS( s Represents a SQL statement.c C s� | j d t � } | d k r" d S| j t j j t j j f k rJ | j S| j t j j k r� | j | � } | j | d t �\ } } t | t t f � r� | j | d t �\ } } | d k r� | j t j j k r� | j Sq� n d S( sM 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. R{ t UNKNOWNR| N( R~ R R R% R R t DMLt DDLR' t CTER� R� RE R� t IdentifierList( R t first_tokent fidxt tidxRV R t dml_keyword( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_type� s ! ( R R! R" R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� � s R� c B s2 e Z d Z d � Z d � Z d � Z d � Z RS( sN Represents an identifier. Identifiers may have aliases or typecasts. c C s% | j d t j � \ } } | d k S( s7 Return ``True`` if this identifier contains a wildcard.R N( R R R� R ( R R RV ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt is_wildcard� s c C sM | j d t j d f � \ } } | j | d t �\ } } | rI | j Sd S( s< Returns the typecast or ``None`` of this object as a string.R s ::R| N( R R R R� R+ R$ R ( R t midxt markerR� R� ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_typecast� s !c C s/ | j d t j j � \ } } | r+ | j Sd S( s5 Returns the ordering or ``None`` as uppercase string.R N( R R R t OrderR' R ( R R t ordering( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_ordering� s c c s9 x2 | j D]' } t | t � r | j d d !Vq q Wd S( s( Returns an iterator of index token listsi i����N( R RE t SquareBrackets( R RV ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_array_indices� s ( R R! R" R� R� R� R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� � s R� c B s e Z d Z d � Z RS( s. A list of :class:`~sqlparse.sql.Identifier`'s.c c s> x7 | j D], } | j p+ | j t j d � s | Vq q Wd S( sk Returns the identifiers. Whitespaces and punctuations are not included in this generator. t ,N( R R* RL R R ( R RV ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_identifiers� s ( R R! R" R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� � s t TypedLiteralc B sP e Z d Z e j j d f e j d f g Z e j j d f Z e j d f Z RS( sE A typed literal, such as "date '2001-09-28'" or "interval '2 hours'".t TIMESTAMPt DAYt HOURt MINUTEt MONTHt SECONDt YEARN( R� R� R� R� R� R� ( R R! R" R R� t BuiltinR R t M_OPENR� t Singlet M_CLOSEt M_EXTEND( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� � s !t Parenthesisc B s; e Z d Z e j d f Z e j d f Z e d � � Z RS( s Tokens between parenthesis.t (t )c C s | j d d !S( Ni i����( R ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyRo � s ( R R! R" R R R� R� R� Ro ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� � s R� c B s; e Z d Z e j d f Z e j d f Z e d � � Z RS( s Tokens between square bracketst [t ]c C s | j d d !S( Ni i����( R ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyRo s ( R R! R" R R R� R� R� Ro ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� � s t Assignmentc B s e Z d Z RS( s An assignment like 'var := val;'( R R! R" ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� s t Ifc B s, e Z d Z e j d f Z e j d f Z RS( s7 An 'if' clause with possible 'else if' or 'else' parts.t IFs END IF( R R! R" R R R� R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� s t Forc B s, e Z d Z e j d f Z e j d f Z RS( s A 'FOR' loop.t FORt FOREACHs END LOOP( R� R� ( R R! R" R R R� R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� s t Comparisonc B s, e Z d Z e d � � Z e d � � Z RS( s/ A comparison used for example in WHERE clauses.c C s | j d S( Ni ( R ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt left s c C s | j d S( Ni����( R ( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt right s ( R R! R" R� R� R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� s Ry c B s e Z d Z d � Z RS( s A comment.c C s# | j o" | j d j t j j k S( Ni ( R R% R Ry t Multiline( R ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt is_multiline& s ( R R! R" R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyRy # s t Wherec B s, e Z d Z e j d f Z e j d f Z RS( s A WHERE clause.t WHEREs ORDER BYs GROUP BYt LIMITt UNIONs UNION ALLt EXCEPTt HAVINGt RETURNINGt INTO( s ORDER BYs GROUP BYR� R� s UNION ALLR� R� R� R� ( R R! R" R R R� R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� * s t Havingc B s, e Z d Z e j d f Z e j d f Z RS( s A HAVING clause.R� s ORDER BYR� ( s ORDER BYR� ( R R! R" R R R� R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� 2 s t Casec B s8 e Z d Z e j d f Z e j d f Z e d � Z RS( sA A CASE statement with one or more WHEN and possibly an ELSE part.t CASEt ENDc C sr d } d } g } | } xS| j D]H} | j t j d � rC q" n� | ra | j t j k ra q" n� | j t j d � r� | j g g f � | } nm | j t j d � r� | } nO | j t j d � r� | j d g f � | } n | j t j d � r� d } n | r"| r"| j g g f � n | | k rF| d d j | � q" | | k r" | d d j | � q" q" W| S( se Returns a list of 2-tuples (condition, value). If an ELSE exists condition is None. i i R� t WHENt THENt ELSER� i����i N( R RL R R R% R R� R ( R R| t CONDITIONt VALUEt rett modeRV ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_cases= s4 ( R R! R" R R R� R� R+ R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� 8 s R� c B s e Z d Z d � Z RS( s A function or procedure call.c C sf | j d } xR | j D]G } t | t � r6 | j � St | d t t f d t j �r | g Sq Wg S( s Return a list of parameters.i����Rx R ( R RE R� R� R R� R� R t Literal( R t parenthesisRV ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt get_parametersp s ! ( R R! R" R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� m s t Beginc B s, e Z d Z e j d f Z e j d f Z RS( s A BEGIN/END block.t BEGINR� ( R R! R" R R R� R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� { s t Operationc B s e Z d Z RS( s Grouping of operations( R R! R" ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� � s t Valuesc B s e Z d Z RS( s Grouping of values( R R! R" ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� � s t Commandc B s e Z d Z RS( s Grouping of CLI commands.( R R! R" ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyR� � s (% R" t __future__R R= t sqlparseR R t sqlparse.compatR R R t sqlparse.utilsR R R t objectR# RS R� R� R� R� R� R� R� R� R� R� Ry R� R� R� R� R� R� R� R� ( ( ( sO /opt/cpanel-ccs/.develop/virtualenv/lib/python2.7/site-packages/sqlparse/sql.pyt <module> s: n�' 5