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
(PHP ActiveX) 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
<?php // 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.. // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.StringBuilder') $sbToken = new COM("Chilkat.StringBuilder"); $sbToken->LoadFile('qa_data/tokens/google_cloud_sql_access_token.txt','utf-8'); // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.Http') $http = new COM("Chilkat.Http"); // 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. // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject') $json = new COM("Chilkat.JsonObject"); $json->UpdateString('settings.activationPolicy','ALWAYS'); // Causes the "Authorization: Bearer "$(gcloud auth print-access-token)" header to be added. $http->AuthToken = $sbToken->getAsString(); $http->SetRequestHeader('Content-Type','application/json; charset=utf-8'); // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.StringBuilder') $sbRequestBody = new COM("Chilkat.StringBuilder"); $json->EmitSb($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 is a Chilkat.HttpResponse $resp = $http->PTextSb('PATCH','https://www.googleapis.com/sql/v1beta4/projects/project-id/instances/instance-id',$sbRequestBody,'utf-8','application/json',0,0); if ($http->LastMethodSuccess == 0) { print $http->LastErrorText . "\n"; exit; } // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.StringBuilder') $sbResponseBody = new COM("Chilkat.StringBuilder"); $resp->GetBodySb($sbResponseBody); // For versions of Chilkat < 10.0.0, use new COM('Chilkat_9_5_0.Chilkat.JsonObject') $jResp = new COM("Chilkat.JsonObject"); $jResp->LoadSb($sbResponseBody); $jResp->EmitCompact = 0; print 'Response Body:' . "\n"; print $jResp->emit() . "\n"; $respStatusCode = $resp->StatusCode; print 'Response Status Code = ' . $respStatusCode . "\n"; if ($respStatusCode == 401) { print 'It may be that your access token expired.' . "\n"; print 'Try refreshing the access token by re-fetching it.' . "\n"; } if ($respStatusCode >= 400) { print 'Response Header:' . "\n"; print $resp->Header . "\n"; print 'Failed.' . "\n"; exit; } // 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 $kind = $jResp->stringOf('kind'); $targetLink = $jResp->stringOf('targetLink'); $status = $jResp->stringOf('status'); $user = $jResp->stringOf('user'); $insertTime = $jResp->stringOf('insertTime'); $operationType = $jResp->stringOf('operationType'); $name = $jResp->stringOf('name'); $targetId = $jResp->stringOf('targetId'); $selfLink = $jResp->stringOf('selfLink'); $targetProject = $jResp->stringOf('targetProject'); ?> |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.