blob: 70d321b20d41c7bd6245e90c082b6377a50db9fc [file] [log] [blame]
Bu Sun Kim65020912020-05-20 12:08:20 -07001<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
75<h1><a href="sql_v1beta4.html">Cloud SQL Admin API</a> . <a href="sql_v1beta4.sslCerts.html">sslCerts</a></h1>
76<h2>Instance Methods</h2>
77<p class="toc_element">
78 <code><a href="#createEphemeral">createEphemeral(project, instance, body=None, x__xgafv=None)</a></code></p>
79<p class="firstline">Generates a short-lived X509 certificate containing the provided public key</p>
80<p class="toc_element">
81 <code><a href="#delete">delete(project, instance, sha1Fingerprint, x__xgafv=None)</a></code></p>
82<p class="firstline">Deletes the SSL certificate. For First Generation instances, the</p>
83<p class="toc_element">
84 <code><a href="#get">get(project, instance, sha1Fingerprint, x__xgafv=None)</a></code></p>
85<p class="firstline">Retrieves a particular SSL certificate. Does not include the private key</p>
86<p class="toc_element">
87 <code><a href="#insert">insert(project, instance, body=None, x__xgafv=None)</a></code></p>
88<p class="firstline">Creates an SSL certificate and returns it along with the private key and</p>
89<p class="toc_element">
90 <code><a href="#list">list(project, instance, x__xgafv=None)</a></code></p>
91<p class="firstline">Lists all of the current SSL certificates for the instance.</p>
92<h3>Method Details</h3>
93<div class="method">
94 <code class="details" id="createEphemeral">createEphemeral(project, instance, body=None, x__xgafv=None)</code>
95 <pre>Generates a short-lived X509 certificate containing the provided public key
96and signed by a private key specific to the target instance. Users may use
97the certificate to authenticate as themselves when connecting to the
98database.
99
100Args:
101 project: string, Project ID of the Cloud SQL project. (required)
102 instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
103 body: object, The request body.
104 The object takes the form of:
105
106{ # SslCerts create ephemeral certificate request.
107 &quot;public_key&quot;: &quot;A String&quot;, # PEM encoded public key to include in the signed certificate.
108 }
109
110 x__xgafv: string, V1 error format.
111 Allowed values
112 1 - v1 error format
113 2 - v2 error format
114
115Returns:
116 An object of the form:
117
118 { # SslCerts Resource
119 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
120 &quot;expirationTime&quot;: &quot;A String&quot;, # The time when the certificate expires in &lt;a
121 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
122 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
123 &quot;sha1Fingerprint&quot;: &quot;A String&quot;, # Sha1 Fingerprint.
124 &quot;certSerialNumber&quot;: &quot;A String&quot;, # Serial number, as extracted from the certificate.
125 &quot;cert&quot;: &quot;A String&quot;, # PEM representation.
126 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#sslCert&lt;/code&gt;.
127 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Constrained to [a-zA-Z.-_ ]+.
128 &quot;createTime&quot;: &quot;A String&quot;, # The time when the certificate was created in &lt;a
129 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
130 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;
131 &quot;instance&quot;: &quot;A String&quot;, # Name of the database instance.
132 }</pre>
133</div>
134
135<div class="method">
136 <code class="details" id="delete">delete(project, instance, sha1Fingerprint, x__xgafv=None)</code>
137 <pre>Deletes the SSL certificate. For First Generation instances, the
138certificate remains valid until the instance is restarted.
139
140Args:
141 project: string, Project ID of the project that contains the instance. (required)
142 instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
143 sha1Fingerprint: string, Sha1 FingerPrint. (required)
144 x__xgafv: string, V1 error format.
145 Allowed values
146 1 - v1 error format
147 2 - v2 error format
148
149Returns:
150 An object of the form:
151
152 { # An Operation resource.&amp;nbsp;For successful operations that return an
153 # Operation resource, only the fields relevant to the operation are populated
154 # in the resource.
Bu Sun Kim4ed7d3f2020-05-27 12:20:54 -0700155 &quot;name&quot;: &quot;A String&quot;, # An identifier that uniquely identifies the operation. You can use this
156 # identifier to retrieve the Operations resource that has information about
157 # the operation.
158 &quot;exportContext&quot;: { # Database instance export context. # The context for export operation, if applicable.
159 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#exportContext&lt;/code&gt;.
160 &quot;databases&quot;: [ # Databases to be exported. &lt;br /&gt; &lt;b&gt;MySQL instances:&lt;/b&gt; If
161 # &lt;code&gt;fileType&lt;/code&gt; is &lt;code&gt;SQL&lt;/code&gt; and no database is specified, all
162 # databases are exported, except for the &lt;code&gt;mysql&lt;/code&gt; system database.
163 # If &lt;code&gt;fileType&lt;/code&gt; is &lt;code&gt;CSV&lt;/code&gt;, you can specify one database,
164 # either by using this property or by using the
165 # &lt;code&gt;csvExportOptions.selectQuery&lt;/code&gt; property, which takes precedence
166 # over this property. &lt;br /&gt; &lt;b&gt;PostgreSQL instances:&lt;/b&gt; You must specify
167 # one database to be exported. If &lt;code&gt;fileType&lt;/code&gt; is &lt;code&gt;CSV&lt;/code&gt;,
168 # this database must match the one specified in the
169 # &lt;code&gt;csvExportOptions.selectQuery&lt;/code&gt; property.
170 &quot;A String&quot;,
171 ],
172 &quot;sqlExportOptions&quot;: { # Options for exporting data as SQL statements.
173 &quot;schemaOnly&quot;: True or False, # Export only schemas.
174 &quot;mysqlExportOptions&quot;: { # Options for exporting from MySQL.
175 &quot;masterData&quot;: 42, # Option to include SQL statement required to set up replication.
176 # If set to &lt;code&gt;1&lt;/code&gt;, the dump file includes
177 # a CHANGE MASTER TO statement with the binary log coordinates.
178 # If set to &lt;code&gt;2&lt;/code&gt;, the CHANGE MASTER TO statement is written as
179 # a SQL comment, and has no effect.
180 # All other values are ignored.
181 },
182 &quot;tables&quot;: [ # Tables to export, or that were exported, from the specified database. If
183 # you specify tables, specify one and only one database. For PostgreSQL
184 # instances, you can specify only one table.
185 &quot;A String&quot;,
186 ],
187 },
188 &quot;fileType&quot;: &quot;A String&quot;, # The file type for the specified uri. &lt;br&gt;&lt;code&gt;SQL&lt;/code&gt;: The file
189 # contains SQL statements. &lt;br&gt;&lt;code&gt;CSV&lt;/code&gt;: The file contains CSV data.
190 &quot;uri&quot;: &quot;A String&quot;, # The path to the file in Google Cloud Storage where the export will be
191 # stored. The URI is in the form &lt;code&gt;gs:
192 # //bucketName/fileName&lt;/code&gt;. If the file already exists, the requests
193 # // succeeds, but the operation fails. If &lt;code&gt;fileType&lt;/code&gt; is
194 # // &lt;code&gt;SQL&lt;/code&gt; and the filename ends with .gz, the contents are
195 # // compressed.
196 &quot;csvExportOptions&quot;: { # Options for exporting data as CSV.
197 &quot;selectQuery&quot;: &quot;A String&quot;, # The select query used to extract the data.
198 },
199 },
200 &quot;targetId&quot;: &quot;A String&quot;, # Name of the database instance related to this operation.
201 &quot;endTime&quot;: &quot;A String&quot;, # The time this operation finished in UTC timezone in &lt;a
202 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
203 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
204 &quot;startTime&quot;: &quot;A String&quot;, # The time this operation actually started in UTC timezone in &lt;a
205 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
206 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
207 &quot;insertTime&quot;: &quot;A String&quot;, # The time this operation was enqueued in UTC timezone in &lt;a
208 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
209 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
Bu Sun Kim65020912020-05-20 12:08:20 -0700210 &quot;user&quot;: &quot;A String&quot;, # The email address of the user who initiated this operation.
211 &quot;targetProject&quot;: &quot;A String&quot;, # The project ID of the target instance related to this operation.
212 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
213 &quot;targetLink&quot;: &quot;A String&quot;,
214 &quot;operationType&quot;: &quot;A String&quot;, # The type of the operation. Valid values are &lt;code&gt;CREATE&lt;/code&gt;,
215 # &lt;code&gt;DELETE&lt;/code&gt;, &lt;code&gt;UPDATE&lt;/code&gt;, &lt;code&gt;RESTART&lt;/code&gt;,
216 # &lt;code&gt;IMPORT&lt;/code&gt;, &lt;code&gt;EXPORT&lt;/code&gt;, &lt;code&gt;BACKUP_VOLUME&lt;/code&gt;,
217 # &lt;code&gt;RESTORE_VOLUME&lt;/code&gt;, &lt;code&gt;CREATE_USER&lt;/code&gt;,
218 # &lt;code&gt;DELETE_USER&lt;/code&gt;, &lt;code&gt;CREATE_DATABASE&lt;/code&gt;,
219 # &lt;code&gt;DELETE_DATABASE&lt;/code&gt; .
220 &quot;error&quot;: { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be
221 # populated.
222 &quot;errors&quot;: [ # The list of errors encountered while processing this operation.
223 { # Database instance operation error.
Bu Sun Kim4ed7d3f2020-05-27 12:20:54 -0700224 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#operationError&lt;/code&gt;.
Bu Sun Kim65020912020-05-20 12:08:20 -0700225 &quot;code&quot;: &quot;A String&quot;, # Identifies the specific error that occurred.
226 &quot;message&quot;: &quot;A String&quot;, # Additional information about the error encountered.
Bu Sun Kim65020912020-05-20 12:08:20 -0700227 },
228 ],
229 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#operationErrors&lt;/code&gt;.
230 },
231 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#operation&lt;/code&gt;.
232 &quot;importContext&quot;: { # Database instance import context. # The context for import operation, if applicable.
Bu Sun Kim4ed7d3f2020-05-27 12:20:54 -0700233 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#importContext&lt;/code&gt;.
Bu Sun Kim65020912020-05-20 12:08:20 -0700234 &quot;csvImportOptions&quot;: { # Options for importing data as CSV.
235 &quot;columns&quot;: [ # The columns to which CSV data is imported. If not specified, all columns
236 # of the database table are loaded with CSV data.
237 &quot;A String&quot;,
238 ],
239 &quot;table&quot;: &quot;A String&quot;, # The table to which CSV data is imported.
240 },
Bu Sun Kim65020912020-05-20 12:08:20 -0700241 &quot;database&quot;: &quot;A String&quot;, # The target database for the import. If &lt;code&gt;fileType&lt;/code&gt; is
242 # &lt;code&gt;SQL&lt;/code&gt;, this field is required only if the import file does not
243 # specify a database, and is overridden by any database specification in the
244 # import file. If &lt;code&gt;fileType&lt;/code&gt; is &lt;code&gt;CSV&lt;/code&gt;, one database
245 # must be specified.
246 &quot;importUser&quot;: &quot;A String&quot;, # The PostgreSQL user for this import operation. PostgreSQL instances only.
247 &quot;bakImportOptions&quot;: { # Import parameters specific to SQL Server .BAK files
248 &quot;encryptionOptions&quot;: {
249 &quot;pvkPassword&quot;: &quot;A String&quot;, # Password that encrypts the private key
250 &quot;certPath&quot;: &quot;A String&quot;, # Path to the Certificate (.cer) in Cloud Storage, in the form
251 # &lt;code&gt;gs://bucketName/fileName&lt;/code&gt;. The instance must have
252 # write permissions to the bucket and read access to the file.
253 &quot;pvkPath&quot;: &quot;A String&quot;, # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
254 # form &lt;code&gt;gs://bucketName/fileName&lt;/code&gt;. The instance must have
255 # write permissions to the bucket and read access to the file.
256 },
257 },
258 &quot;uri&quot;: &quot;A String&quot;, # Path to the import file in Cloud Storage, in the form
259 # &lt;code&gt;gs:
260 # //bucketName/fileName&lt;/code&gt;. Compressed gzip files (.gz) are supported
261 # // when &lt;code&gt;fileType&lt;/code&gt; is &lt;code&gt;SQL&lt;/code&gt;. The instance must have
262 # // write permissions to the bucket and read access to the file.
263 &quot;fileType&quot;: &quot;A String&quot;, # The file type for the specified uri. &lt;br&gt;&lt;code&gt;SQL&lt;/code&gt;: The file
264 # contains SQL statements. &lt;br&gt;&lt;code&gt;CSV&lt;/code&gt;: The file contains CSV data.
265 },
266 &quot;status&quot;: &quot;A String&quot;, # The status of an operation. Valid values are &lt;code&gt;PENDING&lt;/code&gt;,
267 # &lt;code&gt;RUNNING&lt;/code&gt;, &lt;code&gt;DONE&lt;/code&gt;,
268 # &lt;code&gt;SQL_OPERATION_STATUS_UNSPECIFIED&lt;/code&gt;.
Bu Sun Kim65020912020-05-20 12:08:20 -0700269 }</pre>
270</div>
271
272<div class="method">
273 <code class="details" id="get">get(project, instance, sha1Fingerprint, x__xgafv=None)</code>
274 <pre>Retrieves a particular SSL certificate. Does not include the private key
275(required for usage). The private key must be saved from the response to
276initial creation.
277
278Args:
279 project: string, Project ID of the project that contains the instance. (required)
280 instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
281 sha1Fingerprint: string, Sha1 FingerPrint. (required)
282 x__xgafv: string, V1 error format.
283 Allowed values
284 1 - v1 error format
285 2 - v2 error format
286
287Returns:
288 An object of the form:
289
290 { # SslCerts Resource
291 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
292 &quot;expirationTime&quot;: &quot;A String&quot;, # The time when the certificate expires in &lt;a
293 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
294 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
295 &quot;sha1Fingerprint&quot;: &quot;A String&quot;, # Sha1 Fingerprint.
296 &quot;certSerialNumber&quot;: &quot;A String&quot;, # Serial number, as extracted from the certificate.
297 &quot;cert&quot;: &quot;A String&quot;, # PEM representation.
298 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#sslCert&lt;/code&gt;.
299 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Constrained to [a-zA-Z.-_ ]+.
300 &quot;createTime&quot;: &quot;A String&quot;, # The time when the certificate was created in &lt;a
301 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
302 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;
303 &quot;instance&quot;: &quot;A String&quot;, # Name of the database instance.
304 }</pre>
305</div>
306
307<div class="method">
308 <code class="details" id="insert">insert(project, instance, body=None, x__xgafv=None)</code>
309 <pre>Creates an SSL certificate and returns it along with the private key and
310server certificate authority. The new certificate will not be usable until
311the instance is restarted.
312
313Args:
314 project: string, Project ID of the project that contains the instance. (required)
315 instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
316 body: object, The request body.
317 The object takes the form of:
318
319{ # SslCerts insert request.
320 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Must be a distinct name from the other certificates
321 # for this instance.
322 }
323
324 x__xgafv: string, V1 error format.
325 Allowed values
326 1 - v1 error format
327 2 - v2 error format
328
329Returns:
330 An object of the form:
331
332 { # SslCert insert response.
Bu Sun Kim65020912020-05-20 12:08:20 -0700333 &quot;serverCaCert&quot;: { # SslCerts Resource # The server Certificate Authority&#x27;s certificate. If this is missing you can
334 # force a new one to be generated by calling resetSslConfig method on
335 # instances resource.
336 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
337 &quot;expirationTime&quot;: &quot;A String&quot;, # The time when the certificate expires in &lt;a
338 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
339 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
340 &quot;sha1Fingerprint&quot;: &quot;A String&quot;, # Sha1 Fingerprint.
341 &quot;certSerialNumber&quot;: &quot;A String&quot;, # Serial number, as extracted from the certificate.
342 &quot;cert&quot;: &quot;A String&quot;, # PEM representation.
343 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#sslCert&lt;/code&gt;.
344 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Constrained to [a-zA-Z.-_ ]+.
345 &quot;createTime&quot;: &quot;A String&quot;, # The time when the certificate was created in &lt;a
346 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
347 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;
348 &quot;instance&quot;: &quot;A String&quot;, # Name of the database instance.
349 },
350 &quot;clientCert&quot;: { # SslCertDetail. # The new client certificate and private key. For First Generation
351 # instances, the new certificate does not take effect until the instance is
352 # restarted.
353 &quot;certInfo&quot;: { # SslCerts Resource # The public information about the cert.
354 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
355 &quot;expirationTime&quot;: &quot;A String&quot;, # The time when the certificate expires in &lt;a
356 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
357 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
358 &quot;sha1Fingerprint&quot;: &quot;A String&quot;, # Sha1 Fingerprint.
359 &quot;certSerialNumber&quot;: &quot;A String&quot;, # Serial number, as extracted from the certificate.
360 &quot;cert&quot;: &quot;A String&quot;, # PEM representation.
361 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#sslCert&lt;/code&gt;.
362 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Constrained to [a-zA-Z.-_ ]+.
363 &quot;createTime&quot;: &quot;A String&quot;, # The time when the certificate was created in &lt;a
364 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
365 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;
366 &quot;instance&quot;: &quot;A String&quot;, # Name of the database instance.
367 },
368 &quot;certPrivateKey&quot;: &quot;A String&quot;, # The private key for the client cert, in pem format. Keep private in order
369 # to protect your security.
370 },
371 &quot;operation&quot;: { # An Operation resource.&amp;nbsp;For successful operations that return an # The operation to track the ssl certs insert request.
372 # Operation resource, only the fields relevant to the operation are populated
373 # in the resource.
Bu Sun Kim4ed7d3f2020-05-27 12:20:54 -0700374 &quot;name&quot;: &quot;A String&quot;, # An identifier that uniquely identifies the operation. You can use this
375 # identifier to retrieve the Operations resource that has information about
376 # the operation.
377 &quot;exportContext&quot;: { # Database instance export context. # The context for export operation, if applicable.
378 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#exportContext&lt;/code&gt;.
379 &quot;databases&quot;: [ # Databases to be exported. &lt;br /&gt; &lt;b&gt;MySQL instances:&lt;/b&gt; If
380 # &lt;code&gt;fileType&lt;/code&gt; is &lt;code&gt;SQL&lt;/code&gt; and no database is specified, all
381 # databases are exported, except for the &lt;code&gt;mysql&lt;/code&gt; system database.
382 # If &lt;code&gt;fileType&lt;/code&gt; is &lt;code&gt;CSV&lt;/code&gt;, you can specify one database,
383 # either by using this property or by using the
384 # &lt;code&gt;csvExportOptions.selectQuery&lt;/code&gt; property, which takes precedence
385 # over this property. &lt;br /&gt; &lt;b&gt;PostgreSQL instances:&lt;/b&gt; You must specify
386 # one database to be exported. If &lt;code&gt;fileType&lt;/code&gt; is &lt;code&gt;CSV&lt;/code&gt;,
387 # this database must match the one specified in the
388 # &lt;code&gt;csvExportOptions.selectQuery&lt;/code&gt; property.
389 &quot;A String&quot;,
390 ],
391 &quot;sqlExportOptions&quot;: { # Options for exporting data as SQL statements.
392 &quot;schemaOnly&quot;: True or False, # Export only schemas.
393 &quot;mysqlExportOptions&quot;: { # Options for exporting from MySQL.
394 &quot;masterData&quot;: 42, # Option to include SQL statement required to set up replication.
395 # If set to &lt;code&gt;1&lt;/code&gt;, the dump file includes
396 # a CHANGE MASTER TO statement with the binary log coordinates.
397 # If set to &lt;code&gt;2&lt;/code&gt;, the CHANGE MASTER TO statement is written as
398 # a SQL comment, and has no effect.
399 # All other values are ignored.
400 },
401 &quot;tables&quot;: [ # Tables to export, or that were exported, from the specified database. If
402 # you specify tables, specify one and only one database. For PostgreSQL
403 # instances, you can specify only one table.
404 &quot;A String&quot;,
405 ],
406 },
407 &quot;fileType&quot;: &quot;A String&quot;, # The file type for the specified uri. &lt;br&gt;&lt;code&gt;SQL&lt;/code&gt;: The file
408 # contains SQL statements. &lt;br&gt;&lt;code&gt;CSV&lt;/code&gt;: The file contains CSV data.
409 &quot;uri&quot;: &quot;A String&quot;, # The path to the file in Google Cloud Storage where the export will be
410 # stored. The URI is in the form &lt;code&gt;gs:
411 # //bucketName/fileName&lt;/code&gt;. If the file already exists, the requests
412 # // succeeds, but the operation fails. If &lt;code&gt;fileType&lt;/code&gt; is
413 # // &lt;code&gt;SQL&lt;/code&gt; and the filename ends with .gz, the contents are
414 # // compressed.
415 &quot;csvExportOptions&quot;: { # Options for exporting data as CSV.
416 &quot;selectQuery&quot;: &quot;A String&quot;, # The select query used to extract the data.
417 },
418 },
419 &quot;targetId&quot;: &quot;A String&quot;, # Name of the database instance related to this operation.
420 &quot;endTime&quot;: &quot;A String&quot;, # The time this operation finished in UTC timezone in &lt;a
421 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
422 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
423 &quot;startTime&quot;: &quot;A String&quot;, # The time this operation actually started in UTC timezone in &lt;a
424 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
425 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
426 &quot;insertTime&quot;: &quot;A String&quot;, # The time this operation was enqueued in UTC timezone in &lt;a
427 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
428 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
Bu Sun Kim65020912020-05-20 12:08:20 -0700429 &quot;user&quot;: &quot;A String&quot;, # The email address of the user who initiated this operation.
430 &quot;targetProject&quot;: &quot;A String&quot;, # The project ID of the target instance related to this operation.
431 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
432 &quot;targetLink&quot;: &quot;A String&quot;,
433 &quot;operationType&quot;: &quot;A String&quot;, # The type of the operation. Valid values are &lt;code&gt;CREATE&lt;/code&gt;,
434 # &lt;code&gt;DELETE&lt;/code&gt;, &lt;code&gt;UPDATE&lt;/code&gt;, &lt;code&gt;RESTART&lt;/code&gt;,
435 # &lt;code&gt;IMPORT&lt;/code&gt;, &lt;code&gt;EXPORT&lt;/code&gt;, &lt;code&gt;BACKUP_VOLUME&lt;/code&gt;,
436 # &lt;code&gt;RESTORE_VOLUME&lt;/code&gt;, &lt;code&gt;CREATE_USER&lt;/code&gt;,
437 # &lt;code&gt;DELETE_USER&lt;/code&gt;, &lt;code&gt;CREATE_DATABASE&lt;/code&gt;,
438 # &lt;code&gt;DELETE_DATABASE&lt;/code&gt; .
439 &quot;error&quot;: { # Database instance operation errors list wrapper. # If errors occurred during processing of this operation, this field will be
440 # populated.
441 &quot;errors&quot;: [ # The list of errors encountered while processing this operation.
442 { # Database instance operation error.
Bu Sun Kim4ed7d3f2020-05-27 12:20:54 -0700443 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#operationError&lt;/code&gt;.
Bu Sun Kim65020912020-05-20 12:08:20 -0700444 &quot;code&quot;: &quot;A String&quot;, # Identifies the specific error that occurred.
445 &quot;message&quot;: &quot;A String&quot;, # Additional information about the error encountered.
Bu Sun Kim65020912020-05-20 12:08:20 -0700446 },
447 ],
448 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#operationErrors&lt;/code&gt;.
449 },
450 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#operation&lt;/code&gt;.
451 &quot;importContext&quot;: { # Database instance import context. # The context for import operation, if applicable.
Bu Sun Kim4ed7d3f2020-05-27 12:20:54 -0700452 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#importContext&lt;/code&gt;.
Bu Sun Kim65020912020-05-20 12:08:20 -0700453 &quot;csvImportOptions&quot;: { # Options for importing data as CSV.
454 &quot;columns&quot;: [ # The columns to which CSV data is imported. If not specified, all columns
455 # of the database table are loaded with CSV data.
456 &quot;A String&quot;,
457 ],
458 &quot;table&quot;: &quot;A String&quot;, # The table to which CSV data is imported.
459 },
Bu Sun Kim65020912020-05-20 12:08:20 -0700460 &quot;database&quot;: &quot;A String&quot;, # The target database for the import. If &lt;code&gt;fileType&lt;/code&gt; is
461 # &lt;code&gt;SQL&lt;/code&gt;, this field is required only if the import file does not
462 # specify a database, and is overridden by any database specification in the
463 # import file. If &lt;code&gt;fileType&lt;/code&gt; is &lt;code&gt;CSV&lt;/code&gt;, one database
464 # must be specified.
465 &quot;importUser&quot;: &quot;A String&quot;, # The PostgreSQL user for this import operation. PostgreSQL instances only.
466 &quot;bakImportOptions&quot;: { # Import parameters specific to SQL Server .BAK files
467 &quot;encryptionOptions&quot;: {
468 &quot;pvkPassword&quot;: &quot;A String&quot;, # Password that encrypts the private key
469 &quot;certPath&quot;: &quot;A String&quot;, # Path to the Certificate (.cer) in Cloud Storage, in the form
470 # &lt;code&gt;gs://bucketName/fileName&lt;/code&gt;. The instance must have
471 # write permissions to the bucket and read access to the file.
472 &quot;pvkPath&quot;: &quot;A String&quot;, # Path to the Certificate Private Key (.pvk) in Cloud Storage, in the
473 # form &lt;code&gt;gs://bucketName/fileName&lt;/code&gt;. The instance must have
474 # write permissions to the bucket and read access to the file.
475 },
476 },
477 &quot;uri&quot;: &quot;A String&quot;, # Path to the import file in Cloud Storage, in the form
478 # &lt;code&gt;gs:
479 # //bucketName/fileName&lt;/code&gt;. Compressed gzip files (.gz) are supported
480 # // when &lt;code&gt;fileType&lt;/code&gt; is &lt;code&gt;SQL&lt;/code&gt;. The instance must have
481 # // write permissions to the bucket and read access to the file.
482 &quot;fileType&quot;: &quot;A String&quot;, # The file type for the specified uri. &lt;br&gt;&lt;code&gt;SQL&lt;/code&gt;: The file
483 # contains SQL statements. &lt;br&gt;&lt;code&gt;CSV&lt;/code&gt;: The file contains CSV data.
484 },
485 &quot;status&quot;: &quot;A String&quot;, # The status of an operation. Valid values are &lt;code&gt;PENDING&lt;/code&gt;,
486 # &lt;code&gt;RUNNING&lt;/code&gt;, &lt;code&gt;DONE&lt;/code&gt;,
487 # &lt;code&gt;SQL_OPERATION_STATUS_UNSPECIFIED&lt;/code&gt;.
Bu Sun Kim65020912020-05-20 12:08:20 -0700488 },
Bu Sun Kim4ed7d3f2020-05-27 12:20:54 -0700489 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#sslCertsInsert&lt;/code&gt;.
Bu Sun Kim65020912020-05-20 12:08:20 -0700490 }</pre>
491</div>
492
493<div class="method">
494 <code class="details" id="list">list(project, instance, x__xgafv=None)</code>
495 <pre>Lists all of the current SSL certificates for the instance.
496
497Args:
498 project: string, Project ID of the project that contains the instance. (required)
499 instance: string, Cloud SQL instance ID. This does not include the project ID. (required)
500 x__xgafv: string, V1 error format.
501 Allowed values
502 1 - v1 error format
503 2 - v2 error format
504
505Returns:
506 An object of the form:
507
508 { # SslCerts list response.
509 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#sslCertsList&lt;/code&gt;.
510 &quot;items&quot;: [ # List of client certificates for the instance.
511 { # SslCerts Resource
512 &quot;selfLink&quot;: &quot;A String&quot;, # The URI of this resource.
513 &quot;expirationTime&quot;: &quot;A String&quot;, # The time when the certificate expires in &lt;a
514 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
515 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;.
516 &quot;sha1Fingerprint&quot;: &quot;A String&quot;, # Sha1 Fingerprint.
517 &quot;certSerialNumber&quot;: &quot;A String&quot;, # Serial number, as extracted from the certificate.
518 &quot;cert&quot;: &quot;A String&quot;, # PEM representation.
519 &quot;kind&quot;: &quot;A String&quot;, # This is always &lt;code&gt;sql#sslCert&lt;/code&gt;.
520 &quot;commonName&quot;: &quot;A String&quot;, # User supplied name. Constrained to [a-zA-Z.-_ ]+.
521 &quot;createTime&quot;: &quot;A String&quot;, # The time when the certificate was created in &lt;a
522 # href=&quot;https://tools.ietf.org/html/rfc3339&quot;&gt;RFC 3339&lt;/a&gt; format, for example
523 # &lt;code&gt;2012-11-15T16:19:00.094Z&lt;/code&gt;
524 &quot;instance&quot;: &quot;A String&quot;, # Name of the database instance.
525 },
526 ],
527 }</pre>
528</div>
529
530</body></html>