Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(Unicode C) Google Cloud SQL - Get Instance InformationDemonstrates 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
#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); } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.