Defining properties of schemas

After you generate the schema from the configured database in HCL® OneTest Data, you must define the required properties for all schemas.

Before you begin

You must have completed the following tasks:
  1. Created a project.
  2. Generated schemas in HCL® OneTest Data by using a JDBC connection. See Generating a schema in HCL OneTest Data.

Procedure

  1. Log in to HCL OneTest Server and open the team space that contains your project.
  2. Open your project.
    The Overview page is displayed.
  3. Click Author > Data Fabrication.
    The Data Fabrication page is displayed.
  4. Select the generated schema from the Schemas tab.

    For example, schema_<number>

  5. Click the Menu icon of the group type of the schema and select Structure.

    You can view the list of all item types associated with the selected group type in the structural view of the schema.

  6. Click the Menu icon of all item types in the Structure dialog box to set the following properties:
    1. Click Set Required to get at least one occurrence of the item type in the generated test data, and then click Save.
    2. Click Properties for the selected item types and perform the following steps for Item Properties:
      1. Verify the values of the Item Subclass and Presentation fields.

        For example, if the item type is of a number data type, then the value for Item Subclass is Number and Presentation is Integer.

      2. Set the Min size and Max size for the item types of the schema.

        If the value of Subclass is Number and Presentation is Integer for an item type, then set the value of Min size and Max size as the number of digits that can be generated in the test data.

        Note: The value for Min size (digits) should be less than or equal to Max size (digits).

        For example, if the item type is of a number data type, then you can set the Min size (digits) as 1 and the Max size (digits) as 9.

    Notes:
    • The values of both the Min size (digits) and Max size (digits) properties for item types that act as a primary and foreign keys must be same.
    • You must set the value of Min size and Max size for an Integer item type such that the number of digits of the generated test data is between the range of 1 and 9 and the generated test data is between -2147483648 to 2147483647.
  7. Save the changes.
    You must repeat steps 2 through step 5 to set the properties for all schemas.

Results

You have defined the properties for all schemas.

What to do next

You can click Schema Canvas to select the defined and structured schemas that you want to use to generate the test data. See Selecting multiple schemas.