(Visual FoxPro) DynamoDB - DeleteTable

The DeleteTable operation deletes a table and all of its items. After a DeleteTable request, the specified table is in the DELETING state until DynamoDB completes the deletion.

For more information, see https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_DeleteTable.html

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

LOCAL loRest
LOCAL lnSuccess
LOCAL loAuthAws
LOCAL lnBTls
LOCAL lnPort
LOCAL lnBAutoReconnect
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL loJsonResponse
LOCAL lcTableDescriptionTableArn
LOCAL lnTableDescriptionItemCount
LOCAL lnTableDescriptionProvisionedThroughputNumberOfDecreasesToday
LOCAL lnTableDescriptionProvisionedThroughputReadCapacityUnits
LOCAL lnTableDescriptionProvisionedThroughputWriteCapacityUnits
LOCAL lcTableDescriptionTableName
LOCAL lnTableDescriptionTableSizeBytes
LOCAL lcTableDescriptionTableStatus

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Rest')
loRest = CreateObject('Chilkat.Rest')

* Implements the following CURL command:

* curl -X POST https://dynamodb.us-west-2.amazonaws.com/ \
*   -H "Accept-Encoding: identity" \
*   -H "Content-Type: application/x-amz-json-1.0" \
*   -H "Authorization: AWS4-HMAC-SHA256 Credential=<Credential>, SignedHeaders=<Headers>, Signature=<Signature>" \
*   -H "X-Amz-Date: <Date>" \
*   -H "X-Amz-Target: DynamoDB_20120810.DeleteTable" \
*   -d '{
*     "TableName": "Thread"
* }'

* Use the following online tool to generate REST code from a CURL command
* Convert a cURL Command to REST Source Code

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.AuthAws')
loAuthAws = CreateObject('Chilkat.AuthAws')
loAuthAws.AccessKey = "AWS_ACCESS_KEY"
loAuthAws.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.)
loAuthAws.Region = "us-west-2"
loAuthAws.ServiceName = "dynamodb"
* SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
loRest.SetAuthAws(loAuthAws)

* URL: https://dynamodb.us-west-2.amazonaws.com/
lnBTls = 1
lnPort = 443
lnBAutoReconnect = 1
* Don't forget to change the region domain (us-west-2.amazonaws.com) to your particular region.
lnSuccess = loRest.Connect("dynamodb.us-west-2.amazonaws.com",lnPort,lnBTls,lnBAutoReconnect)
IF (lnSuccess <> 1) THEN
    ? "ConnectFailReason: " + STR(loRest.ConnectFailReason)
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loAuthAws
    CANCEL
ENDIF

* Note: The above code does not need to be repeatedly called for each REST request.
* The rest object can be setup once, and then many requests can be sent.  Chilkat will automatically
* reconnect within a FullRequest* method as needed.  It is only the very first connection that is explicitly
* made via the Connect method.

* Use this online tool to generate code from sample JSON:
* Generate Code to Create JSON

* The following JSON is sent in the request body.

* {
*   "TableName": "Thread"
* }

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJson = CreateObject('Chilkat.JsonObject')
loJson.UpdateString("TableName","Thread")

loRest.AddHeader("Content-Type","application/x-amz-json-1.0")
loRest.AddHeader("X-Amz-Target","DynamoDB_20120810.DeleteTable")
loRest.AddHeader("Accept-Encoding","identity")

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbRequestBody = CreateObject('Chilkat.StringBuilder')
loJson.EmitSb(loSbRequestBody)
* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.StringBuilder')
loSbResponseBody = CreateObject('Chilkat.StringBuilder')
lnSuccess = loRest.FullRequestSb("POST","/",loSbRequestBody,loSbResponseBody)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loAuthAws
    RELEASE loJson
    RELEASE loSbRequestBody
    RELEASE loSbResponseBody
    CANCEL
ENDIF

lnRespStatusCode = loRest.ResponseStatusCode
? "response status code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
    ? "Response Status Code = " + STR(lnRespStatusCode)
    ? "Response Header:"
    ? loRest.ResponseHeader
    ? "Response Body:"
    ? loSbResponseBody.GetAsString()
    RELEASE loRest
    RELEASE loAuthAws
    RELEASE loJson
    RELEASE loSbRequestBody
    RELEASE loSbResponseBody
    CANCEL
ENDIF

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
loJsonResponse = CreateObject('Chilkat.JsonObject')
loJsonResponse.LoadSb(loSbResponseBody)

loJsonResponse.EmitCompact = 0
? loJsonResponse.Emit()

* Sample JSON response:
* (Sample code for parsing the JSON response is shown below)

* {
*   "TableDescription": {
*     "TableArn": "arn:aws:dynamodb:us-west-2:123456789012:table/Thread",
*     "ItemCount": 0,
*     "ProvisionedThroughput": {
*       "NumberOfDecreasesToday": 0,
*       "ReadCapacityUnits": 5,
*       "WriteCapacityUnits": 5
*     },
*     "TableName": "Thread",
*     "TableSizeBytes": 0,
*     "TableStatus": "DELETING"
*   }
* }

* Sample code for parsing the JSON response...
* Use the following online tool to generate parsing code from sample JSON:
* Generate Parsing Code from JSON

lcTableDescriptionTableArn = loJsonResponse.StringOf("TableDescription.TableArn")
lnTableDescriptionItemCount = loJsonResponse.IntOf("TableDescription.ItemCount")
lnTableDescriptionProvisionedThroughputNumberOfDecreasesToday = loJsonResponse.IntOf("TableDescription.ProvisionedThroughput.NumberOfDecreasesToday")
lnTableDescriptionProvisionedThroughputReadCapacityUnits = loJsonResponse.IntOf("TableDescription.ProvisionedThroughput.ReadCapacityUnits")
lnTableDescriptionProvisionedThroughputWriteCapacityUnits = loJsonResponse.IntOf("TableDescription.ProvisionedThroughput.WriteCapacityUnits")
lcTableDescriptionTableName = loJsonResponse.StringOf("TableDescription.TableName")
lnTableDescriptionTableSizeBytes = loJsonResponse.IntOf("TableDescription.TableSizeBytes")
lcTableDescriptionTableStatus = loJsonResponse.StringOf("TableDescription.TableStatus")

RELEASE loRest
RELEASE loAuthAws
RELEASE loJson
RELEASE loSbRequestBody
RELEASE loSbResponseBody
RELEASE loJsonResponse