Help Center > > User Guide> GaussDB(for MySQL) DB Instance Management (Development Tool)> Data Scheme> Data Generator

Data Generator

Updated at: Jun 09, 2021 GMT+08:00

Scenarios

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. On the top menu bar, choose Data Scheme > Data Generator.
  2. On the displayed page, click Create Task. In the displayed dialog box, configure the required parameters.

    Figure 1 Creating a data generation task
    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 Type

      On the Create Task page, double-click one column. 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.

  3. Click Preview to check whether the generated data is as expected. If not, modify the settings. Then, click Generate. Alternatively, directly click Generate.

    Figure 3 Data preview
    Figure 4 Test data generation progress

  4. In the task list, locate the created task and click Details. You can also delete the task as required.

    Figure 5 Task list

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel