Chilkat Online Tools

DescribeTableStatistics VB6 Example

AWS Database Migration Service

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim rest As New ChilkatRest
Dim success As Long

Dim authAws As New ChilkatAuthAws
authAws.AccessKey = "AWS_ACCESS_KEY"
authAws.SecretKey = "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.Region = "us-west-2"
authAws.ServiceName = "dms"
' SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
success = 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,1,1)
If (success <> 1) Then
    Debug.Print "ConnectFailReason: " & rest.ConnectFailReason
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' 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

Dim json As New ChilkatJsonObject
success = json.UpdateString("Filters[0].Name","string")
success = json.UpdateString("Filters[0].Values[0]","string")
success = json.UpdateString("Marker","string")
success = json.UpdateInt("MaxRecords",123)
success = json.UpdateString("ReplicationTaskArn","string")

' The JSON request body created by the above code:

' {
'   "Filters": [
'     {
'       "Name": "string",
'       "Values": [
'         "string"
'       ]
'     }
'   ],
'   "Marker": "string",
'   "MaxRecords": number,
'   "ReplicationTaskArn": "string"
' }

success = rest.AddHeader("Content-Type","application/x-amz-json-1.1")
success = rest.AddHeader("X-Amz-Target","AmazonDMSv20160101.DescribeTableStatistics")

Dim sbRequestBody As New ChilkatStringBuilder
success = json.EmitSb(sbRequestBody)
Dim sbResponseBody As New ChilkatStringBuilder
success = rest.FullRequestSb("POST","/",sbRequestBody,sbResponseBody)
If (success <> 1) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim respStatusCode As Long
respStatusCode = rest.ResponseStatusCode
Debug.Print "response status code = " & respStatusCode
If (respStatusCode <> 200) Then
    Debug.Print "Response Header:"
    Debug.Print rest.ResponseHeader
    Debug.Print "Response Body:"
    Debug.Print sbResponseBody.GetAsString()
    Exit Sub
End If

Dim jResp As New ChilkatJsonObject
success = 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

Dim Ddls As Long
Dim Deletes As Long
Dim FullLoadCondtnlChkFailedRows As Long
Dim FullLoadEndTime As Long
Dim FullLoadErrorRows As Long
Dim FullLoadReloaded As Long
Dim FullLoadRows As Long
Dim FullLoadStartTime As Long
Dim Inserts As Long
Dim LastUpdateTime As Long
Dim SchemaName As String
Dim TableName As String
Dim TableState As String
Dim Updates As Long
Dim ValidationFailedRecords As Long
Dim ValidationPendingRecords As Long
Dim ValidationState As String
Dim ValidationStateDetails As String
Dim ValidationSuspendedRecords As Long

Dim Marker As String
Marker = jResp.StringOf("Marker")
Dim ReplicationTaskArn As String
ReplicationTaskArn = jResp.StringOf("ReplicationTaskArn")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("TableStatistics")
Do While i < count_i
    jResp.I = 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
Loop

' 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
'     }
'   ]
' }