WO2021022702A1

WO2021022702A1 - Log insertion method and apparatus, computer apparatus and storage medium

Info

Publication number: WO2021022702A1
Application number: PCT/CN2019/117234
Authority: WO
Inventors: 李斌
Original assignee: 平安科技（深圳）有限公司
Priority date: 2019-08-07
Filing date: 2019-11-11
Publication date: 2021-02-11
Also published as: CN110633258A; CN110633258B

Abstract

A log insertion method and a related device. The method comprises: setting a task configuration file; reading a first command annotation statement in the task configuration file; initializing a global variable group corresponding to the task configuration file according to a command identifier and a command parameter of the first command annotation statement; reading a second command annotation statement in the task configuration file, analyzing a command identifier and a command parameter of the second command annotation statement, and determining the type of the second command annotation statement according to the command identifier of the second command annotation statement; if the type of the second command annotation statement is an insertion command annotation statement, inserting the command parameter of the insertion command annotation statement into a log table by means of the global variable group; reading an SQL statement corresponding to the second command annotation statement in the task configuration file, and executing the SQL statement; and if the SQL statement fails to be executed, inserting execution error information into the log table by means of the global variable group. The efficiency of inserting the execution error information of the SQL statement into the log table can be improved.

Description

Log insertion method, device, computer device and storage medium

This application claims to be submitted to the Chinese Patent Office on August 7, 2019. The application number is 201910727085.6. The application titled "Log insertion method, device, computer device and storage medium" is the priority of the Chinese patent application, the entire content of which is incorporated by reference In this application.

Technical field

This application relates to the technical field of logs, and in particular to a log insertion method, device, computer device, and non-volatile readable storage medium.

Background technique

Ordinary SQL script files and stored procedures, if you want to insert the log table. Need to manually write the corresponding insert statement, increasing the complexity of development. In the database development process, SQL statements often fail to execute. In order to record the log information of SQL statement execution failures, developers need to insert error statements in SQL script files or stored procedures, which generates additional workload and increases development complexity. Therefore, there is a need for a method that can simply and efficiently record the log information of the SQL statement execution failure.

Summary of the invention

In view of the above, it is necessary to provide a log insertion method, device, computer device, and non-volatile readable storage medium, which can improve the efficiency of inserting SQL statement execution error information into the log table.

The first aspect of the application provides a log insertion method, the method includes: setting a task configuration file, the task configuration file includes a first command comment statement, a second command comment statement, and a comment statement with the second command Corresponding SQL statement; read the first command comment statement, parse the command ID and command parameter of the first command comment statement; initialize the task configuration file according to the command ID and command parameter of the first command comment statement Corresponding global variable group; read the second command comment sentence, parse the command identifier and command parameter of the second command comment sentence, and determine the second command comment sentence according to the command identifier of the second command comment sentence If the category of the second command comment sentence is an insert command comment sentence, insert the command parameter of the insert command comment sentence into the log table through the global variable group, and the command parameter of the insert command comment sentence includes and Log information of the SQL statement corresponding to the insert command comment statement; read the SQL statement corresponding to the second command comment statement, execute the SQL statement; if the SQL statement fails to execute, generate an execution error of the SQL statement Information, the execution error information of the SQL statement is assigned to the global variable corresponding to the execution error information in the global variable group, and the execution error information is inserted into the log table through the global variable group.

A second aspect of the present application provides a log insertion device, the device includes: a setting module for setting a task configuration file, the task configuration file includes a first command comment sentence, a second command comment sentence, and The SQL statement corresponding to the second command comment statement; the first parsing module is used to read the first command comment statement, and parse the command identifier and command parameters of the first command comment statement; the initialization module is used to The command identifier and command parameters of the first command comment statement initialize the global variable group corresponding to the task configuration file; the second parsing module is used to read the second command comment statement and parse the second command comment statement The command identifier and the command parameter are used to determine the type of the second command comment sentence according to the command identifier of the second command comment sentence; the first insert module is used to insert the command comment sentence if the type of the second command comment sentence , Insert the command parameter of the insert command comment sentence into the log table through the global variable group, the command parameter of the insert command comment sentence includes log information of the SQL sentence corresponding to the insert command comment sentence; the second insert module , Used to read the SQL statement corresponding to the second command comment statement, execute the SQL statement, if the SQL statement fails to execute, generate the execution error information of the SQL statement, and convert the execution error information of the SQL statement Assign a value to the global variable corresponding to the execution error information in the global variable group, and insert the execution error information into the log table through the global variable group.

A third aspect of the present application provides a computer device that includes a processor, and the processor is configured to implement the log insertion method when executing computer-readable instructions stored in a memory.

A fourth aspect of the present application provides a non-volatile readable storage medium having computer readable instructions stored thereon, and when the computer readable instructions are executed by a processor, the log insertion method is implemented.

This application can improve the efficiency of inserting SQL statement execution error information into the log table.

Description of the drawings

Fig. 1 is a flowchart of a log insertion method provided by an embodiment of the present application.

Figure 2 is a structural diagram of a log insertion device provided by an embodiment of the present application.

Fig. 3 is a schematic diagram of a computer device provided by an embodiment of the present application.

detailed description

Preferably, the log insertion method of this application is applied to one or more computer devices. The computer device may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. The computer device can interact with the user through a keyboard, a mouse, a remote control, a touch panel, or a voice control device.

Example one

FIG. 1 is a flowchart of a log insertion method provided in Embodiment 1 of the present application. The log insertion method is applied to a computer device.

The log insertion method of this application is used to insert the log information of the SQL statement execution failure in the log table.

As shown in Figure 1, the log insertion method includes:

S101. Set a task configuration file. The task configuration file includes a first command comment statement, a second command comment statement, and a SQL (Structured Query Language) statement, the SQL statement and the second command comment The sentence corresponds.

In this embodiment, each task configuration file describes a database operation task, such as importing specified data into the database. Each task configuration file includes one first command comment statement and multiple second command comment statements, and each second command comment statement corresponds to at least one SQL statement.

In this embodiment, the structure of the task configuration file should satisfy: the first command comment sentence is the first sentence of the task configuration file, and the second command comment sentence is adjacent to its corresponding SQL sentence, And the second command comment statement is before its corresponding SQL statement. It can be detected whether the task configuration file meets the structural requirements, and if the task configuration file meets the structural requirements, the subsequent steps are executed. Otherwise, if the task configuration file does not meet the structural requirements, the process ends.

Each of the first command comment statement or the second command comment statement includes at least one command. In this embodiment, the command includes a command for updating the log table. The commands used to update the log table may include "@task_name=XXX", "@task_desc=XXX", "@step_name=XXX", "@step_desc=XXX", and so on. Among them, "@task_name="XXX" is used to set the task name, "@task_desc="XXX" is used to set the task description, "@step_name="XXX" is used to set the step name, and "@step_desc=XXX" is used to set the step description.

The command also includes a command for controlling the commit of the database transaction corresponding to the SQL statement. The command used to control the submission of the database transaction corresponding to the SQL statement may include "@autocommit=true|false", which is used to set whether to submit the database transaction corresponding to the SQL statement after the SQL statement is executed.

In another embodiment, the command may also include a command for controlling the output of log information. The command used to control the output of log information can be "@debug=true|false", which is used to set whether to output the execution failure information of the SQL statement in the log table.

The SQL statement is used to implement specific business logic of database operation tasks.

Optionally, the task configuration file may also include other comment statements. For example, the task configuration file may also include SQL statement comment statements, which are used to explain the SQL statements in the task configuration file to facilitate users to understand the SQL statements.

In the first command comment sentence and the second command comment sentence, comment recognition characters may be used to mark the first command comment sentence and the second command comment sentence. For example, the comment recognition character "-" may be used to indicate the first command comment sentence and the second command comment sentence. Therefore, if the code line includes a comment recognition character, the code line is the first command comment statement or the second command comment statement; if the code line does not include the comment recognition character, the code line is a SQL statement.

The command recognition characters of the first command comment sentence and the second command comment sentence may be the same or different. For example, the first command comment sentence includes a first command recognition character, and the second command comment sentence includes a second command recognition character.

The commands in the first command comment sentence and the second command comment sentence can be marked with command recognition characters. For example, the command recognition character "-#" may be used to indicate the commands in the first command comment sentence and the second command comment sentence.

S102: Read the first command comment sentence, and parse the command identifier and command parameter of the first command comment sentence.

In an embodiment, if the first command comment sentence is the first sentence of the task configuration file, then the first sentence of the task configuration file is read.

Or, in another embodiment, the first command comment sentence includes a first command recognition character, and the first command comment sentence is read according to the first command recognition character.

The first command comment sentence has a fixed format, and the command identifier and command parameters of the first command comment sentence are parsed according to the format of the first command comment sentence. The first command comment statement may include multiple command identifiers and multiple command parameters, where the command identifiers and command parameters have a one-to-one correspondence.

For example, the comment sentence of the first command is "@task_name=T001; @autocommit=true; @task_desc=Back up the user table once a day". The first command comment statement includes the commands "@task_name=T001", "@autocommit=true", and "@task_desc=Back up the user table once a day". The command "@task_name="T001" is used to set the task name to T001, the command "@autocommit="true" is used to set the SQL statement to submit the database transaction corresponding to the SQL statement after the SQL statement is executed, the command "@task_desc = backup user table once a day" Used to set the task description as "Back up user table once a day". The character string between the character "@" and the character "=" is the command identifier, the semicolon ";" after the character "=" is the command parameter, and the three command identifiers of the first command comment statement are parsed as "@task_name" ", "@autocommit", "@task_desc", the three command parameters corresponding to the three command identifiers are "T001", "true", and "Back up the user table once a day".

In one embodiment, the first command comment statement includes a command for controlling output of log information, for example, including "@debug=true", and the command identifier of the first command comment statement is parsed as "@debug", so The command parameter corresponding to the command identifier is "true".

S103: Initialize the global variable group corresponding to the task configuration file according to the command identifier and the command parameter of the first command comment statement.

In a specific embodiment, the initialization of the global variable group corresponding to the task configuration file according to the command identifier and the command parameter of the first command comment statement includes:

Initializing the global variables in the global variable group to a null value;

Query the preset command identifier-global variable table, and determine whether the global variable group contains the global variable corresponding to the command identifier of the first command comment sentence;

If the global variable group contains the global variable corresponding to the command identifier of the first command comment sentence, the command parameter corresponding to the command identifier of the first command comment sentence is assigned to the first command parameter in the global variable group. The command identification of a command comment statement corresponds to the global variable.

For example, the preset command identifier-global variable table is "@task_name-task_name; @autocommit-autocommit; @task_desc-task_desc", indicating that the command identifiers "@task_name", "@autocommit", "@task_desc" correspond to The global variables are "task_name", "autocommit", and "task_desc". Initialize the global variables in the global variable group corresponding to the task configuration file to "task_name=null; autocommit=null; task_desc=null". The first command comment statement in the task configuration file is "@task_name=T001; @autocommit=true; @task_desc=Back up the user table once a day". The global variable group corresponding to the task configuration file contains the global variable "task_name" corresponding to the command identifier "@task_name" of the first command comment statement, and the global variable "autocommit" corresponding to the command identifier "@autocommit" containing the first command comment statement , And the global variable "task_desc" corresponding to the command identifier "@task_desc" containing the first command comment statement. Therefore, the command parameter "T001" corresponding to the command identifier "@task_name" of the first command comment statement is assigned to the global variable "task_name" corresponding to the command identifier of the first command comment statement in the global variable group, and the first command comment statement The command parameter "true" corresponding to the command identifier "@autocommit" is assigned to the global variable "autocommit" corresponding to the command identifier of the first command comment statement in the global variable group, and the command identifier "@task_desc" of the first command comment statement corresponds to The command parameter "Backup user table once a day" is assigned to the global variable "task_desc" corresponding to the command identifier of the first command comment statement in the global variable group. The global variable group after assignment is "task_name=T001; autocommit=true; task_desc= Back up the user table once a day".

S104: Read the second command comment sentence, analyze the command identifier and command parameter of the second command comment sentence, and determine the type of the second command comment sentence according to the command identifier of the second command comment sentence.

In an embodiment, the second command comment sentence includes a second command recognition character, and the second command comment sentence is read according to the second command recognition character.

The second command comment sentence has a fixed format, and the command identifier and command parameter of the second command comment sentence are parsed according to the format of the second command comment sentence. The second command comment statement may include multiple command identifiers and multiple command parameters, where the command identifiers and the command parameters have a one-to-one correspondence.

The judging the category of the second command comment sentence according to the command identifier of the second command comment sentence includes:

If the command identifier of the second command comment sentence is @step_name or @step_desc, the category of the second command comment sentence is an insert command comment sentence;

If the command identifier of the second command comment sentence is @autocommit, the category of the second command comment sentence is a submit command comment sentence.

S105: If the category of the second command comment sentence is an insert command comment sentence, insert the command parameter of the insert command comment sentence into the log table through the global variable group, and the command parameter of the insert command comment sentence includes Describe the log information of the SQL statement corresponding to the insert command comment statement.

In a specific embodiment, the inserting the command parameter of the insert command comment statement into the log table through the global variable group includes:

Query the preset command identifier-global variable table, and determine the global variable corresponding to the command identifier of the inserted command comment sentence in the global variable group;

Assign the command parameter of the insert command comment sentence to the global variable corresponding to the command identifier of the insert command comment sentence in the global variable group, wherein the command parameter of the insert command comment sentence is the same as that of the insert command comment sentence. One-to-one correspondence between command identifiers;

Generating a first log insertion statement according to the global variable group;

The first log insert statement is executed, and the global variable corresponding to the command identifier of the insert command comment statement in the global variable group is inserted into the log table.

For example, the insert command comment statement is "@step_name=backup_table; @step_desc=backup table". Query the preset command ID-global variable table, and determine that the global variable corresponding to the command ID of the command comment statement inserted in the global variable group is "step_name=null; step_desc=null". Assign the command parameter "backup_table" of the inserted command comment statement to the global variable "step_name" corresponding to the command ID "@step_name" of the command comment statement inserted in the global variable group, and assign the command parameter "backup table" of the inserted command comment statement to The global variable "step_desc" corresponding to the command identifier "@step_desc" of the inserted command comment statement in the global variable group, and the global variable corresponding to the command identifier of the inserted command comment statement after assignment is "step_name=backup_table; step_desc=backup table". According to the global variable group "task_name = T001; autocommit = true; task_desc = backup user table once a day; step_name = backup_table; step_desc = backup table" to generate the first log insert statement "Insert into etl_task_log(task_name, step_name, step_desc, start_time) values (T001,backup_table,'backup table',now())", where "now()" is a function to get the current time. The first log insert statement is executed, and the global variable corresponding to the command identifier of the command comment statement inserted in the global variable group is inserted into the log table.

S106: Read the SQL statement corresponding to the second command comment statement, and execute the SQL statement.

The SQL sentence corresponding to the second command comment sentence is a code line that does not include the command recognition character and the comment recognition character.

Executing the SQL statement is to operate the database according to the SQL statement to realize the database operation task described in the task configuration file, such as importing given data into the database.

S107: If the execution of the SQL statement fails, generate execution error information of the SQL statement, assign the execution error information of the SQL statement to the global variable corresponding to the execution error information in the global variable group, and pass the The global variable group inserts the execution error information into the log table.

In a specific embodiment, generating execution error information of the SQL statement includes:

(1) Assign the execution identification information of the SQL statement to "false". The initial value of the execution identification information of the SQL statement is "true", and the execution identification information of the SQL statement is assigned a value of "false", indicating that the execution of the SQL statement failed.

(2) Determine whether the parameters in the SQL statement are correct, and if the parameters in the SQL statement are incorrect, generate a first execution error message. It can be judged whether the data type of the parameter in the SQL statement is correct, and whether the value of the parameter in the SQL statement is a preset value. If the data type of the parameter in the SQL statement is incorrect, or the parameter of the parameter in the SQL statement is not a preset value, the parameter in the SQL statement is incorrect, and a first execution error message is generated.

(3) Determine whether the table in the SQL statement is correct, and if the table in the SQL statement is incorrect, generate a second execution error message. It can be judged whether the table in the SQL statement exists, and whether there is access permission to the table in the SQL statement, if the table in the SQL statement does not exist, or there is no access permission to the table in the SQL statement , The table in the SQL statement is incorrect, and a second execution error message is generated.

(4) If the parameters in the SQL statement are correct and the tables in the SQL statement are correct, a third execution error message is generated. If the parameters in the SQL statement are correct and the tables in the SQL statement are correct, it means that other errors have occurred during the execution of the SQL statement, and a third execution error message is generated.

Assigning the execution error information of the SQL statement to the global variable corresponding to the execution error information in the global variable group is to convert the execution error information into a string and assign it to the global variable group and the execution error The global variable corresponding to the information. For example, convert the execution identification information "false", the first execution error information "false001", and the second execution error information "false002" into the string "false$false001$false002" and assign them to the global variable group corresponding to the execution error information The global variable "status=false$false001$false002". Or, converting the execution identification information "false" and the third execution error information "false003" into a character string "false$false003" and assigning it to the global variable "status=false$false003" corresponding to the execution error information in the global variable group, Among them, "status" is a global variable corresponding to the execution error message.

The inserting the execution error information into the log table through the global variable group includes:

(1) Generate a second log insertion statement according to the global variable group. For example, according to the global variable group "task_name=T001; autocommit=true; task_desc=backup user table once a day; step_name=backup_table; step_desc=backup table; status=false$false003" to generate the second log insert statement "Insert" into etl_task_log(task_name,step_name,step_desc,start_time,status)values(T001,backup_table,'backup table',now(),false$false003)".

(2) Execute the second log insertion statement, and insert the global variable corresponding to the execution error information in the global variable into the log table.

For example, execute "Insert into etl_task_log(task_name,step_name,step_desc,start_time,status)values(T001,backup_table,'backup table',now(),false$false003)", and set the execution error information in the global variable The corresponding global variable is inserted into the log table.

The log insertion method of the first embodiment sets a task configuration file, the task configuration file includes a first command comment statement, a second command comment statement, and a SQL statement corresponding to the second command comment statement; read the first Command comment sentence, parse the command identifier and command parameter of the first command comment sentence; initialize the global variable group corresponding to the task configuration file according to the command identifier and command parameter of the first command comment sentence; read the first command comment sentence Second command comment sentence, parse the command identifier and command parameter of the second command comment sentence, and judge the category of the second command comment sentence according to the command identifier of the second command comment sentence; if the second command comment sentence The category of the insert command comment statement is the insert command comment statement. The command parameter of the insert command comment statement is inserted into the log table through the global variable group. The command parameter of the insert command comment statement includes the SQL statement corresponding to the insert command comment statement. Log information; read the SQL statement corresponding to the second command comment statement, execute the SQL statement; if the SQL statement fails to execute, generate the execution error information of the SQL statement, and replace the execution error information of the SQL statement Assign a value to the global variable corresponding to the execution error information in the global variable group, and insert the execution error information into the log table through the global variable group. The first embodiment can improve the efficiency of inserting SQL statement execution error information into the log table.

In another embodiment, the method may further include:

If the category of the second command comment sentence is a submit command comment sentence, it is determined whether the command parameter in the submit command comment sentence is "true";

If the command parameter in the comment statement of the submit command is "true", then the database transaction corresponding to the SQL statement is submitted.

In another embodiment, the method may further include:

If the execution of the SQL statement fails, it is determined whether the command parameter used to control the output log information in the first command comment statement is "true";

If the command parameter used to control the output of log information in the first command comment statement is "true", then the execution failure information of the SQL statement in the log table is output.

In another embodiment, before the initialization of the global variable group corresponding to the task configuration file according to the command identifier and the command parameter of the first command comment statement, the method further includes:

It is determined whether the command identifier in the first command comment sentence is included in the command identifier-global variable table.

If the command identifier in the first command comment sentence is included in the command identifier-global variable table, initialize the global variable group corresponding to the task configuration file according to the command identifier and command parameters of the first command comment sentence .

In another embodiment, before the judging the category of the second command comment sentence according to the command identifier of the second command comment sentence, the method may further include:

It is determined whether the command identifier in the second command comment sentence is included in the command identifier-global variable table.

If the command identifier in the second command comment sentence is included in the command identifier-global variable table, the type of the second command comment sentence is determined according to the command identifier of the second command comment sentence.

Example two

Fig. 2 is a structural diagram of a log insertion device provided in the second embodiment of the present application. The log insertion device 20 is applied to a computer device. The log insertion of this device is to insert the log information of the SQL statement execution failure in the log table. As shown in FIG. 2, the log insertion device 20 may include a setting module 201, a first analysis module 202, an initialization module 203, a second analysis module 204, a first insertion module 205, and a second insertion module 206.

The setting module 201 is used to set a task configuration file. The task configuration file includes a first command comment statement, a second command comment statement, and SQL (Structured Query Language) statements. The comment statement of the second command corresponds to that.

Optionally, the task configuration file may also include other comment statements. For example, the task configuration file may also include SQL statement comment statements, which are used to explain the SQL statements in the task configuration file, so as to facilitate users to understand the SQL statements.

The first parsing module 202 is configured to read the first command comment sentence and parse the command identifier and command parameters of the first command comment sentence.

The initialization module 203 is configured to initialize the global variable group corresponding to the task configuration file according to the command identifier and the command parameter of the first command comment statement.

Initializing the global variables in the global variable group to a null value;

The second parsing module 204 is configured to read the second command comment sentence, parse the command identifier and command parameter of the second command comment sentence, and determine the second command according to the command identifier of the second command comment sentence The category of the comment statement.

The first insert module 205 is configured to insert the command parameter of the insert command comment sentence into the log table through the global variable group if the type of the second command comment sentence is the insert command comment sentence, the insert command comment sentence The command parameter of includes the log information of the SQL statement corresponding to the insert command comment statement.

For example, insert the command comment statement as "@step_name=backup_table; @step_desc=backup table". Query the preset command ID-global variable table, and determine that the global variable corresponding to the command ID of the command comment statement inserted in the global variable group is "step_name=null; step_desc=null". Assign the command parameter "backup_table" of the inserted command comment statement to the global variable "step_name" corresponding to the command ID "@step_name" of the command comment statement inserted in the global variable group, and assign the command parameter "backup table" of the inserted command comment statement to The global variable "step_desc" corresponding to the command identifier "@step_desc" of the inserted command comment statement in the global variable group, and the global variable corresponding to the command identifier of the inserted command comment statement after assignment is "step_name=backup_table; step_desc=backup table". According to the global variable group "task_name = T001; autocommit = true; task_desc = backup user table once a day; step_name = backup_table; step_desc = backup table" to generate the first log insert statement "Insert into etl_task_log(task_name, step_name, step_desc, start_time) values (T001,backup_table,'backup table',now())", where "now()" is a function to get the current time. The first log insert statement is executed, and the global variable corresponding to the command identifier of the command comment statement inserted in the global variable group is inserted into the log table.

The second insert module 206 is configured to read the SQL statement corresponding to the second command comment statement, and execute the SQL statement.

The second insert module 206 is further configured to generate execution error information of the SQL statement if the execution of the SQL statement fails, and assign the execution error information of the SQL statement to the execution error information corresponding to the global variable group The execution error information is inserted into the log table through the global variable group.

(1) Generate a second log insertion statement according to the global variable group. For example, according to the global variable group "task_name=T001; autocommit=true; task_desc= backup user table once a day; step_name= backup_table; step_desc= backup table; status=false$false003" to generate the second log insert statement "Insert" into etl_task_log(task_name,step_name,step_desc,start_time,status)values(T001,backup_table,'backup table',now(),false$false003)".

The log insertion device 20 of the second embodiment sets a task configuration file, the task configuration file includes a first command comment sentence, a second command comment sentence and a SQL sentence corresponding to the second command comment sentence; reads the first command comment sentence A command comment sentence, parsing the command identifier and command parameter of the first command comment sentence; initialize the global variable group corresponding to the task configuration file according to the command identifier and command parameter of the first command comment sentence; read the The second command comment sentence, parse the command identifier and command parameter of the second command comment sentence, and judge the category of the second command comment sentence according to the command identifier of the second command comment sentence; if the second command comment The category of the sentence is the insert command comment sentence, the command parameter of the insert command comment sentence is inserted into the log table through the global variable group, and the command parameter of the insert command comment sentence includes the SQL sentence corresponding to the insert command comment sentence Read the SQL statement corresponding to the comment statement of the second command, execute the SQL statement; if the SQL statement fails to execute, generate the execution error information of the SQL statement, and the execution error of the SQL statement The information is assigned to the global variable corresponding to the execution error information in the global variable group, and the execution error information is inserted into the log table through the global variable group. The second embodiment can improve the efficiency of inserting SQL statement execution error information into the log table.

In another embodiment, the log insertion device 20 may further include: a submit module, configured to determine the command parameters in the submit command comment sentence if the type of the second command comment sentence is a submit command comment sentence Whether it is "true"; if the command parameter in the submit command comment statement is "true", then the database transaction corresponding to the SQL statement is submitted.

In another embodiment, the log insertion device 20 may further include: an output module, configured to determine whether the command parameter used to control the output of the log information in the first command comment statement if the SQL statement fails to execute Is "true", if the command parameter used to control the output of log information in the first command comment statement is "true", then the execution failure information of the SQL statement in the log table is output.

In another embodiment, the log insertion device 20 may further include: a first judgment module configured to initialize the global corresponding to the task configuration file according to the command identifier and command parameters of the first command comment statement. Before the variable group, it is judged whether the command identifier in the first command comment sentence is included in the command identifier-global variable table. If the command identifier in the first command comment sentence is included in the command identifier-global variable table, the initialization module 203 initializes the task configuration file according to the command identifier and command parameters of the first command comment sentence The corresponding global variable group.

In another embodiment, the log insertion device 20 may further include: a second judgment module, configured to, before judging the category of the second command comment sentence according to the command identifier of the second command comment sentence, It is determined whether the command identifier in the second command comment sentence is included in the command identifier-global variable table. If the command identifier in the second command comment sentence is included in the command identifier-global variable table, the second parsing module 204 determines the second command comment according to the command identifier of the second command comment sentence The category of the statement.

Example three

This embodiment provides a non-volatile readable storage medium having computer readable instructions stored on the non-volatile readable storage medium, and when the computer readable instructions are executed by a processor, the above log insertion method embodiment is implemented For example, the steps S101-S107 shown in FIG. 1; or, when the computer-readable instructions are executed by the processor, the functions of the modules in the above-mentioned device embodiment are realized, for example, the modules 201-206 in FIG.

Example four

FIG. 3 is a schematic diagram of a computer device provided in Embodiment 4 of this application. The computer device 30 includes a memory 301, a processor 302, and computer-readable instructions 303 stored in the memory 301 and running on the processor 302, such as a log insertion program. When the processor 302 executes the computer-readable instruction 303, the steps in the log insertion method embodiment are implemented, for example, steps S101-S107 shown in FIG. 1; or, the computer-readable instruction is executed by the processor to implement the foregoing steps. The function of each module in the device embodiment is, for example, the modules 201-206 in FIG. 2.

Exemplarily, the computer-readable instruction 303 may be divided into one or more modules, and the one or more modules are stored in the memory 301 and executed by the processor 302 to complete the method . For example, the computer-readable instruction 303 can be divided into the setting module 201, the first analysis module 202, the initialization module 203, the second analysis module 204, the first insertion module 205, and the second insertion module 206 in FIG. 2. For specific functions of each module, refer to Embodiment 2.

The computer device 30 may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. Those skilled in the art can understand that the schematic diagram 3 is only an example of the computer device 30 and does not constitute a limitation on the computer device 30. It may include more or less components than those shown in the figure, or combine certain components, or be different. For example, the computer device 30 may also include input and output devices, network access devices, buses, etc.

The so-called processor 302 may be a central processing unit (Central Processing Unit, CPU), other general-purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (ASIC), Field-Programmable Gate Array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. The general-purpose processor can be a microprocessor or the processor 302 can also be any conventional processor, etc. The processor 302 is the control center of the computer device 30 and connects the entire computer device 30 with various interfaces and lines. Various parts.

The memory 301 may be used to store the computer-readable instructions 303, and the processor 302 executes or executes the computer-readable instructions or modules stored in the memory 301, and calls data stored in the memory 301 to implement Various functions of the computer device 30. The memory 301 may mainly include a program storage area and a data storage area. The program storage area may store an operating system, an application program required by at least one function (such as a sound playback function, an image playback function, etc.), etc.; The data created according to the use of the computer device 30 is stored. In addition, the memory 301 may include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a Secure Digital (SD) card, a flash memory card (Flash Card), At least one magnetic disk storage device, flash memory device, or other non-volatile solid state storage device.

If the integrated module of the computer device 30 is implemented in the form of a software function module and sold or used as an independent product, it may be stored in a non-volatile readable storage medium. Based on this understanding, this application implements all or part of the processes in the above-mentioned embodiments and methods, and can also be completed by instructing relevant hardware through computer-readable instructions. The computer-readable instructions can be stored in a non-volatile memory. In the read storage medium, when the computer-readable instructions are executed by the processor, the steps of the foregoing method embodiments can be implemented. Wherein, the computer-readable instructions may be in the form of source code, object code, executable file, or some intermediate forms, etc. The non-volatile readable storage medium may include: any entity or device capable of carrying the computer-readable instruction code, recording medium, U disk, mobile hard disk, magnetic disk, optical disk, read-only memory (ROM, Read- Only Memory).

In the several embodiments provided in this application, it should be understood that the disclosed system, device, and method may be implemented in other ways. For example, the device embodiments described above are only illustrative. For example, the division of the modules is only a logical function division, and there may be other division methods in actual implementation.

Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the application and not to limit them. Although the application has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art should understand that the technical solutions of the application can be Make modifications or equivalent replacements without departing from the spirit and scope of the technical solution of the present application.

Claims

A log insertion method, characterized in that the method includes:

Setting a task configuration file, the task configuration file including a first command comment statement, a second command comment statement, and a SQL statement corresponding to the second command comment statement;

Read the first command comment sentence, and parse the command identifier and command parameters of the first command comment sentence;

Initialize the global variable group corresponding to the task configuration file according to the command identifier and the command parameter of the first command comment statement;

Read the second command comment sentence, parse the command identifier and command parameter of the second command comment sentence, and determine the type of the second command comment sentence according to the command identifier of the second command comment sentence;

If the category of the second command comment sentence is an insert command comment sentence, insert the command parameter of the insert command comment sentence into the log table through the global variable group, and the command parameter of the insert command comment sentence includes the same as the insert command comment sentence. The log information of the SQL statement corresponding to the command comment statement;

Read the SQL statement corresponding to the second command comment statement, and execute the SQL statement;

If the execution of the SQL statement fails, the execution error information of the SQL statement is generated, and the execution error information of the SQL statement is assigned to the global variable corresponding to the execution error information in the global variable group, through the global variable The group inserts the execution error information into the log table.
The method according to claim 1, wherein the initializing the global variable group corresponding to the task configuration file according to the command identifier and the command parameter of the first command comment statement comprises:

Initializing the global variables in the global variable group to a null value;

Query the preset command identifier-global variable table, and determine whether the global variable group contains the global variable corresponding to the command identifier of the first command comment sentence;

If the global variable group contains the global variable corresponding to the command identifier of the first command comment sentence, the command parameter corresponding to the command identifier of the first command comment sentence is assigned to the first command parameter in the global variable group. The command identification of a command comment statement corresponds to the global variable.
The method according to claim 1, wherein the inserting the command parameter of the insert command comment statement into the log table through the global variable group comprises:

Query the preset command identifier-global variable table, and determine the global variable corresponding to the command identifier of the inserted command comment sentence in the global variable group;

Assigning the command parameter of the insert command comment sentence to the global variable corresponding to the command identifier of the insert command comment sentence in the global variable group;

Generating a first log insertion statement according to the global variable group;

The first log insert statement is executed, and the global variable corresponding to the command identifier of the insert command comment statement in the global variable group is inserted into the log table.
The method according to claim 1, wherein said generating execution error information of said SQL statement comprises:

Assigning the execution identification information of the SQL statement to "false";

Determine whether the parameters in the SQL statement are correct, and if the parameters in the SQL statement are incorrect, generate a first execution error message;

Determine whether the table in the SQL statement is correct, and if the table in the SQL statement is incorrect, generate a second execution error message;

If the parameters in the SQL statement are correct and the tables in the SQL statement are correct, a third execution error message is generated.
The method according to claim 1, wherein the inserting the execution error information into the log table through the global variable group comprises:

Generating a second log insertion statement according to the global variable group;

The second log insertion statement is executed, and the global variable corresponding to the execution error information in the global variable is inserted into the log table.
The method according to any one of claims 1-5, wherein the method further comprises:

If the category of the second command comment sentence is a submit command comment sentence, it is determined whether the command parameter in the submit command comment sentence is "true";

If the command parameter in the comment statement of the submit command is "true", then the database transaction corresponding to the SQL statement is submitted.
The method according to any one of claims 1-5, wherein the method further comprises:

If the execution of the SQL statement fails, it is determined whether the command parameter used to control the output log information in the first command comment statement is "true";

If the command parameter used to control the output of log information in the first command comment statement is "true", then the execution failure information of the SQL statement in the log table is output.
A log insertion device, characterized in that the device includes:

A setting module for setting a task configuration file, the task configuration file including a first command comment statement, a second command comment statement, and a SQL statement corresponding to the second command comment statement;

The first parsing module is configured to read the first command comment sentence and parse the command identifier and command parameters of the first command comment sentence;

An initialization module, configured to initialize the global variable group corresponding to the task configuration file according to the command identifier and command parameters of the first command comment statement;

The second parsing module is configured to read the second command comment sentence, parse the command identifier and command parameter of the second command comment sentence, and determine the second command comment according to the command identifier of the second command comment sentence Type of sentence;

The first insert module is used to insert the command parameter of the insert command comment sentence into the log table through the global variable group if the type of the second command comment sentence is the insert command comment sentence. The command parameter includes log information of the SQL statement corresponding to the insert command comment statement;

The second insert module is used to read the SQL statement corresponding to the second command comment statement, execute the SQL statement, if the SQL statement fails to execute, generate the execution error information of the SQL statement, and convert the SQL statement The execution error information of is assigned to the global variable corresponding to the execution error information in the global variable group, and the execution error information is inserted into the log table through the global variable group.
A computer device, wherein the computer device includes a processor and a memory, and the processor is configured to execute computer-readable instructions stored in the memory to implement the following steps:

Setting a task configuration file, the task configuration file including a first command comment statement, a second command comment statement, and a SQL statement corresponding to the second command comment statement;

Read the first command comment sentence, and parse the command identifier and command parameters of the first command comment sentence;

Initialize the global variable group corresponding to the task configuration file according to the command identifier and the command parameter of the first command comment statement;

Read the second command comment sentence, parse the command identifier and command parameter of the second command comment sentence, and determine the type of the second command comment sentence according to the command identifier of the second command comment sentence;

If the category of the second command comment sentence is an insert command comment sentence, insert the command parameter of the insert command comment sentence into the log table through the global variable group, and the command parameter of the insert command comment sentence includes the same as the insert command comment sentence. The log information of the SQL statement corresponding to the command comment statement;

Read the SQL statement corresponding to the second command comment statement, and execute the SQL statement;

If the execution of the SQL statement fails, the execution error information of the SQL statement is generated, and the execution error information of the SQL statement is assigned to the global variable corresponding to the execution error information in the global variable group, through the global variable The group inserts the execution error information into the log table.
The computer device according to claim 9, wherein the processor executes computer-readable instructions stored in the memory to implement the initialization of the command identifier and command parameters according to the first command comment statement The global variable group corresponding to the task configuration file includes:

Initializing the global variables in the global variable group to a null value;

Query the preset command identifier-global variable table, and determine whether the global variable group contains the global variable corresponding to the command identifier of the first command comment sentence;

If the global variable group contains the global variable corresponding to the command identifier of the first command comment sentence, the command parameter corresponding to the command identifier of the first command comment sentence is assigned to the first command parameter in the global variable group. The command identification of a command comment statement corresponds to the global variable.
The computer device according to claim 9, wherein the processor executes computer-readable instructions stored in the memory to implement the insertion of the command parameter of the insert command comment statement through the global variable group The log table includes:

Query the preset command identifier-global variable table, and determine the global variable corresponding to the command identifier of the inserted command comment sentence in the global variable group;

Assigning the command parameter of the insert command comment sentence to the global variable corresponding to the command identifier of the insert command comment sentence in the global variable group;

Generating a first log insertion statement according to the global variable group;

The first log insert statement is executed, and the global variable corresponding to the command identifier of the insert command comment statement in the global variable group is inserted into the log table.
9. The computer device according to claim 9, wherein when the processor executes the computer-readable instructions stored in the memory to implement the generation of the execution error information of the SQL statement, the method comprises:

Assigning the execution identification information of the SQL statement to "false";

Determine whether the parameters in the SQL statement are correct, and if the parameters in the SQL statement are incorrect, generate a first execution error message;

Determine whether the table in the SQL statement is correct, and if the table in the SQL statement is incorrect, generate a second execution error message;

If the parameters in the SQL statement are correct and the tables in the SQL statement are correct, a third execution error message is generated.
The computer device of claim 9, wherein the processor executes computer-readable instructions stored in the memory to implement the inserting the execution error information into the log table through the global variable group When including:

Generating a second log insertion statement according to the global variable group;

The second log insertion statement is executed, and the global variable corresponding to the execution error information in the global variable is inserted into the log table.
The computer device according to any one of claims 9-13, wherein the processor further implements the following steps when executing the computer-readable instructions stored in the memory:

If the category of the second command comment sentence is a submit command comment sentence, it is determined whether the command parameter in the submit command comment sentence is "true";

If the command parameter in the comment statement of the submit command is "true", then the database transaction corresponding to the SQL statement is submitted.
A non-volatile readable storage medium having computer readable instructions stored on the non-volatile readable storage medium, characterized in that, when the computer readable instructions are executed by a processor, the following steps are implemented:

Setting a task configuration file, the task configuration file including a first command comment statement, a second command comment statement, and a SQL statement corresponding to the second command comment statement;

Read the first command comment sentence, and parse the command identifier and command parameters of the first command comment sentence;

Initialize the global variable group corresponding to the task configuration file according to the command identifier and the command parameter of the first command comment statement;

Read the second command comment sentence, parse the command identifier and command parameter of the second command comment sentence, and determine the type of the second command comment sentence according to the command identifier of the second command comment sentence;

If the category of the second command comment sentence is an insert command comment sentence, insert the command parameter of the insert command comment sentence into the log table through the global variable group, and the command parameter of the insert command comment sentence includes the same as the insert command comment sentence. The log information of the SQL statement corresponding to the command comment statement;

Read the SQL statement corresponding to the second command comment statement, and execute the SQL statement;

If the execution of the SQL statement fails, the execution error information of the SQL statement is generated, and the execution error information of the SQL statement is assigned to the global variable corresponding to the execution error information in the global variable group, through the global variable The group inserts the execution error information into the log table.
The storage medium of claim 15, wherein the computer-readable instructions are executed by the processor to implement the initialization of the task configuration file according to the command identifier and command parameters of the first command comment statement The corresponding global variable group includes:

Initializing the global variables in the global variable group to a null value;

Query the preset command identifier-global variable table, and determine whether the global variable group contains the global variable corresponding to the command identifier of the first command comment sentence;

If the global variable group contains the global variable corresponding to the command identifier of the first command comment sentence, the command parameter corresponding to the command identifier of the first command comment sentence is assigned to the first command parameter in the global variable group. The command identification of a command comment statement corresponds to the global variable.
The storage medium according to claim 15, wherein the computer-readable instructions are executed by the processor to implement when the command parameters of the insert command comment statement are inserted into the log table through the global variable group ,include:

Query the preset command identifier-global variable table, and determine the global variable corresponding to the command identifier of the inserted command comment sentence in the global variable group;

Assigning the command parameter of the insert command comment sentence to the global variable corresponding to the command identifier of the insert command comment sentence in the global variable group;

Generating a first log insertion statement according to the global variable group;

The first log insert statement is executed, and the global variable corresponding to the command identifier of the insert command comment statement in the global variable group is inserted into the log table.
15. The storage medium according to claim 15, wherein when the computer-readable instruction is executed by the processor to implement the generation of the execution error message of the SQL statement, it comprises:

Assigning the execution identification information of the SQL statement to "false";

Determine whether the parameters in the SQL statement are correct, and if the parameters in the SQL statement are incorrect, generate a first execution error message;

Determine whether the table in the SQL statement is correct, and if the table in the SQL statement is incorrect, generate a second execution error message;

If the parameters in the SQL statement are correct and the tables in the SQL statement are correct, a third execution error message is generated.
The storage medium according to claim 15, wherein when the computer-readable instructions are executed by the processor to implement the inserting the execution error information into the log table through the global variable group, it comprises :

Generating a second log insertion statement according to the global variable group;

The second log insertion statement is executed, and the global variable corresponding to the execution error information in the global variable is inserted into the log table.
19. The storage medium according to any one of claims 15-19, wherein the computer-readable instructions further implement the following steps when being executed by the processor:

If the category of the second command comment sentence is a submit command comment sentence, it is determined whether the command parameter in the submit command comment sentence is "true";

If the command parameter in the comment statement of the submit command is "true", then the database transaction corresponding to the SQL statement is submitted.