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.

Array

Populates the field with an array of values.

{
   "name": string,
   "generator": "Array",
    // Generator-specific fields
   "items": {
        "generator": string // Generator for the array values
    // Configuration for the selected generator.
    },
   "distribution": "fixed"|"normal"|"uniform", // Distribution to use for the 
                                               // number of array values
   // Fixed distribution
   "exact_value": number // Exact number of array values
   // Uniform distribution
   "min": number, // Minimum number of array values
   "max": number, // Maximum number of array values
   // Normal distribution
   "min": number, // Minimum number of array valuesl
   "max": number, // Maximum number of array values
   "mean": number, // Mean number of array values
   "stddev": number, // Standard deviation for the number of array values
   //End generator-specific fields
   "percent_null": integer,
   "virtual": boolean,
   // Advanced options
   "primary_key": boolean,
   "index": boolean,
   "seed": string,
   "postprocessing_sql": string
}

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
}

Object

Populates the field with a JSON object.

{
   "name": string,
   "generator": "Object",
   // Generator-specific fields
   "fields": [
   // Entry for each field
      {
         "name": string // Name of the object field
         "generator": string // Generator for the field value
         // Configuration for the selected generator
      }
    ],
   // 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
}