(AutoIt) Google Cloud SQL - Get Instance Information

Demonstrates how to get information about your Cloud SQL instances, including instance summary information, usage data, operation logs, and database logs.

For more information, see https://cloud.google.com/sql/docs/mysql/instance-info

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

; 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")
Local $bSuccess

; Implements the following CURL command:

; curl -X GET \
; -H "Authorization: Bearer access-token" \
; https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id

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

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

; 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".)
$oSbResponseBody = ObjCreate("Chilkat.StringBuilder")
$bSuccess = $oHttp.QuickGetSb("https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id",$oSbResponseBody)
If ($bSuccess = False) Then
    ConsoleWrite($oHttp.LastErrorText & @CRLF)
    Exit
EndIf

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

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

Local $iRespStatusCode = $oHttp.LastStatus
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($oHttp.LastHeader & @CRLF)
    ConsoleWrite("Failed." & @CRLF)
    Exit
EndIf

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

; {
;   "kind": "sql#instance",
;   "state": "RUNNABLE",
;   "databaseVersion": "MYSQL_5_7",
;   "settings": {
;     "authorizedGaeApplications": [
;     ],
;     "tier": "db-f1-micro",
;     "kind": "sql#settings",
;     "pricingPlan": "PER_USE",
;     "replicationType": "SYNCHRONOUS",
;     "activationPolicy": "ALWAYS",
;     "ipConfiguration": {
;       "authorizedNetworks": [
;       ],
;       "ipv4Enabled": true
;     },
;     "locationPreference": {
;       "zone": "asia-east1-a",
;       "kind": "sql#locationPreference"
;     },
;     "dataDiskType": "PD_SSD",
;     "backupConfiguration": {
;       "startTime": "08:00",
;       "kind": "sql#backupConfiguration",
;       "enabled": true,
;       "pointInTimeEnabled": true
;     },
;     "settingsVersion": "13",
;     "storageAutoResizeLimit": "0",
;     "storageAutoResize": true,
;     "dataDiskSizeGb": "10"
;   },
;   "etag": "etag-id",
;   "ipAddresses": [
;     {
;       "type": "PRIMARY",
;       "ipAddress": "10.0.0.1"
;     }
;   ],
;   "serverCaCert": {
;     "kind": "sql#sslCert",
;     "certSerialNumber": "0",
;     "cert": "certificate-id",
;     "commonName": "C=US,O=Google\\, Inc,CN=Google Cloud SQL Server CA,dnQualifier=dn-qualifier-id",
;     "sha1Fingerprint": "sha-id",
;     "instance": "instance-id",
;     "createTime": "2019-06-28T22:46:35.052Z",
;     "expirationTime": "2029-06-25T22:47:35.052Z"
;   },
;   "instanceType": "CLOUD_SQL_INSTANCE",
;   "project": "project-id",
;   "serviceAccountEmailAddress": "service-acct-id@gcp-sa-cloud-sql.iam.gserviceaccount.com",
;   "backendType": "SECOND_GEN",
;   "selfLink": "https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id",
;   "connectionName": "project-id:region:instance-id",
;   "name": "instance-id",
;   "region": "asia-east1",
;   "gceZone": "asia-east1-a"
; }

; 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 $sV_type
Local $sIpAddress

Local $sKind = $oJResp.StringOf("kind")
Local $state = $oJResp.StringOf("state")
Local $sDatabaseVersion = $oJResp.StringOf("databaseVersion")
Local $settingsTier = $oJResp.StringOf("settings.tier")
Local $settingsKind = $oJResp.StringOf("settings.kind")
Local $settingsPricingPlan = $oJResp.StringOf("settings.pricingPlan")
Local $settingsReplicationType = $oJResp.StringOf("settings.replicationType")
Local $settingsActivationPolicy = $oJResp.StringOf("settings.activationPolicy")
Local $bSettingsIpConfigurationIpv4Enabled = $oJResp.BoolOf("settings.ipConfiguration.ipv4Enabled")
Local $settingsLocationPreferenceZone = $oJResp.StringOf("settings.locationPreference.zone")
Local $settingsLocationPreferenceKind = $oJResp.StringOf("settings.locationPreference.kind")
Local $settingsDataDiskType = $oJResp.StringOf("settings.dataDiskType")
Local $settingsBackupConfigurationStartTime = $oJResp.StringOf("settings.backupConfiguration.startTime")
Local $settingsBackupConfigurationKind = $oJResp.StringOf("settings.backupConfiguration.kind")
Local $bSettingsBackupConfigurationEnabled = $oJResp.BoolOf("settings.backupConfiguration.enabled")
Local $bSettingsBackupConfigurationPointInTimeEnabled = $oJResp.BoolOf("settings.backupConfiguration.pointInTimeEnabled")
Local $settingsSettingsVersion = $oJResp.StringOf("settings.settingsVersion")
Local $settingsStorageAutoResizeLimit = $oJResp.StringOf("settings.storageAutoResizeLimit")
Local $bSettingsStorageAutoResize = $oJResp.BoolOf("settings.storageAutoResize")
Local $settingsDataDiskSizeGb = $oJResp.StringOf("settings.dataDiskSizeGb")
Local $sEtag = $oJResp.StringOf("etag")
Local $serverCaCertKind = $oJResp.StringOf("serverCaCert.kind")
Local $serverCaCertCertSerialNumber = $oJResp.StringOf("serverCaCert.certSerialNumber")
Local $serverCaCertCert = $oJResp.StringOf("serverCaCert.cert")
Local $serverCaCertCommonName = $oJResp.StringOf("serverCaCert.commonName")
Local $serverCaCertSha1Fingerprint = $oJResp.StringOf("serverCaCert.sha1Fingerprint")
Local $serverCaCertInstance = $oJResp.StringOf("serverCaCert.instance")
Local $serverCaCertCreateTime = $oJResp.StringOf("serverCaCert.createTime")
Local $serverCaCertExpirationTime = $oJResp.StringOf("serverCaCert.expirationTime")
Local $sInstanceType = $oJResp.StringOf("instanceType")
Local $sProject = $oJResp.StringOf("project")
Local $serviceAccountEmailAddress = $oJResp.StringOf("serviceAccountEmailAddress")
Local $sBackendType = $oJResp.StringOf("backendType")
Local $selfLink = $oJResp.StringOf("selfLink")
Local $sConnectionName = $oJResp.StringOf("connectionName")
Local $sName = $oJResp.StringOf("name")
Local $sRegion = $oJResp.StringOf("region")
Local $sGceZone = $oJResp.StringOf("gceZone")
Local $i = 0
Local $iCount_i = $oJResp.SizeOfArray("settings.authorizedGaeApplications")
While $i < $iCount_i
    $oJResp.I = $i
    $i = $i + 1
Wend
$i = 0
$iCount_i = $oJResp.SizeOfArray("settings.ipConfiguration.authorizedNetworks")
While $i < $iCount_i
    $oJResp.I = $i
    $i = $i + 1
Wend
$i = 0
$iCount_i = $oJResp.SizeOfArray("ipAddresses")
While $i < $iCount_i
    $oJResp.I = $i
    $sV_type = $oJResp.StringOf("ipAddresses[i].type")
    $sIpAddress = $oJResp.StringOf("ipAddresses[i].ipAddress")
    $i = $i + 1
Wend