(Unicode C) 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 C/C++ Library Downloads
MS Visual C/C++ Linux/CentOS C/C++ Alpine Linux C/C++ MAC OS X C/C++	armhf/aarch64 C/C++ C++ Builder iOS C/C++ Android C/C++	Solaris C/C++ MinGW C/C++

#include <C_CkStringBuilderW.h>
#include <C_CkHttpW.h>
#include <C_CkJsonObjectW.h>

void ChilkatSample(void)
    {
    HCkStringBuilderW sbToken;
    HCkHttpW http;
    BOOL success;
    HCkStringBuilderW sbResponseBody;
    HCkJsonObjectW jResp;
    int respStatusCode;
    const wchar_t *v_type;
    const wchar_t *ipAddress;
    const wchar_t *kind;
    const wchar_t *state;
    const wchar_t *databaseVersion;
    const wchar_t *settingsTier;
    const wchar_t *settingsKind;
    const wchar_t *settingsPricingPlan;
    const wchar_t *settingsReplicationType;
    const wchar_t *settingsActivationPolicy;
    BOOL settingsIpConfigurationIpv4Enabled;
    const wchar_t *settingsLocationPreferenceZone;
    const wchar_t *settingsLocationPreferenceKind;
    const wchar_t *settingsDataDiskType;
    const wchar_t *settingsBackupConfigurationStartTime;
    const wchar_t *settingsBackupConfigurationKind;
    BOOL settingsBackupConfigurationEnabled;
    BOOL settingsBackupConfigurationPointInTimeEnabled;
    const wchar_t *settingsSettingsVersion;
    const wchar_t *settingsStorageAutoResizeLimit;
    BOOL settingsStorageAutoResize;
    const wchar_t *settingsDataDiskSizeGb;
    const wchar_t *etag;
    const wchar_t *serverCaCertKind;
    const wchar_t *serverCaCertCertSerialNumber;
    const wchar_t *serverCaCertCert;
    const wchar_t *serverCaCertCommonName;
    const wchar_t *serverCaCertSha1Fingerprint;
    const wchar_t *serverCaCertInstance;
    const wchar_t *serverCaCertCreateTime;
    const wchar_t *serverCaCertExpirationTime;
    const wchar_t *instanceType;
    const wchar_t *project;
    const wchar_t *serviceAccountEmailAddress;
    const wchar_t *backendType;
    const wchar_t *selfLink;
    const wchar_t *connectionName;
    const wchar_t *name;
    const wchar_t *region;
    const wchar_t *gceZone;
    int i;
    int count_i;

    // 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..
    sbToken = CkStringBuilderW_Create();
    CkStringBuilderW_LoadFile(sbToken,L"qa_data/tokens/google_cloud_sql_access_token.txt",L"utf-8");

    http = CkHttpW_Create();

    // 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.
    CkHttpW_putAuthToken(http,CkStringBuilderW_getAsString(sbToken));

    // 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".)
    sbResponseBody = CkStringBuilderW_Create();
    success = CkHttpW_QuickGetSb(http,L"https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id",sbResponseBody);
    if (success == FALSE) {
        wprintf(L"%s\n",CkHttpW_lastErrorText(http));
        CkStringBuilderW_Dispose(sbToken);
        CkHttpW_Dispose(http);
        CkStringBuilderW_Dispose(sbResponseBody);
        return;
    }

    jResp = CkJsonObjectW_Create();
    CkJsonObjectW_LoadSb(jResp,sbResponseBody);
    CkJsonObjectW_putEmitCompact(jResp,FALSE);

    wprintf(L"Response Body:\n");
    wprintf(L"%s\n",CkJsonObjectW_emit(jResp));

    respStatusCode = CkHttpW_getLastStatus(http);
    wprintf(L"Response Status Code = %d\n",respStatusCode);
    if (respStatusCode == 401) {
        wprintf(L"It may be that your access token expired.\n");
        wprintf(L"Try refreshing the access token by re-fetching it.\n");
    }

    if (respStatusCode >= 400) {
        wprintf(L"Response Header:\n");
        wprintf(L"%s\n",CkHttpW_lastHeader(http));
        wprintf(L"Failed.\n");
        CkStringBuilderW_Dispose(sbToken);
        CkHttpW_Dispose(http);
        CkStringBuilderW_Dispose(sbResponseBody);
        CkJsonObjectW_Dispose(jResp);
        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

    // Chilkat functions returning "const char *" return a pointer to temporary internal memory owned and managed by Chilkat.
    // See this example explaining how this memory should be used: const char * functions.

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

    i = 0;
    count_i = CkJsonObjectW_SizeOfArray(jResp,L"settings.ipConfiguration.authorizedNetworks");
    while (i < count_i) {
        CkJsonObjectW_putI(jResp,i);
        i = i + 1;
    }

    i = 0;
    count_i = CkJsonObjectW_SizeOfArray(jResp,L"ipAddresses");
    while (i < count_i) {
        CkJsonObjectW_putI(jResp,i);
        v_type = CkJsonObjectW_stringOf(jResp,L"ipAddresses[i].type");
        ipAddress = CkJsonObjectW_stringOf(jResp,L"ipAddresses[i].ipAddress");
        i = i + 1;
    }



    CkStringBuilderW_Dispose(sbToken);
    CkHttpW_Dispose(http);
    CkStringBuilderW_Dispose(sbResponseBody);
    CkJsonObjectW_Dispose(jResp);

    }