GetQueryExecution 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, "athena")
; SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
CkRest::ckSetAuthAws(rest,authAws)
; URL: https://athena.us-west-2.amazonaws.com/
; Use the same region as specified above.
success = CkRest::ckConnect(rest,"athena.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,"QueryExecutionId","string")
; The JSON request body created by the above code:
; {
; "QueryExecutionId": "string"
; }
CkRest::ckAddHeader(rest,"Content-Type","application/x-amz-json-1.1")
CkRest::ckAddHeader(rest,"X-Amz-Target","AmazonAthena.GetQueryExecution")
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
EffectiveEngineVersion.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.EngineVersion.EffectiveEngineVersion")
SelectedEngineVersion.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.EngineVersion.SelectedEngineVersion")
Query.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.Query")
Catalog.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.QueryExecutionContext.Catalog")
Database.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.QueryExecutionContext.Database")
QueryExecutionId.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.QueryExecutionId")
S3AclOption.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.ResultConfiguration.AclConfiguration.S3AclOption")
EncryptionOption.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.ResultConfiguration.EncryptionConfiguration.EncryptionOption")
KmsKey.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.ResultConfiguration.EncryptionConfiguration.KmsKey")
ExpectedBucketOwner.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.ResultConfiguration.ExpectedBucketOwner")
OutputLocation.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.ResultConfiguration.OutputLocation")
StatementType.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.StatementType")
DataManifestLocation.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.Statistics.DataManifestLocation")
DataScannedInBytes.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Statistics.DataScannedInBytes")
EngineExecutionTimeInMillis.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Statistics.EngineExecutionTimeInMillis")
QueryPlanningTimeInMillis.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Statistics.QueryPlanningTimeInMillis")
QueryQueueTimeInMillis.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Statistics.QueryQueueTimeInMillis")
ServiceProcessingTimeInMillis.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Statistics.ServiceProcessingTimeInMillis")
TotalExecutionTimeInMillis.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Statistics.TotalExecutionTimeInMillis")
ErrorCategory.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Status.AthenaError.ErrorCategory")
ErrorMessage.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.Status.AthenaError.ErrorMessage")
ErrorType.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Status.AthenaError.ErrorType")
Retryable.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Status.AthenaError.Retryable")
CompletionDateTime.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Status.CompletionDateTime")
State.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.Status.State")
StateChangeReason.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.Status.StateChangeReason")
SubmissionDateTime.i = CkJsonObject::ckIntOf(jResp,"QueryExecution.Status.SubmissionDateTime")
WorkGroup.s = CkJsonObject::ckStringOf(jResp,"QueryExecution.WorkGroup")
; A sample JSON response body parsed by the above code:
; {
; "QueryExecution": {
; "EngineVersion": {
; "EffectiveEngineVersion": "string",
; "SelectedEngineVersion": "string"
; },
; "Query": "string",
; "QueryExecutionContext": {
; "Catalog": "string",
; "Database": "string"
; },
; "QueryExecutionId": "string",
; "ResultConfiguration": {
; "AclConfiguration": {
; "S3AclOption": "string"
; },
; "EncryptionConfiguration": {
; "EncryptionOption": "string",
; "KmsKey": "string"
; },
; "ExpectedBucketOwner": "string",
; "OutputLocation": "string"
; },
; "StatementType": "string",
; "Statistics": {
; "DataManifestLocation": "string",
; "DataScannedInBytes": number,
; "EngineExecutionTimeInMillis": number,
; "QueryPlanningTimeInMillis": number,
; "QueryQueueTimeInMillis": number,
; "ServiceProcessingTimeInMillis": number,
; "TotalExecutionTimeInMillis": number
; },
; "Status": {
; "AthenaError": {
; "ErrorCategory": number,
; "ErrorMessage": "string",
; "ErrorType": number,
; "Retryable": boolean
; },
; "CompletionDateTime": number,
; "State": "string",
; "StateChangeReason": "string",
; "SubmissionDateTime": number
; },
; "WorkGroup": "string"
; }
; }
CkRest::ckDispose(rest)
CkAuthAws::ckDispose(authAws)
CkJsonObject::ckDispose(json)
CkStringBuilder::ckDispose(sbRequestBody)
CkStringBuilder::ckDispose(sbResponseBody)
CkJsonObject::ckDispose(jResp)
ProcedureReturn
EndProcedure
