
    ,h                        d Z ddl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mZ ddlmZm Z m!Z!m"Z"m#Z# ddlm$Z$ dd	lm%Z% g d
Z& ejN                  d      Z( ejN                  d      Z) ejN                  dejT                        Z+ ejN                  dejT                        Z, ejN                  d      Z- ejN                  d      Z. ejN                  dejT                        Z/ ejN                  dejT                        Z0 ejN                  d      Z1e$jd                  e$jf                  z   e$jh                  z   Z5d Z6 G d d      Z7 G d de7e      Z8 G d de7e      Z9 G d de7e      Z: ejN                  d      Z; ejN                  d      Z< ejN                  d      Z= ejN                  d       Z< ejN                  d!      Z> ejN                  d"      Z? G d# d$      Z@ G d% d&e      ZA G d' d(e      ZB G d) d*e      ZC G d+ d,e      ZD G d- d.e      ZE G d/ d0e      ZF G d1 d2e      ZG G d3 d4e      ZHy)5a  
    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-2025 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)_googlesql_builtins)_tsql_builtins)
GoogleSqlLexer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           
   #   Z  K   d}t         j                  | j                  |j                         |j                         dz          }|!| j	                  |j                  d            }nt        t         j                  | j                  t        d|j                         dz
        |j                                      }|r$| j	                  |d   j                  d            }ngt        t        j                  | j                  t        d|j                         dz
        |j                                      }|r| j	                  d      }|j                  d      t        |j                  d      f |j                  d      t        j                  |j                  d      f |j                  d	      t        |j                  d	      f |r)|j                  |j                  d
            E d{    n)|j                  d
      t        |j                  d
      f |j                  d      t        |j                  d      f |j                  d      t        j                  |j                  d      f |j                  d      t        |j                  d      f y7 w)zParse 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.
    Nd      r      plpgsql                  )language_rematchtextend
_get_lexergrouplistfinditermaxstartdo_rer   	Delimiterget_tokens_unprocessed)lexerr8   lxms       U/var/www/html/Resume-Scraper/venv/lib/python3.12/site-packages/pygments/lexers/sql.pylanguage_callbackrH   Y   s      
B%**UYY[SABA}aggaj)%%JJs1ekkmC/0?A B!!!B%++a.1BU^^

3q%++-"23EKKMBD EA%%i0 ;;q>65;;q>
22;;q>6++U[[^
<<;;q>65;;q>
22	,,U[[^<<<{{1~vu{{1~66;;q>65;;q>
22;;q>6++U[[^
<<;;q>65;;q>
22 	=s   G2J+4J)5B5J+c                   (     e Zd ZdZ fdZd Z x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              '   P   K   || _         t        |   |g| E d {    y 7 wN)r9   superrC   )selfr9   args	__class__s      rG   rC   z#PostgresBase.get_tokens_unprocessed   s&     	71$>>>>s   &$&c                    |j                         dk(  rt        di | j                  S |g}|j                  d      r|j	                  |dd         |j                  d      r|j	                  |d d        |j                  d      r%|j                  d      r|j	                  |dd        |D ]  }	 t        |fi | j                  c S  y # t        $ r Y )w xY w)Nsqlplr1   ur.   )
postgresql)lowerr   options
startswithappendendswithr   )rN   langtriesrE   s       rG   r;   zPostgresBase._get_lexer   s    ::<5 $BT\\BB??4 LLab"==LLcr#??4 T]]3%7LLa$ 	B(<t||<<	  ! s   2C	CC)__name__
__module____qualname____doc__rC   r;   __classcell__)rP   s   @rG   rJ   rJ   }   s    ?
    rJ   c                      e Zd ZdZdZddgZdgZdZdZe	j                  Zdefd	ej                  fd
ej                  dfddj!                  d eez   D              z   dz   ej(                  f eed      efdefdefdej2                  fdej6                  fdej8                  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j2                  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"y*)+r"   z2
    Lexer for the PostgreSQL dialect of SQL.
    zPostgreSQL SQL dialectrU   postgresztext/x-postgresqlhttps://www.postgresql.org1.5\s+--.*\n?/\*multiline-comments(|c              #   @   K   | ]  }|j                  d d        yw) rg   N)replace).0ss     rG   	<genexpr>zPostgresLexer.<genexpr>   s%      @!" YYsF3 @s   z)\b\bsuffixz[+*/<>=~!@#%^&|`?-]+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[^/*]+[/*][^']+'''[^"]+""")rootrj   rx   ry   N)#r]   r^   r_   r`   namealiases	mimetypesurlversion_addedre
IGNORECASEflagsr	   r   Single	Multilinejoinr   r   r   Builtinr   r   r   r   Variabler   FloatIntegerr   r   AffixrH   r   tokens rb   rG   r"   r"      s    $DZ(G$%I
&CMMME Z (W&&(<=CHH @&/,&>@ @ @BHI\\ 8E*G4$h/Ht}}%6E'v}} ExPhv||V[[A>R46GH4  )$--8,-
2 W&&(<=W&&/))*g''(	
 v}}%FMM"6==&)
 v{{#FKK 6;;'
I)Frb   r"   c            	          e Zd ZdZdZdgZdgZdZdZe	j                  Zej                  j                         D  ci c]  \  }}||dd  c}}} Z eed         D ]%  \  ZZed	   ek(  s eeez   d
      efed   e<   [ n J d       dej.                  fdefdej2                  fdej4                  fged   dd yc c}}} w )r#   z7
    Handle the extra syntax in Pl/pgSQL language.
    zPL/pgSQLr0   ztext/x-plpgsqlz4https://www.postgresql.org/docs/current/plpgsql.htmlrf   Nr   r-   rs   rt   r   zSQL keywords not foundz\%[a-z]\w*\bz:=z\<\<[a-z]\w*\>\>z\#[a-z]\w*\b)r]   r^   r_   r`   r   r   r   r   r   r   r   r   r"   r   items	enumerateipatternr   r   r   r   r   r   r   LabelPseudorp   r   states   000rG   r#   r#      s    DkG!"I
@CMMME2?2F2F2L2L2NOO$dE!HnOF  v/ +
71: h!11%@!F6N1 + 	+** 
$,,'		djj)	'..)	F6N2A Ps   B?r#   c            	          e Zd ZdZdZg Zej                  Ze	j                  j                         D  ci c]  \  }}||dd  c}}} 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<   yc c}}} w )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 lexerNr   z\\[^\s]+zpsql-commandz\nrg   rz   '(''|[^'])*'z	`([^`])*`z[^\s]+)r]   r^   r_   r`   r   r   r   r   r   r"   r   r   rY   r   r   r
   r	   r   r   r   r   BacktickSymbolr   s   000rG   r   r      s     5DGMME2?2F2F2L2L2NOO$dE!HnOF
6N	gnnn57 
f		gnn%	$dmm4	&--(	v'	FMM"F>	 Ps   B9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                   ,    e Zd ZdZd Zd Zd Zd ZeZy)	lookaheadz0Wrap an iterator and allow pushing back an item.c                 2    t        |      | _         d | _        y rL   )iter	_nextitem)rN   xs     rG   __init__zlookahead.__init__#  s    G	rb   c                     | S rL   r   )rN   s    rG   __iter__zlookahead.__iter__'  s    rb   c                     || _         |S rL   )r   )rN   r   s     rG   sendzlookahead.send*  s    rb   c                 n    | j                   | j                   }d | _         |S t        | j                        S rL   )r   nextr   )rN   nis     rG   __next__zlookahead.__next__.  s/    >>%B!DNIDIIrb   N)	r]   r^   r_   r`   r   r   r   r   r   r   rb   rG   r   r   !  s     : Drb   r   c                   4    e Zd ZdZdZg dZdgZdZdZdZ	d Z
y	)
r$   z"
    Lexer for psql sessions.
    zPostgreSQL console (psql))psqlzpostgresql-consolezpostgres-consoleztext/x-postgresql-psqlre   rf   zpsql/psql_session.txtc              #     K   t        di | j                  }t        t        j	                  |            }	 d}g }|D ]  }|j                  d      r2|s0t        d	i | j                  }|j                  |      E d {     nt        j                  |      }|\|j                  t        |      dt        j                  |j                         fgf       ||t        |j                               d  z  }n||z  }t        j                  |      st         j#                  |      s n t%        ||j                  |            E d {    t        j&                  }	|D ]  }t        j                  |      }||j)                  |        nt*        j                  |      }
|
|
j                  d      j                  d      s |
j                  d      j                  d      rt        j,                  }	|
j/                  d      t        j0                  |
j                  d      f |
j/                  d      |	|
j                  d      f d|	|f  y  7 7 w)
Nr-    $r   ERRORFATALr1   r   )console)r   rW   r   line_refindallrX   r   rC   	re_promptr8   rY   lenr   Promptr<   re_psql_commandre_end_commandsearchr   Outputr   
re_messageErrorr@   Strong)rN   datarR   linescurcode
insertionslinerD   mprompt	out_tokenmmsgs              rG   rC   z+PostgresConsoleLexer.get_tokens_unprocessedC  s!    ,t||,'//$/0  GJ ??3'-H4<<HE$;;DAAA $//$/&%%s7|)*GNNGMMO(L'M'O PtC$8$9::GtOG
 #((1$++G4+0 %Z%(%?%?%HJ J J  I #//$/&JJt$!''-#zz!}//8**Q-227;$+MM	::a='..$**Q-HH::a=)TZZ]CCi.." i  B(Js,   A:I<I=B(I&!IIDIIN)r]   r^   r_   r`   r   r   r   r   r   _examplerC   r   rb   rG   r$   r$   7  s/     'D@G)*I
&CM&H:rb   r$   c                      e Zd ZdZdZdgZdgZdgZdZdZ	g de
fd	efd
 eej                  e
      dfd eej                  ee
      df edd      ej"                  fd eej"                  e      fdej(                  fd eej*                  e
      dfd eej*                  e
e      dfd eee
e      df edd      ej*                  dfdej*                  dfd eeeej.                  e      df edd      ej*                  f edd      ej0                  fd eej0                  e
e      f eed      efd ej4                  fd!ej*                  fd"ej*                  fd#ej*                  fd$ eeeej6                        fd%e
dfd&ej"                  fd'ej:                  fd(ej.                  fd)ej<                  fd*ej"                  fd+ eej*                  e
e      d,fd- eej*                  e
      fd.ej(                  fd/ eej*                  eej6                  e
e      fd0e
d1fd2e
d3fd4ej0                  fd5efgd6 eej                  e
      dfd7 eej                  ee
      dfd0e
d8fd9e
fd:ej6                  fd;ej6                  fd<ej6                  fd=e
dfd>e
dfd?ej6                  fd@ej6                  fdAej6                  fdBej6                  fdCej6                  fdDefdEe
fdFe
fd2e
d3fgdG ee
ej6                  e
      d3fdHej6                  d3fgdIe
fdDefdJej                  fdKej:                  fdLej.                  fd2e
d3fgdM eej*                  ej6                        fdNej*                  dfdOej*                  dfgdP eej>                  eeee      fdQe
fgd0e
fdRej6                  fd2e
d3fgdSe
fdTej@                  fdUej0                  fdLej.                  fdDefgdV	Z!yW)Xr%   z*
    Handle PostgreSQL EXPLAIN output
    zPostgreSQL EXPLAIN dialectzpostgres-explainz	*.explainztext/x-postgresql-explainz:https://www.postgresql.org/docs/current/using-explain.htmlz2.15z(:|\(|\)|ms|kB|->|\.\.|\,|\/)z(\s+)z
(cost)(=?)instrumentationz(actual)( )(=?))actualzMemory Usagez
Disk UsageMemoryBucketsBatches
originallyrowrowsHitsMisses	Evictions	OverflowszPlanned Partitionsrs   rt   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)(:)( ))Join FilterzSubplans RemovedFilterz
Merge Condz	Hash Condz
Index CondzRecheck CondzHeap BlockszTID CondzRun ConditionzOrder ByzFunction CallzTable Function CallzInner UniquezParams EvaluatedzSingle CopySamplingzOne-Time Filterr   	Relationsz
Remote SQL	predicatez	Conflict conflictz(InitPlan|SubPlan)( )(\d+)( )	init_plan)zSort Methodr   zPlanning timezPlanning TimezExecution timezExecution TimezWorkers PlannedzWorkers LaunchedBuffersPlanningWorkerzQuery IdentifierTimezFull-sort GroupszPre-sorted Groups)zRows Removed by Join FilterzRows Removed by FilterzRows Removed by Index RecheckzHeap Fetchesznever executedz(I/O Timings)(:)( )z"((Right|Left|Full|Semi|Anti) Join)z%(Parallel |Async |Finalize |Partial )Backwardz(Intersect|Except|Hash)z(CTE)( )(\w*)?z
(on|using)r   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\)r|   z(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"rv   z::\w+z +r   z
\[\.\.\.\]z(\()([^\n]*)(\))z[^\n]*z=|\.\.z(rows|width|time|loops)z\d+\.\d+z(\d+)z(Resolution: )(\w+)z(Arbiter \w+:)z
(Filter: )z ([a-z_]*?)(\s*)(=)(\s*)(\'.*?\')z\, zreturns \$\d+(,\$\d+)?z:|kBz.(quicksort|top-N|heapsort|Average|Memory|Peak)z(external|merge|Disk|sort))	r   r   r   r   r   r   r   r   r   N)"r]   r^   r_   r`   r   r   	filenamesr   r   r   r   r	   r   r   Classr   r   r   r   r   r   Preprocr   r   	Exceptionr   Typer   r   r   Constant	AttributePrepocr   r   rb   rG   r%   r%     s    (D!"GI,-I
FCM]
-{;]
z"]
 HTZZ=?PQ]
  $**j+!NPab]
  DLQS ^^]
 ?Ya@bc]
  $W^^4!]
& "8GOO[#I6R']
, Bgoo{J?P-]
0 -hwZ.XZgh1]
6  /
 8=> __k+7]
H 7??J7I]
N .gz6>>:FO]
V  = FK	L NU__	^W]
f  6  ! #'..2g]
n $Xdnnk:%VWo]
r #E2G<s]
x 3GLLAy]
z 6wG{]
| '//*}]
~ (9]
B *dmm LMC]
J K7K]
R fmm,S]
V FLL)W]
X (Y]
^ dmm,_]
b (8c]
f !(7??K"TV_`g]
l 28GOO[3YZm]
n XY`YgYgho]
t (gooz4==+zZ\u]
B K)K( $..1 
 htzz;?ARS!8DJJ
K#PRcd K.k"6F)4==9' [-0;. +DMM:*DMM:. t}}%t}}%J;K(K(? 
F !(;{"SU[\v.	
 $J'4&,,'v~~&K(
 $Xgoot}}%MN?GOO[9
 1(4>>:W_akms2tu[!

 K &6K(
 k">O*DNN;v~~&J
IkFrb   r%   c                      e Zd ZdZdZdgZdgZdgZdZdZ	e
j                  Zdefd	ej                  fd
ej                   df edd      ef edd      ej(                  fdefdej.                  fdej                  fdej2                  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 Zy)r&   z
    Lexer for Structured Query Language. Currently, this lexer does
    not recognize any special syntax except ANSI SQL.
    SQLrR   *.sqlz
text/x-sqlz!https://en.wikipedia.org/wiki/SQLr   rg   rh   ri   rj   (  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ZONErs   rt   )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[+*/<>=~!@#%^&|`?-]rw   r   "(""|[^"])*"z[a-z_][\w$]*[;:()\[\],.]r{   r|   r}   r~   r   rj   c                      y rL   r   )rN   r9   s     rG   analyse_textzSqlLexer.analyse_text  s    rb   N)r]   r^   r_   r`   r   r   r   r   r   r   r   r   r   r	   r   r   r   r   r   r   r   r   r   r   r   r   r   r   r  r   rb   rG   r&   r&   :  s@   
 DgG	II
-CMMME Z (W&&(<= W)n 27oW8p qXr  A JO	P
 \\ $X.'fmm,fmm,d#k*Sj
X W&&(<=W&&/))*g''(	
YrFhrb   r&   c                      e Zd ZdZdZddgZdgZdgZdZdZ	e
j                  Zd	efd
ej                  fdej                   df eej&                        ef eej*                  d      ej,                  f eej.                  d      ej2                  f eej4                  d      ej6                  fd eeeej<                        f eej>                  d      efd eeee      fde jB                  fde jD                  fde jD                  fde jD                  fde jF                  fde$j                  fde$jJ                  fde&fdejN                  fdejP                  fd eej<                  e&      fdefdejP                  jR                  fgdej                   dfdej                   dfd ej                   fd!ej                   fgd"Z*d# Z+y$)%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-tsqlzhttps://www.tsql.infor   rg   z--.*[$|\n]?ri   rj   rs   rt   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]+rw   r   r
  z[;(),.]z@@\w+z@\w+z(\w+)(:)z#?#?\w+\?r{   r|   r}   r~   r  c                 v   d}t         j                  |       rd}|S t        t        j	                  |             }t        t
        j	                  |             }||z   }|dk\  r|d|z  k\  r|dz  }n||kD  r|dz  }n
|dkD  r|dz  }t        j                  |       |dz  }t        j                  |       |dz  }|S )Nr   g      ?r-   r1         ?皙?皙?)tsql_declare_rer   r   name_between_backtick_rer   name_between_bracket_retsql_variable_re
tsql_go_rer9   ratingname_between_backtick_countname_between_bracket_countdialect_name_counts        rG   r  zTransactSqlLexer.analyse_text  s    !!$'F, ) +.(006+8'),'//5*7&
 "=?Y!Y!Q&)Q1L-LL#+.II#+a/#&&t,8#  &2#rb   N),r]   r^   r_   r`   r   r   r   r   r   r   r   r   r   r	   r   r   r   r   r    	OPERATORSr   OPERATOR_WORDSWordTYPESr   r   	FUNCTIONSFunctionr   r   r   r   r   Hexr   r   r   r   r   r   r   Magicr   r  r   rb   rG   r'   r'     s    DwG	II
!CMMME Z W^^,W&&(<=>++,h7>00?O>''6

C>++E:DMMJ"HWj$**$MN>**597C(D(!CDVZZ(-v||<'6"FLL1'fmm,fmm,% t||$dmm$(4::{;<DMM''(;
@ W&&(<=W&&/))*g''(	
A&FPrb   r'   c                      e Zd ZdZdZdgZdgZdZd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j2                  dfdej6                  fdej6                  fdej6                  dfd ej6                  d!fd"ej6                  d#fd$ej6                  fd%efd&efd' eeee      f ee d(d()      ejB                  f ee"d(d()      ejF                  f ee$d(d()      ef ee%d(d*)       eejL                  ee'      fd+efd,ejP                  d-fd.e'fd/ej                  fd0ej                  d1f ee)d(2      ejT                  fd3ej                  fd4ej                  fgd5ej                   fd0ej                   d1fd4ej                   fgd6ej                  fd7ejV                  fd8ejV                  fdej                  d1fgd9ej2                  fd:ejV                  fd8ejV                  fdej2                  d1fgd;ej6                  fd7ej6                  fdej6                  d1fgd<ej6                  fd:ej6                  fdej6                  d1fgd=ej6                  fd>ej6                  fd,ej6                  d1fgd=ejP                  fd>ejP                  jV                  fd,ejP                  d1fgd?	Z,d@ Z-yA)Br(   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-mysqlzhttps://www.mysql.comr   rg   (?:#|--\s+).*z/\*\+optimizer-hintsri   multiline-commentx'([0-9a-f]{2})+'r  b'[01]+'0b[01]+r  [0-9]*\.[0-9]+(e[+-]?[0-9]+)?r  "[0-9]+(?=[^0-9a-z$_\u0080-\uffff])I\{\s*d\s*(?P<quote>['\"])\s*\d{2}(\d{2})?.?\d{2}.?\d{2}\s*(?P=quote)\s*\}Z\{\s*t\s*(?P<quote>['\"])\s*(?:\d+\s+)?\d{1,2}.?\d{1,2}.?\d{1,2}(\.\d*)?\s*(?P=quote)\s*\}p\{\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*\}r   single-quoted-stringr   double-quoted-string9@@(?:global\.|persist\.|persist_only\.|session\.)?[a-z_]+@[a-z0-9_$.]+@'single-quoted-variable@"double-quoted-variable@`backtick-quoted-variabler  z[!%&*+/:<=>^|~-]+\b(set)(?!\s*\()\b(character)(\s+)(set)\brs   prefixru   \b(\s*)(\()   [0-9a-z$_-￿]+`schema-object-name[(),.;]z[^*a-z]+r{   r|   rt   z[a-z]+\*[^*]+[^'\\]+r   \\[0'"bnrtZ\\%_][^"\\]+r   r   r   [^`]+``)	r   r/  r0  r9  r:  r>  r@  rB  rJ  c                     d}t        t        j                  |             }t        t        j                  |             }||z   }|dk\  r|d|z  k\  r|dz  }|S ||kD  r|dz  }|S |dkD  r|dz  }|S )Nr   r-   r1   r  r  r  )r   r  r   r  r  s        rG   r  zMySqlLexer.analyse_text  s    &)$,,T2'4#%(#++D1&3" 9;UU"&!.H*HHcMF
 	 )+EEcMF  )1,cMFrb   N).r]   r^   r_   r`   r   r   r   r   r   r   r   r   r	   r   r   Specialr   r   r)  Binr   r   r   Dater   Doubler   r   r   r   r   r   r   r   r   r   r   r   r(  r   Quotedr   r   Escaper   r  r   rb   rG   r(   r(     s    DiG I
!CMMMEM
Z M
 w~~.	M

 w(9:M
 W&&(;<M
 "6::.M
 VZZ(M
 &**%M
 $M
" .v||<#M
$ .v||<%M
& #FLL1'M
( 3FNNC)M
. Z\\/M
6 k\\7M
@&
 ?M
R 6=="89SM
T 6=="89UM
Z J4==Y[M
\ t}}-]M
^ DMM#;<_M
` DMM#;<aM
b DMM#=>cM
d DMM"eM
j "8,kM
p !'*qM
r *8GZ+QRsM
x ?5?OyM
z ?5?N{M
| >%>H}M
~ ?5HdmmZ=?M
P (.QM
R 4;; 45SM
X %YM
f '//*W__f-(7Iw'GOO$
 w(()W&&/G%%&
 'FMM"$fmm46==&)	!
 'FMM"$fmm46==&)	!
 t}}%DMM"4==&)#
 t}}%DMM"4==&)#
 t}}%DMM"4==&)%
 t{{#DKK&&'4;;'
_TFlrb   r(   c                      e Zd ZdZdZddgZddgZddgZd	Zd
Z	e
j                  Zg 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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j2                  dfdej6                  fdej6                  fd ej6                  d!fd"ej6                  d#fd$ej6                  d%fd&ej6                  fd'efd( eeee      f eej@                  d)d)*      ejB                  f eejD                  d)d)*      ejF                  f eejH                  d)d)*      ef eejJ                  d)d+*       eejL                  ee'      f eejP                  d)d)*      e)fd,efd-ejT                  d.fd/e'fd0ej                   fd1ej                   d2fd3ej                   fgd4ej                  fd5ejV                  fd6ejV                  fdej                  d2fgd7ej2                  fd8ejV                  fd6ejV                  fdej2                  d2fgd9ej6                  fd5ej6                  fdej6                  d2fgd:ej6                  fd8ej6                  fdej6                  d2fgd;ej6                  fd<ej6                  fd-ej6                  d2fgd;ejT                  fd<ejT                  jV                  fd-ejT                  d2fgd=Z,d> Z-y?)@r!   z
    GoogleSQL is Google's standard SQL dialect, formerly known as ZetaSQL.

    The list of keywords includes reserved words for future use.
    	GoogleSQL	googlesqlzetasqlz*.googlesqlz*.googlesql.sqlztext/x-google-sqlztext/x-google-sql-auxz+https://cloud.google.com/bigquery/googlesqlz2.19rg   r.  ri   r0  r1  r  r2  r3  r  r4  r  r5  r6  r7  r8  r   r9  r   r:  r;  r<  r=  r>  r?  r@  rA  rB  r  rC  rD  rs   rE  rG  rH  rI  rJ  rK  rM  r{   r|   rL  rN  r   rO  rP  r   r   r   rQ  rR  )r   r0  r9  r:  r>  r@  rB  rJ  c                     t        j                  | j                               }dt        d |j	                         D              z  S )NgMbP?c              3   6   K   | ]  \  }}|t         v r|  y wrL   )googlesql_identifiers)rp   tcounts      rG   rr   z.GoogleSqlLexer.analyse_text.<locals>.<genexpr>k  s$      :XQ#88 ! :s   )collectionsCountersplitsumr   )r9   r   s     rG   r  zGoogleSqlLexer.analyse_texti  s>    $$TZZ\2s : : : : 	:rb   N).r]   r^   r_   r`   r   r   r   r   r   r   r   r   r   r	   r   r   r   r   r)  rU  r   r   r   rV  r   rW  r   r   r   r   r   r   	constantsr   typesr   keywordsfunctionnamesr(  r   	operatorsr   rX  rY  r   r  r   rb   rG   r!   r!     s    DI&G 12I$&=>I
7CMMMEJ
Z J
 w~~.	J

 W&&(;<J
 "6::.J
 VZZ(J
 &**%J
 $J
  .v||<!J
" .v||<#J
$ #FLL1%J
& 3FNNC'J
, Z\\-J
4 k\\5J
>&
 =J
P 6=="89QJ
R 6=="89SJ
X J4==YYJ
Z t}}-[J
\ DMM#;<]J
^ DMM#;<_J
` DMM#=>aJ
b DMM"cJ
h !'*iJ
j *8GZ+QRkJ
p &00uMt}}]qJ
r &,,U5I7<<XsJ
t &//eLgVuJ
v &44U>ZdmmZ=?wJ
z &00uMxX{J
J (.KJ
L 4;; 45MJ
R %SJ
` w(()W&&/G%%&
 'FMM"$fmm46==&)	!
 'FMM"$fmm46==&)	!
 t}}%DMM"4==&)#
 t}}%DMM"4==&)#
 t}}%DMM"4==&)%
 t{{#DKK&&'4;;'
IIFV:rb   r!   c                   8    e Zd ZdZdZdgZdgZdgZdZdZ	dZ
d	 Zy
)r)   z3
    Lexer for example sessions using sqlite3.
    
sqlite3consqlite3z*.sqlite3-consoleztext/x-sqlite3-consolezhttps://www.sqlite.orgz0.11zsqlite3/sqlite3.sqlite3-consolec           	   #     K   t        di | j                  }d}g }t        j                  |      D ]	  }|j	                         }t
        j                  |      }|^|j                  t        |      dt        j                  |d d fgf       |j                  t        |      dt        dfgf       ||dd  z  }|r't        ||j                  |            E d {    d}g }|j                  d      r$|j                         t        j                   |f |j                         t        j"                  |f  |r$t        ||j                  |            E d {    y y 7 7 w)Nr   r   r6   rn      zSQL error: r   )r&   rW   r   r>   r<   sqlite_prompt_rer8   rY   r   r   r   r	   r   rC   rX   r@   	Tracebackr   )rN   r   rR   r   r   r8   r   prompt_matchs           rG   rC   z)SqliteConsoleLexer.get_tokens_unprocessed|  sp    &&
%%d+ 	@E;;=D+11$7L'!!3w<%&Ra$A#B#D E!!3w<%&
C$8#9#; <48#,Z-0-G-G-P R R R G!#J??=1 ;;='*;*;TBB ;;='..$??%	@& $Z%(%?%?%HJ J J RJs%   CE)E%BE)E'E)'E)N)r]   r^   r_   r`   r   r   r   r   r   r   r   rC   r   rb   rG   r)   r)   o  s:     DkG$%I)*I
"CM0HJrb   r)   c                       e Zd ZdZdZdZdgZdgZdgZd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y)r*   z,
    Lexer for Relation Query Language.
    RQLz"http://www.logilab.org/project/rqlrqlz*.rqlz
text/x-rqlz2.0r   rg   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)\brw   z[A-Z_]\w*\??r   r
  r  N)r]   r^   r_   r`   r   r   r   r   r   r   r   r   r   r	   r   r   r   r   r   r   r   r   r   r   r   rb   rG   r*   r*     s     D
.CgG	IIMMMEZ 56=? H%94<<H'd#fmm,fmm,k*
Frb   r*   )Ir`   rc  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   r   pygments.lexers._mysql_builtinsr   r   r   r   r   r   r    __all__compiler   rq  r   r7   rA   r  r  r  r  r  rj  ri  rh  r`  rH   rJ   r"   r#   r   r   r   r   re_errorr   r   r$   r%   r&   r'   r(   r!   r)   r*   r   rb   rG   <module>r     s]  (T  	 L L4 4 4 4 <5 5  0 *O 2::g2::9: bjj3R]]C

9bmm, %"**%89 %2::&78 RZZ	2==1
"**-r}}=2::01  %%""#  !3H" "J5L* 5p< D\: 6 BJJ56	"**X&,-"**232::'(RZZ78

 ,F5 FRw: wtCz CLSz Slv vr]:Z ]:@'J 'JTz rb   