AutoIt

Google Cloud SQL - Start Database Instance

See more Google Cloud SQL Examples

Demonstrates how to start a Google Cloud SQL database instance. AutoIt

Local $bSuccess = False

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

;  In this example, Get Google Cloud SQL OAuth2 Access Token, 
;  the service account access token was saved to a text file.  This example fetches the access token from the file..
$oSbToken = ObjCreate("Chilkat.StringBuilder")
$oSbToken.LoadFile("qa_data/tokens/google_cloud_sql_access_token.txt","utf-8")

$oHttp = ObjCreate("Chilkat.Http")

;  Implements the following CURL command:

;  curl -X PATCH \
;  -H "Authorization: Bearer "$(gcloud auth print-access-token) \
;  -H "Content-Type: application/json; charset=utf-8" \
;  -d '{
;    "settings": {
;      "activationPolicy": "ALWAYS" 
;    }
;  }' \
;  https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id

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

;  The following JSON is sent in the request body.

;  {
;    "settings": {
;      "activationPolicy": "ALWAYS"
;    }
;  }

;  Use "ALWAYS" to start an instance.  Use "NEVER" to stop an instance.
$oJson = ObjCreate("Chilkat.JsonObject")
$oJson.UpdateString("settings.activationPolicy","ALWAYS")

;  Causes the "Authorization: Bearer "$(gcloud auth print-access-token)" header to be added.
$oHttp.AuthToken = $oSbToken.GetAsString()

$oHttp.SetRequestHeader "Content-Type","application/json; charset=utf-8"

$oSbRequestBody = ObjCreate("Chilkat.StringBuilder")
$oJson.EmitSb($oSbRequestBody)

;  Replace "project-id" with your actual Google project ID.
;  Replace "instance-id" with your database instance ID, which is the name of your database.  (For example, when I created my test database I named it "chilkat", and therefore my instance-id is "chilkat".)
$oResp = ObjCreate("Chilkat.HttpResponse")
$bSuccess = $oHttp.HttpSb("PATCH","https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id",$oSbRequestBody,"utf-8","application/json",$oResp)
If ($bSuccess = False) Then
    ConsoleWrite($oHttp.LastErrorText & @CRLF)
    Exit
EndIf

$oSbResponseBody = ObjCreate("Chilkat.StringBuilder")
$oResp.GetBodySb($oSbResponseBody)
$oJResp = ObjCreate("Chilkat.JsonObject")
$oJResp.LoadSb($oSbResponseBody)
$oJResp.EmitCompact = False

ConsoleWrite("Response Body:" & @CRLF)
ConsoleWrite($oJResp.Emit() & @CRLF)

Local $iRespStatusCode = $oResp.StatusCode
ConsoleWrite("Response Status Code = " & $iRespStatusCode & @CRLF)
If ($iRespStatusCode = 401) Then
    ConsoleWrite("It may be that your access token expired." & @CRLF)
    ConsoleWrite("Try refreshing the access token by re-fetching it." & @CRLF)
EndIf

If ($iRespStatusCode >= 400) Then
    ConsoleWrite("Response Header:" & @CRLF)
    ConsoleWrite($oResp.Header & @CRLF)
    ConsoleWrite("Failed." & @CRLF)
    Exit
EndIf

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

;  {
;    "kind": "sql#operation",
;    "targetLink": "https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id",
;    "status": "PENDING",
;    "user": "user@example.com",
;    "insertTime": "2020-01-20T21:30:35.667Z",
;    "operationType": "UPDATE",
;    "name": "operation-id",
;    "targetId": "instance-id",
;    "selfLink": "https://www.googleapis.com/sql/v1beta4/projects/project-id/operations/operation-id",
;    "targetProject": "project-id"
;  }

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

Local $sKind = $oJResp.StringOf("kind")
Local $sTargetLink = $oJResp.StringOf("targetLink")
Local $status = $oJResp.StringOf("status")
Local $sUser = $oJResp.StringOf("user")
Local $sInsertTime = $oJResp.StringOf("insertTime")
Local $sOperationType = $oJResp.StringOf("operationType")
Local $sName = $oJResp.StringOf("name")
Local $sTargetId = $oJResp.StringOf("targetId")
Local $selfLink = $oJResp.StringOf("selfLink")
Local $sTargetProject = $oJResp.StringOf("targetProject")