Файловый менеджер - Редактировать - /opt/imh-python/lib/python3.9/site-packages/pygments/lexers/__pycache__/sql.cpython-39.pyc
Ðазад
a a�h� � @ sb d Z ddlZddlZddlmZmZmZmZmZ ddl m Z m Z m Z m Z mZmZmZmZmZmZmZ ddlmZmZ ddlmZmZmZm Z m Z ddl m Z m Z m!Z!m"Z"m#Z# ddlm$Z$ dd lm%Z% g d �Z&e�'d �Z(e�'d �Z)e�'d ej*�Z+e�'dej*�Z,e�'d�Z-e�'d�Z.e�'dej*�Z/e�'dej*�Z0e�'d�Z1e$j2e$j3 e$j4 Z5dd� Z6G dd� d�Z7G dd� de7e�Z8G dd� de7e�Z9G d d � d e7e�Z:e�'d �Z;e�'d �Z<e�'d �Z=e�'d!�Z<e�'d"�Z>e�'d#�Z?G d$d%� d%�Z@G d&d'� d'e�ZAG d(d)� d)e�ZBG d*d+� d+e�ZCG d,d-� d-e�ZDG d.d/� d/e�ZEG d0d1� d1e�ZFG d2d3� d3e�ZGG d4d5� d5e�ZHdS )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 <<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 c s� d}t �| j|�� |�� d � �}|dur>| �|�d��}n|tt �| jtd|� � d �|� � � ��}|r�| �|d �d��}n8tt �| jtd|� � d �|� � � ��}|r�| �d�}|� d�t |�d�fV |� d�t j |�d�fV |� d �t |�d �fV |�r"|� |�d ��E dH n|� d �t |�d �fV |� d �t |�d �fV |� d �t j |�d �fV |� d �t |�d �fV dS )z�Parse the content of a $-string using a lexer The lexer is chosen looking for a nearby LANGUAGE or assumed as plpgsql if inside a DO statement and no LANGUAGE has been found. N�d � r ���� �plpgsql� � � � � � )� language_re�match�text�end� _get_lexer�group�list�finditer�max�start�do_rer � Delimiter�get_tokens_unprocessed)�lexerr6 �lx�m� rE ��/root/rpmbuild/BUILDROOT/imh-python39-modules-3.9.7-92.el8.x86_64/opt/imh-python/lib/python3.9/site-packages/pygments/lexers/sql.py�language_callbackY s. � � rG c s( e Zd ZdZ� fdd�Zdd� Z� ZS )� PostgresBasea� Base class for Postgres-related lexers. This is implemented as a mixin to avoid the Lexer metaclass kicking in. this way the different lexer don't have a common Lexer ancestor. If they had, _tokens could be created on this ancestor and not updated for the other classes, resulting e.g. in PL/pgSQL parsed as SQL. This shortcoming seem to suggest that regexp lexers are not really subclassable. c ' s$ || _ t� j|g|�R � E d H d S �N)r7 �superrA )�selfr7 �args�� __class__rE rF rA � s z#PostgresBase.get_tokens_unprocessedc C s� |� � dkr tdi | j��S |g}|�d�r>|�|dd � � |�d�rZ|�|d d� � |�d�r�|�d�r�|�|dd� � |D ]0}zt|fi | j��W S ty� Y q�0 q�d S )N�sql� postgresql�plr/ �ur, )rP )�lowerr �options� startswith�append�endswithr )rK �lang�triesrC rE rE rF r9 � s zPostgresBase._get_lexer)�__name__� __module__� __qualname__�__doc__rA r9 � __classcell__rE rE rM rF rH } s rH c @ sB e Zd ZdZdZddgZdgZdZdZe j Z de fd e jfd e jd fd d �dd� ee D �� d ejfeedd�efdefdefdejfdejfdej fde e j e j�dfde e j e j�dfd e fd efd ejfd e!fgd e jd fd e jd!fd"e jfd#e jfgd$e jfd%e jfd&e jd!fgd'e jfd(e jfd)e jd!fgd*�Z"d+S ),r! z2 Lexer for the PostgreSQL dialect of SQL. zPostgreSQL SQL dialectrP �postgresztext/x-postgresql�https://www.postgresql.org�1.5�\s+�--.*\n?�/\*�multiline-comments�(�|c c s | ]}|� d d�V qdS )� rb N)�replace)�.0�srE rE rF � <genexpr>� s �zPostgresLexer.<genexpr>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�[^/*]+�[/*]�[^']+�''�'�[^"]+�""�")�rootre rr rs N)#rZ 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 �AffixrG r �tokensrE rE rE rF r! � sX ���� � � ��r! c @ s� e Zd ZdZdZdgZdgZdZdZe j Z dd� e j �� D �Z ee d �D ]6\ZZed ekrJeee d d �efe d e< [ q�qJd s�J d��dejfdefdejfdejfge d dd �< dS )r" z7 Handle the extra syntax in Pl/pgSQL language. zPL/pgSQLr. ztext/x-plpgsqlz4https://www.postgresql.org/docs/current/plpgsql.htmlra c C s i | ]\}}||d d � �qS rI rE �rj r� �staterE rE rF � <dictcomp>� � zPlPgsqlLexer.<dictcomp>r r+ rm rn r zSQL keywords not foundz \%[a-z]\w*\bz:=z\<\<[a-z]\w*\>\>z \#[a-z]\w*\bN)rZ r[ r\ r] r� r� r� r� r� r� r� r� r! r� �items� enumerate�i�patternr r r r r r� r �Label�PseudorE rE rE rF r" � s* � �r" c @ s� e Zd ZdZdZg ZejZdd� e j � � D �Z e d � de jdf� dedfd efde jfd ejfd ejfd ejfd ejfge d< dS )�PsqlRegexLexerz� Extend the PostgresLexer adding support specific for psql commands. This is not a complete psql lexer yet as it lacks prompt support and output rendering. z'PostgreSQL console - regexp based lexerc C s i | ]\}}||d d � �qS rI rE r� rE rE rF r� r� zPsqlRegexLexer.<dictcomp>r z\\[^\s]+z psql-commandz\nrb rt � '(''|[^'])*'z `([^`])*`z[^\s]+N)rZ r[ r\ r] r� r� r� r� r� r! r� r� rV r r� r r r r� r r� �Backtick�SymbolrE rE rE rF r� � s ��r� z^(\S.*?)??[=\-\(\$\'\"][#>]z\s*\\z ;\s*(--.*?)?$z(\s*)(\\.+?)(\s+)$z(ERROR|FATAL):zS((?:DEBUG|INFO|NOTICE|WARNING|ERROR|FATAL|HINT|DETAIL|CONTEXT|LINE [0-9]+):)(.*?\n)c @ s4 e Zd ZdZdd� Zdd� Zdd� Zdd � ZeZd S ) � lookaheadz0Wrap an iterator and allow pushing back an item.c C s t |�| _ d | _d S rI )�iter� _nextitem)rK �xrE rE rF �__init__# s zlookahead.__init__c C s | S rI rE )rK rE rE rF �__iter__' s zlookahead.__iter__c C s || _ |S rI )r� )rK r� rE rE rF �send* s zlookahead.sendc C s$ | j d ur| j }d | _ |S t| j�S rI )r� �nextr� )rK �nirE rE rF �__next__. s zlookahead.__next__N) rZ r[ r\ r] r� r� r� r� r� rE rE rE rF r� ! s r� c @ s6 e Zd ZdZdZg d�ZdgZdZdZdZ dd � Z d S ) r# z" Lexer for psql sessions. zPostgreSQL console (psql))�psqlzpostgresql-consolezpostgres-consoleztext/x-postgresql-psqlr` ra zpsql/psql_session.txtc c s� t f i | j��}tt�|��}d}g }|D ]�}|�d�r`|s`td i | j��}|�|�E d H q�t� |�}|d ur�|� t |�dt j |�� fgf� ||t |�� �d � 7 }n||7 }t� |�s�t�|�r* q�q*t||�|��E d H t j} |D ]�}t� |�}|d u�r|�|� q t� |�} | d u�r�| �d��d��sL| �d��d��rRt j} | �d�t j| �d�fV | �d�| | �d�fV q�d| |fV q�d S q d S ) N� �$�consoler r+ �ERROR�FATALr/ )r� )r� rT r� �line_re�findallrU r rA � re_promptr6 rV �lenr �Promptr: �re_psql_command�re_end_command�searchr �Outputr� � re_message�Errorr> �Strong) rK �datarO �lines�curcode� insertions�linerB ZmpromptZ out_tokenZmmsgrE rE rF rA C sN � �� �z+PostgresConsoleLexer.get_tokens_unprocessedN) rZ r[ r\ r] r� r� r� r� r� �_examplerA rE rE rE rF r# 7 s r# c & @ sP e Zd ZdZdZdgZdgZdgZdZdZ de fd e fd e e je �d fd e e je e �d fed dd�ejfde eje�fdejfde eje �dfde eje e �dfde ee e �dfeddd�ejdfdejdfde ee eje �d fed dd�ejfed dd�e jfd e e je e �feedd�efd ejfd!ejfd"ejfd#ejfd$e ee e j�fd%e dfd&e jfd'ej fd(ejfd)e j fd*ejfd+e eje e �d,fd-e eje �fd.ejfd/e eje e je e �fg d0e d1fd2e d3fd4e jfd5efgd6e e je �d fd7e e je e �d fd0e d8fd9e fd:e jfd;e jfd<e jfd=e dfd>e dfd?e jfd@e jfdAe jfdBe jfdCe jfdDe fdEe fdFe fd2e d3fgdGe e e je �d3fdHe jd3fgdIe fdDe fdJe jfdKej fdLejfd2e d3fgdMe eje j�fdNejdfdOejdfgdPe e j e ee e �fdQe fgd0e fdRe jfd2e d3fgdSe fdTej fdUe jfdLejfdDe fgdV� Z!dWS )Xr$ z* 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)( )(=?))�actualz Memory Usagez Disk UsageZMemoryZBucketsZBatchesZ originally�row�rowsZHitsZMissesZ EvictionsZ OverflowszPlanned Partitionsrm rn 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 FilterzSubplans Removed�Filterz Merge Condz Hash Condz Index Condz Recheck Condz Heap BlockszTID Condz Run ConditionzOrder Byz Function CallzTable Function Callz Inner UniquezParams Evaluatedz Single CopyZSamplingzOne-Time Filterr� Z Relationsz Remote SQL� predicatez Conflict �conflictz (InitPlan|SubPlan)( )(\d+)( )� init_plan)z Sort Methodr� z Planning timez Planning TimezExecution timezExecution TimezWorkers PlannedzWorkers LaunchedZBuffersZPlanningZWorkerzQuery IdentifierZTimezFull-sort GroupszPre-sorted Groups)zRows Removed by Join FilterzRows Removed by Filterz Rows Removed by Index Recheckz Heap Fetchesznever executedz(I/O Timings)(:)( )z"((Right|Left|Full|Semi|Anti) Join)z%(Parallel |Async |Finalize |Partial )ZBackwardz(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\)rv 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"rp 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\, 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)"rZ 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� AttributeZPrepocr� rE rE rE rF r$ � s� ����� �������a� �# �� ����� �r$ c @ s� e Zd ZdZdZdgZdgZdgZdZdZ e j Z de fd ejfd ejd fed d d�efedd d�ejfdefdejfdejfdejfdefdefg d ejd fdejdfdejfdejfgd�Zdd � Z d S ) r% z Lexer for Structured Query Language. Currently, this lexer does not recognize any special syntax except ANSI SQL. �SQLrO �*.sqlz text/x-sqlz!https://en.wikipedia.org/wiki/SQLr� rb rc rd re (� ZABORTZABSZABSOLUTEZACCESSZADAZADDZADMINZAFTERZ AGGREGATEZALIASZALLZALLOCATEZALTERZANALYSEZANALYZE�AND�ANYZAREZASZASCZ ASENSITIVEZ ASSERTIONZ ASSIGNMENTZ ASYMMETRIC�ATZATOMICZ AUTHORIZATIONZAVGZBACKWARDZBEFOREZBEGINZBETWEENZBITVARZ BIT_LENGTHZBOTHZBREADTHZBY�CZCACHE�CALLZCALLEDZ CARDINALITYZCASCADEZCASCADEDZCASEZCASTZCATALOGZ CATALOG_NAMEZCHAINZCHARACTERISTICSZCHARACTER_LENGTHZCHARACTER_SET_CATALOGZCHARACTER_SET_NAMEZCHARACTER_SET_SCHEMAZ CHAR_LENGTHZCHECKZCHECKED� CHECKPOINTZCLASSZ CLASS_ORIGINZCLOBZCLOSEZCLUSTERZCOALESCE�COBOLZCOLLATEZ COLLATIONZCOLLATION_CATALOGZCOLLATION_NAMEZCOLLATION_SCHEMAZCOLUMNZ COLUMN_NAMEZCOMMAND_FUNCTIONZCOMMAND_FUNCTION_CODE�COMMENTZCOMMITZ COMMITTEDZ COMPLETIONZCONDITION_NUMBERZCONNECTZ CONNECTIONZCONNECTION_NAMEZ CONSTRAINTZ CONSTRAINTSZCONSTRAINT_CATALOGZCONSTRAINT_NAMEZCONSTRAINT_SCHEMAZ CONSTRUCTORZCONTAINS�CONTINUEZ CONVERSIONZCONVERT�COPYZ CORRESPONDINGZCOUNTZCREATEZCREATEDBZ CREATEUSERZCROSSZCUBEZCURRENTZ CURRENT_DATEZ CURRENT_PATHZ CURRENT_ROLEZ CURRENT_TIMEZCURRENT_TIMESTAMPZ CURRENT_USERZCURSORZ CURSOR_NAMEZCYCLEZDATAZDATABASEZDATETIME_INTERVAL_CODEZDATETIME_INTERVAL_PRECISIONZDAYZ DEALLOCATEZDECLARE�DEFAULTZDEFAULTSZ DEFERRABLEZDEFERREDZDEFINEDZDEFINER�DELETEZ DELIMITERZ DELIMITERSZDEREFZDESCZDESCRIBEZ DESCRIPTORZDESTROYZ DESTRUCTORZ DETERMINISTICZ DIAGNOSTICSZ DICTIONARYZ DISCONNECTZDISPATCHZDISTINCTZDOZDOMAINZDROPZDYNAMICZDYNAMIC_FUNCTIONZDYNAMIC_FUNCTION_CODEZEACH�ELSEZELSIF�ENCODING� ENCRYPTED�ENDzEND-EXECZEQUALS�ESCAPEZEVERYZ EXCEPTIONZEXCEPTZ EXCLUDINGZ EXCLUSIVEZEXECZEXECUTEZEXISTINGZEXISTSZEXPLAINZEXTERNALZEXTRACT�FALSEZFETCHZFINALZFIRSTZFORZFORCEZFOREIGNZFORTRANZFORWARD�FOUNDZFREEZFREEZEZFROMZFULLZFUNCTION�GZGENERALZ GENERATED�GET�GLOBALZGOZGOTOZGRANTZGRANTEDZGROUPZGROUPINGZHANDLERZHAVINGZ HIERARCHYZHOLDZHOSTZIDENTITYZIFZIGNOREZILIKEZ IMMEDIATEZ IMMEDIATELYZ IMMUTABLEZIMPLEMENTATIONZIMPLICIT�INZ INCLUDINGZ INCREMENTZINDEXZ INDITCATORZINFIXZINHERITSZ INITIALIZEZ INITIALLYZINNERZINOUTZINPUTZ INSENSITIVEZINSERTZ INSTANTIABLEZINSTEADZ INTERSECTZINTOZINVOKERZISZISNULLZ ISOLATIONZITERATEZJOINZKEYZ KEY_MEMBERZKEY_TYPEZ LANCOMPILER�LANGUAGEZLARGEZLASTZLATERALZLEADINGZLEFTZLENGTH�LESSZLEVELZLIKEZLIMITZLISTENZLOADZLOCALZ LOCALTIMEZLOCALTIMESTAMPZLOCATIONZLOCATORZLOCKZLOWERZMAPZMATCH�MAXZMAXVALUEZMESSAGE_LENGTHZMESSAGE_OCTET_LENGTHZ MESSAGE_TEXTZMETHODZMINZMINUTEZMINVALUEZMODZMODEZMODIFIESZMODIFYZMONTHZMOREZMOVEZMUMPSZNAMESZNATIONALZNATURALZNCHARZNCLOBZNEWZNEXT�NOZ NOCREATEDBZ NOCREATEUSER�NONE�NOT�NOTHINGZNOTIFYZNOTNULLZNULLZNULLABLEZNULLIFZOBJECTZ OCTET_LENGTHZOFZOFFZOFFSETZOIDSZOLD�ONZONLYZOPENZ OPERATIONZOPERATORZOPTION�OPTIONS�ORZORDERZ ORDINALITYZOUTZOUTERZOUTPUTZOVERLAPSZOVERLAYZ OVERRIDINGZOWNERZPADZ PARAMETERZ PARAMETERSZPARAMETER_MODEZPARAMETER_NAMEZPARAMETER_ORDINAL_POSITIONZPARAMETER_SPECIFIC_CATALOGZPARAMETER_SPECIFIC_NAMEZPARAMETER_SPECIFIC_SCHEMA�PARTIALZPASCALZPENDANTZPERIODZPLACINGZPLIZPOSITIONZPOSTFIXZPRECEEDSZ PRECISION�PREFIXZPREORDERZPREPAREZPRESERVEZPRIMARYZPRIORZ PRIVILEGESZ PROCEDURALZ PROCEDUREZPUBLIC�READZREADSZRECHECKZ RECURSIVEZREFZ REFERENCESZ REFERENCINGZREINDEXZRELATIVEZRENAMEZ REPEATABLEZREPLACE�RESETZRESTARTZRESTRICTZRESULTZRETURNZRETURNED_LENGTHZRETURNED_OCTET_LENGTHZRETURNED_SQLSTATEZRETURNSZREVOKEZRIGHTZROLEZROLLBACKZROLLUPZROUTINEZROUTINE_CATALOGZ ROUTINE_NAMEZROUTINE_SCHEMAZROWZROWSZ ROW_COUNTZRULEZ SAVE_POINTZSCALEZSCHEMAZ SCHEMA_NAMEZSCOPEZSCROLLZSEARCHZSECONDZSECURITYZSELECTZSELFZ SENSITIVEZ SERIALIZABLEZ SERVER_NAMEZSESSIONZ SESSION_USERZSETZSETOFZSETSZSHAREZSHOWZSIMILAR�SIMPLEZSIZEZSOMEZSOURCE�SPACEZSPECIFICZ SPECIFICTYPEZ SPECIFIC_NAMEr� ZSQLCODEZSQLERRORZ SQLEXCEPTIONZSQLSTATEZ SQLWARNINIGZSTABLEZSTARTZSTATEZ STATEMENTZSTATICZ STATISTICSZSTDIN�STDOUTZSTORAGEZSTRICTZ STRUCTUREZSTYPEZSUBCLASS_ORIGINZSUBLISTZ SUBSTRINGZSUCCEEDSZSUMZ SYMMETRICZSYSIDZSYSTEMZ SYSTEM_USERZTABLEZ TABLE_NAMEz TEMP�TEMPLATE� TEMPORARYZ TERMINATEZTHANZTHENZTIME� TIMESTAMPZ TIMEZONE_HOURZTIMEZONE_MINUTEZTOZTOASTZTRAILINGZ TRANSACTIONZTRANSACTIONS_COMMITTEDZTRANSACTIONS_ROLLED_BACKZTRANSACTION_ACTIVEZ TRANSFORMZ TRANSFORMSZ TRANSLATEZ TRANSLATIONZTREATZTRIGGERZTRIGGER_CATALOGZ TRIGGER_NAMEZTRIGGER_SCHEMAZTRIM�TRUEZTRUNCATEZTRUSTEDZTYPEZ UNCOMMITTEDZUNDERZ UNENCRYPTEDZUNIONZUNIQUE�UNKNOWNZUNLISTENZUNNAMEDZUNNESTZUNTILZUPDATEZUPPER�USAGE�USERZUSER_DEFINED_TYPE_CATALOGZUSER_DEFINED_TYPE_NAMEZUSER_DEFINED_TYPE_SCHEMAZUSINGZVACUUMZVALIDZ VALIDATORZVALUES�VARIABLE�VERBOSE�VERSION�VERSIONSZ VERSIONINGZVIEWZVOLATILEZWHENZWHENEVERZWHEREZWITHZWITHOUTZWORK�WRITEZYEARZZONErm rn )ZARRAYZBIGINT�BINARYZBITZBLOBZBOOLEANZCHARZ CHARACTERZDATEZDECZDECIMAL�FLOAT�INTZINTEGERZINTERVAL�NUMBERZNUMERICZREALZSERIALZSMALLINTZVARCHARZVARYINGZINT8ZSERIAL8ZTEXTz[+*/<>=~!@#%^&|`?-]rq r� � "(""|[^"])*"z [a-z_][\w$]*� [;:()\[\],.]ru rv rw rx �r re c C s d S rI rE )rK r7 rE rE rF � analyse_text� s zSqlLexer.analyse_textN) 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 rE rE rE rF r% : sF W�X�Y���l ��tr% c @ s` e Zd ZdZdZddgZdgZdgZdZdZ e j Z d e fd ejfd ejd feej�efeejd d�ejfeejd d�ejfeejd d�ejfde e e ej �feej d d�e fde eee�fde j!fde j"fde j"fde j"fde j#fde$jfde$j%fde&fdej'fdej(fde ej e&�fd efd ej(j)fgd ejd fd ejd fd ejfd!ejfgd"�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�tsqlzt-sqlr� z text/x-tsqlzhttps://www.tsql.infor� rb z --.*[$|\n]?rd re rm rn 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]+rq r� r z[;(),.]z@@\w+z@\w+z(\w+)(:)z#?#?\w+�\?ru rv rw rx r c C s� d}t �| �rd}n�tt�| ��}tt�| ��}|| }|dkrV|d| krV|d7 }n"||krh|d7 }n|dkrx|d7 }t�| �d ur�|d7 }t�| �d ur�|d7 }|S )Nr g �?r+ r/ � �?皙�����?皙�����?)�tsql_declare_rer� r� �name_between_backtick_rer� �name_between_bracket_re�tsql_variable_re� tsql_go_re�r7 ZratingZname_between_backtick_countZname_between_bracket_countZdialect_name_countrE rE rF r � s. �� � z TransactSqlLexer.analyse_textN),rZ r[ r\ r] r� r� r� r� r� r� r� r� r� r r r� r� r r Z OPERATORSr ZOPERATOR_WORDS�Word�TYPESr r� Z FUNCTIONS�Functionr r r� r r �Hexr� r� r r� r r� r� �Magicr� r rE rE rE rF r& � sN � ��(r& c " @ s� e Zd ZdZdZdgZdgZdZdZe j Z de fde jfd e jd fd e jd fd ejfdejfdejfdejfdejfdejfdejfdejfdejfdejfdejfdejdfdejdfd ejfd ejfd ejd fd ejd!fd"ejd#fd$ejfd%e fd&e fd'e e e e �fe e d(d(d)�ej!fe e"d(d(d)�e j#fe e$d(d(d)�e fe e%d(d*d)�e ej&e e'�fd+efd,ej(d-fd.e'fg!d/e jfd0e jd1fe e)d(d2�e j*fd3e jfd4e jfgd5e jfd0e jd1fd4e jfgd6ejfd7ej+fd8ej+fdejd1fgd9ejfd:ej+fd8ej+fdejd1fgd;ejfd7ejfdejd1fgd<ejfd:ejfdejd1fgd=ejfd>ejfd,ejd1fgd=ej(fd>ej(j+fd,ej(d1fgd?� Z,d@dA� Z-dBS )Cr' 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-mysqlzhttps://www.mysql.comr� rb � (?:#|--\s+).*z/\*\+�optimizer-hintsrd �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-string�9@@(?: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)\brm ��prefixro � \b(\s*)(\()� [0-9a-z$_-]+�`�schema-object-name�[(),.;]z[^*a-z]+ru rv rn z[a-z]+�\*�[^*]+�[^'\\]+rz �\\[0'"bnrtZ\\%_]�[^"\\]+r} ry r| �[^`]+�``) r r* r+ r4 r5 r9 r; r= rE c C sl d}t t�| ��}t t�| ��}|| }|dkrF|d| krF|d7 }n"||krX|d7 }n|dkrh|d7 }|S )Nr r+ r/ r r r )r� r r� r r! rE rE rF r � s" �� � zMySqlLexer.analyse_textN).rZ 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 rE rE rE rF r' s� ��� � �S � � � � � � � �� � r' c ! @ sl e Zd ZdZdZddgZddgZddgZd Zd Z e j Z d e fd ejfd ejdfdejfdejfdejfdejfdejfdejfdejfdejfdejfdejfdejfdejdfd ejd fd ejfd ejfd ejd!fd"ejd#fd$ejd%fd&ejfd'e fd(e e e e �fe e j d)d)d*�ej!fe e j"d)d)d*�e j#fe e j$d)d)d*�e fe e j%d)d+d*�e ej&e e'�fe e j(d)d)d*�e)fd,efd-ej*d.fd/e'fg d0ejfd1ejd2fd3ejfgd4ejfd5ej+fd6ej+fdejd2fgd7ejfd8ej+fd6ej+fd ejd2fgd9ejfd5ejfdejd2fgd:ejfd8ejfd ejd2fgd;ejfd<ejfd-ejd2fgd;ej*fd<ej*j+fd-ej*d2fgd=�Z,d>d?� Z-d@S )Ar 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.sqlztext/x-google-sqlztext/x-google-sql-auxz+https://cloud.google.com/bigquery/googlesqlz2.19rb r) rd r+ r, r r- r. r r/ r r0 r1 r2 r3 r{ r4 r~ r5 r6 r7 r8 r9 r: r; r< r= r r> r? rm r@ rB rC rD rE rF rH ru rv rG rI rz rJ rK r} ry r| rL rM )r r+ r4 r5 r9 r; r= rE c C s( t �| �� �}dtdd� |�� D �� S )Ng����MbP?c s s | ]\}}|t v r|V qd S rI )�googlesql_identifiers)rj �t�countrE rE rF rl k s �z.GoogleSqlLexer.analyse_text.<locals>.<genexpr>)� collections�Counter�split�sumr� )r7 r� rE rE rF r i s zGoogleSqlLexer.analyse_textN).rZ r[ r\ r] r� r� r� r� r� r� r� r� r� r r r� r� r r% rO r� r� r rP r rQ r r� r r r r � constantsr� �typesr� �keywords� functionnamesr$ r � operatorsr rR rS r� r rE rE rE rF r � s� ��� � �P � � � � � � �� � r c @ s: e Zd ZdZdZdgZdgZdgZdZdZ dZ d d � Z d S ) r( z3 Lexer for example sessions using sqlite3. � sqlite3con�sqlite3z*.sqlite3-consoleztext/x-sqlite3-consolezhttps://www.sqlite.orgz0.11z sqlite3/sqlite3.sqlite3-consolec c s t f i | j��}d}g }t�|�D ]�}|�� }t�|�}|d ur�|�t|�dt j |d d� fgf� |�t|�dt dfgf� ||dd � 7 }q"|r�t ||� |��E d H d}g }|�d�r�|�� t j|fV q"|�� t j|fV q"|r�t ||� |��E d H d S )Nr� r r4 rh � z SQL error: )r% rT r� r< r: �sqlite_prompt_rer6 rV r� r r� r r rA rU r> � Tracebackr� )rK r� rO r� r� r6 r� Z prompt_matchrE rE rF rA | s6 � �� �z)SqliteConsoleLexer.get_tokens_unprocessedN) rZ r[ r\ r] r� r� r� r� r� r� r� rA rE rE rE rF r( o s r( c @ sz e Zd ZdZdZdZdgZdgZdgZdZ e j Z dd e fd efd efd ejfd ejfdefdejfdejfdefg iZdS )r) z, Lexer for Relation Query Language. �RQLz"http://www.logilab.org/project/rql�rqlz*.rqlz text/x-rqlz2.0r rb 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)\brq z [A-Z_]\w*\??r� r r N)rZ r[ r\ r] r� r� r� r� r� r� r� r� r� r r r r r� r r� r r� r r� rE rE rE rF r) � s, ���r) )Ir] rZ r� Zpygments.lexerr r r r r Zpygments.tokenr r r r r r r r r r r Zpygments.lexersr r Z"pygments.lexers._postgres_builtinsr r r r r Z pygments.lexers._mysql_builtinsr r r r r r r �__all__�compiler� rf r� r5 r? r r r r r ra r` r_ rW rG rH r! r" r� r� r� r� Zre_errorr� r� r# r$ r% r& r' r r( r) rE rE rE rF �<module> sf * 4 ���$%8" �I ; V : !*
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка