Help Center> Data Admin Service> User Guide> MySQL> Generating Test Data
Updated on 2023-12-13 GMT+08:00

Generating Test Data

During the functional testing of a program, a large amount of test data complying with specific rules needs to be inserted into the database. DAS can help you generate test data based on specific rules. This section describes how to generate test data on the DAS console.

Procedure

  1. Log in to the management 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

      You can set the rules for randomly generated data based on the column settings. For example, if the column type is time, you can set the start time, end time, and format, or 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