(Swift 3,4,5...) 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 Downloads for the Swift Programming Language MAC OS X (Cocoa) Objective-C/Swift Libs iOS Objective-C/Swift Libs

func chilkatTest() {
    // 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..
    let sbToken = CkoStringBuilder()!
    sbToken.loadFile("qa_data/tokens/google_cloud_sql_access_token.txt", charset: "utf-8")

    let http = CkoHttp()!
    var success: Bool

    // 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.
    http.authToken = sbToken.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".)
    let sbResponseBody = CkoStringBuilder()!
    success = http.quickGetSb("https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id", sbContent: sbResponseBody)
    if success == false {
        print("\(http.lastErrorText!)")
        return
    }

    let jResp = CkoJsonObject()!
    jResp.loadSb(sbResponseBody)
    jResp.emitCompact = false

    print("Response Body:")
    print("\(jResp.emit()!)")

    var respStatusCode: Int = http.lastStatus.intValue
    print("Response Status Code = \(respStatusCode)")
    if respStatusCode == 401 {
        print("It may be that your access token expired.")
        print("Try refreshing the access token by re-fetching it.")
    }

    if respStatusCode >= 400 {
        print("Response Header:")
        print("\(http.lastHeader!)")
        print("Failed.")
        return
    }

    // 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

    var v_type: String?
    var ipAddress: String?

    var kind: String? = jResp.string(of: "kind")
    var state: String? = jResp.string(of: "state")
    var databaseVersion: String? = jResp.string(of: "databaseVersion")
    var settingsTier: String? = jResp.string(of: "settings.tier")
    var settingsKind: String? = jResp.string(of: "settings.kind")
    var settingsPricingPlan: String? = jResp.string(of: "settings.pricingPlan")
    var settingsReplicationType: String? = jResp.string(of: "settings.replicationType")
    var settingsActivationPolicy: String? = jResp.string(of: "settings.activationPolicy")
    var settingsIpConfigurationIpv4Enabled: Bool = jResp.bool(of: "settings.ipConfiguration.ipv4Enabled")
    var settingsLocationPreferenceZone: String? = jResp.string(of: "settings.locationPreference.zone")
    var settingsLocationPreferenceKind: String? = jResp.string(of: "settings.locationPreference.kind")
    var settingsDataDiskType: String? = jResp.string(of: "settings.dataDiskType")
    var settingsBackupConfigurationStartTime: String? = jResp.string(of: "settings.backupConfiguration.startTime")
    var settingsBackupConfigurationKind: String? = jResp.string(of: "settings.backupConfiguration.kind")
    var settingsBackupConfigurationEnabled: Bool = jResp.bool(of: "settings.backupConfiguration.enabled")
    var settingsBackupConfigurationPointInTimeEnabled: Bool = jResp.bool(of: "settings.backupConfiguration.pointInTimeEnabled")
    var settingsSettingsVersion: String? = jResp.string(of: "settings.settingsVersion")
    var settingsStorageAutoResizeLimit: String? = jResp.string(of: "settings.storageAutoResizeLimit")
    var settingsStorageAutoResize: Bool = jResp.bool(of: "settings.storageAutoResize")
    var settingsDataDiskSizeGb: String? = jResp.string(of: "settings.dataDiskSizeGb")
    var etag: String? = jResp.string(of: "etag")
    var serverCaCertKind: String? = jResp.string(of: "serverCaCert.kind")
    var serverCaCertCertSerialNumber: String? = jResp.string(of: "serverCaCert.certSerialNumber")
    var serverCaCertCert: String? = jResp.string(of: "serverCaCert.cert")
    var serverCaCertCommonName: String? = jResp.string(of: "serverCaCert.commonName")
    var serverCaCertSha1Fingerprint: String? = jResp.string(of: "serverCaCert.sha1Fingerprint")
    var serverCaCertInstance: String? = jResp.string(of: "serverCaCert.instance")
    var serverCaCertCreateTime: String? = jResp.string(of: "serverCaCert.createTime")
    var serverCaCertExpirationTime: String? = jResp.string(of: "serverCaCert.expirationTime")
    var instanceType: String? = jResp.string(of: "instanceType")
    var project: String? = jResp.string(of: "project")
    var serviceAccountEmailAddress: String? = jResp.string(of: "serviceAccountEmailAddress")
    var backendType: String? = jResp.string(of: "backendType")
    var selfLink: String? = jResp.string(of: "selfLink")
    var connectionName: String? = jResp.string(of: "connectionName")
    var name: String? = jResp.string(of: "name")
    var region: String? = jResp.string(of: "region")
    var gceZone: String? = jResp.string(of: "gceZone")
    var i: Int = 0
    var count_i: Int = jResp.size(ofArray: "settings.authorizedGaeApplications").intValue
    while i < count_i {
        jResp.i = i
        i = i + 1
    }

    i = 0
    count_i = jResp.size(ofArray: "settings.ipConfiguration.authorizedNetworks").intValue
    while i < count_i {
        jResp.i = i
        i = i + 1
    }

    i = 0
    count_i = jResp.size(ofArray: "ipAddresses").intValue
    while i < count_i {
        jResp.i = i
        v_type = jResp.string(of: "ipAddresses[i].type")
        ipAddress = jResp.string(of: "ipAddresses[i].ipAddress")
        i = i + 1
    }


}