blob: 204232f182dfb84db64f4e9dda1ad329f8c06cc9 [file] [log] [blame]
Craig Citroe633be12015-03-02 13:40:36 -08001<html><body>
2<style>
3
4body, h1, h2, h3, div, span, p, pre, a {
5 margin: 0;
6 padding: 0;
7 border: 0;
8 font-weight: inherit;
9 font-style: inherit;
10 font-size: 100%;
11 font-family: inherit;
12 vertical-align: baseline;
13}
14
15body {
16 font-size: 13px;
17 padding: 1em;
18}
19
20h1 {
21 font-size: 26px;
22 margin-bottom: 1em;
23}
24
25h2 {
26 font-size: 24px;
27 margin-bottom: 1em;
28}
29
30h3 {
31 font-size: 20px;
32 margin-bottom: 1em;
33 margin-top: 1em;
34}
35
36pre, code {
37 line-height: 1.5;
38 font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Lucida Console', monospace;
39}
40
41pre {
42 margin-top: 0.5em;
43}
44
45h1, h2, h3, p {
46 font-family: Arial, sans serif;
47}
48
49h1, h2, h3 {
50 border-bottom: solid #CCC 1px;
51}
52
53.toc_element {
54 margin-top: 0.5em;
55}
56
57.firstline {
58 margin-left: 2 em;
59}
60
61.method {
62 margin-top: 1em;
63 border: solid 1px #CCC;
64 padding: 1em;
65 background: #EEE;
66}
67
68.details {
69 font-weight: bold;
70 font-size: 14px;
71}
72
73</style>
74
Bu Sun Kim715bd7f2019-06-14 16:50:42 -070075<h1><a href="sqladmin_v1beta4.html">Cloud SQL Admin API</a> . <a href="sqladmin_v1beta4.sslCerts.html">sslCerts</a></h1>
Craig Citroe633be12015-03-02 13:40:36 -080076<h2>Instance Methods</h2>
77<p class="toc_element">
Dmitry Frenkel3e17f892020-10-06 16:46:05 -070078 <code><a href="#close">close()</a></code></p>
79<p class="firstline">Close httplib2 connections.</p>
80<p class="toc_element">
Dan O'Mearadd494642020-05-01 07:42:23 -070081 <code><a href="#createEphemeral">createEphemeral(project, instance, body=None, x__xgafv=None)</a></code></p>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -070082<p class="firstline">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.</p>
Takashi Matsuo06694102015-09-11 13:55:40 -070083<p class="toc_element">
Dan O'Mearadd494642020-05-01 07:42:23 -070084 <code><a href="#delete">delete(project, instance, sha1Fingerprint, x__xgafv=None)</a></code></p>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -070085<p class="firstline">Deletes the SSL certificate. For First Generation instances, the certificate remains valid until the instance is restarted.</p>
Craig Citroe633be12015-03-02 13:40:36 -080086<p class="toc_element">
Dan O'Mearadd494642020-05-01 07:42:23 -070087 <code><a href="#get">get(project, instance, sha1Fingerprint, x__xgafv=None)</a></code></p>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -070088<p class="firstline">Retrieves a particular SSL certificate. Does not include the private key (required for usage). The private key must be saved from the response to initial creation.</p>
Craig Citroe633be12015-03-02 13:40:36 -080089<p class="toc_element">
Dan O'Mearadd494642020-05-01 07:42:23 -070090 <code><a href="#insert">insert(project, instance, body=None, x__xgafv=None)</a></code></p>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -070091<p class="firstline">Creates an SSL certificate and returns it along with the private key and server certificate authority. The new certificate will not be usable until the instance is restarted.</p>
Craig Citroe633be12015-03-02 13:40:36 -080092<p class="toc_element">
Dan O'Mearadd494642020-05-01 07:42:23 -070093 <code><a href="#list">list(project, instance, x__xgafv=None)</a></code></p>
Craig Citroe633be12015-03-02 13:40:36 -080094<p class="firstline">Lists all of the current SSL certificates for the instance.</p>
95<h3>Method Details</h3>
96<div class="method">
Dmitry Frenkel3e17f892020-10-06 16:46:05 -070097 <code class="details" id="close">close()</code>
98 <pre>Close httplib2 connections.</pre>
99</div>
100
101<div class="method">
Dan O'Mearadd494642020-05-01 07:42:23 -0700102 <code class="details" id="createEphemeral">createEphemeral(project, instance, body=None, x__xgafv=None)</code>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700103 <pre>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.
Takashi Matsuo06694102015-09-11 13:55:40 -0700104
105Args:
106 project: string, Project ID of the Cloud SQL project. (required)
107 instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
Dan O'Mearadd494642020-05-01 07:42:23 -0700108 body: object, The request body.
Takashi Matsuo06694102015-09-11 13:55:40 -0700109 The object takes the form of:
110
111{ # SslCerts create ephemeral certificate request.
Bu Sun Kim65020912020-05-20 12:08:20 -0700112 &quot;public_key&quot;: &quot;A String&quot;, # PEM encoded public key to include in the signed certificate.
Takashi Matsuo06694102015-09-11 13:55:40 -0700113 }
114
Dan O'Mearadd494642020-05-01 07:42:23 -0700115 x__xgafv: string, V1 error format.
116 Allowed values
117 1 - v1 error format
118 2 - v2 error format
Takashi Matsuo06694102015-09-11 13:55:40 -0700119
120Returns:
121 An object of the form:
122
123 { # SslCerts Resource
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800124 &quot;createTime&quot;: &quot;A String&quot;, # The time when the certificate was created in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800125 &quot;expirationTime&quot;: &quot;A String&quot;, # The time when the certificate expires in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
126 &quot;instance&quot;: &quot;A String&quot;, # Name of the database instance.
Yoshi Automation Botc2228be2020-11-24 15:48:03 -0800127 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800128 &quot;cert&quot;: &quot;A String&quot;, # PEM representation.
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800129 &quot;certSerialNumber&quot;: &quot;A String&quot;, # Serial number, as extracted from the certificate.
130 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#sslCert*.
131 &quot;sha1Fingerprint&quot;: &quot;A String&quot;, # Sha1 Fingerprint.
132 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Constrained to [a-zA-Z.-_ ]+.
Takashi Matsuo06694102015-09-11 13:55:40 -0700133 }</pre>
134</div>
135
136<div class="method">
Dan O'Mearadd494642020-05-01 07:42:23 -0700137 <code class="details" id="delete">delete(project, instance, sha1Fingerprint, x__xgafv=None)</code>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700138 <pre>Deletes the SSL certificate. For First Generation instances, the certificate remains valid until the instance is restarted.
Craig Citroe633be12015-03-02 13:40:36 -0800139
140Args:
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700141 project: string, Project ID of the project that contains the instance. (required)
Craig Citroe633be12015-03-02 13:40:36 -0800142 instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
143 sha1Fingerprint: string, Sha1 FingerPrint. (required)
Dan O'Mearadd494642020-05-01 07:42:23 -0700144 x__xgafv: string, V1 error format.
145 Allowed values
146 1 - v1 error format
147 2 - v2 error format
Craig Citroe633be12015-03-02 13:40:36 -0800148
149Returns:
150 An object of the form:
151
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800152 { # An Operation resource. For successful operations that return an Operation resource, only the fields relevant to the operation are populated in the resource. Next field: 18
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800153 &quot;error&quot;: { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
154 &quot;errors&quot;: [ # The list of errors encountered while processing this operation.
155 { # Database instance operation error.
156 &quot;code&quot;: &quot;A String&quot;, # Identifies the specific error that occurred.
157 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#operationError*.
158 &quot;message&quot;: &quot;A String&quot;, # Additional information about the error encountered.
159 },
160 ],
161 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#operationErrors*.
162 },
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800163 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800164 &quot;exportContext&quot;: { # Database instance export context. # The context for export operation, if applicable.
165 &quot;csvExportOptions&quot;: { # Options for exporting data as CSV. *MySQL* and *PostgreSQL* instances only.
166 &quot;selectQuery&quot;: &quot;A String&quot;, # The select query used to extract the data.
167 },
168 &quot;offload&quot;: True or False, # Option for export offload.
169 &quot;sqlExportOptions&quot;: { # Options for exporting data as SQL statements.
170 &quot;schemaOnly&quot;: True or False, # Export only schemas.
171 &quot;mysqlExportOptions&quot;: { # Options for exporting from MySQL.
172 &quot;masterData&quot;: 42, # Option to include SQL statement required to set up replication. If set to *1*, the dump file includes a CHANGE MASTER TO statement with the binary log coordinates, and --set-gtid-purged is set to ON. If set to *2*, the CHANGE MASTER TO statement is written as a SQL comment and has no effect. If set to any value other than *1*, --set-gtid-purged is set to OFF.
173 },
174 &quot;tables&quot;: [ # Tables to export, or that were exported, from the specified database. If you specify tables, specify one and only one database. For PostgreSQL instances, you can specify only one table.
175 &quot;A String&quot;,
176 ],
177 },
178 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#exportContext*.
179 &quot;fileType&quot;: &quot;A String&quot;, # The file type for the specified uri. *SQL*: The file contains SQL statements. *CSV*: The file contains CSV data. *BAK*: The file contains backup data for a SQL Server instance.
180 &quot;uri&quot;: &quot;A String&quot;, # The path to the file in Google Cloud Storage where the export will be stored. The URI is in the form *gs: //bucketName/fileName*. If the file already exists, the requests // succeeds, but the operation fails. If *fileType* is // *SQL* and the filename ends with .gz, the contents are // compressed.
181 &quot;databases&quot;: [ # Databases to be exported. *MySQL instances:* If *fileType* is *SQL* and no database is specified, all databases are exported, except for the *mysql* system database. If *fileType* is *CSV*, you can specify one database, either by using this property or by using the *csvExportOptions.selectQuery* property, which takes precedence over this property. *PostgreSQL instances:* You must specify one database to be exported. If *fileType* is *CSV*, this database must match the one specified in the *csvExportOptions.selectQuery* property.
182 &quot;A String&quot;,
183 ],
184 },
185 &quot;endTime&quot;: &quot;A String&quot;, # The time this operation finished in UTC timezone in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
186 &quot;targetProject&quot;: &quot;A String&quot;, # The project ID of the target instance related to this operation.
187 &quot;name&quot;: &quot;A String&quot;, # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
188 &quot;insertTime&quot;: &quot;A String&quot;, # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
189 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#operation*.
190 &quot;startTime&quot;: &quot;A String&quot;, # The time this operation actually started in UTC timezone in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
191 &quot;user&quot;: &quot;A String&quot;, # The email address of the user who initiated this operation.
192 &quot;backupContext&quot;: { # Backup context. # The context for backup operation, if applicable.
193 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#backupContext*.
194 &quot;backupId&quot;: &quot;A String&quot;, # The identifier of the backup.
195 },
196 &quot;status&quot;: &quot;A String&quot;, # The status of an operation. Valid values are: *PENDING* *RUNNING* *DONE* *SQL_OPERATION_STATUS_UNSPECIFIED*
197 &quot;targetLink&quot;: &quot;A String&quot;,
198 &quot;operationType&quot;: &quot;A String&quot;, # The type of the operation. Valid values are: *CREATE* *DELETE* *UPDATE* *RESTART* *IMPORT* *EXPORT* *BACKUP_VOLUME* *RESTORE_VOLUME* *CREATE_USER* *DELETE_USER* *CREATE_DATABASE* *DELETE_DATABASE*
199 &quot;targetId&quot;: &quot;A String&quot;, # Name of the database instance related to this operation.
Yoshi Automation Botc2228be2020-11-24 15:48:03 -0800200 &quot;importContext&quot;: { # Database instance import context. # The context for import operation, if applicable.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800201 &quot;importUser&quot;: &quot;A String&quot;, # The PostgreSQL user for this import operation. PostgreSQL instances only.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800202 &quot;fileType&quot;: &quot;A String&quot;, # The file type for the specified uri. *SQL*: The file contains SQL statements. *CSV*: The file contains CSV data.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800203 &quot;csvImportOptions&quot;: { # Options for importing data as CSV.
204 &quot;table&quot;: &quot;A String&quot;, # The table to which CSV data is imported.
205 &quot;columns&quot;: [ # The columns to which CSV data is imported. If not specified, all columns of the database table are loaded with CSV data.
206 &quot;A String&quot;,
207 ],
208 },
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800209 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#importContext*.
210 &quot;uri&quot;: &quot;A String&quot;, # Path to the import file in Cloud Storage, in the form *gs: //bucketName/fileName*. Compressed gzip files (.gz) are supported // when *fileType* is *SQL*. The instance must have // write permissions to the bucket and read access to the file.
211 &quot;database&quot;: &quot;A String&quot;, # The target database for the import. If *fileType* is *SQL*, this field is required only if the import file does not specify a database, and is overridden by any database specification in the import file. If *fileType* is *CSV*, one database must be specified.
212 &quot;bakImportOptions&quot;: { # Import parameters specific to SQL Server .BAK files
213 &quot;encryptionOptions&quot;: {
214 &quot;pvkPassword&quot;: &quot;A String&quot;, # Password that encrypts the private key
215 &quot;pvkPath&quot;: &quot;A String&quot;, # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the form *gs://bucketName/fileName*. The instance must have write permissions to the bucket and read access to the file.
216 &quot;certPath&quot;: &quot;A String&quot;, # Path to the Certificate (.cer) in Cloud Storage, in the form *gs://bucketName/fileName*. The instance must have write permissions to the bucket and read access to the file.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800217 },
218 },
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800219 },
Craig Citroe633be12015-03-02 13:40:36 -0800220 }</pre>
221</div>
222
223<div class="method">
Dan O'Mearadd494642020-05-01 07:42:23 -0700224 <code class="details" id="get">get(project, instance, sha1Fingerprint, x__xgafv=None)</code>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700225 <pre>Retrieves a particular SSL certificate. Does not include the private key (required for usage). The private key must be saved from the response to initial creation.
Craig Citroe633be12015-03-02 13:40:36 -0800226
227Args:
228 project: string, Project ID of the project that contains the instance. (required)
229 instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
230 sha1Fingerprint: string, Sha1 FingerPrint. (required)
Dan O'Mearadd494642020-05-01 07:42:23 -0700231 x__xgafv: string, V1 error format.
232 Allowed values
233 1 - v1 error format
234 2 - v2 error format
Craig Citroe633be12015-03-02 13:40:36 -0800235
236Returns:
237 An object of the form:
238
239 { # SslCerts Resource
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800240 &quot;createTime&quot;: &quot;A String&quot;, # The time when the certificate was created in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800241 &quot;expirationTime&quot;: &quot;A String&quot;, # The time when the certificate expires in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
242 &quot;instance&quot;: &quot;A String&quot;, # Name of the database instance.
Yoshi Automation Botc2228be2020-11-24 15:48:03 -0800243 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800244 &quot;cert&quot;: &quot;A String&quot;, # PEM representation.
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800245 &quot;certSerialNumber&quot;: &quot;A String&quot;, # Serial number, as extracted from the certificate.
246 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#sslCert*.
247 &quot;sha1Fingerprint&quot;: &quot;A String&quot;, # Sha1 Fingerprint.
248 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Constrained to [a-zA-Z.-_ ]+.
Craig Citroe633be12015-03-02 13:40:36 -0800249 }</pre>
250</div>
251
252<div class="method">
Dan O'Mearadd494642020-05-01 07:42:23 -0700253 <code class="details" id="insert">insert(project, instance, body=None, x__xgafv=None)</code>
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700254 <pre>Creates an SSL certificate and returns it along with the private key and server certificate authority. The new certificate will not be usable until the instance is restarted.
Craig Citroe633be12015-03-02 13:40:36 -0800255
256Args:
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700257 project: string, Project ID of the project that contains the instance. (required)
Craig Citroe633be12015-03-02 13:40:36 -0800258 instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
Dan O'Mearadd494642020-05-01 07:42:23 -0700259 body: object, The request body.
Craig Citroe633be12015-03-02 13:40:36 -0800260 The object takes the form of:
261
262{ # SslCerts insert request.
Dmitry Frenkel3e17f892020-10-06 16:46:05 -0700263 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Must be a distinct name from the other certificates for this instance.
Craig Citroe633be12015-03-02 13:40:36 -0800264 }
265
Dan O'Mearadd494642020-05-01 07:42:23 -0700266 x__xgafv: string, V1 error format.
267 Allowed values
268 1 - v1 error format
269 2 - v2 error format
Craig Citroe633be12015-03-02 13:40:36 -0800270
271Returns:
272 An object of the form:
273
274 { # SslCert insert response.
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800275 &quot;serverCaCert&quot;: { # SslCerts Resource # The server Certificate Authority&#x27;s certificate. If this is missing you can force a new one to be generated by calling resetSslConfig method on instances resource.
276 &quot;createTime&quot;: &quot;A String&quot;, # The time when the certificate was created in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*
277 &quot;expirationTime&quot;: &quot;A String&quot;, # The time when the certificate expires in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
278 &quot;instance&quot;: &quot;A String&quot;, # Name of the database instance.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800279 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800280 &quot;cert&quot;: &quot;A String&quot;, # PEM representation.
281 &quot;certSerialNumber&quot;: &quot;A String&quot;, # Serial number, as extracted from the certificate.
282 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#sslCert*.
283 &quot;sha1Fingerprint&quot;: &quot;A String&quot;, # Sha1 Fingerprint.
284 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Constrained to [a-zA-Z.-_ ]+.
285 },
286 &quot;clientCert&quot;: { # SslCertDetail. # The new client certificate and private key.
287 &quot;certInfo&quot;: { # SslCerts Resource # The public information about the cert.
288 &quot;createTime&quot;: &quot;A String&quot;, # The time when the certificate was created in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*
289 &quot;expirationTime&quot;: &quot;A String&quot;, # The time when the certificate expires in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
290 &quot;instance&quot;: &quot;A String&quot;, # Name of the database instance.
291 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
292 &quot;cert&quot;: &quot;A String&quot;, # PEM representation.
293 &quot;certSerialNumber&quot;: &quot;A String&quot;, # Serial number, as extracted from the certificate.
294 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#sslCert*.
295 &quot;sha1Fingerprint&quot;: &quot;A String&quot;, # Sha1 Fingerprint.
296 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Constrained to [a-zA-Z.-_ ]+.
297 },
298 &quot;certPrivateKey&quot;: &quot;A String&quot;, # The private key for the client cert, in pem format. Keep private in order to protect your security.
299 },
300 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#sslCertsInsert*.
301 &quot;operation&quot;: { # An Operation resource. For successful operations that return an Operation resource, only the fields relevant to the operation are populated in the resource. Next field: 18 # The operation to track the ssl certs insert request.
302 &quot;error&quot;: { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be populated.
303 &quot;errors&quot;: [ # The list of errors encountered while processing this operation.
304 { # Database instance operation error.
305 &quot;code&quot;: &quot;A String&quot;, # Identifies the specific error that occurred.
306 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#operationError*.
307 &quot;message&quot;: &quot;A String&quot;, # Additional information about the error encountered.
308 },
309 ],
310 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#operationErrors*.
311 },
312 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
313 &quot;exportContext&quot;: { # Database instance export context. # The context for export operation, if applicable.
314 &quot;csvExportOptions&quot;: { # Options for exporting data as CSV. *MySQL* and *PostgreSQL* instances only.
315 &quot;selectQuery&quot;: &quot;A String&quot;, # The select query used to extract the data.
316 },
317 &quot;offload&quot;: True or False, # Option for export offload.
318 &quot;sqlExportOptions&quot;: { # Options for exporting data as SQL statements.
319 &quot;schemaOnly&quot;: True or False, # Export only schemas.
320 &quot;mysqlExportOptions&quot;: { # Options for exporting from MySQL.
321 &quot;masterData&quot;: 42, # Option to include SQL statement required to set up replication. If set to *1*, the dump file includes a CHANGE MASTER TO statement with the binary log coordinates, and --set-gtid-purged is set to ON. If set to *2*, the CHANGE MASTER TO statement is written as a SQL comment and has no effect. If set to any value other than *1*, --set-gtid-purged is set to OFF.
322 },
323 &quot;tables&quot;: [ # Tables to export, or that were exported, from the specified database. If you specify tables, specify one and only one database. For PostgreSQL instances, you can specify only one table.
324 &quot;A String&quot;,
325 ],
326 },
327 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#exportContext*.
328 &quot;fileType&quot;: &quot;A String&quot;, # The file type for the specified uri. *SQL*: The file contains SQL statements. *CSV*: The file contains CSV data. *BAK*: The file contains backup data for a SQL Server instance.
329 &quot;uri&quot;: &quot;A String&quot;, # The path to the file in Google Cloud Storage where the export will be stored. The URI is in the form *gs: //bucketName/fileName*. If the file already exists, the requests // succeeds, but the operation fails. If *fileType* is // *SQL* and the filename ends with .gz, the contents are // compressed.
330 &quot;databases&quot;: [ # Databases to be exported. *MySQL instances:* If *fileType* is *SQL* and no database is specified, all databases are exported, except for the *mysql* system database. If *fileType* is *CSV*, you can specify one database, either by using this property or by using the *csvExportOptions.selectQuery* property, which takes precedence over this property. *PostgreSQL instances:* You must specify one database to be exported. If *fileType* is *CSV*, this database must match the one specified in the *csvExportOptions.selectQuery* property.
331 &quot;A String&quot;,
332 ],
333 },
334 &quot;endTime&quot;: &quot;A String&quot;, # The time this operation finished in UTC timezone in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
335 &quot;targetProject&quot;: &quot;A String&quot;, # The project ID of the target instance related to this operation.
336 &quot;name&quot;: &quot;A String&quot;, # An identifier that uniquely identifies the operation. You can use this identifier to retrieve the Operations resource that has information about the operation.
337 &quot;insertTime&quot;: &quot;A String&quot;, # The time this operation was enqueued in UTC timezone in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
338 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#operation*.
339 &quot;startTime&quot;: &quot;A String&quot;, # The time this operation actually started in UTC timezone in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
340 &quot;user&quot;: &quot;A String&quot;, # The email address of the user who initiated this operation.
341 &quot;backupContext&quot;: { # Backup context. # The context for backup operation, if applicable.
342 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#backupContext*.
343 &quot;backupId&quot;: &quot;A String&quot;, # The identifier of the backup.
344 },
345 &quot;status&quot;: &quot;A String&quot;, # The status of an operation. Valid values are: *PENDING* *RUNNING* *DONE* *SQL_OPERATION_STATUS_UNSPECIFIED*
346 &quot;targetLink&quot;: &quot;A String&quot;,
347 &quot;operationType&quot;: &quot;A String&quot;, # The type of the operation. Valid values are: *CREATE* *DELETE* *UPDATE* *RESTART* *IMPORT* *EXPORT* *BACKUP_VOLUME* *RESTORE_VOLUME* *CREATE_USER* *DELETE_USER* *CREATE_DATABASE* *DELETE_DATABASE*
348 &quot;targetId&quot;: &quot;A String&quot;, # Name of the database instance related to this operation.
Yoshi Automation Botc2228be2020-11-24 15:48:03 -0800349 &quot;importContext&quot;: { # Database instance import context. # The context for import operation, if applicable.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800350 &quot;importUser&quot;: &quot;A String&quot;, # The PostgreSQL user for this import operation. PostgreSQL instances only.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800351 &quot;fileType&quot;: &quot;A String&quot;, # The file type for the specified uri. *SQL*: The file contains SQL statements. *CSV*: The file contains CSV data.
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800352 &quot;csvImportOptions&quot;: { # Options for importing data as CSV.
353 &quot;table&quot;: &quot;A String&quot;, # The table to which CSV data is imported.
354 &quot;columns&quot;: [ # The columns to which CSV data is imported. If not specified, all columns of the database table are loaded with CSV data.
355 &quot;A String&quot;,
356 ],
357 },
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800358 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#importContext*.
359 &quot;uri&quot;: &quot;A String&quot;, # Path to the import file in Cloud Storage, in the form *gs: //bucketName/fileName*. Compressed gzip files (.gz) are supported // when *fileType* is *SQL*. The instance must have // write permissions to the bucket and read access to the file.
360 &quot;database&quot;: &quot;A String&quot;, # The target database for the import. If *fileType* is *SQL*, this field is required only if the import file does not specify a database, and is overridden by any database specification in the import file. If *fileType* is *CSV*, one database must be specified.
361 &quot;bakImportOptions&quot;: { # Import parameters specific to SQL Server .BAK files
362 &quot;encryptionOptions&quot;: {
363 &quot;pvkPassword&quot;: &quot;A String&quot;, # Password that encrypts the private key
364 &quot;pvkPath&quot;: &quot;A String&quot;, # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the form *gs://bucketName/fileName*. The instance must have write permissions to the bucket and read access to the file.
365 &quot;certPath&quot;: &quot;A String&quot;, # Path to the Certificate (.cer) in Cloud Storage, in the form *gs://bucketName/fileName*. The instance must have write permissions to the bucket and read access to the file.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800366 },
367 },
Yoshi Automation Bot0d561ef2020-11-25 07:50:41 -0800368 },
Bu Sun Kim673ec5c2020-11-16 11:05:03 -0700369 },
Craig Citroe633be12015-03-02 13:40:36 -0800370 }</pre>
371</div>
372
373<div class="method">
Dan O'Mearadd494642020-05-01 07:42:23 -0700374 <code class="details" id="list">list(project, instance, x__xgafv=None)</code>
Craig Citroe633be12015-03-02 13:40:36 -0800375 <pre>Lists all of the current SSL certificates for the instance.
376
377Args:
Bu Sun Kim715bd7f2019-06-14 16:50:42 -0700378 project: string, Project ID of the project that contains the instance. (required)
Craig Citroe633be12015-03-02 13:40:36 -0800379 instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
Dan O'Mearadd494642020-05-01 07:42:23 -0700380 x__xgafv: string, V1 error format.
381 Allowed values
382 1 - v1 error format
383 2 - v2 error format
Craig Citroe633be12015-03-02 13:40:36 -0800384
385Returns:
386 An object of the form:
387
388 { # SslCerts list response.
Bu Sun Kim65020912020-05-20 12:08:20 -0700389 &quot;items&quot;: [ # List of client certificates for the instance.
Craig Citroe633be12015-03-02 13:40:36 -0800390 { # SslCerts Resource
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800391 &quot;createTime&quot;: &quot;A String&quot;, # The time when the certificate was created in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800392 &quot;expirationTime&quot;: &quot;A String&quot;, # The time when the certificate expires in RFC 3339 format, for example *2012-11-15T16:19:00.094Z*.
393 &quot;instance&quot;: &quot;A String&quot;, # Name of the database instance.
Yoshi Automation Botc2228be2020-11-24 15:48:03 -0800394 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800395 &quot;cert&quot;: &quot;A String&quot;, # PEM representation.
Yoshi Automation Bot0bf565c2020-12-09 08:56:03 -0800396 &quot;certSerialNumber&quot;: &quot;A String&quot;, # Serial number, as extracted from the certificate.
397 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#sslCert*.
398 &quot;sha1Fingerprint&quot;: &quot;A String&quot;, # Sha1 Fingerprint.
399 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Constrained to [a-zA-Z.-_ ]+.
Craig Citroe633be12015-03-02 13:40:36 -0800400 },
401 ],
Yoshi Automation Botb6971b02020-11-26 17:16:03 -0800402 &quot;kind&quot;: &quot;A String&quot;, # This is always *sql#sslCertsList*.
Craig Citroe633be12015-03-02 13:40:36 -0800403 }</pre>
404</div>
405
406</body></html>