3
� �Xs � @ s� d Z ddlZddlmZmZmZmZmZ ddlm Z m
Z
m Z m Z m
Z
mZmZmZmZmZmZ ddlmZmZ ddlmZ ddlmZmZm Z m Z ddlm Z d d
d d d
dddgZ ej d�Z!ej dej"�Z#ej dej"�Z$dd� Z%G dd� de&�Z'G dd � d e'e�Z(G dd
� d
e'e�Z)G dd� de'e�Z*ej d �Z+ej d �Z,ej d �Z-ej d �Z,ej d �Z.ej d!�Z/G d"d#� d#e&�Z0G d$d � d e�Z1G d%d � d e�Z2G d&d
� d
e�Z3G d'd� de�Z4G d(d� de�Z5G d)d� de�Z6dS )*a�
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-2017 by the Pygments team, see AUTHORS.
:license: BSD, see LICENSE for details.
� N)�Lexer�
RegexLexer�
do_insertions�bygroups�words) � Punctuation�
Whitespace�Error�Text�Comment�Operator�Keyword�Name�String�Number�Generic)�get_lexer_by_name�
ClassNotFound)� iteritems)�KEYWORDS� DATATYPES� PSEUDO_TYPES�PLPGSQL_KEYWORDS)�_tsql_builtins�
PostgresLexer� PlPgsqlLexer�PostgresConsoleLexer�SqlLexer�TransactSqlLexer�
MySqlLexer�SqliteConsoleLexer�RqlLexerz.*?
z\s+LANGUAGE\s+'?(\w+)'?z\bDO\bc c s� d}t j| j|j� |j� d � �}|dk r>| j|jd��}n|tt j| jtd|j � d �|j � � ��}|r�| j|d
jd��}n8tt
j| jtd|j � d �|j � � ��}|r�| jd�}|j d�t |jd�fV |j d�t j |jd�fV |j d�t |jd�fV |�r.x:|j
|jd ��D ] }|V �q W n|j d �t |jd �fV |j d
�t |jd
�fV |j d �t j |jd �fV |j d �t |jd �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)�lexerr. �l�m�x� r= �/usr/lib/python3.6/sql.py�language_callbackA s, $$
r? 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 ' s0 || _ x$tt| �j|f|�� D ]
}|V q W d S )N)r/ �superr@ r8 )�selfr/ �argsr< )� __class__r= r> r8 o s z#PostgresBase.get_tokens_unprocessedc C s� |j � dkrtd| j�S |g}|jd�r:|j|dd � � |jd�rV|j|d d� � |jd�r||jd�r||j|dd � � x4|D ](}yt|f| j�S tk
r� Y q�X q�W d S d S )
N�sql�
postgresqlZplr& �ur# )rF r, r, )�lowerr �options�
startswith�append�endswithr )rB ZlangZtriesr: r= r= r> r1 v s
zPostgresBase._get_lexer)�__name__�
__module__� __qualname__�__doc__r8 r1 �
__classcell__r= r= )rD r> r@ f s r@ c @ s: e Zd ZdZdZddgZdgZejZ de
fde j fde j
d fd
d jd 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 dialectrF Zpostgresztext/x-postgresqlz\s+z--.*\n?z/\*zmultiline-comments�(�|c c s | ]}|j d d�V qdS )� z\s+N)�replace)�.0�sr= r= r> � <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-commentsrZ z quoted-identN)!rM rN rO rP �name�aliases� mimetypes�re�
IGNORECASE�flagsr
r �Single� Multiline�joinr r r �Builtinr r r
r �Variabler �Float�Integerr r ZAffixr? r �tokensr= r= r= r> r � s>
$
c @ s� e Zd ZdZdZdgZdgZejZ e
dd� e e j
�D ��Z
xDee
d �D ]4\ZZed ekrHeee d d
�efe
d e< [P qHW d ejfd efd
ejfdejfge
d dd�< dS )r zR
Handle the extra syntax in Pl/pgSQL language.
.. versionadded:: 1.5
zPL/pgSQLr% ztext/x-plpgsqlc c s" | ]\}}||d d � fV qd S )Nr= )rV �kr: r= r= r> rX � s zPlPgsqlLexer.<genexpr>r] r# z\b)rY z \%[a-z]\w*\bz:=z\<\<[a-z]\w*\>\>z \#[a-z]\w*\bNr )rM rN rO rP r^ r_ r` ra rb rc �dictr r rk � enumerate�i�patternr
r r r r rg r �Label�Pseudor= r= r= r> r � s c @ s� e Zd ZdZdZg ZejZe dd� e
e j �D ��Z e d j
dejdf� dedfd efdejfd
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" | ]\}}||d d � fV qd S )Nr= )rV rl r: r= r= r> rX � s zPsqlRegexLexer.<genexpr>r] z\\[^\s]+z psql-commandz\nz\s+z:(['"]?)[a-z]\w*\b\1z '(''|[^'])*'z `([^`])*`z[^\s]+N)rM rN rO rP r^ r_ ra rb rc rm r r rk rK r
rr r
r rh r rd ZBacktick�Symbolr= r= r= r> rs � s rs 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)rB r< r= r= r> �__init__ s
zlookahead.__init__c C s | S )Nr= )rB r= r= r> �__iter__ s zlookahead.__iter__c C s
|| _ |S )N)rw )rB ro r= r= r> �send s zlookahead.sendc C s$ | j d k r| j }d | _ |S t| j�S )N)rw �nextrv )rB Znir= r= r> �__next__ s
zlookahead.__next__N) rM rN rO rP rx ry rz r| r{ r= r= r= r> ru
s ru 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�}ttj|��}�x�d}g }x�y t|�}W n tk
rJ P Y nX |jd�r�| r�td | j�}x|j |�D ]
}|V qtW P t
j |�} | d k r�|j t
|�dtj| j� fgf� ||t
| j� �d � 7 }n||7 }tj |�s�tj|�r(P q(W x t||j |��D ] }
|
V �qW tj} x�t|�}t
j |�} | d k �rD|j|� P tj |�} | d k �r�| jd�jd��s|| jd�jd��r�tj} | jd�tj| jd�fV | jd�| | jd�fV n d| |fV �q W q W d S )
N� �$�consoler r# ZERRORZFATALr& )r )rs rI ru �line_re�findallr{ �
StopIterationrJ r r8 � re_promptr. rK �lenr �Promptr2 �re_psql_command�re_end_command�searchr �Outputrz �
re_messager r6 ZStrong)
rB �datarE �lines�curcode�
insertions�liner9 r< Zmprompt�itemZ out_tokenZmmsgr= r= r> r8 + sT
z+PostgresConsoleLexer.get_tokens_unprocessedN)rM rN rO rP r^ r_ r` r8 r= r= r= r> r s
c � @ s� e Zd ZdZdZdgZdgZdgZej Z
de fde j
fde jd fe�d"�d��d��efe�d#�d��d��ejf�def�dejf�dej
f�dejf�def�defg de jd f�d e j�d f�d e jf�d e jfg�d �Z�d!S ($ r z
Lexer for Structured Query Language. Currently, this lexer does
not recognize any special syntax except ANSI SQL.
�SQLrE z*.sqlz
text/x-sqlz\s+z--.*\n?z/\*zmultiline-comments�ABORT�ABS�ABSOLUTE�ACCESS�ADA�ADD�ADMIN�AFTER� AGGREGATE�ALIAS�ALL�ALLOCATE�ALTER�ANALYSE�ANALYZE�AND�ANY�ARE�AS�ASC�
ASENSITIVE� ASSERTION�
ASSIGNMENT�
ASYMMETRIC�AT�ATOMIC�
AUTHORIZATION�AVG�BACKWARD�BEFORE�BEGIN�BETWEEN�BITVAR�
BIT_LENGTH�BOTH�BREADTH�BY�C�CACHE�CALL�CALLED� CARDINALITY�CASCADE�CASCADED�CASE�CAST�CATALOG� CATALOG_NAME�CHAIN�CHARACTERISTICS�CHARACTER_LENGTH�CHARACTER_SET_CATALOG�CHARACTER_SET_NAME�CHARACTER_SET_SCHEMA� CHAR_LENGTH�CHECK�CHECKED�
CHECKPOINT�CLASS� CLASS_ORIGIN�CLOB�CLOSE�CLUSTER�COALSECE�COBOL�COLLATE� COLLATION�COLLATION_CATALOG�COLLATION_NAME�COLLATION_SCHEMA�COLUMN� COLUMN_NAME�COMMAND_FUNCTION�COMMAND_FUNCTION_CODE�COMMENT�COMMIT� COMMITTED�
COMPLETION�CONDITION_NUMBER�CONNECT�
CONNECTION�CONNECTION_NAME�
CONSTRAINT� CONSTRAINTS�CONSTRAINT_CATALOG�CONSTRAINT_NAME�CONSTRAINT_SCHEMA� CONSTRUCTOR�CONTAINS�CONTINUE�
CONVERSION�CONVERT�COPY�
CORRESPONTING�COUNT�CREATE�CREATEDB�
CREATEUSER�CROSS�CUBE�CURRENT� CURRENT_DATE� CURRENT_PATH� CURRENT_ROLE� CURRENT_TIME�CURRENT_TIMESTAMP� CURRENT_USER�CURSOR� CURSOR_NAME�CYCLE�DATA�DATABASE�DATETIME_INTERVAL_CODE�DATETIME_INTERVAL_PRECISION�DAY�
DEALLOCATE�DECLARE�DEFAULT�DEFAULTS�
DEFERRABLE�DEFERRED�DEFINED�DEFINER�DELETE� DELIMITER�
DELIMITERS�DEREF�DESC�DESCRIBE�
DESCRIPTOR�DESTROY�
DESTRUCTOR�
DETERMINISTIC� DIAGNOSTICS�
DICTIONARY�
DISCONNECT�DISPATCH�DISTINCT�DO�DOMAIN�DROP�DYNAMIC�DYNAMIC_FUNCTION�DYNAMIC_FUNCTION_CODE�EACH�ELSE�ELSIF�ENCODING� ENCRYPTED�END�END-EXEC�EQUALS�ESCAPE�EVERY� EXCEPTION�EXCEPT� EXCLUDING� EXCLUSIVE�EXEC�EXECUTE�EXISTING�EXISTS�EXPLAIN�EXTERNAL�EXTRACT�FALSE�FETCH�FINAL�FIRST�FOR�FORCE�FOREIGN�FORTRAN�FORWARD�FOUND�FREE�FREEZE�FROM�FULL�FUNCTION�G�GENERAL� GENERATED�GET�GLOBAL�GO�GOTO�GRANT�GRANTED�GROUP�GROUPING�HANDLER�HAVING� HIERARCHY�HOLD�HOST�IDENTITY�IF�IGNORE�ILIKE� IMMEDIATE� IMMUTABLE�IMPLEMENTATION�IMPLICIT�IN� INCLUDING� INCREMENT�INDEX�
INDITCATOR�INFIX�INHERITS�
INITIALIZE� INITIALLY�INNER�INOUT�INPUT� INSENSITIVE�INSERT� INSTANTIABLE�INSTEAD� INTERSECT�INTO�INVOKER�IS�ISNULL� ISOLATION�ITERATE�JOIN�KEY�
KEY_MEMBER�KEY_TYPE� LANCOMPILER�LANGUAGE�LARGE�LAST�LATERAL�LEADING�LEFT�LENGTH�LESS�LEVEL�LIKE�LIMIT�LISTEN�LOAD�LOCAL� LOCALTIME�LOCALTIMESTAMP�LOCATION�LOCATOR�LOCK�LOWER�MAP�MATCH�MAX�MAXVALUE�MESSAGE_LENGTH�MESSAGE_OCTET_LENGTH� MESSAGE_TEXT�METHOD�MIN�MINUTE�MINVALUE�MOD�MODE�MODIFIES�MODIFY�MONTH�MORE�MOVE�MUMPS�NAMES�NATIONAL�NATURAL�NCHAR�NCLOB�NEW�NEXT�NO�
NOCREATEDB� NOCREATEUSER�NONE�NOT�NOTHING�NOTIFY�NOTNULL�NULL�NULLABLE�NULLIF�OBJECT� OCTET_LENGTH�OF�OFF�OFFSET�OIDS�OLD�ON�ONLY�OPEN� OPERATION�OPERATOR�OPTION�OPTIONS�OR�ORDER�
ORDINALITY�OUT�OUTER�OUTPUT�OVERLAPS�OVERLAY�
OVERRIDING�OWNER�PAD� PARAMETER�
PARAMETERS�PARAMETER_MODE�PARAMATER_NAME�PARAMATER_ORDINAL_POSITION�PARAMETER_SPECIFIC_CATALOG�PARAMETER_SPECIFIC_NAME�PARAMATER_SPECIFIC_SCHEMA�PARTIAL�PASCAL�PENDANT�PLACING�PLI�POSITION�POSTFIX� PRECISION�PREFIX�PREORDER�PREPARE�PRESERVE�PRIMARY�PRIOR�
PRIVILEGES�
PROCEDURAL� PROCEDURE�PUBLIC�READ�READS�RECHECK� RECURSIVE�REF�
REFERENCES� REFERENCING�REINDEX�RELATIVE�RENAME�
REPEATABLE�REPLACE�RESET�RESTART�RESTRICT�RESULT�RETURN�RETURNED_LENGTH�RETURNED_OCTET_LENGTH�RETURNED_SQLSTATE�RETURNS�REVOKE�RIGHT�ROLE�ROLLBACK�ROLLUP�ROUTINE�ROUTINE_CATALOG� ROUTINE_NAME�ROUTINE_SCHEMA�ROW�ROWS� ROW_COUNT�RULE�
SAVE_POINT�SCALE�SCHEMA� SCHEMA_NAME�SCOPE�SCROLL�SEARCH�SECOND�SECURITY�SELECT�SELF� SENSITIVE� SERIALIZABLE� SERVER_NAME�SESSION� SESSION_USER�SET�SETOF�SETS�SHARE�SHOW�SIMILAR�SIMPLE�SIZE�SOME�SOURCE�SPACE�SPECIFIC� SPECIFICTYPE�
SPECIFIC_NAME�SQLCODE�SQLERROR� SQLEXCEPTION�SQLSTATE� SQLWARNINIG�STABLE�START�STATE� STATEMENT�STATIC�
STATISTICS�STDIN�STDOUT�STORAGE�STRICT� STRUCTURE�STYPE�SUBCLASS_ORIGIN�SUBLIST� SUBSTRING�SUM� SYMMETRIC�SYSID�SYSTEM� SYSTEM_USER�TABLE�
TABLE_NAME� TEMP�TEMPLATE� TEMPORARY� TERMINATE�THAN�THEN� TIMESTAMP�
TIMEZONE_HOUR�TIMEZONE_MINUTE�TO�TOAST�TRAILING�
TRANSATION�TRANSACTIONS_COMMITTED�TRANSACTIONS_ROLLED_BACK�TRANSATION_ACTIVE� TRANSFORM�
TRANSFORMS� TRANSLATE� TRANSLATION�TREAT�TRIGGER�TRIGGER_CATALOG� TRIGGER_NAME�TRIGGER_SCHEMA�TRIM�TRUE�TRUNCATE�TRUSTED�TYPE� UNCOMMITTED�UNDER� UNENCRYPTED�UNION�UNIQUE�UNKNOWN�UNLISTEN�UNNAMED�UNNEST�UNTIL�UPDATE�UPPER�USAGE�USER�USER_DEFINED_TYPE_CATALOG�USER_DEFINED_TYPE_NAME�USER_DEFINED_TYPE_SCHEMA�USING�VACUUM�VALID� VALIDATOR�VALUES�VARIABLE�VERBOSE�VERSION�VIEW�VOLATILE�WHEN�WHENEVER�WHERE�WITH�WITHOUT�WORK�WRITE�YEAR�ZONEz\b)rY �ARRAY�BIGINT�BINARY�BIT�BLOB�BOOLEAN�CHAR� CHARACTER�DATE�DEC�DECIMAL�FLOAT�INT�INTEGER�INTERVAL�NUMBER�NUMERIC�REAL�SERIAL�SMALLINT�VARCHAR�VARYING�INT8�SERIAL8�TEXTz[+*/<>=~!@#%^&|`?-]z[0-9]+z '(''|[^'])*'z "(""|[^"])*"z [a-z_][\w$]*z [;:()\[\],.]z\*/z#popz[^/*]+z[/*])r] zmultiline-commentsN(� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r r r r r r r r r r
r r r
r r r r r r r r r r r r r r r r r r r r! r" r# r$ r% r& r' r( r) r* r+ r, r- r. r/ r0 r1 r2 r3 r4 r5 r6 r7 r8 r9 r: r; r< r= r> r? r@ rA rB rC rD rE rF rG rH rI rJ rK rL rM rN rO rP rQ rR rS rT rU rV rW rX rY rZ r[ r\ r] r^ r_ r` ra rb rc rd re rf rg rh ri rj rk rl rm rn ro rp rq rr rs rt ru rv rw rx ry rz r{ r| r} r~ r r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r r r r r r r r r r r
r r r
r r r r r r r r r r r r r r r r r r r r! r" r# r$ r% r� r& r' r( r) r* r+ r, r- r. r/ r0 r1 r2 r3 r4 r5 r6 r7 r8 r9 r: r; r< r= r> r? r@ rA rB rC rD rE rF rG rH rI rJ rK rL rM rN rO rP rQ rR rS rT rU rV rW rX rY rZ r[ r\ r] r^ r_ r` ra rb rc rd re rf rg rh ri rj rk rl rm rn ro rp rq rr rs rt ru rv rw rx ry rz r{ r| r} r~ r r� r� r� )r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� )rM rN rO rP r^ r_ � filenamesr` ra rb rc r
r rd re r r
r rg r r rj r rt r rk r= r= r= r> r p s�
c @ sV e Zd ZdZdZddgZdgZdgZej ej
B Z de fde
jfd e
jd
feej�efeejd d �ejfeejd d �ejfeejd d �ejfd
ee e ej �feej d d �e fdeeee�fde j fde j!fde j!fde j!fde j"fde#jfde#j$fde%fdej&fdej'fdeej e%�fdefdej'j(fgd e
jd
fd e
jd fd e
jfd e
jfgd �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
--(?m).*?$\n?z/\*zmultiline-commentsz\b)rY 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[/*])r] zmultiline-commentsN)*rM rN rO rP r^ r_ r� r` ra rb �UNICODErc r r rd re r r Z OPERATORSr ZOPERATOR_WORDSZWordZTYPESr ZClassZ FUNCTIONS�Functionr r
rq r r ZHexri rj r rt r rg rh ZMagicrk r= r= r= r> r � sB
c @ s� e Zd ZdZdZdgZdgZejZ de
fde j fde j
dfd ejfd
ejfd ej fd ejfd
ejfdefdeeje
e�fdefdejfdejfdeej e
e�fdefdej fdefgde j
dfde j
dfde j
fde j
fgd�Z d S ) r z"
Special lexer for MySQL.
ZMySQLZmysqlz text/x-mysqlz\s+z(#|--\s+).*\n?z/\*zmultiline-commentsz[0-9]+z[0-9]*\.[0-9]+(e[+-][0-9]+)z'(\\\\|\\'|''|[^'])*'z"(\\\\|\\"|""|[^"])*"z`(\\\\|\\`|``|[^`])*`z[+*/<>=~!@#%^&|`?-]a \b(tinyint|smallint|mediumint|int|integer|bigint|date|datetime|time|bit|bool|tinytext|mediumtext|longtext|text|tinyblob|mediumblob|longblob|blob|float|double|double\s+precision|real|numeric|dec|decimal|timestamp|year|char|varchar|varbinary|varcharacter|enum|set)(\b\s*)(\()?a3 \b(add|all|alter|analyze|and|as|asc|asensitive|before|between|bigint|binary|blob|both|by|call|cascade|case|change|char|character|check|collate|column|condition|constraint|continue|convert|create|cross|current_date|current_time|current_timestamp|current_user|cursor|database|databases|day_hour|day_microsecond|day_minute|day_second|dec|decimal|declare|default|delayed|delete|desc|describe|deterministic|distinct|distinctrow|div|double|drop|dual|each|else|elseif|enclosed|escaped|exists|exit|explain|fetch|flush|float|float4|float8|for|force|foreign|from|fulltext|grant|group|having|high_priority|hour_microsecond|hour_minute|hour_second|if|ignore|in|index|infile|inner|inout|insensitive|insert|int|int1|int2|int3|int4|int8|integer|interval|into|is|iterate|join|key|keys|kill|leading|leave|left|like|limit|lines|load|localtime|localtimestamp|lock|long|loop|low_priority|match|minute_microsecond|minute_second|mod|modifies|natural|no_write_to_binlog|not|numeric|on|optimize|option|optionally|or|order|out|outer|outfile|precision|primary|procedure|purge|raid0|read|reads|real|references|regexp|release|rename|repeat|replace|require|restrict|return|revoke|right|rlike|schema|schemas|second_microsecond|select|sensitive|separator|set|show|smallint|soname|spatial|specific|sql|sql_big_result|sql_calc_found_rows|sql_small_result|sqlexception|sqlstate|sqlwarning|ssl|starting|straight_join|table|terminated|then|to|trailing|trigger|undo|union|unique|unlock|unsigned|update|usage|use|using|utc_date|utc_time|utc_timestamp|values|varying|when|where|while|with|write|x509|xor|year_month|zerofill)\bz*\b(auto_increment|engine|charset|tables)\bz(true|false|null)z([a-z_]\w*)(\s*)(\()z [a-z_]\w*z@[a-z0-9]*[._]*[a-z0-9]*z [;:()\[\],.]z\*/z#popz[^/*]+z[/*])r] zmultiline-commentsN) rM rN rO rP r^ r_ r` ra rb rc r
r rd re r rj ri r �Doublert r r r
ZTyper rr r ZConstantr� rh rk r= r= r= r> 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�tj|�D ]�}|j� }|jd�s@|jd�rv|jt|�dtj |d d� fgf� ||dd � 7 }q |r�x t
||j |��D ]
}|V q�W d}g }|jd�r�|j � tj
|fV q |j � tj|fV q W |r�x t
||j |��D ]
}|V q�W d S )Nr} zsqlite> z ...> r � z SQL error: )r rI r� r4 r2 rJ rK r� r r� r r8 r6 Z Tracebackr� )rB r� rE r� r� r. r� r� r= r= r> r8 q s,
z)SqliteConsoleLexer.get_tokens_unprocessedN) rM rN rO rP r^ r_ r� r` r8 r= r= r= r> r e s c @ sr e Zd ZdZdZdgZdgZdgZej Z
dde fde fd e
fd
ejfd ejfd efd
ejfdejfdefg iZdS )r! zx
Lexer for Relation Query Language.
`RQL <http://www.logilab.org/project/rql>`_
.. versionadded:: 2.0
ZRQLZrqlz*.rqlz
text/x-rqlr] 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)rM rN rO rP r^ r_ r� r` ra rb rc r
r
r r rg r rj r rd r rk r= r= r= r> r! � s" )7rP ra Zpygments.lexerr r r r r Zpygments.tokenr r r r
r r r
r r r r Zpygments.lexersr r Z
pygments.utilr Z"pygments.lexers._postgres_builtinsr r r r r �__all__�compiler� rb r- r7 r? �objectr@ r r rs r� r� r� Zre_errorr� ru r r r r r r! r= r= r= r> �<module>' s@ 4
%'8!
Pt8I(