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 such as real postal addresses can be combined with synthetically generated names
- Query Generators make it easy to create a subset of real production data
GenRocket Query Generators
GenRocket provides 17 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. |
| 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. |
| 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. |
| MapCSVGen | Loads list from column data within a CSV file. |
| MultiKeyMapCSVGen | Generates data as a result of mapping multiple keys generated from a set of Attributes to value from CSV file matching those keys in 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 delimited file at runtime. |
| PermutationCSVGen | Loads a list of values from a CSV file. Then it communicates with other Attributes within the same Domain, also 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. |
| 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. |