Column Configuration Options

A typical column format will contain the below options

• Name : Column name
• Type : Column type. This is a mandatory option.
• Config : Column configuration

Supported Column Types

• string
• int
• date
• bool
• default
• email
• decimal
• list
• guid

String Type Column Configuration Options

• length - Length of the random string to be generated, this is excluding the prefix and suffix. If not specified default value of 5 will be taken. We can generate multiple words seperated by one space by including "|" symbol and entering the word length. For example, if we want to generate two word string where first word is for four character length and the second word is of five character length then the length config is specified as below

{ "length " : "4|5" }

• prefix - Prefix to be added to the generated string. This is optional.
• suffix - Suffix to be added to the generated string. This is optional.
• case - Determines the case of the generated string. Below defined are the supported cases and their definitions. By default, this is set to sentence case
  • upper - Converts the string to upper case.
    • Expected Output String - LOREM
  • lower - Converts the string to lower case.
    • Expected Output String - lorem
  • title - Converts the string to title case case.
    • Expected Output String - Lorem or for multi word strings Lorem Ipsum
  • sentence - Converts the string to upper case.
    • Expected Output String - Lorem or for multi word strings Lorem ipsum
  • camel - Converts the string to upper case.
    • Expected Output String - camel or for multi word strings camelCase
  • pascal - Converts the string to upper case.
    • Expected Output String - Pascal or for multi word strings PascalCase
  • snake - Converts the string to upper case.
    • Expected Output String - snake or for multi word strings snake_case
  • kebab - Converts the string to upper case.
    • Expected Output String - kebab or for multi word strings kebab-case

Int Type Column Configuration Options

• min - Minimum value from which the random integer must be generated. By default this is set to 1
• max - Maximum value below which the random integer must be generated. By default this is set to 1000
• prefix - Prefix to be added to the generated integer. This is optional.
• suffix - Suffix to be added to the generated integer. This is optional.
• increment - A boolean value indicating true/false. When this is set to true all the rows in the generated file will have integers sequentially incremented starting from the value set in min. The increment or the step value is defined by another property "interval" stated below. By default, this will be false.
• interval - The incremental value to be used in case when increment property is set to true. By default, this is set to 1 hence this is a non mandatory field.

Date Type Column Configuration Options

• format - Format of the date to be formed. By default this is set to yyyyMMddHHmmssffff
• minYear - Minimum value of year from which the random date must be generated. By default this is set to 1.
• maxYear - Maximum value of year from which the random date must be generated. By default this is set to current year.

Bool Type Column Configuration Options

• No configuration is required. Randomly a true or false value is generated.

Default Type Column Configuration Options

• defaultValue - Default value to be populated for all the rows. This is a mandatory field.

Email Type Column Configuration Options

• No configuration required. By default an email of the format {5}@{5}.{3} is generated where the number in {} represents the length of the string generated

Decimal Type Column Configuration Options

• min - Minimum value from which the random integer must be generated. By default this is set to 1.
• max - Maximum value below which the random integer must be generated. By default this is set to 1000.
• decimalPart - Number of digits to be shown after the decimal. By default this is set to 2.

List Type Column Configuration Options

• items : An array of objects from which a item has to be picked randomly. This is a mandatory field.

Sample list type column config

{
  "name": "CustomValues",
  "type": "list",
  "config": {
    "items": [
      "kjds",
      1,
      "bool",
      "any"
    ]
  }
}

Guid Type

• Generates a guid string