Ë !täi¸¢ãó¢—dZddlZddlZddlmZmZmZmZmZddl m Z ddl mZddl mZddl m Z ddl mZdd l mZmZdd lmZmZmZmZmZmZmZmZmZmZmZgd¢Zej<d«Zej<d «Z ej<dejB«Z"ej<dejB«Z#ej<d«Z$ej<d«Z%ej<dejB«Z&ej<dejB«Z'ej<d«Z(e jRe jTze jVzZ,d„Z-Gd„d«Z.Gd„de.e«Z/Gd„de.e«Z0Gd„de.e«Z1ej<d«Z2ej<d«Z3ej<d «Z4ej<d!«Z3ej<d"«Z5ej<d#«Z6Gd$„d%«Z7Gd&„d'e«Z8Gd(„d)e«Z9Gd*„d+e«Z:Gd,„d-e«Z;Gd.„d/e«Z<Gd0„d1e«Z=Gd2„d3e«Z>Gd4„d5e«Z?y)6aï 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 <>). `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-present by the Pygments team, see AUTHORS. :license: BSD, see LICENSE for details. éN)ÚLexerÚ RegexLexerÚ do_insertionsÚbygroupsÚwords)Ú_googlesql_builtins)Ú_mysql_builtins)Ú_postgres_builtins)Ú _sql_builtins)Ú_tsql_builtins)Úget_lexer_by_nameÚ ClassNotFound)ÚPunctuationÚ WhitespaceÚTextÚCommentÚOperatorÚKeywordÚNameÚStringÚNumberÚGenericÚLiteral) Ú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 #óZK—d}tj|j|j«|j«dz«}|!|j |jd««}nát tj|jtd|j«dz «|j«««}|r$|j |djd««}ngt tj|jtd|j«dz «|j«««}|r|j d«}|jd«t|jd«f–—|jd«tj|jd«f–—|jd «t|jd «f–—|r)|j|jd ««Ed{–—†n)|jd «t|jd «f–—|jd«t|jd«f–—|jd«tj|jd«f–—|jd «t|jd «f–—y7Œ´w)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)Úlexerr1ÚlxÚms úb/Volumes/fast/ai/experiments/MLX_z-image/.venv/lib/python3.12/site-packages/pygments/lexers/sql.pyÚlanguage_callbackrARsèø€ð €BÜ×Ñ˜%Ÿ*™* U§Y¡Y£[°·±³¸S±ÐAÓB€AØ€}Ø × Ñ ˜aŸg™g a›jÓ )‰ä”×%Ñ%ØJ‰J”s˜1˜eŸk™k›m¨CÑ/Ó0°·±³Ð?óAó BˆáØ×!Ñ! ! B¡%§+¡+¨a£.Ó1‰Bä”U—^‘^Ø— ‘ œ3˜q %§+¡+£-°Ñ"2Ó3°E·K±K³MÐBóDóEˆAáØ×%Ñ% iÓ0ð;‰;q‹>œ6 5§;¡;¨q£>Ð 2Ò2Ø;‰;q‹>œ6×+Ñ+¨U¯[©[¸«^Ð <Ò<Ø;‰;q‹>œ6 5§;¡;¨q£>Ð 2Ò2á Ø×,Ñ,¨U¯[©[¸«^Ó<×<Ñ<à{‰{˜1‹~œv u§{¡{°1£~Ð6Ò6à;‰;q‹>œ6 5§;¡;¨q£>Ð 2Ò2Ø;‰;q‹>œ6×+Ñ+¨U¯[©[¸«^Ð <Ò<Ø;‰;q‹>œ6 5§;¡;¨q£>Ð 2Ó2ð =ús‚G2J+Ç4J)Ç5B5J+có(‡—eZdZdZˆfd„Zd„ZˆxZS)Ú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|¢ŽEd{–—†y7Œw©N)r2Úsuperr<)Úselfr2ÚargsÚ __class__s €r@r<z#PostgresBase.get_tokens_unprocesseds&øèø€àˆŒ Ü‘7Ñ1°$Ð>¸Ò>×>Ò>úsƒ&ž$Ÿ&có¶—|j«dk(rtdi|j¤ŽS|g}|jd«r|j |dd«|jd«r|j |dd«|jd«r%|jd«r|j |dd«|D]} t|fi|j¤ŽcSy#t$rYŒ)wxYw)NÚsqlÚplr*Úur')Ú postgresql)Úlowerr ÚoptionsÚ startswithÚappendÚendswithr)rGÚlangÚtriesr>s r@r4zPostgresBase._get_lexer„sÊ€Ø:‰:‹<˜5Ò Ü$ÑB°T·\±\ÑBÐBàˆØ?‰?˜4Ô ØL‰L˜˜a˜b˜Ô"Ø=‰=˜ÔØL‰L˜˜c˜r˜Ô#Ø?‰?˜4Ô T§]¡]°3Ô%7ØL‰L˜˜a ˜Ô$ãˆBð Ü(¨Ñ<¨t¯|©|Ñ<Ò<ððøô!ò Ùð úsÂ2CÃ CÃC)Ú__name__Ú __module__Ú__qualname__Ú__doc__r<r4Ú __classcell__)rIs@r@rCrCvsø„ñô?ö órCcóD—eZdZdZdZddgZdgZdZdZe jZdefd e jfd e jdfdd j!d„ej$ej&zD««zdzej*feej.d¬«efdefdefdej4fdej8fdej:fdeej@ej«dfdeej@ej(«dfde!fdefdej4fde"fgd e jdfde jd fd!e jfd"e jfgd#ejfd$ejfd%ejd fgd&ej(fd'ej(fd(ej(d fgd)œZ#y*)+rz2 Lexer for the PostgreSQL dialect of SQL. zPostgreSQL SQL dialectrNÚpostgresztext/x-postgresqlúhttps://www.postgresql.orgú1.5ú\s+ú--.*\n?ú/\*úmultiline-commentsÚ(Ú|c#ó@K—|]}|jdd«–—Œyw)Ú r`N)Úreplace)Ú.0Úss r@Ú zPostgresLexer.¬s'èø€ð>ñ'= ðŸY™Y s¨F×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ú[^/*]+ú[/*]ú[^']+ú''Ú'ú[^"]+ú""Ú")ÚrootrcrqrrN)$rVrWrXrYÚnameÚaliasesÚ mimetypesÚurlÚ version_addedÚreÚ IGNORECASEÚflagsrrÚSingleÚ MultilineÚjoinr Ú DATATYPESÚPSEUDO_TYPESrÚBuiltinrÚKEYWORDSrrÚVariablerÚFloatÚIntegerrrÚAffixrArÚtokens©r[r@rr›sõ„ñð$€DØ˜ZÐ(€GØ$Ð%€IØ &€CØ€MàM‰M€EðZÐ Ø ˜Ÿ™Ð(Ø W×&Ñ&Ð(<Ð=Ø C—H‘Hñ>Ø&8×&BÑ&BØ/×<Ñ<ò'=ó>ó>ñ>à@FñGð\‰\ð ñÐ%×.Ñ.°uÔ =¸wÐGØ $ hÐ/Ø HÐØ t—}‘}Ð%Ø 6¸¿¹ÐEØ ˜Ÿ™Ð'Ø ¡¨¯©°v·}±}Ó EÀxÐPà ™h v§|¡|°V·[±[ÓAÀ>ÐRØ 4Ð6GÐHØ ˜4Ð ð)¨$¯-©-Ð8à Ð,ð/ ð4W×&Ñ&Ð(<Ð=Ø W×&Ñ&¨Ð/Ø ˜×)Ñ)Ð*Ø g×'Ñ'Ð(ð ðv—}‘}Ð%Ø F—M‘MÐ"Ø 6—=‘= &Ð)ð ðv—{‘{Ð#Ø F—K‘KÐ Ø 6—;‘; Ð'ð ñK*Fr[rc ó´—eZdZdZdZdgZdgZdZdZe jZejj«Dcic]\}}||dd“Œ c}}}Z ee d«D]9\ZZed ek(sŒeej*ej,zd ¬«efe de<[nJd «‚dej0fdefdej4fdej6fge dddycc}}}w)rz7 Handle the extra syntax in Pl/pgSQL language. zPL/pgSQLr)ztext/x-plpgsqlz4https://www.postgresql.org/docs/current/plpgsql.htmlr_Nr~r&rlrmrzSQL keywords not foundz\%[a-z]\w*\bz:=z\<\<[a-z]\w*\>\>z\#[a-z]\w*\b)rVrWrXrYrr€rr‚rƒr„r…r†rr’ÚitemsÚ enumerateÚiÚpatternrrr rÚPLPGSQL_KEYWORDSrrŒrÚLabelÚPseudo©rirÚstates000r@rrÔs„ñð€DØˆk€GØ!Ð"€IØ @€CØ€MàM‰M€Eà2?×2FÑ2F×2LÑ2LÔ2NÕ OÑ2N¡ $¨ˆdE™!H‰nÐ2NÓ O€Fñ v¡Ö/‰ ˆˆ7Ø1‰:˜Ó áÐ(×1Ñ1Ø(×9Ñ9ñ:ØBGôIàð!ˆF6‰N˜1ÑðÙð0ð +Ð*Ó*ˆqð ˜$Ÿ,™,Ð'Ø ÐØ ˜dŸj™jÐ)Ø ˜'Ÿ.™.Ð)ð €Fˆ6N2AÑùôPs½Crc ó€—eZdZdZdZgZejZe jj«Dcic]\}}||dd“Œ c}}}Z e djde jdf«dedfdefde jfd ej$fd ej(fdej*fdej,fge d<ycc}}}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]+zpsql-commandz\nr`rsú'(''|[^'])*'z `([^`])*`z[^\s]+)rVrWrXrYrr€r„r…r†rr’r•rRrr›rrrrŽrr‡ÚBacktickÚSymbolrœs000r@rŸrŸ÷sÏ„ñð5€DØ€GàM‰M€EØ2?×2FÑ2F×2LÑ2LÔ2NÕ OÑ2N¡ $¨ˆdE™!H‰nÐ2NÓ O€Fà ˆ6N×ÑØ g—n‘n nÐ5ô7ð fÐØ ÐØ g—n‘nÐ%Ø $ d§m¡mÐ4Ø ˜&Ÿ-™-Ð(Ø v—‘Ð'Ø F—M‘MÐ"ð€Fˆ>Òùô PsµB9rŸ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ó,—eZdZdZd„Zd„Zd„Zd„ZeZy)Ú lookaheadz0Wrap an iterator and allow pushing back an item.có2—t|«|_d|_yrE)ÚiterÚ _nextitem)rGÚxs r@Ú__init__zlookahead.__init__s€Ü˜“GˆŒ Øˆr[có—|SrEr“)rGs r@Ú__iter__zlookahead.__iter__"s€Øˆr[có—||_|SrE)r§)rGr—s r@Úsendzlookahead.send%s€ØˆŒØˆr[cón—|j|j}d|_|St|j«SrE)r§Únextr¦)rGÚnis r@Ú__next__zlookahead.__next__)s/€Ø>‰>Ð%Ø—‘ˆBØ!ˆDŒNØˆIÜD—I‘I‹Ðr[N) rVrWrXrYr©r«rr±r¯r“r[r@r¤r¤s „Ù:òòòòðDr[r¤có4—eZdZdZdZgd¢ZdgZdZdZdZ d„Z y ) rz" Lexer for psql sessions. zPostgreSQL console (psql))Úpsqlzpostgresql-consolezpostgres-consoleztext/x-postgresql-psqlr^r_zpsql/psql_session.txtc#ó¾K—tdi|j¤Ž}ttj |««} d}g}|D]é}|jd«r2|s0t d i|j¤Ž}|j|«Ed{–—†n¦tj|«}|\|jt|«dtj|j«fgf«||t|j««dz }n||z }tj|«st j#|«sŒént%||j|««Ed{–—†tj&} |D]ó}tj|«}||j)|«nÊt*j|«} | ©| jd«jd«s | jd«jd«rtj,} | j/d«tj0| jd«f–—| j/d«| | jd«f–—Œíd| |f–—ŒõyŒ 7ŒÛ7Œw) Nr&ÚÚ$rÚERRORÚFATALr*r“)Úconsole)rŸrPr¤Úline_reÚfindallrQr r<Ú re_promptr1rRÚlenrÚPromptr5Úre_psql_commandÚre_end_commandÚsearchrÚOutputrÚ re_messageÚErrorr9ÚStrong)rGÚdatarKÚlinesÚcurcodeÚ insertionsÚliner=ÚmpromptÚ out_tokenÚmmsgs r@r<z+PostgresConsoleLexer.get_tokens_unprocessed>sèø€ÜÑ,˜tŸ|™|Ñ,ˆäœ'Ÿ/™/¨$Ó/Ó0ˆððˆGØˆJÛà—?‘? 3Ô'±Ü-ÑH¸4¿<¹<ÑHEØ$×;Ñ;¸DÓA×AÐAÙô$Ÿ/™/¨$Ó/ØÐ&Ø×%Ñ%¤s¨7£|Ø)*¬G¯N©N¸G¿M¹M»OÐ(LÐ'Mð'OôPà˜t¤C¨¯ © «Ó$8Ð$9Ð:Ñ:‘Gà˜t‘OGô #×(Ñ(¨Ô1Ü$×+Ñ+¨GÕ4Ùð+ô0% ZØ%(×%?Ñ%?ÀÓ%HóJ÷ Jð Jô Ÿ™ˆIÛÜ#Ÿ/™/¨$Ó/ØÐ&à—J‘J˜tÔ$Ùä!×'Ñ'¨Ó-ØÐ#Ø—z‘z !“}×/Ñ/°Ô8ØŸ*™* Q›-×2Ñ2°7Ô;Ü$+§M¡M˜ ØŸ:™: a›=¬'¯.©.¸$¿*¹*ÀQ»-ÐHÒHØŸ:™: a›=¨)°T·Z±ZÀ³]ÐCÓCà˜i¨Ð.Ó.ðð"ñiðBùð( Jûs,‚A:IÁf‘d*ej"f‘d+eej*e e«d,f‘d-eej*e «f‘d.ej(f‘d/eej*ee j8e e«f‘d0e d1fd2e d3fd4e j0fd5efgd6ee je «dfd7ee jee «dfd0e d8fd9e fd:e j8fd;e j8fde dfd?e j8fd@e j8fdAe j8fdBe j8fdCe j8fdDefdEe fdFe fd2e d3fgdGee e j8e «d3fdHe j8d3fgdIe fdDefdJe jfdKej<fdLej.fd2e d3fgdMeej*e j8«fdNej*dfdOej*dfgdPee j@eeee«fdQe fgd0e fdRe j8fd2e d3fgdSe fdTejBfdUe j0fdLej.fdDefgdVœ Z"yW)Xrz* Handle PostgreSQL EXPLAIN output zPostgreSQL EXPLAIN dialectzpostgres-explainz *.explainztext/x-postgresql-explainz:https://www.postgresql.org/docs/current/using-explain.htmlz2.15z!(:|$|$|ms|kB|->|\.\.|\,|\/|=|%)z(\s+)z (cost)(=?)Úinstrumentationz(actual)( )(=?))ÚactualzMemory Usagez Disk UsageÚMemoryÚBucketsÚBatchesÚ originallyÚrowÚrowsÚHitsÚMissesÚ EvictionsÚ OverflowszPlanned PartitionsÚ EstimatesÚcapacityz distinct keysÚlookupszhit percentzIndex SearchesÚStoragezDisk Maximum Storagerlrmz.(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 FilterzSubplans RemovedÚFilterz Merge Condz Hash Condz Index CondzRecheck CondzHeap BlockszTID Condz Run ConditionzOrder Byz Function CallzTable Function CallzInner UniquezParams EvaluatedzSingle CopyÚSamplingzOne-Time FilterrÂÚ Relationsz Remote SQLÚDisabledÚ predicatez Conflict Úconflictz(InitPlan|SubPlan)( )(\d+)( )Ú init_plan)zSort Methodrâz Planning timez Planning TimezExecution timezExecution TimezWorkers PlannedzWorkers LaunchedÚBuffersÚPlanningÚWorkerzQuery IdentifierÚTimezFull-sort GroupszPre-sorted Groups)zRows Removed by Join FilterzRows Removed by FilterzRows Removed by Index RecheckzHeap Fetchesznever 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$ruz(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"roz::\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\, zreturns \$\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)#rVrWrXrYrr€Ú filenamesrr‚rƒrrrrÚClassrrr‡rrr›ÚPreprocrrÚ Exceptionr ÚEXPLAIN_KEYWORDSÚTyperŽrrÚConstantÚ AttributeÚPrepocr’r“r[r@rr{s „ñð(€DØ!Ð"€GØ €IØ,Ð-€IØ F€CØ€Mð_ Ø 1°;Ð?ð_ à zÐ"ð_ ð™H T§Z¡Z°Ó=Ð?PÐQð _ ð ¡¨$¯*©*°jÀ+Ó!NÐPaÐbð_ ñðIðRWô Xð ^‰^ð ð_ ð"?ÁÈÏÉÐYaÓ@bÐcð#_ ð$$ W§^¡^Ð4ð%_ ð*"¡8¨G¯O©O¸[Ó#IÈ6ÐRð+_ ð0BÙ g—o‘o {°JÓ ?Àð Pð1_ ð4-©h°wÀÈZÓ.XÐZgÐhð5_ ñ:ð;ð DIôJð_‰_˜kð +ð;_ ðL˜7Ÿ?™?¨JÐ7ðM_ ðR.Ù g˜z¨6¯>©>¸:Ó FØ ð ðS_ ñZð=ðFKô LðNUÏ_É_ð ^ð[_ ñjð6ð ô!ð#'§.¡.ð 2ðk_ ðr$¡X¨d¯n©n¸kÈ:Ó%VÐWðs_ ñvÐ%×6Ñ6¸uÔ EÀwÐOðw_ ð|3°G·L±LÐAð}_ ð~6°w·±ÐGð_ ð@˜'Ÿ/™/Ð*ðA_ ðB(¨¯©Ð9ðC_ ðF¡¨°*¸d¿m¹mÓ LÐMðG_ ðN˜K¨Ð7ðO_ ðV˜fŸm™mÐ,ðW_ ðZ˜FŸL™LÐ)ð[_ ð\˜Ÿ™Ð(ð]_ ðb˜dŸm™mÐ,ðc_ ðf(¨¯©Ð8ðg_ ðj!¡(¨7¯?©?¸KÈÓ"TÐV_Ð`ðk_ ðp2±8¸G¿O¹OÈ[Ó3YÐZðq_ ðrXÐY`×YgÑYgÐhðs_ ðx(Ù g—o‘o z°4·=±=À+ÈzÓ Zð \ðy_ ðFK Ð)Ø K Ð(Ø $§.¡.Ð1Ø ˜Ð ð ð™h t§z¡z°;Ó?ÐARÐSØ !¡8¨D¯J©J¸ ÀKÓ#PÐRcÐdðK Ð.Ø kÐ"à 6¸¿ ¹ ÐFØ )¨4¯=©=Ð9Ø ˜Ÿ™Ð'ð[ -Ð0Ø ; Ð.ð+¨D¯M©MÐ:Ø *¨D¯M©MÐ:Ø § ¡ Ð.ðt—}‘}Ð%à t—}‘}Ð%Ø JÐØ ;ÐØ ˜KÐ(Ø K Ð(ð? ðF!¡(¨;¸¿ ¹ À{Ó"SÐU[Ð\à ˜Ÿ ™ vÐ.ð ð˜Ð$Ø JÐØ '¨¯©Ð4Ø ˜&Ÿ,™,Ð'Ø v—~‘~Ð&Ø K Ð(ð ð$¡X¨g¯o©o¸t¿}¹}Ó%MÐNØ §¡°Ð?Ø ˜GŸO™O¨[Ð9ð ð1±(¸4¿>¹>È:ÐW_ÐakÐmsÓ2tÐuØ [Ð!ð ð KÐ Ø &¨¯ © Ð6Ø K Ð(ð ðkÐ"Ø >ÀÇÁÐOØ *¨D¯N©NÐ;Ø v—~‘~Ð&Ø JÐð ñMmFr[rcóÆ—eZdZdZdZdgZdgZdgZdZdZ e jZde fd ejfd ej dfeej&d¬ «efeej*d¬ «ej.fdefdej4fdejfdej8fdefdefgd ej dfdej dfdej fdej fgdœZd„Zy)rz Lexer for Structured Query Language. Currently, this lexer does not recognize any special syntax except ANSI SQL. ÚSQLrKú*.sqlz text/x-sqlz!https://en.wikipedia.org/wiki/SQLrµr`rarbrcrlrmz[+*/<>=~!@#%^&|`?-]rpr ú"(""|[^"])*"z[a-z_][\w$]*ú[;:()\[\],.]rtrurvrw©r~rccó—yrEr“)rGr2s r@Úanalyse_textzSqlLexer.analyse_text\s€Ør[N) rVrWrXrYrr€ròrr‚rƒr„r…r†rrr‡rˆrrrrrŠrrŒrrrrr¢rr’rr“r[r@rr7s„ñð €DØˆg€GØ €IØ€IØ -€CØ€MàM‰M€EðZÐ Ø ˜Ÿ™Ð(Ø W×&Ñ&Ð(<Ð=Ù =×)Ñ)°%Ô 8¸'ÐBÙ =×*Ñ*°5Ô 9¸4¿<¹<ÐHØ # XÐ.Ø ˜Ÿ™Ð'à ˜fŸm™mÐ,Ø ˜fŸm™mÐ,Ø ˜dÐ#Ø ˜kÐ*ð ðW×&Ñ&Ð(<Ð=Ø W×&Ñ&¨Ð/Ø ˜×)Ñ)Ð*Ø g×'Ñ'Ð(ð ñ€Fó.r[rcó–—eZdZdZdZddgZdgZdgZdZdZ e jZd e fd ejfdej dfeej&«efeej*d ¬«ej,feej.d ¬«ej2feej4d ¬«ej6fdeee ej<«feej>d ¬«efdeeee«fde jBfde jDfde jDfde jDfde jFfde$jfde$jJfde&fdejNfdejPfdeej<e&«fdefdejPjRfgdej dfdej dfd ej fd!ej fgd"œ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. zTransact-SQLÚtsqlzt-sqlrýztext/x-tsqlzhttps://www.tsql.inforµr`z--.*[$|\n]?rbrcrlrmz(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]+rpr rþz[;(),.]z@@\w+z@\w+z(\w+)(:)z#?#?\w+ú\?rtrurvrwrcóv—d}tj|«rd}|Sttj |««}tt j |««}||z}|dk\r|d|zk\r|dz }n||kDr|dz }n |dkDr|dz }tj|«|dz }tj|«|dz }|S)Nrgð?r&r*çà?çš™™™™™É?çš™™™™™¹?)Útsql_declare_rerÁr½Úname_between_backtick_rer»Úname_between_bracket_reÚtsql_variable_reÚ tsql_go_re©r2ÚratingÚname_between_backtick_countÚname_between_bracket_countÚdialect_name_counts r@rzTransactSqlLexer.analyse_text™sÞ€ØˆÜ×!Ñ! $Ô'àˆFð,ˆ ô)+.Ü(×0Ñ0°Ó6ó+8Ð'ä),Ü'×/Ñ/°Ó5ó*7Ð&ð "=Ð?YÑ!YÐØ! QÒ&Ø)¨QÐ1LÑ-LÒLà˜#‘ ‘Ø+Ð.IÒIØ˜#‘ ‘Ø+¨aÒ/Ø˜#‘ Ü×&Ñ& tÓ,Ð8Ø˜#‘ Ü× Ñ Ó&Ð2Ø˜#‘ Øˆ r[N),rVrWrXrYrr€ròrr‚rƒr„r…r†rrr‡rˆrrÚ OPERATORSrÚOPERATOR_WORDSÚWordÚTYPESrróÚ FUNCTIONSÚFunctionrrršrrÚHexrrrr¢rrŒrŽÚMagicr’rr“r[r@r r `sô„ñð€DØwÐ€GØ €IØ€IØ !€CØ€MàM‰M€EðZÐ Ø ˜WŸ^™^Ð,Ø W×&Ñ&Ð(<Ð=Ù >×+Ñ+Ó ,¨hÐ7Ù >×0Ñ0¸Ô ?ÀÇÁÐOÙ >×'Ñ'°Ô 6¸¿ ¹ ÐCÙ >×+Ñ+°EÔ :¸D¿M¹MÐJØ "¡H¨W°jÀ$Ç*Á*Ó$MÐNÙ >×*Ñ*°5Ô 9¸7ÐCØ ¡¨(°D¸(Ó!CÐDØ ˜VŸZ™ZÐ(à -¨v¯|©|Ð<à '¨¯©Ð6à " F§L¡LÐ1Ø ˜Ÿ™Ð'Ø ˜fŸm™mÐ,Ø ˜fŸm™mÐ,Ø ˜Ð%ðt—|‘|Ð$Ø d—m‘mÐ$Ø ™( 4§:¡:¨{Ó;Ð<Ø ˜ÐØ D—M‘M×'Ñ'Ð(ð; ð@W×&Ñ&Ð(<Ð=Ø W×&Ñ&¨Ð/Ø ˜×)Ñ)Ð*Ø g×'Ñ'Ð(ð ñA&€FóPr[r c óV—eZdZdZdZdgZdgZdZdZe jZgdef‘de jf‘d e jd f‘de j df‘d ej$f‘dej$f‘dej&f‘dej&f‘dej(f‘dej(f‘dej(f‘dej*f‘dej.f‘dej.f‘dej.f‘dejdf‘dej2df‘dej6f‘dej6f‘dej6df‘d ej6d!f‘d"ej6d#f‘d$ej6f‘d%ef‘d&ef‘d'eeee«f‘ee jBd(d(¬)«ejDf‘ee jFd(d(¬)«ejHf‘ee jJd(d(¬)«ef‘ee jLd(d*¬)«eejNee(«f‘d+ef‘d,ejRd-f‘d.e(f‘d/e jfd0e jd1fee jTd(¬2«e jVfd3e jfd4e jfgd5e j fd0e j d1fd4e j fgd6ejfd7ejXfd8ejXfdejd1fgd9ej2fd:ejXfd8ejXfdej2d1fgd;ej6fd7ej6fdej6d1fgdej6fd,ej6d1fgd=ejRfd>ejRjXfd,ejRd1fgd?œ Z-d@„Z.yA)Br!a5The 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Úmysqlztext/x-mysqlzhttps://www.mysql.comrµr`ú (?:#|--\s+).*z/\*\+úoptimizer-hintsrbú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['\"])\s*\d{2}(\d{2})?.?\d{2}.?\d{2}\s*(?P=quote)\s*\}úZ\{\s*t\s*(?P['\"])\s*(?:\d+\s+)?\d{1,2}.?\d{1,2}.?\d{1,2}(\.\d*)?\s*(?P=quote)\s*\}úp\{\s*ts\s*(?P['\"])\s*\d{2}(?:\d{2})?.?\d{2}.?\d{2}\s+\d{1,2}.?\d{1,2}.?\d{1,2}(\.\d*)?\s*(?P=quote)\s*\}rzúsingle-quoted-stringr}údouble-quoted-stringú9@@(?:global\.|persist\.|persist_only\.|session\.)?[a-z_]+ú @[a-z0-9_$.]+ú@'úsingle-quoted-variableú@"údouble-quoted-variableú@`úbacktick-quoted-variablerz[!%&*+/:<=>^|~-]+ú\b(set)(?!\s*\()ú\b(character)(\s+)(set)\brl©Úprefixrnú\b(\s*)(\()õ[0-9a-z$_Â€-ï¿¿]+Ú`úschema-object-nameú[(),.;]z[^*a-z]+rtrurmz[a-z]+ú\*ú[^*]+ú[^'\\]+ryú\\[0'"bnrtZ\\%_]ú[^"\\]+r|rxr{ú[^`]+ú``) r~r#r$r-r.r2r4r6r>cóà—d}ttj|««}ttj|««}||z}|dk\r|d|zk\r|dz }|S||kDr|dz }|S|dkDr|dz }|S)Nrr&r*r rr)r½rr»rrs r@rzMySqlLexer.analyse_text`s €ØˆÜ&)Ü$×,Ñ,¨TÓ2ó'4Ð#ä%(Ü#×+Ñ+¨DÓ1ó&3Ð"ð9Ð;UÑUÐØ Ò"Ø&¨!Ð.HÑ*HÒHàc‰MˆFð ˆ ð )Ð+EÒ EØc‰MˆFðˆ ð)¨1Ò ,Øc‰MˆFØˆ r[N)/rVrWrXrYrr€rr‚rƒr„r…r†rrr‡ÚSpecialrˆrrÚBinrrrÚDaterÚDoublerrŽrrrrr ÚMYSQL_CONSTANTSrøÚMYSQL_DATATYPESr÷ÚMYSQL_KEYWORDSÚMYSQL_FUNCTIONSrrÚQuotedÚMYSQL_OPTIMIZER_HINTSrôÚEscaper’rr“r[r@r!r!¶s„ñð€DØˆi€GØÐ €IØ !€CØ€MàM‰M€EðP Ø ZÐ ðP ð˜wŸ~™~Ð.ð P ð w—‘Ð(9Ð:ðP ðW×&Ñ&Ð(;Ð<ð P ð" 6§:¡:Ð.ðP ð˜VŸZ™ZÐ(ðP ð˜&Ÿ*™*Ð%ðP ð˜Ÿ™Ð$ðP ð".¨v¯|©|Ð<ð#P ð$.¨v¯|©|Ð<ð%P ð&# F§L¡LÐ1ð'P ð(3°F·N±NÐCð)P ð.ZØ \‰\ð ð/P ð6kØ \‰\ð ð7P ð@&ð —‘ð ð?P ðR6—=‘=Ð"8Ð9ðSP ðT6—=‘=Ð"8Ð9ðUP ðZJÈ4Ï=É=ÐYð[P ð\˜tŸ}™}Ð-ð]P ð^D—M‘MÐ#;Ð<ð_P ð`D—M‘MÐ#;Ð<ðaP ðbD—M‘MÐ#=Ð>ðcP ðdD—M‘MÐ"ðeP ðj" 8Ð,ðkP ðp! 'Ð*ðqP ðr*©8°G¸ZÈÓ+QÐRðsP ñx?×2Ñ2¸5ÈÔ OØ ]‰]ð ðyP ñ|?×2Ñ2¸5ÈÔ OØ \‰\ð ð}P ñ@?×1Ñ1¸%ÈÔ NØ ð ðAP ñD?×2Ñ2¸5ÈÔ XÙ d—m‘m Z°Ó =ð ?ðEP ðV(¨Ð.ðWP ðX4—;‘;Ð 4Ð5ðYP ð^˜Ð%ð_P ðl˜'Ÿ/™/Ð*Ø W—_‘_ fÐ-Ù ?×8Ñ8ÀÔ GØ _‰_ð à w—‘Ð'Ø G—O‘OÐ$ð ðw×(Ñ(Ð)Ø W×&Ñ&¨Ð/Ø G×%Ñ%Ð&ð ð˜Ÿ™Ð'Ø F—M‘MÐ"Ø $ f§m¡mÐ4Ø 6—=‘= &Ð)ð ! ð˜Ÿ™Ð'Ø F—M‘MÐ"Ø $ f§m¡mÐ4Ø 6—=‘= &Ð)ð ! ðt—}‘}Ð%Ø D—M‘MÐ"Ø 4—=‘= &Ð)ð# ðt—}‘}Ð%Ø D—M‘MÐ"Ø 4—=‘= &Ð)ð# ðt—}‘}Ð%Ø D—M‘MÐ"Ø 4—=‘= &Ð)ð% ðt—{‘{Ð#Ø D—K‘K×&Ñ&Ð'Ø 4—;‘; Ð'ð ñgX€Fótr[r!cóÀ—eZdZdZdZddgZddgZddgZd Zd Z e jZgde f‘dejf‘d ej df‘dej$f‘dej$f‘dej&f‘dej&f‘dej(f‘dej(f‘dej(f‘dej*f‘dej.f‘dej.f‘dej.f‘dejdf‘dej2df‘dej6f‘dej6f‘d ej6d!f‘d"ej6d#f‘d$ej6d%f‘d&ej6f‘d'ef‘d(eee e«f‘eej@d)d)¬*«ejBf‘eejDd)d)¬*«ejFf‘eejHd)d)¬*«ef‘eejJd)d+¬*«eejLe e'«f‘eejPd)d)¬*«e)f‘d,ef‘d-ejTd.f‘d/e'f‘d0ej fd1ej d2fd3ej fgd4ejfd5ejVfd6ejVfdejd2fgd7ej2fd8ejVfd6ejVfdej2d2fgd9ej6fd5ej6fdej6d2fgd:ej6fd8ej6fdej6d2fgd;ej6fd„Z-y?)@rz’ 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.sqlztext/x-google-sqlztext/x-google-sql-auxz+https://cloud.google.com/bigquery/googlesqlz2.19r`r"rbr$r%rr&r'rr(rr)r*r+r,rzr-r}r.r/r0r1r2r3r4r5r6rr7r8rlr9r;r<r=r>r?rArtrur@rBryrCrDr|rxr{rErF)r~r$r-r.r2r4r6r>cóŽ—tj|j««}dtd„|j «D««zS)Ngü©ñÒMbP?c3ó6K—|]\}}|tvr|–—ŒywrE)Úgooglesql_identifiers)riÚtÚcounts r@rkz.GoogleSqlLexer.analyse_text..s#èø€ð:±¡X Q¨ØÔ#8Ñ8ô!±ùs‚)ÚcollectionsÚCounterÚsplitÚsumr•)r2r’s r@rzGoogleSqlLexer.analyse_text s>€Ü×$Ñ$ T§Z¡Z£\Ó2ˆØ”sñ:°·±´ó:ó:ñ:ð :r[N).rVrWrXrYrr€ròrr‚rƒr„r…r†rrr‡rˆrrrIrrrrJrrKrrŽrrrrÚ constantsrøÚtypesr÷ÚkeywordsÚ functionnamesrrÚ operatorsrrPrRr’rr“r[r@rrssÆ„ñð€DØ˜IÐ&€GØÐ 1Ð2€IØ$Ð&=Ð>€IØ 7€CØ€MàM‰M€EðJ Ø ZÐ ðJ ð˜wŸ~™~Ð.ð J ð W×&Ñ&Ð(;Ð<ðJ ð" 6§:¡:Ð.ðJ ð˜VŸZ™ZÐ(ðJ ð˜&Ÿ*™*Ð%ðJ ð˜Ÿ™Ð$ðJ ð .¨v¯|©|Ð<ð!J ð".¨v¯|©|Ð<ð#J ð$# F§L¡LÐ1ð%J ð&3°F·N±NÐCð'J ð,ZØ \‰\ð ð-J ð4kØ \‰\ð ð5J ð>&ð —‘ð ð=J ðP6—=‘=Ð"8Ð9ðQJ ðR6—=‘=Ð"8Ð9ðSJ ðXJÈ4Ï=É=ÐYðYJ ðZ˜tŸ}™}Ð-ð[J ð\D—M‘MÐ#;Ð<ð]J ð^D—M‘MÐ#;Ð<ð_J ð`D—M‘MÐ#=Ð>ðaJ ðbD—M‘MÐ"ðcJ ðh! 'Ð*ðiJ ðj*©8°G¸ZÈÓ+QÐRðkJ ñpÐ&×0Ñ0¸ÀuÔ MÈtÏ}É}Ð]ðqJ ñrÐ&×,Ñ,°UÀ5Ô IÈ7Ï<É<ÐXðsJ ñtÐ&×/Ñ/¸ÀeÔ LÈgÐVðuJ ñvÐ&×4Ñ4¸UÈ>Ô ZÙ d—m‘m Z°Ó =ð ?ðwJ ñzÐ&×0Ñ0¸ÀuÔ MÈxÐXð{J ðJ(¨Ð.ðKJ ðL4—;‘;Ð 4Ð5ðMJ ðR˜Ð%ðSJ ð`w×(Ñ(Ð)Ø W×&Ñ&¨Ð/Ø G×%Ñ%Ð&ð ð˜Ÿ™Ð'Ø F—M‘MÐ"Ø $ f§m¡mÐ4Ø 6—=‘= &Ð)ð ! ð˜Ÿ™Ð'Ø F—M‘MÐ"Ø $ f§m¡mÐ4Ø 6—=‘= &Ð)ð ! ðt—}‘}Ð%Ø D—M‘MÐ"Ø 4—=‘= &Ð)ð# ðt—}‘}Ð%Ø D—M‘MÐ"Ø 4—=‘= &Ð)ð# ðt—}‘}Ð%Ø D—M‘MÐ"Ø 4—=‘= &Ð)ð% ðt—{‘{Ð#Ø D—K‘K×&Ñ&Ð'Ø 4—;‘; Ð'ð ñII€FóV:r[rcó8—eZdZdZdZdgZdgZdgZdZdZ dZ d „Zy )r"z3 Lexer for example sessions using sqlite3. Ú sqlite3conÚsqlite3z*.sqlite3-consoleztext/x-sqlite3-consolezhttps://www.sqlite.orgz0.11zsqlite3/sqlite3.sqlite3-consolec #óÖK—tdi|j¤Ž}d}g}tj|«D] }|j «}t j |«}|^|jt|«dtj|ddfgf«|jt|«dtdfgf«||ddz }Œ‰|r't||j|««Ed{–—†d}g}|jd«r$|j«tj |f–—Œç|j«tj"|f–—Œ|r$t||j|««Ed{–—†yy7ŒŠ7Œw)Nrµrr/rgézSQL error: r“)rrPrºr7r5Úsqlite_prompt_rer1rRr½rr¾rrr<rQr9Ú TracebackrÂ)rGrÆrKrÈrÉr1rÊÚprompt_matchs r@r<z)SqliteConsoleLexer.get_tokens_unprocessed sièø€ÜÑ&˜Ÿ™Ñ&ˆàˆØˆ Ü×%Ñ% d×+ˆEØ—;‘;“=ˆDÜ+×1Ñ1°$Ó7ˆLØÐ'Ø×!Ñ!¤3 w£<Ø%&¬¯©¸¸R¸a¸Ð$AÐ#Bð#DôEà×!Ñ!¤3 w£<Ø%&¬ °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%‚CE)ÃE%ÃBE)ÅE'ÅE)Å'E)N)rVrWrXrYrr€ròrr‚rƒrÎr<r“r[r@r"r"s:„ñð€DØˆk€GØ$Ð%€IØ)Ð*€IØ "€CØ€MØ0€HóJr[r"cóÔ—eZdZdZdZdZdgZdgZdgZdZ e jZdd e fd efdefdej"fd ej&fdefdej*fdej*fdefg iZy)r#z, Lexer for Relation Query Language. ÚRQLz"http://www.logilab.org/project/rqlÚrqlz*.rqlz text/x-rqlz2.0r~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)\brpz[A-Z_]\w*\??r rþrÿN)rVrWrXrYrr‚r€ròrrƒr„r…r†rrrrrŒrrrr‡rr’r“r[r@r#r#=s¤„ñð€DØ .€CØˆg€GØ €IØ€IØ€MàM‰M€EàØ ZÐ ð5à6=ð ?ð˜HÐ%Ø 9¸4¿<¹<ÐHØ ˜Ÿ™Ð'Ø ˜dÐ#Ø ˜fŸm™mÐ,Ø ˜fŸm™mÐ,Ø ˜kÐ*ð ðFr[r#)@rYr\r„Úpygments.lexerrrrrrÚpygments.lexersrr r rrr rÚpygments.tokenrrrrrrrrrrrÚ__all__Úcompilerºrjr…r0r:rrrr rrcrbrarYrArCrrrŸr¼r¿rÀÚre_errorrÃr¤rrrr r!rr"r#r“r[r@ÚrvsNðñ(óTÛ çLÕLÝ/Ý+Ý.Ý)Ý*ß<÷4÷4÷4ñ4òO€ðˆ2:‰:gÓ€Ø2—:‘:Ð9Ó:Ðàˆbj‰jÐ3°R·]±]ÓC€àˆ ‰ 9˜bŸm™mÓ,€ð%˜"Ÿ*™*Ð%8Ó9ÐØ%˜2Ÿ:™:Ð&7Ó8ÐØ ˆRZ‰Z˜ 2§=¡=Ó 1€ Ø"—*‘*Ð-¨r¯}©}Ó=€Ø2—:‘:Ð0Ó1Ðð×%Ñ%Ø×"Ñ"ñ#à×Ññ ðò!3÷H"ñ"ôJ6L *ô6ôr < ô ôF\ :ôð6 ˆBJ‰JÐ5Ó6€ Ø"—*‘*˜XÓ&€Ø—‘Ð,Ó-€Ø"—*‘*Ð2Ó3€Øˆ2:‰:Ð'Ó(€Ø ˆRZ‰Zð7ó8€ ÷ ñô,F˜5ôFôRy˜:ôyôx&ˆzô&ôRSzôSôlzôzôz]:Zô]:ô@'J˜ô'JôTˆzõr[