System and method for generating testing data for a code testing system using synthetic data generation

A method comprising:

• receiving a request for generating test data for the test system, wherein:
• the test data is to at least partially mimic production data from a production database table that is stored in a production database associated with a production system;
• the request at least comprises a number of data records of the test data that are to be generated and a set of rules at least defining data properties for one or more data attributes associated with a test database table that is to mimic the production database table, wherein the test database table is stored in the test database associated with the test system;
• and
• a data property defined for a particular data attribute at least defines one or more data values that can be assigned to data fields associated with the particular data attribute in the test database table;
• obtain table metadata associated with the production database table, wherein the table metadata at least comprises a format of the production database table;
• generating, based at least upon the table metadata associated with the production database table and the data properties associated with the test database table, a generator object configured to generate the test data for the test system, wherein the generator object is a software program configured to generate the test data in accordance with the table properties associated with the production database table and the data properties associated with the test database table as defined by the set of rules;
• generating the requested number of the data records of the test data by running the generator object;
• loading the generated test data into the test database table stored in the test database associated with the test system;
• and
• running one or more test procedures in the test system based on the test data.

A non-transitory computer-readable medium storing instructions that when executed by a processor causes the processor to:

• receive a request for generating test data for the test system, wherein:
• the test data is to at least partially mimic production data from a production database table that is stored in a production database associated with a production system;
• the request at least comprises a number of data records of the test data that are to be generated and a set of rules at least defining data properties for one or more data attributes associated with a test database table that is to mimic the production database table, wherein the test database table is stored in the test database associated with the test system;
• and
• a data property defined for a particular data attribute at least defines one or more data values that can be assigned to data fields associated with the particular data attribute in the test database table;
• obtain table metadata associated with the production database table, wherein the table metadata at least comprises a format of the production database table;
• generate, based at least upon the table metadata associated with the production database table and the data properties associated with the test database table, a generator object configured to generate the test data for the test system, wherein the generator object is a software program configured to generate the test data in accordance with the table properties associated with the production database table and the data properties associated with the test database table as defined by the set of rules;
• generate the requested number of the data records of the test data by running the generator object;
• load the generated test data into the test database table stored in the test database associated with the test system;
• and
• run one or more test procedures in the test system based on the test data.