File: //opt/alt/python37/lib/python3.7/site-packages/pygments/lexers/__pycache__/sql.cpython-37.pyc
B
��f{� � @ s: d Z ddlZddlmZmZmZmZmZ ddlm Z m
Z
m Z m Z m
Z
mZmZmZmZmZmZ ddlmZmZ ddlmZmZmZmZm Z ddl m Z m Z m Z m!Z!m"Z" ddlm#Z# d d
d d d
ddddg Z$e�%d�Z&e�%d�Z'e�%dej(�Z)e�%dej(�Z*e�%d�Z+e�%d�Z,e�%dej(�Z-e�%dej(�Z.e�%d�Z/dd � Z0G d d � d �Z1G d d � d e1e�Z2G d d
� d
e1e�Z3G d!d"� d"e1e�Z4e�%d#�Z5e�%d$�Z6e�%d%�Z7e�%d&�Z6e�%d'�Z8e�%d(�Z9G d)d*� d*�Z:G d+d � d e�Z;G d,d � d e�Z<G d-d
� d
e�Z=G d.d� de�Z>G d/d� de�Z?G d0d� de�Z@G d1d� de�ZAdS )2a�
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.
`PostgresExplainLexer`
A lexer to highlight Postgres execution plan.
The ``tests/examplefiles`` contains a few test files with data to be
parsed by these lexers.
:copyright: Copyright 2006-2023 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�EXPLAIN_KEYWORDS)�MYSQL_CONSTANTS�MYSQL_DATATYPES�MYSQL_FUNCTIONS�MYSQL_KEYWORDS�MYSQL_OPTIMIZER_HINTS)�_tsql_builtins�
PostgresLexer� PlPgsqlLexer�PostgresConsoleLexer�PostgresExplainLexer�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 � �}|dk r>| �|�d��}n|tt �| jtd|� � d �|� � � ��}|r�| �|d �d��}n8tt
�| jtd|� � d �|� � � ��}|r�| �d�}|� d�t |�d�fV |� d�t j |�d�fV |� d �t |�d �fV |�r"|�
|�d
��E dH n|� d
�t |�d
�fV |� d �t |�d �fV |� d �t j |�d �fV |� d
�t |�d
�fV dS )z�Parse 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.
N�d � r ���� �plpgsql� � � � � � )� language_re�match�text�end�
_get_lexer�group�list�finditer�max�start�do_rer Z Delimiter�get_tokens_unprocessed)�lexerr4 �lx�m� rB �D/opt/alt/python37/lib/python3.7/site-packages/pygments/lexers/sql.py�language_callbackQ s* $$
rD c s( e Zd ZdZ� fdd�Zdd� Z� ZS )� 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|f|�� E d H d S )N)r5 �superr> )�selfr5 �args)� __class__rB rC r> ~ s z#PostgresBase.get_tokens_unprocessedc C s� |� � dkrtd| j�S |g}|�d�r:|�|dd � � |�d�rV|�|d d� � |�d�r||�d�r||�|dd� � x4|D ](}yt|f| j�S tk
r� Y q�X q�W d S d S )N�sql�
postgresql�plr- �ur* )rK )�lowerr �options�
startswith�append�endswithr )rG �lang�triesr@ rB rB rC r7 � s
zPostgresBase._get_lexer)�__name__�
__module__� __qualname__�__doc__r> r7 �
__classcell__rB rB )rI rC rE u s rE c @ s: e Zd ZdZdZddgZdgZejZ de
fde j fde j
d fd
d �d d
� ee D �� d ejfeedd�efdefdefdejfdejfdejfdee j e j �dfdee j e j�dfde fdefd ejfd e fgde j
d fd e j
d fd e j
fd!e j
fgd"e j fd#e j fd$e j d fgd%e jfd&e jfd'e jd fgd(�Z d)S )*r zM
Lexer for the PostgreSQL dialect of SQL.
.. versionadded:: 1.5
zPostgreSQL SQL dialectrK Zpostgresztext/x-postgresqlz\s+z--.*\n?z/\*zmultiline-comments�(�|c c s | ]}|� d d�V qdS )� z\s+N)�replace)�.0�srB rB rC � <genexpr>� s zPostgresLexer.<genexpr>z)\bz\b)�suffixz[+*/<>=~!@#%^&|`?-]+z::z\$\d+z&([0-9]*\.[0-9]*|[0-9]+)(e[+-]?[0-9]+)?z[0-9]+z((?:E|U&)?)(')�stringz ((?:U&)?)(")z quoted-identz$(?s)(\$)([^$]*)(\$)(.*?)(\$)(\2)(\$)z [a-z_]\w*z:(['"]?)[a-z]\w*\b\1z[;:()\[\]{},.]z\*/z#popz[^/*]+z[/*]z[^']+z''�'z[^"]+z""�")�rootzmultiline-commentsrb z quoted-identN)!rU rV rW rX �name�aliases� mimetypes�re�
IGNORECASE�flagsr r
�Single� Multiline�joinr r r
�Builtinr r r r �Variabler �Float�Integerr r ZAffixrD r �tokensrB rB rB rC r � s@
c @ s� e Zd ZdZdZdgZdgZejZ dd� e
j � � D �Z xPe
e d �D ]4\ZZed ekrDeee d d
�efe d e< [P qDW d s�td ��d
ejfdefdejfdejfge d dd �< dS )r zR
Handle the extra syntax in Pl/pgSQL language.
.. versionadded:: 1.5
zPL/pgSQLr, ztext/x-plpgsqlc C s i | ]\}}|d d � |�qS )NrB )r^ �k�lrB rB rC �
<dictcomp>� s zPlPgsqlLexer.<dictcomp>re r) z\b)ra r zSQL keywords not foundz \%[a-z]\w*\bz:=z\<\<[a-z]\w*\>\>z \#[a-z]\w*\bN)rU rV rW rX rf rg rh ri rj rk r rs �items� enumerate�i�patternr r r r �AssertionErrorr
ro r �Label�PseudorB rB rB rC r � s" c @ s� e Zd ZdZdZg ZejZdd� e j
� � D �Z
e
d � de
jdf� dedfd efde
jfd
ejfd ejfd ejfd
ejfge
d< dS )�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 � |�qS )NrB )r^ rt ru rB rB rC rv � s zPsqlRegexLexer.<dictcomp>re z\\[^\s]+z psql-commandz\nz\s+z:(['"]?)[a-z]\w*\b\1z '(''|[^'])*'z `([^`])*`z[^\s]+N)rU rV rW rX rf rg ri rj rk r rs rw rQ r r} r r r
rp r rl ZBacktick�SymbolrB rB rB rC 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 Zd ZdZdd� Zdd� Zdd� Zdd � ZeZd
S ) � lookaheadz0Wrap an iterator and allow pushing back an item.c C s t |�| _ d | _d S )N)�iter� _nextitem)rG �xrB rB rC �__init__ s
zlookahead.__init__c C s | S )NrB )rG rB rB rC �__iter__ s zlookahead.__iter__c C s
|| _ |S )N)r� )rG ry rB rB rC �send! s zlookahead.sendc C s$ | j d k r| j }d | _ |S t| j�S )N)r� �nextr� )rG �nirB rB rC �__next__% s
zlookahead.__next__N) rU rV rW rX r� r� r� r� r� rB rB rB rC r� s r� c @ s, e Zd ZdZdZdddgZdgZdd� Zd S )
r! z=
Lexer for psql sessions.
.. versionadded:: 1.5
zPostgreSQL console (psql)Zpsqlzpostgresql-consolezpostgres-consoleztext/x-postgresql-psqlc c s� t f | j�}tt�|��}�x|d}g }x�|D ]�}|�d�r\|s\td | j�}|�|�E d H P t� |�}|d k r�|�
t |�dt j
|�� fgf� ||t |�� �d � 7 }n||7 }t� |�s�t�|�r,P q,W t||�|��E d H t j} x�|D ]�}t� |�}|d k �r|�|� P t� |�}
|
d k �r�|
�d��d��sH|
�d��d��rNt j} |
�d�t j|
�d�fV |
�d�| |
�d�fV q�d| |fV q�W d S q W d S )
N� �$�consoler r) �ERROR�FATALr- )r� )r~ rO r� �line_re�findallrP r r> � re_promptr4 rQ �lenr �Promptr8 �re_psql_command�re_end_command�searchr �Outputr� �
re_message�Errorr< ZStrong) rG �datarJ �lines�curcode�
insertions�liner? ZmpromptZ out_tokenZmmsgrB rB rC r> 9 sH
z+PostgresConsoleLexer.get_tokens_unprocessedN)rU rV rW rX rf rg rh r> rB rB rB rC r! . s
c & @ sH e Zd ZdZdZdgZdgZdgZdefde fde
e j e�d fd
e
e j e e�d fe
d d d
�ejfde
eje�fdejfde
eje�dfde
ejee �dfde
eee �dfe
dd d
�ejdfdejdfde
ee eje �dfe
dd d
�ejfe
d d d
�e jfd e
e jee �fe
ed d
�efd ejfd ejfd ejfd!ejfd"e
ee e j�fd#edfd$ejfd%ejfd&ejfd'e j fd(ejfd)e
ejee �d*fd+e
eje�fd,ejfd-e
eje e jee �fg d.ed/fd0ed1fd2e jfd3efgd4e
e j e�d fd5e
e j e e�d fd.ed6fd7efd8e jfd9e jfd:e jfd;edfd<edfd=e jfd>e jfd?e jfd@e jfdAe jfdBe fdCefdDefd0ed1fgdEe
ee je�d1fdFe jd1fgdGefdBe fdHe j fd%ejfd&ejfd0ed1fgdIe
eje j�fdJejdfdKejdfgdLe
e j e ee e�fdMefgd.efdNe jfd0ed1fgdOefdPej fdQe jfd&ejfdBe fgdR� Z dSS )Tr" zF
Handle PostgreSQL EXPLAIN output
.. versionadded:: 2.15
zPostgreSQL EXPLAIN dialectzpostgres-explainz *.explainztext/x-postgresql-explainz(:|\(|\)|ms|kB|->|\.\.|\,)z(\s+)z
(cost)(=?)�instrumentationz(actual)( )(=?)) �actualz Memory UsageZMemoryZBucketsZBatchesZ
originally�row�rowsZHitsZMissesZ EvictionsZ Overflowsz\b)ra z.(hit|read|dirtied|written|write|time|calls)(=)z(shared|temp|local)z(Sort Method)(: )�sortz1(Sort Key|Group Key|Presorted Key|Hash Key)(:)( )� object_namez (Cache Key|Cache Mode)(:)( ))z Join FilterzSubplans Removed�Filterz
Merge Condz Hash Condz
Index Condz Recheck Condz Heap BlockszTID Condz
Run ConditionzOrder Byz
Function CallzTable Function Callz Inner UniquezParams Evaluatedz Single CopyZSamplingzOne-Time Filterr� Z Relationsz
Remote SQL� predicatez Conflict �conflictz (InitPlan|SubPlan)( )(\d+)( )� init_plan)z Sort Methodz Join Filterz
Planning timez
Planning TimezExecution timezExecution TimezWorkers PlannedzWorkers LaunchedZBuffersZPlanningZWorkerzQuery IdentifierZTimezFull-sort GroupszPre-sorted Groups)zRows Removed by Join FilterzRows Removed by Filterz Rows Removed by Index Recheckz Heap Fetchesznever executedz(I/O Timings)(:)( )z"((Right|Left|Full|Semi|Anti) Join)z%(Parallel |Async |Finalize |Partial )ZBackwardz(Intersect|Except|Hash)z(CTE)( )(\w*)?z
(on|using)z '(''|[^'])*'z\d+\.\d+z(\d+)z (true|false)z\s*QUERY PLAN\s*\n\s*-+z(Settings)(:)( )�settingz!(JIT|Functions|Options|Timing)(:)zG(Inlining|Optimization|Expressions|Deforming|Generation|Emission|Total)z(Trigger)( )(\S*)(:)( )z\(z#pushz\)z#popz(never executed)z[^)(]+z (\(cost)(=?)z(\(actual)( )(=?)�
expressionz(on)z&\w+(\.\w+)*( USING \S+| \w+ USING \S+)z\"?\w+\"?(?:\.\"?\w+\"?)?z\'\S*\'z,\n�,z"\*SELECT\*( \d+)?"(.\w+)?z"\*VALUES\*(_\d+)?"(.\w+)?z"ANY_subquery"z\$\d+z::\w+z +rd z
\[\.\.\.\]z(\()([^\n]*)(\))z[^\n]*z=|\.\.z(rows|width|time|loops)z(Resolution: )(\w+)z(Arbiter \w+:)z
(Filter: )z ([a-z_]*?)(\s*)(=)(\s*)(\'.*?\')z\, zreturns \$\d+(,\$\d+)?z:|kBz.(quicksort|top-N|heapsort|Average|Memory|Peak)z(external|merge|Disk|sort)) re r� r� r� r� r� r� r� r� N) rU rV rW rX rf rg � filenamesrh r r r r
�Classr r
rl r r r} �Preprocr rr � Exceptionr �Typerp r rq �Constant� AttributeZPrepocrs rB rB rB rC r" v s�
c @ s� e Zd ZdZdZdgZdgZdgZej Z
de fde j
fde jd fed
d d �efed
d d �ejfdefdejfdej
fdejfdefdefg de jd fde jdfde jfde jfgd�Zdd� ZdS ) r# z
Lexer for Structured Query Language. Currently, this lexer does
not recognize any special syntax except ANSI SQL.
�SQLrJ z*.sqlz
text/x-sqlz\s+z--.*\n?z/\*zmultiline-comments(� ZABORTZABSZABSOLUTEZACCESSZADAZADDZADMINZAFTERZ AGGREGATEZALIAS�ALLZALLOCATEZALTERZANALYSEZANALYZE�AND�ANYZAREZAS�ASCZ
ASENSITIVEZ ASSERTIONZ
ASSIGNMENTZ
ASYMMETRIC�ATZATOMICZ
AUTHORIZATIONZAVGZBACKWARDZBEFOREZBEGINZBETWEENZBITVARZ
BIT_LENGTHZBOTHZBREADTHZBY�C�CACHE�CALLZCALLEDZ CARDINALITYZCASCADEZCASCADEDZCASEZCASTZCATALOGZ CATALOG_NAMEZCHAINZCHARACTERISTICSZCHARACTER_LENGTHZCHARACTER_SET_CATALOGZCHARACTER_SET_NAMEZCHARACTER_SET_SCHEMAZ CHAR_LENGTHZCHECKZCHECKED�
CHECKPOINTZCLASSZ CLASS_ORIGINZCLOBZCLOSEZCLUSTERZCOALESCEZCOBOLZCOLLATEZ COLLATIONZCOLLATION_CATALOGZCOLLATION_NAMEZCOLLATION_SCHEMAZCOLUMNZ COLUMN_NAMEZCOMMAND_FUNCTIONZCOMMAND_FUNCTION_CODE�COMMENTZCOMMITZ COMMITTEDZ
COMPLETIONZCONDITION_NUMBER�CONNECTZ
CONNECTIONZCONNECTION_NAMEZ
CONSTRAINTZ CONSTRAINTSZCONSTRAINT_CATALOGZCONSTRAINT_NAMEZCONSTRAINT_SCHEMAZ CONSTRUCTORZCONTAINS�CONTINUEZ
CONVERSIONZCONVERT�COPYZ
CORRESPONDINGZCOUNTZCREATEZCREATEDBZ
CREATEUSERZCROSSZCUBEZCURRENTZ CURRENT_DATEZ CURRENT_PATHZ CURRENT_ROLEZ CURRENT_TIMEZCURRENT_TIMESTAMPZ CURRENT_USERZCURSORZ CURSOR_NAMEZCYCLEZDATAZDATABASEZDATETIME_INTERVAL_CODEZDATETIME_INTERVAL_PRECISIONZDAYZ
DEALLOCATEZDECLARE�DEFAULTZDEFAULTSZ
DEFERRABLEZDEFERREDZDEFINEDZDEFINER�DELETEZ DELIMITERZ
DELIMITERSZDEREFZDESCZDESCRIBEZ
DESCRIPTORZDESTROYZ
DESTRUCTORZ
DETERMINISTICZ DIAGNOSTICSZ
DICTIONARYZ
DISCONNECTZDISPATCHZDISTINCTZDOZDOMAINZDROPZDYNAMICZDYNAMIC_FUNCTIONZDYNAMIC_FUNCTION_CODEZEACH�ELSEZELSIF�ENCODING� ENCRYPTEDZENDzEND-EXECZEQUALS�ESCAPEZEVERYZ EXCEPTIONZEXCEPTZ EXCLUDINGZ EXCLUSIVEZEXECZEXECUTEZEXISTINGZEXISTSZEXPLAINZEXTERNALZEXTRACT�FALSEZFETCHZFINALZFIRSTZFORZFORCEZFOREIGNZFORTRAN�FORWARD�FOUNDZFREEZFREEZEZFROMZFULLZFUNCTION�GZGENERALZ GENERATED�GET�GLOBALZGOZGOTOZGRANTZGRANTEDZGROUPZGROUPINGZHANDLERZHAVINGZ HIERARCHYZHOLDZHOSTZIDENTITYZIFZIGNOREZILIKEZ IMMEDIATEZ IMMEDIATELYZ IMMUTABLEZIMPLEMENTATIONZIMPLICIT�INZ INCLUDINGZ INCREMENTZINDEXZ
INDITCATORZINFIXZINHERITSZ
INITIALIZEZ INITIALLYZINNERZINOUTZINPUTZ INSENSITIVEZINSERTZ INSTANTIABLEZINSTEADZ INTERSECTZINTOZINVOKERZISZISNULLZ ISOLATIONZITERATEZJOINZKEYZ
KEY_MEMBERZKEY_TYPEZ LANCOMPILER�LANGUAGEZLARGEZLASTZLATERALZLEADING�LEFTZLENGTH�LESSZLEVELZLIKEZLIMITZLISTENZLOADZLOCALZ LOCALTIMEZLOCALTIMESTAMPZLOCATIONZLOCATORZLOCKZLOWERZMAP�MATCH�MAXZMAXVALUEZMESSAGE_LENGTHZMESSAGE_OCTET_LENGTHZ MESSAGE_TEXTZMETHODZMINZMINUTEZMINVALUEZMODZMODEZMODIFIESZMODIFYZMONTHZMOREZMOVEZMUMPSZNAMESZNATIONALZNATURALZNCHARZNCLOBZNEWZNEXT�NOZ
NOCREATEDBZ NOCREATEUSER�NONEZNOTZNOTHINGZNOTIFYZNOTNULLZNULLZNULLABLEZNULLIFZOBJECTZ OCTET_LENGTHZOFZOFFZOFFSETZOIDSZOLD�ONZONLYZOPENZ OPERATIONZOPERATORZOPTION�OPTIONS�ORZORDERZ
ORDINALITYZOUTZOUTERZOUTPUTZOVERLAPSZOVERLAYZ
OVERRIDINGZOWNERZPADZ PARAMETERZ
PARAMETERSZPARAMETER_MODEZPARAMETER_NAMEZPARAMETER_ORDINAL_POSITIONZPARAMETER_SPECIFIC_CATALOGZPARAMETER_SPECIFIC_NAMEZPARAMETER_SPECIFIC_SCHEMA�PARTIALZPASCALZPENDANTZPERIODZPLACINGZPLIZPOSITIONZPOSTFIXZPRECEEDSZ PRECISION�PREFIXZPREORDERZPREPAREZPRESERVEZPRIMARYZPRIORZ
PRIVILEGESZ
PROCEDURALZ PROCEDUREZPUBLIC�READZREADSZRECHECKZ RECURSIVEZREFZ
REFERENCESZ REFERENCINGZREINDEXZRELATIVEZRENAMEZ
REPEATABLEZREPLACE�RESETZRESTARTZRESTRICTZRESULTZRETURNZRETURNED_LENGTHZRETURNED_OCTET_LENGTHZRETURNED_SQLSTATEZRETURNSZREVOKE�RIGHTZROLEZROLLBACKZROLLUPZROUTINEZROUTINE_CATALOGZ ROUTINE_NAMEZROUTINE_SCHEMAZROWZROWSZ ROW_COUNTZRULEZ
SAVE_POINTZSCALEZSCHEMAZ SCHEMA_NAMEZSCOPEZSCROLLZSEARCHZSECONDZSECURITYZSELECTZSELFZ SENSITIVEZ SERIALIZABLEZ SERVER_NAMEZSESSIONZ SESSION_USERZSETZSETOFZSETSZSHAREZSHOWZSIMILARZSIMPLEZSIZEZSOMEZSOURCE�SPACEZSPECIFICZ SPECIFICTYPEZ
SPECIFIC_NAMEr� ZSQLCODEZSQLERRORZ SQLEXCEPTIONZSQLSTATEZ SQLWARNINIGZSTABLE�STARTZSTATEZ STATEMENTZSTATICZ
STATISTICSZSTDIN�STDOUTZSTORAGEZSTRICTZ STRUCTUREZSTYPEZSUBCLASS_ORIGINZSUBLISTZ SUBSTRINGZSUCCEEDSZSUMZ SYMMETRICZSYSIDZSYSTEMZ SYSTEM_USERZTABLEZ
TABLE_NAMEz TEMP�TEMPLATE� TEMPORARYZ TERMINATEZTHANZTHENZTIME� TIMESTAMPZ
TIMEZONE_HOURZTIMEZONE_MINUTEZTOZTOASTZTRAILINGZ TRANSACTIONZTRANSACTIONS_COMMITTEDZTRANSACTIONS_ROLLED_BACKZTRANSACTION_ACTIVEZ TRANSFORMZ
TRANSFORMSZ TRANSLATEZ TRANSLATIONZTREATZTRIGGERZTRIGGER_CATALOGZ TRIGGER_NAMEZTRIGGER_SCHEMAZTRIM�TRUEZTRUNCATEZTRUSTEDZTYPEZ UNCOMMITTEDZUNDERZ UNENCRYPTEDZUNIONZUNIQUE�UNKNOWNZUNLISTENZUNNAMEDZUNNESTZUNTILZUPDATEZUPPER�USAGE�USERZUSER_DEFINED_TYPE_CATALOGZUSER_DEFINED_TYPE_NAMEZUSER_DEFINED_TYPE_SCHEMAZUSINGZVACUUMZVALIDZ VALIDATORZVALUES�VARIABLE�VERBOSE�VERSION�VERSIONSZ
VERSIONINGZVIEWZVOLATILEZWHENZWHENEVERZWHEREZWITHZWITHOUTZWORK�WRITEZYEARZZONEz\b)ra )�ARRAYZBIGINT�BINARYZBITZBLOBZBOOLEANZCHARZ CHARACTERZDATEZDECZDECIMAL�FLOAT�INTZINTEGERZINTERVAL�NUMBERZNUMERICZREALZSERIALZSMALLINTZVARCHARZVARYINGZINT8ZSERIAL8ZTEXTz[+*/<>=~!@#%^&|`?-]z[0-9]+z '(''|[^'])*'z "(""|[^"])*"z [a-z_][\w$]*z [;:()\[\],.]z\*/z#popz[^/*]+z[/*])re zmultiline-commentsc C s d S )NrB )rG r5 rB rB rC � analyse_text� s zSqlLexer.analyse_textN)rU rV rW rX rf rg r� rh ri rj rk r r
rl rm r r r
ro r r rr r r r rs r� rB rB rB rC r# 0 s8
V
c @ sX e Zd ZdZdZddgZdgZdgZej Z
de fde j
fd e jd
feej�efeejd d �ejfeejd d �ejfeejd d �ejfd
eee ej �feej d d �efdeeee�fde j fde j fde j fde j fde j!fde"j
fde"j#fde$fdej%fdej&fdeej e$�fdefdej&j'fgd e jd
fd e jd fd e jfd e jfgd �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-SQLZtsqlzt-sqlz*.sqlz text/x-tsqlz\s+z --.*?$\n?z/\*zmultiline-commentsz\b)ra z(goto)(\s+)(\w+\b)z(\[)([^]]+)(\])z 0x[0-9a-f]+z [0-9]+\.[0-9]*(e[+-]?[0-9]+)?z\.[0-9]+(e[+-]?[0-9]+)?z[0-9]+e[+-]?[0-9]+z[0-9]+z '(''|[^'])*'z "(""|[^"])*"z[;(),.]z@@\w+z@\w+z(\w+)(:)z#?#?\w+z\?z\*/z#popz[^/*]+z[/*])re zmultiline-commentsc C s� d}t �| �rd}n�tt�| ��}tt�| ��}|| }|dkrV|d| krV|d7 }n"||krh|d7 }n|dkrx|d7 }t�| �d k r�|d7 }t�| �d k r�|d7 }|S )Nr g �?r) r- g �?g�������?g�������?)�tsql_declare_rer� r� �name_between_backtick_rer� �name_between_bracket_re�tsql_variable_re�
tsql_go_re)r5 �rating�name_between_backtick_count�name_between_bracket_count�dialect_name_countrB rB rC r� � s(
z TransactSqlLexer.analyse_textN)*rU rV rW rX rf rg r� rh ri rj rk r r
rl rm r r Z OPERATORSr ZOPERATOR_WORDS�Word�TYPESr
r� Z FUNCTIONS�Functionr r r| r r �Hexrq rr r r r ro rp ZMagicrs r� rB rB rB rC r$ � sD
c " @ s� e Zd ZdZdZdgZdgZejZ de
fde j fde j
dfd e jd
fd ejfd ejfd
ejfdejfdejfdejfdejfdejfdejfdejfdejfdej dfdejdfdejfdejfd ejd fd ejd fd ejd!fd"ejfd#efd$efd%e ee
e�fe e d&d&d'�ej fe e d&d&d'�ej!fe e"d&d&d'�efe e#d&d(d'�e ej$e
e%�fd)efd*ej&d+fd,e%fg!d-e j
fd.e j
d/fe e'd&d0�e j(fd1e j
fd2e j
fgd3e jfd.e jd/fd2e jfgd4ej fd5ej)fd6ej)fdej d/fgd7ejfd8ej)fd6ej)fdejd/fgd9ejfd5ejfdejd/fgd:ejfd8ejfdejd/fgd;ejfd<ejfd*ejd/fgd;ej&fd<ej&j)fd*ej&d/fgd=� 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.
ZMySQLZmysqlz text/x-mysqlz\s+z
(?:#|--\s+).*z/\*\+zoptimizer-hintsz/\*zmultiline-commentzx'([0-9a-f]{2})+'z 0x[0-9a-f]+zb'[01]+'z0b[01]+z [0-9]+\.[0-9]*(e[+-]?[0-9]+)?z [0-9]*\.[0-9]+(e[+-]?[0-9]+)?z[0-9]+e[+-]?[0-9]+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*\}rc zsingle-quoted-stringrd zdouble-quoted-stringz9@@(?:global\.|persist\.|persist_only\.|session\.)?[a-z_]+z
@[a-z0-9_$.]+z@'zsingle-quoted-variablez@"zdouble-quoted-variablez@`zbacktick-quoted-variablez\?z[!%&*+/:<=>^|~-]+z\b(set)(?!\s*\()z\b(character)(\s+)(set)\bz\b)�prefixra z \b(\s*)(\()u [0-9a-z$_-]+�`zschema-object-namez[(),.;]z[^*a-z]+z\*/z#pop)ra z[a-z]+z\*z[^*]+z[^'\\]+z''z\\[0'"bnrtZ\\%_]z[^"\\]+z""z[^']+z[^"]+z[^`]+z``) re zoptimizer-hintszmultiline-commentzsingle-quoted-stringzdouble-quoted-stringzsingle-quoted-variablezdouble-quoted-variablezbacktick-quoted-variablezschema-object-namec C sl d}t t�| ��}t t�| ��}|| }|dkrF|d| krF|d7 }n"||krX|d7 }n|dkrh|d7 }|S )Nr r) r- g �?g�������?g�������?)r� r� r� r� )r5 r� r� r� r� rB rB rC r� � s
zMySqlLexer.analyse_textN),rU rV rW rX rf rg rh ri rj rk r r
rl �Specialrm r r� ZBinrq rr r �Dater �Doubler
rp r r r r r r� r r� r r r� r ZQuotedr r� ZEscapers r� rB rB rB rC r% s�
c @ s. e Zd ZdZdZdgZdgZdgZdd� ZdS ) r& zO
Lexer for example sessions using sqlite3.
.. versionadded:: 0.11
Z
sqlite3conZsqlite3z*.sqlite3-consoleztext/x-sqlite3-consolec c s t f | j�}d}g }x�t�|�D ]�}|�� }t�|�}|d k r�|�t|�dt j
|d d� fgf� |�t|�dt dfgf� ||dd � 7 }q |r�t ||�
|��E d H d}g }|�d�r�|�� t j|fV q |�� t j|fV q W |r�t ||�
|��E d H d S )Nr� r r2 r\ � z SQL error: )r# rO r� r: r8 �sqlite_prompt_rer4 rQ r� r r� r r r> rP r< � Tracebackr� )rG r� rJ r� r� r4 r� Z prompt_matchrB rB rC r> � s.
z)SqliteConsoleLexer.get_tokens_unprocessedN) rU rV rW rX rf rg r� rh r> rB rB rB rC r& � s c @ sv e Zd ZdZdZdZdgZdgZdgZe j
Z dde fd e
fd
efd ejfd ejfd
efdejfdejfdefg iZdS )r' zG
Lexer for Relation Query Language.
.. versionadded:: 2.0
ZRQLz"http://www.logilab.org/project/rqlZrqlz*.rqlz
text/x-rqlre z\s+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)\bz[0-9]+z [A-Z_]\w*\??z '(''|[^'])*'z "(""|[^"])*"z [;:()\[\],.]N)rU rV rW rX rf �urlrg r� rh ri rj rk r r r r
ro r rr r rl r rs rB rB rB rC r' � s$ )BrX ri Zpygments.lexerr r r r r Zpygments.tokenr r r r
r r r
r r r r Zpygments.lexersr r Z"pygments.lexers._postgres_builtinsr r r r r Z pygments.lexers._mysql_builtinsr r r r r r �__all__�compiler� r rj r3 r= r� r� r� r� r� rD rE r r r~ r� r� r� Zre_errorr� r� r! r" r# r$ r% r& r' rB rB rB rC �<module>) sT 4
$%8!
H ; T 8)