o
    ‡ÎÖa¯…  ã                   @   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-2021 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 ƒ| 	¡ … ¡ƒ}|rB|  |d  d¡¡}nt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 )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   Ú	DelimiterÚget_tokens_unprocessed)Úlexerr2   ÚlxÚm© rA   ú5/usr/lib/python3/dist-packages/pygments/lexers/sql.pyÚlanguage_callbackN   s0   € ÿÿ
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¡r-| |d d… ¡ | d¡r@| d¡r@| |dd… ¡ |D ]}zt|fi | j¤ŽW   S  tyY   Y qBw d 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   —   sV    
ÿÿþê

ü
ý
ý
Ü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 ]\ZZed ekr<eee d	d
�efed e< [ nq!J 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   ó   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   rˆ   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__  ó   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 d	i | j¤Ž}tt |¡ƒ}	 d}g }|D ]Q}| d¡r2|s2td
i | j¤Ž}| |¡E d H   n7t 	|¡}|d urX| 
t|ƒdtj| ¡ fgf¡ ||t| ¡ ƒd … 7 }n||7 }t 	|¡sft |¡rh nqt|| |¡ƒE d H  tj}	|D ]N}t 	|¡}|d ur‹| |¡  n?t 	|¡}
|
d urÁ|
 d¡ d¡s¤|
 d¡ d¡r§tj}	|
 d¡tj|
 d¡fV  |
 d¡|	|
 d¡fV  qyd|	|fV  qyd S q)Nr'   Ú ú$Úconsoler   ÚERRORÚFATALr+   rA   )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>   ÚmpromptÚ	out_tokenÚmmsgrA   rA   rB   r=   6  sV   €

ÿ
ÿþ
ÿ


ÿÌ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_   (ù  Ú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ÚENDz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_NAMEr½   Ú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_NAMEz 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ÚZONErg   rh   )Ú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[+*/<>=~!@#%^&|`?-]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ó  rž   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  sD    
W©X¨Yüû—
l
ü”tr!   c                   @   s^  e Zd ZdZdZddgZdgZdgZej	ej
B 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}|S tt | ¡ƒ}tt | ¡ƒ}|| }|dkr,|d| kr,|d7 }n||kr5|d7 }n|dkr=|d7 }t | ¡d urH|d7 }t | ¡d urS|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   ÚratingÚname_between_backtick_countÚname_between_bracket_countÚdialect_name_countrA   rA   rB   rÑ  .  s.   
ìÿÿ

zTransactSqlLexer.analyse_textN)+rV   rW   rX   rY   ry   rz   rÒ  r{   r|   r}   ÚUNICODEr~   r   r
   r   r€   r   r   Ú	OPERATORSr   ÚOPERATOR_WORDSÚWordÚTYPESr   ÚClassÚ	FUNCTIONSÚFunctionr   r   r’   r   r   ÚHexr„   r…   r   r—   r   r‚   rƒ   ÚMagicr‡   rÑ  rA   rA   rA   rB   r"   ÷  sL    

ã
 
üà(r"   c                   @   sÄ  e Zd ZdZdZdgZdgZejZ	g 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‘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   sp   d}t t | ¡ƒ}t t | ¡ƒ}|| }|dkr$|d| kr$|d7 }|S ||kr.|d7 }|S |dkr6|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   ÚQuotedr   ÚPreprocÚEscaper‡   rÑ  rA   rA   rA   rB   r#   K  sò    ÿü
û
ú	÷
öóòïîíìÿéÿå úá
)×
*Ö-Ó.Ò
/Ñ
0Ð
1Ï2Î5Ë8È9Ç<Ä=Ã>Â?ÿÁH¸
I·L´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 di | j¤Ž}d}g }t |¡D ]`}| ¡ }t |¡}|d urI| t|ƒdt	j
|d d… fgf¡ | t|ƒdtdfgf¡ ||dd … 7 }q|rZt|| |¡ƒE d H  d}g }| d¡ri| ¡ t	j|fV  q| ¡ t	j|fV  q|r‚t|| |¡ƒE d H  d S d S )Nr¤   r   r0   rb   é   zSQL error: rA   )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¹   Úprompt_matchrA   rA   rB   r=     s:   €

ÿ

ÿ
ÿ
ÿÿz)SqliteConsoleLexer.get_tokens_unprocessedN)	rV   rW   rX   rY   ry   rz   rÒ  r{   r=   rA   rA   rA   rB   r$     s    r$   c                   @   sr   e 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%   zx
    Lexer for Relation Query Language.

    `RQL <http://www.logilab.org/project/rql>`_

    .. versionadded:: 2.0
    Ú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   rz   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|   Úpygments.lexerr   r   r   r   r   Úpygments.tokenr   r   r	   r
   r   r   r   r   r   r   r   Úpygments.lexersr   r   Ú"pygments.lexers._postgres_builtinsr   r   r   r   Ú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¯   Úre_errorr²   r˜   r    r!   r"   r#   r$   r%   rA   rA   rA   rB   Ú<module>   sP    '4




$%8!




ÿH T 8)