a
    ñ»jüh  ã                   @   sŽ   d Z dZdZdZdZdZedkrŠddlZdd	lm	Z	 dd
l
mZ dZed Zed Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zdd„ Zeƒ  dS )a  
    pygments.lexers._mysql_builtins
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    Self-updating data files for the MySQL lexer.

    Run with `python -I` to update.

    :copyright: Copyright 2006-present by the Pygments team, see AUTHORS.
    :license: BSD, see LICENSE for details.
)ÚfalseÚnullÚtrueÚunknown)=ZbigintÚbitÚboolÚbooleanÚdecÚdecimalÚdoubleÚfixedÚfloatZfloat4Zfloat8ÚintZint1Zint2Zint3Zint4Zint8ÚintegerZ	mediumintZ	middleintÚnumericÚ	precisionÚrealÚserialZsmallintZtinyintÚdateÚdatetimeÚtimeÚ	timestampÚyearÚbinaryZblobÚbyteÚcharÚenumÚlongZlongblobZlongtextZ
mediumblobZ
mediumtextZnationalZncharZnvarcharÚsetÚtextZtinyblobZtinytextZ	varbinaryZvarcharZvarcharacterZvaryingZgeometryZgeometrycollectionZ
linestringZmultilinestringZ
multipointZmultipolygonÚpointZpolygonÚjson(‡  ÚabsÚacosZadddateZaddtimeZaes_decryptZaes_encryptZ	any_valueÚasinÚatanÚatan2Z	benchmarkÚbinZbin_to_uuidZbit_andZ	bit_countÚ
bit_lengthZbit_orZbit_xorZcan_access_columnZcan_access_databaseZcan_access_eventZcan_access_resource_groupZcan_access_routineZcan_access_tableZcan_access_triggerZcan_access_userZcan_access_viewÚcastÚceilZceilingZchar_lengthZcharacter_lengthZcoercibilityÚcompressÚconcatZ	concat_wsZconnection_idÚconvZconvert_cpu_id_maskZ!convert_interval_to_user_intervalZ
convert_tzÚcosZcotÚcountÚcrc32ZcurdateZcurrent_roleZcurtimeZdate_addZdate_formatZdate_subZdatediffZdaynameZ
dayofmonthZ	dayofweekZ	dayofyearÚdegreesÚeltÚetagÚexpZ
export_setÚextractZextractvalueÚfieldZfind_in_setÚfloorZformat_bytesZformat_pico_timeZ
found_rowsZfrom_base64Z	from_daysZfrom_unixtimeZfrom_vectorZget_dd_column_privilegesZget_dd_create_optionsZget_dd_index_private_dataZget_dd_index_sub_part_lengthZget_dd_property_key_valueZget_dd_schema_optionsZget_dd_tablespace_private_dataZget_jdv_property_key_valueZget_lockZgreatestZgroup_concatZgtid_subsetZgtid_subtractÚhexZicu_versionZifnullZ
inet6_atonZ
inet6_ntoaÚ	inet_atonÚ	inet_ntoaÚinstrZinternal_auto_incrementZinternal_avg_row_lengthZinternal_check_timeZinternal_checksumZinternal_data_freeZinternal_data_lengthZinternal_dd_char_lengthZinternal_get_comment_or_errorZinternal_get_dd_column_extraZinternal_get_enabled_role_jsonZinternal_get_hostnameZ!internal_get_mandatory_roles_jsonZ internal_get_partition_nodegroupZinternal_get_usernameZ"internal_get_view_warning_or_errorZ!internal_index_column_cardinalityZinternal_index_lengthZinternal_is_enabled_roleZinternal_is_mandatory_roleZinternal_keys_disabledZinternal_max_data_lengthZinternal_table_rowsZ#internal_tablespace_autoextend_sizeZinternal_tablespace_data_freeZinternal_tablespace_extent_sizeZinternal_tablespace_extraZ internal_tablespace_free_extentsZinternal_tablespace_idZ internal_tablespace_initial_sizeZ&internal_tablespace_logfile_group_nameZ(internal_tablespace_logfile_group_numberZ internal_tablespace_maximum_sizeZinternal_tablespace_row_formatZinternal_tablespace_statusZ!internal_tablespace_total_extentsZinternal_tablespace_typeZinternal_tablespace_versionZinternal_update_timeZ!internal_use_terminology_previousZis_free_lockZis_ipv4Zis_ipv4_compatZis_ipv4_mappedÚis_ipv6Zis_used_lockZis_uuidZis_visible_dd_objectZisnullZ
json_arrayZjson_array_appendZjson_array_insertZjson_arrayaggZjson_containsZjson_contains_pathZ
json_depthZjson_duality_objectZjson_extractZjson_insertZ	json_keysZjson_lengthZ
json_mergeZjson_merge_patchZjson_merge_preserveZjson_objectZjson_objectaggZjson_overlapsZjson_prettyZ
json_quoteZjson_removeZjson_replaceZjson_schema_validZjson_schema_validation_reportZjson_searchZjson_setZjson_storage_freeZjson_storage_sizeZ	json_typeZjson_unquoteZ
json_validZlast_dayZlast_insert_idZlcaseZleastÚlengthZlike_range_maxZlike_range_minÚlnZ	load_fileÚlocateÚlogÚlog10Úlog2ÚlowerZlpadZltrimZmake_setZmakedateZmaketimeZmaster_pos_waitÚmaxZmbrcontainsZmbrcoveredbyZ	mbrcoversZmbrdisjointZ	mbrequalsZmbrintersectsZmbroverlapsZ
mbrtouchesZ	mbrwithinÚmd5ÚmidÚminÚ	monthnameZ
name_constÚnowZnullifÚoctZoctet_lengthÚordZ
period_addZperiod_diffÚpiÚpositionÚpowÚpowerZps_current_thread_idZps_thread_idÚquoteÚradiansZrandZrandom_bytesZregexp_instrZregexp_likeZregexp_replaceZregexp_substrZrelease_all_locksÚrelease_lockZremove_dd_property_keyÚreverseZroles_graphmlÚroundZrpadZrtrimZsec_to_timeZsession_userÚshaÚsha1Zsha2ÚsignÚsinÚsleepZsoundexZsource_pos_waitÚspaceÚsqrtZst_areaZst_asbinaryZst_asgeojsonZ	st_astextZst_aswkbZst_aswktZ	st_bufferZst_buffer_strategyZst_centroidZ
st_collectZst_containsZst_convexhullZ
st_crossesZst_differenceZst_dimensionZst_disjointZst_distanceZst_distance_sphereZst_endpointZst_envelopeZ	st_equalsZst_exteriorringZst_frechetdistanceZ
st_geohashZst_geomcollfromtextZst_geomcollfromtxtZst_geomcollfromwkbZst_geometrycollectionfromtextZst_geometrycollectionfromwkbZst_geometryfromtextZst_geometryfromwkbZst_geometrynZst_geometrytypeZst_geomfromgeojsonZst_geomfromtextZst_geomfromwkbZst_hausdorffdistanceZst_interiorringnZst_intersectionZst_intersectsZst_isclosedZ
st_isemptyZst_issimpleZ
st_isvalidZst_latfromgeohashZst_latitudeZ	st_lengthZst_linefromtextZst_linefromwkbZst_lineinterpolatepointZst_lineinterpolatepointsZst_linestringfromtextZst_linestringfromwkbZst_longfromgeohashZst_longitudeZst_makeenvelopeZst_mlinefromtextZst_mlinefromwkbZst_mpointfromtextZst_mpointfromwkbZst_mpolyfromtextZst_mpolyfromwkbZst_multilinestringfromtextZst_multilinestringfromwkbZst_multipointfromtextZst_multipointfromwkbZst_multipolygonfromtextZst_multipolygonfromwkbZst_numgeometriesZst_numinteriorringZst_numinteriorringsZst_numpointsZst_overlapsZst_pointatdistanceZst_pointfromgeohashZst_pointfromtextZst_pointfromwkbZ	st_pointnZst_polyfromtextZst_polyfromwkbZst_polygonfromtextZst_polygonfromwkbZst_simplifyZst_sridZst_startpointZ	st_swapxyZst_symdifferenceZ
st_touchesZst_transformZst_unionZst_validateZ	st_withinZst_xZst_yZstatement_digestZstatement_digest_textZstdZstddevZ
stddev_popZstddev_sampZstr_to_dateZstrcmpZstring_to_vectorZsubdateÚsubstrZ	substringZsubstring_indexZsubtimeÚsumZsysdateZsystem_userÚtanÚtime_formatZtime_to_secZtimediffZ	to_base64Zto_daysZ
to_secondsZ	to_vectorZtrimZucaseÚ
uncompressZuncompressed_lengthÚunhexZunix_timestampZ	updatexmlÚupperÚuuidZ
uuid_shortZuuid_to_binZvalidate_password_strengthZvar_popZvar_sampZvarianceZ
vector_dimZvector_to_stringÚversionZwait_for_executed_gtid_setZ!wait_until_sql_thread_after_gtidsÚweekdayZ
weekofyearZyearweek)*ZbkaZbnlZderived_condition_pushdownZdupsweedoutZ
firstmatchZgroup_indexZ	hash_joinÚindexZindex_mergeZ
intoexistsZjoin_fixed_orderZ
join_indexZ
join_orderZjoin_prefixZjoin_suffixZ	loosescanZmaterializationZmax_execution_timeÚmergeZmrrZno_bkaZno_bnlZno_derived_condition_pushdownZno_group_indexZno_hash_joinZno_icpÚno_indexZno_index_mergeZno_join_indexZno_mergeZno_mrrZno_order_indexZno_range_optimizationZno_semijoinZno_skip_scanZorder_indexZqb_nameZresource_groupZsemijoinZset_varZ	skip_scanZsubquery(Ð  ZabsentZ
accessibleÚaccountÚactionZactiveÚaddZadminÚafterZagainstZ	aggregateÚ	algorithmÚallZallow_missing_filesZalterÚalwaysZanalyzeÚandÚanyÚarrayÚasÚascÚasciiZ
asensitiveZ&assign_gtids_to_anonymous_transactionsÚatÚ	attributeZauthenticationÚautoZauto_incrementÚauto_refreshZauto_refresh_sourceZautoextend_sizeZavgZavg_row_lengthÚbackupÚbeforeÚbeginZ	bernoulliZbetweenZbinlogÚblockZbothZbtreeZbucketsZbulkZbyÚcacheÚcallZcascadeZcascadedÚcaseZcatalog_nameÚchainZchallenge_responseZchangeÚchangedZchannelÚ	characterÚcharsetÚcheckZchecksumÚcipherZclass_originÚclientÚcloneÚcloseZcoalesceÚcodeZcollateZ	collationÚcolumnZcolumn_formatZcolumn_nameÚcolumnsÚcommentÚcommitZ	committedÚcompactÚ
completionÚ	componentÚ
compressedÚcompressionZ
concurrentÚ	conditionÚ
connectionZ
consistentÚ
constraintZconstraint_catalogZconstraint_nameZconstraint_schemaÚcontainsÚcontextÚcontinueÚconvertÚcpuÚcreateÚcrossZcubeZ	cume_distÚcurrentZcurrent_dateÚcurrent_timeZcurrent_timestampZcurrent_userÚcursorZcursor_nameÚdataZdatabaseZ	databasesZdatafileÚdayZday_hourZday_microsecondZ
day_minuteZ
day_secondZ
deallocateZdeclareÚdefaultZdefault_authZdefinerZ
definitionZdelay_key_writeZdelayedÚdeleteZ
dense_rankÚdescZdescribeÚdescriptionZdeterministicZdiagnosticsÚ	directoryÚdisableÚdiscardZdiskZdistinctZdistinctrowÚdivÚdoZdropZdualZdualityZdumpfileZ	duplicateZdynamicZeachÚelseZelseifÚemptyÚenableZenclosedZ
encryptionÚendZendsZenforcedZengineZengine_attributeZenginesÚerrorÚerrorsÚescapeÚescapedÚeventÚeventsZeveryÚexceptZexchangeÚexcludeÚexecuteÚexistsÚexitZ	expansionZexpireZexplainZexportÚextendedZextent_sizeZexternalZexternal_formatÚfactorZfailed_login_attemptsr   ÚfastZfaultsÚfetchÚfieldsÚfileZfile_block_sizeZfile_formatÚ	file_nameZfile_patternZfile_prefixÚfilesÚfilterÚfinishÚfirstZfirst_valueÚflushZ	followingZfollowsÚforÚforceZforeignÚformatÚfoundÚfromÚfullZfulltextÚfunctionZgeneralÚgenerateÚ	generatedZgeomcollectionÚgetZ
get_formatZget_master_public_keyZget_source_public_keyÚglobalZgrantZgrantsÚgroupZgroup_replicationÚgroupingÚgroupsZ	gtid_onlyZgtidsÚhandlerÚhashZhavingÚheaderÚhelpZhigh_priorityZ	histogramÚhistoryÚhostÚhostsÚhourZhour_microsecondZhour_minuteZhour_secondZ
identifiedÚifÚignoreZignore_server_idsÚimportÚinZinactivere   ZindexesÚinfileÚinitialÚinitial_sizeZinitiateÚinnerZinoutZinsensitiveÚinsertZinsert_methodÚinstallÚinstanceZ	intersectÚintervalZintoZ	invisibleZinvokerÚioZio_after_gtidsZio_before_gtidsZ	io_threadZipcÚisZ	isolationZissuerZiterateÚjoinZ
json_tableZ
json_valueÚkeyZkey_block_sizeÚkeyringÚkeysÚkillZlagÚlanguageÚlastÚ
last_valueZlateralZleadÚleadingZleaveÚleavesÚleftÚlessÚlevelZlibraryZlikeÚlimitZlinearÚlinesÚlistÚloadÚlocalÚ	localtimeZlocaltimestampÚlockÚlockedÚlocksr?   ZlogfileÚlogsÚloopZlow_priorityZmanualZmasterZmaster_auto_positionZmaster_bindZmaster_compression_algorithmsZmaster_connect_retryZmaster_delayZmaster_heartbeat_periodZmaster_hostZmaster_log_fileZmaster_log_posZmaster_passwordZmaster_portZmaster_public_key_pathZmaster_retry_countZ
master_sslZmaster_ssl_caZmaster_ssl_capathZmaster_ssl_certZmaster_ssl_cipherZmaster_ssl_crlZmaster_ssl_crlpathZmaster_ssl_keyZmaster_ssl_verify_server_certZmaster_tls_ciphersuitesZmaster_tls_versionZmaster_userZmaster_zstd_compression_levelÚmatchZmax_connections_per_hourZmax_queries_per_hourZmax_rowsÚmax_sizeZmax_updates_per_hourZmax_user_connectionsZmaxvalueZmediumÚmemberZmemoryrf   Úmessage_textÚmicrosecondZmigrateZmin_rowsÚminuteZminute_microsecondZminute_secondÚmodÚmodeZmodifiesÚmodifyÚmonthÚmutexZmysql_errnoÚnameÚnamesZnaturalZndbZ
ndbclusterÚnestedZnetwork_namespaceÚneverÚnewÚnextÚnoZno_waitZno_write_to_binlogZ	nodegroupÚnoneÚnotZnowaitZ	nth_valueZntiler   ZnullsÚnumberZofÚoffÚoffsetZojÚoldÚonÚoneÚonlyÚopenÚoptimizeZoptimizer_costsÚoptionÚoptionalZ
optionallyÚoptionsÚorÚorderZ
ordinalityZorganizationZothersÚoutÚouterÚoutfileZoverÚownerZ	pack_keysÚpageÚparallelÚ
parametersZ
parse_treeÚparserÚpartialÚ	partitionZpartitioningZ
partitionsÚpasswordZpassword_lock_timeÚpathZpercent_rankZpersistZpersist_onlyZphaseÚpluginZ
plugin_dirÚpluginsÚportÚprecedesZ	precedingÚprepareZpreserveÚprevÚprimaryZprivilege_checks_userZ
privilegesZ	procedureÚprocessZprocesslistZprofileZprofilesÚproxyÚpurgeZqualifyZquarterÚqueryZquickÚrandomÚrangeZrankÚreadZ	read_onlyZ
read_writeZreadsZrebuildZrecoverÚ	recursiveZredo_buffer_sizeZ	redundantÚ	referenceZ
referencesÚregexpZregistrationZ
relationalZrelayZrelay_log_fileZrelay_log_posZrelay_threadZrelaylogÚreleaseÚreloadÚremoveÚrenameZ
reorganizeZrepairÚrepeatZ
repeatableÚreplaceZreplicaZreplicasZreplicate_do_dbZreplicate_do_tableZreplicate_ignore_dbZreplicate_ignore_tableZreplicate_rewrite_dbZreplicate_wild_do_tableZreplicate_wild_ignore_tableZreplicationÚrequireZrequire_row_formatZrequire_table_primary_key_checkÚresetZresignalÚresourceZrespectZrestartZrestoreZrestrictÚresumeZretainÚreturnZreturned_sqlstateZ	returningÚreturnsZreuserR   ZrevokeÚrightZrlikeZroleÚrollbackZrollupÚrotateZroutineÚrowÚ	row_countZ
row_formatZ
row_numberÚrowsZrtreeZs3Z	savepointZscheduleZschemaZschema_nameZschemasÚsecondZsecond_microsecondZ	secondaryZsecondary_engineZsecondary_engine_attributeZsecondary_loadZsecondary_unloadÚsecurityÚselectZ	sensitiveÚ	separatorZserializableÚserverÚsessionÚshareÚshowÚshutdownÚsignalÚsignedÚsimpleÚskipZslaveZslowZsnapshotÚsocketZsomeZsonameZsoundsÚsourceZsource_auto_positionZsource_bindZsource_compression_algorithmsZsource_connect_retryZsource_connection_auto_failoverZsource_delayZsource_heartbeat_periodZsource_hostZsource_log_fileZsource_log_posZsource_passwordZsource_portZsource_public_key_pathZsource_retry_countZ
source_sslZsource_ssl_caZsource_ssl_capathZsource_ssl_certZsource_ssl_cipherZsource_ssl_crlZsource_ssl_crlpathZsource_ssl_keyZsource_ssl_verify_server_certZsource_tls_ciphersuitesZsource_tls_versionZsource_userZsource_zstd_compression_levelZspatialZspecificÚsqlZsql_after_gtidsZsql_after_mts_gapsZsql_before_gtidsZsql_big_resultZsql_buffer_resultZsql_calc_found_rowsZsql_no_cacheZsql_small_resultZ
sql_threadZsql_tsi_dayZsql_tsi_hourZsql_tsi_minuteZsql_tsi_monthZsql_tsi_quarterZsql_tsi_secondZsql_tsi_weekZsql_tsi_yearZsqlexceptionZsqlstateZ
sqlwarningZsridÚsslZstackedÚstartÚstartingZstartsZstats_auto_recalcZstats_persistentZstats_sample_pagesÚstatusÚstopZstorageZstoredZstraight_joinÚstreamZstrict_loadÚstringZsubclass_originÚsubjectZsubpartitionZsubpartitionsÚsuperZsuspendZswapsZswitchesÚsystemÚtableZtable_checksumZ
table_nameZtablesZtablesampleZ
tablespaceÚ	temporaryZ	temptableZ
terminatedZthanZthenZthread_priorityZtiesZtimestampaddZtimestampdiffÚtlsÚtoZtrailingZtransactionÚtriggerÚtriggersr   ÚtruncateÚtypeÚtypesZ	unboundedZuncommittedZ	undefinedZundoZundo_buffer_sizeZundofileÚunicodeÚ	uninstallÚunionÚuniquer   ÚunlockÚ
unregisterZunsignedZuntilÚupdateÚupgradeÚuriÚurlÚusageZuseZuse_frmÚuserZuser_resourcesÚusingZutc_dateZutc_timeZutc_timestampZ
validationÚvalueÚvaluesÚ	variablesZvcpuZvectorZverify_key_constraintsÚviewZvirtualÚvisibleÚwaitÚwarningsÚweekZweight_stringÚwhenÚwhereÚwhileZwindowÚwithZwithoutZworkÚwrapperÚwriteÚx509ZxaÚxidÚxmlÚxorZ
year_monthZzerofillÚzoneÚ__main__é    N)Úurlopen)Úformat_linesz/https://github.com/mysql/mysql-server/raw/trunkz
/sql/lex.hz/sql/item_create.ccc                  C   s˜   t tƒ ¡ jddd�} t| ƒ}t| ƒ}t| ƒ}t tƒ ¡ jddd�}| t	|ƒ¡ |t
tƒ8 }tdtt|ƒƒƒ tdtt|ƒƒƒ tdtt|ƒƒƒ d S )NÚutf8rÝ   )r°   ÚMYSQL_FUNCTIONSÚMYSQL_KEYWORDSÚMYSQL_OPTIMIZER_HINTS)r˜  ÚLEX_URLr=  ÚdecodeÚparse_lex_keywordsÚparse_lex_functionsÚparse_lex_optimizer_hintsÚITEM_CREATE_URLr|  Úparse_item_create_functionsr   ÚMYSQL_DATATYPESÚupdate_contentÚtupleÚsorted)Zlex_fileÚkeywordsZ	functionsZoptimizer_hintsZitem_create_file© rª  úEE:\soccer\ml_env\Lib\site-packages\pygments/lexers/_mysql_builtins.pyÚupdate_myself  s    r¬  c                 C   sB   t ƒ }tjd| tjd�D ]}| | d¡ ¡ ¡ q|s>tdƒ‚|S )zParse keywords in lex.h.z({SYM(?:_HK)?\("(?P<keyword>[a-z0-9_]+)",©ÚflagsÚkeywordzNo keywords found©r   ÚreÚfinditerÚIrj   rÑ   rB   Ú
ValueError©ÚfÚresultsÚmrª  rª  r«  r   "  s    r   c                 C   sB   t ƒ }tjd| tjd�D ]}| | d¡ ¡ ¡ q|s>tdƒ‚|S )zParse optimizer hints in lex.h.z"{SYM_H\("(?P<keyword>[a-z0-9_]+)",r­  r¯  zNo optimizer hints foundr°  rµ  rª  rª  r«  r¢  /  s    r¢  c                 C   sB   t ƒ }tjd| tjd�D ]}| | d¡ ¡ ¡ q|s>tdƒ‚|S )z&Parse MySQL function names from lex.h.z%{SYM_FN?\("(?P<function>[a-z0-9_]+)",r­  rÌ   zNo lex functions foundr°  rµ  rª  rª  r«  r¡  <  s    r¡  c                 C   sB   t ƒ }tjd| tjd�D ]}| | d¡ ¡ ¡ q|s>tdƒ‚|S )z/Parse MySQL function names from item_create.cc.z({"(?P<function>[^"]+?)",\s*SQL_F[^(]+?\(r­  rÌ   zNo item_create functions foundr°  rµ  rª  rª  r«  r¤  I  s    r¤  c                 C   sØ   t tdd��}| ¡ }W d  ƒ n1 s*0    Y  t d| › d�tjtjB ¡}| |¡}|sltd| › �ƒ‚t	| |ƒ}|d| 
¡ … | || ¡ d…  }t tdddd	��}| |¡ W d  ƒ n1 sÊ0    Y  dS )
zAOverwrite this file with content parsed from MySQL's source code.zutf-8)ÚencodingNú^z\s*=\s*\($.*?^\s*\)$z*Could not find an existing definition for ÚwÚ
)r¹  Únewline)r  Ú__file__r=  r±  ÚcompileÚMÚSÚsearchr´  r™  rd  r®   r�  )Ú
field_nameÚcontentr¶  r    Zre_matchr¸  Z	new_blockrª  rª  r«  r¦  V  s    &

$r¦  )Ú__doc__ZMYSQL_CONSTANTSr¥  r›  r�  rœ  Ú__name__r±  Úurllib.requestr˜  Zpygments.utilr™  Z
SOURCE_URLrž  r£  r¬  r   r¢  r¡  r¤  r¦  rª  rª  rª  r«  Ú<module>   s6   M   .     Y