Google Cloud Sql Admin V1 Client - Class SqlUsersServiceClient (0.12.0)

Reference documentation and code samples for the Google Cloud Sql Admin V1 Client class SqlUsersServiceClient.

Service Description: Cloud SQL users service.

This class provides the ability to make remote calls to the backing service through method calls that map to API methods.

Namespace

Google \ Cloud \ Sql \ V1 \ Client

Methods

__construct

Constructor.

Parameters
NameDescription
options array

Optional. Options for configuring the service API wrapper.

↳ apiEndpoint string

The address of the API remote host. May optionally include the port, formatted as "

↳ credentials string|array|FetchAuthTokenInterface|CredentialsWrapper

The credentials to be used by the client to authorize API calls. This option accepts either a path to a credentials file, or a decoded credentials file as a PHP array. Advanced usage: In addition, this option can also accept a pre-constructed Google\Auth\FetchAuthTokenInterface object or Google\ApiCore\CredentialsWrapper object. Note that when one of these objects are provided, any settings in $credentialsConfig will be ignored.

↳ credentialsConfig array

Options used to configure credentials, including auth token caching, for the client. For a full list of supporting configuration options, see Google\ApiCore\CredentialsWrapper::build() .

↳ disableRetries bool

Determines whether or not retries defined by the client configuration should be disabled. Defaults to false.

↳ clientConfig string|array

Client method configuration, including retry settings. This option can be either a path to a JSON file, or a PHP array containing the decoded JSON data. By default this settings points to the default client config file, which is provided in the resources folder.

↳ transport string|TransportInterface

The transport used for executing network requests. May be either the string rest or grpc. Defaults to grpc if gRPC support is detected on the system. Advanced usage: Additionally, it is possible to pass in an already instantiated Google\ApiCore\Transport\TransportInterface object. Note that when this object is provided, any settings in $transportConfig, and any $apiEndpoint setting, will be ignored.

↳ transportConfig array

Configuration options that will be used to construct the transport. Options for each supported transport type should be passed in a key for that transport. For example: $transportConfig = [ 'grpc' => [...], 'rest' => [...], ]; See the Google\ApiCore\Transport\GrpcTransport::build() and Google\ApiCore\Transport\RestTransport::build() methods for the supported options.

↳ clientCertSource callable

A callable which returns the client cert as a string. This can be used to provide a certificate and private key to the transport layer for mTLS.

delete

Deletes a user from a Cloud SQL instance.

The async variant is Google\Cloud\Sql\V1\Client\SqlUsersServiceClient::deleteAsync() .

Parameters
NameDescription
request Google\Cloud\Sql\V1\SqlUsersDeleteRequest

A request to house fields associated with the call.

callOptions array

Optional.

↳ retrySettings RetrySettings|array

Retry settings to use for this call. Can be a Google\ApiCore\RetrySettings object, or an associative array of retry settings parameters. See the documentation on Google\ApiCore\RetrySettings for example usage.

Returns
TypeDescription
Google\Cloud\Sql\V1\Operation
Example
use Google\ApiCore\ApiException;
use Google\Cloud\Sql\V1\Client\SqlUsersServiceClient;
use Google\Cloud\Sql\V1\Operation;
use Google\Cloud\Sql\V1\SqlUsersDeleteRequest;

/**
 * This sample has been automatically generated and should be regarded as a code
 * template only. It will require modifications to work:
 *  - It may require correct/in-range values for request initialization.
 *  - It may require specifying regional endpoints when creating the service client,
 *    please see the apiEndpoint client configuration option for more details.
 */
function delete_sample(): void
{
    // Create a client.
    $sqlUsersServiceClient = new SqlUsersServiceClient();

    // Prepare the request message.
    $request = new SqlUsersDeleteRequest();

    // Call the API and handle any network failures.
    try {
        /** @var Operation $response */
        $response = $sqlUsersServiceClient->delete($request);
        printf('Response data: %s' . PHP_EOL, $response->serializeToJsonString());
    } catch (ApiException $ex) {
        printf('Call failed with message: %s' . PHP_EOL, $ex->getMessage());
    }
}

get

Retrieves a resource containing information about a user.

The async variant is Google\Cloud\Sql\V1\Client\SqlUsersServiceClient::getAsync() .

Parameters
NameDescription
request Google\Cloud\Sql\V1\SqlUsersGetRequest

A request to house fields associated with the call.

callOptions array

Optional.

↳ retrySettings RetrySettings|array

Retry settings to use for this call. Can be a Google\ApiCore\RetrySettings object, or an associative array of retry settings parameters. See the documentation on Google\ApiCore\RetrySettings for example usage.

Returns
TypeDescription
Google\Cloud\Sql\V1\User
Example
use Google\ApiCore\ApiException;
use Google\Cloud\Sql\V1\Client\SqlUsersServiceClient;
use Google\Cloud\Sql\V1\SqlUsersGetRequest;
use Google\Cloud\Sql\V1\User;

/**
 * This sample has been automatically generated and should be regarded as a code
 * template only. It will require modifications to work:
 *  - It may require correct/in-range values for request initialization.
 *  - It may require specifying regional endpoints when creating the service client,
 *    please see the apiEndpoint client configuration option for more details.
 */
function get_sample(): void
{
    // Create a client.
    $sqlUsersServiceClient = new SqlUsersServiceClient();

    // Prepare the request message.
    $request = new SqlUsersGetRequest();

    // Call the API and handle any network failures.
    try {
        /** @var User $response */
        $response = $sqlUsersServiceClient->get($request);
        printf('Response data: %s' . PHP_EOL, $response->serializeToJsonString());
    } catch (ApiException $ex) {
        printf('Call failed with message: %s' . PHP_EOL, $ex->getMessage());
    }
}

insert

Creates a new user in a Cloud SQL instance.

The async variant is Google\Cloud\Sql\V1\Client\SqlUsersServiceClient::insertAsync() .

Parameters
NameDescription
request Google\Cloud\Sql\V1\SqlUsersInsertRequest

A request to house fields associated with the call.

callOptions array

Optional.

↳ retrySettings RetrySettings|array

Retry settings to use for this call. Can be a Google\ApiCore\RetrySettings object, or an associative array of retry settings parameters. See the documentation on Google\ApiCore\RetrySettings for example usage.

Returns
TypeDescription
Google\Cloud\Sql\V1\Operation
Example
use Google\ApiCore\ApiException;
use Google\Cloud\Sql\V1\Client\SqlUsersServiceClient;
use Google\Cloud\Sql\V1\Operation;
use Google\Cloud\Sql\V1\SqlUsersInsertRequest;

/**
 * This sample has been automatically generated and should be regarded as a code
 * template only. It will require modifications to work:
 *  - It may require correct/in-range values for request initialization.
 *  - It may require specifying regional endpoints when creating the service client,
 *    please see the apiEndpoint client configuration option for more details.
 */
function insert_sample(): void
{
    // Create a client.
    $sqlUsersServiceClient = new SqlUsersServiceClient();

    // Prepare the request message.
    $request = new SqlUsersInsertRequest();

    // Call the API and handle any network failures.
    try {
        /** @var Operation $response */
        $response = $sqlUsersServiceClient->insert($request);
        printf('Response data: %s' . PHP_EOL, $response->serializeToJsonString());
    } catch (ApiException $ex) {
        printf('Call failed with message: %s' . PHP_EOL, $ex->getMessage());
    }
}

list

Lists users in the specified Cloud SQL instance.

The async variant is Google\Cloud\Sql\V1\Client\SqlUsersServiceClient::listAsync() .

Parameters
NameDescription
request Google\Cloud\Sql\V1\SqlUsersListRequest

A request to house fields associated with the call.

callOptions array

Optional.

↳ retrySettings RetrySettings|array

Retry settings to use for this call. Can be a Google\ApiCore\RetrySettings object, or an associative array of retry settings parameters. See the documentation on Google\ApiCore\RetrySettings for example usage.

Returns
TypeDescription
Google\Cloud\Sql\V1\UsersListResponse
Example
use Google\ApiCore\ApiException;
use Google\Cloud\Sql\V1\Client\SqlUsersServiceClient;
use Google\Cloud\Sql\V1\SqlUsersListRequest;
use Google\Cloud\Sql\V1\UsersListResponse;

/**
 * This sample has been automatically generated and should be regarded as a code
 * template only. It will require modifications to work:
 *  - It may require correct/in-range values for request initialization.
 *  - It may require specifying regional endpoints when creating the service client,
 *    please see the apiEndpoint client configuration option for more details.
 */
function list_sample(): void
{
    // Create a client.
    $sqlUsersServiceClient = new SqlUsersServiceClient();

    // Prepare the request message.
    $request = new SqlUsersListRequest();

    // Call the API and handle any network failures.
    try {
        /** @var UsersListResponse $response */
        $response = $sqlUsersServiceClient->list($request);
        printf('Response data: %s' . PHP_EOL, $response->serializeToJsonString());
    } catch (ApiException $ex) {
        printf('Call failed with message: %s' . PHP_EOL, $ex->getMessage());
    }
}

update

Updates an existing user in a Cloud SQL instance.

The async variant is Google\Cloud\Sql\V1\Client\SqlUsersServiceClient::updateAsync() .

Parameters
NameDescription
request Google\Cloud\Sql\V1\SqlUsersUpdateRequest

A request to house fields associated with the call.

callOptions array

Optional.

↳ retrySettings RetrySettings|array

Retry settings to use for this call. Can be a Google\ApiCore\RetrySettings object, or an associative array of retry settings parameters. See the documentation on Google\ApiCore\RetrySettings for example usage.

Returns
TypeDescription
Google\Cloud\Sql\V1\Operation
Example
use Google\ApiCore\ApiException;
use Google\Cloud\Sql\V1\Client\SqlUsersServiceClient;
use Google\Cloud\Sql\V1\Operation;
use Google\Cloud\Sql\V1\SqlUsersUpdateRequest;

/**
 * This sample has been automatically generated and should be regarded as a code
 * template only. It will require modifications to work:
 *  - It may require correct/in-range values for request initialization.
 *  - It may require specifying regional endpoints when creating the service client,
 *    please see the apiEndpoint client configuration option for more details.
 */
function update_sample(): void
{
    // Create a client.
    $sqlUsersServiceClient = new SqlUsersServiceClient();

    // Prepare the request message.
    $request = new SqlUsersUpdateRequest();

    // Call the API and handle any network failures.
    try {
        /** @var Operation $response */
        $response = $sqlUsersServiceClient->update($request);
        printf('Response data: %s' . PHP_EOL, $response->serializeToJsonString());
    } catch (ApiException $ex) {
        printf('Call failed with message: %s' . PHP_EOL, $ex->getMessage());
    }
}

deleteAsync

Parameters
NameDescription
request Google\Cloud\Sql\V1\SqlUsersDeleteRequest
optionalArgs = [] array
Returns
TypeDescription
GuzzleHttp\Promise\PromiseInterface

getAsync

Parameters
NameDescription
request Google\Cloud\Sql\V1\SqlUsersGetRequest
optionalArgs = [] array
Returns
TypeDescription
GuzzleHttp\Promise\PromiseInterface

insertAsync

Parameters
NameDescription
request Google\Cloud\Sql\V1\SqlUsersInsertRequest
optionalArgs = [] array
Returns
TypeDescription
GuzzleHttp\Promise\PromiseInterface

listAsync

Parameters
NameDescription
request Google\Cloud\Sql\V1\SqlUsersListRequest
optionalArgs = [] array
Returns
TypeDescription
GuzzleHttp\Promise\PromiseInterface

updateAsync

Parameters
NameDescription
request Google\Cloud\Sql\V1\SqlUsersUpdateRequest
optionalArgs = [] array
Returns
TypeDescription
GuzzleHttp\Promise\PromiseInterface