Data type and specific values

The following generators populate a column with a specific value or a random value of a specific type.

For more information about each generator and how to configure in the application, go to Data type and specific values.

Blank

The Blank generator inserts a null value.

{ 
  "name": string,
  "data_type": string,
  "generator": "Blank",
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Boolean

Inserts a random boolean value - either true or false.

{ 
  "name": string,
  "data_type": string,
  "generator": "Boolean",
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Constant

Inserts the same value into all of the rows.

{ 
  "name": string,
  "data_type": string,
  "generator": "Constant",
  // Generator-specific fields
  "constant_value": string, // The value to assign to the column
  // End generator-specific fields
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Image (binary)

Produces a JPEG image in binary format.

{ 
  "name": string,
  "data_type": string,
  "generator": "Image (binary)",
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Lorem Ipsum

Populates the column with filler text.

{ 
  "name": string,
  "data_type": string,
  "generator": "Lorem Ipsum",
  // Generator-specific fields
  "lorem_ipsum_unit": "words"|"sentences"|"paragraphs", // Content format
  "distribution": "fixed"|"normal"|"uniform", // Type of distribution to use
  // -----------------------------------------------------------------------
  // Fixed distribution
  "exact_value": integer, // The exact length
  // ----------------------------------------------------------------------
  // Uniform distribution
  "min": integer, // Minimum length
  "max": integer, // Maximum length
  // ---------------------------------------------------------------------
  // Normal distribution
  "min": integer, // Minimum length
  "mean": string, // Mean length
  "std_dev": string, // Standard deviation
  "max": integer, // Maximum length
  // End generator-specific fields
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Number

Inserts a numeric value.

{ 
  "name": string,
  "data_type": string,
  "generator": "Number",
  // Generator-specific fields
  "distribution": "autoincrement"|"uniform"|"binomial"|"exponential"|
                  "geometric"|"normal"|"poisson"|"series", // Distribution type
  "min": integer // For autoincrement, the increment value
  "conditions": [ // Set of variants for non-autoincrement distribution
    {  
      "condition_type": "sql"|”percentage", // The type of condition
      "conditions": string, // For sql, the expression to identify the condition 
                           // that triggers the variant
      "condition_percentage": float, // For percentage, the percentage of records
                                     // that use the variant
      // ---------------------------------------------------------------------
      // Uniform distribution
      "min": integer, // Minimum value
      "max": integer, // Maximum value
      "decimals": integer, // Number of decimal places
      // ---------------------------------------------------------------------
      // Binomial distribution
      "trials": string // Number of tests
      "success_probability": string, // Success probability
      // ---------------------------------------------------------------------
      // Exponential distribution
      "min": integer, // Minimum value
      "rate": string, // Rate of increase
      "max": integer, // Maximum value
      "decimals": integer, // Number of decimal places
      // ----------------------------------------------------------------------
      // Geometric distribution
      "min": integer, // Minimum value
      "success_probability": string, // Success probability
      "max": integer, // Maximum value
      "decimals": integer, // Number of decimal places
      // ---------------------------------------------------------------------
      // Normal distribution
      "min": integer, // Minimum value
      "mean": string, // Mean value
      "std_dev": string, // Standard deviation
      "max": integer, // Maximum value
      "decimals": integer, // Number of decimal places
      // ---------------------------------------------------------------------
      // Poisson distribution
      "min": integer, // Minimum value
      "mean": string, // Mean value
      "max": integer, // Maximum value
      "decimals": integer, // Number of decimal places
      // ---------------------------------------------------------------------
      // Series distribution
      "start_field_id": uuid, // Start field
      "end_field_id": uuid, // End field
      "partition_by_field_id": uuid, // Partition by field
      "order_by_field_id": uuid, // Order by field
      "decimals": integer, // Number of decimal places
      "curve_type": "exponential"|"logarithmic"|"from column", // Curve type
      "rate": string, // Rate of increase for exponential and
                      // logarithmic curve types
      "curve_type_field_id": uuid, // Field for From field curve type
      "volatility_type": "fixed"|"from_column", // Type of volatility
      "volatility": string, // Fixed volatility value
      "volatility_field_id": uuid // From column volatility column
    }
  ],
  // End generator-specific fields
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

UUID

Generates a random universally unique identifier (UUID).

{ 
  "name": string,
  "data_type": string,
  "generator": "UUID",
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}