DescribeStatement C Example
#include <C_CkRest.h>
#include <C_CkAuthAws.h>
#include <C_CkJsonObject.h>
#include <C_CkStringBuilder.h>
void ChilkatSample(void)
{
HCkRest rest;
BOOL success;
HCkAuthAws authAws;
HCkJsonObject json;
HCkStringBuilder sbRequestBody;
HCkStringBuilder sbResponseBody;
int respStatusCode;
HCkJsonObject jResp;
const char *name;
const char *value;
const char *ClusterIdentifier;
int CreatedAt;
const char *Database;
const char *DbUser;
int Duration;
const char *Error;
int HasResultSet;
const char *Id;
const char *QueryString;
int RedshiftPid;
int RedshiftQueryId;
int ResultRows;
int ResultSize;
const char *SecretArn;
const char *Status;
int UpdatedAt;
int i;
int count_i;
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
rest = CkRest_Create();
authAws = CkAuthAws_Create();
CkAuthAws_putAccessKey(authAws,"AWS_ACCESS_KEY");
CkAuthAws_putSecretKey(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_putRegion(authAws,"us-west-2");
CkAuthAws_putServiceName(authAws,"redshift-data");
// SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
CkRest_SetAuthAws(rest,authAws);
// URL: https://redshift-data.us-west-2.amazonaws.com/
// Use the same region as specified above.
success = CkRest_Connect(rest,"redshift-data.us-west-2.amazonaws.com",443,TRUE,TRUE);
if (success != TRUE) {
printf("ConnectFailReason: %d\n",CkRest_getConnectFailReason(rest));
printf("%s\n",CkRest_lastErrorText(rest));
CkRest_Dispose(rest);
CkAuthAws_Dispose(authAws);
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 = CkJsonObject_Create();
CkJsonObject_UpdateString(json,"Id","string");
// The JSON request body created by the above code:
// {
// "Id": "string"
// }
CkRest_AddHeader(rest,"Content-Type","application/x-amz-json-1.1");
CkRest_AddHeader(rest,"X-Amz-Target","RedshiftData.DescribeStatement");
sbRequestBody = CkStringBuilder_Create();
CkJsonObject_EmitSb(json,sbRequestBody);
sbResponseBody = CkStringBuilder_Create();
success = CkRest_FullRequestSb(rest,"POST","/",sbRequestBody,sbResponseBody);
if (success != TRUE) {
printf("%s\n",CkRest_lastErrorText(rest));
CkRest_Dispose(rest);
CkAuthAws_Dispose(authAws);
CkJsonObject_Dispose(json);
CkStringBuilder_Dispose(sbRequestBody);
CkStringBuilder_Dispose(sbResponseBody);
return;
}
respStatusCode = CkRest_getResponseStatusCode(rest);
printf("response status code = %d\n",respStatusCode);
if (respStatusCode != 200) {
printf("Response Header:\n");
printf("%s\n",CkRest_responseHeader(rest));
printf("Response Body:\n");
printf("%s\n",CkStringBuilder_getAsString(sbResponseBody));
CkRest_Dispose(rest);
CkAuthAws_Dispose(authAws);
CkJsonObject_Dispose(json);
CkStringBuilder_Dispose(sbRequestBody);
CkStringBuilder_Dispose(sbResponseBody);
return;
}
jResp = CkJsonObject_Create();
CkJsonObject_LoadSb(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
// Chilkat functions returning "const char *" return a pointer to temporary internal memory owned and managed by Chilkat.
// See this example explaining how this memory should be used: const char * functions.
ClusterIdentifier = CkJsonObject_stringOf(jResp,"ClusterIdentifier");
CreatedAt = CkJsonObject_IntOf(jResp,"CreatedAt");
Database = CkJsonObject_stringOf(jResp,"Database");
DbUser = CkJsonObject_stringOf(jResp,"DbUser");
Duration = CkJsonObject_IntOf(jResp,"Duration");
Error = CkJsonObject_stringOf(jResp,"Error");
HasResultSet = CkJsonObject_IntOf(jResp,"HasResultSet");
Id = CkJsonObject_stringOf(jResp,"Id");
QueryString = CkJsonObject_stringOf(jResp,"QueryString");
RedshiftPid = CkJsonObject_IntOf(jResp,"RedshiftPid");
RedshiftQueryId = CkJsonObject_IntOf(jResp,"RedshiftQueryId");
ResultRows = CkJsonObject_IntOf(jResp,"ResultRows");
ResultSize = CkJsonObject_IntOf(jResp,"ResultSize");
SecretArn = CkJsonObject_stringOf(jResp,"SecretArn");
Status = CkJsonObject_stringOf(jResp,"Status");
UpdatedAt = CkJsonObject_IntOf(jResp,"UpdatedAt");
i = 0;
count_i = CkJsonObject_SizeOfArray(jResp,"QueryParameters");
while (i < count_i) {
CkJsonObject_putI(jResp,i);
name = CkJsonObject_stringOf(jResp,"QueryParameters[i].name");
value = CkJsonObject_stringOf(jResp,"QueryParameters[i].value");
i = i + 1;
}
i = 0;
count_i = CkJsonObject_SizeOfArray(jResp,"SubStatements");
while (i < count_i) {
CkJsonObject_putI(jResp,i);
CreatedAt = CkJsonObject_IntOf(jResp,"SubStatements[i].CreatedAt");
Duration = CkJsonObject_IntOf(jResp,"SubStatements[i].Duration");
Error = CkJsonObject_stringOf(jResp,"SubStatements[i].Error");
HasResultSet = CkJsonObject_IntOf(jResp,"SubStatements[i].HasResultSet");
Id = CkJsonObject_stringOf(jResp,"SubStatements[i].Id");
QueryString = CkJsonObject_stringOf(jResp,"SubStatements[i].QueryString");
RedshiftQueryId = CkJsonObject_IntOf(jResp,"SubStatements[i].RedshiftQueryId");
ResultRows = CkJsonObject_IntOf(jResp,"SubStatements[i].ResultRows");
ResultSize = CkJsonObject_IntOf(jResp,"SubStatements[i].ResultSize");
Status = CkJsonObject_stringOf(jResp,"SubStatements[i].Status");
UpdatedAt = CkJsonObject_IntOf(jResp,"SubStatements[i].UpdatedAt");
i = i + 1;
}
// A sample JSON response body parsed by the above code:
// {
// "ClusterIdentifier": "string",
// "CreatedAt": number,
// "Database": "string",
// "DbUser": "string",
// "Duration": number,
// "Error": "string",
// "HasResultSet": boolean,
// "Id": "string",
// "QueryParameters": [
// {
// "name": "string",
// "value": "string"
// }
// ],
// "QueryString": "string",
// "RedshiftPid": number,
// "RedshiftQueryId": number,
// "ResultRows": number,
// "ResultSize": number,
// "SecretArn": "string",
// "Status": "string",
// "SubStatements": [
// {
// "CreatedAt": number,
// "Duration": number,
// "Error": "string",
// "HasResultSet": boolean,
// "Id": "string",
// "QueryString": "string",
// "RedshiftQueryId": number,
// "ResultRows": number,
// "ResultSize": number,
// "Status": "string",
// "UpdatedAt": number
// }
// ],
// "UpdatedAt": number
// }
CkRest_Dispose(rest);
CkAuthAws_Dispose(authAws);
CkJsonObject_Dispose(json);
CkStringBuilder_Dispose(sbRequestBody);
CkStringBuilder_Dispose(sbResponseBody);
CkJsonObject_Dispose(jResp);
}