3
.ßL]V{  ã               @   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 ddlmZmZmZmZ ddlmZ d	d
ddddddgZej dƒZ!ej dej"ƒZ#ej dej"ƒZ$ej dƒZ%ej dƒZ&ej dej"ƒZ'ej dej"ƒZ(ej dƒZ)dd„ Z*G dd„ de+ƒZ,G dd	„ d	e,eƒZ-G dd
„ d
e,eƒZ.G dd „ d e,eƒZ/ej d!ƒZ0ej d"ƒZ1ej d#ƒZ2ej d$ƒZ1ej d%ƒZ3ej d&ƒZ4G d'd(„ d(e+ƒZ5G d)d„ deƒZ6G d*d„ deƒZ7G d+d„ deƒZ8G d,d„ deƒZ9G d-d„ deƒZ:G d.d„ deƒZ;dS )/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-2019 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\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 … ƒ}|dk	r>| j|jdƒƒ}n|tt j| jtd|j	ƒ d ƒ|j	ƒ … ƒƒ}|r‚| j|d jdƒƒ}n8tt
j| jtd|j	ƒ d ƒ|j	ƒ … ƒƒ}|rº| jdƒ}|j	dƒt|jdƒfV  |j	dƒtj|jdƒfV  |j	dƒt|jdƒfV  |�r.x:|j|jd	ƒƒD ]}|V  �qW n|j	d	ƒt|jd	ƒfV  |j	d
ƒt|jd
ƒfV  |j	dƒtj|jdƒfV  |j	dƒt|j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   Z	DelimiterÚget_tokens_unprocessed)Úlexerr.   ÚlÚmÚx© r=   ú9/tmp/pip-install-5sebvq2j/pygments/pygments/lexers/sql.pyÚlanguage_callbackH   s,     $$
r?   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             '   s0   || _ x$tt| ƒj|f|žŽ D ]
}|V  qW d S )N)r/   Úsuperr@   r8   )Úselfr/   Úargsr<   )Ú	__class__r=   r>   r8   v   s    z#PostgresBase.get_tokens_unprocessedc             C   s¶   |j ƒ dkrtd| jŽS |g}|jdƒr:|j|dd … ƒ |jdƒrV|j|d d… ƒ |jdƒr||jdƒr||j|dd	… ƒ x4|D ](}yt|f| jŽS  tk
r¨   Y q‚X q‚W d S d S )
NÚsqlÚ
postgresqlÚplr&   Úur#   )rF   r,   r,   )Úlowerr   ÚoptionsÚ
startswithÚappendÚendswithr   )rB   ÚlangÚtriesr:   r=   r=   r>   r1   }   s    



zPostgresBase._get_lexer)Ú__name__Ú
__module__Ú__qualname__Ú__doc__r8   r1   Ú__classcell__r=   r=   )rD   r>   r@   m   s   r@   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j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 dialectrF   Zpostgresztext/x-postgresqlz\s+z--.*\n?z/\*zmultiline-commentsú(ú|c             c   s   | ]}|j d dƒV  qdS )ú z\s+N)Úreplace)Ú.0Úsr=   r=   r>   ú	<genexpr>¥   s   zPostgresLexer.<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""ú")Úrootzmultiline-commentsr]   zquoted-identN)!rP   rQ   rR   rS   ÚnameÚaliasesÚ	mimetypesÚreÚ
IGNORECASEÚflagsr
   r   ÚSingleÚ	MultilineÚjoinr   r   r   ÚBuiltinr   r   r   r   ÚVariabler   ÚFloatÚIntegerr   r   ZAffixr?   r   Útokensr=   r=   r=   r>   r   ”   s>   
$


c               @   s¾   e Zd ZdZdZdgZdgZejZ	e
dd„ eejƒD ƒƒZxPeed ƒD ]4\ZZed ekrHeee d	d
�efed e< [P qHW dsŒt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"   | ]\}}||d d … fV  qd S )Nr=   )rY   Úkr:   r=   r=   r>   r[   ×   s    zPlPgsqlLexer.<genexpr>r`   r#   z\b)r\   r   zSQL keywords not foundz\%[a-z]\w*\bz:=z\<\<[a-z]\w*\>\>z\#[a-z]\w*\bN)rP   rQ   rR   rS   ra   rb   rc   rd   re   rf   Údictr   r   rn   Ú	enumerateÚiÚpatternr   r   r   r   ÚAssertionErrorr   rj   r   ÚLabelÚPseudor=   r=   r=   r>   r   Ì   s"   c               @   sŠ   e Zd ZdZdZg ZejZe	dd„ e
ejƒD ƒƒZed j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"   | ]\}}||d d … fV  qd S )Nr=   )rY   ro   r:   r=   r=   r>   r[   ù   s    zPsqlRegexLexer.<genexpr>r`   z\\[^\s]+zpsql-commandz\nz\s+z:(['"]?)[a-z]\w*\b\1z'(''|[^'])*'z	`([^`])*`z[^\s]+N)rP   rQ   rR   rS   ra   rb   rd   re   rf   rp   r   r   rn   rL   r   rv   r
   r   rk   r   rg   ZBacktickÚSymbolr=   r=   r=   r>   rw   í   s   rw   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 )N)ÚiterÚ	_nextitem)rB   r<   r=   r=   r>   Ú__init__  s    
zlookahead.__init__c             C   s   | S )Nr=   )rB   r=   r=   r>   Ú__iter__  s    zlookahead.__iter__c             C   s
   || _ |S )N)r{   )rB   rr   r=   r=   r>   Úsend  s    zlookahead.sendc             C   s$   | j d k	r| j }d | _ |S t| jƒS )N)r{   Únextrz   )rB   Únir=   r=   r>   Ú__next__  s
    
zlookahead.__next__N)	rP   rQ   rR   rS   r|   r}   r~   r�   r   r=   r=   r=   r>   ry     s   ry   c               @   s,   e Zd ZdZdZdddgZdgZdd„ Zd	S )
r   z=
    Lexer for psql sessions.

    .. versionadded:: 1.5
    zPostgreSQL console (psql)Zpsqlzpostgresql-consolezpostgres-consoleztext/x-postgresql-psqlc             c   s¶  t f | jŽ}ttj|ƒƒ}�x”d}g }x®|D ]¦}|jdƒrh| rhtd	| jŽ}x|j|ƒD ]
}|V  qXW P tj	|ƒ}	|	d k	r´|j
t|ƒdtj|	jƒ fgfƒ ||t|	jƒ ƒd … 7 }n||7 }tj	|ƒsÐtj|ƒr,P q,W xt||j|ƒƒD ]
}
|
V  qèW tj}x°|D ]¤}tj	|ƒ}	|	d k	�r&|j|ƒ P tj	|ƒ}|d k	�r˜|jdƒjdƒ�s^|jdƒjdƒ�rdtj}|jdƒtj|jdƒfV  |jdƒ||jdƒfV  nd||fV  �qW d S qW d S )
NÚ ú$Úconsoler   r#   ÚERRORÚFATALr&   )r„   )rw   rJ   ry   Úline_reÚfindallrK   r   r8   Ú	re_promptr.   rL   Úlenr   ÚPromptr2   Úre_psql_commandÚre_end_commandÚsearchr   ÚOutputr~   Ú
re_messager	   r6   ZStrong)rB   ÚdatarE   ÚlinesÚcurcodeÚ
insertionsÚliner9   r<   ZmpromptÚitemZ	out_tokenZmmsgr=   r=   r>   r8   2  sL    












z+PostgresConsoleLexer.get_tokens_unprocessedN)rP   rQ   rR   rS   ra   rb   rc   r8   r=   r=   r=   r>   r   '  s
   
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.
    ÚSQLrE   z*.sqlz
text/x-sqlz\s+z--.*\n?z/\*zmultiline-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)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[/*])r`   zmultiline-commentsc             C   s   dS )Ng{®Gáz„?r=   )r/   r=   r=   r>   Úanalyse_textä  s    zSqlLexer.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)  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›  rœ  r�  rž  rŸ  r   r¡  )rP   rQ   rR   rS   ra   rb   Ú	filenamesrc   rd   re   rf   r
   r   rg   rh   r   r   r   rj   r   r   rm   r   rx   r   rn   r¢  r=   r=   r=   r>   r   q  sÌ   
                                                                            





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-SQLZtsqlzt-sqlz*.sqlztext/x-tsqlz\s+z(?m)--.*?$\n?z/\*zmultiline-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[/*])r`   zmultiline-commentsc             C   s¨   d}t j| ƒrd}n�ttj| ƒƒ}ttj| ƒƒ}|| }|dkrV|d| krV|d7 }n"||krh|d7 }n|dkrx|d7 }tj| ƒd k	rŽ|d7 }tj| ƒd k	r¤|d7 }|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)r/   ÚratingÚname_between_backtick_countÚname_between_bracket_countÚdialect_name_countr=   r=   r>   r¢    s&    


zTransactSqlLexer.analyse_textN)+rP   rQ   rR   rS   ra   rb   r£  rc   rd   re   ÚUNICODErf   r   r   rg   rh   r   r   Z	OPERATORSr   ZOPERATOR_WORDSÚWordÚTYPESr   ZClassZ	FUNCTIONSÚFunctionr   r   ru   r   r   ZHexrl   rm   r   rx   r   rj   rk   ZMagicrn   r¢  r=   r=   r=   r>   r   è  sD   


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fd
ejfdejfdejfdejfdefdeeje
eƒfdefdejfdejfdeeje
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œZdd„ ZdS )r   z"
    Special lexer for MySQL.
    ZMySQLZmysqlztext/x-mysqlz\s+z(#|--\s+).*\n?z/\*zmultiline-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`   zmultiline-commentsc             C   sl   d}t tj| ƒƒ}t tj| ƒƒ}|| }|dkrF|d| krF|d7 }n"||krX|d7 }n|dkrh|d7 }|S )Nr   r#   r&   g      à?gš™™™™™É?gš™™™™™¹?)rŠ   r¥  rˆ   r¦  )r/   r©  rª  r«  r¬  r=   r=   r>   r¢  ƒ  s    

zMySqlLexer.analyse_textN) rP   rQ   rR   rS   ra   rb   rc   rd   re   rf   r
   r   rg   rh   r   rm   rl   r   ÚDoublerx   r   r   r   ÚTyper   rv   r   ÚConstantr°  rk   rn   r¢  r=   r=   r=   r>   r   ;  s<   


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
    Z
sqlite3conZsqlite3z*.sqlite3-consoleztext/x-sqlite3-consolec             c   sþ   t f | jŽ}d}g }xÀtj|ƒD ]²}|jƒ }|jdƒs@|jdƒrv|jt|ƒdtj	|d d… fgfƒ ||dd … 7 }q |r¢xt
||j|ƒƒD ]
}|V  qŒW d}g }|jdƒrÀ|jƒ tj|fV  q |jƒ tj|fV  q W |rúxt
||j|ƒƒD ]
}|V  qìW d S )Nr‚   zsqlite> z   ...> r   é   zSQL error: )r   rJ   r‡   r4   r2   rK   rL   rŠ   r   r‹   r   r8   r6   Ú	Tracebackr�   )rB   r‘   rE   r“   r”   r.   r•   r–   r=   r=   r>   r8   ¡  s,    


z)SqliteConsoleLexer.get_tokens_unprocessedN)	rP   rQ   rR   rS   ra   rb   r£  rc   r8   r=   r=   r=   r>   r    •  s   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
    ZRQLZrqlz*.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)rP   rQ   rR   rS   ra   rb   r£  rc   rd   re   rf   r
   r   r   r   rj   r   rm   r   rg   r   rn   r=   r=   r=   r>   r!   ½  s"   )<rS   rd   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.utilr   Z"pygments.lexers._postgres_builtinsr   r   r   r   r   Ú__all__Úcompiler‡   re   r-   r7   r¦  r¥  r¨  r¤  r§  r?   Úobjectr@   r   r   rw   r‰   rŒ   r�   Zre_errorr�   ry   r   r   r   r   r    r!   r=   r=   r=   r>   Ú<module>'   sJ   4



%'8!




JwSZ(