Script correction checking method and device, equipment and storage medium
The script correction and verification method addresses inefficiencies in task dependency configuration by identifying unconfigured source tables and updating scripts based on task scheduling, resulting in accurate and stable data processing.
Patent Information
- Application Number
- CN202411171977.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-23
- Publication Date
- 2024-12-13
AI Technical Summary
Existing methods for configuring task dependencies in data processing are labor-intensive and time-consuming, often leading to errors such as incorrect recording of dependent task names and source tables, which result in inefficient and inaccurate data processing.
A script correction and verification method that identifies unconfigured dependency source tables, generates correction instructions, and updates scripts based on system task scheduling information to ensure accurate configuration and verification of dependencies.
Improves the accuracy and efficiency of script dependency source table correction and verification, preventing errors and enhancing the stability of data processing by ensuring correct task scheduling.
Smart Images
Figure CN119127207A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a script correction and verification method, device, equipment and storage medium. Background Art
[0002] Detection is one of the key projects of operation and maintenance, a key step and core issue in the development work of the data team, and an important basis for whether the business data model design is reasonable and the terminal business operation analysis is accurate. Configuring the dependency relationship between data tasks can realize automatic scheduling between upstream and downstream tables to ensure smooth operation of the data link. At the same time, the dependency logic of the data link is closely related to the business process logic. There will be buried data in every link of business operation. The dependency relationship connects the buried data in each link to form a data link. If the dependency relationship is wrong, it will mislead the business operation.
[0003] For example, in the application scenario of task scheduling, there is a time difference in task scheduling, and the running time is not completely stable. Errors, redundancies, and omissions in the configuration of task dependencies are likely to result in the situation where the upstream task has not yet been completed, but the downstream task has already started to collect data. The consequence is often that the task runs in vain, resulting in missing data, which has a serious impact on the data perception of the business, and violates the development process of the real business scenario, causing data link fault problems. Correct configuration of task dependencies not only ensures the smooth assessment of key links in business development, but is also responsible for the timeliness and accuracy of terminal business data, and has analytical and guiding significance for business operation scenarios.
[0004] At present, the dependencies of tasks are always controlled and configured by developers themselves. In the dependency configuration process, there are problems such as incorrect recording of dependent task names and dependent source tables. Therefore, operation and maintenance personnel must arrange manpower for fixed time periods to scan and correct errors. However, both detection and correction are time-consuming and labor-intensive and have low work efficiency. Summary of the invention
[0005] The main purpose of this application is to provide a script correction and verification method, device, equipment and storage medium, aiming to improve the accuracy and efficiency of script dependency source table correction and verification.
[0006] In a first aspect, the present application provides a script correction and verification method, the script correction and verification method comprising the following steps:
[0007] Obtaining a target script to be corrected, and determining dependent keywords in the target script;
[0008] Determine, according to the dependency keyword, a first data source table having a dependency relationship with the target script, wherein the first data source table includes configured dependency source table information and unconfigured dependency source table information;
[0009] Generate and output script correction instruction information according to the dependent source table information not configured in the first data source table, wherein the script correction instruction information is used to provide a reference for developers to correct the target script;
[0010] Obtaining dependent source table configuration information input by a developer according to the script correction instruction information;
[0011] The target script is updated according to the dependent source table configuration information, and system task scheduling information is obtained;
[0012] Check the updated target script's dependent source table according to the system task scheduling information to generate a check result for the updated target script
[0013] In a second aspect, the present application further provides a script correction and verification device, the script correction and verification device comprising an acquisition module, a determination module, an update module and a verification module, wherein:
[0014] The acquisition module is used to acquire the target script to be corrected;
[0015] The determination module is used to determine the dependent keywords in the target script;
[0016] The determination module is further used to determine a first data source table having a dependency relationship with the target script according to the dependency keyword, wherein the first data source table includes configured dependency source table information and unconfigured dependency source table information;
[0017] The determination module is further used to generate and output script correction instruction information according to the dependent source table information not configured in the first data source table, wherein the script correction instruction information is used to provide a reference for developers to correct the target script;
[0018] The acquisition module is further used to acquire the dependent source table configuration information input by the developer according to the script correction instruction information;
[0019] The update module is used to update the target script according to the dependent source table configuration information;
[0020] The acquisition module is also used to acquire system task scheduling information;
[0021] The checking module is used to check the dependency source table of the updated target script according to the system task scheduling information, and generate a checking result of the updated target script.
[0022] In a third aspect, the present application also provides a computer device, comprising a processor, a memory, and a computer program stored in the memory and executable by the processor, wherein when the computer program is executed by the processor, the steps of the script correction and verification method as described above are implemented.
[0023] In a fourth aspect, the present application further provides a computer-readable storage medium, on which a computer program is stored, wherein when the computer program is executed by a processor, the steps of the script correction and verification method as described above are implemented.
[0024] The present application provides a script correction and verification method, apparatus, device and storage medium. The present application obtains a target script to be corrected and determines dependent keywords in the target script; determines a first data source table that has a dependency relationship with the target script according to the dependent keywords, and the first data source table includes configured dependent source table information and unconfigured dependent source table information; generates and outputs script correction indication information according to the unconfigured dependent source table information in the first data source table, and the script correction indication information is used to provide a developer with a reference for correcting the target script; obtains dependent source table configuration information input by the developer according to the script correction indication information; updates the target script according to the dependent source table configuration information, and obtains system task scheduling information; performs dependent source table verification on the updated target script according to the system task scheduling information, and generates a verification result of the updated target script. In the present application, the unconfigured dependency source table information of the target script can be accurately determined according to the dependency keywords in the target script, and script correction instruction information is generated based on the unconfigured dependency source table information, so that the developer can input the dependency source table configuration information according to the script correction instruction information, and the target script can be accurately updated according to the dependency source table configuration information, which greatly improves the accuracy of the target script update; then, the dependency source table of the updated target script is checked according to the system task scheduling information, which effectively prevents errors in the target script and greatly improves the stability of the target script. BRIEF DESCRIPTION OF THE DRAWINGS
[0025] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.
[0026] Figure 1 A flowchart of a script correction and verification method provided in an embodiment of the present application;
[0027] Figure 2 for Figure 1 A schematic diagram of the sub-step flow of the script correction and verification method in FIG.
[0028] Figure 3 A schematic block diagram of a script correction and verification device provided in an embodiment of the present application;
[0029] Figure 4 for Figure 3 A schematic block diagram of the submodules of the script correction and inspection device;
[0030] Figure 5 A schematic block diagram of the structure of a computer device provided in an embodiment of the present application.
[0031] The realization of the purpose, functional features and advantages of this application will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION
[0032] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.
[0033] The flowcharts shown in the accompanying drawings are only examples and do not necessarily include all the contents and operations / steps, nor must they be executed in the order described. For example, some operations / steps may also be decomposed, combined or partially merged, so the actual execution order may change according to actual conditions.
[0034] The embodiments of the present application can acquire and process relevant data based on artificial intelligence technology. Among them, artificial intelligence (AI) is the theory, method, technology and application system that uses digital computers or machines controlled by digital computers to simulate, extend and expand human intelligence, perceive the environment, acquire knowledge and use knowledge to obtain the best results.
[0035] AI basic technologies generally include sensors, dedicated AI chips, cloud computing, distributed storage, big data processing technology, operation / interaction systems, mechatronics, etc. AI software technologies mainly include computer vision technology, robotics technology, biometrics technology, speech processing technology, natural language processing technology, and machine learning / deep learning.
[0036] The embodiments of the present application provide a script correction and verification method, apparatus, device and storage medium. The script correction and verification method can be applied to a computer device, which can be an electronic device such as a mobile phone, a tablet computer, a laptop computer, a desktop computer, a personal digital assistant and a wearable device.
[0037] In conjunction with the accompanying drawings, some embodiments of the present application are described in detail below. In the absence of conflict, the following embodiments and features in the embodiments can be combined with each other.
[0038] Please refer to Figure 1 , Figure 1 A flowchart of a script correction and verification method provided in an embodiment of the present application.
[0039] like Figure 1 As shown, the script correction and verification method includes steps S101 to S106.
[0040] Step S101: Obtain a target script to be corrected, and determine dependent keywords in the target script.
[0041] Among them, the target script is the script to be corrected, and the target script is the script in which the script parameters have been changed.
[0042] In some embodiments, the development scripts in the system are scanned, and the updated development scripts are obtained to determine whether the updated development script has an updated dependency source table; if the updated development script has an updated dependency source table, the development script is determined as the target script. By obtaining the updated development script, the target script that needs to be checked for dependency can be accurately obtained, which greatly improves the efficiency and accuracy of script correction and checking.
[0043] It should be noted that any development script with updated parameters can be defined as a development script with updated parameters.
[0044] In some embodiments, the method for determining whether the updated development script has an updated dependency source table can be: comparing the updated code in the updated development script with the script code of the same name in the preset code library to obtain the changed content, using visdiff() to output the changed content to obtain the changed result, and using find() to retrieve the changed result to obtain the changed dependency source table name. If the changed dependency source table name exists in the search result, it is determined that the updated development script has an updated dependency source table; if the changed dependency source table name does not exist in the search result, it is determined that the updated development script does not have an updated dependency source table.
[0045] In some embodiments, when the target script to be corrected is obtained, a preset dependency keyword table is obtained, and the preset dependency keyword table is compared with the target script to obtain the dependency keywords in the target script. The preset dependency keyword table is a set of pre-set dependency keywords, and the preset dependency keyword table can be set according to actual conditions, which is not specifically limited in the embodiments of the present invention.
[0046] Exemplarily, the target script is compared with a preset dependency keyword table, and the dependent keywords obtained are map(), from, and join.
[0047] Step S102: determining a first data source table having a dependency relationship with the target script according to the dependency keyword, wherein the first data source table includes configured dependency source table information and unconfigured dependency source table information.
[0048] The first data source table includes all dependent source table information of the target script, and the first data source table includes configured dependent source table information and unconfigured dependent source table information.
[0049] In some embodiments, all codes in the target script are traversed, and codes with dependent keywords are obtained, and first data with a dependency relationship is output from the codes with dependent keywords to obtain a first data source table, which includes configured dependent source table information and unconfigured dependent source table information.
[0050] In some embodiments, the first and second lines of code in the target script are traversed, and the code with the dependency keyword is obtained, and the first data with the dependency relationship is output from the code with the dependency keyword to obtain the first data source table, and the first data source table includes the configured dependency source table information and the unconfigured dependency source table information. The dependency relationship data exists in the first and second lines of the code, and only the first and second lines of the code are traversed, which can improve the efficiency of script correction and verification.
[0051] Step S103: Generate and output script correction instruction information according to the dependent source table information not configured in the first data source table, wherein the script correction instruction information is used to provide a reference for developers to correct the target script.
[0052] In some embodiments, script correction instruction information is generated based on dependent source table information that is not configured in the first data source table. The script correction instruction information is used to provide developers with a reference for correcting the target script, and the script correction instruction information is output so that the developer can obtain the script correction instruction information.
[0053] In some embodiments, the method of outputting the script correction instruction information can be set according to actual conditions, and the embodiments of the present invention do not specifically limit this. For example, the script correction instruction information is output to the screen of the terminal device used by the developer so that the developer can view the script correction instruction information. The terminal device can be selected according to actual conditions, and the embodiments of the present invention do not specifically limit this. For example, the terminal device can be a desktop computer.
[0054] Step S104: Obtain the dependent source table configuration information input by the developer according to the script correction instruction information.
[0055] In some embodiments, the developer refers to the script correction instruction information, determines the dependent source table configuration information, and obtains the dependent source table configuration information, where the dependent source table configuration information includes only one dependent source table.
[0056] Step S105: update the target script according to the dependent source table configuration information, and obtain system task scheduling information.
[0057] The system task scheduling information is process information of task scheduling during the system operation of the computer device.
[0058] In some embodiments, each dependent source table configuration in the dependent source table configuration information is used to update the script parameters in the target script to obtain an updated target script. The target script can be accurately updated by relying on the dependent source table configuration information, which greatly improves the accuracy and efficiency of target script correction.
[0059] In some embodiments, task scheduling information during the system operation is obtained to obtain system task scheduling information. By obtaining the system task scheduling information, the efficiency and accuracy of target script correction and inspection can be effectively improved, and the stability of target script operation can be greatly improved.
[0060] Step S106: Check the dependency source table of the updated target script according to the system task scheduling information to generate a check result of the updated target script.
[0061] The inspection result includes a first inspection result and a second inspection result, the first inspection result is that the inspection passed, and the second inspection result is that the inspection failed.
[0062] In some embodiments, Figure 2 As shown, step S106 includes sub-steps S1061 to S1063.
[0063] Sub-step S1061, performing task scheduling check on the updated target script according to the system task scheduling information to obtain a task scheduling check result.
[0064] Among them, the task scheduling inspection results include task scheduling inspection passed and task scheduling inspection failed.
[0065] In some embodiments, when the updated target script satisfies the first verification condition, the second verification condition and the third verification condition at the same time, the task scheduling verification result is determined to be the task scheduling verification passed; when the updated target script does not satisfy the first verification condition, the second verification condition and / or the third verification condition, the task scheduling verification result is determined to be the task scheduling verification failed; wherein, the first verification condition is that there exists a task in the system task scheduling information that matches the dependency source table of the updated target script; the second verification condition is that the dependent tasks corresponding to each dependency source table in the updated target script have been completed; the third verification condition is that the scheduling time of the task corresponding to the dependency source table of the updated target script is before the scheduling time of the target script.
[0066] By determining whether the updated target script satisfies the first verification condition, the second verification condition and the third verification condition at the same time, the task scheduling verification result can be accurately obtained.
[0067] In some embodiments, when the task scheduling check result is that the task scheduling check fails, script correction failure information is generated and output, so that the developer can re-enter the dependent source table configuration information according to the script correction failure information, and update the target script according to the re-entered dependent source table configuration information. If the target script correction fails according to the task scheduling check result, the target script is updated again, which greatly improves the accuracy of the target script, as well as the accuracy and stability of the target script processing task.
[0068] In some embodiments, when the task scheduling check result is that the task scheduling check fails, a script correction alarm is generated to remind the developer that the dependency correction of the target script fails, generate and display script correction failure information, and obtain the dependency source table configuration information input by the developer according to the script correction failure information; continue to perform the steps of updating the target script according to the dependency source table configuration information and checking the dependency source table of the updated target script according to the system task scheduling information, and generating the verification result of the updated target script. By re-correcting the script and checking the dependency source table of the target script, the stability of the target script can be improved.
[0069] Sub-step S1062: When the task scheduling check result is the first scheduling check result, the dependent source table configuration is checked on the updated target script to obtain the dependent source table configuration check result.
[0070] The dependent source table configuration check result includes a first configuration check result and a second configuration check result. The first configuration check result is used to indicate that the configuration check has passed, and the second configuration check result is used to indicate that the configuration check has failed.
[0071] In some embodiments, when the dependency source table of the updated target script and the first data source table have the same dependency source table, and the dependency source table of the updated target script has the same name as the same task in the system task scheduling information, the dependency source table configuration verification result is determined to be the first configuration verification result; when the dependency source table of the updated target script and the first data source table do not have the same dependency source table, and / or the dependency source table of the updated target script has different names from the same task in the system task scheduling information, the dependency source table configuration verification result is determined to be the second configuration verification result.
[0072] Sub-step S1063: When the dependent source table configuration verification result is the first configuration verification result, determine that the verification result of the updated target script is passed.
[0073] In some embodiments, when the dependent source table configuration check result is the first configuration check result, the check result of the updated target script is determined to be passed. When the dependent source table configuration check result is the task scheduling check passed, and the dependent source table configuration check result is the first configuration check result, the check result of the target script is determined to be passed, which greatly improves the efficiency and accuracy of the target script check.
[0074] In some embodiments, when the dependency source table configuration check result is the second configuration check result, a script correction alarm is generated to remind the developer that the dependency correction of the target script fails, generate and display script correction failure information, and obtain the dependency source table configuration information input by the developer according to the script correction failure information; continue to perform the steps of updating the target script according to the dependency source table configuration information and checking the dependency source table of the updated target script according to the system task scheduling information to generate the check result of the updated target script. By re-correcting the script and checking the dependency source table of the target script, the stability of the target script can be improved.
[0075] The script correction and verification method provided in the above embodiment obtains the target script to be corrected and determines the dependent keywords in the target script; determines the first data source table that has a dependency relationship with the target script according to the dependent keywords, and the first data source table includes configured dependent source table information and unconfigured dependent source table information; generates and outputs script correction indication information according to the unconfigured dependent source table information in the first data source table, and the script correction indication information is used to provide developers with a reference for correcting the target script; obtains the dependent source table configuration information input by the developer according to the script correction indication information; updates the target script according to the dependent source table configuration information, and obtains the system task scheduling information; performs dependent source table verification on the updated target script according to the system task scheduling information, and generates a verification result of the updated target script. In the present application, the unconfigured dependency source table information of the target script can be accurately determined according to the dependency keywords in the target script, and script correction instruction information is generated based on the unconfigured dependency source table information, so that the developer can input the dependency source table configuration information according to the script correction instruction information, and the target script can be accurately updated according to the dependency source table configuration information, which greatly improves the accuracy of the target script update; then, the dependency source table of the updated target script is checked according to the system task scheduling information, which effectively prevents errors in the target script and greatly improves the stability of the target script.
[0076] See also Figure 3 , Figure 3 A schematic block diagram of a script correction and verification device provided in an embodiment of the present application.
[0077] like Figure 3 As shown, the script correction and verification device 200 includes an acquisition module 210, a determination module 220, an update module 230 and a verification module 240, wherein:
[0078] The acquisition module 210 is used to acquire the target script to be corrected;
[0079] The determination module 220 is used to determine the dependent keywords in the target script;
[0080] The determination module 220 is further configured to determine, according to the dependency keyword, a first data source table having a dependency relationship with the target script, wherein the first data source table includes configured dependency source table information and unconfigured dependency source table information;
[0081] The determination module 220 is further configured to generate and output script correction instruction information according to the dependent source table information not configured in the first data source table, wherein the script correction instruction information is used to provide a reference for developers to correct the target script;
[0082] The acquisition module 210 is further used to acquire the dependent source table configuration information input by the developer according to the script correction instruction information;
[0083] The updating module 230 is used to update the target script according to the dependent source table configuration information;
[0084] The acquisition module 210 is also used to acquire system task scheduling information;
[0085] The checking module 240 is used to check the dependency source table of the updated target script according to the system task scheduling information, and generate a checking result of the updated target script.
[0086] In some embodiments, Figure 4 As shown, the inspection module 240 includes a generation module 241, a first inspection submodule 242 and a second inspection submodule 243, wherein:
[0087] The generating module 241 is used to perform task scheduling check on the updated target script according to the system task scheduling information to obtain a task scheduling check result;
[0088] The first checking submodule 242 is used to check the dependent source table configuration of the updated target script to obtain the dependent source table configuration checking result when the task scheduling checking result is that the task scheduling checking fails;
[0089] The second checking submodule 243 is further used to determine that the checking result of the updated target script is passed when the checking result of the dependent source table configuration is the first configuration checking result.
[0090] In some embodiments, the generating module 241 is further used to:
[0091] When the updated target script satisfies the first verification condition, the second verification condition and the third verification condition at the same time, determining that the task scheduling verification result is task scheduling verification passed;
[0092] In a case where the updated target script does not satisfy the first verification condition, the second verification condition and / or the third verification condition, determining that the task scheduling verification result is that the task scheduling verification has failed;
[0093] Among them, the first verification condition is that there exists a task in the system task scheduling information that matches the dependency source table of the updated target script; the second verification condition is that the dependency tasks corresponding to each dependency source table in the updated target script have been completed; the third verification condition is that the scheduling time of the task corresponding to the dependency source table of the updated target script is before the scheduling time of the target script.
[0094] In some embodiments, the first checking submodule 242 is further used to:
[0095] When the dependency source table of the updated target script and the first data source table have the same dependency source table, and the dependency source table of the updated target script has the same name as the same task in the system task scheduling information, determining that the dependency source table configuration verification result is the first configuration verification result;
[0096] When the dependency source table of the updated target script and the first data source table do not have the same dependency source table, and / or the dependency source table of the updated target script has a different name from the same task in the system task scheduling information, the dependency source table configuration verification result is determined to be the second configuration verification result.
[0097] In some embodiments, the verification module 240 is further used to:
[0098] When the task scheduling check result is that the task scheduling check fails, a script correction alarm is generated to remind the developer that the dependency correction of the target script has failed.
[0099] In some embodiments, the verification module 240 is further used to:
[0100] Generate and display script correction failure information, and obtain dependent source table configuration information input by the developer according to the script correction failure information;
[0101] Continue to execute the steps of updating the target script according to the dependent source table configuration information and checking the dependent source table of the updated target script according to the system task scheduling information, and generating a checking result of the updated target script.
[0102] In some embodiments, the acquisition module 210 is further used to:
[0103] Acquire an updated development script, and determine whether the updated development script has an updated dependent source table;
[0104] In the case that the updated development script has an updated dependent source table, the development script is determined as a target script.
[0105] It should be noted that those skilled in the art can clearly understand that for the convenience and simplicity of description, the specific working process of the above-mentioned script correction and inspection device can refer to the corresponding process in the above-mentioned script correction and inspection method embodiment, and will not be repeated here.
[0106] See also Figure 5 , Figure 5A schematic block diagram of the structure of a computer device provided in an embodiment of the present application.
[0107] like Figure 5 As shown, the computer device 300 includes a processor 302 and a memory 303 connected via a system bus 301 , wherein the memory 303 may include a storage medium and an internal memory.
[0108] The storage medium can store a computer program. The computer program includes program instructions, and when the program instructions are executed, the processor can execute any script correction and verification method.
[0109] The processor 302 is used to provide computing and control capabilities and support the operation of the entire computer device.
[0110] The internal memory provides an environment for the operation of the computer program in the storage medium. When the computer program is executed by the processor, the processor can execute any script correction and verification method.
[0111] Those skilled in the art will understand that Figure 5 The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.
[0112] It should be understood that the processor 302 may be a central processing unit (CPU), and the processor may also be other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. Among them, the general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.
[0113] In one embodiment, the processor 302 is used to run a computer program stored in the memory to implement the following steps:
[0114] Obtaining a target script to be corrected, and determining dependent keywords in the target script;
[0115] Determine, according to the dependency keyword, a first data source table having a dependency relationship with the target script, wherein the first data source table includes configured dependency source table information and unconfigured dependency source table information;
[0116] Generate and output script correction instruction information according to the dependent source table information not configured in the first data source table, wherein the script correction instruction information is used to provide a reference for developers to correct the target script;
[0117] Obtaining dependent source table configuration information input by a developer according to the script correction instruction information;
[0118] The target script is updated according to the dependent source table configuration information, and system task scheduling information is obtained;
[0119] The updated target script is checked for a dependent source table according to the system task scheduling information to generate a check result of the updated target script.
[0120] In one embodiment, when the processor 302 performs the dependent source table check on the updated target script according to the system task scheduling information and generates the check result of the updated target script, it is used to implement:
[0121] Performing task scheduling check on the updated target script according to the system task scheduling information to obtain a task scheduling check result;
[0122] When the task scheduling check result is that the task scheduling check fails, performing a dependent source table configuration check on the updated target script to obtain a dependent source table configuration check result;
[0123] In a case where the dependent source table configuration verification result is the first configuration verification result, it is determined that the verification result of the updated target script is passed.
[0124] In one embodiment, when the processor 302 performs task scheduling check on the updated target script according to the system task scheduling information and obtains the task scheduling check result, it is used to implement:
[0125] When the updated target script satisfies the first verification condition, the second verification condition and the third verification condition at the same time, determining that the task scheduling verification result is task scheduling verification passed;
[0126] In a case where the updated target script does not satisfy the first verification condition, the second verification condition and / or the third verification condition, determining that the task scheduling verification result is that the task scheduling verification has failed;
[0127] Among them, the first verification condition is that there exists a task in the system task scheduling information that matches the dependency source table of the updated target script; the second verification condition is that the dependency tasks corresponding to each dependency source table in the updated target script have been completed; the third verification condition is that the scheduling time of the task corresponding to the dependency source table of the updated target script is before the scheduling time of the target script.
[0128] In one embodiment, when the processor 302 performs a dependency source table configuration check on the updated target script and obtains a dependency source table configuration check result, it is configured to implement:
[0129] When the dependency source table of the updated target script and the first data source table have the same dependency source table, and the dependency source table of the updated target script has the same name as the same task in the system task scheduling information, determining that the dependency source table configuration verification result is the first configuration verification result;
[0130] When the dependency source table of the updated target script and the first data source table do not have the same dependency source table, and / or the dependency source table of the updated target script has a different name from the same task in the system task scheduling information, the dependency source table configuration verification result is determined to be the second configuration verification result.
[0131] In one embodiment, after performing task scheduling check on the updated target script according to the system task scheduling information and obtaining the task scheduling check result, the processor 302 is further used to implement:
[0132] When the task scheduling check result is that the task scheduling check fails, a script correction alarm is generated to remind the developer that the dependency correction of the target script has failed.
[0133] In one embodiment, after the processor 302 generates a script correction alarm to remind the developer that the dependency correction of the target script fails when the task scheduling check result is that the task scheduling check fails, it is further configured to:
[0134] Generate and display script correction failure information, and obtain dependent source table configuration information input by the developer according to the script correction failure information;
[0135] Continue to execute the steps of updating the target script according to the dependent source table configuration information and checking the dependent source table of the updated target script according to the system task scheduling information, and generating a checking result of the updated target script.
[0136] In one embodiment, when the processor 302 implements the acquisition of the target script to be corrected, it is used to implement:
[0137] Acquire an updated development script, and determine whether the updated development script has an updated dependent source table;
[0138] In the case that the updated development script has an updated dependent source table, the development script is determined as a target script.
[0139] It should be noted that technical personnel in the relevant field can clearly understand that for the convenience and brevity of description, the specific working process of the computer device described above can refer to the corresponding process in the aforementioned script correction and verification method embodiment, and will not be repeated here.
[0140] An embodiment of the present application also provides a computer-readable storage medium, on which a computer program is stored. The computer program includes program instructions. The method implemented when the program instructions are executed can refer to the various embodiments of the script correction and verification method of the present application.
[0141] The computer-readable storage medium may be an internal storage unit of the computer device described in the foregoing embodiment, such as a hard disk or memory of the computer device. The computer-readable storage medium may be non-volatile or volatile. The computer-readable storage medium may also be an external storage device of the computer device, such as a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card, a flash card (Flash Card), etc., equipped on the computer device.
[0142] Furthermore, the computer-readable storage medium may mainly include a program storage area and a data storage area, wherein the program storage area may store an operating system, an application required for at least one function, etc.; the data storage area may store data created according to the use of the blockchain node, etc.
[0143] The blockchain referred to in this invention is a new application mode of computer technologies such as distributed data storage, peer-to-peer transmission, consensus mechanism, encryption algorithm, etc. Blockchain is essentially a decentralized database, a string of data blocks generated by cryptographic methods. Each data block contains a batch of network transaction information, which is used to verify the validity of its information (anti-counterfeiting) and generate the next block. Blockchain can include the underlying blockchain platform, platform product service layer, and application service layer.
[0144] It should be understood that the terms used in this application specification are only for the purpose of describing specific embodiments and are not intended to limit the application. As used in this application specification, unless the context clearly indicates otherwise, the singular forms "a", "an" and "the" are intended to include plural forms.
[0145] It should also be understood that the term "and / or" used in the present specification refers to any combination of one or more of the associated listed items and all possible combinations, including these combinations. It should be noted that, in this article, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or system including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or system. In the absence of further restrictions, an element defined by the sentence "including a..." does not exclude the presence of other identical elements in the process, method, article or system including the element.
[0146] The serial numbers of the embodiments of the present application are for description only and do not represent the advantages and disadvantages of the embodiments. The above description is only a specific implementation mode of the present application, but the protection scope of the present application is not limited thereto. Any technician familiar with the technical field can easily think of various equivalent modifications or replacements within the technical scope disclosed in the present application, and these modifications or replacements should be included in the protection scope of the present application.
Claims
1. A script correction and checking method, characterized in that: include: Obtaining a target script to be corrected, and determining dependent keywords in the target script; Determine, according to the dependency keyword, a first data source table having a dependency relationship with the target script, wherein the first data source table includes configured dependency source table information and unconfigured dependency source table information; Generate and output script correction instruction information according to the dependent source table information not configured in the first data source table, wherein the script correction instruction information is used to provide a reference for developers to correct the target script; Obtaining dependent source table configuration information input by a developer according to the script correction instruction information; The target script is updated according to the dependent source table configuration information, and system task scheduling information is obtained; The updated target script is checked for a dependent source table according to the system task scheduling information to generate a check result of the updated target script.
2. The script correction and checking method according to claim 1, characterized in that: The checking of the dependent source table of the updated target script according to the system task scheduling information to generate the checking result of the updated target script includes: Performing task scheduling check on the updated target script according to the system task scheduling information to obtain a task scheduling check result; When the task scheduling check result is that the task scheduling check fails, performing a dependent source table configuration check on the updated target script to obtain a dependent source table configuration check result; In a case where the dependent source table configuration verification result is the first configuration verification result, it is determined that the verification result of the updated target script is passed.
3. The script correction and checking method according to claim 2, characterized in that: The step of performing task scheduling check on the updated target script according to the system task scheduling information to obtain a task scheduling check result includes: When the updated target script satisfies the first verification condition, the second verification condition and the third verification condition at the same time, determining that the task scheduling verification result is task scheduling verification passed; In a case where the updated target script does not satisfy the first verification condition, the second verification condition and / or the third verification condition, determining that the task scheduling verification result is that the task scheduling verification has failed; Among them, the first verification condition is that there exists a task in the system task scheduling information that matches the dependency source table of the updated target script; the second verification condition is that the dependency tasks corresponding to each dependency source table in the updated target script have been completed; the third verification condition is that the scheduling time of the task corresponding to the dependency source table of the updated target script is before the scheduling time of the target script.
4. The script correction and checking method according to claim 2, characterized in that: The updated target script is subjected to a dependent source table configuration check to obtain a dependent source table configuration check result, including: When the dependency source table of the updated target script and the first data source table have the same dependency source table, and the dependency source table of the updated target script has the same name as the same task in the system task scheduling information, determining that the dependency source table configuration verification result is the first configuration verification result; When the dependency source table of the updated target script and the first data source table do not have the same dependency source table, and / or the dependency source table of the updated target script has a different name from the same task in the system task scheduling information, the dependency source table configuration verification result is determined to be the second configuration verification result.
5. The script correction and checking method according to claim 2, characterized in that: After performing task scheduling check on the updated target script according to the system task scheduling information and obtaining the task scheduling check result, the method further includes: When the task scheduling check result is that the task scheduling check fails, a script correction alarm is generated to remind the developer that the dependency correction of the target script has failed.
6. The script correction and checking method according to claim 5, characterized in that: After generating a script correction alarm to remind the developer that the dependency correction of the target script has failed when the task scheduling check result is that the task scheduling check has failed, the method further includes: Generate and display script correction failure information, and obtain dependent source table configuration information input by the developer according to the script correction failure information; Continue to execute the steps of updating the target script according to the dependent source table configuration information and checking the dependent source table of the updated target script according to the system task scheduling information, and generating a checking result of the updated target script.
7. The script correction and checking method according to claim 1, characterized in that: The step of obtaining the target script to be corrected includes: Acquire an updated development script, and determine whether the updated development script has an updated dependent source table; In the case that the updated development script has an updated dependent source table, the development script is determined as a target script.
8. A script correction and inspection device, characterized in that: The script correction and verification device comprises an acquisition module, a determination module, an update module and a verification module, wherein: The acquisition module is used to acquire the target script to be corrected; The determination module is used to determine the dependent keywords in the target script; The determination module is further used to determine a first data source table having a dependency relationship with the target script according to the dependency keyword, wherein the first data source table includes configured dependency source table information and unconfigured dependency source table information; The determination module is further used to generate and output script correction instruction information according to the dependent source table information not configured in the first data source table, wherein the script correction instruction information is used to provide a reference for developers to correct the target script; The acquisition module is further used to acquire the dependent source table configuration information input by the developer according to the script correction instruction information; The update module is used to update the target script according to the dependent source table configuration information; The acquisition module is also used to acquire system task scheduling information; The checking module is used to check the dependency source table of the updated target script according to the system task scheduling information, and generate a checking result of the updated target script.
9. A computer device, characterized in that: The computer device includes a processor, a memory, and a computer program stored in the memory and executable by the processor, wherein when the computer program is executed by the processor, the steps of the script correction and checking method as described in any one of claims 1 to 7 are implemented.
10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, wherein when the computer program is executed by a processor, the steps of the script correction and verification method according to any one of claims 1 to 7 are implemented.