(Java) 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 Java Downloads Java Libs for Windows, MacOS, Linux, Alpine Linux, Solaris Java Libs for Android

import com.chilkatsoft.*;

public class ChilkatExample {

  static {
    try {
        System.loadLibrary("chilkat");
    } catch (UnsatisfiedLinkError e) {
      System.err.println("Native code library failed to load.\n" + e);
      System.exit(1);
    }
  }

  public static void main(String argv[])
  {
    // 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..
    CkStringBuilder sbToken = new CkStringBuilder();
    sbToken.LoadFile("qa_data/tokens/google_cloud_sql_access_token.txt","utf-8");

    CkHttp http = new CkHttp();
    boolean success;

    // 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.put_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".)
    CkStringBuilder sbResponseBody = new CkStringBuilder();
    success = http.QuickGetSb("https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id",sbResponseBody);
    if (success == false) {
        System.out.println(http.lastErrorText());
        return;
        }

    CkJsonObject jResp = new CkJsonObject();
    jResp.LoadSb(sbResponseBody);
    jResp.put_EmitCompact(false);

    System.out.println("Response Body:");
    System.out.println(jResp.emit());

    int respStatusCode = http.get_LastStatus();
    System.out.println("Response Status Code = " + respStatusCode);
    if (respStatusCode == 401) {
        System.out.println("It may be that your access token expired.");
        System.out.println("Try refreshing the access token by re-fetching it.");
        }

    if (respStatusCode >= 400) {
        System.out.println("Response Header:");
        System.out.println(http.lastHeader());
        System.out.println("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

    String v_type;
    String ipAddress;

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

    i = 0;
    count_i = jResp.SizeOfArray("settings.ipConfiguration.authorizedNetworks");
    while (i < count_i) {
        jResp.put_I(i);
        i = i+1;
        }

    i = 0;
    count_i = jResp.SizeOfArray("ipAddresses");
    while (i < count_i) {
        jResp.put_I(i);
        v_type = jResp.stringOf("ipAddresses[i].type");
        ipAddress = jResp.stringOf("ipAddresses[i].ipAddress");
        i = i+1;
        }
  }
}