DescribeTableStatistics Go Example
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
rest := chilkat.NewRest()
var success bool
authAws := chilkat.NewAuthAws()
authAws.SetAccessKey("AWS_ACCESS_KEY")
authAws.SetSecretKey("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.)
authAws.SetRegion("us-west-2")
authAws.SetServiceName("dms")
// SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
rest.SetAuthAws(authAws)
// URL: https://dms.us-west-2.amazonaws.com/
// Use the same region as specified above.
success = rest.Connect("dms.us-west-2.amazonaws.com",443,true,true)
if success != true {
fmt.Println("ConnectFailReason: ", rest.ConnectFailReason())
fmt.Println(rest.LastErrorText())
rest.DisposeRest()
authAws.DisposeAuthAws()
return
}
// 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 := chilkat.NewJsonObject()
json.UpdateString("Filters[0].Name","string")
json.UpdateString("Filters[0].Values[0]","string")
json.UpdateString("Marker","string")
json.UpdateInt("MaxRecords",123)
json.UpdateString("ReplicationTaskArn","string")
// The JSON request body created by the above code:
// {
// "Filters": [
// {
// "Name": "string",
// "Values": [
// "string"
// ]
// }
// ],
// "Marker": "string",
// "MaxRecords": number,
// "ReplicationTaskArn": "string"
// }
rest.AddHeader("Content-Type","application/x-amz-json-1.1")
rest.AddHeader("X-Amz-Target","AmazonDMSv20160101.DescribeTableStatistics")
sbRequestBody := chilkat.NewStringBuilder()
json.EmitSb(sbRequestBody)
sbResponseBody := chilkat.NewStringBuilder()
success = rest.FullRequestSb("POST","/",sbRequestBody,sbResponseBody)
if success != true {
fmt.Println(rest.LastErrorText())
rest.DisposeRest()
authAws.DisposeAuthAws()
json.DisposeJsonObject()
sbRequestBody.DisposeStringBuilder()
sbResponseBody.DisposeStringBuilder()
return
}
respStatusCode := rest.ResponseStatusCode()
fmt.Println("response status code = ", respStatusCode)
if respStatusCode != 200 {
fmt.Println("Response Header:")
fmt.Println(rest.ResponseHeader())
fmt.Println("Response Body:")
fmt.Println(*sbResponseBody.GetAsString())
rest.DisposeRest()
authAws.DisposeAuthAws()
json.DisposeJsonObject()
sbRequestBody.DisposeStringBuilder()
sbResponseBody.DisposeStringBuilder()
return
}
jResp := chilkat.NewJsonObject()
jResp.LoadSb(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
var Ddls int
var Deletes int
var FullLoadCondtnlChkFailedRows int
var FullLoadEndTime int
var FullLoadErrorRows int
var FullLoadReloaded int
var FullLoadRows int
var FullLoadStartTime int
var Inserts int
var LastUpdateTime int
SchemaName_DECLARATION
TableName_DECLARATION
TableState_DECLARATION
var Updates int
var ValidationFailedRecords int
var ValidationPendingRecords int
ValidationState_DECLARATION
ValidationStateDetails_DECLARATION
var ValidationSuspendedRecords int
Marker := jResp.StringOf("Marker")
ReplicationTaskArn := jResp.StringOf("ReplicationTaskArn")
i := 0
count_i := jResp.SizeOfArray("TableStatistics")
for i < count_i {
jResp.SetI(i)
Ddls = jResp.IntOf("TableStatistics[i].Ddls")
Deletes = jResp.IntOf("TableStatistics[i].Deletes")
FullLoadCondtnlChkFailedRows = jResp.IntOf("TableStatistics[i].FullLoadCondtnlChkFailedRows")
FullLoadEndTime = jResp.IntOf("TableStatistics[i].FullLoadEndTime")
FullLoadErrorRows = jResp.IntOf("TableStatistics[i].FullLoadErrorRows")
FullLoadReloaded = jResp.IntOf("TableStatistics[i].FullLoadReloaded")
FullLoadRows = jResp.IntOf("TableStatistics[i].FullLoadRows")
FullLoadStartTime = jResp.IntOf("TableStatistics[i].FullLoadStartTime")
Inserts = jResp.IntOf("TableStatistics[i].Inserts")
LastUpdateTime = jResp.IntOf("TableStatistics[i].LastUpdateTime")
SchemaName = *jResp.StringOf("TableStatistics[i].SchemaName")
TableName = *jResp.StringOf("TableStatistics[i].TableName")
TableState = *jResp.StringOf("TableStatistics[i].TableState")
Updates = jResp.IntOf("TableStatistics[i].Updates")
ValidationFailedRecords = jResp.IntOf("TableStatistics[i].ValidationFailedRecords")
ValidationPendingRecords = jResp.IntOf("TableStatistics[i].ValidationPendingRecords")
ValidationState = *jResp.StringOf("TableStatistics[i].ValidationState")
ValidationStateDetails = *jResp.StringOf("TableStatistics[i].ValidationStateDetails")
ValidationSuspendedRecords = jResp.IntOf("TableStatistics[i].ValidationSuspendedRecords")
i = i + 1
}
// 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
// }
// ]
// }
rest.DisposeRest()
authAws.DisposeAuthAws()
json.DisposeJsonObject()
sbRequestBody.DisposeStringBuilder()
sbResponseBody.DisposeStringBuilder()
jResp.DisposeJsonObject()
