a
    lcg                     @   s  d Z ddlZddlmZmZmZmZmZ ddlm	Z	m
Z
mZmZmZmZmZmZmZmZmZ ddlmZmZ ddlmZmZmZmZ ddlmZmZmZm Z m!Z! ddlm"Z" g d	Z#e$d
Z%e$dZ&e$dej'Z(e$dej'Z)e$dZ*e$dZ+e$dej'Z,e$dej'Z-e$dZ.dd Z/G dd dZ0G dd de0eZ1G dd de0eZ2G dd de0eZ3e$dZ4e$dZ5e$dZ6e$d Z5e$d!Z7e$d"Z8G d#d$ d$Z9G d%d& d&eZ:G d'd( d(eZ;G d)d* d*eZ<G d+d, d,eZ=G d-d. d.eZ>G d/d0 d0eZ?dS )1a  
    pygments.lexers.sql
    ~~~~~~~~~~~~~~~~~~~

    Lexers for various SQL dialects and related interactive sessions.

    Postgres specific lexers:

    `PostgresLexer`
        A SQL lexer for the PostgreSQL dialect. Differences w.r.t. the SQL
        lexer are:

        - keywords and data types list parsed from the PG docs (run the
          `_postgres_builtins` module to update them);
        - Content of $-strings parsed using a specific lexer, e.g. the content
          of a PL/Python function is parsed using the Python lexer;
        - parse PG specific constructs: E-strings, $-strings, U&-strings,
          different operators and punctuation.

    `PlPgsqlLexer`
        A lexer for the PL/pgSQL language. Adds a few specific construct on
        top of the PG SQL lexer (such as <<label>>).

    `PostgresConsoleLexer`
        A lexer to highlight an interactive psql session:

        - identifies the prompt and does its best to detect the end of command
          in multiline statement where not all the lines are prefixed by a
          prompt, telling them apart from the output;
        - highlights errors in the output and notification levels;
        - handles psql backslash commands.

    The ``tests/examplefiles`` contains a few test files with data to be
    parsed by these lexers.

    :copyright: Copyright 2006-2022 by the Pygments team, see AUTHORS.
    :license: BSD, see LICENSE for details.
    N)Lexer
RegexLexerdo_insertionsbygroupswords)Punctuation
WhitespaceTextCommentOperatorKeywordNameStringNumberGenericLiteral)get_lexer_by_nameClassNotFound)KEYWORDS	DATATYPESPSEUDO_TYPESPLPGSQL_KEYWORDS)MYSQL_CONSTANTSMYSQL_DATATYPESMYSQL_FUNCTIONSMYSQL_KEYWORDSMYSQL_OPTIMIZER_HINTS)_tsql_builtins)PostgresLexerPlPgsqlLexerPostgresConsoleLexerSqlLexerTransactSqlLexer
MySqlLexerSqliteConsoleLexerRqlLexerz.*?
z^(?:sqlite|   ...)>(?= )z\s+LANGUAGE\s+'?(\w+)'?z\bDO\bz\[[a-zA-Z_]\w*\]z`[a-zA-Z_]\w*`z\bgo\bz\bdeclare\s+@z@[a-zA-Z_]\w*\bc                 c   s  d}t | j| | d  }|dur>| |d}n|tt | jtd|	 d |	  }|r| |d d}n8tt
| jtd|	 d |	  }|r| d}|	dt|dfV  |	dtj|dfV  |	d	t|d	fV  |r"||d
E dH  n|	d
t|d
fV  |	dt|dfV  |	dtj|dfV  |	dt|dfV  dS )zParse the content of a $-string using a lexer

    The lexer is chosen looking for a nearby LANGUAGE or assumed as
    plpgsql if inside a DO statement and no LANGUAGE has been found.
    Nd      r      plpgsql                  )language_rematchtextend
_get_lexergrouplistfinditermaxstartdo_rer   	Delimiterget_tokens_unprocessed)lexerr2   lxm rA   O/var/www/html/django/DPS/env/lib/python3.9/site-packages/pygments/lexers/sql.pylanguage_callbackN   s.     
rC   c                       s(   e Zd ZdZ fddZdd Z  ZS )PostgresBasea  Base class for Postgres-related lexers.

    This is implemented as a mixin to avoid the Lexer metaclass kicking in.
    this way the different lexer don't have a common Lexer ancestor. If they
    had, _tokens could be created on this ancestor and not updated for the
    other classes, resulting e.g. in PL/pgSQL parsed as SQL. This shortcoming
    seem to suggest that regexp lexers are not really subclassable.
    c                 '   s$   || _ t j|g|R  E d H  d S N)r3   superr=   )selfr3   args	__class__rA   rB   r=   {   s    z#PostgresBase.get_tokens_unprocessedc              	   C   s   |  dkrtdi | jS |g}|dr>||dd   |drZ||d d  |dr|dr||dd  |D ]0}zt|fi | jW   S  ty   Y q0 qd S )Nsql
postgresqlplr+   ur(   )rL   )lowerr   options
startswithappendendswithr   )rG   langtriesr?   rA   rA   rB   r5      s    

zPostgresBase._get_lexer)__name__
__module____qualname____doc__r=   r5   __classcell__rA   rA   rI   rB   rD   r   s   rD   c                   @   s:  e Zd ZdZdZddgZdgZejZ	de
fdejfdejd	fd
ddd ee D  d ejfeeddefdefdefdejfdejfdejfdeejejdfdeejejdfdefdefdejfdefgdejd	fdejdfd ejfd!ejfgd"ejfd#ejfd$ejdfgd%ejfd&ejfd'ejdfgd(Z d)S )*r   zM
    Lexer for the PostgreSQL dialect of SQL.

    .. versionadded:: 1.5
    zPostgreSQL SQL dialectrL   postgresztext/x-postgresql\s+--.*\n?/\*multiline-comments(|c                 c   s   | ]}| d dV  qdS ) r\   N)replace).0srA   rA   rB   	<genexpr>   s   zPostgresLexer.<genexpr>z)\b\bsuffixz[+*/<>=~!@#%^&|`?-]+z::z\$\d+z&([0-9]*\.[0-9]*|[0-9]+)(e[+-]?[0-9]+)?[0-9]+z((?:E|U&)?)(')stringz((?:U&)?)(")quoted-identz$(?s)(\$)([^$]*)(\$)(.*?)(\$)(\2)(\$)z	[a-z_]\w*:(['"]?)[a-z]\w*\b\1z[;:()\[\]{},.]\*/#pop[^/*]+[/*][^']+'''[^"]+""")rootr_   rk   rl   N)!rV   rW   rX   rY   namealiases	mimetypesre
IGNORECASEflagsr   r
   Single	Multilinejoinr   r   r   Builtinr   r   r   r   Variabler   FloatIntegerr   r   AffixrC   r   tokensrA   rA   rA   rB   r      sT   




r   c                   @   s   e Zd ZdZdZdgZdgZejZ	dd e
j D Zeed D ]6\ZZed ekrBeee d	d
efed e< [ qqBdsJ ddejfdefdejfdejfged dd< dS )r   zR
    Handle the extra syntax in Pl/pgSQL language.

    .. versionadded:: 1.5
    zPL/pgSQLr*   ztext/x-plpgsqlc                 C   s   i | ]\}}||d d  qS rE   rA   rd   klrA   rA   rB   
<dictcomp>       zPlPgsqlLexer.<dictcomp>rx   r'   rg   rh   r   zSQL keywords not foundz\%[a-z]\w*\bz:=z\<\<[a-z]\w*\>\>z\#[a-z]\w*\bN)rV   rW   rX   rY   ry   rz   r{   r|   r}   r~   r   r   items	enumerateipatternr   r   r   r   r   r   r   LabelPseudorA   rA   rA   rB   r      s&   r   c                   @   s   e Zd ZdZdZg ZejZdd e	j
 D Z
e
d dejdf dedfd	efdejfd
ejfdejfdejfdejfge
d< dS )PsqlRegexLexerz
    Extend the PostgresLexer adding support specific for psql commands.

    This is not a complete psql lexer yet as it lacks prompt support
    and output rendering.
    z'PostgreSQL console - regexp based lexerc                 C   s   i | ]\}}||d d  qS rE   rA   r   rA   rA   rB   r      r   zPsqlRegexLexer.<dictcomp>rx   z\\[^\s]+zpsql-commandz\nr\   rm   '(''|[^'])*'z	`([^`])*`z[^\s]+N)rV   rW   rX   rY   ry   rz   r|   r}   r~   r   r   r   rR   r   r   r	   r   r   r   r   r   BacktickSymbolrA   rA   rA   rB   r      s    
r   z^(\S.*?)??[=\-\(\$\'\"][#>]z\s*\\z;\s*(--.*?)?$z(\s*)(\\.+?)(\s+)$z(ERROR|FATAL):zS((?:DEBUG|INFO|NOTICE|WARNING|ERROR|FATAL|HINT|DETAIL|CONTEXT|LINE [0-9]+):)(.*?\n)c                   @   s4   e Zd ZdZdd Zdd Zdd Zdd	 ZeZd
S )	lookaheadz0Wrap an iterator and allow pushing back an item.c                 C   s   t || _ d | _d S rE   )iter	_nextitem)rG   xrA   rA   rB   __init__  s    
zlookahead.__init__c                 C   s   | S rE   rA   )rG   rA   rA   rB   __iter__  s    zlookahead.__iter__c                 C   s
   || _ |S rE   )r   )rG   r   rA   rA   rB   send  s    zlookahead.sendc                 C   s$   | j d ur| j }d | _ |S t| jS rE   )r   nextr   )rG   nirA   rA   rB   __next__"  s
    
zlookahead.__next__N)	rV   rW   rX   rY   r   r   r   r   r   rA   rA   rA   rB   r     s   r   c                   @   s*   e Zd ZdZdZg dZdgZdd ZdS )r    z=
    Lexer for psql sessions.

    .. versionadded:: 1.5
    zPostgreSQL console (psql))psqlzpostgresql-consolezpostgres-consoleztext/x-postgresql-psqlc                 c   s  t f i | j}tt|}d}g }|D ]}|dr`|s`td	i | j}||E d H   qt	|}|d ur|
t|dtj| fgf ||t| d  7 }n||7 }t	|st|r* qq*t|||E d H  tj}	|D ]}t	|}|d ur||  qt	|}
|
d ur|
ddsL|
ddrRtj}	|
dtj|
dfV  |
d|	|
dfV  qd|	|fV  qd S qd S )
N $consoler   r'   ERRORFATALr+   )r   )r   rP   r   line_refindallrQ   r   r=   	re_promptr2   rR   lenr   Promptr6   re_psql_commandre_end_commandsearchr   Outputr   
re_messageErrorr:   Strong)rG   datarK   linescurcode
insertionsliner>   ZmpromptZ	out_tokenZmmsgrA   rA   rB   r=   6  sN    








z+PostgresConsoleLexer.get_tokens_unprocessedN)rV   rW   rX   rY   ry   rz   r{   r=   rA   rA   rA   rB   r    +  s
   r    c                   @   s   e Zd ZdZdZdgZdgZdgZej	Z
defdejfdejd	fed
ddefedddejfdefdejfdejfdejfdefdefgdejd	fdejdfdejfdejfgdZdd ZdS )r!   z
    Lexer for Structured Query Language. Currently, this lexer does
    not recognize any special syntax except ANSI SQL.
    SQLrK   *.sqlz
text/x-sqlr\   r]   r^   r_   (  ZABORTZABSZABSOLUTEZACCESSZADAZADDZADMINZAFTERZ	AGGREGATEZALIASALLZALLOCATEZALTERZANALYSEZANALYZEANDANYZAREZASASCZ
ASENSITIVEZ	ASSERTIONZ
ASSIGNMENTZ
ASYMMETRICATZATOMICZAUTHORIZATIONZAVGZBACKWARDZBEFOREZBEGINZBETWEENZBITVARZ
BIT_LENGTHZBOTHZBREADTHZBYCZCACHECALLZCALLEDZCARDINALITYZCASCADEZCASCADEDZCASEZCASTZCATALOGZCATALOG_NAMEZCHAINZCHARACTERISTICSZCHARACTER_LENGTHZCHARACTER_SET_CATALOGZCHARACTER_SET_NAMEZCHARACTER_SET_SCHEMAZCHAR_LENGTHZCHECKZCHECKED
CHECKPOINTZCLASSZCLASS_ORIGINZCLOBZCLOSEZCLUSTERZCOALESCECOBOLZCOLLATEZ	COLLATIONZCOLLATION_CATALOGZCOLLATION_NAMEZCOLLATION_SCHEMAZCOLUMNZCOLUMN_NAMEZCOMMAND_FUNCTIONZCOMMAND_FUNCTION_CODECOMMENTZCOMMITZ	COMMITTEDZ
COMPLETIONZCONDITION_NUMBERZCONNECTZ
CONNECTIONZCONNECTION_NAMEZ
CONSTRAINTZCONSTRAINTSZCONSTRAINT_CATALOGZCONSTRAINT_NAMEZCONSTRAINT_SCHEMAZCONSTRUCTORZCONTAINSCONTINUEZ
CONVERSIONZCONVERTCOPYZCORRESPONDINGZCOUNTZCREATEZCREATEDBZ
CREATEUSERZCROSSZCUBEZCURRENTZCURRENT_DATEZCURRENT_PATHZCURRENT_ROLEZCURRENT_TIMEZCURRENT_TIMESTAMPZCURRENT_USERZCURSORZCURSOR_NAMEZCYCLEZDATAZDATABASEZDATETIME_INTERVAL_CODEZDATETIME_INTERVAL_PRECISIONZDAYZ
DEALLOCATEZDECLAREDEFAULTZDEFAULTSZ
DEFERRABLEZDEFERREDZDEFINEDZDEFINERDELETEZ	DELIMITERZ
DELIMITERSZDEREFZDESCZDESCRIBEZ
DESCRIPTORZDESTROYZ
DESTRUCTORZDETERMINISTICZDIAGNOSTICSZ
DICTIONARYZ
DISCONNECTZDISPATCHZDISTINCTZDOZDOMAINZDROPZDYNAMICZDYNAMIC_FUNCTIONZDYNAMIC_FUNCTION_CODEZEACHELSEZELSIFENCODING	ENCRYPTEDZENDzEND-EXECZEQUALSESCAPEZEVERYZ	EXCEPTIONZEXCEPTZ	EXCLUDINGZ	EXCLUSIVEZEXECZEXECUTEZEXISTINGZEXISTSZEXPLAINZEXTERNALZEXTRACTFALSEZFETCHZFINALZFIRSTZFORZFORCEZFOREIGNZFORTRANZFORWARDFOUNDZFREEZFREEZEZFROMZFULLZFUNCTIONGZGENERALZ	GENERATEDGETGLOBALZGOZGOTOZGRANTZGRANTEDZGROUPZGROUPINGZHANDLERZHAVINGZ	HIERARCHYZHOLDZHOSTZIDENTITYZIFZIGNOREZILIKEZ	IMMEDIATEZIMMEDIATELYZ	IMMUTABLEZIMPLEMENTATIONZIMPLICITINZ	INCLUDINGZ	INCREMENTZINDEXZ
INDITCATORZINFIXZINHERITSZ
INITIALIZEZ	INITIALLYZINNERZINOUTZINPUTZINSENSITIVEZINSERTZINSTANTIABLEZINSTEADZ	INTERSECTZINTOZINVOKERZISZISNULLZ	ISOLATIONZITERATEZJOINZKEYZ
KEY_MEMBERZKEY_TYPEZLANCOMPILERLANGUAGEZLARGEZLASTZLATERALZLEADINGLEFTZLENGTHLESSZLEVELZLIKEZLIMITZLISTENZLOADZLOCALZ	LOCALTIMEZLOCALTIMESTAMPZLOCATIONZLOCATORZLOCKZLOWERZMAPMATCHMAXZMAXVALUEZMESSAGE_LENGTHZMESSAGE_OCTET_LENGTHZMESSAGE_TEXTZMETHODZMINZMINUTEZMINVALUEZMODZMODEZMODIFIESZMODIFYZMONTHZMOREZMOVEZMUMPSZNAMESZNATIONALZNATURALZNCHARZNCLOBZNEWZNEXTNOZ
NOCREATEDBZNOCREATEUSERNONENOTZNOTHINGZNOTIFYZNOTNULLZNULLZNULLABLEZNULLIFZOBJECTZOCTET_LENGTHZOFZOFFZOFFSETZOIDSZOLDONZONLYZOPENZ	OPERATIONZOPERATORZOPTIONOPTIONSORZORDERZ
ORDINALITYZOUTZOUTERZOUTPUTZOVERLAPSZOVERLAYZ
OVERRIDINGZOWNERZPADZ	PARAMETERZ
PARAMETERSZPARAMETER_MODEZPARAMETER_NAMEZPARAMETER_ORDINAL_POSITIONZPARAMETER_SPECIFIC_CATALOGZPARAMETER_SPECIFIC_NAMEZPARAMETER_SPECIFIC_SCHEMAPARTIALZPASCALZPENDANTZPERIODZPLACINGZPLIZPOSITIONZPOSTFIXZPRECEEDSZ	PRECISIONPREFIXZPREORDERZPREPAREZPRESERVEZPRIMARYZPRIORZ
PRIVILEGESZ
PROCEDURALZ	PROCEDUREZPUBLICREADZREADSZRECHECKZ	RECURSIVEZREFZ
REFERENCESZREFERENCINGZREINDEXZRELATIVEZRENAMEZ
REPEATABLEZREPLACERESETZRESTARTZRESTRICTZRESULTZRETURNZRETURNED_LENGTHZRETURNED_OCTET_LENGTHZRETURNED_SQLSTATEZRETURNSZREVOKERIGHTZROLEZROLLBACKZROLLUPZROUTINEZROUTINE_CATALOGZROUTINE_NAMEZROUTINE_SCHEMAZROWZROWSZ	ROW_COUNTZRULEZ
SAVE_POINTZSCALEZSCHEMAZSCHEMA_NAMEZSCOPEZSCROLLZSEARCHZSECONDZSECURITYZSELECTZSELFZ	SENSITIVEZSERIALIZABLEZSERVER_NAMEZSESSIONZSESSION_USERZSETZSETOFZSETSZSHAREZSHOWZSIMILARSIMPLEZSIZEZSOMEZSOURCESPACEZSPECIFICZSPECIFICTYPEZSPECIFIC_NAMEr   ZSQLCODEZSQLERRORZSQLEXCEPTIONZSQLSTATEZSQLWARNINIGZSTABLESTARTZSTATEZ	STATEMENTZSTATICZ
STATISTICSZSTDINSTDOUTZSTORAGEZSTRICTZ	STRUCTUREZSTYPEZSUBCLASS_ORIGINZSUBLISTZ	SUBSTRINGZSUCCEEDSZSUMZ	SYMMETRICZSYSIDZSYSTEMZSYSTEM_USERZTABLEZ
TABLE_NAMEz TEMPTEMPLATE	TEMPORARYZ	TERMINATEZTHANZTHENZTIME	TIMESTAMPZTIMEZONE_HOURZTIMEZONE_MINUTEZTOZTOASTZTRAILINGZTRANSACTIONZTRANSACTIONS_COMMITTEDZTRANSACTIONS_ROLLED_BACKZTRANSACTION_ACTIVEZ	TRANSFORMZ
TRANSFORMSZ	TRANSLATEZTRANSLATIONZTREATZTRIGGERZTRIGGER_CATALOGZTRIGGER_NAMEZTRIGGER_SCHEMAZTRIMTRUEZTRUNCATEZTRUSTEDZTYPEZUNCOMMITTEDZUNDERZUNENCRYPTEDZUNIONZUNIQUEUNKNOWNZUNLISTENZUNNAMEDZUNNESTZUNTILZUPDATEZUPPERUSAGEUSERZUSER_DEFINED_TYPE_CATALOGZUSER_DEFINED_TYPE_NAMEZUSER_DEFINED_TYPE_SCHEMAZUSINGZVACUUMZVALIDZ	VALIDATORZVALUESVARIABLEVERBOSEVERSIONVERSIONSZ
VERSIONINGZVIEWZVOLATILEZWHENZWHENEVERZWHEREZWITHZWITHOUTZWORKWRITEZYEARZZONErg   rh   )ZARRAYZBIGINTBINARYZBITZBLOBZBOOLEANZCHARZ	CHARACTERZDATEZDECZDECIMALFLOATINTZINTEGERZINTERVALNUMBERZNUMERICZREALZSERIALZSMALLINTZVARCHARZVARYINGZINT8ZSERIAL8ZTEXTz[+*/<>=~!@#%^&|`?-]rj   r   "(""|[^"])*"z[a-z_][\w$]*[;:()\[\],.]rn   ro   rp   rq   rx   r_   c                 C   s   d S rE   rA   )rG   r3   rA   rA   rB   analyse_text  s    zSqlLexer.analyse_textN)rV   rW   rX   rY   ry   rz   	filenamesr{   r|   r}   r~   r   r
   r   r   r   r   r   r   r   r   r   r   r   r   r   r   rA   rA   rA   rB   r!   s  sB   
WXYl

tr!   c                   @   sX  e Zd ZdZdZddgZdgZdgZej	Z
defdejfd	ejd
feejefeejddejfeejddejfeejddejfdeeeejfeejddefdeeeefdejfdej fdej fdej fdej!fde"jfde"j#fde$fdej%fdej&fdeeje$fdefdej&j'fgd	ejd
fdejdfdejfdejfgd Z(d!d" Z)d#S )$r"   z
    Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to
    SQL.

    The list of keywords includes ODBC and keywords reserved for future use..
    zTransact-SQLtsqlzt-sqlr   ztext/x-tsqlr\   z	--.*?$\n?r^   r_   rg   rh   z(goto)(\s+)(\w+\b)z(\[)([^]]+)(\])0x[0-9a-f]+[0-9]+\.[0-9]*(e[+-]?[0-9]+)?z\.[0-9]+(e[+-]?[0-9]+)?[0-9]+e[+-]?[0-9]+rj   r   r   z[;(),.]z@@\w+z@\w+z(\w+)(:)z#?#?\w+\?rn   ro   rp   rq   r   c                 C   s   d}t | rd}ntt| }tt| }|| }|dkrV|d| krV|d7 }n"||krh|d7 }n|dkrx|d7 }t| d ur|d7 }t| d ur|d7 }|S )Nr   g      ?r'   r+         ?皙?皙?)tsql_declare_rer   r   name_between_backtick_rer   name_between_bracket_retsql_variable_re
tsql_go_rer3   ZratingZname_between_backtick_countZname_between_bracket_countZdialect_name_countrA   rA   rB   r   .  s.    



zTransactSqlLexer.analyse_textN)*rV   rW   rX   rY   ry   rz   r   r{   r|   r}   r~   r   r
   r   r   r   r   Z	OPERATORSr   ZOPERATOR_WORDSWordTYPESr   ClassZ	FUNCTIONSFunctionr   r   r   r   r   Hexr   r   r   r   r   r   r   Magicr   r   rA   rA   rA   rB   r"     sJ   

 

(r"   c                "   @   s  e Zd ZdZdZdgZdgZejZ	de
fdejfdejdfd	ejd
fdejfdejfdejfdejfdejfdejfdejfdejfdejfdejfdejfdejdfdejdfdejfdejfdejdfdejdfd ejd!fd"ejfd#efd$efd%eee
efeed&d&d'ejfee d&d&d'ej!fee"d&d&d'efee#d&d(d'eej$e
e%fd)efd*ej&d+fd,e%fg!d-ejfd.ejd/fee'd&d0ej(fd1ejfd2ejfgd3ejfd.ejd/fd2ejfgd4ejfd5ej)fd6ej)fdejd/fgd7ejfd8ej)fd6ej)fdejd/fgd9ejfd5ejfdejd/fgd:ejfd8ejfdejd/fgd;ejfd<ejfd*ejd/fgd;ej&fd<ej&j)fd*ej&d/fgd=	Z*d>d? Z+d@S )Ar#   a5  The Oracle MySQL lexer.

    This lexer does not attempt to maintain strict compatibility with
    MariaDB syntax or keywords. Although MySQL and MariaDB's common code
    history suggests there may be significant overlap between the two,
    compatibility between the two is not a target for this lexer.
    MySQLmysqlztext/x-mysqlr\   z(?:#|--\s+).*z/\*\+optimizer-hintsr^   multiline-commentzx'([0-9a-f]{2})+'r   zb'[01]+'z0b[01]+r   z[0-9]*\.[0-9]+(e[+-]?[0-9]+)?r   z"[0-9]+(?=[^0-9a-z$_\u0080-\uffff])zI\{\s*d\s*(?P<quote>['\"])\s*\d{2}(\d{2})?.?\d{2}.?\d{2}\s*(?P=quote)\s*\}zZ\{\s*t\s*(?P<quote>['\"])\s*(?:\d+\s+)?\d{1,2}.?\d{1,2}.?\d{1,2}(\.\d*)?\s*(?P=quote)\s*\}zp\{\s*ts\s*(?P<quote>['\"])\s*\d{2}(?:\d{2})?.?\d{2}.?\d{2}\s+\d{1,2}.?\d{1,2}.?\d{1,2}(\.\d*)?\s*(?P=quote)\s*\}rt   single-quoted-stringrw   double-quoted-stringz9@@(?:global\.|persist\.|persist_only\.|session\.)?[a-z_]+z@[a-z0-9_$.]+z@'single-quoted-variablez@"double-quoted-variablez@`backtick-quoted-variabler   z[!%&*+/:<=>^|~-]+z\b(set)(?!\s*\()z\b(character)(\s+)(set)\brg   )prefixri   z\b(\s*)(\()u   [0-9a-z$_-￿]+`schema-object-namez[(),.;]z[^*a-z]+rn   ro   rh   z[a-z]+z\*z[^*]+z[^'\\]+rs   z\\[0'"bnrtZ\\%_]z[^"\\]+rv   rr   ru   z[^`]+z``)	rx   r  r  r  r  r  r  r  r  c                 C   sl   d}t t| }t t| }|| }|dkrF|d| krF|d7 }n"||krX|d7 }n|dkrh|d7 }|S )Nr   r'   r+   r   r  r  )r   r  r   r  r  rA   rA   rB   r     s"    


zMySqlLexer.analyse_textN),rV   rW   rX   rY   ry   rz   r{   r|   r}   r~   r   r
   r   Specialr   r   r  Binr   r   r   Dater   Doubler   r   r   r   r   r   r   Constantr   Typer   r   r  r   ZQuotedr   PreprocEscaper   r   rA   rA   rA   rB   r#   K  s   







	
S
	








  r#   c                   @   s.   e Zd ZdZdZdgZdgZdgZdd ZdS )	r$   zO
    Lexer for example sessions using sqlite3.

    .. versionadded:: 0.11
    
sqlite3consqlite3z*.sqlite3-consoleztext/x-sqlite3-consolec              	   c   s  t f i | j}d}g }t|D ]}| }t|}|d ur|t|dt	j
|d d fgf |t|dtdfgf ||dd  7 }q"|rt|||E d H  d}g }|dr| t	j|fV  q"| t	j|fV  q"|rt|||E d H  d S )Nr   r   r0   rb      zSQL error: )r!   rP   r   r8   r6   sqlite_prompt_rer2   rR   r   r   r   r   r   r=   rQ   r:   	Tracebackr   )rG   r   rK   r   r   r2   r   Zprompt_matchrA   rA   rB   r=     s6    





z)SqliteConsoleLexer.get_tokens_unprocessedN)	rV   rW   rX   rY   ry   rz   r   r{   r=   rA   rA   rA   rB   r$     s   r$   c                   @   sv   e Zd ZdZdZdZdgZdgZdgZe	j
Zddefd	efd
efdejfdejfdefdejfdejfdefg	iZdS )r%   zG
    Lexer for Relation Query Language.

    .. versionadded:: 2.0
    RQLz"http://www.logilab.org/project/rqlrqlz*.rqlz
text/x-rqlrx   r\   z(DELETE|SET|INSERT|UNION|DISTINCT|WITH|WHERE|BEING|OR|AND|NOT|GROUPBY|HAVING|ORDERBY|ASC|DESC|LIMIT|OFFSET|TODAY|NOW|TRUE|FALSE|NULL|EXISTS)\bz
[+*/<>=%-]z)(Any|is|instance_of|CWEType|CWRelation)\brj   z[A-Z_]\w*\??r   r   r   N)rV   rW   rX   rY   ry   urlrz   r   r{   r|   r}   r~   r   r   r   r   r   r   r   r   r   r   r   rA   rA   rA   rB   r%   +  s*   r%   )@rY   r|   Zpygments.lexerr   r   r   r   r   Zpygments.tokenr   r   r	   r
   r   r   r   r   r   r   r   Zpygments.lexersr   r   Z"pygments.lexers._postgres_builtinsr   r   r   r   Zpygments.lexers._mysql_builtinsr   r   r   r   r   r   __all__compiler   r&  r}   r1   r;   r  r  r  r  r  rC   rD   r   r   r   r   r   r   Zre_errorr   r   r    r!   r"   r#   r$   r%   rA   rA   rA   rB   <module>   sN   '4




$%8!




H T 8)