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. |
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. |