a
    ¨ˆcÎd  ã                   @   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-2022 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ÚnumericZ	precisionÚrealÚserialZsmallintZtinyintÚdateÚdatetimeÚtimeÚ	timestampÚyearÚbinaryZblobÚcharÚenumÚlongZlongblobZlongtextZ
mediumblobZ
mediumtextZnationalZncharZnvarcharÚsetÚtextZtinyblobZtinytextZ	varbinaryZvarcharZvarcharacterZvaryingZgeometryZgeometrycollectionZ
linestringZmultilinestringZ
multipointZmultipolygonZ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ÚexpZ
export_setÚextractZextractvalueÚfieldZfind_in_setÚfloorZformat_bytesZformat_pico_timeZ
found_rowsZfrom_base64Z	from_daysZfrom_unixtimeZ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_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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_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_fileZlocateÚlogÚlog10Úlog2ÚlowerZlpadZltrimZmake_setZmakedateZmaketimeZmaster_pos_waitÚmaxZmbrcontainsZmbrcoveredbyZ	mbrcoversZmbrdisjointZ	mbrequalsZmbrintersectsZmbroverlapsZ
mbrtouchesZ	mbrwithinÚmd5Z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subdateÚsubstrZ	substringZsubstring_indexZsubtimeÚsumZsysdateZsystem_userÚtanÚtime_formatZtime_to_secZtimediffZ	to_base64Zto_daysZ
to_secondsZtrimZucaseÚ
uncompressZuncompressed_lengthÚunhexZunix_timestampZ	updatexmlÚupperÚuuidZ
uuid_shortZuuid_to_binZvalidate_password_strengthZvar_popZvar_sampZvarianceÚ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
accessibleÚaccountÚactionÚactiveÚaddZadminÚafterZagainstZ	aggregateÚ	algorithmÚallZalterÚalwaysZanalyzeÚandÚanyÚarrayÚasZascÚasciiZ
asensitiveZ&assign_gtids_to_anonymous_transactionsÚatÚ	attributeZauthenticationZauto_incrementZautoextend_sizeÚavgZavg_row_lengthÚbackupÚbeforeÚbeginZbetweenZbinlogÚblockZbothZbtreeZbucketsZbyÚbyteÚcacheÚcallZcascadeZcascadedZ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ÚcreateZ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ÚdivZdoZdropZdualZ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expireÚexplainÚexportÚextendedZextent_sizeZfactorZfailed_login_attemptsr   ÚfastZfaultsÚfetchÚfieldsÚfileZfile_block_sizeÚfilterÚfinishÚfirstZfirst_valueÚflushZ	followingZfollowsÚforÚforceZforeignÚformatÚfoundÚfromÚfullZfulltextÚfunctionZgeneralÚ	generatedZgeomcollectionÚgetZ
get_formatZget_master_public_keyZget_source_public_keyÚglobalZgrantZgrantsÚgroupZgroup_replicationÚgroupingÚgroupsZ	gtid_onlyÚhandlerÚhashZhavingÚhelpZhigh_priorityZ	histogramÚhistoryÚhostÚhostsÚhourZhour_microsecondZhour_minuteZhour_secondZ
identifiedÚifÚignoreZignore_server_idsÚimportÚinZinactiver_   ZindexesÚinfileÚinitialÚinitial_sizeZinitiateÚinnerZinoutZinsensitiveÚinsertZinsert_methodÚinstallÚinstanceÚ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leaveZleavesÚleftZlessÚlevelÚlikeÚlimitZlinearÚlinesÚlistÚloadÚlocalÚ	localtimeZlocaltimestampÚlockÚlockedÚlocksÚlogfileZlogsZloopZlow_priorityZ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memoryr`   Z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ÚonZoneÚonlyÚopenÚoptimizeZoptimizer_costsÚoptionÚoptionalZ
optionallyÚoptionsÚorÚorderZ
ordinalityZorganizationZothersÚoutÚouterÚoutfileZoverÚownerZ	pack_keysÚpageÚparserÚpartialÚ	partitionZpartitioningZ
partitionsÚpasswordZpassword_lock_timeÚpathZpercent_rankZpersistZpersist_onlyÚphaseZpluginZ
plugin_dirZpluginsÚportÚprecedesZ	precedingÚprepareÚpreserveÚprevZprimaryZprivilege_checks_userZ
privilegesZ	procedureÚprocessZprocesslistZprofileZprofilesÚproxyÚpurgeZquarterÚqueryZquickÚrandomÚrangeZrankÚreadZ	read_onlyZ
read_writeZreadsZrebuildZrecoverÚ	recursiveZredo_buffer_sizeZ	redundantÚ	referenceZ
referencesÚregexpZregistrationZ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restartÚrestoreZrestrictÚresumeZretainÚreturnZreturned_sqlstateZ	returningÚreturnsZreuserL   ZrevokeÚrightZrlikeÚroleÚrollbackZrollupÚrotateZroutineÚrowZ	row_countZ
row_formatZ
row_numberÚrowsZrtreeZ	savepointÚscheduleZschemaZschema_nameZschemasÚsecondZsecond_microsecondZ	secondaryZsecondary_engineZsecondary_engine_attributeZsecondary_loadZsecondary_unloadÚsecurityÚselectZ	sensitiveÚ	separatorZserializableÚserverÚsessionZ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specificZ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ÚstartZstartingZstartsZstats_auto_recalcZstats_persistentZstats_sample_pagesÚstatusÚstopZstorageZstoredZstraight_joinÚstreamÚstringZsubclass_originÚsubjectZsubpartitionZsubpartitionsÚsuperZsuspendZswapsZswitchesÚsystemÚtableZtable_checksumZ
table_nameZtablesZ
tablespaceÚ	temporaryZ	temptableZ
terminatedZthanZthenZthread_priorityZtiesZtimestampaddZtimestampdiffZtlsÚtoZtrailingZtransactionZtriggerZtriggersr   ÚtruncateÚtypeÚtypesZ	unboundedZuncommittedZ	undefinedZundoZundo_buffer_sizeZundofileÚunicodeÚ	uninstallÚunionÚuniquer   ZunlockÚ
unregisterZunsignedZuntilÚupdateÚupgradeÚusageZuseZuse_frmÚuserZuser_resourcesZusingZutc_dateZutc_timeZutc_timestampZ
validationÚvalueÚvaluesÚ	variablesZvcpuÚviewZvirtualZ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/8.0z
/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_URLrd  Úparse_item_create_functionsr   ÚMYSQL_DATATYPESÚupdate_contentÚtupleÚsorted)Zlex_fileÚkeywordsZ	functionsZoptimizer_hintsZitem_create_file© rŽ  úb/home/yuhw/wc/wire-cell-python/wcpy/lib/python3.9/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ÚIre   rÆ   r=   Ú
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ˆ    s    rˆ  c                 C   sÌ   t tƒ�}| ¡ }W d  ƒ n1 s&0    Y  t d|  tjtjB ¡}| |¡}|sbtd|  ƒ‚t	| |ƒ}|d| 
¡ … | || ¡ d…  }t tddd��}| |¡ W d  ƒ n1 s¾0    Y  dS )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Ú
)Únewline)r  Ú__file__r*  r•  ÚcompileÚMÚSÚsearchr˜  r}  rQ  r¥   rt  )Ú
field_nameÚcontentrš  r˜   Úre_matchrœ  Z	new_blockrŽ  rŽ  r�  rŠ  %  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   L   .     8