3
V'ícg
ã @ s$ d Z ddlZddlmZmZmZmZmZ ddlm Z m
Z
m Z m Z m
Z
mZmZmZmZmZmZ ddlmZmZ ddlmZmZmZmZ ddl m Z m Z m Z m Z m!Z! ddlm"Z" d d
d d d
dddgZ#ej$dZ%ej$dZ&ej$dej'Z(ej$dej'Z)ej$dZ*ej$dZ+ej$dej'Z,ej$dej'Z-ej$dZ.dd Z/G d d d Z0G d d d e0eZ1G d d
d
e0eZ2G d d! d!e0eZ3ej$d"Z4ej$d#Z5ej$d$Z6ej$d%Z5ej$d&Z7ej$d'Z8G d(d) d)Z9G d*d d eZ:G d+d d eZ;G d,d
d
eZ<G d-d deZ=G d.d deZ>G d/d deZ?dS )0a
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| 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 dt |jdfV |j dt j |jdfV |j dt |jdfV |r"|j
|jd E dH 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)Úlexerr2 ÚlxÚm© r@ ú7/tmp/pip-build-gk9425m9/Pygments/pygments/lexers/sql.pyÚlanguage_callbackN s* $$
rB c s( e Zd ZdZ fddZdd 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)r3 Úsuperr< )Úselfr3 Úargs)Ú __class__r@ rA r< { s z#PostgresBase.get_tokens_unprocessedc C s¶ |j dkrtd| jS |g}|jdr:|j|dd
|jdrV|j|d d
|jdr||jdr||j|dd
x4|D ](}yt|f| jS tk
r¨ Y qX qW d S d S )
NÚsqlÚ
postgresqlÚplr* Úur' )rI r0 r0 )Úlowerr ÚoptionsÚ
startswithÚappendÚendswithr )rE ÚlangÚtriesr> r@ r@ rA r5 s
zPostgresBase._get_lexer)Ú__name__Ú
__module__Ú __qualname__Ú__doc__r< r5 Ú
__classcell__r@ r@ )rG rA rC r s rC c @ s: e Zd ZdZdZddgZdgZejZ de
fde j fde j
d fd
d jd d
ee D d ejfeeddefdefdefdejfdejfdejfdee j e j dfdee j e jdfde 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 dialectrI Zpostgresztext/x-postgresqlz\s+z--.*\n?z/\*zmultiline-commentsú(ú|c c s | ]}|j d dV qdS )ú z\s+N)Úreplace)Ú.0Úsr@ r@ rA ú <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-commentsr` z quoted-identN)!rS rT rU rV ÚnameÚaliasesÚ mimetypesÚreÚ
IGNORECASEÚflagsr r
ÚSingleÚ MultilineÚjoinr r r
ÚBuiltinr r r r ÚVariabler ÚFloatÚIntegerr r ZAffixrB r Útokensr@ r@ r@ rA r s@
c @ sº e Zd ZdZdZdgZdgZejZ dd e
j j D Z xPe
e d D ]4\ZZed ekrDeee d d
efe d e< [P qDW d std 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 )Nr@ )r\ ÚkÚlr@ r@ rA ú
<dictcomp>Ú s zPlPgsqlLexer.<dictcomp>rc r' z\b)r_ r zSQL keywords not foundz \%[a-z]\w*\bz:=z\<\<[a-z]\w*\>\>z \#[a-z]\w*\bN)rS rT rU rV rd re rf rg rh ri r rq ÚitemsÚ enumerateÚiÚpatternr r r r ÚAssertionErrorr
rm r ÚLabelÚPseudor@ r@ r@ rA r Ï s" c @ s e Zd ZdZdZg ZejZdd e j
j D Z
e
d j 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 )Nr@ )r\ rr rs r@ r@ rA rt ü s zPsqlRegexLexer.<dictcomp>rc z\\[^\s]+z psql-commandz\nz\s+z:(['"]?)[a-z]\w*\b\1z '(''|[^'])*'z `([^`])*`z[^\s]+N)rS rT rU rV rd re rg rh ri r rq ru rO r r{ r r r
rn r rj ZBacktickÚSymbolr@ r@ r@ rA 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)rE Úxr@ r@ rA Ú__init__ s
zlookahead.__init__c C s | S )Nr@ )rE r@ r@ rA Ú__iter__ s zlookahead.__iter__c C s
|| _ |S )N)r )rE rw r@ r@ rA Úsend s zlookahead.sendc C s$ | j d k r| j }d | _ |S t| jS )N)r Únextr )rE Únir@ r@ rA Ú__next__" s
zlookahead.__next__N) rS rT rU rV r r r r r
r@ r@ r@ rA 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}ttj|}x~d}g }x¤|D ]}|jdr^| r^td | j}|j|E d H P tj |}|d k rª|j
t |dt j
|j fgf ||t |j d
7 }n||7 }tj |sÆtj|r,P q,W t||j|E d H t j} x®|D ]¢}tj |}|d k r|j| P tj |}
|
d k r|
jdjdsJ|
jdjdrPt j} |
jdt j|
jdfV |
jd| |
jdfV qîd| |fV qîW d S q W d S )
NÚ ú$Úconsoler r' ÚERRORÚFATALr* )r )r| rM r~ Úline_reÚfindallrN r r< Ú re_promptr2 rO Úlenr ÚPromptr6 Úre_psql_commandÚre_end_commandÚsearchr ÚOutputr Ú
re_messageÚErrorr: ZStrong) rE ÚdatarH ÚlinesÚcurcodeÚ
insertionsÚliner= ZmpromptZ out_tokenZmmsgr@ r@ rA r< 6 sH
z+PostgresConsoleLexer.get_tokens_unprocessedN)rS rT rU rV rd re rf r< r@ r@ r@ rA r + s
c ý @ sê e Zd ZdZdZdgZdgZdgZej Z
de fde j
fde jd fed+ddefed,ddejfd efd ejfd ej
fd ejfd!efd"efg de jd fd#e jd$fd%e jfd&e jfgd'Zd(d) Zd*S (- r! z
Lexer for Structured Query Language. Currently, this lexer does
not recognize any special syntax except ANSI SQL.
ÚSQLrH 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ÚCOALESCEÚ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Ú
CORRESPONDINGÚ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Ú IMMEDIATELYÚ 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ÚPARAMETER_NAMEÚPARAMETER_ORDINAL_POSITIONÚPARAMETER_SPECIFIC_CATALOGÚPARAMETER_SPECIFIC_NAMEÚPARAMETER_SPECIFIC_SCHEMAÚPARTIALÚPASCALÚPENDANTÚPERIODÚPLACINGÚPLIÚPOSITIONÚPOSTFIXÚPRECEEDSÚ 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ÚSUCCEEDSÚSUMÚ SYMMETRICÚSYSIDÚSYSTEMÚ SYSTEM_USERÚTABLEÚ
TABLE_NAMEú TEMPÚTEMPLATEÚ TEMPORARYÚ TERMINATEÚTHANÚTHENÚTIMEÚ TIMESTAMPÚ
TIMEZONE_HOURÚTIMEZONE_MINUTEÚTOÚTOASTÚTRAILINGÚ TRANSACTIONÚTRANSACTIONS_COMMITTEDÚTRANSACTIONS_ROLLED_BACKÚTRANSACTION_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ÚVERSIONSÚ
VERSIONINGÚVIEWÚVOLATILEÚWHENÚWHENEVERÚWHEREÚWITHÚWITHOUTÚWORKÚWRITEÚYEARÚZONEz\b)r_ Ú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[/*])rc zmultiline-commentsc C s d S )Nr@ )rE r3 r@ r@ rA Ú analyse_textó s zSqlLexer.analyse_textN(ù r r r r¡ r¢ r£ r¤ r¥ r¦ r§ r¨ r© rª r« r¬ r r® r¯ r° r± r² r³ r´ rµ r¶ r· r¸ r¹ rº r» r¼ r½ r¾ r¿ rÀ rÁ r rà rÄ rÅ rÆ rÇ rÈ rÉ rÊ rË rÌ rÍ rÎ rÏ rÐ rÑ rÒ rÓ rÔ rÕ rÖ r× rØ rÙ rÚ rÛ rÜ rÝ rÞ rß rà rá râ rã rä rå ræ rç rè ré rê rë rì rí rî rï rð rñ rò ró rô rõ rö r÷ rø rù rú rû rü rý rþ rÿ r r r r r r r r r r r
r r r
r r r r r r r r r r 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/ r0 r1 r2 r3 r4 r 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® )rS rT rU rV rd re Ú filenamesrf rg rh ri r r
rj rk r r r
rm r r rp r r} r rq r¯ r@ r@ r@ rA r! s sæ
c @ sX e Zd ZdZdZddgZdgZdgZej Z
de fde j
fd e jd
feejefeejd d ejfeejd d ejfeejd d ejfd
eee ej feej d d efdeeeefde 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)r_ 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[/*])rc zmultiline-commentsc C s¨ d}t j| rd}nttj| }ttj| }|| }|dkrV|d| krV|d7 }n"||krh|d7 }n|dkrx|d7 }tj| d k r|d7 }tj| 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)r3 ÚratingÚname_between_backtick_countÚname_between_bracket_countÚdialect_name_countr@ r@ rA r¯ . s(
z TransactSqlLexer.analyse_textN)*rS rT rU rV rd re r° rf rg rh ri r r
rj rk r r Z OPERATORSr ZOPERATOR_WORDSÚWordÚTYPESr
ZClassZ FUNCTIONSÚFunctionr r rz r r ÚHexro rp r r} r rm rn ZMagicrq r¯ r@ r@ r@ rA 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
efe 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&d0e 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*\}ra zsingle-quoted-stringrb 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)Úprefixr_ z \b(\s*)(\()u [0-9a-z$_Â-ï¿¿]+ú`zschema-object-namez[(),.;]z[^*a-z]+z\*/z#pop)r_ z[a-z]+z\*z[^*]+z[^'\\]+z''z\\[0'"bnrtZ\\%_]z[^"\\]+z""z[^']+z[^"]+z[^`]+z``) rc zoptimizer-hintszmultiline-commentzsingle-quoted-stringzdouble-quoted-stringzsingle-quoted-variablezdouble-quoted-variablezbacktick-quoted-variablezschema-object-namec C sl d}t tj| }t tj| }|| }|dkrF|d| krF|d7 }n"||krX|d7 }n|dkrh|d7 }|S )Nr r' r* g à?gÉ?g¹?)r r² r r³ )r3 r¶ r· r¸ r¹ r@ r@ rA r¯ ï s
zMySqlLexer.analyse_textN),rS rT rU rV rd re rf rg rh ri r r
rj ÚSpecialrk r r½ ZBinro rp r ÚDater ÚDoubler
rn r r r r r ÚConstantr ÚTyper r r¼ r ZQuotedr ZPreprocZEscaperq r¯ r@ r@ r@ rA r# K 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 }tj|}|d k r|jt|dt j
|d d
fgf |jt|dt dfgf ||dd
7 }q |r°t ||j
|E d H d}g }|jdrÎ|j t j|fV q |j t j|fV q W |rþt ||j
|E d H d S )Nr r r/ rZ é z SQL error: )r! rM r r8 r6 Úsqlite_prompt_rer2 rO r r r r r r< rN r: Ú Tracebackr )rE r rH r r r2 r Z prompt_matchr@ r@ rA r< s.
z)SqliteConsoleLexer.get_tokens_unprocessedN) rS rT rU rV rd re r° rf r< r@ r@ r@ rA 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-rqlrc 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)rS rT rU rV rd Úurlre r° rf rg rh ri r r r r
rm r rp r rj r rq r@ r@ r@ rA r% + s$ )@rV rg 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 Z pygments.lexers._mysql_builtinsr r r r r r Ú__all__Úcompiler rÆ rh r1 r; r³ r² rµ r± r´ rB rC r r r| r r r Zre_errorr r~ r r! r" r# r$ r% r@ r@ r@ rA Ú<module>& sP 4
$%8!
H T 8)