Skip to main content

Data generator

In this path you will learn how to generate a set of test data, thanks to which you will be able to operate on data close to real data during your work.

Below is the material presenting the resulting functionality.

Issues presented in the current article​

DATA STRUCTURE

  1. Building a data structure
  2. Adding fields to a data structure
  3. Building relationships between data structures

LIST

  1. Building a list
  2. List properties
  3. Actions on a list
  4. The @Parent parameter in SQL queries

FORM

  1. Toolbox and data-bound controls
  2. Container and its properties
  3. Embedding a list in a form
  4. Read-only attribute

PACKAGES

  1. Data generator
  2. Map In Place mapping
  3. Browse Data
  4. Saving data to the database

OTHER

  1. Using expressions

STEP 1 - DATA STRUCTURE​

In this step:

  1. You will create a data structures of products
  2. You will create a relations between the Owner and Vehicles structures

STEP 2 - DATA GENERATOR​

In this step:

  1. You will create a processing package (blocks: Random Data Generator, Map In Place, Browse Data and Database Writer)
  2. You will define the ranges for the random data generator
  3. You will use expressions to generate email addresses
  4. You will save the generated data to the database

STEP 3 - LISTS​

In this step:

  1. You will create the list based on a simple SQL query
  2. You will generate the columns of the list with an additional action column
  3. You will define the list properties, ie list title and columns width

STEP 4 - FORM​

In this step:

  1. You will create a form with data of vehicle owners
  2. You will use the container and specify its properties
  3. You will embed the list on the form

STEP 5 - MENU​

In this step:

  1. You will define a menu object for the application
  2. You will add a menu item navigating to the list