From 431b594ec3d5d82cc2ec4bbea8766839181d6b18 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Maur=C3=ADcio=20Meneghini=20Fauth?= Date: Tue, 5 Jul 2022 15:47:12 -0300 Subject: Change doclinks.js to use JS modules MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Maurício Meneghini Fauth --- js/src/doclinks.js | 367 ------------------------------------------- js/src/functions.js | 2 +- js/src/modules/doc-links.js | 365 ++++++++++++++++++++++++++++++++++++++++++ libraries/classes/Header.php | 1 - webpack.config.cjs | 1 - 5 files changed, 366 insertions(+), 370 deletions(-) delete mode 100644 js/src/doclinks.js create mode 100644 js/src/modules/doc-links.js diff --git a/js/src/doclinks.js b/js/src/doclinks.js deleted file mode 100644 index 52b09d1b3c..0000000000 --- a/js/src/doclinks.js +++ /dev/null @@ -1,367 +0,0 @@ -/** - * Definition of links to MySQL documentation. - */ - -var mysqlDocKeyword = { - /* Multi word */ - 'CHARACTER SET': ['charset'], - 'SHOW AUTHORS': ['show-authors'], - 'SHOW BINARY LOGS': ['show-binary-logs'], - 'SHOW BINLOG EVENTS': ['show-binlog-events'], - 'SHOW CHARACTER SET': ['show-character-set'], - 'SHOW COLLATION': ['show-collation'], - 'SHOW COLUMNS': ['show-columns'], - 'SHOW CONTRIBUTORS': ['show-contributors'], - 'SHOW CREATE DATABASE': ['show-create-database'], - 'SHOW CREATE EVENT': ['show-create-event'], - 'SHOW CREATE FUNCTION': ['show-create-function'], - 'SHOW CREATE PROCEDURE': ['show-create-procedure'], - 'SHOW CREATE TABLE': ['show-create-table'], - 'SHOW CREATE TRIGGER': ['show-create-trigger'], - 'SHOW CREATE VIEW': ['show-create-view'], - 'SHOW DATABASES': ['show-databases'], - 'SHOW ENGINE': ['show-engine'], - 'SHOW ENGINES': ['show-engines'], - 'SHOW ERRORS': ['show-errors'], - 'SHOW EVENTS': ['show-events'], - 'SHOW FUNCTION CODE': ['show-function-code'], - 'SHOW FUNCTION STATUS': ['show-function-status'], - 'SHOW GRANTS': ['show-grants'], - 'SHOW INDEX': ['show-index'], - 'SHOW MASTER STATUS': ['show-master-status'], - 'SHOW OPEN TABLES': ['show-open-tables'], - 'SHOW PLUGINS': ['show-plugins'], - 'SHOW PRIVILEGES': ['show-privileges'], - 'SHOW PROCEDURE CODE': ['show-procedure-code'], - 'SHOW PROCEDURE STATUS': ['show-procedure-status'], - 'SHOW PROCESSLIST': ['show-processlist'], - 'SHOW PROFILE': ['show-profile'], - 'SHOW PROFILES': ['show-profiles'], - 'SHOW RELAYLOG EVENTS': ['show-relaylog-events'], - 'SHOW SLAVE HOSTS': ['show-slave-hosts'], - 'SHOW SLAVE STATUS': ['show-slave-status'], - 'SHOW STATUS': ['show-status'], - 'SHOW TABLE STATUS': ['show-table-status'], - 'SHOW TABLES': ['show-tables'], - 'SHOW TRIGGERS': ['show-triggers'], - 'SHOW VARIABLES': ['show-variables'], - 'SHOW WARNINGS': ['show-warnings'], - 'LOAD DATA INFILE': ['load-data'], - 'LOAD XML': ['load-xml'], - 'LOCK TABLES': ['lock-tables'], - 'UNLOCK TABLES': ['lock-tables'], - 'ALTER DATABASE': ['alter-database'], - 'ALTER EVENT': ['alter-event'], - 'ALTER LOGFILE GROUP': ['alter-logfile-group'], - 'ALTER FUNCTION': ['alter-function'], - 'ALTER PROCEDURE': ['alter-procedure'], - 'ALTER SERVER': ['alter-server'], - 'ALTER TABLE': ['alter-table'], - 'ALTER TABLESPACE': ['alter-tablespace'], - 'ALTER VIEW': ['alter-view'], - 'CREATE DATABASE': ['create-database'], - 'CREATE EVENT': ['create-event'], - 'CREATE FUNCTION': ['create-function'], - 'CREATE INDEX': ['create-index'], - 'CREATE LOGFILE GROUP': ['create-logfile-group'], - 'CREATE PROCEDURE': ['create-procedure'], - 'CREATE SERVER': ['create-server'], - 'CREATE TABLE': ['create-table'], - 'CREATE TABLESPACE': ['create-tablespace'], - 'CREATE TRIGGER': ['create-trigger'], - 'CREATE VIEW': ['create-view'], - 'DROP DATABASE': ['drop-database'], - 'DROP EVENT': ['drop-event'], - 'DROP FUNCTION': ['drop-function'], - 'DROP INDEX': ['drop-index'], - 'DROP LOGFILE GROUP': ['drop-logfile-group'], - 'DROP PROCEDURE': ['drop-procedure'], - 'DROP SERVER': ['drop-server'], - 'DROP TABLE': ['drop-table'], - 'DROP TABLESPACE': ['drop-tablespace'], - 'DROP TRIGGER': ['drop-trigger'], - 'DROP VIEW': ['drop-view'], - 'RENAME TABLE': ['rename-table'], - 'TRUNCATE TABLE': ['truncate-table'], - - /* Statements */ - 'SELECT': ['select'], - 'SET': ['set'], - 'EXPLAIN': ['explain'], - 'DESCRIBE': ['describe'], - 'DELETE': ['delete'], - 'SHOW': ['show'], - 'UPDATE': ['update'], - 'INSERT': ['insert'], - 'REPLACE': ['replace'], - 'CALL': ['call'], - 'DO': ['do'], - 'HANDLER': ['handler'], - 'COLLATE': ['charset-collations'], - - /* Functions */ - 'ABS': ['mathematical-functions', 'function_abs'], - 'ACOS': ['mathematical-functions', 'function_acos'], - 'ADDDATE': ['date-and-time-functions', 'function_adddate'], - 'ADDTIME': ['date-and-time-functions', 'function_addtime'], - 'AES_DECRYPT': ['encryption-functions', 'function_aes_decrypt'], - 'AES_ENCRYPT': ['encryption-functions', 'function_aes_encrypt'], - 'AND': ['logical-operators', 'operator_and'], - 'ASCII': ['string-functions', 'function_ascii'], - 'ASIN': ['mathematical-functions', 'function_asin'], - 'ATAN2': ['mathematical-functions', 'function_atan2'], - 'ATAN': ['mathematical-functions', 'function_atan'], - 'AVG': ['aggregate-functions', 'function_avg'], - 'BENCHMARK': ['information-functions', 'function_benchmark'], - 'BIN': ['string-functions', 'function_bin'], - 'BINARY': ['cast-functions', 'operator_binary'], - 'BIT_AND': ['aggregate-functions', 'function_bit_and'], - 'BIT_COUNT': ['bit-functions', 'function_bit_count'], - 'BIT_LENGTH': ['string-functions', 'function_bit_length'], - 'BIT_OR': ['aggregate-functions', 'function_bit_or'], - 'BIT_XOR': ['aggregate-functions', 'function_bit_xor'], - 'CASE': ['control-flow-functions', 'operator_case'], - 'CAST': ['cast-functions', 'function_cast'], - 'CEIL': ['mathematical-functions', 'function_ceil'], - 'CEILING': ['mathematical-functions', 'function_ceiling'], - 'CHAR_LENGTH': ['string-functions', 'function_char_length'], - 'CHAR': ['string-functions', 'function_char'], - 'CHARACTER_LENGTH': ['string-functions', 'function_character_length'], - 'CHARSET': ['information-functions', 'function_charset'], - 'COALESCE': ['comparison-operators', 'function_coalesce'], - 'COERCIBILITY': ['information-functions', 'function_coercibility'], - 'COLLATION': ['information-functions', 'function_collation'], - 'COMPRESS': ['encryption-functions', 'function_compress'], - 'CONCAT_WS': ['string-functions', 'function_concat_ws'], - 'CONCAT': ['string-functions', 'function_concat'], - 'CONNECTION_ID': ['information-functions', 'function_connection_id'], - 'CONV': ['mathematical-functions', 'function_conv'], - 'CONVERT_TZ': ['date-and-time-functions', 'function_convert_tz'], - 'Convert': ['cast-functions', 'function_convert'], - 'COS': ['mathematical-functions', 'function_cos'], - 'COT': ['mathematical-functions', 'function_cot'], - 'COUNT': ['aggregate-functions', 'function_count'], - 'CRC32': ['mathematical-functions', 'function_crc32'], - 'CURDATE': ['date-and-time-functions', 'function_curdate'], - 'CURRENT_DATE': ['date-and-time-functions', 'function_current_date'], - 'CURRENT_TIME': ['date-and-time-functions', 'function_current_time'], - 'CURRENT_TIMESTAMP': ['date-and-time-functions', 'function_current_timestamp'], - 'CURRENT_USER': ['information-functions', 'function_current_user'], - 'CURTIME': ['date-and-time-functions', 'function_curtime'], - 'DATABASE': ['information-functions', 'function_database'], - 'DATE_ADD': ['date-and-time-functions', 'function_date_add'], - 'DATE_FORMAT': ['date-and-time-functions', 'function_date_format'], - 'DATE_SUB': ['date-and-time-functions', 'function_date_sub'], - 'DATE': ['date-and-time-functions', 'function_date'], - 'DATEDIFF': ['date-and-time-functions', 'function_datediff'], - 'DAY': ['date-and-time-functions', 'function_day'], - 'DAYNAME': ['date-and-time-functions', 'function_dayname'], - 'DAYOFMONTH': ['date-and-time-functions', 'function_dayofmonth'], - 'DAYOFWEEK': ['date-and-time-functions', 'function_dayofweek'], - 'DAYOFYEAR': ['date-and-time-functions', 'function_dayofyear'], - 'DECLARE': ['declare', 'declare'], - 'DECODE': ['encryption-functions', 'function_decode'], - 'DEFAULT': ['miscellaneous-functions', 'function_default'], - 'DEGREES': ['mathematical-functions', 'function_degrees'], - 'DES_DECRYPT': ['encryption-functions', 'function_des_decrypt'], - 'DES_ENCRYPT': ['encryption-functions', 'function_des_encrypt'], - 'DIV': ['arithmetic-functions', 'operator_div'], - 'ELT': ['string-functions', 'function_elt'], - 'ENCODE': ['encryption-functions', 'function_encode'], - 'ENCRYPT': ['encryption-functions', 'function_encrypt'], - 'EXP': ['mathematical-functions', 'function_exp'], - 'EXPORT_SET': ['string-functions', 'function_export_set'], - 'EXTRACT': ['date-and-time-functions', 'function_extract'], - 'ExtractValue': ['xml-functions', 'function_extractvalue'], - 'FIELD': ['string-functions', 'function_field'], - 'FIND_IN_SET': ['string-functions', 'function_find_in_set'], - 'FLOOR': ['mathematical-functions', 'function_floor'], - 'FORMAT': ['string-functions', 'function_format'], - 'FOUND_ROWS': ['information-functions', 'function_found_rows'], - 'FROM_DAYS': ['date-and-time-functions', 'function_from_days'], - 'FROM_UNIXTIME': ['date-and-time-functions', 'function_from_unixtime'], - 'GET_FORMAT': ['date-and-time-functions', 'function_get_format'], - 'GET_LOCK': ['miscellaneous-functions', 'function_get_lock'], - 'GREATEST': ['comparison-operators', 'function_greatest'], - 'GROUP_CONCAT': ['aggregate-functions', 'function_group_concat'], - 'HEX': ['string-functions', 'function_hex'], - 'HOUR': ['date-and-time-functions', 'function_hour'], - 'IF': ['control-flow-functions', 'function_if'], - 'IFNULL': ['control-flow-functions', 'function_ifnull'], - 'IN': ['comparison-operators', 'function_in'], - 'INET_ATON': ['miscellaneous-functions', 'function_inet_aton'], - 'INET_NTOA': ['miscellaneous-functions', 'function_inet_ntoa'], - 'INSTR': ['string-functions', 'function_instr'], - 'INTERVAL': ['comparison-operators', 'function_interval'], - 'IS_FREE_LOCK': ['miscellaneous-functions', 'function_is_free_lock'], - 'IS_USED_LOCK': ['miscellaneous-functions', 'function_is_used_lock'], - 'IS': ['comparison-operators', 'operator_is'], - 'ISNULL': ['comparison-operators', 'function_isnull'], - 'LAST_DAY': ['date-and-time-functions', 'function_last_day'], - 'LAST_INSERT_ID': ['information-functions', 'function_last_insert_id'], - 'LCASE': ['string-functions', 'function_lcase'], - 'LEAST': ['comparison-operators', 'function_least'], - 'LEFT': ['string-functions', 'function_left'], - 'LENGTH': ['string-functions', 'function_length'], - 'LIKE': ['string-comparison-functions', 'operator_like'], - 'LN': ['mathematical-functions', 'function_ln'], - 'LOAD_FILE': ['string-functions', 'function_load_file'], - 'LOCALTIME': ['date-and-time-functions', 'function_localtime'], - 'LOCALTIMESTAMP': ['date-and-time-functions', 'function_localtimestamp'], - 'LOCATE': ['string-functions', 'function_locate'], - 'LOG10': ['mathematical-functions', 'function_log10'], - 'LOG2': ['mathematical-functions', 'function_log2'], - 'LOG': ['mathematical-functions', 'function_log'], - 'LOWER': ['string-functions', 'function_lower'], - 'LPAD': ['string-functions', 'function_lpad'], - 'LTRIM': ['string-functions', 'function_ltrim'], - 'MAKE_SET': ['string-functions', 'function_make_set'], - 'MAKEDATE': ['date-and-time-functions', 'function_makedate'], - 'MAKETIME': ['date-and-time-functions', 'function_maketime'], - 'MASTER_POS_WAIT': ['miscellaneous-functions', 'function_master_pos_wait'], - 'MATCH': ['fulltext-search', 'function_match'], - 'MAX': ['aggregate-functions', 'function_max'], - 'MD5': ['encryption-functions', 'function_md5'], - 'MICROSECOND': ['date-and-time-functions', 'function_microsecond'], - 'MID': ['string-functions', 'function_mid'], - 'MIN': ['aggregate-functions', 'function_min'], - 'MINUTE': ['date-and-time-functions', 'function_minute'], - 'MOD': ['mathematical-functions', 'function_mod'], - 'MONTH': ['date-and-time-functions', 'function_month'], - 'MONTHNAME': ['date-and-time-functions', 'function_monthname'], - 'NAME_CONST': ['miscellaneous-functions', 'function_name_const'], - 'NOT': ['logical-operators', 'operator_not'], - 'NOW': ['date-and-time-functions', 'function_now'], - 'NULLIF': ['control-flow-functions', 'function_nullif'], - 'OCT': ['mathematical-functions', 'function_oct'], - 'OCTET_LENGTH': ['string-functions', 'function_octet_length'], - 'OLD_PASSWORD': ['encryption-functions', 'function_old_password'], - 'OR': ['logical-operators', 'operator_or'], - 'ORD': ['string-functions', 'function_ord'], - 'PASSWORD': ['encryption-functions', 'function_password'], - 'PERIOD_ADD': ['date-and-time-functions', 'function_period_add'], - 'PERIOD_DIFF': ['date-and-time-functions', 'function_period_diff'], - 'PI': ['mathematical-functions', 'function_pi'], - 'POSITION': ['string-functions', 'function_position'], - 'POW': ['mathematical-functions', 'function_pow'], - 'POWER': ['mathematical-functions', 'function_power'], - 'QUARTER': ['date-and-time-functions', 'function_quarter'], - 'QUOTE': ['string-functions', 'function_quote'], - 'RADIANS': ['mathematical-functions', 'function_radians'], - 'RAND': ['mathematical-functions', 'function_rand'], - 'REGEXP': ['regexp', 'operator_regexp'], - 'RELEASE_LOCK': ['miscellaneous-functions', 'function_release_lock'], - 'REPEAT': ['string-functions', 'function_repeat'], - 'REVERSE': ['string-functions', 'function_reverse'], - 'RIGHT': ['string-functions', 'function_right'], - 'RLIKE': ['regexp', 'operator_rlike'], - 'ROUND': ['mathematical-functions', 'function_round'], - 'ROW_COUNT': ['information-functions', 'function_row_count'], - 'RPAD': ['string-functions', 'function_rpad'], - 'RTRIM': ['string-functions', 'function_rtrim'], - 'SCHEMA': ['information-functions', 'function_schema'], - 'SEC_TO_TIME': ['date-and-time-functions', 'function_sec_to_time'], - 'SECOND': ['date-and-time-functions', 'function_second'], - 'SESSION_USER': ['information-functions', 'function_session_user'], - 'SHA': ['encryption-functions', 'function_sha1'], - 'SHA1': ['encryption-functions', 'function_sha1'], - 'SIGN': ['mathematical-functions', 'function_sign'], - 'SIN': ['mathematical-functions', 'function_sin'], - 'SLEEP': ['miscellaneous-functions', 'function_sleep'], - 'SOUNDEX': ['string-functions', 'function_soundex'], - 'SPACE': ['string-functions', 'function_space'], - 'SQRT': ['mathematical-functions', 'function_sqrt'], - 'STD': ['aggregate-functions', 'function_std'], - 'STDDEV_POP': ['aggregate-functions', 'function_stddev_pop'], - 'STDDEV_SAMP': ['aggregate-functions', 'function_stddev_samp'], - 'STDDEV': ['aggregate-functions', 'function_stddev'], - 'STR_TO_DATE': ['date-and-time-functions', 'function_str_to_date'], - 'STRCMP': ['string-comparison-functions', 'function_strcmp'], - 'SUBDATE': ['date-and-time-functions', 'function_subdate'], - 'SUBSTR': ['string-functions', 'function_substr'], - 'SUBSTRING_INDEX': ['string-functions', 'function_substring_index'], - 'SUBSTRING': ['string-functions', 'function_substring'], - 'SUBTIME': ['date-and-time-functions', 'function_subtime'], - 'SUM': ['aggregate-functions', 'function_sum'], - 'SYSDATE': ['date-and-time-functions', 'function_sysdate'], - 'SYSTEM_USER': ['information-functions', 'function_system_user'], - 'TAN': ['mathematical-functions', 'function_tan'], - 'TIME_FORMAT': ['date-and-time-functions', 'function_time_format'], - 'TIME_TO_SEC': ['date-and-time-functions', 'function_time_to_sec'], - 'TIME': ['date-and-time-functions', 'function_time'], - 'TIMEDIFF': ['date-and-time-functions', 'function_timediff'], - 'TIMESTAMP': ['date-and-time-functions', 'function_timestamp'], - 'TIMESTAMPADD': ['date-and-time-functions', 'function_timestampadd'], - 'TIMESTAMPDIFF': ['date-and-time-functions', 'function_timestampdiff'], - 'TO_DAYS': ['date-and-time-functions', 'function_to_days'], - 'TRIM': ['string-functions', 'function_trim'], - 'TRUNCATE': ['mathematical-functions', 'function_truncate'], - 'UCASE': ['string-functions', 'function_ucase'], - 'UNCOMPRESS': ['encryption-functions', 'function_uncompress'], - 'UNCOMPRESSED_LENGTH': ['encryption-functions', 'function_uncompressed_length'], - 'UNHEX': ['string-functions', 'function_unhex'], - 'UNIX_TIMESTAMP': ['date-and-time-functions', 'function_unix_timestamp'], - 'UpdateXML': ['xml-functions', 'function_updatexml'], - 'UPPER': ['string-functions', 'function_upper'], - 'USER': ['information-functions', 'function_user'], - 'UTC_DATE': ['date-and-time-functions', 'function_utc_date'], - 'UTC_TIME': ['date-and-time-functions', 'function_utc_time'], - 'UTC_TIMESTAMP': ['date-and-time-functions', 'function_utc_timestamp'], - 'UUID_SHORT': ['miscellaneous-functions', 'function_uuid_short'], - 'UUID': ['miscellaneous-functions', 'function_uuid'], - 'VALUES': ['miscellaneous-functions', 'function_values'], - 'VAR_POP': ['aggregate-functions', 'function_var_pop'], - 'VAR_SAMP': ['aggregate-functions', 'function_var_samp'], - 'VARIANCE': ['aggregate-functions', 'function_variance'], - 'VERSION': ['information-functions', 'function_version'], - 'WEEK': ['date-and-time-functions', 'function_week'], - 'WEEKDAY': ['date-and-time-functions', 'function_weekday'], - 'WEEKOFYEAR': ['date-and-time-functions', 'function_weekofyear'], - 'XOR': ['logical-operators', 'operator_xor'], - 'YEAR': ['date-and-time-functions', 'function_year'], - 'YEARWEEK': ['date-and-time-functions', 'function_yearweek'], - 'SOUNDS_LIKE': ['string-functions', 'operator_sounds-like'], - 'IS_NOT_NULL': ['comparison-operators', 'operator_is-not-null'], - 'IS_NOT': ['comparison-operators', 'operator_is-not'], - 'IS_NULL': ['comparison-operators', 'operator_is-null'], - 'NOT_LIKE': ['string-comparison-functions', 'operator_not-like'], - 'NOT_REGEXP': ['regexp', 'operator_not-regexp'], - 'COUNT_DISTINCT': ['aggregate-functions', 'function_count-distinct'], - 'NOT_IN': ['comparison-operators', 'function_not-in'] -}; -window.mysqlDocKeyword = mysqlDocKeyword; - -var mysqlDocBuiltin = { - 'TINYINT': ['numeric-types'], - 'SMALLINT': ['numeric-types'], - 'MEDIUMINT': ['numeric-types'], - 'INT': ['numeric-types'], - 'BIGINT': ['numeric-types'], - 'DECIMAL': ['numeric-types'], - 'FLOAT': ['numeric-types'], - 'DOUBLE': ['numeric-types'], - 'REAL': ['numeric-types'], - 'BIT': ['numeric-types'], - 'BOOLEAN': ['numeric-types'], - 'SERIAL': ['numeric-types'], - 'DATE': ['date-and-time-types'], - 'DATETIME': ['date-and-time-types'], - 'TIMESTAMP': ['date-and-time-types'], - 'TIME': ['date-and-time-types'], - 'YEAR': ['date-and-time-types'], - 'CHAR': ['string-types'], - 'VARCHAR': ['string-types'], - 'TINYTEXT': ['string-types'], - 'TEXT': ['string-types'], - 'MEDIUMTEXT': ['string-types'], - 'LONGTEXT': ['string-types'], - 'BINARY': ['string-types'], - 'VARBINARY': ['string-types'], - 'TINYBLOB': ['string-types'], - 'MEDIUMBLOB': ['string-types'], - 'BLOB': ['string-types'], - 'LONGBLOB': ['string-types'], - 'ENUM': ['string-types'], - 'SET': ['string-types'] -}; -window.mysqlDocBuiltin = mysqlDocBuiltin; diff --git a/js/src/functions.js b/js/src/functions.js index d0de8d4a6e..4becba39e2 100644 --- a/js/src/functions.js +++ b/js/src/functions.js @@ -1,9 +1,9 @@ import $ from 'jquery'; +import { mysqlDocKeyword, mysqlDocBuiltin } from './modules/doc-links.js'; /* global Navigation */ /* global ChartType, ColumnType, DataTable, JQPlotChartFactory */ // js/chart.js /* global DatabaseStructure */ // js/database/structure.js -/* global mysqlDocBuiltin, mysqlDocKeyword */ // js/doclinks.js /* global Indexes */ // js/indexes.js /* global firstDayOfCalendar, maxInputVars, mysqlDocTemplate, themeImagePath */ // templates/javascript/variables.twig diff --git a/js/src/modules/doc-links.js b/js/src/modules/doc-links.js new file mode 100644 index 0000000000..3354ec1afe --- /dev/null +++ b/js/src/modules/doc-links.js @@ -0,0 +1,365 @@ +/** + * Definition of links to MySQL documentation. + */ + +export const mysqlDocKeyword = { + /* Multi word */ + 'CHARACTER SET': ['charset'], + 'SHOW AUTHORS': ['show-authors'], + 'SHOW BINARY LOGS': ['show-binary-logs'], + 'SHOW BINLOG EVENTS': ['show-binlog-events'], + 'SHOW CHARACTER SET': ['show-character-set'], + 'SHOW COLLATION': ['show-collation'], + 'SHOW COLUMNS': ['show-columns'], + 'SHOW CONTRIBUTORS': ['show-contributors'], + 'SHOW CREATE DATABASE': ['show-create-database'], + 'SHOW CREATE EVENT': ['show-create-event'], + 'SHOW CREATE FUNCTION': ['show-create-function'], + 'SHOW CREATE PROCEDURE': ['show-create-procedure'], + 'SHOW CREATE TABLE': ['show-create-table'], + 'SHOW CREATE TRIGGER': ['show-create-trigger'], + 'SHOW CREATE VIEW': ['show-create-view'], + 'SHOW DATABASES': ['show-databases'], + 'SHOW ENGINE': ['show-engine'], + 'SHOW ENGINES': ['show-engines'], + 'SHOW ERRORS': ['show-errors'], + 'SHOW EVENTS': ['show-events'], + 'SHOW FUNCTION CODE': ['show-function-code'], + 'SHOW FUNCTION STATUS': ['show-function-status'], + 'SHOW GRANTS': ['show-grants'], + 'SHOW INDEX': ['show-index'], + 'SHOW MASTER STATUS': ['show-master-status'], + 'SHOW OPEN TABLES': ['show-open-tables'], + 'SHOW PLUGINS': ['show-plugins'], + 'SHOW PRIVILEGES': ['show-privileges'], + 'SHOW PROCEDURE CODE': ['show-procedure-code'], + 'SHOW PROCEDURE STATUS': ['show-procedure-status'], + 'SHOW PROCESSLIST': ['show-processlist'], + 'SHOW PROFILE': ['show-profile'], + 'SHOW PROFILES': ['show-profiles'], + 'SHOW RELAYLOG EVENTS': ['show-relaylog-events'], + 'SHOW SLAVE HOSTS': ['show-slave-hosts'], + 'SHOW SLAVE STATUS': ['show-slave-status'], + 'SHOW STATUS': ['show-status'], + 'SHOW TABLE STATUS': ['show-table-status'], + 'SHOW TABLES': ['show-tables'], + 'SHOW TRIGGERS': ['show-triggers'], + 'SHOW VARIABLES': ['show-variables'], + 'SHOW WARNINGS': ['show-warnings'], + 'LOAD DATA INFILE': ['load-data'], + 'LOAD XML': ['load-xml'], + 'LOCK TABLES': ['lock-tables'], + 'UNLOCK TABLES': ['lock-tables'], + 'ALTER DATABASE': ['alter-database'], + 'ALTER EVENT': ['alter-event'], + 'ALTER LOGFILE GROUP': ['alter-logfile-group'], + 'ALTER FUNCTION': ['alter-function'], + 'ALTER PROCEDURE': ['alter-procedure'], + 'ALTER SERVER': ['alter-server'], + 'ALTER TABLE': ['alter-table'], + 'ALTER TABLESPACE': ['alter-tablespace'], + 'ALTER VIEW': ['alter-view'], + 'CREATE DATABASE': ['create-database'], + 'CREATE EVENT': ['create-event'], + 'CREATE FUNCTION': ['create-function'], + 'CREATE INDEX': ['create-index'], + 'CREATE LOGFILE GROUP': ['create-logfile-group'], + 'CREATE PROCEDURE': ['create-procedure'], + 'CREATE SERVER': ['create-server'], + 'CREATE TABLE': ['create-table'], + 'CREATE TABLESPACE': ['create-tablespace'], + 'CREATE TRIGGER': ['create-trigger'], + 'CREATE VIEW': ['create-view'], + 'DROP DATABASE': ['drop-database'], + 'DROP EVENT': ['drop-event'], + 'DROP FUNCTION': ['drop-function'], + 'DROP INDEX': ['drop-index'], + 'DROP LOGFILE GROUP': ['drop-logfile-group'], + 'DROP PROCEDURE': ['drop-procedure'], + 'DROP SERVER': ['drop-server'], + 'DROP TABLE': ['drop-table'], + 'DROP TABLESPACE': ['drop-tablespace'], + 'DROP TRIGGER': ['drop-trigger'], + 'DROP VIEW': ['drop-view'], + 'RENAME TABLE': ['rename-table'], + 'TRUNCATE TABLE': ['truncate-table'], + + /* Statements */ + 'SELECT': ['select'], + 'SET': ['set'], + 'EXPLAIN': ['explain'], + 'DESCRIBE': ['describe'], + 'DELETE': ['delete'], + 'SHOW': ['show'], + 'UPDATE': ['update'], + 'INSERT': ['insert'], + 'REPLACE': ['replace'], + 'CALL': ['call'], + 'DO': ['do'], + 'HANDLER': ['handler'], + 'COLLATE': ['charset-collations'], + + /* Functions */ + 'ABS': ['mathematical-functions', 'function_abs'], + 'ACOS': ['mathematical-functions', 'function_acos'], + 'ADDDATE': ['date-and-time-functions', 'function_adddate'], + 'ADDTIME': ['date-and-time-functions', 'function_addtime'], + 'AES_DECRYPT': ['encryption-functions', 'function_aes_decrypt'], + 'AES_ENCRYPT': ['encryption-functions', 'function_aes_encrypt'], + 'AND': ['logical-operators', 'operator_and'], + 'ASCII': ['string-functions', 'function_ascii'], + 'ASIN': ['mathematical-functions', 'function_asin'], + 'ATAN2': ['mathematical-functions', 'function_atan2'], + 'ATAN': ['mathematical-functions', 'function_atan'], + 'AVG': ['aggregate-functions', 'function_avg'], + 'BENCHMARK': ['information-functions', 'function_benchmark'], + 'BIN': ['string-functions', 'function_bin'], + 'BINARY': ['cast-functions', 'operator_binary'], + 'BIT_AND': ['aggregate-functions', 'function_bit_and'], + 'BIT_COUNT': ['bit-functions', 'function_bit_count'], + 'BIT_LENGTH': ['string-functions', 'function_bit_length'], + 'BIT_OR': ['aggregate-functions', 'function_bit_or'], + 'BIT_XOR': ['aggregate-functions', 'function_bit_xor'], + 'CASE': ['control-flow-functions', 'operator_case'], + 'CAST': ['cast-functions', 'function_cast'], + 'CEIL': ['mathematical-functions', 'function_ceil'], + 'CEILING': ['mathematical-functions', 'function_ceiling'], + 'CHAR_LENGTH': ['string-functions', 'function_char_length'], + 'CHAR': ['string-functions', 'function_char'], + 'CHARACTER_LENGTH': ['string-functions', 'function_character_length'], + 'CHARSET': ['information-functions', 'function_charset'], + 'COALESCE': ['comparison-operators', 'function_coalesce'], + 'COERCIBILITY': ['information-functions', 'function_coercibility'], + 'COLLATION': ['information-functions', 'function_collation'], + 'COMPRESS': ['encryption-functions', 'function_compress'], + 'CONCAT_WS': ['string-functions', 'function_concat_ws'], + 'CONCAT': ['string-functions', 'function_concat'], + 'CONNECTION_ID': ['information-functions', 'function_connection_id'], + 'CONV': ['mathematical-functions', 'function_conv'], + 'CONVERT_TZ': ['date-and-time-functions', 'function_convert_tz'], + 'Convert': ['cast-functions', 'function_convert'], + 'COS': ['mathematical-functions', 'function_cos'], + 'COT': ['mathematical-functions', 'function_cot'], + 'COUNT': ['aggregate-functions', 'function_count'], + 'CRC32': ['mathematical-functions', 'function_crc32'], + 'CURDATE': ['date-and-time-functions', 'function_curdate'], + 'CURRENT_DATE': ['date-and-time-functions', 'function_current_date'], + 'CURRENT_TIME': ['date-and-time-functions', 'function_current_time'], + 'CURRENT_TIMESTAMP': ['date-and-time-functions', 'function_current_timestamp'], + 'CURRENT_USER': ['information-functions', 'function_current_user'], + 'CURTIME': ['date-and-time-functions', 'function_curtime'], + 'DATABASE': ['information-functions', 'function_database'], + 'DATE_ADD': ['date-and-time-functions', 'function_date_add'], + 'DATE_FORMAT': ['date-and-time-functions', 'function_date_format'], + 'DATE_SUB': ['date-and-time-functions', 'function_date_sub'], + 'DATE': ['date-and-time-functions', 'function_date'], + 'DATEDIFF': ['date-and-time-functions', 'function_datediff'], + 'DAY': ['date-and-time-functions', 'function_day'], + 'DAYNAME': ['date-and-time-functions', 'function_dayname'], + 'DAYOFMONTH': ['date-and-time-functions', 'function_dayofmonth'], + 'DAYOFWEEK': ['date-and-time-functions', 'function_dayofweek'], + 'DAYOFYEAR': ['date-and-time-functions', 'function_dayofyear'], + 'DECLARE': ['declare', 'declare'], + 'DECODE': ['encryption-functions', 'function_decode'], + 'DEFAULT': ['miscellaneous-functions', 'function_default'], + 'DEGREES': ['mathematical-functions', 'function_degrees'], + 'DES_DECRYPT': ['encryption-functions', 'function_des_decrypt'], + 'DES_ENCRYPT': ['encryption-functions', 'function_des_encrypt'], + 'DIV': ['arithmetic-functions', 'operator_div'], + 'ELT': ['string-functions', 'function_elt'], + 'ENCODE': ['encryption-functions', 'function_encode'], + 'ENCRYPT': ['encryption-functions', 'function_encrypt'], + 'EXP': ['mathematical-functions', 'function_exp'], + 'EXPORT_SET': ['string-functions', 'function_export_set'], + 'EXTRACT': ['date-and-time-functions', 'function_extract'], + 'ExtractValue': ['xml-functions', 'function_extractvalue'], + 'FIELD': ['string-functions', 'function_field'], + 'FIND_IN_SET': ['string-functions', 'function_find_in_set'], + 'FLOOR': ['mathematical-functions', 'function_floor'], + 'FORMAT': ['string-functions', 'function_format'], + 'FOUND_ROWS': ['information-functions', 'function_found_rows'], + 'FROM_DAYS': ['date-and-time-functions', 'function_from_days'], + 'FROM_UNIXTIME': ['date-and-time-functions', 'function_from_unixtime'], + 'GET_FORMAT': ['date-and-time-functions', 'function_get_format'], + 'GET_LOCK': ['miscellaneous-functions', 'function_get_lock'], + 'GREATEST': ['comparison-operators', 'function_greatest'], + 'GROUP_CONCAT': ['aggregate-functions', 'function_group_concat'], + 'HEX': ['string-functions', 'function_hex'], + 'HOUR': ['date-and-time-functions', 'function_hour'], + 'IF': ['control-flow-functions', 'function_if'], + 'IFNULL': ['control-flow-functions', 'function_ifnull'], + 'IN': ['comparison-operators', 'function_in'], + 'INET_ATON': ['miscellaneous-functions', 'function_inet_aton'], + 'INET_NTOA': ['miscellaneous-functions', 'function_inet_ntoa'], + 'INSTR': ['string-functions', 'function_instr'], + 'INTERVAL': ['comparison-operators', 'function_interval'], + 'IS_FREE_LOCK': ['miscellaneous-functions', 'function_is_free_lock'], + 'IS_USED_LOCK': ['miscellaneous-functions', 'function_is_used_lock'], + 'IS': ['comparison-operators', 'operator_is'], + 'ISNULL': ['comparison-operators', 'function_isnull'], + 'LAST_DAY': ['date-and-time-functions', 'function_last_day'], + 'LAST_INSERT_ID': ['information-functions', 'function_last_insert_id'], + 'LCASE': ['string-functions', 'function_lcase'], + 'LEAST': ['comparison-operators', 'function_least'], + 'LEFT': ['string-functions', 'function_left'], + 'LENGTH': ['string-functions', 'function_length'], + 'LIKE': ['string-comparison-functions', 'operator_like'], + 'LN': ['mathematical-functions', 'function_ln'], + 'LOAD_FILE': ['string-functions', 'function_load_file'], + 'LOCALTIME': ['date-and-time-functions', 'function_localtime'], + 'LOCALTIMESTAMP': ['date-and-time-functions', 'function_localtimestamp'], + 'LOCATE': ['string-functions', 'function_locate'], + 'LOG10': ['mathematical-functions', 'function_log10'], + 'LOG2': ['mathematical-functions', 'function_log2'], + 'LOG': ['mathematical-functions', 'function_log'], + 'LOWER': ['string-functions', 'function_lower'], + 'LPAD': ['string-functions', 'function_lpad'], + 'LTRIM': ['string-functions', 'function_ltrim'], + 'MAKE_SET': ['string-functions', 'function_make_set'], + 'MAKEDATE': ['date-and-time-functions', 'function_makedate'], + 'MAKETIME': ['date-and-time-functions', 'function_maketime'], + 'MASTER_POS_WAIT': ['miscellaneous-functions', 'function_master_pos_wait'], + 'MATCH': ['fulltext-search', 'function_match'], + 'MAX': ['aggregate-functions', 'function_max'], + 'MD5': ['encryption-functions', 'function_md5'], + 'MICROSECOND': ['date-and-time-functions', 'function_microsecond'], + 'MID': ['string-functions', 'function_mid'], + 'MIN': ['aggregate-functions', 'function_min'], + 'MINUTE': ['date-and-time-functions', 'function_minute'], + 'MOD': ['mathematical-functions', 'function_mod'], + 'MONTH': ['date-and-time-functions', 'function_month'], + 'MONTHNAME': ['date-and-time-functions', 'function_monthname'], + 'NAME_CONST': ['miscellaneous-functions', 'function_name_const'], + 'NOT': ['logical-operators', 'operator_not'], + 'NOW': ['date-and-time-functions', 'function_now'], + 'NULLIF': ['control-flow-functions', 'function_nullif'], + 'OCT': ['mathematical-functions', 'function_oct'], + 'OCTET_LENGTH': ['string-functions', 'function_octet_length'], + 'OLD_PASSWORD': ['encryption-functions', 'function_old_password'], + 'OR': ['logical-operators', 'operator_or'], + 'ORD': ['string-functions', 'function_ord'], + 'PASSWORD': ['encryption-functions', 'function_password'], + 'PERIOD_ADD': ['date-and-time-functions', 'function_period_add'], + 'PERIOD_DIFF': ['date-and-time-functions', 'function_period_diff'], + 'PI': ['mathematical-functions', 'function_pi'], + 'POSITION': ['string-functions', 'function_position'], + 'POW': ['mathematical-functions', 'function_pow'], + 'POWER': ['mathematical-functions', 'function_power'], + 'QUARTER': ['date-and-time-functions', 'function_quarter'], + 'QUOTE': ['string-functions', 'function_quote'], + 'RADIANS': ['mathematical-functions', 'function_radians'], + 'RAND': ['mathematical-functions', 'function_rand'], + 'REGEXP': ['regexp', 'operator_regexp'], + 'RELEASE_LOCK': ['miscellaneous-functions', 'function_release_lock'], + 'REPEAT': ['string-functions', 'function_repeat'], + 'REVERSE': ['string-functions', 'function_reverse'], + 'RIGHT': ['string-functions', 'function_right'], + 'RLIKE': ['regexp', 'operator_rlike'], + 'ROUND': ['mathematical-functions', 'function_round'], + 'ROW_COUNT': ['information-functions', 'function_row_count'], + 'RPAD': ['string-functions', 'function_rpad'], + 'RTRIM': ['string-functions', 'function_rtrim'], + 'SCHEMA': ['information-functions', 'function_schema'], + 'SEC_TO_TIME': ['date-and-time-functions', 'function_sec_to_time'], + 'SECOND': ['date-and-time-functions', 'function_second'], + 'SESSION_USER': ['information-functions', 'function_session_user'], + 'SHA': ['encryption-functions', 'function_sha1'], + 'SHA1': ['encryption-functions', 'function_sha1'], + 'SIGN': ['mathematical-functions', 'function_sign'], + 'SIN': ['mathematical-functions', 'function_sin'], + 'SLEEP': ['miscellaneous-functions', 'function_sleep'], + 'SOUNDEX': ['string-functions', 'function_soundex'], + 'SPACE': ['string-functions', 'function_space'], + 'SQRT': ['mathematical-functions', 'function_sqrt'], + 'STD': ['aggregate-functions', 'function_std'], + 'STDDEV_POP': ['aggregate-functions', 'function_stddev_pop'], + 'STDDEV_SAMP': ['aggregate-functions', 'function_stddev_samp'], + 'STDDEV': ['aggregate-functions', 'function_stddev'], + 'STR_TO_DATE': ['date-and-time-functions', 'function_str_to_date'], + 'STRCMP': ['string-comparison-functions', 'function_strcmp'], + 'SUBDATE': ['date-and-time-functions', 'function_subdate'], + 'SUBSTR': ['string-functions', 'function_substr'], + 'SUBSTRING_INDEX': ['string-functions', 'function_substring_index'], + 'SUBSTRING': ['string-functions', 'function_substring'], + 'SUBTIME': ['date-and-time-functions', 'function_subtime'], + 'SUM': ['aggregate-functions', 'function_sum'], + 'SYSDATE': ['date-and-time-functions', 'function_sysdate'], + 'SYSTEM_USER': ['information-functions', 'function_system_user'], + 'TAN': ['mathematical-functions', 'function_tan'], + 'TIME_FORMAT': ['date-and-time-functions', 'function_time_format'], + 'TIME_TO_SEC': ['date-and-time-functions', 'function_time_to_sec'], + 'TIME': ['date-and-time-functions', 'function_time'], + 'TIMEDIFF': ['date-and-time-functions', 'function_timediff'], + 'TIMESTAMP': ['date-and-time-functions', 'function_timestamp'], + 'TIMESTAMPADD': ['date-and-time-functions', 'function_timestampadd'], + 'TIMESTAMPDIFF': ['date-and-time-functions', 'function_timestampdiff'], + 'TO_DAYS': ['date-and-time-functions', 'function_to_days'], + 'TRIM': ['string-functions', 'function_trim'], + 'TRUNCATE': ['mathematical-functions', 'function_truncate'], + 'UCASE': ['string-functions', 'function_ucase'], + 'UNCOMPRESS': ['encryption-functions', 'function_uncompress'], + 'UNCOMPRESSED_LENGTH': ['encryption-functions', 'function_uncompressed_length'], + 'UNHEX': ['string-functions', 'function_unhex'], + 'UNIX_TIMESTAMP': ['date-and-time-functions', 'function_unix_timestamp'], + 'UpdateXML': ['xml-functions', 'function_updatexml'], + 'UPPER': ['string-functions', 'function_upper'], + 'USER': ['information-functions', 'function_user'], + 'UTC_DATE': ['date-and-time-functions', 'function_utc_date'], + 'UTC_TIME': ['date-and-time-functions', 'function_utc_time'], + 'UTC_TIMESTAMP': ['date-and-time-functions', 'function_utc_timestamp'], + 'UUID_SHORT': ['miscellaneous-functions', 'function_uuid_short'], + 'UUID': ['miscellaneous-functions', 'function_uuid'], + 'VALUES': ['miscellaneous-functions', 'function_values'], + 'VAR_POP': ['aggregate-functions', 'function_var_pop'], + 'VAR_SAMP': ['aggregate-functions', 'function_var_samp'], + 'VARIANCE': ['aggregate-functions', 'function_variance'], + 'VERSION': ['information-functions', 'function_version'], + 'WEEK': ['date-and-time-functions', 'function_week'], + 'WEEKDAY': ['date-and-time-functions', 'function_weekday'], + 'WEEKOFYEAR': ['date-and-time-functions', 'function_weekofyear'], + 'XOR': ['logical-operators', 'operator_xor'], + 'YEAR': ['date-and-time-functions', 'function_year'], + 'YEARWEEK': ['date-and-time-functions', 'function_yearweek'], + 'SOUNDS_LIKE': ['string-functions', 'operator_sounds-like'], + 'IS_NOT_NULL': ['comparison-operators', 'operator_is-not-null'], + 'IS_NOT': ['comparison-operators', 'operator_is-not'], + 'IS_NULL': ['comparison-operators', 'operator_is-null'], + 'NOT_LIKE': ['string-comparison-functions', 'operator_not-like'], + 'NOT_REGEXP': ['regexp', 'operator_not-regexp'], + 'COUNT_DISTINCT': ['aggregate-functions', 'function_count-distinct'], + 'NOT_IN': ['comparison-operators', 'function_not-in'] +}; + +export const mysqlDocBuiltin = { + 'TINYINT': ['numeric-types'], + 'SMALLINT': ['numeric-types'], + 'MEDIUMINT': ['numeric-types'], + 'INT': ['numeric-types'], + 'BIGINT': ['numeric-types'], + 'DECIMAL': ['numeric-types'], + 'FLOAT': ['numeric-types'], + 'DOUBLE': ['numeric-types'], + 'REAL': ['numeric-types'], + 'BIT': ['numeric-types'], + 'BOOLEAN': ['numeric-types'], + 'SERIAL': ['numeric-types'], + 'DATE': ['date-and-time-types'], + 'DATETIME': ['date-and-time-types'], + 'TIMESTAMP': ['date-and-time-types'], + 'TIME': ['date-and-time-types'], + 'YEAR': ['date-and-time-types'], + 'CHAR': ['string-types'], + 'VARCHAR': ['string-types'], + 'TINYTEXT': ['string-types'], + 'TEXT': ['string-types'], + 'MEDIUMTEXT': ['string-types'], + 'LONGTEXT': ['string-types'], + 'BINARY': ['string-types'], + 'VARBINARY': ['string-types'], + 'TINYBLOB': ['string-types'], + 'MEDIUMBLOB': ['string-types'], + 'BLOB': ['string-types'], + 'LONGBLOB': ['string-types'], + 'ENUM': ['string-types'], + 'SET': ['string-types'] +}; diff --git a/libraries/classes/Header.php b/libraries/classes/Header.php index b0a469987c..85bc1dcd10 100644 --- a/libraries/classes/Header.php +++ b/libraries/classes/Header.php @@ -143,7 +143,6 @@ class Header $this->scripts->addFile('cross_framing_protection.js'); $this->scripts->addFile('messages.php', ['l' => $GLOBALS['lang']]); $this->scripts->addFile('config.js'); - $this->scripts->addFile('doclinks.js'); $this->scripts->addFile('functions.js'); $this->scripts->addFile('navigation.js'); $this->scripts->addFile('indexes.js'); diff --git a/webpack.config.cjs b/webpack.config.cjs index 78c4847fda..e488adafbb 100644 --- a/webpack.config.cjs +++ b/webpack.config.cjs @@ -36,7 +36,6 @@ module.exports = [ 'designer/move': './js/src/designer/move.js', 'designer/objects': './js/src/designer/objects.js', 'designer/page': './js/src/designer/page.js', - 'doclinks': './js/src/doclinks.js', 'drag_drop_import': './js/src/drag_drop_import.js', 'error_report': './js/src/error_report.js', 'export': './js/src/export.js', -- cgit v1.2.3