System and method for generating test data for a code testing system

A method for generating test data for a test system, the 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;
• and
• the request at least comprises a number of data records of the test data that are to be generated and a query configured to extract a portion of the production data from the production database table;
• obtaining table metadata associated with the production database table, wherein the table metadata at least comprises a format of the production database table;
• extracting the portion of the production data from the production database table by running the query in the production database, wherein the extracted portion of the production data is to be used as sample data as part of generating the test data;
• determining data properties of the production data stored in the production database table based on the sample data extracted from the production database table;
• generating, based at least upon the table metadata and the data properties associated with the production 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 mimicking the production data from the production database table;
• generating the requested number of the data records of the test data by running the generator object;
• loading the generated test data into a 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 generated test data.

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

• receive a request for generating test data for a 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;
• and
• the request at least comprises a number of data records of the test data that are to be generated and a query configured to extract a portion of the production data from the production 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;
• extract the portion of the production data from the production database table by running the query in the production database, wherein the extracted portion of the production data is to be used as sample data as part of generating the test data;
• determine data properties of the production data stored in the production database table based on the sample data extracted from the production database table;
• generate, based at least upon the table metadata and the data properties associated with the production 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 mimicking the production data from the production database table;
• generate the requested number of the data records of the test data by running the generator object;
• load the generated test data into a 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 generated test data.