CN117215570A

CN117215570A - Code generation method of application program interface, terminal device and storage medium

Info

Publication number: CN117215570A
Application number: CN202311243480.XA
Authority: CN
Inventors: 陈家祥
Original assignee: China Merchants Bank Co Ltd
Current assignee: China Merchants Bank Co Ltd
Priority date: 2023-09-25
Filing date: 2023-09-25
Publication date: 2023-12-12

Abstract

The invention discloses a code generation method of an application program interface, terminal equipment and a storage medium, wherein the method comprises the following steps: when receiving a generating action triggered based on a configuration page, acquiring data query information and interface information corresponding to a target application program interface to be generated based on the configuration page; combining the data query information according to the query rule of the statement template corresponding to the data query information to construct a target query statement of the target application program interface; and generating a code file of the target application program interface according to the target query statement and the interface information. The invention provides a code generation scheme of an application program interface, a user can automatically generate a code file corresponding to the application program interface only by inputting data query information and interface information into a configuration page, and does not need to learn corresponding development rules and write the code file by itself, thereby achieving the purpose of improving the code generation efficiency of the application program interface.

Description

Code generation method of application program interface, terminal device and storage medium

Technical Field

The present invention relates to the field of data processing technologies, and in particular, to a code generation method for an application program interface, a terminal device, and a storage medium.

Background

In the big data age, storage and management of mass data is an important challenge. The traditional mode of storing and managing data sources by adopting a fixed type database cannot meet the storage and processing requirements of large-scale data. Accordingly, to accommodate the storage and processing of mass data, databases suitable for various storage and processing requirements have been developed, such as Hadoop databases, column-wise distributed databases (HBase databases), gaussian databases, and the like.

In the related art, when developing an application program, a developer generally selects a corresponding storage data source according to application scenarios of different functional modules of the application program. However, because the development rules of the data sources corresponding to different databases are different, a developer needs to learn the development rules of the different data sources respectively, and then write the corresponding interface codes according to the development rules of the data sources, so that the code generation of the application program interface is realized, and the technical problem of low development efficiency of the application program interface is caused.

The foregoing is provided merely for the purpose of facilitating understanding of the technical solutions of the present invention and is not intended to represent an admission that the foregoing is prior art.

Disclosure of Invention

The embodiment of the invention aims to solve the technical problem of low development efficiency of an application program interface by providing a code generation method, terminal equipment and a computer readable storage medium of the application program interface.

In order to achieve the above object, an embodiment of the present invention provides a code generation method of an application program interface, the code generation method of the application program interface including:

when receiving a generating action triggered based on a configuration page, acquiring data query information and interface information corresponding to a target application program interface to be generated based on the configuration page;

combining the data query information according to the query rule of the statement template corresponding to the data query information to construct a target query statement of the target application program interface;

and generating a code file of the target application program interface according to the target query statement and the interface information.

Optionally, before the step of acquiring the data query information and the interface information corresponding to the target application program interface to be generated based on the configuration page when the generating action triggered based on the configuration page is received, the method includes:

When the triggering action of the configuration page is detected, outputting and displaying the configuration page;

receiving a data source configured based on the configuration page, and acquiring a corresponding statement template according to the storage type of the data source;

and displaying the statement template in a corresponding area of the configuration page so that a user configures the data query information in the statement template.

Optionally, the step of combining the data query information according to the query rule of the statement template corresponding to the data query information to construct the target query statement of the target application program interface includes:

when the storage type of the data source is the ES database type, determining a statement template in which the data query information is located;

acquiring a logic relationship and/or a hierarchical relationship between the data query information configured based on the configuration page and a logic relationship between the sentence templates;

and combining the data query information according to the query rules of the statement templates, the logical relations and/or hierarchical relations among the data query information and the logical relations among the statement templates to construct the target query statement.

and when the storage type of the data source is the HBase database type, combining the data query information according to a query rule corresponding to a target statement template where the data query information is located, and constructing the target query statement.

Optionally, when the storage type of the data source is an HBase database type, the step of combining the data query information to construct the target query statement according to a query rule corresponding to a target statement template where the data query information is located includes:

acquiring a row key to be spliced configured based on the target sentence template and an assembly rule corresponding to the row key to be spliced;

assembling the row keys to be spliced according to the assembly rule to obtain a main key of the target query statement;

and combining the data query information with the primary key according to a query rule corresponding to a target statement template where the data query information is located, so as to construct the target query statement.

Optionally, before the step of generating the code file of the target application program interface according to the target query statement and the interface information, the method further includes:

executing the target query statement, and outputting and displaying a target query result of the target query statement on the configuration page;

receiving a screening action triggered based on the target query result, and acquiring screening information corresponding to the screening action;

updating to the target query statement according to the screening information, continuously executing the target query statement, and outputting and displaying a target query result of the target query statement on the configuration page;

and when receiving a generating action triggered based on a configuration page, generating a code file of the target application program interface according to the target query statement and the interface information.

Optionally, the interface information includes response definition information; after the step of executing the target query statement and outputting and displaying the target query result of the target query statement by the configuration page, the method further comprises the following steps:

determining to access JSON structure data corresponding to the target application program interface according to the target query result;

Displaying the JSON structure data on the configuration page;

and receiving response definition information configured based on the configuration page, and updating the JSON structure data according to the response definition information.

Optionally, the step of generating a code file of the target application program interface according to the target query statement and the interface information includes:

associating the target application program interface with a data source corresponding to the data query information to obtain an association relationship between the data source and the target application program interface;

and when the abnormality of the data source is detected, determining an alarm target according to the association relation of the data source, wherein the alarm target is an application program interface associated with the data source.

In addition, in order to achieve the above object, the present invention further provides a terminal device, including: the system comprises a memory, a processor and a code generation program of an application program interface which is stored in the memory and can run on the processor, wherein the code generation program of the application program interface realizes the steps of the code generation method of the application program interface when being executed by the processor.

In addition, in order to achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon a code generation program of an application program interface, which when executed by a processor, implements the steps of the code generation method of the application program interface as described above.

According to the code generation method of the application program interface, when a generation action triggered based on a configuration page is received, data query information and interface information corresponding to a target application program interface to be generated are acquired based on the configuration page, the data query information is combined according to query rules of a statement template corresponding to the data query information, a target query statement of the target application program interface is constructed, and then a code file of the target application program interface is generated according to the target query statement and the interface information. The invention provides a code generation scheme of an application program interface, a user can automatically generate a code file corresponding to the application program interface only by inputting data query information and interface information at the corresponding position of a configuration page, and the user does not need to learn corresponding development rules and write the code file by himself, so that the code generation efficiency of the application program interface is improved.

Drawings

FIG. 1 is a block diagram of a code generation apparatus of an application program interface according to the present invention;

FIG. 2 is a flowchart illustrating an embodiment of a code generation method of an application program interface according to the present invention;

FIG. 3 is a diagram of an access call link for a target application program interface in accordance with the present invention;

FIG. 4 is a detailed flowchart of step S10 in a second embodiment of the code generation method of the application program interface of the present invention;

FIG. 5 is a detailed flowchart of step S20 in a third embodiment of the code generation method of the application program interface of the present invention;

FIG. 6 is a schematic diagram of a building target query statement by the ES domain-specific language generation engine of the present invention;

FIG. 7 is a flowchart illustrating a code generation method of an application program interface according to a fourth embodiment of the present invention, wherein the flowchart includes step S20;

FIG. 8 is a schematic diagram of a HBase domain specific language generation engine of the present invention constructing a target query statement;

FIG. 9 is another detailed flowchart of step S30 in a fifth embodiment of a code generation method of an application program interface of the present invention;

FIG. 10 is a detailed flowchart of step S70 in a sixth embodiment of a code generation method of an application program interface of the present invention;

FIG. 11 is a schematic diagram of modification of JSON structure data according to the present invention;

fig. 12 is a schematic diagram of a terminal structure of a hardware running environment according to an embodiment of the present invention.

The achievement of the objects, functional features and advantages of the present invention will be further described with reference to the accompanying drawings, in conjunction with the embodiments.

Detailed Description

It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.

In order to solve the above-mentioned drawbacks of the related art, the present invention provides a code generation method of an application program interface, which mainly comprises the following steps:

when receiving a generating action triggered based on a configuration page, acquiring data query information and interface information corresponding to a target application program interface to be generated based on the configuration page, combining the data query information according to a query rule of a statement template corresponding to the data query information, constructing a target query statement of the target application program interface, and then generating a code file of the target application program interface according to the target query statement and the interface information. The invention provides a code generation scheme of an application program interface, a user can automatically generate a code file corresponding to the application program interface only by inputting data query information and interface information at the corresponding position of a configuration page, and the user does not need to learn corresponding development rules and write the code file by himself, so that the code generation efficiency of the application program interface is improved.

In order to better understand the above technical solution, exemplary embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present invention are shown in the drawings, it should be understood that the present invention may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the invention to those skilled in the art.

Referring to fig. 1, fig. 1 is a schematic block diagram of a code generating device of an application program interface according to the present invention. The invention provides a code generating device of an application program interface, which comprises a data source management module, a right management module, an interface configuration module, an interface monitoring module, a code generating module and an interface SaaS (Software as a Service, software operation service) service module. The data source management module is used for managing metadata such as examples, clusters, indexes, tables, partition information and the like of various data sources. The user may choose to store the data source in the corresponding database at the data source management module. The data management module of the present invention provides an ES (elastic search) database and an HBase database, and the user may store the data source into the ES database or the HBase database according to actual needs, which is not limited in this embodiment. The right management module is used for managing the use right of the data source. Before using the data source, the user needs to apply for the use authority of the data source in the authority management module, otherwise, the user is forbidden to use the data source. The interface configuration module is used for configuring corresponding to the target application program interface. The interface configuration module comprises a configuration page, and a user can configure the target application program by inputting corresponding data query information and interface information in the configuration page. In addition, the interface configuration module also provides an interface preview function for pre-executing the target query statement constructed according to the data query information and returning the target query result so that the user can modify the data query information according to the target query result. The interface monitoring module is used for monitoring the target application program interface and the data source. When the abnormality of the target application program interface or the data source is monitored, a corresponding alarm prompt is output, so that a user can find the abnormality and repair the abnormality in time. The code generating module is used for generating a code file of the target application program interface according to the target query statement and the interface information so that a user can download the code file and deploy the code file at any terminal. It should be noted that, the code generating module of the present invention generates, through the code generating engine, the code file of the target application program interface according to the target query statement and the interface information configured by the user. The interface service module is used for publishing and deploying the target application program interface so that a user can call the target application program interface through the interface service module.

Referring to fig. 2, in an embodiment of the code generation method of the application program interface of the present invention, the code generation method of the application program interface includes the following steps:

step S10: when receiving a generating action triggered based on a configuration page, acquiring data query information and interface information corresponding to a target application program interface to be generated based on the configuration page;

in this embodiment, the execution body is a terminal. The terminal may be a mobile phone, a computer, or other devices for generating code files of an application program interface, which is not limited in this embodiment. The invention provides a code generation module which is used for generating a code file of an application program interface. When receiving the generating action triggered by the configuration page, the terminal acquires the data query information and the interface information set by the configuration page through the code generating module, and generates a code file of the target application program interface. The data query information includes at least one or more of database name, table name, field, filtering condition, ordering rule, aggregation function, and grouping, which is not particularly limited in this embodiment. The interface information includes at least an interface name and an interface parameter and response definition information. It will be appreciated that the interface parameters are input parameters for the target application program interface. The input parameter may be related data in the data query information, or may be other information, which is not specifically limited in this embodiment. The response definition information is used for defining the returned JSON (JavaScript Object Notation, a data interaction format) structure data when the target application program interface is called.

Step S20: combining the data query information according to the query rule of the statement template corresponding to the data query information to construct a target query statement of the target application program interface;

in this embodiment, the user configures corresponding data query information in the sentence templates of the configuration page, and different sentence templates correspond to different query rules. Therefore, the terminal can acquire the query rule of the statement template corresponding to the data query information, and combine the data query information according to the query rule, so that the construction of the target query statement is realized. Query rules refer to the rules or regulations that are followed when making data queries. It defines the structure, syntax and semantics of the query statement, as well as the behavior of the query operation and the expectation of the results. It should be noted that the target query statement is a language supported by a database type of the storage data source. For example, when the data query information is derived from the ES database, the constructed target query statement is a DSL (Domain-Specific Language Query ) statement, and when the data query information is derived from the HBase database, the constructed target query statement is an HBase SQL (HBase Structured Query Language ) statement, which is not particularly limited in this embodiment.

Step S30: and generating a code file of the target application program interface according to the target query statement and the interface information.

In this embodiment, the terminal generates, by using the code generation module, a code file of the target application program interface according to the constructed target query statement and the interface information. The user can download the code file of the target application program interface so as to install and deploy the code file on any terminal or server. It should be noted that the generated code file is an independent code project, and no dependency is added, so that the generated code file can be directly operated without depending on other components or services, and the user can conveniently and independently deploy the generated target application program interface.

In another alternative embodiment, the invention provides an interface service module for publishing a deployment-target application program interface. The interface service module is used for issuing and deploying the target application program interface according to the target query statement and the interface information based on the SaaS service, so that a user can access the generated target application program interface through the interface service module and acquire JSON structure data returned by the target application program interface. It can be understood that the target application program interface for issuing and deploying based on the SaaS service has a certain dependency with the terminal of the invention.

It should be noted that, the interface service module supports a dynamic parameter function, and when the target application program interface is accessed through the interface service module, a user can input corresponding interface parameters according to different scenes, requirements or configurations. The interface parameters may be information of an associated ES cluster address, index name, query condition, etc. If a certain query condition of the target query statement has and has only one interface parameter, and the interface parameter is not transmitted by the user, the interface service module automatically discards the query condition, so that the interface service module adapts to more application scenes.

Optionally, to facilitate the user to further process the JSON structure data returned by the interface, for example, the JSON structure data is encapsulated into class objects. When the response definition information is set in the target application program interface accessed by the user, processing the target query result according to the response definition data, obtaining JSON structure data, and extracting specific fields from the JSON structure data to generate POJO (Plain Old Java Object, java object class) class return, so that the user can directly complete packaging of corresponding fields in the returned JSON structure data.

Referring to fig. 3, fig. 3 is an access call link diagram of a target application program interface according to the present invention. After issuing the target application program interface based on the SaaS service, a user calls the issued target application program interface through an interface service module and inputs the ES cluster address, the index name and the interface parameters of the query condition. When the interface service module receives an access request of a target application program interface, searching data query information and interface information corresponding to the target application program interface from a Redis cache database, if not, further acquiring the data query information and response definition information from a Mysql source database, then determining a partition index where a data source is according to whether an index corresponding to an ES cluster name and an index name is a partition index or not, and if the index is the partition index, further determining the partition index where the data source is located according to partition fields and time parameters in the data query information. The specific DSL statement of the query is constructed by using the domain-specific language generating engine, the interface parameters input by the user are transmitted to the DSL statement, and then the target query result is obtained in the partition index where the determined data source is located. After the target query result is obtained, the returned target query result is processed according to the response definition information, and final JSON structure data is obtained. If the response definition information is not queried, the method judges that the original JSON structure data is automatically returned if the result analysis is not needed.

It can be understood that when the generating action based on the configuration page trigger is received, the method outputs a prompt whether the target application program interface is to be deployed or not through the configuration page, if the user selects to deploy, the generated target application program interface is released and deployed through the interface service module, and if the user does not select to deploy, the code file of the target application program interface is directly generated, so that the user can download the code file and deploy the code file to any terminal or server.

In the technical scheme provided by the embodiment, when receiving the generating action triggered based on the configuration page, acquiring data query information and interface information corresponding to the target application program interface to be generated based on the configuration page, combining the data query information according to the query rule of the statement template corresponding to the data query information, constructing a target query statement of the target application program interface, and then generating a code file of the target application program interface according to the target query statement and the interface information. The invention provides a code generation scheme of an application program interface, a user can automatically generate a code file corresponding to the application program interface only by inputting data query information and interface information at the corresponding position of a configuration page, and the user does not need to learn corresponding development rules and write the code file by himself, so that the development efficiency of the application program interface is improved.

Referring to fig. 4, in a second embodiment, based on the first embodiment, before the step S10, the method includes:

step S40: when the triggering action of the configuration page is detected, outputting and displaying the configuration page;

in this embodiment, the present invention provides an interface configuration module, configured to configure data query information and interface information of a target application program interface. The interface configuration module includes a configuration page. The user configures the data query information and the interface information of the target application program interface to be generated on the configuration page by entering the configuration page of the interface configuration module, and then the code generating module automatically generates the code file of the target application program according to the data query information and the interface information.

Step S50: receiving a data source configured based on the configuration page, and acquiring a corresponding statement template according to the storage type of the data source;

in this embodiment, the storage type refers to a database type storing the data source. The storage types are divided into two types, namely an ES database type and an HBase database type. The invention provides configuration of data sources on a configuration page. After entering the configuration page, the user needs to configure the data source on the configuration page, and then subsequently, the user queries the information based on the data source configuration data. It can be understood that the data query information is selected and configured based on the data source, and then the constructed target query statement is used for querying the data in the data source.

Optionally, to improve the security of the data source, the present invention provides a rights management module. Before configuring a data source, a user needs to apply for the use authority of the data source in the authority management module, and after acquiring the use authority of the data source, the data source can be configured and used in a configuration page, otherwise, the data source cannot be configured and used. The usage rights may be a database usage right, a table data right, and an index usage right, which is not specifically limited in this embodiment. When a user configures a data source in a configuration page, the permission management module verifies whether the user has the use permission of the data source, if so, the user is allowed to configure, and if not, the user applies to the permission management module by the corresponding prompt information of the data.

Step S60: and displaying the statement template in a corresponding area of the configuration page so that a user configures the data query information in the statement template.

In this embodiment, the present invention designs different sentence templates for different storage types of the data source. Different sentence templates correspond to different functions. The ES database type designs screening templates, aggregation templates and data display templates. The screening class template is used for screening out data meeting the conditions. The aggregation template is used for carrying out aggregation operation on the screened data to obtain a final statistical result. The data display class template is used for displaying functions such as dynamic ordering, folding, paging and the like of data. The HBase database type designs a single row query template, a batch query template and a scanning query template. The single line query template is used to query a single line of data. The batch query template is used to query multiple rows of data. The scan query is used to traverse or scan the entire dataset or specified portions of the data. It will be appreciated that the single row query template may be referred to as a get template, the batch query template may be referred to as a get template, and the scan query template may be referred to as a scan template, as the embodiment is not specifically limited in this regard.

It should be noted that, in the single-row query template, the data query information includes, but is not limited to, table names and row keys. In the batch query template, the data query information includes, but is not limited to, table names, row key lists, column families, column qualifier lists. In the scan query template, the data query information includes, but is not limited to, a table name, a start row key, an end row key, a column family, and a column qualifier. It is understood that a row key may be referred to as a RowKey.

Alternatively, three types of sentence templates of the ES database type may be used alone or in combination. Therefore, when the storage type of the data source is the ES database type, three types of sentence templates can be respectively displayed in the corresponding areas of the configuration page, and the user can configure corresponding data query information in the various sentence templates of the configuration page.

In this embodiment, when the storage type of the data source is the ES database type, the three types of sentence templates are all displayed in the corresponding area of the configuration page. The user can configure data query information in the corresponding sentence templates according to the service requirement, and set the logic relationship and/or hierarchical relationship between the data query information in the sentence templates, and set the logic relationship between various sentence templates. The logical relationship includes and, or, not. The hierarchical relationships include parent-child relationships and sibling relationships. It will be appreciated that in the statement templates displayed in the configuration page, visual selection of logical relationships and hierarchical relationships between the data query information is provided.

It should be understood that there are cases where the result after the aggregation calculation needs to be subjected to the aggregation calculation again in the aggregation calculation. Therefore, the hierarchical relationship among the data query information can be set in the aggregation class template.

Optionally, the three sentence templates of the HBase database type are not used in combination and are all used independently. Therefore, when the storage type of the data source is the HBase database type, the target sentence templates are determined according to the options of the user by outputting the options of the three sentence templates, and the target sentence templates are displayed in the corresponding areas of the configuration page. The user can query information, such as table names, row keys and the like, corresponding to filling data according to filling identification in the target sentence template according to business requirements.

In this embodiment, the target sentence template displayed on the configuration page displays the filling identification of various data query information, and the user only needs to configure the data query information at the corresponding position of the target sentence template according to the service requirement, without paying attention to the code implementation of the target query sentence.

It can be understood that the sentence template displayed on the configuration page does not need to be provided by a user, and only the corresponding data query information is input at the corresponding position of the sentence template. After the configuration is completed, the code generating module of the terminal can automatically generate the code file of the target application program interface according to the data query information and the interface information by triggering the generating action of the configuration page, so that the development efficiency of the application program interface is improved.

Optionally, to facilitate management of data sources by a user, the present invention provides a data source management module for managing metadata such as examples, clusters, indexes, tables, partition information, and the like of various data sources. The user can register own data source in the data source management module, store the data source in the ES database or the HBase database, and configure corresponding index. It is understood that the ES database includes a normal index and a partition index. It is understood that a common index refers to storing data sources directly in a single index, without partition or fragment management. Partition index refers to partitioning a data source into multiple partitions according to partition rules, each partition being stored independently in a different partition. Common indexes can be adopted for data sources with small data quantity, and partition indexes can be adopted for massive data sources, so that the data query efficiency can be improved. The partitioning rule may partition each field of the data source according to one or more of time, region, and user identifier, which is not specifically limited in this embodiment.

Optionally, if it is detected that the storage type of the data source configured by the configuration page is an ES database type, and when the configured data query information includes a partition field, a prompt that an index query of the partition field can be set can be output by the configuration page, and when the user selects to set the index query of the partition field, the terminal automatically supplements index query information corresponding to the partition field in the data query information, so that when query is performed based on the constructed target query statement, query efficiency can be improved according to the index query of the partition field.

Optionally, after the step of generating the code file of the target application program interface according to the target query statement and the interface information, associating the target application program interface with a data source corresponding to the data query information to obtain an association relationship between the data source and the target application program interface; and when the abnormality of the data source is detected, determining an alarm target according to the association relation of the data source, wherein the alarm target is an application program interface associated with the data source.

In this embodiment, in order to quickly locate affected application program interfaces and make a corresponding solution policy when a data source is abnormal, after a target application program interface is generated, the method and the device associate the target application program interface with the data source, so that when the data source is abnormal, all affected application program interfaces can be quickly located according to the association relationship of the data source, and a user terminal corresponding to the application program interface is used as an alarm target to send an alarm prompt to the alarm target.

Optionally, in another optional embodiment, after the step of receiving the data source set based on the configuration page, the step of receiving includes: and associating the data source with the target application program interface to be generated, so that when the user enters the configuration page next time, the interface name can be input in the configuration page, and the data source, the data query information and the interface information associated with the interface name are output and displayed in the configuration page, so that the user can conveniently and continuously configure the target application program interface, and the embodiment is not limited in detail.

Optionally, to implement anomaly monitoring of the application program interface and the data source, the present invention provides an interface monitoring module for monitoring the application program interface and the data source. The interface monitoring module can acquire technical indexes such as calling trend, interface response time, interface success rate and the like of the application program interface according to the interface log of the application program interface, and when any technical index exceeds a corresponding preset threshold value, the abnormality of the application program interface is determined, so that a corresponding alarm prompt is output, and a user can timely find out the problem of the application program interface in use and solve the problem. The interface calling trend refers to a change trend of the interface calling frequency or the interface calling amount in a period of time, which is not particularly limited in this embodiment.

Optionally, in another optional implementation manner, a multidimensional decision tree algorithm is adopted, technical indexes of different dimensions are scored, and the health degree of the application program interface is obtained according to the comprehensive score, and when the health degree exceeds a threshold value, the application program interface is judged to be abnormal, which is not particularly limited in this embodiment. Meanwhile, the invention supports the user to set the technical index to be monitored and the corresponding alarm rule. For example, interface call errors, interface call surges or dips, interface response time length, interface success rate and the like are used as technical indexes.

Alternatively, the interface monitoring module may employ different monitoring policies depending on the data sources of different storage types. For the data source of the ES database type, the interface monitoring module counts the number of the newly added partition indexes in a preset time period, when the number of the newly added partition indexes exceeds a threshold value, the abnormality of the data source can be judged, and then all affected application program interfaces are rapidly positioned according to the association relation of the data source, and a using terminal corresponding to the application program interfaces is used as an alarm target to send an alarm prompt to the alarm target.

In the technical scheme provided by the embodiment, when the triggering action of the configuration page is detected, the configuration page is output and displayed, then a data source configured based on the configuration page is received, a corresponding statement template is acquired according to the storage type of the data source, and further the statement template is displayed in a corresponding area of the configuration page, so that a user can configure data query information in the statement template according to service requirements, the data query information is configured in a corresponding position of the statement template, and further when the generating action based on the configuration page is triggered, the data query information is combined according to the query rule of the statement template corresponding to the data query information, so that the construction of a target query statement is realized, encoding of the target query statement is not needed, and the construction efficiency of the target query statement is improved.

Referring to fig. 5, in a third embodiment, based on any of the above embodiments, the step S20 includes:

step S21: when the storage type of the data source is the ES database type, determining a statement template in which the data query information is located;

step S22: acquiring a logic relationship and/or a hierarchical relationship between the data query information configured based on the configuration page and a logic relationship between the sentence templates;

step S23: and combining the data query information according to the query rules of the statement templates, the logical relations and/or hierarchical relations among the data query information and the logical relations among the statement templates to construct the target query statement.

In this embodiment, the code generation module of the present invention provides an ES domain-specific language generation engine for constructing a query statement with a storage type of ES database type. It can be understood that the ES domain specific language generation engine stores various sentence templates of the ES database type and query rules corresponding to the various sentence templates. When triggering the generating action based on the configuration page, the code generating module calls an ES domain special language generating engine when determining that the storage type of the data source of the configuration page is ES data type or the storage type of the data source corresponding to the data query information is ES database type, and the ES domain special language generating engine determines statement representations of logical relations and/or hierarchical relations among various data query information and statement representations of logical relations among statement templates where the various data query information are located according to query rules, so that the various data query information is combined, and the construction of target query statements is realized. Referring to fig. 6, fig. 6 is a schematic diagram of constructing a target query sentence by the ES domain-specific language generation engine according to the present invention.

If the statement templates are detected to be not configured with the data query information, the language generation engine special for the ES field ignores the statement templates and only processes the statement templates configured with the data query information, so that each statement template can be used independently or in combination, multiple persons can conveniently cooperate and develop simultaneously, and development efficiency of an application program interface is improved.

In the technical scheme provided by the embodiment, when the storage type of the data source is the ES database type, the statement template in which the data query information is located is determined, the logic relationship and/or the hierarchical relationship between each item of data query information configured based on the configuration page and the logic relationship between each item of statement templates are obtained, and each item of data query information is combined according to the query rule of each item of statement template and the logic relationship and/or the hierarchical relationship between each item of data query information and the logic relationship between each item of statement templates to construct a target query statement, so that a user only needs to configure the corresponding data query information on the configuration page according to service requirements, and sets the logic relationship and/or the hierarchical relationship between the data query information and the logic relationship between each item of statement templates without paying attention to the code implementation of the target statement, and the construction efficiency of the target query statement is improved.

Referring to fig. 7, in a fourth embodiment, based on any of the above embodiments, the step S20 includes:

step S24: and when the storage type of the data source is the HBase database type, combining the data query information according to a query rule corresponding to a target statement template where the data query information is located, and constructing the target query statement.

In this embodiment, the code generation module of the present invention provides a HBase domain-specific language generation engine for constructing a query statement with a storage type of HBase database type. It can be understood that the HBase domain specific language generation engine stores each statement template of the HBase database type and the query rule corresponding to each statement template. And when the code generation module determines that the storage type of the data source of the configuration page is the HBase database type or determines that the storage type of the data source corresponding to the data query information is the HBase database type, invoking a special language generation engine in the HBase field, and combining the data query information according to the query rule corresponding to the target statement template in which the data query information is positioned to construct a target query statement.

For example, the target sentence template configured by the user is a single-line query template, and the table name filled in the single-line query template is tab1, and the line key is uid. Then the subsequent code generation module combines the table names and the row keys according to the query rule of the single-row query template, thereby obtaining ' get ' tab1' _, 'uid' "target query statement.

Alternatively, referring to fig. 8, fig. 8 is a schematic diagram of the HBase domain-specific language generation engine construction target query statement according to the present invention. In another optional embodiment, in order to improve query efficiency of the target query statement, when the storage type of the data source is an HBase database type, the step of combining the data query information according to a query rule corresponding to a target statement template where the data query information is located to construct the target query statement further includes: acquiring a row key to be spliced configured based on the target statement template and an assembly rule corresponding to the row key to be spliced, assembling the row key to be spliced according to the assembly rule, acquiring a main key of the target query statement, and combining the data query information and the main key according to a query rule corresponding to the target statement template in which the data query information is located, so as to construct the target query statement.

In this embodiment, in order to improve the efficiency of data query, the present invention further provides a function of splicing row keys in various sentence templates. The user can configure a plurality of row keys to be spliced at corresponding positions in the target sentence template, and configure an assembly rule of the row keys to be spliced. When the target query statement is built, the HBase domain specific language generating engine assembles the row keys to be spliced according to the assembly rule configured by the user, and takes the assembled row keys as the main keys of the target query statement, so that the query efficiency can be greatly improved according to the main key query during the data query.

In the technical scheme provided by the embodiment, when the storage type of the data source is the HBase database type, the data query information is combined according to the query rule corresponding to the target statement template where the data query information is located, and the target query statement is constructed, so that a user does not need to pay attention to the code implementation of the target query statement, and only needs to configure the corresponding data query information in the target statement template, thereby improving the construction efficiency of the query statement.

Referring to fig. 9, in a fifth embodiment, based on any of the above embodiments, before the step S30, the method includes:

step S70: executing the target query statement, and outputting and displaying a target query result of the target query statement on the configuration page;

in this embodiment, the interface configuration module of the present invention further provides an interface preview function, and may pre-execute the constructed target query statement, and display the corresponding target query result in a list form on the configuration page, so that the user may determine whether the configured data query information is correct according to the displayed target query result. If not, the configured data query information can be immediately modified correspondingly, so that the target query statement is reconstructed. And continuously executing the reconstructed target query statement until the configured data query information is determined to be correct, and regenerating a code file of the target application program interface, so that the accuracy of the generated code file can be improved, and the development efficiency of the target application program interface can be improved.

Step S80: receiving a screening action triggered based on the target query result, and acquiring screening information corresponding to the screening action;

step S90: updating to the target query statement according to the screening information, continuously executing the target query statement, and outputting and displaying a target query result of the target query statement on the configuration page;

in this embodiment, the filtering information is a target field and/or a generic name of the target field that is filtered by the user from the displayed target query result. And when a screening action triggered based on the target query result is received, updating the target field and/or the name of the target field to the target query statement by acquiring the target field and/or the name of the target field screened by the user. And then, re-executing the updated target query statement and displaying the screened target query result. The invention further simplifies the generation process of the code file by supporting the direct screening of the target query result by the user, and the user can generate the code by the code generation method of the application program interface provided by the invention without professional development capability.

Alternatively, when it is detected that the filtering button corresponding to the target query result is clicked, the filtering action may be regarded as triggered, which is not specifically limited in this embodiment.

Optionally, the target field and/or the name of the target field may be updated into the returned results in the target query statement. The returned result is a field returned after the execution of the target query statement. For example, in a query statement of the HBase database, the returned fields are defined by Column qualifiers (Column qualitors). In the query statement of the ES database, the returned fields are defined by Source Filtering (Source Filtering).

It should be noted that, if a new field or condition needs to be added to the target query result, the data query information may be modified, which is not specifically limited in this embodiment.

Step S100: and when receiving a generating action triggered based on a configuration page, generating a code file of the target application program interface according to the target query statement and the interface information.

In this embodiment, after updating the target query statement, the user may trigger the generating action again on the configuration page, so as to generate the code file of the target application program interface according to the updated target query statement and the interface information.

In the technical scheme provided by the embodiment, the target query statement is executed, the target query result of the target query statement is output and displayed on the configuration page, then the screening action triggered based on the target query result is received, the screening information corresponding to the screening action is acquired, the screening information is updated to the target query statement, the target query statement is continuously executed, the target query result of the target query statement is output and displayed on the configuration page, and when the generating action triggered based on the configuration page is received, the code file of the target application program interface is generated according to the target query statement and the interface information. The invention provides a result preview function, and the target query statement is executed in advance and output and display the target query result, so that a user can screen according to the target query result, and the finally generated target query statement meets the service requirement of the user.

Referring to fig. 10, in a sixth embodiment, after step S70, based on any of the above embodiments, the method further includes:

step S110: converting the target query result into JSON structure data corresponding to the target application program interface;

in this embodiment, the JSON structure data is a return result of accessing the target application program interface. The interface configuration module provides an interface preview function, pre-executes the target query statement, and after obtaining the target query result, can convert the target query result into the JSON structure data corresponding to the access target application program interface, so that a user can modify the JSON structure data of the target application program interface, and therefore, when the user accesses the target application program interface, the user does not need to deal with complicated JSON structure data to judge various types, only needs to pay attention to the data, the development progress can be greatly accelerated, and the method is more friendly and convenient to use.

Step S120: displaying the JSON structure data on the configuration page;

step S130: and receiving response definition information configured based on the configuration page, and updating the JSON structure data according to the response definition information.

In this embodiment, the present invention provides a preview function of JSON structure data, and supports modification of JSON structure data. The user may configure the response definition information through the configuration area of the interface information corresponding to the configuration page, or directly change JSON structure data displayed in the configuration page, which is not specifically limited in this embodiment. The modification includes, but is not limited to, deleting part of the data in the JSON structure data, and modifying the name of the part of the data in the JSON structure data. When response definition information for configuration based on the configuration page is received, data to be deleted or changed is determined according to the response definition information, so that corresponding data in the return structure is deleted or modified.

Optionally, after deleting or modifying part of the JSON structure data according to the response definition information, the structure of the JSON structure data may be reorganized, so as to improve the readability and conciseness of the JSON structure data. The most simplified returned structure data can be obtained by restructuring and optimizing pruning through a single path shrinkage, bifurcation point restructuring objects and a set object traversing principle, and the embodiment is not limited in detail.

Optionally, in another optional embodiment, after the target query result is converted to obtain JSON structure data, a formatting structure may be extracted from the JSON structure data, where the formatting structure still maintains the original hierarchical relationship, but some information that is not useful for the user is deleted, and the structure is simplified.

For example, referring to fig. 11, fig. 11 is a schematic diagram of modification of JSON structure data according to the present invention. The original JSON is original JSON structure data obtained by directly converting a target query result. The user-defined interface return message is JSON structure data obtained by deleting irrelevant data in original JSON structure data according to response definition information and reorganizing the part of the structure, so that the structure is simplified. The received response definition information is reserved keys in aggregation 1. Pocket, and pocket. Keys and pocket. Doc_count under the same level. The extraction structure is the JSON structure obtained after the format structure is extracted from the original JSON structure data.

Referring to fig. 12, fig. 12 is a schematic diagram of a terminal structure of a hardware running environment according to an embodiment of the present invention.

The terminal of the embodiment of the invention can be terminal equipment.

As shown in fig. 12, the terminal may include: a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, a communication bus 1002. Wherein the communication bus 1002 is used to enable connected communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), a mouse, etc., and the optional user interface 1003 may further include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface). The memory 1005 may be a high-speed RAM memory or a stable memory (non-volatile memory), such as a disk memory. The memory 1005 may also optionally be a storage device separate from the processor 1001 described above.

It will be appreciated by those skilled in the art that the terminal structure shown in fig. 12 is not limiting of the terminal and may include more or fewer components than shown, or may combine certain components, or a different arrangement of components.

As shown in fig. 12, a code generation program of an operating system, a network communication module, a user interface module, and an application program interface may be included in the memory 1005 as one type of computer storage medium.

In the terminal shown in fig. 12, the network interface 1004 is mainly used for connecting to a background server, and performing data communication with the background server; the processor 1001 may be configured to call a code generation program of an application program interface stored in the memory 1005 and perform the following operations:

Further, the processor 1001 may call a code generation program of an application program interface stored in the memory 1005, and further perform the following operations:

displaying the JSON structure data on the configuration page;

It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or system that comprises the element.

The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.

From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on this understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (e.g. ROM/RAM, magnetic disk, optical disk) as described above, comprising instructions for causing a terminal device (which may be a mobile phone, a computer, a server) to perform the method according to the embodiments of the present invention.

The foregoing description is only of the preferred embodiments of the present invention, and is not intended to limit the scope of the invention, but rather is intended to cover any equivalents of the structures or equivalent processes disclosed herein or in the alternative, which may be employed directly or indirectly in other related arts.

Claims

1. A code generation method of an application program interface, characterized in that the code generation method of the application program interface comprises the following steps:

2. The method of claim 1, wherein the step of acquiring the data query information and the interface information corresponding to the target application program interface to be generated based on the configuration page when the generating action triggered based on the configuration page is received comprises:

3. The method as claimed in claim 2, wherein the step of combining the data query information according to the query rule of the statement template corresponding to the data query information to construct the target query statement of the target application program interface includes:

4. The method as claimed in claim 2, wherein the step of combining the data query information according to the query rule of the statement template corresponding to the data query information to construct the target query statement of the target application program interface includes:

5. The method of claim 4, wherein when the storage type of the data source is HBase database type, the step of combining the data query information according to a query rule corresponding to a target statement template in which the data query information is located, and constructing the target query statement comprises:

6. The method of claim 1, wherein prior to the step of generating the code file of the target application program interface from the target query statement and the interface information, further comprising:

7. The method of claim 6, wherein the interface information includes response definition information; after the step of executing the target query statement and outputting and displaying the target query result of the target query statement by the configuration page, the method further comprises the following steps:

displaying the JSON structure data on the configuration page;

8. The method of claim 1, wherein the step of generating a code file for the target application program interface from the target query statement and the interface information comprises:

9. A terminal device, characterized in that the terminal device comprises: memory, a processor and a generation program of an application program interface stored on the memory and executable on the processor, which when executed by the processor, implements the steps of the code generation method of an application program interface as claimed in any one of claims 1 to 8.

10. A computer-readable storage medium, wherein a generation program of an application program interface is stored on the computer-readable storage medium, which when executed by a processor, implements the steps of the code generation method of an application program interface according to any one of claims 1 to 8.