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 - Start Database InstanceDemonstrates how to start a Google Cloud SQL database instance. For more information, see https://cloud.google.com/sql/docs/mysql/start-stop-restart-instance
#include <C_CkStringBuilderW.h> #include <C_CkHttpW.h> #include <C_CkJsonObjectW.h> #include <C_CkHttpResponseW.h> void ChilkatSample(void) { HCkStringBuilderW sbToken; HCkHttpW http; BOOL success; HCkJsonObjectW json; HCkStringBuilderW sbRequestBody; HCkHttpResponseW resp; HCkStringBuilderW sbResponseBody; HCkJsonObjectW jResp; int respStatusCode; const wchar_t *kind; const wchar_t *targetLink; const wchar_t *status; const wchar_t *user; const wchar_t *insertTime; const wchar_t *operationType; const wchar_t *name; const wchar_t *targetId; const wchar_t *selfLink; const wchar_t *targetProject; // 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 PATCH \ // -H "Authorization: Bearer "$(gcloud auth print-access-token) \ // -H "Content-Type: application/json; charset=utf-8" \ // -d '{ // "settings": { // "activationPolicy": "ALWAYS" // } // }' \ // https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id // Use this online tool to generate code from sample JSON: // Generate Code to Create JSON // The following JSON is sent in the request body. // { // "settings": { // "activationPolicy": "ALWAYS" // } // } // Use "ALWAYS" to start an instance. Use "NEVER" to stop an instance. json = CkJsonObjectW_Create(); CkJsonObjectW_UpdateString(json,L"settings.activationPolicy",L"ALWAYS"); // Causes the "Authorization: Bearer "$(gcloud auth print-access-token)" header to be added. CkHttpW_putAuthToken(http,CkStringBuilderW_getAsString(sbToken)); CkHttpW_SetRequestHeader(http,L"Content-Type",L"application/json; charset=utf-8"); sbRequestBody = CkStringBuilderW_Create(); CkJsonObjectW_EmitSb(json,sbRequestBody); // 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".) resp = CkHttpW_PTextSb(http,L"PATCH",L"https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id",sbRequestBody,L"utf-8",L"application/json",FALSE,FALSE); if (CkHttpW_getLastMethodSuccess(http) == FALSE) { wprintf(L"%s\n",CkHttpW_lastErrorText(http)); CkStringBuilderW_Dispose(sbToken); CkHttpW_Dispose(http); CkJsonObjectW_Dispose(json); CkStringBuilderW_Dispose(sbRequestBody); return; } sbResponseBody = CkStringBuilderW_Create(); CkHttpResponseW_GetBodySb(resp,sbResponseBody); jResp = CkJsonObjectW_Create(); CkJsonObjectW_LoadSb(jResp,sbResponseBody); CkJsonObjectW_putEmitCompact(jResp,FALSE); wprintf(L"Response Body:\n"); wprintf(L"%s\n",CkJsonObjectW_emit(jResp)); respStatusCode = CkHttpResponseW_getStatusCode(resp); 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",CkHttpResponseW_header(resp)); wprintf(L"Failed.\n"); CkHttpResponseW_Dispose(resp); CkStringBuilderW_Dispose(sbToken); CkHttpW_Dispose(http); CkJsonObjectW_Dispose(json); CkStringBuilderW_Dispose(sbRequestBody); CkStringBuilderW_Dispose(sbResponseBody); CkJsonObjectW_Dispose(jResp); return; } CkHttpResponseW_Dispose(resp); // Sample JSON response: // (Sample code for parsing the JSON response is shown below) // { // "kind": "sql#operation", // "targetLink": "https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id", // "status": "PENDING", // "user": "user@example.com", // "insertTime": "2020-01-20T21:30:35.667Z", // "operationType": "UPDATE", // "name": "operation-id", // "targetId": "instance-id", // "selfLink": "https://www.googleapis.com/sql/v1beta4/projects/project-id/operations/operation-id", // "targetProject": "project-id" // } // 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"); targetLink = CkJsonObjectW_stringOf(jResp,L"targetLink"); status = CkJsonObjectW_stringOf(jResp,L"status"); user = CkJsonObjectW_stringOf(jResp,L"user"); insertTime = CkJsonObjectW_stringOf(jResp,L"insertTime"); operationType = CkJsonObjectW_stringOf(jResp,L"operationType"); name = CkJsonObjectW_stringOf(jResp,L"name"); targetId = CkJsonObjectW_stringOf(jResp,L"targetId"); selfLink = CkJsonObjectW_stringOf(jResp,L"selfLink"); targetProject = CkJsonObjectW_stringOf(jResp,L"targetProject"); CkStringBuilderW_Dispose(sbToken); CkHttpW_Dispose(http); CkJsonObjectW_Dispose(json); CkStringBuilderW_Dispose(sbRequestBody); CkStringBuilderW_Dispose(sbResponseBody); CkJsonObjectW_Dispose(jResp); } |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.