DescribeTableStatistics Java Example
import com.chilkatsoft.*;
public class ChilkatExample {
static {
try {
System.loadLibrary("chilkat");
} catch (UnsatisfiedLinkError e) {
System.err.println("Native code library failed to load.\n" + e);
System.exit(1);
}
}
public static void main(String argv[])
{
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
CkRest rest = new CkRest();
boolean success;
CkAuthAws authAws = new CkAuthAws();
authAws.put_AccessKey("AWS_ACCESS_KEY");
authAws.put_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.put_Region("us-west-2");
authAws.put_ServiceName("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) {
System.out.println("ConnectFailReason: " + rest.get_ConnectFailReason());
System.out.println(rest.lastErrorText());
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
CkJsonObject json = new CkJsonObject();
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");
CkStringBuilder sbRequestBody = new CkStringBuilder();
json.EmitSb(sbRequestBody);
CkStringBuilder sbResponseBody = new CkStringBuilder();
success = rest.FullRequestSb("POST","/",sbRequestBody,sbResponseBody);
if (success != true) {
System.out.println(rest.lastErrorText());
return;
}
int respStatusCode = rest.get_ResponseStatusCode();
System.out.println("response status code = " + respStatusCode);
if (respStatusCode != 200) {
System.out.println("Response Header:");
System.out.println(rest.responseHeader());
System.out.println("Response Body:");
System.out.println(sbResponseBody.getAsString());
return;
}
CkJsonObject jResp = new CkJsonObject();
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
int Ddls;
int Deletes;
int FullLoadCondtnlChkFailedRows;
int FullLoadEndTime;
int FullLoadErrorRows;
int FullLoadReloaded;
int FullLoadRows;
int FullLoadStartTime;
int Inserts;
int LastUpdateTime;
String SchemaName;
String TableName;
String TableState;
int Updates;
int ValidationFailedRecords;
int ValidationPendingRecords;
String ValidationState;
String ValidationStateDetails;
int ValidationSuspendedRecords;
String Marker = jResp.stringOf("Marker");
String ReplicationTaskArn = jResp.stringOf("ReplicationTaskArn");
int i = 0;
int count_i = jResp.SizeOfArray("TableStatistics");
while (i < count_i) {
jResp.put_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;
}
// 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
// }
// ]
// }
}
}
