CN117891451A

CN117891451A - Script file generation method, device, equipment and storage medium

Info

Publication number: CN117891451A
Application number: CN202311770899.0A
Authority: CN
Inventors: 蒋天伦; 庞江川; 张家宝; 金浩
Original assignee: Shuguang Cloud Computing Group Co ltd; Wuxi City Cloud Computing Center Co ltd
Current assignee: Shuguang Cloud Computing Group Co ltd; Wuxi City Cloud Computing Center Co ltd
Priority date: 2023-12-20
Filing date: 2023-12-20
Publication date: 2024-04-16

Abstract

The application relates to a script file generation method, a script file generation device, script file generation equipment and a storage medium. The method comprises the following steps: by responding to the triggering operation of the user on the target control in the configuration interface of the application program interface, the script configuration interface corresponding to the triggering operation can be displayed. Wherein the triggering operation is determined by the user based on the generation mode of the application program interface to be generated. The first script file corresponding to the application program interface can be obtained based on configuration parameters input by a user in the script configuration interface. Wherein the configuration parameters are determined by the user according to the service information of the application program interface. The target script file corresponding to the application program interface can be generated according to the first script file and the second script file which is generated in advance. Wherein the second script file is generated based on the basic information of the application program interface. By adopting the method, the development difficulty of the application program of the data service technology can be reduced.

Description

Script file generation method, device, equipment and storage medium

Technical Field

The present invention relates to the field of application program interfaces, and in particular, to a method, an apparatus, a device, and a storage medium for generating a script file.

Background

With the widespread use of big data technology, individuals, enterprises, etc. have generated a large number of data assets, which can be processed by calling the data service technology through the application program interface (Application Program Interface, API) of the data service technology in order to break the data islands and use the data assets as important production elements for promoting the social development.

In the conventional technology, a large amount of business logic codes and SQL codes are required to be written to complete the development of the API.

However, the conventional art has a problem in that development of an API of the data service technology is difficult.

Disclosure of Invention

In view of the foregoing, it is desirable to provide a method, apparatus, device, and storage medium for generating a script file that can reduce the difficulty in developing an API of a data service technology.

In a first aspect, the present application provides a method for generating a script file, including:

responding to the triggering operation of a user on a target control in a configuration interface of an application program interface, and displaying a script configuration interface corresponding to the triggering operation; the triggering operation is determined by the user based on a generation mode of an application program interface to be generated;

acquiring a first script file corresponding to the application program interface based on configuration parameters input by the user on the script configuration interface; the configuration parameters are determined by the user according to the service information of the application program interface;

Generating a target script file corresponding to the application program interface according to the first script file and a pre-generated second script file; the second script file is generated based on the basic information of the application program interface.

According to the script file generation method, the script configuration interface corresponding to the trigger operation can be displayed by responding to the trigger operation of the user on the target control in the configuration interface of the application program interface. Wherein the triggering operation is determined by the user based on the generation mode of the application program interface to be generated. The first script file corresponding to the application program interface can be obtained based on configuration parameters input by a user in the script configuration interface. Wherein the configuration parameters are determined by the user according to the service information of the application program interface. The target script file corresponding to the application program interface can be generated according to the first script file and the second script file which is generated in advance. Wherein the second script file is generated based on the basic information of the application program interface. Because the user can directly input configuration parameters in the script configuration interface of the application program interface, the first script file corresponding to the application program interface is obtained, and then the target script file is generated according to the second script file which is generated in advance, the user does not need to write a large amount of codes, and the development difficulty of the application program of the data service technology is reduced.

In one embodiment, the target control includes a first generation mode control and a second generation mode control.

In this embodiment, since the target control includes the first generation mode control and the second generation mode control, the user can respond to the triggering operation of the user on different target controls, and the script configuration interface corresponding to the triggering operation can be displayed to the user, so that two ways of inputting configuration parameters are provided for the user, and the flexibility of script file generation is improved.

In one embodiment, if the triggering operation is a triggering operation on the first generation mode control, the obtaining, based on the configuration parameters input by the user at the script configuration interface, the first script file corresponding to the application program interface includes:

analyzing the configuration parameters to obtain a plurality of SQL sentences corresponding to the configuration parameters;

and acquiring the first script file according to the SQL sentences.

In this embodiment, by analyzing the configuration parameters, a plurality of SQL statements corresponding to the configuration parameters can be obtained. According to the SQL sentences, the first script file can be acquired. The computer equipment can analyze the configuration parameters input by the user based on the script configuration interface, so that the first script file can be obtained, and the user does not need to write the script, namely, the transcoding-free development of the application program interface is supported, so that the development difficulty of the application program interface of the data service technology is reduced, and the universality is realized.

In one embodiment, the obtaining the first script file according to the plurality of SQL statements includes:

and assembling the SQL sentences to obtain the first script file.

In this embodiment, the first script file can be obtained by assembling the plurality of SQL statements, so that the complexity of generating the first script file is reduced. Furthermore, the development efficiency of the application program interface is improved.

In one embodiment, if the triggering operation is a triggering operation on the second generation mode control, the obtaining, based on the configuration parameters input by the user at the script configuration interface, the first script file corresponding to the application program interface includes:

and determining the configuration parameters as codes corresponding to the first script file to obtain the first script file.

In this embodiment, by determining the configuration parameters as the codes corresponding to the first script file, the first script file can be obtained, and compared with the development of the application program interface in the conventional technology, the programming of the logic codes is not required to be performed by using other computer languages, so that the development difficulty of the application program interface is reduced. And further improves the development efficiency of the application program interface.

In one embodiment, the method further comprises:

the information of the application program interface is registered with the gateway to proxy the application program interface by using the gateway.

In this embodiment, the application program interface information is registered in the gateway, so that the gateway can be used to proxy the application program interface. In the process of proxy of the application program interface, the information of the server deployed by the application program interface is not published to external users, so that the privacy is enhanced. Meanwhile, the gateway can be automatically registered, the gateway does not need to be manually configured, and the technical requirement on using the gateway by a user is reduced.

In one embodiment, the method further comprises:

and calling a management interface of the application program interface, and acquiring management operation of a user on the application program interface through the management interface of the application program interface so as to manage the application program interface.

In this embodiment, the management interface of the application program interface is invoked, and the management operation of the application program interface by the user is obtained through the management interface of the application program interface, so that the application program interface can be managed, the working performance of the application program interface is improved, and the efficiency of invoking the application program interface by the user is further improved.

In a second aspect, the present application further provides a device for generating a script file, including:

the display module is used for responding to the triggering operation of a user on a target control in the configuration interface of the application program interface and displaying a script configuration interface corresponding to the triggering operation; the triggering operation is determined by the user based on a generation mode of an application program interface to be generated;

the acquisition module is used for acquiring a first script file corresponding to the application program interface based on configuration parameters input by the user on the script configuration interface; the configuration parameters are determined by the user according to the service information of the application program interface;

the generating module is used for generating a target script file corresponding to the application program interface according to the first script file and a second script file which is generated in advance; the second script file is generated based on the basic information of the application program interface.

In a third aspect, the present application also provides a computer device comprising a memory storing a computer program and a processor implementing the steps of the method of the first aspect described above when the computer program is executed by the processor.

In a fourth aspect, the present application also provides a computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of the method of the first aspect described above.

In a fifth aspect, the present application also provides a computer program product comprising a computer program which, when executed by a processor, implements the steps of the method of the first aspect described above.

According to the script file generation method, device, equipment and storage medium, the script configuration interface corresponding to the trigger operation can be displayed by responding to the trigger operation of the user on the target control in the configuration interface of the application program interface. Wherein the triggering operation is determined by the user based on the generation mode of the application program interface to be generated. The first script file corresponding to the application program interface can be obtained based on configuration parameters input by a user in the script configuration interface. Wherein the configuration parameters are determined by the user according to the service information of the application program interface. The target script file corresponding to the application program interface can be generated according to the first script file and the second script file which is generated in advance. Wherein the second script file is generated based on the basic information of the application program interface. Because the user can directly input configuration parameters in the script configuration interface of the application program interface, the first script file corresponding to the application program interface is obtained, and then the target script file is generated according to the second script file which is generated in advance, the user does not need to write a large amount of codes, and the development difficulty of the application program of the data service technology is reduced.

Drawings

In order to more clearly illustrate the embodiments of the present application or the technical solutions in the related art, the drawings that are required to be used in the embodiments or the related technical descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and other drawings may be obtained according to the drawings without inventive effort for a person having ordinary skill in the art.

FIG. 1 is an application environment diagram of a method of generating script files in one embodiment;

FIG. 2 is a flow chart of a method for generating a script file in one embodiment;

FIG. 3 is a flow diagram of a method of generating a script file in one embodiment;

FIG. 4 is a schematic diagram of an interface in one embodiment;

FIG. 5 is a schematic illustration of an interface in another embodiment;

FIG. 6 is a flowchart of a method for generating a script file according to another embodiment;

FIG. 7 is a diagram of an example of SQL code parsing in one embodiment;

FIG. 8 is a flow diagram of the state change operation of an application program interface in one embodiment;

FIG. 9 is a flowchart of the development and management of an application program interface in one embodiment;

FIG. 10 is a block diagram of a script file generating apparatus in one embodiment;

FIG. 11 is a block diagram showing a structure of a script file generating apparatus in another embodiment;

fig. 12 is a block diagram showing a structure of a script file generating apparatus according to another embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.

Reference in the specification to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the application. The appearances of such phrases in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is to be expressly and implicitly understood by those of ordinary skill in the art that the embodiments described herein can be combined with other embodiments without conflict. Reference to "a," "an," "the," and similar terms herein do not denote a limitation of quantity, but rather denote the singular or plural. The terms "comprising," "including," "having," and any variations thereof, are intended to cover a non-exclusive inclusion, as used herein, the meaning of "plurality" is at least two, such as two, three, etc., unless expressly defined otherwise. It should be noted that the beneficial effects or the technical problems to be solved by the embodiments of the present application are not limited to this one, but may be other implicit or related problems, and particularly, reference may be made to the following description of embodiments. The following describes the technical solutions of the present application and how the technical solutions of the present application solve the above technical problems in detail with specific embodiments.

With the widespread use of big data technology, individuals, enterprises, etc. have generated a large number of data assets, which can be processed by calling the data service technology through the application program interface (Application Program Interface, API) of the data service technology in order to break the data islands and use the data assets as important production elements for promoting the social development. In the conventional technology, a large amount of business logic codes and SQL codes are required to be written to complete the development of the API. However, the conventional art has a problem in that development of an API of the data service technology is difficult.

In view of the above problems, the method for generating a script according to the embodiments of the present application may be applied to an application environment as shown in fig. 1. Fig. 1 provides a computer device, which may be a terminal, and an internal structure diagram thereof may be as shown in fig. 1. The computer device includes a processor, a memory, an input/output interface, a communication interface, a display unit, and an input means. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface, the display unit and the input device are connected to the system bus through the input/output interface. Wherein the processor of the computer device is configured to provide computing 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 a computer program. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless mode can be realized through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. The computer program, when executed by a processor, implements a method of script generation. The display unit of the computer device is used for forming a visual picture, and can be a display screen, a projection device or a virtual reality imaging device. The display screen 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, can also be a key, a track ball or a touch pad arranged on the shell of the computer equipment, and can also be an external keyboard, a touch pad or a mouse and the like.

It will be appreciated by those skilled in the art that the structure shown in fig. 1 is merely a block diagram of some of the structures associated with the present application and is not limiting of the computer device to which the present application may be applied, and that a particular computer device may include more or fewer components than shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, as shown in fig. 2, a method for generating a script file is provided, and the method is applied to the computer device in fig. 1 for illustration, and includes the following steps:

s201, responding to trigger operation of a user on a target control in a configuration interface of an application program interface, and displaying a script configuration interface corresponding to the trigger operation; the triggering operation is determined by the user based on the generation mode of the application program interface to be generated.

The target control may be a control triggering a code-free mode, or may be a control triggering an SQL mode. If the trigger operation of the code-free mode is responded, displaying a script configuration interface corresponding to the code-free mode; and if the trigger operation of the SQL mode is responded, displaying a script configuration interface corresponding to the SQL mode.

It will be appreciated that the user may configure basic information of the application program interface in the configuration interface of the application program interface, table 1 is basic information of the application program interface, and as shown in table 1, the basic information of the application program interface may include a generation mode of the application program interface, a name of the application program interface, a path, a request mode, a return type, description information of the application program interface, and the like. The generation modes of the application program interface comprise a code-free mode and an SQL mode.

In this embodiment, a user may configure basic information of an application program interface in a configuration interface of the application program interface, and based on a generation mode of the application program interface to be generated, the user may click on a target control in the configuration interface of the application program interface, and then the computer device may respond to a triggering operation of the target control in the configuration interface of the application program interface by the user, and display a script configuration interface corresponding to the triggering operation.

The user may click on the target control in the configuration interface of the application program interface based on the generation mode and the mode requirement of the application program interface to be generated, and if the mode requirement is the code-free mode, the computer device may respond to the triggering operation of the control in the code-free mode in the configuration interface of the application program interface by the user, and display the script configuration interface in the code-free mode.

TABLE 1

S202, acquiring a first script file corresponding to an application program interface based on configuration parameters input by a user in a script configuration interface; the configuration parameters are determined by the user according to the service information of the application program interface.

The service information may include basic service information parameters, advanced service information parameters, and logical information parameters, among others. The basic service information parameters may include a Data Engine (Data Engine) and a Data Engine instance (Data Engine Instance) for configuring database information and Data table information. Specifically, the basic service information parameter is used for querying a data source of an application program interface, the JDBC protocol is adopted to shield connection difference of the data source, and in the connection process, various data sources, such as a Hudi, presto, doris novel database and a MySQl, oracle, sql Server and other traditional databases, can be connected.

The advanced service information parameters may include a Cache Time (Cache Time) and a timeout Time (Time Out) that may be used to tune the performance of the application program interface. If the user configures the buffer time, when the application program interface is called, firstly reading data from the Redis middleware, and if the data cannot be read, then executing the data service logic of the application program interface, storing the read data into the Redis middleware and setting the buffer time. In addition, each time the application program interface is executed, a new thread is started to execute the data service logic of the application program interface, the overtime time of the thread is set, and if the execution time is longer than the overtime time, the system performs error reporting. And the cache of the calling result of the application program interface is supported, and the capability of the application program interface is improved.

The logic information parameters may include request parameter information, return parameter information, and ordering parameter information. And the overtime limiting measure when the application program interface is operated reduces the condition that the system resources are excessively occupied and crashed. The configuration parameters may include paging information, database information, data table information, request parameter information, return parameter information, and ordering parameter information. Alternatively, the configuration parameters may also be in the form of SQL code.

In this embodiment, the computer device responds to a triggering operation of the user on the target control in the configuration interface of the application program interface, and after the script configuration interface corresponding to the triggering operation is displayed, the user may input configuration parameters in the script configuration interface. If a script configuration interface without a code mode is displayed, a user can input paging information, database information and data table information in the script configuration interface according to information included in service information of an application program interface. And inputting request parameter information, return parameter information and ordering parameter information according to the fields of the data in the paging information and the data table information. And then analyzing the request parameter information, the return parameter information and the ordering parameter information to obtain a first script file corresponding to the application program interface. If a script configuration interface in the SQL mode is displayed, the user can input paging information, database information and data table information in the script configuration interface according to information included in service information of the application program interface. According to the paging information and the fields of the data in the data table information, the computer equipment can acquire the input SQL code and take the SQL code as a first script file.

It should be noted that, if the code-free mode is adopted, when the user configures the request parameter information, the data fields in the data table of the database and the request parameters are bound in the computer device. The parameter name of the request parameter may be different from the data field name. The user may also annotate operations with operators, whether options are necessary, etc. to represent the screening logic, where fields in the screening logic are binding fields and values of the screening logic are binding parameter values. Specifically, the parameter design of the user configuration request parameter is shown in table 2.

When the user configures the return parameter (response epaaram) information, the computer device may bind the data field in the data table of the database with the return parameter name, and the parameter name of the return parameter may be inconsistent with the data field name, so as to achieve the function of alias for the selected field, and increase flexibility. Specifically, the parameter design of the user-configured return parameters is shown in table 3.

When a user configures ordering parameter (OrderParam) information, the field name of the required ordering and ordering mode (Sort) need to be configured, and the ordering mode comprises ascending order ordering (ASC) and descending order ordering (DESC).

TABLE 2

TABLE 3 Table 3

S203, generating a target script file corresponding to the application program interface according to the first script file and a pre-generated second script file; the second script file is generated based on the basic information of the application program interface.

The second script file may be pre-generated based on basic information of a user configuring the application program interface in a configuration interface of the application program interface.

In this embodiment, the computer device may generate the target script file corresponding to the application program interface according to the first script file, the second script file generated in advance, and the preset script generation rule. Optionally, the first script file and the pre-generated second script file may be combined according to a preset combination rule, and the target script file corresponding to the application program interface is obtained after the combination.

In one embodiment, the target controls include a first generation mode control and a second generation mode control.

In this embodiment, when the first script file is generated according to the configuration parameters, the first script file may be generated based on two different configuration interfaces, so that the target control may also correspond to two types, respond to the triggering operation of the different controls, display different pages to perform configuration, and generate the first script file based on the configured configuration parameters.

The first generation mode control may be a control without a code mode, and the script configuration interface corresponding to the code-free mode is displayed in response to a triggering operation of the control without the code mode. And generating a first script file based on configuration parameters input by a user on a script configuration interface corresponding to the code-free mode. The second generation mode control can be an SQL mode control, and the script configuration interface corresponding to the SQL mode is displayed in response to the triggering operation of the SQL mode control. And generating a first script file based on configuration parameters input by a user in a script configuration interface corresponding to the SQL mode.

In the scenario of acquiring the first script file corresponding to the application program interface based on the configuration parameters input by the user in the script configuration interface, after the first generation mode control is triggered, the configuration information is analyzed based on the configuration information input by the user, so as to obtain the first script file. The first script file may also be determined based on configuration information entered by the user after the second generation mode control is triggered. The following will describe the detailed procedures of these two first script files corresponding to the acquired application program interfaces respectively:

first, as an alternative embodiment, as shown in fig. 3, if the triggering operation is a triggering operation on the first generation mode control, S202 includes:

s301, analyzing the configuration parameters to obtain a plurality of SQL sentences corresponding to the configuration parameters.

The configuration parameters may include paging information, database information, data table information, request parameter information, return parameter information, and ordering parameter information, among others.

In this embodiment, the user selects the first generation mode control on the configuration interface, and the computer device may respond to the selection operation of the user on the first generation mode control to display the script configuration interface corresponding to the code-free mode. The script configuration interface corresponding to the code-free mode is shown in fig. 4, the user selects the configuration parameters in the script configuration interface, and after the computer obtains the selection operation triggered by the configuration parameters in the script configuration interface, the configuration parameters such as page splitting information, database information, data table information, request parameter information, return parameter information, ordering parameter information and the like can be analyzed according to the preset analysis rule to obtain the SQL statement corresponding to each configuration parameter.

It should be noted that, for the analysis of the configuration parameters, the preset analysis rule corresponding to each configuration parameter may be different. The pagination information may generate a corresponding paginated SQL script according to an SQL Dialect (SQL Dialect). For example, if the selected data source is Mysql, the SQL statement corresponding to the paging information may be limit $ { limit }, offset $ { offset }. The data table information in the database can be used as a queried table after being put into the from keyword. For example, if the table name is student, the SQL statement corresponding to the data table information may be from student. When the request parameter information is unnecessary, a dynamic SQL tag < if > mode can be used to bracket the query logic for querying the parameter. The operator of each request parameter, the request parameter name, the request field name may constitute a screening condition, and the screening conditions are connected by an and. For example, if the name of the request parameter information is student, the operator is }, the name of the request field is student_age, and the filter logic SQL statement may be student_age $ { student age }. When the return parameter is parsed, a select statement may be generated, the return field name being concatenated with the return parameter name with an as key. For example, the field name is student_name, the name of the return parameter information is student_name, and the generated SQL statement may be student_ name as studentName. When the ordering parameter information is analyzed, an order by statement can be formed. For example, if the ordering field is student_id and the ordering mode is desc, the corresponding SQL is order by student_id desc. In addition, in the embodiment, the configuration parameters can be flexibly configured, analysis of dynamic parameters is supported, and the query service logic and the parameter names of the return values are dynamically changed according to the existence of the parameters.

S302, acquiring a first script file according to a plurality of SQL sentences.

In this embodiment, the first script file may be generated according to a preset script generating rule and SQL statements corresponding to a plurality of configuration parameters.

As an alternative embodiment, acquiring a script file according to a plurality of SQL statements includes:

and assembling the SQL sentences to obtain a first script file.

In this embodiment, the computer device may assemble the SQL statements corresponding to the plurality of configuration parameters according to a preset assembly rule of the SQL statements, so as to obtain the first script file.

Second, as another alternative embodiment, if the triggering operation is a triggering operation on the second generation mode control, S202 is as follows: comprising the following steps:

Wherein the second generation mode control may be an SQL mode control.

In this embodiment, the user selects the second generation mode control on the configuration interface, and the computer device may respond to the selection operation of the user on the second generation mode control to display the script configuration interface corresponding to the SQL mode. The script configuration interface corresponding to the SQL mode is shown in FIG. 5. The user inputs the SQL code in the script configuration interface, and the computer equipment can acquire the SQL code input by the user in the script configuration interface, determine the SQL code as the code of the first script file and obtain the first script file.

It can be understood that, as shown in fig. 6, if the user selects the code-free mode on the configuration interface, the user performs the script configuration interface corresponding to the code-free mode, selects paging information, database information, data table information, request parameter information, return parameter information, ordering parameter information, and the like, and after the configuration is completed, parses the configuration parameters into the first script file. If the user selects the SQL mode in the configuration interface, the user performs a script configuration interface corresponding to the SQL mode and fills in an SQL code to obtain a first script file. It should be noted that, after the user fills out the SQL code, the user may choose to parse the SQL code to obtain the request parameter information and the return parameter information, so as to be used when the user invokes the application program interface after the application program interface is published. An example of parsing an SQL code can refer to FIG. 7, where the SQL code can be parsed into a syntax Tree Sql Tree, where each word in the SQL code is interpreted as each node, and the selected set of fields is called Select Elements, and the selected fields are called Select Elements. Selected are Select Elements in the SQL state of the first layer in the SQL code. The request parameter information of the user can be wrapped by using $ { for example, if the request parameter information is id, the writing mode of the id in the SQL code is $ { id }, and the id can be identified as the parameter requested by the user during the character string scanning. For analysis of the return parameter information, when the Sql State exists AS characters, selecting the name behind the AS AS the name of the return parameter information. Because the SQL codes can be selected to be analyzed after the user fills out the SQL codes, the request parameter information and the return parameter information are obtained, so that the SQL codes can be used when the user calls the application program interface after the application program interface is released, the problem that the steps of manually configuring the request parameter information and the return parameter information are needed in the SQL codes in the prior art is solved, and the efficiency of calling the application program interface by the user is improved.

In some scenarios, the generated application program interface may also be proxied to improve the stability of the API when the client interacts with the server where the application program interface is deployed. In one embodiment, the method further comprises: information of the application program interface is registered with the gateway to proxy the application program interface by using the gateway.

The gateway may be an Apache ShenYu gateway.

In this embodiment, after the target script file corresponding to the application program interface is published, the information of the application program interface may be registered in the Apache ShenYu gateway, and the gateway proxies the application program interface in a matching manner. The proxy is a reverse proxy, i.e. the information of the server deployed by the application program interface is not published to external users in the process of proxy of the application program interface.

For example, the gateway proxy object may be taken as a micro-service object in a Nacos, the plug-in of Apache Shunyu used is SpringCloud, metaData to complete the registration function, the selector in the SpringCloud plug-in is the same as and unique to the name of the rule, the name value is the full Path of the API, the values of AppName and Path in the MetaData plug-in are all paths of the API, and the RPCType value is SpringCloud. The selector, rule association of an API with a SpringCloud, metaData plug-in Apache ShenYu is a key with the full path of the API as an association. The gateway can be automatically registered without manually configuring the gateway, and the technical requirement for using the gateway by a user is reduced.

It should be noted that, after the first script file is generated, the first script file may be tested. After the target script file is generated, the target script file can be tested to verify the correctness of the target script file. The verification method can be as follows: the test user inputs parameters to the target script file, the target script file generates a complete SQL sentence according to the input parameters, the SQL sentence is executed in a database by connecting the Java language with the database (Java DataBase Connectivity, JSBC), and when the result meets the expectations, the test is passed. The release can be performed after the test is passed. After release, the application program interface is not in the on-shelf state and needs to be set by the user on the management interface.

In one embodiment, the method further comprises: and calling a management interface of the application program interface, and acquiring management operation of the application program interface by a user through the management interface of the application program interface so as to manage the application program interface.

In this embodiment, the computer device may display the management interface to the user by calling the management interface of the application program interface, and the user may trigger a management operation of the application program interface in the management interface to manage the on-shelf state and the off-shelf state of the application program interface.

The management interface includes a first management interface and a second management interface, the user may include a development user and an audit user, the development user may trigger a selection operation of the loading request in the first management interface, the audit user may click an agreement control in the second management interface, so as to respond to the loading request of the development user, perform the loading operation on the application program interface, and set a state of the application program interface to be a loading state.

Specifically, the operations of the application program interface may include an enabling operation, a disabling operation, an up operation, a down operation, and a down operation. Wherein the operation of the application program interface determines the operation that can be performed by the user who uses the application program interface later. The system can be designed into a loading stop state, a loading start state, a non-loading state and a non-release state. When the state is on-shelf enabled, the application program interface can be seen by a calling party but cannot be called, and the available operation is enabled and off-line at the moment; when the state is that the on-shelf is disabled, the application program interface can be seen by a calling party and can be called, and the available operation is disabled and off-line at the moment; when the state is not on shelf, the application program interface cannot be seen by a calling party and cannot be called, and when the state is not released, the available operation is on shelf and off line, which means that the application program interface is still in the flow of the application program interface development module, and the application program interface can be released after the test is passed. The application program interface after the pop-up operation can present records in an application program interface Market (application program interface mark) for a caller to browse and view. The status field of the application program interface is shown in table 4. The state change operation flow of the application program interface is shown in fig. 8.

TABLE 4 Table 4

It should be noted that, the authorization relationship generated when the Application program interface authorizes the outside is managed by an Application program (APP), the APP is associated with a user, and one user may have a plurality of APPs, where the APP includes an Application code (app_code) and an association relationship list between the Application program interface and the APP, that is, an Application program interface_app_association. One APP corresponds to one application code, and the application codes are used for verifying the authority of the application program interface when being called, and playing the role of a token, so that the calling authority of the granularity of a user is controlled, the application codes need to be placed in a request header when the user calls the application program interface, and the parameter name of the request header when the user calls the application program interface is APP code. The association relationship indicates that the application program interface can be called in the application program, and the association relationship includes an expiration time (valid_time) field in the format of "MM fraction s seconds at yyyy year MM month dd day HH" for specifying that the application program interface can be called before the expiration time. The existing authorization relationship can be managed in a unified way, and specifically, the application program of the user, the association relationship between the application program interface and the APP and the addition, deletion and modification operation can be managed.

By way of example, the checking of rights occurs when an application program interface is invoked, and the logic of the rights check may be: firstly, acquiring an app code in a request header, judging whether the app code is empty, inquiring an application program according to the app code if the app code is not empty, then determining whether the application program exists, if all application program interfaces related to a reference program are inquired, matching the application program interfaces, determining whether the application program interfaces can be matched, if so, inquiring the application program interfaces to authorize, determining whether the application program interfaces are in a starting state, if yes, determining whether the current time is greater than the expiration time, and if not, detecting passing. In any of the above-described determined branches, if the condition check failure is not satisfied, a check failure abnormality is displayed at the interface. The method solves the problem of overlarge granularity of authority management and control of application program interface call in the prior art. The calling authority of the application program interface can be flexibly configured.

As shown in fig. 9, a development and management flow of an application program interface is provided, basic API information can be configured according to development requirements, data service information is reconfigured, a script is generated, the script is tested, after the test passes, the application program interface is released, a gateway is registered again, interface management is performed, loading of the API is completed, and application and authorization are managed and checked.

An embodiment of the present disclosure is described below in connection with a specific script file generation scenario, the method comprising the steps of:

s1, responding to triggering operation of a user on a target control in a configuration interface of an application program interface, and displaying a script configuration interface corresponding to the triggering operation.

S2, if the triggering operation is the triggering operation of the first generation mode control, analyzing the configuration parameters, obtaining a plurality of SQL sentences corresponding to the configuration parameters, and assembling the SQL sentences to obtain a first script file.

And S3, if the triggering operation is the triggering operation of the second generation mode control, determining the configuration parameters as codes corresponding to the first script file, and obtaining the first script file.

And S4, registering the information of the application program interface to the gateway so as to proxy the application program interface by using the gateway.

S5, calling a management interface of the application program interface, and acquiring management operation of the application program interface by a user through the management interface of the application program interface so as to manage the application program interface.

It should be understood that, although the steps in the flowcharts related to the above embodiments are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.

Based on the same inventive concept, the embodiment of the application also provides a script file generating device for realizing the script file generating method. The implementation of the solution provided by the device is similar to the implementation described in the above method, so the specific limitation in the embodiment of the generating device of one or more script files provided below may refer to the limitation of the generating method of the script file hereinabove, and will not be repeated herein.

In one embodiment, as shown in fig. 10, there is provided a script file generating apparatus, including: a display module 11, an acquisition module 12 and a generation module 13, wherein:

the display module 11 is used for responding to the triggering operation of a user on a target control in the configuration interface of the application program interface and displaying a script configuration interface corresponding to the triggering operation; the triggering operation is determined by the user based on the generation mode of the application program interface to be generated.

The acquiring module 12 is configured to acquire a first script file corresponding to the application program interface based on configuration parameters input by a user at the script configuration interface; the configuration parameters are determined by the user according to the service information of the application program interface.

The generating module 13 is configured to generate a target script file corresponding to the application program interface according to the first script file and a second script file that is generated in advance; the second script file is generated based on the basic information of the application program interface.

In one embodiment, as shown in fig. 11, if the trigger operation is a trigger operation on the first generation mode control, the acquiring module 12 includes: a first acquisition unit 121 and a second acquisition unit 122, wherein:

The first obtaining unit 121 is configured to parse the configuration parameter to obtain a plurality of SQL statements corresponding to the configuration parameter.

The second obtaining unit 122 is configured to obtain the first script file according to the plurality of SQL statements.

In one embodiment, the second obtaining unit 122 is specifically configured to assemble a plurality of SQL statements to obtain the first script file.

In one embodiment, as shown in fig. 12, if the trigger operation is a trigger operation on the second generation mode control, the obtaining module 12 includes a determining unit 123, where:

the determining unit 123 is configured to determine the configuration parameter as a code corresponding to the first script file, and obtain the first script file.

In one embodiment, the script file generating device further includes: registration module 14, wherein:

a registration module 14, configured to register information of the application program interface with the gateway, so as to proxy the application program interface with the gateway.

In one embodiment, the script file generating device further includes: call module 15, wherein:

and the calling module is used for calling the management interface of the application program interface, and acquiring the management operation of the application program interface by a user through the management interface of the application program interface so as to manage the application program interface.

The above-described respective modules in the script file generating apparatus may be implemented in whole or in part by software, hardware, or a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.

In one exemplary embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of:

responding to the triggering operation of a user on a target control in a configuration interface of an application program interface, and displaying a script configuration interface corresponding to the triggering operation; triggering operation is determined for a user based on a generation mode of an application program interface to be generated;

acquiring a first script file corresponding to an application program interface based on configuration parameters input by a user in a script configuration interface; the configuration parameters are determined by the user according to the service information of the application program interface;

generating a target script file corresponding to an application program interface according to the first script file and a pre-generated second script file; the second script file is generated based on the basic information of the application program interface.

In one embodiment, the processor when executing the computer program further performs the steps of:

if the triggering operation is the triggering operation of the first generation mode control, analyzing the configuration parameters to obtain a plurality of SQL sentences corresponding to the configuration parameters;

and acquiring a first script file according to the SQL sentences.

and assembling the SQL sentences to obtain a first script file.

if the triggering operation is the triggering operation of the second generation mode control, determining the configuration parameters as codes corresponding to the first script file, and obtaining the first script file.

information of the application program interface is registered with the gateway to proxy the application program interface by using the gateway.

and calling a management interface of the application program interface, and acquiring management operation of the application program interface by a user through the management interface of the application program interface so as to manage the application program interface.

In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:

In one embodiment, the computer program when executed by the processor further performs the steps of:

And acquiring a first script file according to the SQL sentences.

and assembling the SQL sentences to obtain a first script file.

In one embodiment, a computer program product is provided comprising a computer program which, when executed by a processor, performs the steps of:

and acquiring a first script file according to the SQL sentences.

and assembling the SQL sentences to obtain a first script file.

Those skilled in the art will appreciate that implementing all or part of the above-described methods in accordance with the embodiments may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed may comprise the steps of the embodiments of the methods described above. Any reference to memory, database, or other medium used in the various embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the various embodiments provided herein may include at least one of relational databases and non-relational databases. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processors referred to in the embodiments provided herein may be general purpose processors, central processing units, graphics processors, digital signal processors, programmable logic units, quantum computing-based data processing logic units, etc., without being limited thereto.

The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.

The foregoing examples represent only a few embodiments of the present application, which are described in more detail and are not thereby to be construed as limiting the scope of the present application. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application shall be subject to the appended claims.

Claims

1. A method for generating a script file, the method comprising:

2. The method of claim 1, wherein the target control comprises a first generation mode control and a second generation mode control.

3. The method of claim 2, wherein, if the triggering operation is a triggering operation on the first generation mode control, the obtaining, based on the configuration parameters input by the user at the script configuration interface, a first script file corresponding to the application program interface includes:

and acquiring the first script file according to the SQL sentences.

4. The method of claim 3, wherein the obtaining the first script file from the plurality of SQL statements comprises:

and assembling the SQL sentences to obtain the first script file.

5. The method of claim 2, wherein, if the triggering operation is a triggering operation on the second generation mode control, the obtaining the first script file corresponding to the application program interface based on the configuration parameters input by the user at the script configuration interface includes:

6. The method according to any one of claims 1 to 5, further comprising:

registering the information of the application program interface to a gateway so as to proxy the application program interface by using the gateway.

7. The method according to any one of claims 1 to 5, further comprising:

8. A script file generation apparatus, the apparatus comprising:

The generation module is used for generating a target script file corresponding to the application program interface according to the first script file and a second script file which is generated in advance; the second script file is generated based on the basic information of the application program interface.

9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.

10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.