Custom configuration data checking and creating method and platform, electronic equipment and storage medium

Through the custom configuration method and platform for number search, the problems of low data acquisition efficiency and large resource utilization in software testing are solved, and the closed-loop process of number search and number search is realized, saving resources and improving testing efficiency.

CN120104632APending Publication Date: 2025-06-06FUZHOU CHANGXIN INFORMATION TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202510124034.X
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-01-26
Publication Date
2025-06-06

AI Technical Summary

Technical Problem

During the software business test cycle, the existing technology has problems such as low data acquisition efficiency and large resource occupancy, resulting in longer testing cycles and excessive maintenance workload.

Method used

Provides a custom configuration method and platform for number search, which realizes the closed-loop process of querying and number searching through SQL statement preconfiguration, SQL statement execution of variable enumeration values, result judgment and automated script call.

Benefits of technology

Save test development resources, supplement query data, shorten the preparation time for test pre-data, reduce investment in customized development, improve testing efficiency and promote left-hand shift of tests.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120104632A_ABST
    Figure CN120104632A_ABST
Patent Text Reader

Abstract

The invention relates to the technical field of software testing, and provides a custom configuration data checking and creating method and platform, electronic equipment and a storage medium, and the method comprises the following steps: carrying out SQL statement pre-configuration of data checking and creating; selecting a number checking condition, and executing the SQL statement of the variable enumeration value; obtaining a query result, and judging whether the query result meets requirements; and if the requirements are not met, calling an automatic script for data creation. According to the technical scheme, the wanted preposed data is searched in a number checking mode, and the traditional manual preparation time is greatly shortened. The platform is compatible with and adapts to different service lines, one-time development is completed, almost zero maintenance is achieved, all the service lines can be used, and customized development investment is greatly reduced; different service requirements are met, an interface automation platform is butted, a number checking and creating closed loop can be formed, and the continuous availability of the platform is kept.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of software testing technology, and in particular to a self-configured number query method, platform, electronic device and storage medium. Background Art

[0002] During the software business testing cycle, there is a lot of math work involved in new function and regression testing, and there is also a lot of math work involved in product acceptance and UI acceptance, which requires a lot of time to prepare test preconditions.

[0003] The existing solutions mainly include the following: 1. Manual preparation of relevant data. If the business chain is long, it takes a long time to prepare the pre-test data through manual operation. 2. Customized development of business efficiency tools, such as one-click creation of data for a certain scenario.

[0004] Among the above existing technical solutions: the first solution has low work efficiency. When encountering complex scenarios and irreversible data, repeated operations are required. Switching scenarios requires continuous manual operations, and the pre-data preparation work takes a lot of time, which lengthens the testing cycle. The second solution relies too much on the testing and development capabilities, and has serious business coupling. If there are many business scenarios, many functions need to be customized and developed, which takes up more testing and development resources, resulting in excessive workload for later maintenance. Summary of the invention

[0005] In order to help solve the problems of low efficiency and large resource occupation of existing data acquisition, the present application provides a custom-configured number query method, platform, electronic device and storage medium.

[0006] In a first aspect, the present application provides a method for querying numbers with a custom configuration, which is used in a test system, and the method includes:

[0007] Pre-configure SQL statements for querying numbers;

[0008] Select the query condition and execute the SQL statement of the variable enumeration value;

[0009] Get the query results and determine whether they meet the requirements;

[0010] If it does not meet the requirements, call the automated script to generate numbers.

[0011] By adopting the above technical solution, test development resources can be saved, number-checking data can be supplemented, and the entire number-checking and number-generating process can be closed-loop.

[0012] In a second aspect, the present application proposes a custom configured query and creation platform for use in a test system, comprising:

[0013] Configuration page front end: pre-configure SQL statements for querying numbers;

[0014] Query page front end: select query conditions and obtain query results;

[0015] Server: receives configuration and query instructions, executes corresponding SQL statements, and returns operation results;

[0016] Database: stores data for retrieval.

[0017] In a third aspect, the present application provides an electronic device, which adopts the following technical solution:

[0018] An electronic device, comprising:

[0019] at least one processor;

[0020] Memory;

[0021] At least one application, wherein the at least one application is stored in the memory and configured to be executed by at least one processor, and the at least one application is configured to: execute a custom configured number query method.

[0022] In a fourth aspect, the present application provides a computer-readable storage medium, which adopts the following technical solution:

[0023] A computer-readable storage medium stores a computer program, which, when executed in a computer, causes the computer to execute any one of the user-defined number-checking methods provided in the first aspect.

[0024] In summary, the technical solution of this application is adapted to different businesses through SQL statement variableization and query configuration, and different business queries are reflected in different SQL query statements. After the platform development is completed, it does not need to take up too many test development resources, integrates external automation platforms, executes number-making scripts, and cooperates with operations in the operation area to supplement the number-checking data and close the entire number-checking and number-making process. The design of this platform also includes data monitoring timer tasks: regular polling query data, when the number is insufficient, automatically call the number-making script to keep the number of number-checking sufficient, solve the problem of low efficiency of manual number-making, and greatly improve test efficiency while better promoting test left shift. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] Figure 1 It is a flowchart of a method for querying and generating numbers with a custom configuration provided in an embodiment of the present application;

[0026] Figure 2 It is a flowchart of a method for querying and generating numbers with a custom configuration provided by another embodiment of the present application;

[0027] Figure 3 It is a schematic diagram of the principle of a custom-configured number query and creation platform provided in another embodiment of the present application;

[0028] Figure 4 It is a schematic diagram of a number query configuration page of a number query platform with custom configuration provided by another embodiment of the present application;

[0029] Figure 5 It is a schematic diagram of a number query page of a number query platform with a custom configuration provided by another embodiment of the present application;

[0030] Figure 6 It is a schematic diagram of the module principle of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0031] In order to make the purpose, technical solutions and advantages of this application more clear, the following Figure 1-6 It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0032] The embodiment of the present application provides a custom configured number query method for use in a test system.

[0033] This embodiment uses testing as an application example to specifically illustrate the above method. In actual implementation, the above method can also be used in other software systems that need to check and create numbers, and this embodiment does not limit this.

[0034] Specific reference Figure 1 , a custom configured query method is used in the test system, the method includes:

[0035] S10: Pre-configure SQL statements for querying numbers;

[0036] S20: Select the query condition and execute the SQL statement of the variable enumeration value;

[0037] S30: Obtain the query result and determine whether it meets the requirements;

[0038] S40: If it does not meet the requirements, call the automated script to generate numbers.

[0039] Based on this embodiment, the process of pre-configuring the SQL statement for querying the number includes:

[0040] S11: Business-based multi-table query SQL statement preparation;

[0041] S12: parameterized configuration of conditional field values ​​of SQL statements;

[0042] S13: Parse the SQL statement, and automatically generate a configuration line for the parameterized variables, and fill in the variable name and the variable enumeration value;

[0043] S14: Configure the column operation and expandable function of the query page, and configure whether to display on the query page;

[0044] S15: Configuration of the operation area tool set of the query page, including the execution of number-making scripts, the ability to extend functions, and the configuration of whether to display on the query page;

[0045] S16: Save the configuration.

[0046] Furthermore, when making a query:

[0047] Generate a custom query page, where the search item name is the variable name and the search item drop-down value is the variable enumeration value;

[0048] Determine in sequence whether the operation area needs to be modified, whether the column operation needs to be modified, and whether the query condition needs to be modified. If so, modify them;

[0049] Select the search item drop-down value, select the query key, execute the SQL statement in the background, and display the query results.

[0050] In the embodiment of the present invention, after obtaining the query result, it is determined whether it meets the requirements;

[0051] S41: If not, perform column operations on the query results;

[0052] S42: Determine whether the result data meets the requirements;

[0053] S43: If not, then execute the number-generating script in the operation area;

[0054] S44: Continue to query. If the result data does not meet the requirements, return to step S41. If the result data meets the requirements, end the query.

[0055] The technical solution of the present invention changes the idea of ​​test pre-data preparation, and searches for the desired pre-data by counting, which greatly shortens the time of traditional manual preparation. The universal counting configuration solution is compatible with different business lines, developed once, with almost zero maintenance, and can be used by all business lines, greatly reducing the investment in customized development. The scalability of the operation area is adapted to different business needs, and the interface automation platform can be connected to form a closed loop of counting and creating numbers. Automatically creating numbers in conjunction with data monitoring tasks can maintain the continuous availability of the platform.

[0056] Refer to the attached Figure 2In one example, the present invention provides a universal and customizable number-checking and number-making solution. By customizing the number-checking conditions, the required data can be directly found. For example, if a user account that meets the conditions is found, the test pre-preparation can be realized by logging in the user. If a different pre-preparation is to be changed, different conditions can be selected to check again, and another user account can be used to log in, and the test preparation of another scenario can be realized immediately. By changing different accounts that meet the conditions, the test pre-preparation can be quickly switched, avoiding the traditional frequent manual operations of using one account to achieve the preparation of switching the test pre-conditions.

[0057] The variableization and query configuration of common SQL statements can adapt to different businesses, and different business queries are reflected in different SQL query statements. After the platform is developed, it does not need to occupy too many test development resources, integrates external automation platforms, executes number-making scripts, and cooperates with operations in the operation area to supplement the number-checking data and close the entire number-checking and number-making process.

[0058] The design of this platform also includes data monitoring timing tasks: regular polling query data, when the number is insufficient, automatically call the number-generating script to keep the number of queries sufficient, solve the problem of low efficiency of manual number generation, aiming to improve test efficiency while better promoting test left shift.

[0059] This platform module is divided into two front-end pages and a server + database. The front-end includes the query configuration page front-end and the query page front-end. The module functions involved in each function are as shown in the attached Figure 3 shown.

[0060] Refer to the attached Figure 4 And attached Figure 5 The query configuration page shown includes:

[0061] Complete search SQL statement: Enter the complete statement for this query. The variable format that needs to be parameterized is: ${variable value}

[0062] Search item configuration: Each line contains the search item name, variable name, and variable value enumeration (variable value: name, multiple values ​​separated by commas).

[0063] Click the "SQL Parsing" button, and the variable name will be reversed in the ${variable value} reference in the SQL statement above. The search item name and variable value enumeration are empty by default and are required.

[0064] The search term name corresponds to the search term name on the search page.

[0065] The variable value names in the variable value enumeration are referenced by the drop-down list in the search page. Users can select the enumeration value to search by dropping down. When clicking the query button, the enumeration value is passed to the corresponding variable assignment in the SQL statement for query.

[0066] Operation configuration: currently supported column operations (expandable), whether to display enabled, and can be displayed and used in the search page.

[0067] Operation area configuration: currently supported operations (expandable), whether to display enable, can be displayed in the search page. Required for running the number creation script, cannot be unenabled.

[0068] As attached Figure 5 The number-checking page shown generates a customized number-checking page according to the search item configuration, column operation configuration, and operation area configuration in the number-checking configuration page.

[0069] On this page, you can query different information by selecting from the drop-down menu to find the data you want. If there is no corresponding data, you can execute operations such as number-making scripts to eventually find the data you want.

[0070] The present application also provides a custom configured query and creation platform for use in a test system, the platform comprising:

[0071] Configuration page front end: pre-configure SQL statements for querying numbers;

[0072] Query page front end: select query conditions and obtain query results;

[0073] Server: receives configuration and query instructions, executes corresponding SQL statements, and returns operation results;

[0074] Database: stores data for retrieval.

[0075] Based on the embodiment of the present invention, the server includes a number generation module, which performs:

[0076] Generate a custom query page, where the search item name is the variable name and the search item drop-down value is the variable enumeration value;

[0077] Determine in sequence whether the operation area needs to be modified, whether the column operation needs to be modified, and whether the query condition needs to be modified. If so, modify them;

[0078] Select the search item drop-down value, select the query key, execute the SQL statement in the background, and display the query results.

[0079] Furthermore, the server is provided with a data timing monitoring task: a timing polling query task, and when the quantity is insufficient, a number generation module is called to generate the number to keep the query data sufficient.

[0080] The server includes a configuration module, which performs:

[0081] Business-based multi-table query SQL statement preparation;

[0082] Parameterized configuration of conditional field values ​​of SQL statements;

[0083] Parse SQL statements, and automatically generate configuration lines for parameterized variables, filling in the variable name and enumeration value of the variable;

[0084] Configure the column operations and expandable functions of the query page, and configure whether to display on the query page;

[0085] Configure the operation area toolset of the query page, including executing number-generating scripts, extending functions, and configuring whether to display on the query page; save the configuration.

[0086] The present application also provides an electronic device, such as Figure 6 As shown, Figure 6 The electronic device 700 shown includes: a processor 701 and a memory 703. The processor 701 and the memory 703 are connected, such as through a bus 702. Optionally, the electronic device 700 may also include a transceiver 704. It should be noted that in actual applications, the transceiver 704 is not limited to one, and the structure of the electronic device 700 does not constitute a limitation on the embodiments of the present application.

[0087] Processor 701 may be a CPU (Central Processing Unit), a general purpose processor, a DSP (Digital Signal Processor), an ASIC (Application Specific Integrated Circuit) or other programmable logic devices, transistor logic devices, hardware components or any combination thereof. It may implement or execute various exemplary logic blocks, modules and circuits described in conjunction with the disclosure of this application. Processor 701 may also be a combination that implements computing functions, such as a combination of one or more microprocessors, a combination of a DSP and a microprocessor, etc.

[0088] The bus 702 may include a path to transmit information between the above components. The bus 702 may be a PCI (Peripheral Component Interconnect) bus or an EISA (Extended Industry Standard Architecture) bus. The bus 702 may be divided into an address bus, a data bus, etc. For ease of representation, Figure 6 Only one thick line is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0089] The memory 703 can be a ROM (Read Only Memory) or other types of static storage devices that can store static information and instructions, a RAM (Random Access Memory) or other types of dynamic storage devices that can store information and instructions, or an EEPROM (Electrically Erasable Programmable Read Only Memory), a disk storage medium or other magnetic storage device, or any other medium that can be used to carry or store the desired program code in the form of instructions or data structures and can be accessed by a computer, but is not limited to these.

[0090] The memory 703 is used to store the application code for executing the solution of the present application, and the execution is controlled by the processor 701. The processor 701 is used to execute the application code stored in the memory 703 to implement the contents shown in the above method embodiment.

[0091] The electronic devices include, but are not limited to, mobile terminals such as mobile phones, notebook computers, PDAs (personal digital assistants), PADs (tablet computers), etc., and fixed terminals such as digital TVs, desktop computers, etc. It can also be a server, etc. Figure 6 The electronic device shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present application.

[0092] The embodiment of the present application also provides a computer-readable storage medium on which a computer program is stored. When the computer program is executed in a computer, the computer is caused to execute the custom configured query number provided in the above embodiment.

[0093] It should be understood that although the steps in the flowchart of the accompanying drawings are shown in sequence according to the instructions of the arrows, these steps are not necessarily performed in the order indicated by the arrows. Unless otherwise clearly stated in this document, the execution of these steps is not strictly limited in order and can be performed in other orders.

[0094] The above are only some implementation methods of the present application. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present application. These improvements and modifications should also be regarded as the scope of protection of the present application.

Claims

1. A method for querying numbers with a custom configuration, characterized in that: Used in a test system, the method comprises: S10: Pre-configure SQL statements for querying numbers; S20: Select the query condition and execute the SQL statement of the variable enumeration value; S30: Obtain the query result and determine whether it meets the requirements; S40: If it does not meet the requirements, call the automated script to generate numbers.

2. The method for querying numbers with a custom configuration according to claim 1, characterized in that: The process of pre-configuring the SQL statement for querying data includes: S11: Business-based multi-table query SQL statement preparation; S12: parameterized configuration of conditional field values ​​of SQL statements; S13: Parse the SQL statement, and automatically generate a configuration line for the parameterized variables, and fill in the variable name and the variable enumeration value; S14: Configure the column operation and expandable function of the query page, and configure whether to display on the query page; S15: Configuration of the operation area tool set of the query page, including the execution of number-making scripts, the ability to extend functions, and the configuration of whether to display on the query page; S16: Save the configuration.

3. The method for querying numbers with a custom configuration according to claim 2, characterized in that: When making a query: Generate a custom query page, where the search item name is the variable name and the search item drop-down value is the variable enumeration value; Determine in sequence whether the operation area needs to be modified, whether the column operation needs to be modified, and whether the query condition needs to be modified. If so, modify them; Select the search item drop-down value, select the query key, execute the SQL statement in the background, and display the query results.

4. The method for querying numbers with a custom configuration according to claim 1, characterized in that: After obtaining the query results, determine whether they meet the requirements; S41: If not, perform column operations on the query results; S42: Determine whether the result data meets the requirements; S43: If not, execute the number-generating script in the operation area; S44: Continue to query. If the result data does not meet the requirements, return to step S41. If the result data meets the requirements, end the query.

5. A custom configured query and creation platform, characterized in that: In the method for querying and generating numbers with a custom configuration as claimed in any one of claims 1 to 4, the platform comprises: Configuration page front end: pre-configure SQL statements for querying numbers; Query page front end: select query conditions and obtain query results; Server: receives configuration and query instructions, executes corresponding SQL statements, and returns operation results; Database: stores data for retrieval.

6. The custom configured number query and creation platform according to claim 5, characterized in that: The server includes a number-generating module, which executes: Generate a custom query page, where the search item name is the variable name and the search item drop-down value is the variable enumeration value; Determine in sequence whether the operation area needs to be modified, whether the column operation needs to be modified, and whether the query condition needs to be modified. If so, modify them; Select the search item drop-down value, select the query key, execute the SQL statement in the background, and display the query results.

7. The custom configured number query and creation platform according to claim 6, characterized in that: The server is provided with a data timing monitoring task: a timing polling query task, and when the number is insufficient, a number generation module is called to generate numbers to keep the query data sufficient.

8. The custom configured number query and creation platform according to claim 5, characterized in that: The server includes a configuration module, which performs: Business-based multi-table query SQL statement preparation; Parameterized configuration of conditional field values ​​of SQL statements; Parse SQL statements, and automatically generate configuration lines for parameterized variables, filling in the variable name and enumeration value of the variable; Configure the column operations and expandable functions of the query page, and configure whether to display on the query page; Configure the operation area toolset of the query page, including executing number-generating scripts, extending functions, and configuring whether to display on the query page; save the configuration.

9. An electronic device, characterized in that: The electronic device includes: at least one processor; Memory; At least one application, wherein the at least one application is stored in a memory and configured to be executed by at least one processor, and the at least one application is configured to: execute the custom configured number query method according to any one of claims 1 to 4.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed in a computer, the computer is caused to execute the self-configured number query method according to any one of claims 1 to 4.