You can call GetStructSyncJobAnalyzeResult to obtain the analysis result of the schema synchronization task.

Debugging

OpenAPI Explorer automatically calculates the signature value. For your convenience, we recommend that you call this operation in OpenAPI Explorer. OpenAPI Explorer dynamically generates the sample code of the operation for different SDKs.

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:

  • CREATE_TABLE : creates a table.
  • ALTER_TABLE : modifies a table.
  • EQUAL_TABLE : Same table
  • PASS_TABLE : Skipped tables
  • NOT_COMPARE : the table to be analyzed
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:

  • CREATE_TABLE : creates a table.
  • ALTER_TABLE : modifies a table.
  • EQUAL_TABLE : Same table
  • PASS_TABLE : Skipped tables
  • NOT_COMPARE : the table to be analyzed
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&regionid=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.