Help Center/ Data Admin Service/ User Guide/ GaussDB(for MySQL)/ Data Generator (Not Promoted)
Updated on 2024-09-05 GMT+08:00

Data Generator (Not Promoted)

DAS can automatically generate test data according to certain rules. This test data can be inserted into a database to test program functions. This section describes how to generate test data according to the predefined rules.

Procedure

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Data Scheme > Data Generator.
  7. On the displayed page, click Create Task.

    Figure 1 Creating a data generation task

  8. In the displayed dialog box, configure required parameters.

    Figure 2 Configuring task parameters
    • Rows to Generate

      A maximum of 1,000,000 rows of data can be generated.

    • Conflict Policy

      If you select Skip, the system skips data rows in conflict and continues generating data. If you select Replace, the system replaces existing rows with new ones that have the same primary key.

    • Generation Mode

      On the Create Task page, double-click one column you want to select. Set rules for generating data randomly based on the column information. For example, if the column name is time, you need to specify start and end time and the generation format. Alternatively, select Based on current time.

  9. Click Preview to check whether the data that will be generated can meet your requirements. If not, adjust the generation rules.

    Figure 3 Data preview

  10. Click Generate.

    Figure 4 Test data generation progress

  11. In the task list, locate the created task and click Details.

    You can also delete the task as required.
    Figure 5 Task list