Cloud SQL Admin API . connect

Instance Methods

close()

Close httplib2 connections.

generateEphemeralCert(project, instance, body=None, x__xgafv=None)

Generates a short-lived X509 certificate containing the provided public key and signed by a private key specific to the target instance. Users may use the certificate to authenticate as themselves when connecting to the database.

get(project, instance, readTime=None, x__xgafv=None)

Retrieves connect settings about a Cloud SQL instance.

Method Details

close()
Close httplib2 connections.
generateEphemeralCert(project, instance, body=None, x__xgafv=None)
Generates a short-lived X509 certificate containing the provided public key and signed by a private key specific to the target instance. Users may use the certificate to authenticate as themselves when connecting to the database.

Args:
  project: string, Project ID of the project that contains the instance. (required)
  instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
  body: object, The request body.
    The object takes the form of:

{ # Ephemeral certificate creation request.
  "access_token": "A String", # Optional. Access token to include in the signed certificate.
  "public_key": "A String", # PEM encoded public key to include in the signed certificate.
  "readTime": "A String", # Optional. Optional snapshot read timestamp to trade freshness for performance.
  "validDuration": "A String", # Optional. If set, it will contain the cert valid duration.
}

  x__xgafv: string, V1 error format.
    Allowed values
      1 - v1 error format
      2 - v2 error format

Returns:
  An object of the form:

    { # Ephemeral certificate creation request.
  "ephemeralCert": { # SslCerts Resource # Generated cert
    "cert": "A String", # PEM representation.
    "certSerialNumber": "A String", # Serial number, as extracted from the certificate.
    "commonName": "A String", # User supplied name. Constrained to [a-zA-Z.-_ ]+.
    "createTime": "A String", # The time when the certificate was created in [RFC 3339](https://tools.ietf.org/html/rfc3339) format, for example `2012-11-15T16:19:00.094Z`
    "expirationTime": "A String", # The time when the certificate expires in [RFC 3339](https://tools.ietf.org/html/rfc3339) format, for example `2012-11-15T16:19:00.094Z`.
    "instance": "A String", # Name of the database instance.
    "kind": "A String", # This is always `sql#sslCert`.
    "selfLink": "A String", # The URI of this resource.
    "sha1Fingerprint": "A String", # Sha1 Fingerprint.
  },
}
get(project, instance, readTime=None, x__xgafv=None)
Retrieves connect settings about a Cloud SQL instance.

Args:
  project: string, Project ID of the project that contains the instance. (required)
  instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
  readTime: string, Optional. Optional snapshot read timestamp to trade freshness for performance.
  x__xgafv: string, V1 error format.
    Allowed values
      1 - v1 error format
      2 - v2 error format

Returns:
  An object of the form:

    { # Connect settings retrieval response.
  "backendType": "A String", # `SECOND_GEN`: Cloud SQL database instance. `EXTERNAL`: A database server that is not managed by Google. This property is read-only; use the `tier` property in the `settings` object to determine the database type.
  "databaseVersion": "A String", # The database engine type and version. The `databaseVersion` field cannot be changed after instance creation. MySQL instances: `MYSQL_8_0`, `MYSQL_5_7` (default), or `MYSQL_5_6`. PostgreSQL instances: `POSTGRES_9_6`, `POSTGRES_10`, `POSTGRES_11`, `POSTGRES_12` (default), `POSTGRES_13`, or `POSTGRES_14`. SQL Server instances: `SQLSERVER_2017_STANDARD` (default), `SQLSERVER_2017_ENTERPRISE`, `SQLSERVER_2017_EXPRESS`, `SQLSERVER_2017_WEB`, `SQLSERVER_2019_STANDARD`, `SQLSERVER_2019_ENTERPRISE`, `SQLSERVER_2019_EXPRESS`, or `SQLSERVER_2019_WEB`.
  "dnsName": "A String", # The dns name of the instance.
  "ipAddresses": [ # The assigned IP addresses for the instance.
    { # Database instance IP mapping
      "ipAddress": "A String", # The IP address assigned.
      "timeToRetire": "A String", # The due time for this IP to be retired in [RFC 3339](https://tools.ietf.org/html/rfc3339) format, for example `2012-11-15T16:19:00.094Z`. This field is only available when the IP is scheduled to be retired.
      "type": "A String", # The type of this IP address. A `PRIMARY` address is a public address that can accept incoming connections. A `PRIVATE` address is a private address that can accept incoming connections. An `OUTGOING` address is the source address of connections originating from the instance, if supported.
    },
  ],
  "kind": "A String", # This is always `sql#connectSettings`.
  "pscEnabled": True or False, # Whether PSC connectivity is enabled for this instance.
  "region": "A String", # The cloud region for the instance. For example, `us-central1`, `europe-west1`. The region cannot be changed after instance creation.
  "serverCaCert": { # SslCerts Resource # SSL configuration.
    "cert": "A String", # PEM representation.
    "certSerialNumber": "A String", # Serial number, as extracted from the certificate.
    "commonName": "A String", # User supplied name. Constrained to [a-zA-Z.-_ ]+.
    "createTime": "A String", # The time when the certificate was created in [RFC 3339](https://tools.ietf.org/html/rfc3339) format, for example `2012-11-15T16:19:00.094Z`
    "expirationTime": "A String", # The time when the certificate expires in [RFC 3339](https://tools.ietf.org/html/rfc3339) format, for example `2012-11-15T16:19:00.094Z`.
    "instance": "A String", # Name of the database instance.
    "kind": "A String", # This is always `sql#sslCert`.
    "selfLink": "A String", # The URI of this resource.
    "sha1Fingerprint": "A String", # Sha1 Fingerprint.
  },
}