| object | | |
RequestId | string | | 427688B8-ADFB-4C4E-9D45-EF5C1FD6E23D |
DataCorrectOrderDetail | object | The information about the data change ticket. | |
PreCheckDetail | array<object> | The precheck details of the ticket. | |
| object | | |
UserTip | string | The message that indicates a check step. | tip messsage |
CheckStatus | string | The status of the precheck. Valid values:
- WAITING: The ticket is pending precheck.
- RUNNING: The ticket is being prechecked.
- SUCCESS: The ticket passes the precheck.
- FAIL: The ticket fails the precheck.
| SUCCESS |
CheckStep | string | The check step of the precheck. Valid values:
- SQL_PARSE: The system checks the syntax of the SQL statement.
- SQL_TYPE_CHECK: The system checks the type of the SQL statement.
- PERMISSION_CHECK: The system checks the permissions required for the data change.
- ROW_CHECK: The system checks the number of affected rows.
| PERMISSION_CHECK |
OrderDetail | object | The details of the ticket. | |
RbSQL | string | The SQL statements used to roll back the data change. | empty |
RbAttachmentName | string | The name of the attachment that contains the SQL statements used to roll back the data change. | test |
Classify | string | The category of the reason for the data change. | test |
ExeSQL | string | The executed SQL statements. | update t1 set name = 'xxx' where id <= 100 |
EstimateAffectRows | long | The estimated number of affected rows. | 100 |
RbSQLType | string | The format of the SQL statements used to roll back the data change. Valid values:
- TEXT: text
- ATTACHMENT: attachment
| text |
ActualAffectRows | long | The number of affected rows that is obtained by the precheck. | 100 |
IgnoreAffectRows | boolean | Indicates whether the precheck result is ignored. Valid values:
- true: The precheck result is ignored.
- false: The precheck result is not ignored.
| false |
AttachmentName | string | The name of the attachment that contains the SQL statements used to change data. | xxx |
SqlType | string | The format of the SQL statements used to change data. Valid values:
- TEXT: text
- ATTACHMENT: attachment
| text |
IgnoreAffectRowsReason | string | The reason why the precheck result is ignored. | test |
DatabaseList | array<object> | The information about the database in which data is changed. | |
| object | | |
DbId | integer | | 1860**** |
DbType | string | The engine of the database. | mysql |
Logic | boolean | Indicates whether the database is a logical database. Valid values:
- true: The database is a logical database.
- false: The database is a physical database.
| false |
SearchName | string | The name that is used to search for the database. | xxx@xxx:3306 |
EnvType | string | The type of the environment to which the database belongs. Valid values:
- product: production environment
- dev: development environment
- pre: staging environment
- test: test environment
- sit: system integration testing (SIT) environment
- uat: user acceptance testing (UAT) environment
- pet: stress testing environment
- stag: STAG environment
| product |
Status | string | The status of the ticket. Valid values:
- new: The ticket is created.
- precheck: The ticket is being prechecked.
- precheck_fail: The ticket fails the precheck.
- precheck_success: The ticket passes the precheck and waits to be submitted for approval.
- toaudit: The ticket is being reviewed.
- Approved: The ticket is approved.
- reject: The ticket is rejected.
- waiting: The ticket is submitted and waits to be scheduled.
- processing: The ticket is being executed.
- success: The ticket is executed.
- closed: The ticket is closed.
| approved |
ExecMode | string | The execution mode of the ticket after the ticket is approved. Valid values:
- COMMITOR: The data change is performed by the user who submits the ticket.
- AUTO: The data change is automatically performed after the ticket is approved.
- LAST_AUDITOR: The data change is performed by the last approver of the ticket.
| COMMITOR |
ErrorCode | string | The error code returned if the request fails. | UnknownError |
ErrorMessage | string | The error message returned if the request fails. | UnknownError |
Success | boolean | Indicates whether the request is successful. Valid values:
- true: The request is successful.
- false: The request fails.
| true |