/ lib / pygments / lexers / _mysql_builtins.pyc
_mysql_builtins.pyc
  1  o

  2   ��c�d�@s�dZdZdZdZdZdZedkrGddlZdd	lm	Z	dd
  3  l
  4  mZdZedZ
ed
Zdd�Zdd�Zdd�Zdd�Zdd�Zdd�Ze�dSdS)a
  5      pygments.lexers._mysql_builtins
  6      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  7  
  8      Self-updating data files for the MySQL lexer.
  9  
 10      Run with `python -I` to update.
 11  
 12      :copyright: Copyright 2006-2022 by the Pygments team, see AUTHORS.
 13      :license: BSD, see LICENSE for details.
 14  )�false�null�true�unknown)<�bigint�bit�bool�boolean�dec�decimal�double�fixed�float�float4�float8�int�int1�int2�int3�int4�int8�integerZ	mediumintZ	middleint�numeric�	precision�real�serial�smallint�tinyint�date�datetime�time�	timestamp�year�binary�blob�char�enum�longZlongblobZlongtextZ
 15  mediumblobZ
 16  mediumtext�national�nchar�nvarchar�set�textZtinyblobZtinytext�	varbinary�varcharZvarcharacter�varying�geometryZgeometrycollectionZ
 17  linestringZmultilinestringZ
 18  multipointZmultipolygon�point�polygon�json(~�abs�acosZadddateZaddtimeZaes_decryptZaes_encryptZ	any_value�asin�atan�atan2�	benchmark�binZbin_to_uuidZbit_and�	bit_count�
 19  bit_lengthZbit_orZbit_xorZcan_access_columnZcan_access_databaseZcan_access_eventZcan_access_resource_groupZcan_access_routineZcan_access_tableZcan_access_triggerZcan_access_userZcan_access_view�cast�ceil�ceiling�char_length�character_lengthZcoercibility�compress�concatZ	concat_wsZ
connection_id�convZconvert_cpu_id_maskZ!convert_interval_to_user_intervalZ
 20  convert_tz�cos�cot�count�crc32Zcurdate�current_roleZcurtime�date_add�date_format�date_sub�datediff�dayname�
 21  dayofmonth�	dayofweek�	dayofyear�degrees�elt�expZ
 22  export_set�extract�extractvalue�fieldZfind_in_set�floorZformat_bytesZformat_pico_timeZ
 23  found_rowsZfrom_base64Z	from_daysZ
from_unixtimeZget_dd_column_privilegesZget_dd_create_optionsZget_dd_index_private_dataZget_dd_index_sub_part_lengthZget_dd_property_key_valueZget_dd_schema_optionsZget_dd_tablespace_private_data�get_lockZgreatestZgroup_concatZgtid_subsetZ
gtid_subtract�hexZicu_version�ifnullZ
 24  inet6_atonZ
 25  inet6_ntoa�	inet_aton�	inet_ntoa�instrZinternal_auto_incrementZinternal_avg_row_lengthZinternal_check_timeZinternal_checksumZinternal_data_freeZinternal_data_lengthZinternal_dd_char_lengthZinternal_get_comment_or_errorZinternal_get_dd_column_extraZinternal_get_enabled_role_jsonZinternal_get_hostnameZ!internal_get_mandatory_roles_jsonZ internal_get_partition_nodegroupZinternal_get_usernameZ"internal_get_view_warning_or_errorZ!internal_index_column_cardinalityZinternal_index_lengthZinternal_is_enabled_roleZinternal_is_mandatory_roleZinternal_keys_disabledZinternal_max_data_lengthZinternal_table_rowsZ#internal_tablespace_autoextend_sizeZinternal_tablespace_data_freeZinternal_tablespace_extent_sizeZinternal_tablespace_extraZ internal_tablespace_free_extentsZinternal_tablespace_idZ internal_tablespace_initial_sizeZ&internal_tablespace_logfile_group_nameZ(internal_tablespace_logfile_group_numberZ internal_tablespace_maximum_sizeZinternal_tablespace_row_formatZinternal_tablespace_statusZ!internal_tablespace_total_extentsZinternal_tablespace_typeZinternal_tablespace_versionZinternal_update_timeZis_free_lockZis_ipv4Zis_ipv4_compatZis_ipv4_mapped�is_ipv6Zis_used_lockZis_uuidZis_visible_dd_object�isnullZ
 26  json_arrayZjson_array_appendZjson_array_insertZ
json_arrayaggZ
json_containsZjson_contains_pathZ
 27  json_depthZjson_extractZjson_insertZ	json_keysZjson_lengthZ
 28  json_mergeZjson_merge_patchZjson_merge_preserve�json_objectZjson_objectaggZ
json_overlapsZjson_prettyZ
 29  json_quoteZjson_removeZjson_replaceZjson_schema_validZjson_schema_validation_reportZjson_searchZjson_setZjson_storage_freeZjson_storage_sizeZ	json_typeZjson_unquoteZ
 30  json_validZlast_dayZlast_insert_idZlcaseZleast�lengthZlike_range_maxZlike_range_min�ln�	load_file�locate�log�log10�log2�lowerZlpad�ltrimZmake_set�makedate�maketimeZmaster_pos_wait�maxZmbrcontainsZmbrcoveredbyZ	mbrcoversZmbrdisjointZ	mbrequalsZ
mbrintersectsZmbroverlapsZ
 31  mbrtouchesZ	mbrwithin�md5�mid�min�	monthnameZ
 32  name_const�now�nullif�oct�octet_length�ordZ
 33  period_addZperiod_diff�pi�position�pow�powerZps_current_thread_idZps_thread_id�quote�radians�rand�random_bytesZregexp_instrZregexp_likeZregexp_replaceZ
regexp_substrZrelease_all_locks�release_lockZremove_dd_property_key�reverseZ
roles_graphml�roundZrpad�rtrimZsec_to_time�session_user�sha�sha1�sha2�sign�sin�sleep�soundexZsource_pos_wait�space�sqrtZst_areaZst_asbinaryZst_asgeojsonZ	st_astextZst_aswkbZst_aswktZ	st_bufferZst_buffer_strategyZst_centroidZ
 34  st_collectZst_containsZ
st_convexhullZ
 35  st_crossesZ
st_differenceZst_dimensionZst_disjointZst_distanceZst_distance_sphereZst_endpointZst_envelopeZ	st_equalsZst_exteriorringZst_frechetdistanceZ
 36  st_geohashZst_geomcollfromtextZst_geomcollfromtxtZst_geomcollfromwkbZst_geometrycollectionfromtextZst_geometrycollectionfromwkbZst_geometryfromtextZst_geometryfromwkbZst_geometrynZst_geometrytypeZst_geomfromgeojsonZst_geomfromtextZst_geomfromwkbZst_hausdorffdistanceZst_interiorringnZst_intersectionZ
st_intersectsZst_isclosedZ
 37  st_isemptyZst_issimpleZ
 38  st_isvalidZst_latfromgeohashZst_latitudeZ	st_lengthZst_linefromtextZst_linefromwkbZst_lineinterpolatepointZst_lineinterpolatepointsZst_linestringfromtextZst_linestringfromwkbZst_longfromgeohashZst_longitudeZst_makeenvelopeZst_mlinefromtextZst_mlinefromwkbZst_mpointfromtextZst_mpointfromwkbZst_mpolyfromtextZst_mpolyfromwkbZst_multilinestringfromtextZst_multilinestringfromwkbZst_multipointfromtextZst_multipointfromwkbZst_multipolygonfromtextZst_multipolygonfromwkbZst_numgeometriesZst_numinteriorringZst_numinteriorringsZst_numpointsZst_overlapsZst_pointatdistanceZst_pointfromgeohashZst_pointfromtextZst_pointfromwkbZ	st_pointnZst_polyfromtextZst_polyfromwkbZst_polygonfromtextZst_polygonfromwkbZst_simplifyZst_sridZ
st_startpointZ	st_swapxyZst_symdifferenceZ
 39  st_touchesZst_transformZst_unionZst_validateZ	st_withinZst_xZst_yZstatement_digestZstatement_digest_text�std�stddev�
 40  stddev_pop�stddev_sampZstr_to_date�strcmpZsubdate�substr�	substringZsubstring_indexZsubtime�sumZsysdate�system_user�tan�time_formatZtime_to_secZtimediffZ	to_base64Zto_daysZ
 41  to_seconds�trimZucase�
 42  uncompressZuncompressed_length�unhexZunix_timestampZ	updatexml�upper�uuidZ
 43  uuid_shortZuuid_to_binZvalidate_password_strength�var_pop�var_samp�variance�versionZwait_for_executed_gtid_setZ!wait_until_sql_thread_after_gtids�weekday�
 44  weekofyearZyearweek)*ZbkaZbnlZderived_condition_pushdownZdupsweedoutZ
 45  firstmatch�group_indexZ	hash_join�indexZindex_mergeZ
 46  intoexistsZjoin_fixed_order�
 47  join_indexZ
 48  join_orderZjoin_prefixZjoin_suffixZ	loosescanZmaterializationZmax_execution_time�mergeZmrrZno_bkaZno_bnlZno_derived_condition_pushdownZno_group_indexZno_hash_joinZno_icpZno_indexZno_index_mergeZ
no_join_indexZno_mergeZno_mrrZno_order_indexZno_range_optimizationZno_semijoinZno_skip_scanZorder_indexZqb_nameZresource_groupZsemijoinZset_varZ	skip_scanZsubquery(�Z
 49  accessible�account�action�active�add�admin�after�against�	aggregate�	algorithm�all�alter�always�analyze�and�any�array�as�asc�ascii�
 50  asensitiveZ&assign_gtids_to_anonymous_transactions�at�	attributeZauthenticationZauto_incrementZautoextend_size�avgZavg_row_length�backup�before�begin�betweenZbinlog�block�bothZbtree�buckets�by�byte�cache�call�cascade�cascaded�caseZcatalog_name�chainZchallenge_response�change�changed�channel�	character�charset�check�checksum�cipherZclass_origin�client�clone�close�coalesce�code�collate�	collation�column�
column_format�column_name�columns�comment�commitZ	committed�compact�
 51  completion�	component�
 52  compressed�compression�
 53  concurrent�	condition�
 54  connectionZ
 55  consistent�
 56  constraintZconstraint_catalogZconstraint_nameZconstraint_schema�contains�context�continue�convert�cpu�create�cross�cube�	cume_dist�current�current_date�current_time�current_timestamp�current_user�cursorZcursor_name�data�databaseZ	databases�datafile�dayZday_hourZday_microsecondZ
 57  day_minuteZ
 58  day_second�
 59  deallocate�declare�defaultZdefault_authZdefiner�
 60  definitionZdelay_key_write�delayed�delete�
 61  dense_rank�desc�describe�description�
deterministic�diagnostics�	directory�disable�discard�disk�distinctZdistinctrow�div�do�drop�dualZdumpfile�	duplicate�dynamic�each�else�elseif�empty�enable�enclosedZ
 62  encryption�end�endsZenforced�engineZengine_attributeZengines�error�errors�escape�escaped�event�events�every�except�exchange�exclude�execute�exists�exit�	expansion�expire�explain�export�extendedZextent_size�factorZfailed_login_attemptsr�fast�faults�fetch�fields�fileZfile_block_size�filter�finish�first�first_value�flush�	following�follows�for�force�foreign�format�found�from�fullZfulltext�function�general�	generatedZgeomcollection�get�
 63  get_formatZget_master_public_keyZget_source_public_key�global�grantZgrants�groupZgroup_replication�grouping�groupsZ	gtid_only�handler�hash�having�helpZ
high_priority�	histogram�history�host�hosts�hourZhour_microsecondZhour_minuteZhour_secondZ
 64  identified�if�ignoreZignore_server_ids�import�in�inactiver��indexes�infile�initial�initial_sizeZinitiate�inner�inout�insensitive�insertZ
insert_method�install�instance�interval�into�	invisibleZinvoker�ioZio_after_gtidsZio_before_gtids�	io_thread�ipc�is�	isolation�issuer�iterate�joinZ
 65  json_table�
 66  json_value�keyZkey_block_sizeZkeyring�keys�kill�lag�language�last�
 67  last_value�lateral�lead�leading�leave�leaves�left�less�level�like�limit�linear�lines�list�load�local�	localtime�localtimestamp�lock�locked�locks�logfile�logs�loopZlow_priority�masterZmaster_auto_positionZmaster_bindZmaster_compression_algorithmsZmaster_connect_retryZmaster_delayZmaster_heartbeat_periodZmaster_hostZmaster_log_fileZmaster_log_posZmaster_passwordZmaster_portZmaster_public_key_pathZmaster_retry_countZ
 68  master_sslZ
master_ssl_caZmaster_ssl_capathZmaster_ssl_certZmaster_ssl_cipherZmaster_ssl_crlZmaster_ssl_crlpathZmaster_ssl_keyZmaster_ssl_verify_server_certZmaster_tls_ciphersuitesZmaster_tls_versionZmaster_userZmaster_zstd_compression_level�matchZmax_connections_per_hourZmax_queries_per_hour�max_rows�max_sizeZmax_updates_per_hourZmax_user_connections�maxvalue�medium�member�memoryr�Zmessage_text�microsecond�migrate�min_rows�minuteZminute_microsecondZ
minute_second�mod�mode�modifies�modify�month�mutex�mysql_errno�name�names�natural�ndbZ
 69  ndbcluster�nestedZnetwork_namespace�never�new�next�noZno_waitZno_write_to_binlog�	nodegroup�none�notZnowaitZ	nth_value�ntiler�nulls�number�of�off�offsetZoj�old�on�one�only�open�optimizeZoptimizer_costs�option�optionalZ
 70  optionally�options�or�order�
 71  ordinality�organization�others�out�outer�outfile�over�ownerZ	pack_keys�page�parser�partial�	partition�partitioning�
 72  partitions�passwordZpassword_lock_time�path�percent_rankZpersistZpersist_only�phase�pluginZ
 73  plugin_dir�plugins�port�precedes�	preceding�prepare�preserve�prev�primaryZprivilege_checks_user�
 74  privileges�	procedure�processZprocesslist�profile�profiles�proxy�purge�quarter�query�quick�random�range�rank�read�	read_onlyZ
 75  read_write�reads�rebuild�recover�	recursiveZredo_buffer_sizeZ	redundant�	reference�
 76  references�regexpZregistration�relayZrelay_log_fileZ
relay_log_posZrelay_threadZrelaylog�release�reload�remove�rename�
 77  reorganizeZrepair�repeatZ
 78  repeatable�replaceZreplicaZreplicasZreplicate_do_dbZreplicate_do_tableZreplicate_ignore_dbZreplicate_ignore_tableZreplicate_rewrite_dbZreplicate_wild_do_tableZreplicate_wild_ignore_table�replication�requireZrequire_row_formatZrequire_table_primary_key_check�resetZresignal�resourceZrespect�restart�restore�restrict�resume�retain�returnZreturned_sqlstate�	returning�returnsZreuser�revoke�rightZrlike�role�rollback�rollup�rotate�routine�row�	row_countZ
 79  row_format�
 80  row_number�rowsZrtree�	savepoint�schedule�schema�schema_name�schemas�secondZsecond_microsecondZ	secondaryZsecondary_engineZsecondary_engine_attributeZsecondary_loadZsecondary_unload�security�select�	sensitive�	separatorZserializable�server�session�share�show�shutdown�signal�signed�simple�skipZslave�slow�snapshot�socket�some�sonameZsounds�sourceZsource_auto_positionZsource_bindZsource_compression_algorithmsZsource_connect_retryZsource_connection_auto_failoverZsource_delayZsource_heartbeat_periodZsource_hostZsource_log_fileZsource_log_posZsource_passwordZsource_portZsource_public_key_pathZsource_retry_countZ
 81  source_sslZ
source_ssl_caZsource_ssl_capathZsource_ssl_certZsource_ssl_cipherZsource_ssl_crlZsource_ssl_crlpathZsource_ssl_keyZsource_ssl_verify_server_certZsource_tls_ciphersuitesZsource_tls_versionZsource_userZsource_zstd_compression_levelZspatial�specific�sqlZsql_after_gtidsZsql_after_mts_gapsZsql_before_gtidsZsql_big_resultZsql_buffer_resultZsql_calc_found_rowsZsql_no_cacheZsql_small_resultZ
 82  sql_threadZsql_tsi_dayZsql_tsi_hourZsql_tsi_minuteZ
sql_tsi_monthZsql_tsi_quarterZsql_tsi_secondZsql_tsi_weekZsql_tsi_year�sqlexception�sqlstate�
 83  sqlwarningZsrid�ssl�stacked�start�starting�startsZstats_auto_recalcZstats_persistentZstats_sample_pages�status�stop�storage�storedZ
straight_join�stream�stringZsubclass_origin�subjectZsubpartitionZ
subpartitions�super�suspendZswaps�switches�system�tableZtable_checksum�
 84  table_name�tablesZ
 85  tablespace�	temporaryZ	temptable�
 86  terminated�than�thenZthread_priority�tiesZtimestampaddZ
timestampdiff�tls�to�trailing�transaction�triggerZtriggersr�truncate�type�types�	unboundedZuncommitted�	undefined�undoZundo_buffer_size�undofile�unicode�	uninstall�union�uniquer�unlock�
 87  unregister�unsigned�until�update�upgrade�usage�useZuse_frm�userZuser_resources�usingZutc_date�utc_timeZ
utc_timestamp�
 88  validation�value�values�	variables�vcpu�view�virtual�visible�wait�warnings�weekZ
weight_string�when�where�while�window�with�without�work�wrapper�write�x509�xa�xid�xml�xor�
 89  year_monthZzerofill�zone�__main__�N)�urlopen)�format_linesz-https://github.com/mysql/mysql-server/raw/8.0z
 90  /sql/lex.hz/sql/item_create.cccCs�tt���jddd�}t|�}t|�}t|�}tt���jddd�}|�t	|��|t
 91  t�8}tdt
t|���tdt
t|���tdt
t|���dS)N�utf8rW)r�MYSQL_FUNCTIONS�MYSQL_KEYWORDS�MYSQL_OPTIMIZER_HINTS)r}�LEX_URLr��decode�parse_lex_keywords�parse_lex_functions�parse_lex_optimizer_hints�ITEM_CREATE_URLrY�parse_item_create_functionsr*�MYSQL_DATATYPES�update_content�tuple�sorted)Zlex_file�keywords�	functionsZoptimizer_hintsZitem_create_file�r���C:\Users\Jacks.GUTTSPC\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\pygments\lexers\_mysql_builtins.py�
update_myself�sr�cC�Bt�}tjd|tjd�D]}|�|�d����q|std��|S)zParse keywords in lex.h.z({SYM(?:_HK)?\("(?P<keyword>[a-z0-9_]+)",��flags�keywordzNo keywords found�r*�re�finditer�Ir�rJrh�
 92  ValueError��f�results�mr�r�r�r���r�cCr�)zParse optimizer hints in lex.h.z"{SYM_H\("(?P<keyword>[a-z0-9_]+)",r�r�zNo optimizer hints foundr�r�r�r�r�r��r�r�cCr�)z&Parse MySQL function names from lex.h.z%{SYM_FN?\("(?P<function>[a-z0-9_]+)",r�rCzNo lex functions foundr�r�r�r�r�r�r�r�cCr�)z/Parse MySQL function names from item_create.cc.z({"(?P<function>[^"]+?)",\s*SQL_F[^(]+?\(r�rCzNo item_create functions foundr�r�r�r�r�r�r�r�cCs�tt��}|��}Wd�n1swYt�d|tjtjB�}|�|�}|s1td|��t	||�}|d|�
 93  ��|||��d�}ttddd��}|�|�Wd�dS1s`wYdS)zAOverwrite this file with content parsed from MySQL's source code.Nz^%s\s*=\s*\($.*?^\s*\)$z,Could not find an existing definition for %s�w�
 94  )�newline)
r��__file__r�r��compile�M�S�searchr�r~r/rrs)�
 95  field_name�contentr�r��re_matchr��	new_blockr�r�r�r�%s
 96  
 97  �
 98  
 99  $"�r�)�__doc__�MYSQL_CONSTANTSr�r�r�r��__name__r��urllib.requestr}�
pygments.utilr~�
100  SOURCE_URLr�r�r�r�r�r�r�r�r�r�r�r��<module>s:
L.8



101  �