DescribeTableStatistics PureBasic Example
IncludeFile "CkJsonObject.pb"
IncludeFile "CkStringBuilder.pb"
IncludeFile "CkRest.pb"
IncludeFile "CkAuthAws.pb"
Procedure ChilkatExample()
; This example requires the Chilkat API to have been previously unlocked.
; See Global Unlock Sample for sample code.
rest.i = CkRest::ckCreate()
If rest.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
success.i
authAws.i = CkAuthAws::ckCreate()
If authAws.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkAuthAws::setCkAccessKey(authAws, "AWS_ACCESS_KEY")
CkAuthAws::setCkSecretKey(authAws, "AWS_SECRET_KEY")
; Don't forget to change the region to your particular region. (Also make the same change in the call to Connect below.)
CkAuthAws::setCkRegion(authAws, "us-west-2")
CkAuthAws::setCkServiceName(authAws, "dms")
; SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
CkRest::ckSetAuthAws(rest,authAws)
; URL: https://dms.us-west-2.amazonaws.com/
; Use the same region as specified above.
success = CkRest::ckConnect(rest,"dms.us-west-2.amazonaws.com",443,1,1)
If success <> 1
Debug "ConnectFailReason: " + Str(CkRest::ckConnectFailReason(rest))
Debug CkRest::ckLastErrorText(rest)
CkRest::ckDispose(rest)
CkAuthAws::ckDispose(authAws)
ProcedureReturn
EndIf
; The following code creates the JSON request body.
; The JSON created by this code is shown below.
; Use this online tool to generate code from sample JSON:
; Generate Code to Create JSON
json.i = CkJsonObject::ckCreate()
If json.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkJsonObject::ckUpdateString(json,"Filters[0].Name","string")
CkJsonObject::ckUpdateString(json,"Filters[0].Values[0]","string")
CkJsonObject::ckUpdateString(json,"Marker","string")
CkJsonObject::ckUpdateInt(json,"MaxRecords",123)
CkJsonObject::ckUpdateString(json,"ReplicationTaskArn","string")
; The JSON request body created by the above code:
; {
; "Filters": [
; {
; "Name": "string",
; "Values": [
; "string"
; ]
; }
; ],
; "Marker": "string",
; "MaxRecords": number,
; "ReplicationTaskArn": "string"
; }
CkRest::ckAddHeader(rest,"Content-Type","application/x-amz-json-1.1")
CkRest::ckAddHeader(rest,"X-Amz-Target","AmazonDMSv20160101.DescribeTableStatistics")
sbRequestBody.i = CkStringBuilder::ckCreate()
If sbRequestBody.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkJsonObject::ckEmitSb(json,sbRequestBody)
sbResponseBody.i = CkStringBuilder::ckCreate()
If sbResponseBody.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
success = CkRest::ckFullRequestSb(rest,"POST","/",sbRequestBody,sbResponseBody)
If success <> 1
Debug CkRest::ckLastErrorText(rest)
CkRest::ckDispose(rest)
CkAuthAws::ckDispose(authAws)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(sbRequestBody)
CkStringBuilder::ckDispose(sbResponseBody)
ProcedureReturn
EndIf
respStatusCode.i = CkRest::ckResponseStatusCode(rest)
Debug "response status code = " + Str(respStatusCode)
If respStatusCode <> 200
Debug "Response Header:"
Debug CkRest::ckResponseHeader(rest)
Debug "Response Body:"
Debug CkStringBuilder::ckGetAsString(sbResponseBody)
CkRest::ckDispose(rest)
CkAuthAws::ckDispose(authAws)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(sbRequestBody)
CkStringBuilder::ckDispose(sbResponseBody)
ProcedureReturn
EndIf
jResp.i = CkJsonObject::ckCreate()
If jResp.i = 0
Debug "Failed to create object."
ProcedureReturn
EndIf
CkJsonObject::ckLoadSb(jResp,sbResponseBody)
; The following code parses the JSON response.
; A sample JSON response is shown below the sample code.
; Use this online tool to generate parsing code from sample JSON:
; Generate Parsing Code from JSON
Ddls.i
Deletes.i
FullLoadCondtnlChkFailedRows.i
FullLoadEndTime.i
FullLoadErrorRows.i
FullLoadReloaded.i
FullLoadRows.i
FullLoadStartTime.i
Inserts.i
LastUpdateTime.i
SchemaName.s
TableName.s
TableState.s
Updates.i
ValidationFailedRecords.i
ValidationPendingRecords.i
ValidationState.s
ValidationStateDetails.s
ValidationSuspendedRecords.i
Marker.s = CkJsonObject::ckStringOf(jResp,"Marker")
ReplicationTaskArn.s = CkJsonObject::ckStringOf(jResp,"ReplicationTaskArn")
i.i = 0
count_i.i = CkJsonObject::ckSizeOfArray(jResp,"TableStatistics")
While i < count_i
CkJsonObject::setCkI(jResp, i)
Ddls = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].Ddls")
Deletes = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].Deletes")
FullLoadCondtnlChkFailedRows = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].FullLoadCondtnlChkFailedRows")
FullLoadEndTime = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].FullLoadEndTime")
FullLoadErrorRows = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].FullLoadErrorRows")
FullLoadReloaded = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].FullLoadReloaded")
FullLoadRows = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].FullLoadRows")
FullLoadStartTime = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].FullLoadStartTime")
Inserts = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].Inserts")
LastUpdateTime = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].LastUpdateTime")
SchemaName = CkJsonObject::ckStringOf(jResp,"TableStatistics[i].SchemaName")
TableName = CkJsonObject::ckStringOf(jResp,"TableStatistics[i].TableName")
TableState = CkJsonObject::ckStringOf(jResp,"TableStatistics[i].TableState")
Updates = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].Updates")
ValidationFailedRecords = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].ValidationFailedRecords")
ValidationPendingRecords = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].ValidationPendingRecords")
ValidationState = CkJsonObject::ckStringOf(jResp,"TableStatistics[i].ValidationState")
ValidationStateDetails = CkJsonObject::ckStringOf(jResp,"TableStatistics[i].ValidationStateDetails")
ValidationSuspendedRecords = CkJsonObject::ckIntOf(jResp,"TableStatistics[i].ValidationSuspendedRecords")
i = i + 1
Wend
; A sample JSON response body parsed by the above code:
; {
; "Marker": "string",
; "ReplicationTaskArn": "string",
; "TableStatistics": [
; {
; "Ddls": number,
; "Deletes": number,
; "FullLoadCondtnlChkFailedRows": number,
; "FullLoadEndTime": number,
; "FullLoadErrorRows": number,
; "FullLoadReloaded": boolean,
; "FullLoadRows": number,
; "FullLoadStartTime": number,
; "Inserts": number,
; "LastUpdateTime": number,
; "SchemaName": "string",
; "TableName": "string",
; "TableState": "string",
; "Updates": number,
; "ValidationFailedRecords": number,
; "ValidationPendingRecords": number,
; "ValidationState": "string",
; "ValidationStateDetails": "string",
; "ValidationSuspendedRecords": number
; }
; ]
; }
CkRest::ckDispose(rest)
CkAuthAws::ckDispose(authAws)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(sbRequestBody)
CkStringBuilder::ckDispose(sbResponseBody)
CkJsonObject::ckDispose(jResp)
ProcedureReturn
EndProcedure