Metadata-based test data generation

• US 9,734,214 B2
• Filed: 06/28/2012
• Issued: 08/15/2017
• Est. Priority Date: 06/28/2012
• Status: Expired due to Fees

• Current Assignee: Micro Focus LLC (Open Text Corporation)
• Original Assignee: entIT Software LLC (Open Text Corporation)
• Inventors: Leizerovich, Maxim, Meirman, Ilan
• Primary Examiner(s): Dao, Thuy
• Assistant Examiner(s): Rivera, Anibal
• Application Number:
  US13/535,913
• Publication Number:
  US 20140007056A1
• Time in Patent Office: 1,874 Days
• CPC Class Codes: G06F 11/3684 for test design, e.g. generating new test cases
• CPC Class Codes: G06F 11/3688 for test execution, e.g. scheduling of test suites
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: G06F 16/24564 Applying rules; Deductive queries
• CPC Class Codes: G06F 16/2458 Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation

Abstract

Example embodiments disclosed herein relate to a method for generating test data for form validation, where the method includes maintaining metadata for a database, mapping a control field of the form to a column of the database, and generating test data based on the mapping and the metadata.

Claims

1. A method comprising:

extracting column metadata from a relational database, the column metadata describing a plurality of columns of a data table included in the relational database, the data table comprising a plurality of data records, wherein the column metadata comprises at least one of field data types, mandatory fields, or relationships to other columns;

generating a graphical mapping interface comprising an interface form and the plurality of columns of the data table, the interface form comprising a plurality of input controls;

receiving, in the graphical mapping interface, user inputs defining a plurality of control-column mappings between the plurality of input controls of the interface form and the plurality of columns of the data table;

in response to a receipt of the user inputs defining the plurality of control-column mappings;

automatically generating, using the plurality of control-column mappings, a plurality of control-metadata mappings between the plurality of input controls to the column metadata; and

using the plurality of control-metadata mappings, automatically generating, by a processor, new test data values for testing the plurality of input controls, the new test data values comprising data values that are illegal according to the column metadata.

2. The method of claim 1, wherein the column metadata describes data types of the plurality of columns in the data table.

3. The method of claim 1, wherein the column metadata describes data limits of the plurality of columns in the data table.

4. The method of claim 1, the new test data further comprising test data for inter-field logic validation.

5. The method of claim 4, wherein the inter-field logic validation test data comprises test data values for validating relationships between multiple combo fields of the interface form.

6. The method of claim 1, wherein the new test data values further include extreme values that are legal according to the column metadata.

7. The method of claim 1, further comprising:

generating test scripts to inject the new test data values; and

executing the test scripts to validate the interface form.

8. A system comprising:

a hardware processor;

a machine-readable storage medium storing instructions executed by the hardware processor to;

extract column metadata from a relational database, the column metadata describing a plurality of columns of a data table included in the relational database, the data table comprising a plurality of data records, wherein the column metadata comprises at least one of field data types, mandatory fields, or relationships to other columns;

generate a graphical mapping interface comprising an interface form and the plurality of columns of the data table, the interface form comprising a plurality of input controls;

receive, from the graphical mapping interface, user inputs defining a plurality of control-column mappings between the plurality of input controls of the interface form and the plurality of columns of the data table;

in response to a receipt of the user inputs defining the plurality of control-column mappings;

automatically generate, using the plurality of control-column mappings, a plurality of control-metadata mappings between the plurality of input controls to the column metadata; and

automatically generate, using the plurality of control-metadata mappings, new test data values for testing the plurality of input controls, the new test data values including data values that are illegal according to the column metadata.

9. The system of claim 8, wherein the new test data values further include data values for validating relationships between multiple combo fields of the interface form.

10. The system of claim 8, further comprising instructions executed by the hardware processor to automatically generate test scripts for injecting the new test data values during testing.

11. The system of claim 8, wherein the column metadata describes data types of the plurality of columns in the data table.

12. The system of claim 8, wherein the column metadata describes data limits of the plurality of columns in the data table.

13. A non-transitory computer readable medium comprising instructions that when executed implement a method, the method comprising:

extracting column metadata from a relational database, the column metadata describing a plurality of columns of a data table included in the relational database, the data table comprising a plurality of data records, wherein the column metadata comprises at least one of field data types, mandatory fields, or relationships to other columns;

generating a graphical mapping interface comprising an interface form and the plurality of columns of the data table, the interface form comprising a plurality of input controls;

receiving, in the graphical mapping interface, user inputs defining a plurality of control-column mappings between the plurality of input controls of the interface form and the plurality of columns of the data table;

in response to a receipt of the user inputs defining the plurality of control-column mappings;

automatically generating, using the plurality of control-column mappings, a plurality of control-metadata mappings between the plurality of input controls to the column metadata; and

automatically generating, using the plurality of control-metadata mappings, new test data values for testing the plurality of input controls, the new test data values comprising data values that are illegal according to the column metadata.

14. The non-transitory computer readable medium of claim 13, wherein the column metadata describes data types of the plurality of columns in the data table.

15. The non-transitory computer readable medium of claim 13, wherein the column metadata describes data limits of the plurality of columns in the data table.

16. The non-transitory computer readable medium of claim 13, wherein the column metadata describes relationships between different columns of the data table.

17. The non-transitory computer readable medium of claim 13, the method further comprising:

generating test scripts to inject the new test data values during testing; and

executing the test scripts to validate the interface form.

18. The non-transitory computer readable medium of claim 13, wherein the new test data values further include data values for validating a combo control field based on mapped data column and lookup tables associated with the combo control field.

19. The non-transitory computer readable medium of claim 13, wherein the new test data values further include data values for validating a relation between multiple combo fields based on their relation in the database.

20. The non-transitory computer readable medium of claim 13, wherein the new test data values further include extreme values that are legal according to the column metadata.