WO2018205545A1 - Data generation method, apparatus, terminal, and computer-readable storage medium - Google Patents

Abstract

Disclosed is a method for generating data, used for software testing; the method for generating data comprises the following steps: when a software testing request is detected, determining test information of a to-be-tested software according to the function of the to-be-tested software, and storing said information; generating test data according to the test information, and verifying whether the generated test data satisfies test requirements; inputting to an Excel table the test data that satisfies test requirements, and using same for software testing. Also correspondingly disclosed are a data generation apparatus and terminal and a computer-readable medium. In the present invention, Excel is combined with a program language, and the program, according to data information in template data, simulates the generation of software test data; it is unnecessary for test personnel to manually perform input according to a preset format, improving the efficiency of software testing.

Description

 Data generation method, device, terminal and computer readable storage medium

The present application claims priority to Chinese Patent Application No. 201010327747.1, entitled "Data Generation Method, Terminal and Computer Readable Storage Media", filed on May 10, 2017, the entire contents of which are incorporated by reference. In the application.

Technical field

The present invention relates to the field of software testing, and in particular, to a data generation method, apparatus, terminal, and computer readable storage medium.

Background technique

Existing companies or institutions have different network topologies in the local area network. Servers in the center of the topology structure connect to other node subsystems to receive and analyze data. Multiple subsystems may upload data according to the set template. To the server, the server receives the data sent by the subsystem through the setting template, and verifies the data in the template and then inputs the corresponding location, and finally realizes the processing and analysis of the data.

However, in the early stage of system development, mid-operation, and post-maintenance, no real data is uploaded to the server in the form of attachments for templates. Therefore, testers need to manually input a large amount of data for testing, and manually input data for system testing, manual The data input workload is large, cumbersome, and boring. It may also cause data input format errors, input omissions, etc., which are difficult to find in later inspections, and cause system testing problems.

The above content is only used to assist in understanding the technical solutions of the present invention, and does not constitute an admission that the above is prior art.

Summary of the invention

The main object of the present invention is to provide a data generation method, apparatus, terminal and computer readable storage medium, which aim to improve test efficiency by automatically generating test data and inputting test data into a corresponding test position test.

To achieve the above object, the present invention provides a data generation method, and a data generation method is applied to a software test, including the following steps:

When the software test request is detected, the test information of the software to be tested is determined according to the function of the software to be tested and stored;

Generate test data based on the test information and verify that the generated test data meets the test requirements;

Test data that meets the test requirements is entered into an Excel spreadsheet and applied to software testing.

Optionally, when the software test request is detected, determining the test information of the software to be tested according to the function of the software to be tested and storing the steps includes:

When the software test request is detected, the software to be tested is associated with the Excel table according to the function of the software to be tested;

According to the relationship between the software to be tested and the Excel table, the test information of the software test is determined and stored.

Optionally, the test information includes a data location and a data length, a character set, and the step of generating test data according to the test information includes:

The row and column coordinate values in the Excel table are used as the data locations in the test information;

Based on the data location in the test information, the data length and character set of the corresponding location are determined to generate test data.

Optionally, the step of determining the data length and the character set of the corresponding location according to the data location in the test information to generate the test data includes:

Identifying the data length and character set at the corresponding location according to the data location in the test information;

When a data generation instruction is detected, characters in the character set are extracted and test data is generated based on the data length combination.

Optionally, the steps of verifying that the generated test data meets the test requirements include:

According to the software function of the software to be tested, the preset verification conditions verify the generated test data to determine whether the generated test data meets the test requirements.

Optionally, the step of determining whether the generated test data meets the test requirements includes:

If the generated test data meets the test requirements, the generated test data software is used to test;

If the generated test data does not meet the test requirements, mark the test data that does not meet the test requirements and generate new test data.

Optionally, inputting test data that meets the test requirements into an Excel spreadsheet and applying the steps for the software test includes:

The number of software tests is determined according to the software test requirements, and the number of times the test data is generated is set to perform multiple software tests.

Optionally, determining the number of software tests according to the software testing requirements, and setting the number of times the test data is generated, after performing the multiple software testing steps, includes:

The generated test data is used for software testing to determine whether the test result obtained by the software test is correct. If the test result obtained by the software test is correct, the test data is stopped.

In order to achieve the above object, the present invention also provides a data generating apparatus, where the data generating apparatus includes:

a detection determining module, configured to determine, according to a function of the software to be tested, test information of the software to be tested and store the software test request;

Generating a verification module for generating test data based on the test information and verifying whether the generated test data meets the test requirements;

A data input module for inputting test data that meets the test requirements into an Excel spreadsheet and for use in software testing.

To achieve the above object, the present invention further provides a data generating terminal, the data generating terminal comprising: a memory, a processor, and a data generating program stored on the memory and operable on the processor, the data generating program The steps of the data generation method described above are implemented when executed by the processor.

Furthermore, in order to achieve the above object, the present invention also provides a computer readable storage medium having a data generation program stored thereon, the data generation program being executed by a processor to implement the steps of the data generation method described above.

The present invention provides a data generation method. The data generation method is applied to a software test. When a software test request is detected, the test information of the software to be tested is determined according to the function of the software to be tested and stored, and test data is generated according to the test information, and Verify that the generated test data meets the test requirements, input the test data that meets the test requirements into an Excel spreadsheet, and apply it to the software test; specifically, the data information that needs to be uploaded to the server by the client is stored in the software running process. In the attachment of the Excel format, when testing the software on the server, using the features of the supported program language running on Excel, the programming language is developed in Excel, the data input of the client is simulated, the software tester, and the server needs to be processed. The data is sorted, and all the data position information, data length, character set, and character set that the user may input are obtained as test information, and the program language is randomly generated to generate corresponding test data for software testing, thereby avoiding the software tester manually inputting data and improving the speed of data input. Further improve the efficiency of software testing.

DRAWINGS

1 is a schematic structural diagram of a terminal in a hardware operating environment according to an embodiment of the present invention;

2 is a schematic diagram of a scenario of various embodiments of a data generating method of the present invention;

3 is a schematic diagram of a scenario of a data generating method of the present invention in a software testing process;

4 is a schematic flowchart of an embodiment of a data generating method according to the present invention;

FIG. 5 is a schematic flowchart of the refinement of step S10 of the data generating method in FIG. 4;

6 is a schematic flowchart of the refinement of step S20 of the data generating method in FIG. 4;

FIG. 7 is a schematic flowchart of the refinement of step S22 of the data generating method in FIG. 6;

FIG. 8 is a schematic flowchart diagram of another embodiment of a data generating method according to the present invention; FIG.

FIG. 9 is a schematic diagram of functional modules of an embodiment of a data generating apparatus according to the present invention.

The implementation, functional features, and advantages of the present invention will be further described in conjunction with the embodiments.

detailed description

It is understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.

As shown in FIG. 1, FIG. 1 is a schematic structural diagram of a terminal in a hardware operating environment according to an embodiment of the present invention.

The corresponding program in the data generating method of the present invention is implemented by a data generating terminal (also called a terminal), and the terminal of the embodiment may be a PC, or a portable terminal device having a display function, such as a tablet computer or a portable computer, which needs supplementary explanation. It is the terminal and server mentioned in the present invention that can be replaced.

As shown in FIG. 1, the terminal may include a processor 1001, such as a CPU, a network interface 1004, a user interface 1003, a memory 1005, and a communication bus 1002. Among them, the communication bus 1002 is used to implement connection communication between these components. The user interface 1003 may include a display, an input unit such as a keyboard. In the present invention, the terminal (server) communicates with the user end during the running of the software, and the tester can use the software during the test. The user interface performs input of data information, and the optional user interface 1003 may also include a standard wired interface and a wireless interface. The network interface 1004 can optionally include a standard wired interface, a wireless interface (such as a WI-FI interface). The memory 1005 may be a high speed RAM memory or a stable memory (non-volatile) Memory), such as disk storage. The memory 1005 can also optionally be a storage device independent of the aforementioned processor 1001.

Optionally, the terminal may further include a camera, RF (Radio) Frequency, RF) circuits, sensors, audio circuits, WiFi modules, and more. Among them, sensors such as light sensors, motion sensors, and other sensors. Specifically, the light sensor may include an ambient light sensor and a proximity sensor, wherein the ambient light sensor may adjust the brightness of the display according to the brightness of the ambient light, and the proximity sensor may turn off the display and/or when the mobile terminal moves to the ear. Backlighting. As a kind of motion sensor, the gravity acceleration sensor can detect the magnitude of acceleration in each direction (usually three axes), and can detect the magnitude and direction of gravity when stationary, and can be used to identify the posture of the mobile terminal (such as horizontal and vertical screen switching, Related games, magnetometer attitude calibration), vibration recognition related functions (such as pedometer, tapping), etc.; of course, the mobile terminal can also be equipped with other sensors such as gyroscope, barometer, hygrometer, thermometer, infrared sensor, etc. No longer.

It will be understood by those skilled in the art that the terminal structure shown in FIG. 1 does not constitute a limitation to the terminal, and may include more or less components than those illustrated, or a combination of certain components, or different component arrangements.

The main solution of the embodiment of the present invention is: developing a programming language in Excel according to data processed by the server, simulating generating test data, applying and software testing, specifically, in conjunction with FIG. 3, the user input processed in the software running process is in Excel. The data in the table, the present invention simulates the data input by the client, generates data in Excel using the programming language, and applies the generated data to the software test. It is necessary to additionally explain that the solution software (system) processing described in the present invention The digital information is in Excel. Therefore, based on the characteristics of Excel that can directly run the program, the data generation statement is set in Excel by using VB (or other programming language that can be run on Excel) in Excel. For Excel, if simple replacement is performed on the basis of the present invention, that is, generating other text information, or simply switching other document modes in Excel, it should be considered within the scope of the present invention.

Since the prior art does not have an improved scheme for manually inputting test data in software testing, existing software tests, regardless of the type of data, are manually input data, so the number of tests is small, the test accuracy is low, and at the same time Software testing is less efficient.

The present invention provides a solution for generating test data in the form of data processing using a programming language.

As shown in FIG. 1, the memory 1005 as a computer storage medium may include an operating system, a network communication module, a user interface module, and a data generation application, and the data generated by the data generation application for data generation is used for software testing.

In the terminal shown in FIG. 1, the network interface 1004 is mainly used to connect to the background server and perform data communication with the background server; the user interface 1003 is mainly used to connect the client (user end), and perform data communication with the client; and the processor 1001 can be used to invoke a software test stored in memory 1005 and perform the following operations:

When the software test request is detected, the test information of the software to be tested is determined according to the function of the software to be tested and stored;

Generate test data based on the test information and verify that the generated test data meets the test requirements;

Test data that meets the test requirements is entered into an Excel spreadsheet and applied to software testing.

Further, the processor 1001 may call the data generation application stored in the memory 1005, and also perform the following operations:

When the software test request is detected, the step of determining the test information of the software to be tested according to the function of the software to be tested and storing the steps includes:

When the software test request is detected, the software to be tested is associated with the Excel table according to the function of the software to be tested;

According to the relationship between the software to be tested and the Excel table, the test information of the software test is determined and stored.

Further, the processor 1001 may call the data generation application stored in the memory 1005, and also perform the following operations:

The test information includes a data location and a data length, a character set, and the step of generating test data according to the test information includes:

The row and column coordinate values in the Excel table are used as the data locations in the test information;

Based on the data location in the test information, the data length and character set of the corresponding location are determined to generate test data.

Further, the processor 1001 may call the data generation application stored in the memory 1005, and also perform the following operations:

According to the data location in the test information, the steps of determining the data length and character set of the corresponding location to generate test data include:

Identifying the data length and character set at the corresponding location according to the data location in the test information;

When a data generation instruction is detected, characters in the character set are extracted and test data is generated based on the data length combination.

Further, the processor 1001 may call the data generation application stored in the memory 1005, and also perform the following operations:

The steps to verify that the generated test data meets the test requirements include:

According to the software function of the software to be tested, the preset verification conditions verify the generated test data to determine whether the generated test data meets the test requirements.

Further, the processor 1001 may call the data generation application stored in the memory 1005, and also perform the following operations:

The steps to determine whether the generated test data meets the test requirements include:

If the generated test data meets the test requirements, the generated test data software is used to test;

If the generated test data does not meet the test requirements, mark the test data that does not meet the test requirements and generate new test data.

Further, the processor 1001 may call the data generation application stored in the memory 1005, and also perform the following operations:

Entering test data that meets the test requirements into an Excel spreadsheet and applying the software test steps includes:

The number of software tests is determined according to the software test requirements, and the number of times the test data is generated is set to perform multiple software tests.

Further, the processor 1001 may call the data generation application stored in the memory 1005, and also perform the following operations:

The number of software tests is determined according to the software testing requirements, and the number of times the test data is generated is set to perform multiple software testing steps including:

The generated test data is used for software testing to determine whether the test result obtained by the software test is correct. If the test result obtained by the software test is correct, the test data is stopped.

Referring to FIG. 4, an embodiment of the data generating method of the present invention provides a data generating method including the following steps:

Step S10, when the software test request is detected, the test information of the software to be tested is determined according to the function of the software to be tested and stored.

When testing software on the server (the software here can be understood as software or data processing system), the information of the data processed by the software runtime is used as test information and stored in the memory to determine the software testing process according to the test information. Simulate the generated test data. For example, the software on the server is a financial salary settlement system, the financial salary settlement system is used to pay wages to employees of other branches, and the branch office serves as the basic information for uploading employees of the company (employee name, job number) , gender, etc., and the basic information of wages (salary amount, bank card number, deductible amount, etc.) and salary distribution data, in the system test process of the financial salary settlement system, the test personnel need to input the salary amount, bank card number Data, but there is no real salary settlement data for software testing during the software testing process. The existing technology mainly relies on the manual input of the tester. The present invention firstly organizes the data related information processed by the system as System test test information The salary settlement system test information: the salary amount, the bank card number, the deduction amount and other information related to the salary calculation), and the test data is generated according to the stored test information, and the relevant test data is simulated to calculate the salary, thereby realizing the financial salary settlement system. Test.

Step S20, generating test data according to the test information, and verifying whether the generated test data meets the test requirement.

Specifically, according to the data processed by the software runtime on the server, the program function is generated to generate test data, that is, the type of data that may appear is saved in the memory of the server, the programming language is developed in Excel, and the corresponding characters are combined into a test. The data is tested for data. As shown in Table 1, the numbers, other letters, and symbol information appearing in the bank card number are stored in the memory as test information:

Employee salary schedule
Name		gender
Job number		position
date		Bank card number
Payroll statistics
Attendance days
bonus
Commission
Performance
total amount
Deductible
The actual amount

(Table 1, shown as an Excel template, can intuitively understand the salary calculation data as software test data), using the programming language, first determine the location of the digital information in the Excel table: the first few rows, the first few columns Further, the program function is used to generate the test data, and the generated test data is verified according to the verification condition, and it is judged whether the generated data meets the test requirement (verification condition: the verification condition according to the specific situation of the generated data, and the data can be Generate probabilistic verification randomness, or whether it conforms to a specific data boundary, the end of the verification rules, etc., to verify the generated test data, to meet the test requirements to meet the test requirements).

In step S30, the test data meeting the test requirements is input into an Excel spreadsheet and used for software testing.

The server inputs the verified test data conforming to the test requirements into an Excel spreadsheet, and performs software testing using the test data generated by the programming language in the Excel table.

In this embodiment, when the software test request is detected, the test information of the software to be tested is determined according to the function of the software to be tested and stored, the test data is generated according to the test information, and the generated test data is verified to meet the test requirements, and the The test data of the test requirement is input into the Excel spreadsheet and used for software testing; the data information processed by the client to the server is stored in an attachment in Excel format, and the software in the support language of Excel is used when testing the software on the server. The characteristics of the operation, develop the programming language in Excel, simulate the data input of the client, specifically, sort the data that the server needs to process, obtain all the data information that the user may input as the test information, and set the programming language to randomly generate the corresponding test data. Software testing is performed to prevent software testers from manually inputting data, which increases the speed of data input and further improves the efficiency of software testing.

Referring to FIG. 5, the embodiment is further proposed based on the first embodiment. In this embodiment, step S10 includes:

In step S11, when the software test request is detected, the software to be tested is associated with the Excel table according to the function of the software to be tested.

In the server software test, first determine the data processed during the software running process, input all the data processed in the software running process into the Excel format as the software test information, and associate the software to be tested with the Excel table, for example, the headquarters The financial salary settlement system, when the salary is paid, enter the salary distribution related data in the template of the employee salary list Excel table shown in Table 1, and then upload the data in Excel as the attachment information to the financial salary settlement system of the headquarters. In the middle, the relationship between the financial salary settlement system and the Excel spreadsheet is established, and the financial salary settlement system processes the data information in Excel.

It should be added that in the method, the data in the Excel input by the user terminal is used as the template data. If other formats are used for data generation, the application and software testing methods are evenly considered within the scope of protection of the solution.

Step S12: Determine test information of the software test according to the relationship between the software to be tested and the Excel table, and store the test information.

According to the relationship between the software to be tested and the Excel table, it is determined that the software to be tested needs to test all the test data in Excel, and wants to test the position information of the data in Excel, the length of the test data, the type of the test data as test information, and stored in In the memory, that is, in Excel, numeric data, data dictionary data, text data, and the like may be unified in the character set, so the terminal needs to store all possible test information (data position and data length, character set) in the memory. In the memory of the terminal.

In the embodiment, when the software test request is detected, the software to be tested is associated with the Excel table according to the function of the software to be tested, and the test information of the software test is determined and stored according to the relationship between the software to be tested and the Excel table; During the running of the system, the user inputs the data information in Excel as test information, so as to generate corresponding test data according to the test information for software testing. The existing software test is data input processed by the tester according to the software, and manual manual data input. Software testing, such a method for software testing of a large number of data input, will lead to low test efficiency, the data that the user may input as test information, generate test data for data testing can speed up the efficiency of software testing.

Referring to FIG. 6, the embodiment is further provided on the basis of the first embodiment. In this embodiment, the data information includes a data location, a data type, and a data length, and step S20 includes:

In step S21, the row and column coordinate values in the Excel table are used as the data locations in the test information.

Specifically, in the data generation process, the present invention directly simulates data input of the user end, and inputs the generated test data into a corresponding position in Excel, as shown in Table 1, and uses the corresponding row and column values of the template data in Excel as a template. The data location of the data, in the software test, the location in Excel is no test data, this method uses the features of Excel to support the running program language, generate test data in Excel, that is, first determine the test data in the software test in Excel Data location, software tool language: You can use the VBA language sheets().select and cells() functions to find the location in the specific excel, and populate the data on this basis.

Step S22: Determine a data length and a character set of the corresponding location according to the data location in the test information to generate test data.

Specifically, after determining the data location of the template data, the data length and the data type of the corresponding location are further determined, that is, after determining the data location of the generated data in Excel, determining the data length and character set (character set) of the corresponding location : Different data types, symbols, letters, etc., set different program languages for different data locations to generate test data.

In this embodiment, the row and column coordinate values in the Excel table are used as the data position in the test information, and the data length and character set of the corresponding position are determined according to the data position in the test information to generate test data; the test data is in Excel. The corresponding row and column coordinate values in the table, as the data position of the test data, determine the data length and characters of the corresponding position according to the data position of the template data, and set the programming language to generate test data to prevent the cumbersome work of manually inputting the test data, and determine the test by determining the test. Information, and then preset programming language to generate test data speeds up software testing efficiency.

Referring to FIG. 7, in the embodiment, step S22 includes:

Step S221, identifying the data length and the character set at the corresponding location according to the data location in the test information.

Specifically, after determining the location of the test data based on the location of the test data in Excel, the data length and character set of the test data that should be generated are identified.

Step S222, when the data generation instruction is detected, the characters in the character set are extracted and the test data is generated according to the data length combination.

After determining the data location, the data length, and the character set, the programming language randomly extracts characters from the character set stored in the test information pre-stored in the terminal, and generates numerical values of various types within a certain range of the data position of the template data for the numerical data. And correspondingly filling the extracted data to the corresponding position, that is, the random value can be generated according to the round and format functions of the VBA, and if the data dictionary class data is filled, the data dictionary is maintained in a sheet, and the sheet is read in a sequential cycle. The value of the data field class data is filled into the Excel template, combined to generate test data,

For example, in the Excel form information filled in by the employee in the salary settlement system of the headquarters, the bank card number to be filled in during the software test, first determine the location where the bank card number needs to be filled, and then determine the length of the bank card number, and then select the number corresponding to the length, and combine The bank card number is formed (all numbers and characters are pre-stored in the memory to form a character set, and then the data is randomly extracted by the programming language to form test data), and the same type of digital information is required to be generated correspondingly.

It should be added that the data here includes not only numbers, but also letters, or other types of character information.

In this embodiment, according to the data location in the test information, the data length and the character set at the corresponding location are identified; when the data generation instruction is detected, the characters in the character set are extracted and the test data is generated according to the data length combination, from the pre-stored The test information character set randomly extracts the character information combination to form test data, which accelerates the generation efficiency of the test data.

With reference to FIG. 6, step S20 in the data generating method of the present invention further includes:

In step S23, according to the software function of the software to be tested, the generated verification data is verified by the preset verification condition to determine whether the generated test data meets the test requirement.

Specifically, according to the software function of the software to be tested, the preset verification condition verifies the generated test data to verify whether the generated test data is a test requirement, that is, simply verifying randomness verification for the generated data, or The data setting condition of the location data verification condition, for example, whether the generated bank card number corresponds to the corresponding verification rule, that is, whether the generated test data conforms to different data verification rules such as randomness and uniqueness.

In step S24, if the generated test data meets the test requirements, the generated test data software is used for testing.

Specifically, the generated test data is tested by using the preset verification condition. If the generated test data satisfies the corresponding verification condition, the test data is considered to meet the test requirement, the test data of the next data location is generated, and the generated data is utilized. Software testing, based on the support of the programming language in Excel, you can directly test the software in Excel.

In step S25, if the generated test data does not meet the test requirements, the test data that does not meet the test requirements is marked, and new test data is generated.

If the test data is verified, the test data does not satisfy the randomness, the repetition rate is high, or other verification conditions are not met. It is considered that the generated test data does not meet the test requirements, and the test data that does not meet the test requirements is marked and again. Run the data generator of the corresponding location to generate new test data.

In this embodiment, according to the software function of the software to be tested, the verification condition is used to verify the generated test data to determine whether the generated test data meets the test requirement, and different data verification conditions are preset for the generated data to generate The test data is verified to make the generated test data more in line with the requirements of the software test, so that the accuracy of the software test is guaranteed, and whether the generated test data meets the test requirements, and if the generated test data meets the test requirements, the generated test data is utilized. Test data software test, if the generated test data does not meet the test requirements, mark the test data that does not meet the test requirements, and generate new test data, so that the generated test data is more in line with the requirements of the software test, and the accuracy of the software test is improved. Sexuality, the existing test data mainly depends on the manual input by the tester. If the manual input of the test has errors, the query is difficult, and the software system may also have problems.

Referring to FIG. 8, after step S30 in another embodiment of the data generating method, the method further includes:

In step S40, the number of software tests is determined according to the software test requirements, and the number of times the test data is generated is set to perform multiple software tests.

Specifically, according to the software test requirement setting data generation times, using a loop statement, after a software test is finished, setting a data generation statement again, generating a new round of test data over the Excel template to overwrite the previous data, and Data verification for newly generated test data and software testing for multiple cycles.

In step S50, the generated test data is used for software testing to determine whether the test result obtained by the software test is correct. If the test result obtained by the software test is correct, the test data is stopped.

Specifically, the software test is mainly carried out around different factors such as the stability of the softness, using the generated test data for software testing, and judging whether the result of the software test is correct, that is, when using the generated test value for software testing, The result of the test is the same as the value of the software running normally. If the software test result is correct multiple times, stop generating the software test data and complete the corresponding software test work. Otherwise, if the test result obtained by the software test is incorrect, then Generate test data multiple times and look for software anomalies.

In this embodiment, the data generation times are set according to the software testing requirements, and the test data is generated by using the programming language to cycle and verify the generated test data for software testing, which can prevent the tester from repeating a large amount of data input to implement the software test, and speed up the software test. effectiveness. Using the test data to perform software testing, determine whether the software test result matches the set value. If the software test result matches the set value, stop generating the software test data and complete the software test. In this embodiment, the test data is stopped. The generated conditions, using the generated test data to quickly perform software testing, slow down the tedious manual test; save the investment of test manpower for large-scale attachment upload function; the randomly generated data can cover the test scenario more comprehensively. It is not easy to miss the scene.

Further, with reference to FIG. 9, the present invention further provides a data generating apparatus, where the data generating apparatus includes:

The detection determining module 10 is configured to determine, according to a function of the software to be tested, test information of the software to be tested and store the software test request;

Generating a verification module 20 for generating test data according to the test information and verifying whether the generated test data meets the test requirements;

The data input module 30 is configured to input test data meeting the test requirements into an Excel spreadsheet and apply the software test.

For the steps of the data generating device, the data generating device can refer to various embodiments of the data generating method of the present invention, and details are not described herein again.

In addition, an embodiment of the present invention further provides a computer readable storage medium having a data generation program stored thereon, and the data generation program is implemented by a processor to implement steps such as a data generation method.

For the method implemented when the data generating program is executed, reference may be made to various embodiments of the data generating method of the present invention, and details are not described herein again.

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 It also includes other elements that are not explicitly listed, or elements that are inherent to such a process, method, item, or system. An element defined by the phrase "comprising a ..." does not exclude the presence of additional equivalent elements in a process, method, article, or system that includes the element, without further limitation.

The serial numbers of the embodiments of the present invention 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, portions of the technical solution of the present invention that contribute substantially or to the prior art may be embodied in the form of a software product stored in a storage medium (such as a ROM/RAM as described above). , a disk, an optical disk, including 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 invention.

The above are only the preferred embodiments of the present invention, and are not intended to limit the scope of the invention, and the equivalent structure or equivalent process transformations made by the description of the present invention and the drawings are directly or indirectly applied to other related technical fields. The same is included in the scope of patent protection of the present invention.

Claims (20)

1.  A data generating method, wherein the data generating method is applied to a software test, and the data generating method comprises the following steps:

   When the software test request is detected, the test information of the software to be tested is determined according to the function of the software to be tested and stored;

   Generate test data based on the test information and verify that the generated test data meets the test requirements;

   Test data that meets the test requirements is entered into an Excel spreadsheet and applied to software testing.
2. The data generating method according to claim 1, wherein when the software test request is detected, determining the test information of the software to be tested according to the function of the software to be tested and storing the steps includes:

   When the software test request is detected, the software to be tested is associated with the Excel table according to the function of the software to be tested;

   According to the relationship between the software to be tested and the Excel table, the test information of the software test is determined and stored.
3. The data generating method according to claim 2, wherein the test information comprises a data location and a data length, and a character set;

   The step of generating test data according to the test information includes:

   The row and column coordinate values in the Excel table are used as the data locations in the test information;

   Based on the data location in the test information, the data length and character set of the corresponding location are determined to generate test data.
4. The data generating method according to claim 3, wherein the step of determining a data length and a character set of the corresponding location according to the data location in the test information to generate test data comprises:

   Identifying the data length and character set at the corresponding location according to the data location in the test information;

   When a data generation instruction is detected, characters in the character set are extracted and test data is generated based on the data length combination.
5. The data generating method according to claim 1, wherein the step of verifying whether the generated test data meets the test requirement comprises:

   According to the software function of the software to be tested, the preset verification conditions verify the generated test data to determine whether the generated test data meets the test requirements.
6. The data generating method according to claim 5, wherein the step of determining whether the generated test data meets the test requirement comprises:

   If the generated test data meets the test requirements, the generated test data software is used to test;

   If the generated test data does not meet the test requirements, mark the test data that does not meet the test requirements and generate new test data.
7. The data generating method according to claim 1, wherein the inputting the test data conforming to the test requirement into the Excel table and applying the software test step comprises:

   The number of software tests is determined according to the software test requirements, and the number of times the test data is generated is set to perform multiple software tests.
8. The data generating method according to claim 7, wherein the determining the number of software tests according to the software testing requirement and setting the number of times the test data is generated to perform the plurality of software testing steps comprises:

   The generated test data is used for software testing to determine whether the test result obtained by the software test is correct. If the test result obtained by the software test is correct, the test data is stopped.
9. A data generating device, wherein the data generating device comprises:

   a detection determining module, configured to determine, according to a function of the software to be tested, test information of the software to be tested and store the software test request;

   Generating a verification module for generating test data based on the test information and verifying whether the generated test data meets the test requirements;

   A data input module for inputting test data that meets the test requirements into an Excel spreadsheet and for use in software testing.
10. A data generating terminal, comprising: a memory, a processor, and a data generating program stored on the memory and operable on the processor, wherein

    The data generation program is executed by the processor to implement the following steps:

    When the software test request is detected, the test information of the software to be tested is determined according to the function of the software to be tested and stored;

    Generate test data based on the test information and verify that the generated test data meets the test requirements;

    Test data that meets the test requirements is entered into an Excel spreadsheet and applied to software testing.
11. The data generating terminal according to claim 10, wherein the data generating program is implemented by the processor, and when the software testing request is detected, determining the software to be tested according to the function of the software to be tested The steps to test the information and store it include:

    When the software test request is detected, the software to be tested is associated with the Excel table according to the function of the software to be tested;

    According to the relationship between the software to be tested and the Excel table, the test information of the software test is determined and stored.
12. The data generating terminal according to claim 11, wherein the data generating program is implemented by the processor, and the test information comprises a data location and a data length, and a character set;

    The step of generating test data according to the test information includes:

    The row and column coordinate values in the Excel table are used as the data locations in the test information;

    Based on the data location in the test information, the data length and character set of the corresponding location are determined to generate test data.
13. The data generating terminal according to claim 12, wherein said data generating program is implemented by said processor, said determining a data length and a character set of the corresponding position based on the data position in the test information, The steps to generate test data include:

    Identifying the data length and character set at the corresponding location according to the data location in the test information;

    When a data generation instruction is detected, characters in the character set are extracted and test data is generated based on the data length combination.
14. The data generating terminal according to claim 10, wherein the step of realizing whether the test data generated by the verification conforms to the test requirement when the data generating program is executed by the processor comprises:

    According to the software function of the software to be tested, the preset verification conditions verify the generated test data to determine whether the generated test data meets the test requirements.
15. The data generating terminal according to claim 14, wherein the data generating program is implemented by the processor, and the step of determining whether the generated test data meets a test requirement comprises:

    If the generated test data meets the test requirements, the generated test data software is used to test;

    If the generated test data does not meet the test requirements, mark the test data that does not meet the test requirements and generate new test data.
16. A computer readable storage medium, characterized in that the computer readable storage medium stores a data generation program, and when the data generation program is executed by the processor, the following steps are implemented:

    When the software test request is detected, the test information of the software to be tested is determined according to the function of the software to be tested and stored;

    Generate test data based on the test information and verify that the generated test data meets the test requirements;

    Test data that meets the test requirements is entered into an Excel spreadsheet and applied to software testing.
17. The computer readable storage medium according to claim 16, wherein the data generation program is executed by the processor to implement the test of the software to be tested according to the function of the software to be tested when the software test request is detected. The steps for information and storage include:

    When the software test request is detected, the software to be tested is associated with the Excel table according to the function of the software to be tested;

    According to the relationship between the software to be tested and the Excel table, the test information of the software test is determined and stored.
18. The computer readable storage medium of claim 17, wherein the data generation program is implemented by a processor, the test information comprising a data location and a data length, a set of characters;

    The step of generating test data according to the test information includes:

    The row and column coordinate values in the Excel table are used as the data locations in the test information;

    Based on the data location in the test information, the data length and character set of the corresponding location are determined to generate test data.
19. The computer readable storage medium according to claim 18, wherein when the data generating program is executed by the processor, the data length and the character set of the corresponding position are determined according to the data position in the test information to generate The steps to test the data include:

    Identifying the data length and character set at the corresponding location according to the data location in the test information;

    When a data generation instruction is detected, characters in the character set are extracted and test data is generated based on the data length combination.
20. The computer readable storage medium according to claim 16, wherein the data generating program is implemented by a processor, and the step of verifying whether the generated test data meets a test requirement comprises:

    According to the software function of the software to be tested, the preset verification conditions verify the generated test data to determine whether the generated test data meets the test requirements.