WO2021217846A1

WO2021217846A1 - Interface data processing method and apparatus, and computer device and storage medium

Info

Publication number: WO2021217846A1
Application number: PCT/CN2020/098683
Authority: WO
Inventors: 郑光凯
Original assignee: 平安国际智慧城市科技股份有限公司
Priority date: 2020-04-28
Filing date: 2020-06-29
Publication date: 2021-11-04
Also published as: CN111581271A

Abstract

The present application relates to a data warehouse in big data. Provided are an interface data processing method and apparatus, a computer device, and a storage medium. The method comprises: acquiring an interface identifier and a parameter identification statement; parsing the parameter identification statement according to a preset target parsing rule script, so as to obtain an interface request parameter identifier and an interface return parameter identifier; acquiring a corresponding request parameter statement according to the interface request parameter identifier, parsing the request parameter statement to obtain a data table field corresponding to the request parameter identifier, and generating a corresponding request parameter attribute by using the data table field; acquiring a corresponding return parameter statement according to the interface return parameter identifier, parsing the return parameter statement to obtain a data table field corresponding to the return parameter identifier, and generating a corresponding return parameter attribute by using the data table field; and generating, according to the request parameter attribute and the return parameter attribute, a parameter list corresponding to the interface identifier, and storing the interface identifier and the parameter list in an associative manner. By utilizing the present method, the interface parameter configuration efficiency can be improved.

Description

Interface data processing method, device, computer equipment and storage medium

Cross-references to related applications

This application claims the priority of the Chinese patent application filed with the Chinese Patent Office on April 28, 2020, the application number is 2020103494884, and the application title is "Interface parameter determination method, device, computer equipment and storage medium", the entire content of which is incorporated by reference Incorporated in this application.

Technical field

This application relates to an interface data processing method, device, computer equipment and storage medium.

Background technique

With the development of Internet technology, the development of interfaces is usually involved in the development of Internet projects, and each interface needs to be configured with parameters. When the parameter configuration is completed, the interface can be used, and the data can be transferred by using the interface.

However, the inventor realized that when a complex project is encountered, multiple projects need to be carried out at the same time. Each project needs to be configured with multiple interfaces, and each interface has different parameters, resulting in low efficiency in the configuration of interface parameters, thereby affecting The use of interfaces reduces the efficiency of data transfer between interfaces.

Summary of the invention

According to various embodiments disclosed in the present application, an interface data processing method, device, computer equipment, and storage medium are provided.

An interface data processing method, the method includes:

Receive interface parameter determination instructions, and obtain interface identification and parameter identification sentences according to the parameter determination instructions;

Analyze the parameter identification statement according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier;

Obtain the corresponding request parameter statement according to the interface request parameter identifier, parse the request parameter statement, obtain the data table field corresponding to the request parameter identifier, and use the data table field to generate the corresponding request parameter attribute;

Obtain the corresponding return parameter statement according to the interface return parameter identifier, parse the return parameter statement, obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute; and

According to the request parameter attribute and the return parameter attribute, a parameter list corresponding to the interface identifier is generated, and the interface identifier and the parameter list are associated and saved.

An interface data processing device, the device comprising:

The sentence acquisition module is used to receive interface parameter determination instructions, and acquire interface identification and parameter identification sentences according to the parameter determination instructions;

The parsing module is used to parse the parameter recognition statement according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier;

The attribute generation module is used to obtain the corresponding request parameter statement according to the interface request parameter identification, parse the request parameter statement, and obtain the data table field corresponding to the request parameter identification, and use the data table field to generate the corresponding request parameter attribute; obtain according to the interface return parameter identification The corresponding return parameter statement, parse the return parameter statement, obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute; and

The parameter generation module is used to generate a parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and store the interface identifier in association with the parameter list.

A computer device, including a memory and one or more processors, the memory stores computer readable instructions, and when the computer readable instructions are executed by the processor, the one or more processors execute The following steps:

One or more computer-readable storage media storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors perform the following steps:

The above-mentioned interface data processing method, device, computer equipment and storage medium receive the interface parameter determination instruction, and obtain the interface identification and parameter identification sentence according to the parameter determination instruction; the parameter identification sentence is parsed according to the preset target parsing rule script to obtain the interface request parameter identification And the interface returns the parameter identification; obtain the corresponding request parameter statement according to the interface request parameter identification, parse the request parameter statement, obtain the data table field corresponding to the request parameter identification, use the data table field to generate the corresponding request parameter attribute; obtain according to the interface return parameter identification Corresponding return parameter statement, parse the return parameter statement, get the data table field corresponding to the return parameter identifier, use the data table field to generate the corresponding return parameter attribute; generate the parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and set the interface The identification is saved in association with the parameter list. The parameter identification is obtained by using the parameter identification statement, and the corresponding parameter statement is used to generate the parameter attribute according to the parameter identification. The parameter list is obtained according to the parameter attribute, that is, the parameter identification statement is used to configure the interface parameters, which improves the interface parameters. The efficiency of configuration enables faster generation and use of interfaces, thereby improving the efficiency of data transfer between interfaces.

The details of one or more embodiments of the present application are set forth in the following drawings and description. Other features and advantages of this application will become apparent from the description, drawings and claims.

Description of the drawings

In order to more clearly describe the technical solutions in the embodiments of the present application, the following will briefly introduce the drawings needed in the embodiments. Obviously, the drawings in the following description are only some embodiments of the present application. A person of ordinary skill in the art can obtain other drawings based on these drawings without creative work.

Fig. 1 is an application environment diagram of the interface data processing method according to one or more embodiments;

FIG. 2 is a schematic flowchart of an interface data processing method according to one or more embodiments;

FIG. 3 is a schematic diagram of a flow of generating a script according to one or more embodiments;

FIG. 4 is a schematic diagram of a process of parsing a parameter recognition sentence according to one or more embodiments;

FIG. 5 is a schematic diagram of a flow of reading parameter identifiers according to one or more embodiments;

Fig. 6 is a schematic diagram of a process of matching parameter names according to one or more embodiments;

FIG. 7 is a schematic diagram of a flow of generating an interface parameter document according to one or more embodiments;

FIG. 8 is a schematic flowchart of an interface data processing method according to one or more specific embodiments;

Figure 9 is a block diagram of a device for determining interface parameters according to one or more embodiments;

Figure 10 is a block diagram of a computer device according to one or more embodiments.

Detailed ways

In order to make the technical solutions and advantages of the present application clearer, the following further describes the present application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application, and are not used to limit the present application.

The interface data processing method provided in this application can be applied to the application environment as shown in FIG. 1. The terminal 102 communicates with the server 104 through the network. The terminal 102 receives the interface parameter determination instruction, and obtains the interface identification and parameter identification sentence according to the parameter determination instruction; the terminal 102 parses the parameter identification sentence according to the preset target parsing rule script to obtain the interface request parameter identification and the interface return parameter identification; the terminal 102 according to the interface request The parameter identification obtains the corresponding request parameter statement, parses the request parameter statement, and obtains the data table field corresponding to the request parameter identification, and uses the data table field to generate the corresponding request parameter attribute; the terminal 102 obtains the corresponding return parameter statement according to the interface return parameter identification, and parses Return parameter statement to obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute; the terminal 102 generates the parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and associates the interface identifier with the parameter list For saving, the terminal 102 may upload the saved interface identifier and the corresponding parameter list to the server 104 for saving. The terminal 102 may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices. The server 104 may be implemented by an independent server or a server cluster composed of multiple servers.

In one of the embodiments, as shown in FIG. 2, an interface data processing method is provided. Taking the method applied to the server in FIG. 1 as an example for description, the method includes the following steps:

S202: Receive an interface parameter determination instruction, and obtain an interface identifier and a parameter identification statement according to the parameter determination instruction.

The interface identifier is used to uniquely identify the interface, which can be a name, a number, and so on. Interface refers to the reference type that defines the contract. Other types implement interfaces to ensure that they support certain operations. The interface specifies the members that must be provided by the class or other interfaces that implement it. The parameter identification statement refers to the SQL (Structured Query Language) statement of the database, which is used to automatically configure the parameters of the interface. Different databases have different SQL statements, such as mysql, oracle, DM, Hive, SQLSever, and postgresql.

Specifically, the terminal receives the developer's interface parameter determination instruction, and obtains the interface identifier and the parameter identification sentence corresponding to the interface identifier from the command line interface according to the parameter determination instruction. Among them, the command line interface refers to the interface used to receive the parameter determination command, and the developer can input the interface identification to be configured and the parameter identification statement corresponding to the interface identification through the command line interface.

S204: Parse the parameter identification sentence according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier.

Preset target parsing rule scripts Pre-set scripts that can uniformly parse SQL statements of different databases. The interface request parameter identifier and the interface return parameter identifier are used to uniquely identify the type of the interface parameter, including the interface request parameter and the interface return parameter. That is, different characters can be used to distinguish whether the parameter to be configured is an interface request parameter or an interface return parameter. For example, ${@param} is used to identify interface request parameters. #{@param} is used to identify interface return parameters.

Specifically, the terminal uses a preset target parsing rule script to parse the parameter identification sentence to obtain the interface request parameter identifier and the interface return parameter identifier.

S206: Obtain a corresponding request parameter statement according to the interface request parameter identifier, parse the request parameter statement to obtain a data table field corresponding to the request parameter identifier, and use the data table field to generate a corresponding request parameter attribute.

The request parameter statement refers to the SQL statement required to configure the request parameter. Different types of interfaces have different request parameter statements, that is, each interface request parameter identifier has a corresponding request parameter statement, and the interface return parameter identifier has a corresponding return parameter. Statement. Data table fields refer to the fields included in the parameter list. The request parameter attribute refers to the attribute of the request parameter in the interface obtained according to the data field, which can include: parameter name, parameter type, parameter length, default value, parameter transmission rules, and so on.

Specifically, the terminal obtains the corresponding request parameter statement according to the interface request parameter identifier, and the request parameter statement may be input through a command line interface. Parse the request parameter statement to obtain the data table field corresponding to the request parameter identifier, and use the data table field to generate the corresponding request parameter attribute. In an embodiment, it is also possible to obtain information such as configuration conditions corresponding to the request parameters, index, primary key, and whether to desensitize, etc., by parsing the request parameter statement.

S208: Obtain a corresponding return parameter statement according to the interface return parameter identifier, parse the return parameter statement to obtain a data table field corresponding to the return parameter identifier, and use the data table field to generate a corresponding return parameter attribute.

The return parameter statement refers to the SQL statement required to configure the return parameter. Among them, different types of interfaces have different return parameter statements, that is, each interface return parameter identifier has a corresponding return parameter statement. Data table fields refer to the fields included in the parameter list. The return parameter attribute refers to the attribute of the return parameter in the interface obtained according to the data field, which can include: parameter name, parameter type, parameter length, default value, whether to output, etc.

Specifically, the terminal obtains a corresponding return parameter statement according to the interface return parameter identifier, and the return parameter statement is a SQL statement input through a command line interface. You can use the preset parsing script to parse the return parameter statement to obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute. In one embodiment, it is also possible to obtain information such as the configuration condition corresponding to the returned parameter, index, primary key, whether desensitization, etc., by parsing the return parameter statement.

S210: Generate a parameter list corresponding to the interface identifier according to the request parameter attribute and the returned parameter attribute, and store the interface identifier in association with the parameter list.

The parameter list refers to a list that saves the configured interface parameters.

Specifically, the terminal generates a parameter list corresponding to the interface identifier according to the request parameter attribute and the returned parameter attribute, and stores the interface identifier in association with the parameter list.

In the above interface data processing method, by receiving the interface parameter determination instruction, the interface identification and the parameter identification statement are obtained according to the parameter identification instruction; the parameter identification statement is parsed according to the preset target parsing rule script to obtain the interface request parameter identification and the interface return parameter identification; Obtain the corresponding request parameter statement according to the interface request parameter identification, parse the request parameter statement, and obtain the data table field corresponding to the request parameter identification, use the data table field to generate the corresponding request parameter attribute; obtain the corresponding return parameter statement according to the interface return parameter identification, Analyze the return parameter statement to obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute; generate the parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and save the interface identifier and the parameter list associatively , Obtain the parameter identification by using the parameter identification statement, use the corresponding parameter statement to generate the parameter attribute according to the parameter identification, and obtain the parameter list according to the parameter attribute, that is, use the parameter identification statement to configure the interface parameters, which improves the efficiency of interface parameter configuration and enables Generate and use interfaces faster, thereby improving the efficiency of data transfer between interfaces.

In one of the embodiments, parallel threads can be enabled to determine interface parameters for multiple interfaces at the same time. By using parallel threads, the running memory resources of the terminal are rationally utilized, and efficiency is further improved.

In one of the embodiments, as shown in FIG. 3, before step S202, that is, before receiving the interface parameter determination instruction, and before obtaining the interface identification and parameter identification sentence according to the parameter determination instruction, the method further includes the following steps:

S302: Obtain each database parameter parsing rule, and establish a target parsing rule according to each database parameter parsing rule.

Database parameter parsing rules refer to the rules set by the database for parsing SQL statements.

Specifically, the terminal obtains each database parameter parsing rule, and unifies each database parameter parsing rule, for example, uniformly uses the int integer type to parse the int parameter type. A unified database parameter parsing rule is obtained, that is, a target parsing rule is obtained.

S304: Generate a target parsing rule script according to the target parsing rule, and deploy the target parsing rule script.

Specifically, the terminal writes the target parsing rule into a target parsing rule script using a scripting language, and deploys the target parsing rule script for use.

In the above embodiment, by unifying the analysis rules of each database, the target analysis rules are established, so that the parameter recognition sentence can be parsed more conveniently, and the efficiency of parameter configuration is improved.

In one of the embodiments, as shown in FIG. 4, step S204, that is, parsing the parameter recognition sentence according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier, includes the steps:

S402: Determine the database type corresponding to the parameter identification sentence.

S404: Obtain the corresponding regular expression according to the database type, and use the regular expression to parse the parameter identification sentence to obtain the interface request parameter identifier and the interface return parameter identifier.

The database type refers to the type of database corresponding to the syntax of the parameter recognition statement. The database type includes mysql database, oracle database, DM database, Hive database, SQLSever database, and postgresql database. Regular expression is a kind of logical formula for string manipulation. It uses some pre-defined specific characters and the combination of these specific characters to form a "rule string". This "rule string" is used to express the pair of characters. A kind of filtering logic for strings.

Specifically, the terminal recognizes the corresponding database type according to the parameter recognition sentence, and the syntax of the sentence of different databases is different, and the corresponding database type can be determined according to the characteristics of the syntax. Then, the corresponding parameter identification sentence is parsed according to the regular expression corresponding to the set database type, and the interface request parameter identifier and the interface return parameter identifier are obtained.

In the above embodiment, by using regular expressions to parse the parameter recognition sentence, the accuracy of the analysis can be improved.

In one of the embodiments, as shown in FIG. 5, step S204, which is to parse the parameter recognition sentence according to the preset target parsing rule script, to obtain the interface request parameter identifier and the interface return parameter identifier, including:

S502: Use the preset target parsing rule script to determine the target identification character from the parameter recognition sentence.

S504: Determine the position of the interface request parameter identifier and the interface return parameter identifier in the parameter identification sentence according to the target identifier character, and read the interface request parameter identifier and the interface return parameter identifier from the position.

The target identification character refers to the character set in the parameter recognition sentence in advance, and the character is used to indicate the position of the interface request parameter identification and the interface return parameter identification. For example, the position of the interface request parameter identification and the interface return parameter identification may be after the target identification character. The interface request parameter identifier and the interface return parameter identifier respectively have corresponding target identification characters. For example, the character corresponding to the interface request parameter identifier can be ${@param}. The character corresponding to the interface return parameter identifier can be #{#param}.

Specifically, the terminal uses the preset target parsing rule script to parse the parameter recognition sentence, and when the target identification character is parsed, it obtains the position of the interface request parameter identifier and the interface return parameter identifier in the parameter recognition sentence, from the corresponding position The interface request parameter identifier and the interface return parameter identifier are read.

In one of the embodiments, the parameter identification statement may also include a request parameter statement and a return parameter statement. That is, the position of the request parameter statement and the return parameter statement in the parameter identification statement can also be determined according to the target identification character, and the request parameter statement and the return parameter statement can be read according to the position.

In the above embodiment, by using target identification characters to confirm the position of the interface request parameter identification and the interface return parameter identification, the interface request parameter identification and the interface return parameter identification can be obtained more quickly, and the efficiency of parsing the parameter identification statement is improved. .

In one of the embodiments, as shown in FIG. 6, after step S210, that is, after generating a parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and after associating and saving the interface identifier with the parameter list, the method further includes the following steps:

S602: Obtain the parameter name corresponding to the constant parameter in the parameter list, and match the parameter name corresponding to the constant parameter with the existing parameter name.

S604: When the matches are consistent, the target parameter name is obtained, and the target parameter name is used as the parameter name corresponding to the constant parameter.

The parameter name refers to the name corresponding to the constant parameter. Characters can be used as the name of the parameter. For example, the parameter name is NameId. The existing parameter name refers to the names of all parameters in the parameter list except the constant parameter.

Specifically, the terminal obtains the parameter name corresponding to the constant parameter in the acquired parameter list, and matches the parameter name corresponding to the constant parameter with the existing parameter name, that is, judges whether the parameter name is consistent with the existing parameter name, and when there is a consistent parameter name, When there is a parameter name, it means that the parameter name corresponding to the constant parameter does not meet the requirements and needs to be updated. At this time, the target parameter name will be obtained, that is, the updated parameter name corresponding to the constant parameter, and the target parameter name will be used as the constant parameter. The parameter name.

In the above embodiment, when the parameter name corresponding to the constant parameter is consistent with the existing parameter name, the target parameter name is used as the parameter name corresponding to the constant parameter, which avoids conflicts between interface parameter names and improves the accuracy of parameter configuration .

In one of the embodiments, as shown in FIG. 7, after step S210, after generating a parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and after associating and saving the interface identifier with the parameter list, the method further includes:

S702: Obtain a parameter list and an interface parameter document template corresponding to each interface identifier;

S704: Use the interface parameter document template and the parameter list corresponding to each interface identifier to generate an interface parameter document, and save the interface parameter document.

The interface parameter document template is a preset template for generating interface parameter documents.

Specifically, the terminal obtains a parameter list corresponding to each interface identifier and a preset interface parameter document template, writes the parameter list into the interface parameter document template, obtains the interface parameter document, and saves the interface parameter document. In one of the embodiments, the interface parameter file can be uploaded to the server for sharing.

In the above embodiment, the parameter list corresponding to each interface can be generated and saved as a parameter file, which is convenient for subsequent use.

In a specific embodiment, the interface data processing method is applied to the interface generation platform, as shown in FIG. 8, which specifically includes:

By unifying the parameter parsing rules of databases such as mysql, oracle, DM, Hive, SQLSever, and postgresql, a unified parsing rule is established, and SQL parsing scripts are generated according to the unified parsing rule. When the receiving interface parameter determination instruction is received, the interface identification and parameter identification statement are obtained according to the parameter identification instruction; the SQL parsing script is used to parse the parameter identification statement to obtain the interface request parameter identification and the interface return parameter identification. Obtain the corresponding request parameter statement according to the interface request parameter identifier, parse the request parameter statement, obtain the data table field corresponding to the request parameter identifier, and use the data table field to generate the corresponding request parameter attribute. Obtain the corresponding return parameter statement according to the interface return parameter identifier, parse the return parameter statement, obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute. Verify the consistency between the parameter name of the constant parameter in the return parameter and the existing parameter name, and verify the consistency between the parameter name of the constant parameter in the request parameter and the existing parameter name. When the verification is passed, the return parameter is The parameter name of the constant parameter in the parameter is inconsistent with the existing parameter name, and the parameter name of the constant parameter in the request parameter is inconsistent with the existing parameter name. At this point, the request parameter attributes including parameter name, parameter alias, parameter type, and parameter passing rules are obtained, and the return parameter attributes include parameter name, parameter alias, parameter type, and so on. Then, a parameter list corresponding to the interface identifier is generated, and the interface identifier and the parameter list are associated and saved.

It should be understood that although the various steps in the flowcharts of FIGS. 2-7 are displayed in sequence as indicated by the arrows, these steps are not necessarily executed in sequence in the order indicated by the arrows. Unless specifically stated in this article, the execution of these steps is not strictly limited in order, and these steps can be executed in other orders. Moreover, at least part of the steps in Figures 2-7 can include multiple steps or multiple stages. These steps or stages are not necessarily executed at the same time, but can be executed at different times. The execution of these steps or stages The sequence is not necessarily performed sequentially, but may be performed alternately or alternately with other steps or at least a part of the steps or stages in other steps.

In one of the embodiments, as shown in FIG. 9, an interface parameter determination device 900 is provided, which includes: a sentence acquisition module 902, a parsing module 904, an attribute generation module 906, and a parameter generation module 908, wherein:

The sentence acquisition module 902 is configured to receive an interface parameter determination instruction, and acquire the interface identification and parameter identification sentence according to the parameter determination instruction;

The parsing module 904 is configured to parse the parameter identification statement according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier;

The attribute generation module 906 is used to obtain the corresponding request parameter statement according to the interface request parameter identifier, parse the request parameter statement, and obtain the data table field corresponding to the request parameter identifier, and use the data table field to generate the corresponding request parameter attribute; return the parameter identifier according to the interface Obtain the corresponding return parameter statement, parse the return parameter statement, obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute;

The parameter generation module 908 is configured to generate a parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and store the interface identifier in association with the parameter list.

In one of the embodiments, the interface parameter determining device 900 further includes:

The rule establishment module is used to obtain the parsing rules of each database parameter, and establish target parsing rules according to the parsing rules of each database parameter;

The script generation module is used to generate target parsing rule scripts according to target parsing rules, and deploy target parsing rule scripts.

In one of the embodiments, the parsing module 904 is also used to determine the database type corresponding to the parameter recognition sentence; obtain the corresponding regular expression according to the database type, use the regular expression to parse the parameter recognition sentence, and obtain the interface request parameter identifier and the interface return parameter Logo.

In one of the embodiments, the parsing module 904 is further configured to use the preset target parsing rule script to determine the target identification character from the parameter recognition statement; determine the interface request parameter identification and the interface return parameter identification in the parameter identification statement according to the target identification character Location, read the interface request parameter identification and the interface return parameter identification from the location.

The constant verification module is used to obtain the parameter name corresponding to the constant parameter in the parameter list, and match the parameter name corresponding to the constant parameter with the existing parameter name; when the match is consistent, obtain the target parameter name, and use the target parameter name as the constant parameter The corresponding parameter name.

The document generation module is used to obtain the parameter list corresponding to each interface identifier and the interface parameter document template; use the interface parameter document template and the parameter list corresponding to each interface identifier to generate the interface parameter document, and save the interface parameter document.

For the specific limitation of the device for determining interface parameters, please refer to the above limitation on the interface data processing method, which will not be repeated here. Each module in the above interface parameter determination device can be implemented in whole or in part by software, hardware and a combination thereof. The above-mentioned modules may be embedded in the form of hardware or independent of the processor in the computer equipment, or may be stored in the memory of the computer equipment in the form of software, so that the processor can call and execute the operations corresponding to the above-mentioned modules.

In one of the embodiments, a computer device is provided. The computer device may be a terminal, and its internal structure diagram may be as shown in FIG. 9. The computer equipment includes a processor, a memory, a communication interface, a display screen and an input device connected through a system bus. Among them, the processor of the computer device is used to provide calculation and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and computer readable instructions. The internal memory provides an environment for the operation of the operating system and computer-readable instructions in the non-volatile storage medium. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner can be implemented through WIFI, an operator's network, NFC (near field communication) or other technologies. The computer readable instruction is executed by the processor to realize an interface data processing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, or it can be a button, trackball or touch pad set on the housing of the computer equipment , It can also be an external keyboard, touchpad, or mouse.

Those skilled in the art can understand that the structure shown in FIG. 9 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 Including more or fewer parts than shown in the figure, or combining some parts, or having a different arrangement of parts.

A computer device, including a memory and one or more processors, in which computer readable instructions are stored. When the computer readable instructions are executed by the processor, one or more processors are caused to perform the following steps: receiving an interface parameter determination instruction , Obtain the interface identification and parameter identification statement according to the parameter determination instruction; parse the parameter identification statement according to the preset target analysis rule script to obtain the interface request parameter identification and the interface return parameter identification; obtain the corresponding request parameter statement according to the interface request parameter identification, and parse the request Parameter statement, obtain the data table field corresponding to the request parameter identifier, use the data table field to generate the corresponding request parameter attribute; obtain the corresponding return parameter statement according to the interface return parameter identifier, parse the return parameter statement, and obtain the data table field corresponding to the return parameter identifier , Use the data table fields to generate the corresponding return parameter attributes; generate the parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and save the interface identifier and the parameter list in association.

In one of the embodiments, the processor further implements the following steps when executing the computer-readable instructions: acquiring each database parameter parsing rule, establishing a target parsing rule according to each database parameter parsing rule; generating a target parsing rule script according to the target parsing rule, and deploying the target Parse the rule script.

In one of the embodiments, the processor further implements the following steps when executing the computer-readable instructions: determining the database type corresponding to the parameter recognition sentence; obtaining the corresponding regular expression according to the database type, using the regular expression to parse the parameter recognition sentence, and obtaining the interface Request parameter identification and interface return parameter identification.

In one of the embodiments, the processor further implements the following steps when executing the computer-readable instruction: using the preset target parsing rule script to determine the target identification character from the parameter recognition sentence; and determining the interface request parameter identification and the interface return parameter according to the target identification character Identify the position in the parameter identification statement, read the interface request parameter identifier and the interface return parameter identifier from the position.

In one of the embodiments, the processor further implements the following steps when executing the computer-readable instruction: obtaining the parameter name corresponding to the constant parameter in the parameter list, and matching the parameter name corresponding to the constant parameter with the existing parameter name; when the match is consistent When, get the target parameter name, and use the target parameter name as the parameter name corresponding to the constant parameter.

In one of the embodiments, the processor further implements the following steps when executing the computer-readable instructions: obtaining the parameter list and the interface parameter document template corresponding to each interface identifier; generating the interface parameters using the interface parameter document template and the parameter list corresponding to each interface identifier Document, save the interface parameter document.

One or more computer-readable storage media storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors perform the following steps: receiving interface parameter determination instructions, Determine the instruction to obtain the interface identification and parameter identification statement; parse the parameter identification statement according to the preset target analysis rule script to obtain the interface request parameter identification and the interface return parameter identification; obtain the corresponding request parameter statement according to the interface request parameter identification, and parse the request parameter statement, Obtain the data table field corresponding to the request parameter identifier, and use the data table field to generate the corresponding request parameter attribute; obtain the corresponding return parameter statement according to the interface return parameter identifier, parse the return parameter statement, and obtain the data table field corresponding to the return parameter identifier. Use the data The table fields generate corresponding return parameter attributes; generate a parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and store the interface identifier in association with the parameter list. Wherein, the computer-readable storage medium may be non-volatile or volatile.

In one of the embodiments, when the computer-readable instructions are executed by the processor, the following steps are also implemented: obtain each database parameter analysis rule, establish target analysis rules according to each database parameter analysis rule; generate target analysis rule scripts according to the target analysis rules, and deploy Target resolution rule script.

In one of the embodiments, when the computer-readable instruction is executed by the processor, the following steps are also implemented: determine the database type corresponding to the parameter recognition sentence; obtain the corresponding regular expression according to the database type, and use the regular expression to parse the parameter recognition sentence to obtain Interface request parameter identification and interface return parameter identification.

In one of the embodiments, when the computer-readable instruction is executed by the processor, the following steps are also implemented: use the preset target parsing rule script to determine the target identification character from the parameter recognition sentence; determine the interface request parameter identification and interface return according to the target identification character The position of the parameter identifier in the parameter identification statement, the interface request parameter identifier and the interface return parameter identifier are read from the position.

In one of the embodiments, when the computer-readable instruction is executed by the processor, the following steps are also implemented: obtain the parameter name corresponding to the constant parameter in the parameter list, and match the parameter name corresponding to the constant parameter with the existing parameter name; When they are consistent, the target parameter name is obtained, and the target parameter name is used as the parameter name corresponding to the constant parameter.

In one of the embodiments, when the computer-readable instruction is executed by the processor, the following steps are also implemented: obtaining the parameter list and interface parameter document template corresponding to each interface identifier; generating the interface using the interface parameter document template and the parameter list corresponding to each interface identifier Parameter file, save the interface parameter file.

A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be implemented by instructing relevant hardware through a computer program. The computer program can be stored in a non-volatile computer readable storage. In the medium, when the computer program is executed, it may include the processes of the above-mentioned method embodiments. Wherein, any reference to memory, storage, database or other media used in the embodiments provided in this application may include at least one of non-volatile and volatile memory. Non-volatile memory may include read-only memory (Read-Only Memory, ROM), magnetic tape, floppy disk, flash memory, or optical storage. Volatile memory may include random access memory (RAM) or external cache memory. As an illustration and not a limitation, RAM may be in various forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), etc.

The technical features of the above embodiments can be combined arbitrarily. In order to make the description concise, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features, they should be It is considered as the range described in this specification.

The above-mentioned embodiments only express several implementation manners of the present application, and the description is relatively specific and detailed, but it should not be understood as a limitation on the scope of the invention patent. It should be pointed out that for those of ordinary skill in the art, without departing from the concept of this application, several modifications and improvements can be made, and these all fall within the protection scope of this application. Therefore, the scope of protection of the patent of this application shall be subject to the appended claims.

Claims

An interface data processing method, wherein the method includes:

Receiving an interface parameter determination instruction, and acquiring an interface identification and a parameter identification sentence according to the parameter determination instruction;

Parse the parameter identification sentence according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier;

Obtain the corresponding request parameter sentence according to the interface request parameter identifier, parse the request parameter sentence to obtain the data table field corresponding to the request parameter identifier, and use the data table field to generate the corresponding request parameter attribute;

Obtain the corresponding return parameter sentence according to the interface return parameter identifier, parse the return parameter sentence to obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute; and

Generate a parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and store the interface identifier in association with the parameter list.
The method according to claim 1, wherein, before said receiving the interface parameter determination instruction, acquiring the interface identification and the parameter identification sentence according to the parameter determination instruction, further comprising:

Acquiring each database parameter parsing rule, and establishing a target parsing rule according to each database parameter parsing rule; and

A target parsing rule script is generated according to the target parsing rule, and the target parsing rule script is deployed.
The method according to claim 1, wherein the parsing the parameter identification sentence according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier comprises:

Determine the database type corresponding to the parameter recognition sentence; and

A corresponding regular expression is obtained according to the database type, and the parameter identification sentence is parsed using the regular expression to obtain an interface request parameter identifier and an interface return parameter identifier.
The method according to claim 1, wherein the parsing the parameter identification sentence according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier comprises:

Use a preset target parsing rule script to determine target identification characters from the parameter recognition sentence; and

The position of the interface request parameter identifier and the interface return parameter identifier in the parameter identification sentence is determined according to the target identification character, and the interface request parameter identifier and the interface return parameter identifier are read from the position.
The method according to claim 1, wherein after said generating a parameter list corresponding to said interface identifier according to said request parameter attribute and said return parameter attribute, and storing said interface identifier in association with said parameter list, Also includes:

Obtain the parameter name corresponding to the constant parameter in the parameter list, and match the parameter name corresponding to the constant parameter with the existing parameter name; and

When the matches are consistent, the target parameter name is obtained, and the target parameter name is used as the parameter name corresponding to the constant parameter.
The method according to claim 1, wherein after said generating a parameter list corresponding to said interface identifier according to said request parameter attribute and said return parameter attribute, and storing said interface identifier in association with said parameter list, Also includes:

Obtain the parameter list and interface parameter document template corresponding to each interface identifier; and

The interface parameter document template and the parameter list corresponding to each interface identifier are used to generate an interface parameter document, and the interface parameter document is saved.
An interface parameter determination device, wherein the device includes:

The sentence acquisition module is configured to receive an interface parameter determination instruction, and acquire the interface identification and parameter identification sentence according to the parameter determination instruction;

The parsing module is used to parse the parameter identification sentence according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier;

The attribute generation module is used to obtain the corresponding request parameter sentence according to the interface request parameter identifier, parse the request parameter sentence to obtain the data table field corresponding to the request parameter identifier, and use the data table field to generate the corresponding request parameter Attributes; obtain the corresponding return parameter statement according to the interface return parameter identifier, parse the return parameter statement to obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute; and

The parameter generation module is configured to generate a parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and store the interface identifier in association with the parameter list.
The device according to claim 7, wherein the device further comprises:

The rule establishment module is used to obtain various database parameter analysis rules, and establish target analysis rules according to the various database parameter analysis rules; and

The script generation module is used to generate a target parsing rule script according to the target parsing rule, and deploy the target parsing rule script.
A computer device includes a memory and one or more processors. The memory stores computer-readable instructions. When the computer-readable instructions are executed by the one or more processors, the one or more Each processor performs the following steps:

Receiving an interface parameter determination instruction, and acquiring an interface identification and a parameter identification sentence according to the parameter determination instruction;

Parse the parameter identification sentence according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier;

Obtain the corresponding request parameter sentence according to the interface request parameter identifier, parse the request parameter sentence to obtain the data table field corresponding to the request parameter identifier, and use the data table field to generate the corresponding request parameter attribute;

Obtain the corresponding return parameter sentence according to the interface return parameter identifier, parse the return parameter sentence to obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute; and

Generate a parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and store the interface identifier in association with the parameter list.
The computer device according to claim 9, wherein the processor further executes the following steps when executing the computer readable instruction:

Acquiring each database parameter parsing rule, and establishing a target parsing rule according to each database parameter parsing rule; and

A target parsing rule script is generated according to the target parsing rule, and the target parsing rule script is deployed.
The computer device according to claim 9, wherein the processor further executes the following steps when executing the computer readable instruction:

Determine the database type corresponding to the parameter recognition sentence; and

A corresponding regular expression is obtained according to the database type, and the parameter identification sentence is parsed using the regular expression to obtain an interface request parameter identifier and an interface return parameter identifier.
The computer device according to claim 9, wherein the processor further executes the following steps when executing the computer readable instruction:

Use a preset target parsing rule script to determine target identification characters from the parameter recognition sentence; and

The position of the interface request parameter identifier and the interface return parameter identifier in the parameter identification sentence is determined according to the target identification character, and the interface request parameter identifier and the interface return parameter identifier are read from the position.
The computer device according to claim 9, wherein the processor further executes the following steps when executing the computer readable instruction:

Obtain the parameter name corresponding to the constant parameter in the parameter list, and match the parameter name corresponding to the constant parameter with the existing parameter name; and

When the matches are consistent, the target parameter name is obtained, and the target parameter name is used as the parameter name corresponding to the constant parameter.
The computer device according to claim 9, wherein the processor further executes the following steps when executing the computer readable instruction:

Obtain the parameter list and interface parameter document template corresponding to each interface identifier; and

The interface parameter document template and the parameter list corresponding to each interface identifier are used to generate an interface parameter document, and the interface parameter document is saved.
One or more non-volatile computer-readable storage media storing computer-readable instructions. When the computer-readable instructions are executed by one or more processors, the one or more processors execute the following steps:

Receiving an interface parameter determination instruction, and acquiring an interface identification and a parameter identification sentence according to the parameter determination instruction;

Parse the parameter identification sentence according to the preset target parsing rule script to obtain the interface request parameter identifier and the interface return parameter identifier;

Obtain the corresponding request parameter sentence according to the interface request parameter identifier, parse the request parameter sentence to obtain the data table field corresponding to the request parameter identifier, and use the data table field to generate the corresponding request parameter attribute;

Obtain the corresponding return parameter sentence according to the interface return parameter identifier, parse the return parameter sentence to obtain the data table field corresponding to the return parameter identifier, and use the data table field to generate the corresponding return parameter attribute; and

Generate a parameter list corresponding to the interface identifier according to the request parameter attribute and the return parameter attribute, and store the interface identifier in association with the parameter list.
The storage medium according to claim 15, wherein the following steps are further performed when the computer-readable instructions are executed by the processor:

Acquiring each database parameter parsing rule, and establishing a target parsing rule according to each database parameter parsing rule; and

A target parsing rule script is generated according to the target parsing rule, and the target parsing rule script is deployed.
The storage medium according to claim 15, wherein the following steps are further performed when the computer-readable instructions are executed by the processor:

Determine the database type corresponding to the parameter recognition sentence; and

A corresponding regular expression is obtained according to the database type, and the parameter identification sentence is parsed using the regular expression to obtain an interface request parameter identifier and an interface return parameter identifier.
The storage medium according to claim 15, wherein the following steps are further performed when the computer-readable instructions are executed by the processor:

Use a preset target parsing rule script to determine target identification characters from the parameter recognition sentence; and

The position of the interface request parameter identifier and the interface return parameter identifier in the parameter identification sentence is determined according to the target identification character, and the interface request parameter identifier and the interface return parameter identifier are read from the position.
The storage medium according to claim 15, wherein the following steps are further performed when the computer-readable instructions are executed by the processor:

Obtain the parameter name corresponding to the constant parameter in the parameter list, and match the parameter name corresponding to the constant parameter with the existing parameter name; and

When the matches are consistent, the target parameter name is obtained, and the target parameter name is used as the parameter name corresponding to the constant parameter.
The storage medium according to claim 15, wherein the following steps are further performed when the computer-readable instructions are executed by the processor:

Obtain the parameter list and interface parameter document template corresponding to each interface identifier; and

The interface parameter document template and the parameter list corresponding to each interface identifier are used to generate an interface parameter document, and the interface parameter document is saved.