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

PermutationQueryGenQueries 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.
QueryBeforeLoopGenQueries a column within a table using an SQL select statement BEFORE the 1st iteration of test data generation.
QueryBeforeLoopV2GenQueries a column within a table using an SQL select statement BEFORE the 1st iteration of test data generation. For more information, click here.
QueryCountGenCreate 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.

QueryEachFromMapGenReads the value of a particular column from the result of QueryEachToMapGen.
QueryEachToMapGenUsing 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.
QueryFromMapGenMaps to a given column that is managed by the QueryToMapGen to generate its data for a given Attribute. For more information, click here.
QueryLoopSetGenQuery 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.
QueryOnceGenQuery only once within a table of a database using SQL.
QueryOnceV2GenQuery only once within a table of a database using SQL.
QueryToMapGenQuery data from one or more database table columns into a memory buffer. For more information, click here.
RangeQueryGenQuery for max row within a given table and set the startRange to the value of the result returned + 1.
SFQueryGenQuery 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.
CSVFromMapGenReads 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. 
CSVIndexFromMapGenReads the value of a particular column by Column Name from the result of CSVIndexToMapGen.
CSVResourceGenLoads column data from the first detail row within a CSV file. 
CSVResourceIndexGenLoads column data from a given row within a CSV file. 
EvalCaseSentenceCSVGenEmulates 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. 
ListCSVGenLoads list from column data within a CSV file. 
ListCSVV2GenLoads list from column data within a CSV file.
MapCSVGenLoads list from column data within a CSV file.
MultiKeyMapCSVGenGenerates 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. 
MultiWeightCSVGenAllows 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. 
PermutationCSVGenLoads 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. 
SentenceCSVGenLoads the Subject, Predicates, and Clause from a CSV file to make sentences.