Functions

Note

We can enhance the automatic prompt function of the code editor through the function module provided by the system.
System default function
The system has built-in the following data source functions by default (it does not mean that it is the most complete function of the new version, if there is something missing, please submit issues or pr to fix it):
  • • ClickHouse
  • • MySQL
  • • Hive
  • • Trino & Presto (fit a part)
Add function
After entering the system, click the corresponding Function submenu under the top Settings menu to go to the function configuration function
img.png
Click the Add button on the top right to add a new function, and the following window will pop up after clicking:
img_1.png
The following is a detailed parameter description:
  • • Name : The name used to mark the function prompt, the suggestion is English
  • • Plugin : The plugin this function applies to, multiple options can be selected
  • • Content : The specific content of the function, which will be entered into the editor
  • • Description : Description of the function
  • • Type : Type of function, can be: KeyWord , Operator , Function , default is KeyWord
  • • Example : For the use example of this function, it is convenient for users to understand how to use the function
When the above content is written, click the Submit button at the bottom to save the operation, and you can use it in the editor later.
Batch operation
The system provides a way to import functions in batches. Currently, it supports the import of content and URI addresses. Next, let's take a look at how to do it.
We perform the batch import function by clicking the import button on the top right.
Content import
img_2.png
The content import method allows us to enter a list of functions, and they are divided according to each line. Adding the following keywords we need to import:
sql
SHOW
USE
In Plugin , we choose to use the ClickHouse plug-in, and in Type , we choose KeyWord . After the operation is completed, we click the Submit button at the bottom to use the import function of the current input function.
URI import
The URI import method is relatively simple. We can import data in batches by specifying the remote server URI address, which can be your local server address or the address provided by the software.
The URI address format provided by the software by default is
sql
(http|https)://datacap.edurt.io/resources/functions/plugin/keywords.txt
(http|https)://datacap.edurt.io/resources/functions/plugin/operators.txt
(http|https)://datacap.edurt.io/resources/functions/plugin/functions.txt
We only need to replace the value of plugin in the address with the name of the plugin that needs to be imported.

Warning

It should be noted that due to local network problems, the URI import method may be slow.
提交于 2025年2月19日 13:48
修改于 2025年2月19日 13:48
首次提交 (b1e5f80c)
末次提交 (b1e5f80c)
贡献者
qianmoQ
qianmoQ
1 次提交

目录