You can call GetStructSyncJobAnalyzeResult to obtain the analysis result of the schema synchronization task.
Debugging
Parameters
Parameter | Type | Is it required? | Example | Description |
---|---|---|---|---|
OrderId | Long | Yes | 1342355 |
Work Order Number |
CompareType | String | No | CREATE_TABLE |
The comparison type. Valid values:
|
PageNumber | Long | No | 1 |
page number. |
PageSize | Long | No | 20 |
The amount of data per page. |
Tid | Long | No | 1 |
The tenant has expired. Note The information of the tenant's chart is taken from the avatar in the upper-right
corner of the system. For more information, see View tenant information .
|
RegionId | String | No | cn-hangzhou |
Select the service region of the destination region to call this operation. For more information about the valid values, see switchegionfigure parameter description . Note select based on the location of the application nearby.
|
return data
Parameter | Type | Example | Description |
---|---|---|---|
RequestId | String | 1810E635-A2D7-428B-BAA9-85DAEB9B1A77 |
The error message returned because the request already exists. |
Success | Boolean | true |
Whether the request is successful. |
ErrorMessage | String | UnknownError |
Error message. |
ErrorCode | String | UnknownError |
Error code. |
StructSyncJobAnalyzeResult | object |
The analysis result of the schema synchronization task. |
|
SummaryList | Array of Summary |
The list of statistical results. |
|
CompareType | String | CREATE_TABLE |
The comparison type. Valid values:
|
Count | Long | 1 |
The number of tables. |
ResultList | Array of Result |
The detailed list of analysis results. |
|
SourceTableName | String | helloz_bak |
The name of the source table. |
TargetTableName | String | helloz_bak |
The name of the destination table. |
Script | String | /* origin table[helloz_bak] exist, target table[helloz_bak] not exist */\N /* Generate [helloz_bak] create table SQL */\ncreate table 'helloz_bak '(\n \'tid' bigInt (20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'primary key',\n\t' gmt_create' datetime NOT NULL COMMENT' creation time ',\n \tid' gmt_modified' datetime NOT NULL COMMENT 'number 11, time modification time (nnnint)'), NOT NULL COMMENT '(N \n\t'addr' varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'address',\n \t{{********** ('id')\n)\nDEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci\nCOMMENT='test'\n; |
The following example describes the script. |
Examples
Sample requests
http(s)://dms-enterprise.aliyuncs.com/? descrirderizd=1342355 &CompareType=CREATE_TABLE&descriageizumber=1&descriageizize=20®ionid=1&common request parameters
Sample success responses
XML
Format
HTT/ 1.1 200 OK Content-Type:application/xml <GetStructSyncJobAnalyzeResultResponse> <StructSyncJobAnalyzeResult> <eesultist> <SourceTableName>data_modify</SourceTableName> <crmarker>/* origin table[data_modify] exist, target table[data_modify] not exist * /* Generate [data_modify] exist (CREATE TABLE SQL) 'name' (CREATE TABLE 'data_modify) 'primary key * /* /* Generate [data_modify] unsigned NOT NULL AUTO_INCREMENT COMMENT (' vmax), NOT NULL COMMENT ''phone' varchar(32) DEFAULT NULL COMMENT 'phone', 'sex' varchar(32) DEFAULT NULL COMMENT 'gender', 'email' varchar(256) DEFAULT NULL COMMENT 'mailbox', 'user_desc' varchar(1024) DEFAULT NULL COMMENT 'commentary', // timescalate'id' ('id') ) DEFAULT CHARSET=utf8 COMMENT='data modification table';</Script> <TargetTableName>data_modify</TargetTableName> </ResultList> <ResultList> <SourceTableName>task_data</SourceTableName> <Script>/* origin table[task_data] exist target table[task_data] not exist * // * Generate [task_data] create table SQL */ create table 'task_data ' ( 'id' bigInt (20) unsigned NOT NULL AUTO_INCREMENT COMMENT' primary key ', ' gmt_create' datetime NOT NULL COMMENT 'creation time,' gmt_modified' datetime NOT NULL COMMENT 'modification time', 'content' text COMMENT 'test data', // choose modifyMY KKEE( 'id') ) DEFAULT CHARSET=utf8mb4 COMMENT='task orchestration test table';</Script> <TargetTableName>task_data</TargetTableName> </ResultList> <SummaryList> <CompareType>CREATE_TABLE</CompareType> <Count>2</Count> </SummaryList> <SummaryList> <CompareType>EQUAL_TABLE</CompareType> <Count>1</Count> </SummaryList> </StructSyncJobAnalyzeResult> <RequestId>472C5F33-198B-4A41-BF83-B2322636B583</RequestId> <Success>true</success> </GetStructSyncJobAnalyzeResultResponse>
JSON
Format
HTT/ 1.1200 OK Content-Type:application/json { "StructSyncJobAnalyzeResult" : { "createsulterist" : [ { "SourceTableName" : "data_modify", "Origin marker" : "/* origin table[data_modify] exist, target table[data_modify] not exist */\N /* generate primary key (CREATE TABLE SQL) '(ncreate table 'data_modify)' () unsigned NOT NULL AUTO_INCREMENT COMMENT *)\n the 'name' varchar(256) NOT NULL COMMENT 'name' \n 'phone' varchar(32) DEFAULT NULL COMMENT 'telephone' \N 'sex' varchar(32) DEFAULT NULL COMMENT' gender '\n 'email' varchar(256) DEFAULT NULL COMMENT mailbox' \n 'user_desc' varchar(1024) DEFAULT NULL COMMENT 'Comment' \n PRIMARY KEY ('id')\n) DEFAULT CHARSET=utf8 COMMENT='data modifications on the test;" "TargetTableName" : "data_modify" }, { "SourceTableName" : "task_data", "Script" : "/* origin table[task_data] exist target table[task_data] not exist */\N /* Generate [task_data] create table SQL */\ncreate table 'task_data' \n 'id' bigInt (20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key' \n 'gmt_create' datetime NOT NULL COMMENT' creation time,\n 'gmt_modified' datetime NOT NULL COMMENT' modification time of the file,\n 'content' text COMMENT test data, \N PRIMARY KEY ('id')\n) DEFAULT CHARSET=utf8mb4 COMMENT=task orchestration test;", "TargetTableName" : "task_data" } ], "SummaryList", the conditions must be: [ { "CompareType" : "CREATE_TABLE", "Count" : 2 }, { "CompareType" : "EQUAL_TABLE" "Sum" : 1 } ] }, "updatequestsidd" : "sum", "descriuccess" : true}
Error code
Access error Center For more information, see error codes.