scenario: id: 65abf943-53e4-476a-820f-9d1f7601678a context: auth: type: digest base_path: /v1beta2 host: null description: ng_cluster_imports name: ng_cluster_imports steps: - operation_id: TidbService_CreateTidb request_type: http request: |- { "method": "POST", "path": "/tidbs", "headers": {}, "query_params": {}, "body": { "displayName": "sce-ng-cluster-imports", "regionId": "{regionId}", "minRcu": "5000", "maxRcu": "6000", "servicePlan": "Premium", "cloudProvider": "{cloud_provider}" }, "body_params": { "regionId": "region_id", "cloud_provider": "cloud_provider" }, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } } } expect: |- { "status_code": 200, "cel": "" } save: |- { "placeholder": [ { "key": "cluster_1", "eval": "body.tidbId" } ] } description: "" max_retries: 0 delay_after: 0 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 0 - operation_id: PrivateEndpointConnectionService_GetPrivateLinkService request_type: http request: |- { "method": "GET", "path": "/tidbs/{tidbId}/privateLinkService", "headers": {}, "query_params": {}, "body": {}, "path_params": { "tidbId": "cluster_1" }, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } } } expect: |- { "status_code": 200, "cel": "body.state == 'ACTIVE'" } save: |- { "placeholder": [ { "key": "private_link_service_1", "eval": "body.serviceName" } ] } description: '' max_retries: 120 delay_after: 30 name: '' continue_on_unexpected: false stage: '' meta: '{}' generation_id: '' order: 0.5 - operation_id: TidbService_GetTidb request_type: http request: |- { "method": "GET", "path": "/tidbs/{tidbId}", "headers": {}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1" } } expect: |- { "status_code": 200, "cel": "body.state == 'ACTIVE'" } save: null description: "" max_retries: 120 delay_after: 30 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 1 - operation_id: TidbService_ResetRootPassword request_type: http request: |- { "method": "POST", "path": "/tidbs/{tidbId}:resetRootPassword", "headers": {}, "query_params": {}, "body": { "rootPassword": "pi31415926" }, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1" } } expect: |- { "status_code": 200, "cel": "" } save: null description: '' max_retries: 5 delay_after: 60 name: '' continue_on_unexpected: false stage: '' meta: '{}' generation_id: '' order: 1.5 - operation_id: PublicConnectionSettingService_UpdatePublicConnectionSetting request_type: http request: |- { "method": "PATCH", "path": "/tidbs/{tidbId}/publicConnectionSetting", "headers": {}, "query_params": {}, "body": { "enabled": true, "ipAccessList": [ { "cidrNotation": "0.0.0.0/0", "description": "Allow all IPs" } ] }, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1" } } expect: |- { "status_code": 200, "cel": "" } save: null description: "" max_retries: 0 delay_after: 0 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 2 - operation_id: ClusterService_GetCluster generation_id: 09198df8-3eef-4d82-a5a4-31eb9b0db7de order: 3 case_type: supplimental_positive request_type: http request: |- { "auth": { "auth_type": "digest", "content": {"private_key": "placeholder","public_key": "placeholder"} }, "method": "GET", "path": "/tidbs/{tidbId}", "path_params": { "tidbId": "cluster_1" }, "query_params": {}, "headers": {}, "body": {} } expect: |- { "status_code": 200, "cel": "body.state == \"ABC\"" } description: Poll the cluster state until it becomes ACTIVE. max_retries: 30 delay_after: 10 step_type: defined name: force_wait_dns save: null continue_on_unexpected: true stage: prepare meta: "{}" - operation_id: TidbService_GetTidb request_type: http request: |- { "method": "GET", "path": "/tidbs/{tidbId}", "headers": {}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1" } } expect: |- { "status_code": 200, "cel": "body.state == \"ACTIVE\" && size(body.endpoints.filter(e, e.connectionType == 'PUBLIC')) > 0 && body.endpoints.filter(e, e.connectionType == 'PUBLIC')[0].host != \"\"" } save: |- { "placeholder": [ {"key": "public_endpoint", "eval": "body.endpoints.filter(e, e.connectionType == 'PUBLIC')[0].host"}, {"key": "port", "eval": "body.endpoints.filter(e, e.connectionType == 'PUBLIC')[0].port"} ] } description: "" max_retries: 120 delay_after: 30 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 4 - operation_id: CheckImportDatabaseConnectivity request_type: http request: |- { "method": "POST", "path": "/tidbs/{tidbId}/imports:checkDatabaseConnectivity", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "path_params": { "tidbId": "cluster_1" }, "body": { "username": "root", "password": "pi31415926" }, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } } } expect: |- { "status_code": 200, "cel": "body.success == true" } save: null description: "" max_retries: 0 delay_after: 0 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 4.5 - operation_id: CheckImportSource request_type: http request: |- { "method": "POST", "path": "/tidbs/{tidbId}/imports:checkSource", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "path_params": { "tidbId": "cluster_1" }, "body": { "source": { "type": "ENUM_S3", "s3": { "uri": "s3://tidbcloud-sample-data/data-ingestion/", "authType": "ENUM_ROLE_ARN", "roleArn": "arn:aws:iam::801626783489:role/import-sample-access" } } }, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } } } expect: |- { "status_code": 200, "cel": "body.success == true" } save: null description: "" max_retries: 0 delay_after: 0 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 5 - operation_id: CreateImportIntoTask request_type: http request: |- { "method": "POST", "path": "/tidbs/{tidbId}/imports", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "path_params": { "tidbId": "cluster_1" }, "body": { "username": "root", "password": "pi31415926", "creationDetails": { "source": { "type": "ENUM_S3", "s3": { "uri": "s3://tidbcloud-sample-data/data-ingestion/", "authType": "ENUM_ROLE_ARN", "roleArn": "arn:aws:iam::801626783489:role/import-sample-access" } }, "targetTableInfos": [ { "database": "bikeshare", "table": "trips", "filesWildcard": "s3://tidbcloud-sample-data/data-ingestion/bikeshare.trips.*.sql" } ] } }, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } } } expect: |- { "status_code": 200, "cel": "" } save: |- { "placeholder": [ { "key": "import_1", "eval": "body.importId" } ] } description: "" max_retries: 0 delay_after: 0 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 6 - operation_id: ListImportIntoTasks request_type: http request: |- { "method": "GET", "path": "/tidbs/{tidbId}/imports?pageSize=20&pageToken=0", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1" } } expect: |- { "status_code": 200, "cel": "body.totalSize > 0" } save: null description: "" max_retries: 120 delay_after: 30 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 7 - operation_id: CancelImportIntoTask request_type: http request: |- { "method": "POST", "path": "/tidbs/{tidbId}/imports/{importId}:cancel", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1", "importId": "import_1" } } expect: |- { "status_code": 200, "cel": "" } save: null description: "Cancel Import task under prepare stage" max_retries: 0 delay_after: 0 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 8 - operation_id: GetImportIntoTask request_type: http request: |- { "method": "GET", "path": "/tidbs/{tidbId}/imports/{importId}", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1", "importId": "import_1" } } expect: |- { "status_code": 200, "cel": "body.state == 'ENUM_CANCELED'" } save: null description: "" max_retries: 60 delay_after: 5 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 9 - operation_id: CreateImportIntoTask request_type: http request: |- { "method": "POST", "path": "/tidbs/{tidbId}/imports", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "path_params": { "tidbId": "cluster_1" }, "body": { "username": "root", "password": "pi31415926", "creationDetails": { "source": { "type": "ENUM_S3", "s3": { "uri": "s3://tidbcloud-sample-data/data-ingestion/", "authType": "ENUM_ROLE_ARN", "roleArn": "arn:aws:iam::801626783489:role/import-sample-access" } }, "targetTableInfos": [ { "database": "bikeshare", "table": "trips", "filesWildcard": "s3://tidbcloud-sample-data/data-ingestion/bikeshare.trips.*.sql" } ] } }, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } } } expect: |- { "status_code": 200, "cel": "" } save: |- { "placeholder": [ { "key": "import_3", "eval": "body.importId" } ] } description: "" max_retries: 0 delay_after: 0 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 10 - operation_id: ListImportIntoTasks request_type: http request: |- { "method": "GET", "path": "/tidbs/{tidbId}/imports?pageSize=20&pageToken=0", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1" } } expect: |- { "status_code": 200, "cel": "body.totalSize > 0" } save: null description: "" max_retries: 120 delay_after: 30 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 11 - operation_id: GetImportIntoTask request_type: http request: |- { "method": "GET", "path": "/tidbs/{tidbId}/imports/{importId}", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1", "importId": "import_3" } } expect: |- { "status_code": 200, "cel": "body.state == 'ENUM_IMPORTING'" } save: null description: "" max_retries: 60 delay_after: 5 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 12 - operation_id: CancelImportIntoTask request_type: http request: |- { "method": "POST", "path": "/tidbs/{tidbId}/imports/{importId}:cancel", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1", "importId": "import_3" } } expect: |- { "status_code": 200, "cel": "" } save: null description: "Cancel Import task under Importing stage" max_retries: 0 delay_after: 0 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 13 - operation_id: GetImportIntoTask request_type: http request: |- { "method": "GET", "path": "/tidbs/{tidbId}/imports/{importId}", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1", "importId": "import_3" } } expect: |- { "status_code": 200, "cel": "body.state == 'ENUM_CANCELED'" } save: null description: "" max_retries: 60 delay_after: 5 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 14 - operation_id: CheckImportSource request_type: http request: |- { "method": "POST", "path": "/tidbs/{tidbId}/imports:checkSource", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "path_params": { "tidbId": "cluster_1" }, "body": { "source": { "type": "ENUM_S3", "s3": { "uri": "s3://tidbcloud-sample-data/data-ingestion/", "authType": "ENUM_ROLE_ARN", "roleArn": "arn:aws:iam::801626783489:role/import-sample-access" } } }, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } } } expect: |- { "status_code": 200, "cel": "body.success == true" } save: null description: "" max_retries: 0 delay_after: 0 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 15 - operation_id: CreateImportIntoTask request_type: http request: |- { "method": "POST", "path": "/tidbs/{tidbId}/imports", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "path_params": { "tidbId": "cluster_1" }, "body": { "username": "root", "password": "pi31415926", "creationDetails": { "source": { "type": "ENUM_S3", "s3": { "uri": "s3://tidbcloud-sample-data/data-ingestion/", "authType": "ENUM_ROLE_ARN", "roleArn": "arn:aws:iam::801626783489:role/import-sample-access" } }, "targetTableInfos": [ { "database": "bikeshare", "table": "trips", "filesWildcard": "s3://tidbcloud-sample-data/data-ingestion/bikeshare.trips.*.sql" } ] } }, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } } } expect: |- { "status_code": 200, "cel": "" } save: |- { "placeholder": [ { "key": "import_2", "eval": "body.importId" } ] } description: "" max_retries: 0 delay_after: 0 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 16 - operation_id: ListImportIntoTasks request_type: http request: |- { "method": "GET", "path": "/tidbs/{tidbId}/imports?pageSize=20&pageToken=0", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1" } } expect: |- { "status_code": 200, "cel": "body.totalSize > 0" } save: null description: "" max_retries: 120 delay_after: 30 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 17 - operation_id: GetImportIntoTask request_type: http request: |- { "method": "GET", "path": "/tidbs/{tidbId}/imports/{importId}", "headers": {"Accept": "application/json+camel"}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1", "importId": "import_2" } } expect: |- { "status_code": 200, "cel": "body.state == 'ENUM_COMPLETED'" } save: null description: "" max_retries: 60 delay_after: 10 name: "" continue_on_unexpected: false stage: "" meta: "{}" generation_id: "" order: 18 - operation_id: Mysqlsh_connection generation_id: 09198df8-3eef-4d82-a5a4-31eb9b0db7de order: 19 case_type: typical_positive request_type: cmd_mysqlsh request: |- { "name": "mysqlsh", "args": [ "--sql", "mysql://root:pi31415926@{public_endpoint}:{port}/mysql", "--result-format=json", "-e", "select count(*) as count from bikeshare.trips", "--quiet-start=2" ], "args_params": { "public_endpoint": "public_endpoint", "port": "port" } } expect: |- { "exit_code": 0, "cel": "output.count > 0" } description: Check the connection status of the cluster. max_retries: 0 delay_after: 0 step_type: defined name: check_password continue_on_unexpected: false save: null stage: execute meta: "{}" - operation_id: TidbService_DeleteTidb request_type: http request: |- { "method": "DELETE", "path": "/tidbs/{tidbId}", "headers": {}, "query_params": {}, "body": {}, "auth": { "auth_type": "digest", "content": { "private_key": "placeholder", "public_key": "placeholder" } }, "path_params": { "tidbId": "cluster_1" } } expect: |- { "status_code": 200, "cel": "" } save: null description: '' max_retries: 0 delay_after: 0 name: '' continue_on_unexpected: false stage: '' meta: '{}' generation_id: '' order: 20