CN112131846A - Method and system for parameter transmission based on mapping relation, electronic device and storage medium - Google Patents
Method and system for parameter transmission based on mapping relation, electronic device and storage medium Download PDFInfo
- Publication number
- CN112131846A CN112131846A CN202010928265.3A CN202010928265A CN112131846A CN 112131846 A CN112131846 A CN 112131846A CN 202010928265 A CN202010928265 A CN 202010928265A CN 112131846 A CN112131846 A CN 112131846A
- Authority
- CN
- China
- Prior art keywords
- parameter
- work order
- input
- template
- code table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 32
- 238000013507 mapping Methods 0.000 title claims abstract description 16
- 230000005540 biological transmission Effects 0.000 title claims abstract description 15
- 238000012545 processing Methods 0.000 claims abstract description 14
- 230000008569 process Effects 0.000 claims abstract description 12
- 238000004590 computer program Methods 0.000 claims description 7
- 230000003068 static effect Effects 0.000 claims description 4
- 238000007619 statistical method Methods 0.000 claims description 3
- 238000012423 maintenance Methods 0.000 description 5
- 238000013515 script Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000007429 general method Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Stored Programmes (AREA)
Abstract
The invention discloses a method and a system for parameter transmission based on a mapping relation, an electronic device and a storage medium, belonging to the technical field of parameter processing and comprising the following steps: configuring SQL sentences, related parameter code tables and work order table templates according to business requirements and work order table samples; calling out a work order to be processed from a database, performing SQL editing on the work order, and using the input parameters in the editing process as "means; analyzing the name of an input parameter in the work order editing process based on the configuration SQL statement; according to the name of the input parameter, the input parameter is associated with the relevant parameter code table and is input into the work order table template after being associated; and resolving the parameter values of the input parameters in the work order according to the input work order table template. The parameter transmission method and system, the electronic device and the storage medium improve the work order processing efficiency.
Description
Technical Field
The invention belongs to the technical field of parameter processing, and particularly relates to a method and a system for parameter transmission based on a mapping relation, an electronic device and a storage medium.
Background
When the operation and maintenance staff process the work order, the general method is to compile a large number of script statements and Shell scripts for processing different services to analyze and process the services. In the method, when the SQL script is different from the reference, frequent modification is required, which is not beneficial to script maintenance and management.
Disclosure of Invention
In view of the foregoing problems, the present invention provides a method and system, an electronic device, and a storage medium for parameter transmission based on a mapping relationship, including:
configuring SQL sentences, related parameter code tables and work order table templates according to business requirements and work order table samples;
calling a work order to be processed from a database, performing SQL editing on the work order, and using the input parameters in the editing process as? "means;
analyzing the name of the input parameter in the work order editing process based on the configuration SQL statement;
associating the input parameters with the related parameter code table, and recording the associated input parameters into the work order table template;
and resolving the parameter values of the input parameters in the work order according to the entered work order table template.
Preferably, the step of associating the input parameter with the relevant parameter code table includes:
according to the input parameter in the work order? "the input sequence selects the parameter consistent with the input parameter name from the related parameter code table;
if the relevant parameter code table does not contain the parameter consistent with the input parameter name, adding the parameter into the relevant parameter code table;
and if the relevant parameter code table stores parameters consistent with the input parameter names, the input parameters are associated with the parameters in the relevant parameter code table in a one-to-one correspondence mode according to the input sequence.
Preferably, the step of entering the work order form template after the association is:
and each input parameter is stored in the work order form template according to the template in the work order form template, the node and the input sequence of the input parameter.
Preferably, the step of analyzing the parameter values of the input parameters in the work order according to the entered work order table template is as follows:
finding out the parameter name corresponding to the input parameter in the work order form template according to the template, the node and the input sequence of the input parameter in the work order form template;
acquiring a corresponding parameter value according to the characteristic of the parameter name;
and filling the acquired parameter values into the input parameters of the work order according to the input sequence.
Preferably, the related parameter code table is a WF _ relpaam _ DICT code table, and the code table types are classified into static parameters and dynamic parameters.
Preferably, the work order table template is a WF _ NODEINPARAM _ REL table.
The embodiment of the invention provides a system for parameter transmission based on a mapping relation, which comprises:
the SQL sentence execution module is used for acquiring the name of the input parameter according to the SQL grammar;
the relevant parameter code table determining module is used for carrying out statistical analysis on the work order data and determining relevant parameters of the work order;
the work order form template configuration module is used for configuring a work order form template;
and the main control program is used for calling the SQL statement execution module, the related parameter code table determination module and the work order table template configuration module to finish editing the work order.
An embodiment of the present invention provides a computing device, which includes at least one processing unit and at least one storage unit, where the storage unit stores a computer program, and when the program is executed by the processing unit, the processing unit is caused to execute the method described above.
An embodiment of the present invention provides a computer-readable storage medium, which stores a computer program executable by a computing device, and when the program runs on the computing device, the computer program causes the computing device to execute the method described above.
Compared with the prior art, the invention has the beneficial effects that:
by the parameter transmission method, the operability and efficiency of SQL configuration are improved, the work order processing efficiency is further improved, and the labor force of operation and maintenance personnel is liberated.
Drawings
FIG. 1 is a diagram of a hardware architecture of an electronic device according to the present invention;
FIG. 2 is a schematic block diagram of the present invention;
FIG. 3 is a schematic flow chart of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.
In the description of the present invention, it should be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc., indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings, and are only for convenience of description and simplicity of description, but do not indicate or imply that the device or element being referred to must have a particular orientation, be constructed and operated in a particular orientation, and thus, should not be construed as limiting the present invention. Furthermore, the terms "first," "second," and "third" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
In the description of the present invention, it should also be noted that, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.
Referring to fig. 1, a schematic diagram of an alternative hardware architecture of an electronic device 1 according to the present invention is shown.
In this embodiment, the electronic device 1 may include, but is not limited to, a memory 11, a processor 12, and a network interface 13, which may be communicatively connected to each other through a system bus. It is noted that fig. 1 only shows the electronic device 1 with components 11-13, but it is to be understood that not all shown components are required to be implemented, and that more or less components may be implemented instead.
The electronic device 1 may be a server, a PC (Personal Computer), a smart phone, a tablet Computer, a palm Computer, a portable Computer, or other terminal equipment. The server may be a rack server, a blade server, a tower server, a cabinet server, or other computing devices, may be an independent server, or may be a server cluster composed of a plurality of servers.
The memory 11 includes at least one type of readable storage medium including a flash memory, a hard disk, a multimedia card, a card type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a Programmable Read Only Memory (PROM), a magnetic memory, a magnetic disk, an optical disk, etc. In some embodiments, the storage 11 may be an internal storage unit of the electronic device 1, such as a hard disk or a memory of the electronic device 1. In other embodiments, the memory 11 may also be an external storage device of the electronic apparatus 1, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), or the like provided on the electronic apparatus 1. Of course, the memory 11 may also comprise both an internal memory unit of the electronic apparatus 1 and an external memory device thereof. In this embodiment, the memory 11 is generally used for storing an operating system and various application software installed in the electronic device 1, such as program codes of the Hive table building system 200. Furthermore, the memory 11 may also be used to temporarily store various types of data that have been output or are to be output.
The processor 12 may be a Central Processing Unit (CPU), controller, microcontroller, microprocessor, or other data Processing chip in some embodiments. The processor 12 is typically used to control the overall operation of the electronic device 1. In this embodiment, the processor 12 is configured to run the program codes or process data stored in the memory 11, for example, run the system 2 that performs parameter transmission based on a mapping relationship.
The network interface 13 may comprise a wireless network interface or a wired network interface, and the network interface 13 is generally used for establishing a communication connection between the electronic apparatus 1 and other electronic devices.
The hardware structure and functions of the related devices of the present invention have been described in detail so far. Hereinafter, embodiments of the present invention will be proposed based on the above description.
First, the present invention provides a system 2 for performing parameter transmission based on mapping relationship.
Referring to fig. 2, the referencing system in this embodiment includes a series of computer program instructions stored in memory 11, which when executed by processor 12, implement the referencing operation of the present invention. In some embodiments, the reference system 2 may be divided into one or more modules based on the particular operations implemented by the portions of the computer program instructions. For example, in fig. 2 includes:
the SQL sentence execution module 21 is used for acquiring the name of the input parameter according to the SQL grammar;
the relevant parameter code table determining module 22 is used for performing statistical analysis on the work order data to determine relevant parameters of the work order;
the work order form template configuration module 23 is used for configuring a work order form template;
and the main control program 24 is used for calling the SQL statement execution module, the related parameter code table determination module and the work order table template configuration module to finish editing the work order.
In addition, the invention also provides a method for carrying out parameter transmission based on the mapping relation.
Referring to fig. 3, a schematic flow chart of the present invention includes:
configuring SQL sentences, related parameter code tables and work order table templates according to business requirements and work order table samples;
specifically, the related parameter code table is a WF _ relaram _ DICT code table, the code table types are classified into static parameters and dynamic parameters, and the work order table template is a WF _ nodeinaram _ REL table.
Calling out a work order to be processed from a database, performing SQL editing on the work order, and using the input parameters in the editing process as? "means;
specifically, according to the input parameter "? "the input sequence selects the parameter consistent with the input parameter name from the related parameter code table;
if the relevant parameter code table does not contain the parameter consistent with the input parameter name, adding the parameter into the relevant parameter code table;
and if the relevant parameter code table stores parameters consistent with the input parameter names, the input parameters are associated with the parameters in the relevant parameter code table in a one-to-one correspondence mode according to the input sequence.
Analyzing the name of an input parameter in the work order editing process based on the configuration SQL statement;
specifically, each input parameter is stored in the work order form template according to the template, the node and the input sequence of the input parameter in the work order form template.
According to the name of the input parameter, the input parameter is associated with the relevant parameter code table and is input into the work order table template after being associated;
and resolving the parameter values of the input parameters in the work order according to the input work order table template.
Specifically, the parameter name of the corresponding input parameter is found out in the work order form template according to the input sequence of the template, the node and the input parameter in the work order form template;
acquiring a corresponding parameter value according to the characteristics of the parameter name;
and filling the acquired parameter values into the input parameters of the work order according to the input sequence.
The method for transmitting the parameters based on the mapping relation obviously improves the operability and efficiency of SQL configuration, and the operation and maintenance personnel can flexibly compile SQL to process the work order, thereby improving the work order processing efficiency and liberating the labor force of the operation and maintenance personnel.
The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, and various modifications and changes will occur to those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (9)
1. A method for performing parameter transmission based on a mapping relation is characterized by comprising the following steps:
configuring SQL sentences, related parameter code tables and work order table templates according to business requirements and work order table samples;
calling a work order to be processed from a database, performing SQL editing on the work order, and using the input parameters in the editing process as? "means;
analyzing the name of the input parameter in the work order editing process based on the configuration SQL statement;
according to the name of the input parameter, associating the input parameter with the related parameter code table, and recording the associated input parameter into the work order table template;
and resolving the parameter values of the input parameters in the work order according to the entered work order table template.
2. The method for performing parameter transmission based on mapping relationship according to claim 1, wherein the step of associating the input parameter with the related parameter code table comprises:
according to the input parameter in the work order? "the input sequence selects the parameter consistent with the input parameter name from the related parameter code table;
if the relevant parameter code table does not contain the parameter consistent with the input parameter name, adding the parameter into the relevant parameter code table;
and if the relevant parameter code table stores parameters consistent with the input parameter names, the input parameters are associated with the parameters in the relevant parameter code table in a one-to-one correspondence mode according to the input sequence.
3. The method for making reference to based on mapping relation according to claim 2, wherein the step of entering the work order form template after associating is:
and each input parameter is stored in the work order form template according to the template in the work order form template, the node and the input sequence of the input parameter.
4. The method for parameter transmission based on mapping relation according to claim 3, wherein the step of resolving the parameter value of the input parameter in the work order according to the work order table template after entry is as follows:
finding out the parameter name corresponding to the input parameter in the work order form template according to the template, the node and the input sequence of the input parameter in the work order form template;
acquiring a corresponding parameter value according to the characteristic of the parameter name;
and filling the acquired parameter values into the input parameters of the work order according to the input sequence.
5. The method for performing parameter propagation based on mapping relationship of claim 1, wherein the related parameter code table is a WF _ relpaam _ DICT code table, and the code table types are classified into static parameters and dynamic parameters.
6. The method for referencing according to claim 1, wherein said worksheet table template is a WF _ nodeinaram _ REL table.
7. A system for performing parameter transmission based on mapping relationship, comprising:
the SQL sentence execution module is used for acquiring the name of the input parameter according to the SQL grammar;
the relevant parameter code table determining module is used for carrying out statistical analysis on the work order data and determining relevant parameters of the work order;
the work order form template configuration module is used for configuring a work order form template;
and the main control program is used for calling the SQL statement execution module, the related parameter code table determination module and the work order table template configuration module to finish editing the work order.
8. An electronic device, comprising at least one processing unit and at least one memory unit, wherein the memory unit stores a computer program that, when executed by the processing unit, causes the processing unit to perform the method of any of claims 1 to 6.
9. A storage medium storing a computer program executable by a computing device, the program, when run on the computing device, causing the computing device to perform the method of any of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010928265.3A CN112131846A (en) | 2020-09-07 | 2020-09-07 | Method and system for parameter transmission based on mapping relation, electronic device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010928265.3A CN112131846A (en) | 2020-09-07 | 2020-09-07 | Method and system for parameter transmission based on mapping relation, electronic device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112131846A true CN112131846A (en) | 2020-12-25 |
Family
ID=73848306
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010928265.3A Pending CN112131846A (en) | 2020-09-07 | 2020-09-07 | Method and system for parameter transmission based on mapping relation, electronic device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112131846A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104346334A (en) * | 2013-07-23 | 2015-02-11 | 上海化工宝电子商务有限公司 | Remote visual interface database system |
| CN105117441A (en) * | 2015-08-11 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Data work order processing method and system |
| CN107480280A (en) * | 2017-08-22 | 2017-12-15 | 金蝶软件（中国）有限公司 | The method and relevant device of a kind of data processing |
| CN108255967A (en) * | 2017-12-26 | 2018-07-06 | 平安科技（深圳）有限公司 | Call method, device, storage medium and the terminal of storing process |
-
2020
- 2020-09-07 CN CN202010928265.3A patent/CN112131846A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104346334A (en) * | 2013-07-23 | 2015-02-11 | 上海化工宝电子商务有限公司 | Remote visual interface database system |
| CN105117441A (en) * | 2015-08-11 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Data work order processing method and system |
| CN107480280A (en) * | 2017-08-22 | 2017-12-15 | 金蝶软件（中国）有限公司 | The method and relevant device of a kind of data processing |
| CN108255967A (en) * | 2017-12-26 | 2018-07-06 | 平安科技（深圳）有限公司 | Call method, device, storage medium and the terminal of storing process |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107844634B (en) | Modeling method of multivariate general model platform, electronic equipment and computer readable storage medium | |
| CN108427705B (en) | Electronic device, distributed system log query method and storage medium | |
| CN110795455B (en) | Dependency analysis method, electronic device, computer apparatus, and readable storage medium | |
| CN110704521A (en) | Interface data access method and system | |
| CN110928802A (en) | Test method, device, equipment and storage medium based on automatic generation of case | |
| CN111866016A (en) | Log analysis method and system | |
| CN111737227B (en) | Data modification method and system | |
| CN112636957A (en) | Early warning method and device based on log, server and storage medium | |
| CN110990390A (en) | Data cooperative processing method and device, computer equipment and storage medium | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| CN112631924A (en) | Automatic testing method and device, computer equipment and storage medium | |
| CN112328631A (en) | Production fault analysis method and device, electronic equipment and storage medium | |
| CN112860706A (en) | Service processing method, device, equipment and storage medium | |
| CN115794437A (en) | Calling method and device of microservice, computer equipment and storage medium | |
| CN111367982A (en) | Method and device for importing TRIRIGA basic data, computer equipment and storage medium | |
| CN110647564A (en) | Hive table establishing method, electronic device and computer readable storage medium | |
| CN110866007B (en) | Information management method, system and computer equipment for big data application and table | |
| CN116074183B (en) | C3 timeout analysis method, device and equipment based on rule engine | |
| CN112131846A (en) | Method and system for parameter transmission based on mapping relation, electronic device and storage medium | |
| CN116450723A (en) | Data extraction method, device, computer equipment and storage medium | |
| CN116204428A (en) | Test case generation method and device | |
| CN112751976B (en) | Agent association method, system, equipment and storage medium based on authentication log | |
| CN114637672A (en) | Automatic data testing method and device, computer equipment and storage medium | |
| CN113868138A (en) | Method, system, equipment and storage medium for acquiring test data | |
| CN108959508B (en) | SQL data generation method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |