WO2018188342A1

WO2018188342A1 - Method, apparatus and device for generating script file, and computer-readable storage medium

Info

Publication number: WO2018188342A1
Application number: PCT/CN2017/111881
Authority: WO
Inventors: 张义德
Original assignee: 平安科技（深圳）有限公司
Priority date: 2017-04-13
Filing date: 2017-11-20
Publication date: 2018-10-18
Also published as: CN107688593A

Abstract

Disclosed is a method for generating a script file. The method comprises: when an instruction for generating a script file is received, creating a table on a pre-set interface by means of a pre-set script generation tool; defining configuration information in the created table; and according to the configuration information defined in the table, and a script program template corresponding to the table, generating a script file. Further disclosed are an apparatus and device for generating a script file, and a computer-readable storage medium. A script file generated in the present application conforms to standards. Even if the script file needs to be subsequently modified, only the configuration information in a table needs to be modified, thus improving the efficiency and intelligence of the generation of the script file.

Description

Script file generation method, device, device and computer readable storage medium

The present application claims the priority of the Chinese Patent Application, filed on Apr. 13, 2017, the application Serial No.

Technical field

The present application relates to the field of computer application technologies, and in particular, to a script file generation method, apparatus, device, and computer readable storage medium.

Background technique

At present, the database design is basically designed by the developer, manually written, and then submitted to the appropriate test personnel for inspection.

However, there are often the following problems: Because the database design is not standardized, if there are some relatively low-level errors during the execution of the script, and the test has problems, you need to go back and adjust the design, re-edit the script code, and re-execute. Because this process requires a lot of content to be manually rewritten, it takes a lot of time, resulting in low efficiency of script file generation and poor intelligence of the generation method.

Summary of the invention

The main purpose of the present application is to provide a script file generation method, apparatus, device, and computer readable storage medium, which aim to solve the technical problem of the existing script file generation method, low efficiency, and poor intelligence.

To achieve the above objective, the present application provides a script file generating method, where the script file generating method includes:

When receiving the generation instruction of the script file, the preset script generation tool creates a form on the preset interface;

Define configuration information in the established form;

A script file is generated according to the configuration information defined in the table and the script template corresponding to the table.

In addition, in order to achieve the above object, the present application further provides a script file generating apparatus, where the script file generating apparatus includes:

Establishing a module, configured to create a table in a preset interface by using a preset script generation tool when receiving a script file generation instruction;

a definition module for defining configuration information in the created table;

And a generating module, configured to generate a script file according to the configuration information defined in the table, and the script program template corresponding to the table.

In addition, in order to achieve the above object, the present application further provides a script file generating device, the script file generating device including a processor, and a memory storing a program generated by the script file; the processor is configured to execute the script file generation Program to implement the steps of the script file generation method as described above.

In addition, in order to achieve the above object, the present application further provides a computer readable storage medium storing a script file generating program, the script file generating program being executed by a processor to implement as described above The steps of the script file generation method.

The script file generating method proposed by the present application firstly establishes a form in a preset interface by using a preset script generating tool when receiving a script file generating instruction, and then defines configuration information in the created table, and then according to the definition in the table. The configuration information, and the script template corresponding to the table, generate a script file. The script file is generated by the configuration information in the table and the script template corresponding to the table, and the generated script file conforms to the specification. Even if the script file is to be modified later, the configuration information in the table can be modified, and the code in the script template is Fragments do not need to be written again, improving the efficiency and intelligence of script file generation.

DRAWINGS

1 is a schematic flowchart of a first embodiment of a method for generating a script file according to the present application;

2 is a schematic diagram of a refinement process of step S20 in FIG. 1;

3 is a schematic diagram of a refinement process of step S30 in FIG. 1;

4 is a schematic flowchart of a second embodiment of a method for generating a script file according to the present application;

5 is a schematic diagram of functional modules of a first embodiment of a script file generating apparatus of the present application;

6 is a schematic diagram of a refinement function module of the module 20 defined in FIG. 5;

7 is a schematic diagram of a refinement function module of the generation module 30 in FIG. 5;

8 is a schematic diagram of functional modules of a second embodiment of a script file generating apparatus of the present application;

FIG. 9 is a schematic structural diagram of a device in a hardware operating environment according to an embodiment of the present application.

The implementation, functional features and advantages of the present application will be further described with reference to the accompanying drawings.

detailed description

It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting.

The solution of the embodiment of the present application is mainly: when receiving the generation instruction of the script file, first establishing a table in the preset interface by using a preset script generation tool, and then defining configuration information in the established table, and then defining according to the table The configuration information, and the script template corresponding to the table, generate a script file. The generation of the script file is implemented by the configuration information in the table and the script template corresponding to the table, and the generated script file conforms to the specification. Even if the script file is to be modified later, the configuration information in the table can be modified, and the script template is The code snippet does not need to be written again, and solves the problem of the existing script file generation method, low efficiency, and poor intelligence.

The application provides a script file generation method.

Referring to FIG. 1, FIG. 1 is a schematic flowchart of a preferred embodiment of a script file generating method according to the present application.

In this embodiment, the script file generating method includes:

When receiving the generation instruction of the script file, the preset script generation tool creates a table in the preset interface; defines the configuration information in the established table; according to the configuration information defined in the table, and the script template corresponding to the table , generate a script file.

In this embodiment, the script file generating method is preferably implemented by the terminal by using a preset script generating tool, and the script generating tool may be a DB (Database) tool, and the script file generating tool of the present application is completed by the script generating tool. process.

The following are the specific steps for implementing the script file generation in this embodiment:

Step S10, when receiving the generation instruction of the script file, creating a form on the preset interface by using a preset script generation tool;

In this embodiment, when receiving the generation instruction of the script file, the preset application is invoked by the preset script generation tool to create a table in the preset interface of the preset application. In this embodiment, the preset The interface is preferably an interface of an Excel application, and correspondingly, the created form is an Excel spreadsheet.

Step S20, defining configuration information in the established table;

After the table is created in the preset interface, the configuration information is defined in the established table. In this embodiment, the configuration information may be configuration information defined by the terminal system, or may be input by the terminal system and the user in the table. The configuration information is defined together, and the specific configuration information needs to be defined, depending on the actual situation. The configuration information defined by the terminal system is defined by the system by default, and the configuration information input by the user is input according to the actual needs of the user. Preferably, after the form is established, if the configuration information input by the user is received, the configuration information input by the user and the configuration information of the terminal system can be defined into the table. If the configuration information input by the user is not received, The configuration information defined by the terminal system is directly adopted.

The information defined by the terminal system includes: a database associated with the table, and a standard authorization file associated with the table; wherein the database is used to determine the specific type of the script template corresponding to the form, and the standard authorization file is used to determine the generation rules of the script file, and the script file The generation rules mainly include: the length of the field in the script file and the access permission of the script file. For example, the script file can only be viewed, cannot be added or deleted, or can only be viewed and added, and cannot be deleted. The configuration information input by the user includes: user information, synonym user information, triggers, and the like; wherein the user information and the synonym user information are used to distinguish different users, to grant different access rights to different users, and the trigger is used to record the script. Traces of modifications to the file. Of course, the database and standard authorization file associated with the above mentioned table can also be modified by the user according to actual needs.

Specifically, referring to FIG. 2, the step S20 includes:

Step S21, associating a database in the established table;

Step S22, establishing user information and synonym user information for the associated database in the table, so that different users have different access rights;

In step S23, a trigger is created in the table to record the modification trace of the script file based on the created trigger.

That is, after the table is created, the table is associated with the preset database. In this embodiment, the system may be associated with the default database at the beginning, and may be added according to actual needs to be associated with other databases. The addition mode can be implemented by the user adding a database identification information in the preset area of the table to associate the table to the new database. For example, the database initially associated with the table is LBS and ELIS, and the display form is:

Database: LBS ELIS

Subsequent addition of one more database d0lucd0 according to actual needs, then it is necessary to add one more to the database associated in advance in the preset area, that is, the operation of associating the prior data is:

Execute the script database: LBS

ELIS

When adding a database to the default area, the operation is:

Execute the script database: LBS

ELIS

D0lucd0

Then, the final form of the data table is displayed as:

Database: LBS ELIS d0lucd0

It should be understood that the table in this embodiment is a normalized table, which can be mapped to a script template by using the script generation tool mentioned above, but since the script template to which the table is mapped is the same, The generated script files are different. Therefore, the script template corresponding to the table can be further determined by the database associated with the table, that is, the table is associated with different databases, and the attribute information generated in each database is different, and finally generated. The script template will also be different. In this embodiment, a table can be associated with multiple databases, and finally multiple script templates can be obtained.

After the table is associated with the preset database, user information and synonym user information are established in the associated database in the table, and different users are authorized to have different access rights for different users. For example, when a developer develops a script file through a form, the user information set under a certain database is “Zhang Sheng”, and then a synonym user information is set to “Zhang San”, and the “Zhang Sheng” permission is Viewing the specific data in this form, adding, deleting, and modifying, and "Zhang San" is information that tells other users to visit, such as the user information that informs the tester to view, "Zhang San" has the right to view information, and cannot add or delete the table. data. It should be understood that "Zhang Sheng" and "Zhang San" are the same object, setting user information and synonym information for the same object, and setting unused rights for user information and synonym information, so that developers and other personnel such as testers There are two different access rights for this object, which realizes the protection of the data in the table, prevents other people from changing the data in the table, and causes the script file generated subsequently to be incorrect, thus ensuring the security of the information.

In addition, a trigger can be created in the created table to subsequently record the modified trace of the script file based on the created trigger. In this embodiment, a trigger is created in the created table, so that the modification trace of the script file is recorded based on the created trigger, and the trace of each modification, as well as the specific modified content and the modification time, can be triggered. Record, easy to know the modification of the data in the table, better analysis.

After the configuration information is defined in the established table, the script template corresponding to the table may be determined according to the associated database in the table, and the configuration of the related information of the subsequently generated script file is completed.

Step S30, generating a script file according to the configuration information defined in the table and the script program template corresponding to the table.

According to the database associated with the table, the script template has been obtained, and combined with the configuration information defined by the terminal system in the table and the configuration information input by the user, the configuration information is specifically added to the script template to generate a script file.

Specifically, referring to FIG. 3, the step S30 includes:

Step S31, extracting a script file generation rule from a standard authorization file stored in a preset directory;

Step S32, generating a script file according to the extracted script file generation rule, the configuration information defined in the table, and the script program template corresponding to the table.

In this embodiment, after determining the configuration information defined in the table, the script template corresponding to the table, the generation rule of the script file may be further extracted from the standard authorization file stored in the preset directory, for example, the script file is only viewed. The certain fields are inherently invariant, cannot be modified, and the like, and then generate a script file according to the generated rules of the generated script file, the configuration information defined in the table, and the corresponding script template of the skin label.

Further, the script file generating method further includes:

When the modification instruction of the standard authorization file is detected, determining a location of the standard authorization file to be modified in the preset directory;

Replace the determined location with a placeholder and add a new script file generation rule in the determined location.

The script file generating method in the embodiment, when receiving the script file generating instruction, first establishes a table in a preset interface by using a preset script generating tool, and then defines configuration information in the created table, and then defines according to the table. The configuration information, and the script template corresponding to the table, generate a script file. The script file is generated by the configuration information in the table and the script template corresponding to the table, and the generated script file conforms to the specification. Even if the script file is to be modified later, the configuration information in the table can be modified, and the code in the script template is Fragments do not need to be written again, improving the efficiency and intelligence of script file generation.

Further, a second embodiment of the method for generating a script file of the present application is proposed based on the first embodiment. In this embodiment, referring to FIG. 4, after the step S30, the method further includes:

Step S40, when receiving the running instruction of the script file, calling the database associated with the table to run the script file to implement testing of the script file;

In step S50, when it is detected that the script file is incorrect, the prompt information is output, wherein the manner of outputting the prompt information includes outputting in a position with an error in the table, or popping up the prompt window to output an error information.

In this embodiment, when receiving the running instruction of the script file, first calling the database associated with the table to run the script file, that is, by calling the database, traversing the database to run the script file, and detecting If no error is reported during the running of the script file, the generated script file is considered to be accurate. If the script file is detected to be incorrect, the prompt information is output to prompt the script file to be incorrect, and the manner of outputting the prompt information may be The position of the table is incorrectly output, and the prompt window may output a message with an error.

In this embodiment, in order to ensure the accuracy of the data test, before the step S40, the method includes:

Upon receiving the handover instruction of the script file, the generated script file is handed over to the preset storage path for subsequent execution of the script file;

That is, the script file is first handed over to the preset storage path, so that the script file is tested in the storage path, and the test is not performed on the interface for generating the script file, thereby affecting the test of the script file, thereby improving the script. The accuracy of the document test.

It should be noted that those skilled in the art can understand that all or part of the steps of implementing the above embodiments may be completed by hardware, or may be instructed by a program to execute related hardware, and the program may be stored in a computer readable state. In the storage medium, the above-mentioned storage medium may be a read only memory, a magnetic disk or an optical disk or the like.

The application further provides a script file generating apparatus.

Referring to FIG. 5, FIG. 5 is a schematic diagram of functional modules of a preferred embodiment of the script file generating apparatus 100 of the present application.

It should be emphasized that, for those skilled in the art, the functional block diagram shown in FIG. 5 is merely an exemplary diagram of a preferred embodiment, and those skilled in the art surround the functional modules of the script file generating apparatus 100 shown in FIG. 5. The function modules of the present invention can be easily supplemented by the new function modules. The names of the function modules are used to assist in understanding the various program function blocks of the script file generating apparatus 100, and are not used to limit the technical solutions of the present application. At the heart of the solution is the functionality to be achieved by the functional modules that each define the name.

In this embodiment, the script file generating apparatus 100 includes:

Establishing a module, configured to: when the script generation instruction is received, create a table in the preset interface by using a preset script generation tool; define a module, configured to define configuration information in the established table; and generate a module, according to the table The configuration information defined in the template, and the script template corresponding to the table, generate a script file.

In this embodiment, the script file generating apparatus is preferably implemented by the terminal by using a preset script generating tool, and the script generating tool may be a DB (Database) tool, and the script file generating tool of the present application is completed by the script generating tool. process.

The following are the specific functions of each module that implements script file generation in this embodiment:

The establishing module 10 is configured to: when receiving the generating instruction of the script file, create a table in the preset interface by using a preset script generating tool;

In this embodiment, when the generating instruction of the script file is received, the establishing module 10 calls the preset application by using the preset script generating tool to create a table in the preset interface of the preset application. In this embodiment, the The preset interface is preferably an interface of an Excel application, and correspondingly, the created form is an Excel spreadsheet.

Wherein, the definition module 20 is configured to define configuration information in the established table;

After the table is created in the preset interface, the definition module 20 defines the configuration information in the established table. In this embodiment, the configuration information may be configuration information defined by the terminal system, or may be the terminal system and the user. The configuration information entered in the table is defined together, and the specific configuration information needs to be defined, depending on the actual situation. The configuration information defined by the terminal system is defined by the system by default, and the configuration information input by the user is input according to the actual needs of the user. Preferably, after the form is established, if the configuration information input by the user is received, the configuration information input by the user and the configuration information of the terminal system can be defined into the table. If the configuration information input by the user is not received, The configuration information defined by the terminal system is directly adopted.

Specifically, referring to FIG. 6, the definition module 20 includes:

An association unit 21, configured to associate a database in the established table;

The establishing unit 22 is configured to establish user information and synonym user information in the table for the associated database, so that different users have different access rights;

A creating unit 23 is configured to create a trigger in the table to record a modification trace of the script file based on the created trigger.

That is, after the table is created, the association unit 21 associates the table to the preset database. In this embodiment, the system may be associated with the default database at the beginning, and may be added according to actual needs to be associated with other databases. The specific addition method can be implemented by the user adding a database identification information in the preset area of the table, so that the table is associated with the new database. For example, the database initially associated with the table is LBS and ELIS, and the display form is:

Database: LBS ELIS

Execute the script database: LBS

ELIS

When adding a database to the default area, the operation is:

Execute the script database: LBS

ELIS

D0lucd0

Then, the final form of the data table is displayed as:

Database: LBS ELIS d0lucd0

After the table is associated with the preset database, the establishing unit 22 establishes user information and synonym user information for the associated database in the table, and authorizes different users so that different users have different access rights. For example, when a developer develops a script file through a form, the user information set under a certain database is “Zhang Sheng”, and then a synonym user information is set to “Zhang San”, and the “Zhang Sheng” permission is Viewing the specific data in this form, adding, deleting, and modifying, and "Zhang San" is information that tells other users to visit, such as the user information that informs the tester to view, "Zhang San" has the right to view information, and cannot add or delete the table. data. It should be understood that "Zhang Sheng" and "Zhang San" are the same object, setting user information and synonym information for the same object, and setting unused rights for user information and synonym information, so that developers and other personnel such as testers There are two different access rights for this object, which realizes the protection of the data in the table, prevents other people from changing the data in the table, and causes the script file generated subsequently to be incorrect, thus ensuring the security of the information.

In addition, the creation unit 23 can also create a trigger in the created table to subsequently record the modification trace of the script file based on the created trigger. In this embodiment, a trigger is created in the created table, so that the modification trace of the script file is recorded based on the created trigger, and the trace of each modification, as well as the specific modified content and the modification time, can be triggered. Record, easy to know the modification of the data in the table, better analysis.

The generating module 30 is configured to generate a script file according to the configuration information defined in the table and the script program template corresponding to the table.

The script template is obtained according to the database associated with the table. The generating module 30 further adds the configuration information to the script template in combination with the configuration information defined by the terminal system in the table and the configuration information input by the user to generate a script. file.

Specifically, referring to FIG. 7, the generating module 30 includes:

The extracting unit 31 is configured to extract a script file generating rule from a standard authorization file stored in a preset directory;

The generating unit 32 is configured to generate a script file according to the extracted script file generation rule, the configuration information defined in the table, and the script program template corresponding to the table.

In this embodiment, after determining the configuration information defined in the table, the script template corresponding to the table, the extracting unit 31 may further extract the script file generation rule, such as a script file, from the standard authorization file stored in the preset directory. Is only view, some fields are inherently unchanged, can not be modified, and so on, and then the generating unit 32 according to the generated rules of the generated script file, and the configuration information defined in the table and the corresponding script template of the skin label , generate a script file.

Further, the script file generating apparatus further includes:

a determining module, configured to determine, in the preset directory, a location where the standard authorization file is to be modified when the modification instruction of the standard authorization file is detected;

A processing module that replaces the determined location with a placeholder and adds a new script file generation rule to the determined location.

The script file generating apparatus 100 of the present embodiment firstly establishes a form in a preset interface by using a preset script generating tool when receiving a script file generating instruction, and then defines configuration information in the created form, and then according to the table. The defined configuration information, and the script template corresponding to the table, generates a script file. The script file is generated by the configuration information in the table and the script template corresponding to the table, and the generated script file conforms to the specification. Even if the script file is to be modified later, the configuration information in the table can be modified, and the code in the script template is Fragments do not need to be written again, improving the efficiency and intelligence of script file generation.

Further, a second embodiment of the script file generating apparatus 100 of the present application is proposed based on the first embodiment. In this embodiment, referring to FIG. 8, the script file generating apparatus 100 further includes:

The calling module 40 is configured to, when receiving the running instruction of the script file, invoke the database associated with the table to run the script file to implement testing of the script file;

The output module 50 is configured to output prompt information when detecting that the script file is incorrect, wherein the manner of outputting the prompt information includes outputting in a position with an error in the table, or popping up the prompt window to output incorrect information.

In this embodiment, upon receiving the running instruction of the script file, the calling module 40 first invokes the database associated with the table to run the script file, that is, by calling the database, traversing the database to run the script file, If no error is reported during the running of the script file, the generated script file is considered to be accurate. If the script file is detected to be incorrect, the output module 50 outputs the prompt information to prompt the script file to be incorrect, and output the prompt information. The way can be output in the wrong position in the table, and the prompt window can be displayed to output incorrect information.

In this embodiment, in order to ensure the accuracy of the data test, the device includes:

a handover module, configured to: when the handover instruction of the script file is received, hand over the generated script file to a preset storage path, so as to subsequently run the script file;

That is, the handover module first transfers the script file to the preset storage path, so as to test the script file in the storage path, avoiding testing on the interface for generating the script file, thereby affecting the test of the script file, thereby improving The accuracy of the script file test.

It should be noted that, in hardware implementation, the above establishing module 10, defining module 20, generating module 30, and the like may be embedded in or independent of the script file generating device in hardware form, or may be stored in the script file generating device in software form. In the memory, so that the processor calls to perform the operations corresponding to the above modules. The processor can be a central processing unit (CPU), a microprocessor, a microcontroller, or the like.

Referring to FIG. 9, FIG. 9 is a schematic structural diagram of a device in a hardware operating environment according to an embodiment of the present application.

The script file generating device in the embodiment of the present application may be a PC, or may be a terminal device having a display function, such as a smart phone, a tablet computer, or a portable computer.

As shown in FIG. 9, the script file generating device may include a processor 1001, such as a CPU, a network interface 1002, a user interface 1003, and a memory 1004. Connection communication between these components can be achieved via a communication bus. The network interface 1002 may optionally include a standard wired interface (for connecting to a wired network), a wireless interface (such as a WI-FI interface, a Bluetooth interface, an infrared interface, etc. for connecting to a wireless network). The user interface 1003 may include a display, an input unit such as a keyboard, and the optional user interface 1003 may also include a standard wired interface (eg, for connecting a wired keyboard, a wired mouse, etc.), a wireless interface (eg, for Connect a wireless keyboard, wireless mouse). The memory 1004 may be a high speed RAM memory or a stable memory (non-volatile) Memory), such as disk storage. The memory 1004 can also optionally be a storage device independent of the aforementioned processor 1001.

Optionally, the script file generating device may further include a camera, RF (Radio) Frequency, RF) circuits, sensors, audio circuits, WiFi modules, and more.

It will be understood by those skilled in the art that the script file generating device structure shown in FIG. 9 does not constitute a limitation of the script file generating device, and may include more or less components than those illustrated, or combine some components, or different. Parts layout.

As shown in FIG. 9, an operating system, a network communication module, a user interface module, and a script file generation program may be included in the memory 1004 as a computer storage medium. The operating system is a program for managing and controlling the script file generation device hardware and software resources, and supports the operation of the network communication module, the user interface module, the script file generation program, and other programs or software; the network communication module is used to manage and control the network interface. 1002; a user interface module is used to manage and control the user interface 1003.

In the script file generating apparatus shown in FIG. 9, the processor 1001 can be used to execute a script file generating program stored in the memory 1004 to implement the steps of the script file generating method as described above.

The present application provides a computer readable storage medium storing a script file generating program, the script file generating program being executed by a processor to implement the steps of the script file generating method as described above .

It is to be understood that the term "comprises", "comprising", or any other variants thereof, is intended to encompass a non-exclusive inclusion, such that a process, method, article, or device comprising a series of elements includes those elements. It also includes other elements not explicitly listed, or elements that are inherent to such a process, method, article, or device. An element that is defined by the phrase "comprising a ..." does not exclude the presence of additional equivalent elements in the process, method, item, or device that comprises the element.

The serial numbers of the embodiments of the present application are merely for the description, and do not represent the advantages and disadvantages of the embodiments.

Through the description of the above embodiments, those skilled in the art can clearly understand that the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be through hardware, but in many cases, the former is better. Implementation. Based on such understanding, the technical solution of the present application, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk, The optical disc includes a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present application.

The above is only a preferred embodiment of the present application, and thus does not limit the scope of the patent application, and the equivalent structure or equivalent process transformation made by the specification and the drawings of the present application, or directly or indirectly applied to other related technical fields. The same is included in the scope of patent protection of this application.

Claims

A script file generating method, wherein the script file generating method comprises:

When receiving the generation instruction of the script file, the preset script generation tool creates a form on the preset interface;

Define configuration information in the established form;

A script file is generated according to the configuration information defined in the table and the script template corresponding to the table.
The script file generating method according to claim 1, wherein the step of defining configuration information in the created table comprises:

Associate the database in the established form;

User information and synonym user information are established in the table for the associated database, so that different users have different access rights;

A trigger is created in the table to subsequently record a modification trace of the script file based on the created trigger.
The script file generating method according to claim 2, wherein the step of generating a script file according to the configuration information defined in the table and the script program template corresponding to the table comprises:

Extracting a script file generation rule from a standard authorization file stored in a preset directory;

A script file is generated according to the extracted script file generation rule, the configuration information defined in the table, and the script program template corresponding to the table.
The method for generating a script file according to claim 3, wherein the method further comprises:

When the modification instruction of the standard authorization file is detected, determining a location of the standard authorization file to be modified in the preset directory;

Replace the determined location with a placeholder and add a new script file generation rule in the determined location.
The script file generating method according to claim 2, wherein the script file is generated after the step of generating a script file according to the configuration information defined in the table and the script program template corresponding to the table The method also includes:

Upon receiving the running instruction of the script file, calling the database associated with the table to run the script file to implement testing of the script file;

When it is detected that the script file is incorrect, the prompt information is output, wherein the manner of outputting the prompt information includes outputting in a position with an error in the table, or popping up the prompt window to output an incorrect information.
A script file generating apparatus, wherein the script file generating apparatus comprises:

Establishing a module, configured to create a table in a preset interface by using a preset script generation tool when receiving a script file generation instruction;

a definition module for defining configuration information in the created table;

And a generating module, configured to generate a script file according to the configuration information defined in the table, and the script program template corresponding to the table.
The script file generating apparatus according to claim 6, wherein the definition module comprises:

An association unit for associating a database in the established table;

Establishing a unit for establishing user information and synonym user information in the table for the associated database, so that different users have different access rights;

Creating a unit for creating a trigger in the table to subsequently record a modification trace of the script file based on the created trigger.
The script file generating apparatus according to claim 7, wherein the generating module comprises:

An extracting unit, configured to extract a script file generating rule from a standard authorization file stored in a preset directory;

And a generating unit, configured to generate a script file according to the extracted script file generation rule, the configuration information defined in the table, and the script program template corresponding to the table.
The script file generating apparatus according to claim 8, wherein the apparatus further comprises:

a determining module, configured to determine, in the preset directory, a location where the standard authorization file is to be modified when the modification instruction of the standard authorization file is detected;

A processing module that replaces the determined location with a placeholder and adds a new script file generation rule to the determined location.
The script file generating apparatus according to claim 7, wherein the script file generating apparatus further comprises:

Calling a module, when receiving a running instruction of the script file, calling a database associated with the table to run the script file to implement testing of the script file;

The output module is configured to output prompt information when detecting that the script file is incorrect, wherein the manner of outputting the prompt information includes outputting in a position with an error in the table, or popping up the prompt window to output an incorrect information.
A script file generating device, wherein the script file generating device includes a processor and a memory storing a program generated by the script file; the processor is configured to execute the program generated by the script file to implement the following steps :

When receiving the generation instruction of the script file, the preset script generation tool creates a form on the preset interface;

Define configuration information in the established form;

A script file is generated according to the configuration information defined in the table and the script template corresponding to the table.
The script file generating apparatus according to claim 11, wherein the processor is further configured to execute the script file generating program to implement the step of defining configuration information in the created table:

Associate the database in the established form;

User information and synonym user information are established in the table for the associated database, so that different users have different access rights;

A trigger is created in the table to subsequently record a modification trace of the script file based on the created trigger.
The script file generating device according to claim 12, wherein the processor is further configured to execute the script file generating program to implement configuration information according to the table and a script corresponding to the table. Program template, the steps to generate a script file:

Extracting a script file generation rule from a standard authorization file stored in a preset directory;

A script file is generated according to the extracted script file generation rule, the configuration information defined in the table, and the script program template corresponding to the table.
The script file generating device according to claim 13, wherein the processor is further configured to execute the script file generating program to implement the following steps:

When the modification instruction of the standard authorization file is detected, determining a location of the standard authorization file to be modified in the preset directory;

Replace the determined location with a placeholder and add a new script file generation rule in the determined location.
The script file generating device according to claim 12, wherein the processor further generates the script file according to the configuration information defined in the table and the script program template corresponding to the table. Used to execute the script file generation program to implement the following steps:

Upon receiving the running instruction of the script file, calling the database associated with the table to run the script file to implement testing of the script file;

When it is detected that the script file is incorrect, the prompt information is output, wherein the manner of outputting the prompt information includes outputting in a position with an error in the table, or popping up the prompt window to output an incorrect information.
A computer readable storage medium, characterized in that the computer readable storage medium stores a script file generating program, the script file generating program being executed by a processor to implement the following steps:

When receiving the generation instruction of the script file, the preset script generation tool creates a form on the preset interface;

Define configuration information in the established form;

A script file is generated according to the configuration information defined in the table and the script template corresponding to the table.
The computer readable storage medium of claim 16 wherein said script file generation program is executed by a processor and further implementing the step of defining configuration information in the created table:

Associate the database in the established form;

User information and synonym user information are established in the table for the associated database, so that different users have different access rights;

A trigger is created in the table to subsequently record a modification trace of the script file based on the created trigger.
The computer readable storage medium according to claim 17, wherein said script file generating program is executed by a processor, and further implements configuration information defined in said table, and a script program template corresponding to said table, Steps to generate a script file:

Extracting a script file generation rule from a standard authorization file stored in a preset directory;

A script file is generated according to the extracted script file generation rule, the configuration information defined in the table, and the script program template corresponding to the table.
The computer readable storage medium of claim 18, wherein the script file generation program is executed by a processor, further implementing the following steps:

When the modification instruction of the standard authorization file is detected, determining a location of the standard authorization file to be modified in the preset directory;

Replace the determined location with a placeholder and add a new script file generation rule in the determined location.
The computer readable storage medium according to claim 17, wherein said script file is generated after said step of generating a script file according to configuration information defined in said table and said script template corresponding to said table The generator is executed by the processor and the following steps are implemented:

Upon receiving the running instruction of the script file, calling the database associated with the table to run the script file to implement testing of the script file;

When it is detected that the script file is incorrect, the prompt information is output, wherein the manner of outputting the prompt information includes outputting in a position with an error in the table, or popping up the prompt window to output an incorrect information.