Description
GenRocket Query Generators query columns, tables, or a list of values within a specified file or database during test data generation.
When should you use Query Generators?
- Any time you want to query real data from within a specified file or database.
Why are Query Generators useful?
- Query Generators make it easy to blend real data values with synthetically generated data. For example, combining real postal addresses with synthetically generated names.
- Query Generators make it easy to create a subset of real production data.
GenRocket Query Generators
GenRocket provides several Query Generators, which are described in further detail within the table below:
Generator Name | Description |
| PermutationQueryGen | Queries a list of values used with other Permutation Generators to compute a sum of permutations. It will generate all possible combinations of data for a given set of values queried from a set column within a database. For more information, click here. |
| QueryBeforeLoopGen | Queries a column within a table using an SQL select statement BEFORE the 1st iteration of test data generation. |
| QueryBeforeLoopV2Gen | Queries a column within a table using an SQL select statement BEFORE the 1st iteration of test data generation. For more information, click here. |
| QueryCountGen | Create and execute a 'selectcount(*)' query statement. |
| QueryCountV2Gen | Create and execute a 'selectcount(*)' query statement. |
| QueryEachLoopGen | Query a column within a database table, using an SQL select statement, on EACH iteration of test Generation. |
| QueryEachLoopV2Gen | Query a column within a database table, using an SQL select statement, on EACH iteration of test Generation. For more information, click here. |
| QueryEachFromMapGen | Reads the value of a particular column from the result of QueryEachToMapGen. |
| QueryEachToMapGen | Using SQL, query one or more columns within a table in a database allowing for full select statements to be executed during EACH iteration of a given Generator. |
| QueryFromMapGen | Maps to a given column that is managed by the QueryToMapGen to generate its data for a given Attribute. For more information, click here. |
| QueryLoopSetGen | Query only once within a table in a database and set the loopCount. |
| QueryMapBeforeLoopGen | Query two columns from one or more joined database tables to create a map in memory. |
| QueryOnceGen | Query only once within a table of a database using SQL. |
| QueryOnceV2Gen | Query only once within a table of a database using SQL. |
| QueryReGenerateOnHitGen | Query a column in a database table, using an SQL statement, on EACH iteration of test generation and validates whether the referenced value exists or not. If the value exists, the Generator calls the Generator of referenced value to regenerate the next value, which is again validated for its existence. |
| QueryToMapGen | Query data from one or more database table columns into a memory buffer. For more information, click here. |
| QueryMaxGen | QueryMaxGen Generator allows querying the max value of a column within a table using an SQL select max() statement. |
| RangeQueryGen | Query for max row within a given table and set the startRange to the value of the result returned + 1. |
| RangeQueryV2Gen | Query for max row within a given table and set the startRange to the value of the result returned + 1. |
| SFQueryGen | Query a column of data from a Salesforce object. The query takes place in real-time via a Salesforce REST web service call. |
| CSVToMapGen | Allows you to read data from one or more columns from a CSV file. |
| CSVFromMapGen | Reads the value of a particular column by Column Name from the result of CSVToMapGen. |
| CSVIndexToMapGen | Reads the value of one or more columns from a particular row in a CSV file. |
| CSVIndexFromMapGen | Reads the value of a particular column by Column Name from the result of CSVIndexToMapGen. |
| CSVResourceGen | Loads column data from the first detail row within a CSV file. |
| CSVResourceIndexGen | Loads column data from a given row within a CSV file. |
| EvalCaseSentenceCSVGen | Emulates multiple if-then-else cases by returning the first true value and loading the Subject, Predicates, and Clause from a CSV file to make sentences. |
| ListCSVGen | Loads list from column data within a CSV file. |
| ListCSVV2Gen | Loads list from column data within a CSV file. |
| ListCSVIndexGen | Loads list from column data within a CSV file. |
| MapCSVChildGen | Loads list from column data within a CSV file based on key column. |
| MapCSVGen | Loads list from column data within a CSV file. |
| MapCSVManualDistGen | Loads key/value pair into map from column data present in the CSV file and find the closest key based on referenced value. |
| MultiKeyMapCSVGen | Generates data as a result of mapping multiple keys generated from a set of Attributes to value from a CSV file matching those keys in a CSV file. |
| MultiWeightCSVGen | Allows multiple values to have weighting to determine how often each value is generated. Values and their respective weights are read from the delimited file at runtime. |
| PermutationCSVGen | Loads a list of values from a CSV file. Then it communicates with other Attributes within the same Domain, using a Permutation type Generator to compute the sum of all possible permutations. |
| SentenceCSVGen | Loads the Subject, Predicates, and Clause from a CSV file to make sentences. |
| ExcelChildFromMapGen | Reads the value of a particular column from the result of ExcelToMapGen. |
| ExcelChildToMapGen | Read data from one or more columns from an Excel file. |
| ExcelToMapGen | Reads data from one or more columns from an Excel file. |
| ExcelFromMapGen | Reads the value of a particular column by Column Name from the result of ExcelToMapGen. |
| ListExcelGen | Loads its list from the column data within an Excel file. |
| MapExcelGen | Reads data from Excel Spreadsheet and returns the first matched value from the column provided in valueColumn parameter. |
| MapExcelChildGen | Reads data from Excel Spreadsheet and creates Map again on every Child Domain iteration and returns the matched value from the column provided in valueColumn parameter. |