docs: update docs (#916)
* fix: re-run script
* test: fix noxfile
diff --git a/docs/dyn/sql_v1beta4.instances.html b/docs/dyn/sql_v1beta4.instances.html
index 7e59129..0a93ec0 100644
--- a/docs/dyn/sql_v1beta4.instances.html
+++ b/docs/dyn/sql_v1beta4.instances.html
@@ -163,6 +163,61 @@
{ # An Operation resource. For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -177,15 +232,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -193,7 +249,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -222,61 +277,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -294,17 +294,17 @@
{ # Database instance clone request.
"cloneContext": { # Database instance clone context. # Contains details about the clone operation.
+ "destinationInstanceName": "A String", # Name of the Cloud SQL instance to be created as a clone.
"pitrTimestampMs": "A String", # Reserved for future use.
"binLogCoordinates": { # Binary log coordinates. # Binary log coordinates, if specified, identify the position up to which the
# source instance should be cloned. If not specified, the source instance is
# cloned up to the most recent binary log coordinates.
+ "binLogFileName": "A String", # Name of the binary log file for a Cloud SQL instance.
"binLogPosition": "A String", # Position (offset) within the binary log file.
"kind": "A String", # This is always <code>sql#binLogCoordinates</code>.
- "binLogFileName": "A String", # Name of the binary log file for a Cloud SQL instance.
},
"kind": "A String", # This is always <code>sql#cloneContext</code>.
"pointInTime": "A String", # Reserved for future use.
- "destinationInstanceName": "A String", # Name of the Cloud SQL instance to be created as a clone.
},
}
@@ -319,6 +319,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -333,15 +388,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -349,7 +405,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -378,61 +433,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -454,6 +454,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -468,15 +523,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -484,7 +540,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -513,61 +568,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -584,25 +584,6 @@
{ # Database demote master request.
"demoteMasterContext": { # Database instance demote master context. # Contains details about the demoteMaster operation.
- "replicaConfiguration": { # Read-replica configuration for connecting to the on-premises master. # Configuration specific to read-replicas replicating from the on-premises
- # master.
- "kind": "A String", # This is always <code>sql#demoteMasterConfiguration</code>.
- "mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises
- # master. Replication configuration information such as the username,
- # password, certificates, and keys are not stored in the instance metadata.
- # The configuration information is used only to set up the replication
- # connection and is stored by MySQL in a file named <code>master.info</code>
- # in the data directory.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for the replication connection.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#demoteMasterMysqlReplicaConfiguration</code>.
- "password": "A String", # The password for the replication connection.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate. The format of the slave's private
- # key can be either PKCS #1 or PKCS #8.
- },
- },
"kind": "A String", # This is always <code>sql#demoteMasterContext</code>.
"masterInstanceName": "A String", # The name of the instance which will act as on-premises master in the
# replication setup.
@@ -613,6 +594,25 @@
# exposes you to the risk of future replication failures. Change the value
# only if you know the reason for the GTID divergence and are confident that
# doing so will not cause any replication issues.
+ "replicaConfiguration": { # Read-replica configuration for connecting to the on-premises master. # Configuration specific to read-replicas replicating from the on-premises
+ # master.
+ "kind": "A String", # This is always <code>sql#demoteMasterConfiguration</code>.
+ "mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises
+ # master. Replication configuration information such as the username,
+ # password, certificates, and keys are not stored in the instance metadata.
+ # The configuration information is used only to set up the replication
+ # connection and is stored by MySQL in a file named <code>master.info</code>
+ # in the data directory.
+ "kind": "A String", # This is always <code>sql#demoteMasterMysqlReplicaConfiguration</code>.
+ "password": "A String", # The password for the replication connection.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate. The format of the slave's private
+ # key can be either PKCS #1 or PKCS #8.
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for the replication connection.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ },
+ },
},
}
@@ -627,6 +627,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -641,15 +696,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -657,7 +713,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -686,61 +741,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -757,6 +757,7 @@
{ # Database instance export request.
"exportContext": { # Database instance export context. # Contains details about the export operation.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
"databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
# <code>fileType</code> is <code>SQL</code> and no database is specified, all
# databases are exported, except for the <code>mysql</code> system database.
@@ -770,11 +771,6 @@
"A String",
],
"sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
"schemaOnly": True or False, # Export only schemas.
"mysqlExportOptions": { # Options for exporting from MySQL.
"masterData": 42, # Option to include SQL statement required to set up replication.
@@ -784,6 +780,11 @@
# a SQL comment, and has no effect.
# All other values are ignored.
},
+ "tables": [ # 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.
+ "A String",
+ ],
},
"fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
# contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
@@ -796,7 +797,6 @@
"csvExportOptions": { # Options for exporting data as CSV.
"selectQuery": "A String", # The select query used to extract the data.
},
- "kind": "A String", # This is always <code>sql#exportContext</code>.
},
}
@@ -811,6 +811,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -825,15 +880,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -841,7 +897,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -870,61 +925,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -941,9 +941,9 @@
{ # Instance failover request.
"failoverContext": { # Database instance failover context. # Failover Context.
+ "kind": "A String", # This is always <code>sql#failoverContext</code>.
"settingsVersion": "A String", # The current settings version of this instance. Request will be rejected if
# this version doesn't match the current settings version.
- "kind": "A String", # This is always <code>sql#failoverContext</code>.
},
}
@@ -958,6 +958,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -972,15 +1027,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -988,7 +1044,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -1017,61 +1072,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -1091,51 +1091,6 @@
An object of the form:
{ # A Cloud SQL instance resource.
- "ipv6Address": "A String", # The IPv6 address assigned to the instance. This property is applicable only
- # to First Generation instances.
- "selfLink": "A String", # The URI of this resource.
- "diskEncryptionStatus": { # Disk encryption status for an instance. # Disk encryption status specific to an instance.
- # Applies only to Second Generation instances.
- "kmsKeyVersionName": "A String", # KMS key version used to encrypt the Cloud SQL instance resource
- "kind": "A String", # This is always <code>sql#diskEncryptionStatus</code>.
- },
- "kind": "A String", # This is always <code>sql#instance</code>.
- "region": "A String", # The geographical region. Can be <code>us-central</code>
- # (<code>FIRST_GEN</code> instances only), <code>us-central1</code>
- # (<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
- # <code>europe-west1</code>. Defaults to <code>us-central</code> or
- # <code>us-central1</code> depending on the instance type (First Generation
- # or Second Generation). The region can not be changed after instance
- # creation.
- "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the
- # following. <br><code>RUNNABLE</code>: The instance is running, or is ready
- # to run when accessed. <br><code>SUSPENDED</code>: The instance is not
- # available, for example due to problems with billing.
- # <br><code>PENDING_CREATE</code>: The instance is being created.
- # <br><code>MAINTENANCE</code>: The instance is down for maintenance.
- # <br><code>FAILED</code>: The instance creation failed.
- # <br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.
- "backendType": "A String", # <code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
- # /><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
- # instance. <br /><code>EXTERNAL</code>: A database server that is not
- # managed by Google. <br>This property is read-only; use the
- # <code>tier</code> property in the <code>settings</code> object to determine
- # the database type and Second or First Generation.
- "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
- "hostPort": "A String", # The host and port of the on-premises instance in host:port format
- "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for connecting to on-premises instance.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
- "password": "A String", # The password for connecting to on-premises instance.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate.
- },
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
- # apps domain is prefixed if applicable.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
- # is applicable only to Second Generation instances.
"databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
# field can not be changed after instance creation. MySQL Second Generation
# instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
@@ -1146,29 +1101,72 @@
"A String",
],
"settings": { # Database instance settings. # The user settings.
+ "backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
+ "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
+ # disabled, binarylog must be disabled as well.
+ "replicationLogArchivingEnabled": True or False, # Reserved for future use.
+ "location": "A String", # Location of the backup
+ "pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
+ "startTime": "A String", # Start time for the daily backup configuration in UTC timezone in the 24
+ # hour format - <code>HH:MM</code>.
+ "kind": "A String", # This is always <code>sql#backupConfiguration</code>.
+ "enabled": True or False, # Whether this configuration is enabled.
+ },
+ "userLabels": { # User-provided labels, represented as a dictionary where each label is a
+ # single key value pair.
+ "a_key": "A String",
+ },
+ "locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # The location preference settings. This allows the instance to be located as
+ # near as possible to either an App Engine app or Compute Engine zone for
+ # better performance. App Engine co-location is only applicable to First
+ # Generation instances.
+ # preferably be located, either in a specific Compute Engine zone, or
+ # co-located with an App Engine application. Note that if the preferred
+ # location is not available, the instance will be located as close as possible
+ # within the region. Only one location may be specified.
+ "kind": "A String", # This is always <code>sql#locationPreference</code>.
+ "zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
+ # etc.).
+ "followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
+ # Cloud SQL instance.
+ },
+ "kind": "A String", # This is always <code>sql#settings</code>.
+ "replicationType": "A String", # The type of replication this instance uses. This can be either
+ # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
+ # only applicable to First Generation instances.
+ "activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
+ # applicable only when the instance state is <code>RUNNABLE</code>. Valid
+ # values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
+ # the absence of connection requests. <br><code>NEVER</code>: The instance is
+ # off; it is not activated, even if a connection request arrives.
+ # <br><code>ON_DEMAND</code>: First Generation instances only. The instance
+ # responds to incoming requests, and turns itself off when not in use.
+ # Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
+ # inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
+ # 12 hours of inactivity.
"ipConfiguration": { # IP Management configuration. # The settings for IP Management. This allows to enable or disable the
# instance IP and manage which external networks can connect to the instance.
# The IPv4 address cannot be disabled for Second Generation instances.
- "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
- # accessible for private IP. For example,
- # <code>/projects/myProject/global/networks/default</code>. This setting can
- # be updated, but it cannot be removed after it is set.
- "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
"authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
# using the IP. In <a
# href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
# notation</a>, also known as 'slash' notation (e.g.
# <code>192.168.100.0/24</code>).
{ # An entry for an Access Control list.
+ "kind": "A String", # This is always <code>sql#aclEntry</code>.
"value": "A String", # The whitelisted value for the access control list.
"expirationTime": "A String", # The time when this access control entry expires in <a
# href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
# <code>2012-11-15T16:19:00.094Z</code>.
"name": "A String", # Optional. A label to identify this entry.
- "kind": "A String", # This is always <code>sql#aclEntry</code>.
},
],
"requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
+ "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
+ # accessible for private IP. For example,
+ # <code>/projects/myProject/global/networks/default</code>. This setting can
+ # be updated, but it cannot be removed after it is set.
+ "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
},
"availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
# <br><code>ZONAL</code>: The instance serves data from only one zone.
@@ -1183,27 +1181,27 @@
# to update this value.
"databaseFlags": [ # The database flags passed to the instance at startup.
{ # Database flags for Cloud SQL instances.
- "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
- # and <code>off</code> for false. This field must be omitted if the flag
- # doesn't take a value.
"name": "A String", # The name of the flag. These flags are passed at instance startup, so
# include both server options and system variables for MySQL. Flags should be
# specified with underscores, not hyphens. For more information, see <a
# href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
# SQL documentation.
+ "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
+ # and <code>off</code> for false. This field must be omitted if the flag
+ # doesn't take a value.
},
],
"maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
# can be restarted for maintenance purposes. Not used for First Generation
# instances.
# preferably be restarted for system maintenance purposes.
+ "hour": 42, # hour of day - 0 to 23.
+ "day": 42, # day of week (1-7), starting on Monday.
+ "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
"updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
# <code>stable</code> (Later). <br /><a
# href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
# Learn more</a>.
- "hour": 42, # hour of day - 0 to 23.
- "day": 42, # day of week (1-7), starting on Monday.
- "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
},
"pricingPlan": "A String", # The pricing plan for this instance. This can be either <code>PER_USE</code>
# or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
@@ -1232,64 +1230,21 @@
"crashSafeReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether
# database flags for crash-safe replication are enabled. This property is
# only applicable to First Generation instances.
- "backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
- "pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
- "startTime": "A String", # Start time for the daily backup configuration in UTC timezone in the 24
- # hour format - <code>HH:MM</code>.
- "kind": "A String", # This is always <code>sql#backupConfiguration</code>.
- "enabled": True or False, # Whether this configuration is enabled.
- "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
- # disabled, binarylog must be disabled as well.
- "replicationLogArchivingEnabled": True or False, # Reserved for future use.
- "location": "A String", # Location of the backup
- },
- "userLabels": { # User-provided labels, represented as a dictionary where each label is a
- # single key value pair.
- "a_key": "A String",
- },
- "locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # The location preference settings. This allows the instance to be located as
- # near as possible to either an App Engine app or Compute Engine zone for
- # better performance. App Engine co-location is only applicable to First
- # Generation instances.
- # preferably be located, either in a specific Compute Engine zone, or
- # co-located with an App Engine application. Note that if the preferred
- # location is not available, the instance will be located as close as possible
- # within the region. Only one location may be specified.
- "followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
- # Cloud SQL instance.
- "kind": "A String", # This is always <code>sql#locationPreference</code>.
- "zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
- # etc.).
- },
- "kind": "A String", # This is always <code>sql#settings</code>.
- "replicationType": "A String", # The type of replication this instance uses. This can be either
- # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
- # only applicable to First Generation instances.
- "activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
- # applicable only when the instance state is <code>RUNNABLE</code>. Valid
- # values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
- # the absence of connection requests. <br><code>NEVER</code>: The instance is
- # off; it is not activated, even if a connection request arrives.
- # <br><code>ON_DEMAND</code>: First Generation instances only. The instance
- # responds to incoming requests, and turns itself off when not in use.
- # Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
- # inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
- # 12 hours of inactivity.
},
"replicaNames": [ # The replicas of the instance.
"A String",
],
"diskEncryptionConfiguration": { # Disk encryption configuration for an instance. # Disk encryption configuration specific to an instance.
# Applies only to Second Generation instances.
- "kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
"kmsKeyName": "A String", # Resource name of KMS key for disk encryption
+ "kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
},
- "rootPassword": "A String", # Initial root password. Use only on creation.
"scheduledMaintenance": { # Any scheduled maintenancce for this instance. # The start time of any upcoming scheduled maintenance for this instance.
"canReschedule": True or False, # If the scheduled maintenance can be rescheduled.
"canDefer": True or False,
"startTime": "A String", # The start time of any upcoming scheduled maintenance for this instance.
},
+ "rootPassword": "A String", # Initial root password. Use only on creation.
"etag": "A String", # This field is deprecated and will be removed from a future version of the
# API. Use the <code>settings.settingsVersion</code> field instead.
"serverCaCert": { # SslCerts Resource # SSL configuration.
@@ -1326,7 +1281,6 @@
# href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
# announcement</a> for details.
"replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to failover replicas and read replicas.
- "kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
"mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises
# master. Replication configuration information such as the username,
# password, certificates, and keys are not stored in the instance metadata.
@@ -1358,32 +1312,78 @@
# the new master instance. <p>Only one replica can be specified as failover
# target, and the replica has to be in different zone with the master
# instance.
+ "kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
},
"connectionName": "A String", # Connection name of the Cloud SQL instance used in connection strings.
"failoverReplica": { # The name and status of the failover replica. This property is applicable
# only to Second Generation instances.
- "available": True or False, # The availability status of the failover replica. A false status indicates
- # that the failover replica is out of sync. The master can only failover to
- # the failover replica when the status is true.
"name": "A String", # The name of the failover replica. If specified at instance creation, a
# failover replica is created for the instance. The name
# doesn't include the project ID. This property is applicable only to
# Second Generation instances.
+ "available": True or False, # The availability status of the failover replica. A false status indicates
+ # that the failover replica is out of sync. The master can only failover to
+ # the failover replica when the status is true.
},
"ipAddresses": [ # The assigned IP addresses for the instance.
{ # Database instance IP Mapping.
- "timeToRetire": "A String", # The due time for this IP to be retired in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>. This field is only available when
- # the IP is scheduled to be retired.
"type": "A String", # The type of this IP address. A <code>PRIMARY</code> address is a public
# address that can accept incoming connections. A <code>PRIVATE</code>
# address is a private address that can accept incoming connections. An
# <code>OUTGOING</code> address is the source address of connections
# originating from the instance, if supported.
"ipAddress": "A String", # The IP address assigned.
+ "timeToRetire": "A String", # The due time for this IP to be retired in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>. This field is only available when
+ # the IP is scheduled to be retired.
},
],
+ "ipv6Address": "A String", # The IPv6 address assigned to the instance. This property is applicable only
+ # to First Generation instances.
+ "selfLink": "A String", # The URI of this resource.
+ "diskEncryptionStatus": { # Disk encryption status for an instance. # Disk encryption status specific to an instance.
+ # Applies only to Second Generation instances.
+ "kmsKeyVersionName": "A String", # KMS key version used to encrypt the Cloud SQL instance resource
+ "kind": "A String", # This is always <code>sql#diskEncryptionStatus</code>.
+ },
+ "kind": "A String", # This is always <code>sql#instance</code>.
+ "region": "A String", # The geographical region. Can be <code>us-central</code>
+ # (<code>FIRST_GEN</code> instances only), <code>us-central1</code>
+ # (<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
+ # <code>europe-west1</code>. Defaults to <code>us-central</code> or
+ # <code>us-central1</code> depending on the instance type (First Generation
+ # or Second Generation). The region can not be changed after instance
+ # creation.
+ "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the
+ # following. <br><code>RUNNABLE</code>: The instance is running, or is ready
+ # to run when accessed. <br><code>SUSPENDED</code>: The instance is not
+ # available, for example due to problems with billing.
+ # <br><code>PENDING_CREATE</code>: The instance is being created.
+ # <br><code>MAINTENANCE</code>: The instance is down for maintenance.
+ # <br><code>FAILED</code>: The instance creation failed.
+ # <br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.
+ "backendType": "A String", # <code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
+ # /><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
+ # instance. <br /><code>EXTERNAL</code>: A database server that is not
+ # managed by Google. <br>This property is read-only; use the
+ # <code>tier</code> property in the <code>settings</code> object to determine
+ # the database type and Second or First Generation.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for connecting to on-premises instance.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
+ "password": "A String", # The password for connecting to on-premises instance.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate.
+ },
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
+ # apps domain is prefixed if applicable.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
+ # is applicable only to Second Generation instances.
}</pre>
</div>
@@ -1400,6 +1400,7 @@
{ # Database instance import request.
"importContext": { # Database instance import context. # Contains details about the import operation.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -1407,7 +1408,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -1446,6 +1446,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -1460,15 +1515,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -1476,7 +1532,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -1505,61 +1560,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -1574,51 +1574,6 @@
The object takes the form of:
{ # A Cloud SQL instance resource.
- "ipv6Address": "A String", # The IPv6 address assigned to the instance. This property is applicable only
- # to First Generation instances.
- "selfLink": "A String", # The URI of this resource.
- "diskEncryptionStatus": { # Disk encryption status for an instance. # Disk encryption status specific to an instance.
- # Applies only to Second Generation instances.
- "kmsKeyVersionName": "A String", # KMS key version used to encrypt the Cloud SQL instance resource
- "kind": "A String", # This is always <code>sql#diskEncryptionStatus</code>.
- },
- "kind": "A String", # This is always <code>sql#instance</code>.
- "region": "A String", # The geographical region. Can be <code>us-central</code>
- # (<code>FIRST_GEN</code> instances only), <code>us-central1</code>
- # (<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
- # <code>europe-west1</code>. Defaults to <code>us-central</code> or
- # <code>us-central1</code> depending on the instance type (First Generation
- # or Second Generation). The region can not be changed after instance
- # creation.
- "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the
- # following. <br><code>RUNNABLE</code>: The instance is running, or is ready
- # to run when accessed. <br><code>SUSPENDED</code>: The instance is not
- # available, for example due to problems with billing.
- # <br><code>PENDING_CREATE</code>: The instance is being created.
- # <br><code>MAINTENANCE</code>: The instance is down for maintenance.
- # <br><code>FAILED</code>: The instance creation failed.
- # <br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.
- "backendType": "A String", # <code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
- # /><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
- # instance. <br /><code>EXTERNAL</code>: A database server that is not
- # managed by Google. <br>This property is read-only; use the
- # <code>tier</code> property in the <code>settings</code> object to determine
- # the database type and Second or First Generation.
- "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
- "hostPort": "A String", # The host and port of the on-premises instance in host:port format
- "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for connecting to on-premises instance.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
- "password": "A String", # The password for connecting to on-premises instance.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate.
- },
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
- # apps domain is prefixed if applicable.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
- # is applicable only to Second Generation instances.
"databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
# field can not be changed after instance creation. MySQL Second Generation
# instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
@@ -1629,29 +1584,72 @@
"A String",
],
"settings": { # Database instance settings. # The user settings.
+ "backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
+ "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
+ # disabled, binarylog must be disabled as well.
+ "replicationLogArchivingEnabled": True or False, # Reserved for future use.
+ "location": "A String", # Location of the backup
+ "pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
+ "startTime": "A String", # Start time for the daily backup configuration in UTC timezone in the 24
+ # hour format - <code>HH:MM</code>.
+ "kind": "A String", # This is always <code>sql#backupConfiguration</code>.
+ "enabled": True or False, # Whether this configuration is enabled.
+ },
+ "userLabels": { # User-provided labels, represented as a dictionary where each label is a
+ # single key value pair.
+ "a_key": "A String",
+ },
+ "locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # The location preference settings. This allows the instance to be located as
+ # near as possible to either an App Engine app or Compute Engine zone for
+ # better performance. App Engine co-location is only applicable to First
+ # Generation instances.
+ # preferably be located, either in a specific Compute Engine zone, or
+ # co-located with an App Engine application. Note that if the preferred
+ # location is not available, the instance will be located as close as possible
+ # within the region. Only one location may be specified.
+ "kind": "A String", # This is always <code>sql#locationPreference</code>.
+ "zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
+ # etc.).
+ "followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
+ # Cloud SQL instance.
+ },
+ "kind": "A String", # This is always <code>sql#settings</code>.
+ "replicationType": "A String", # The type of replication this instance uses. This can be either
+ # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
+ # only applicable to First Generation instances.
+ "activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
+ # applicable only when the instance state is <code>RUNNABLE</code>. Valid
+ # values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
+ # the absence of connection requests. <br><code>NEVER</code>: The instance is
+ # off; it is not activated, even if a connection request arrives.
+ # <br><code>ON_DEMAND</code>: First Generation instances only. The instance
+ # responds to incoming requests, and turns itself off when not in use.
+ # Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
+ # inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
+ # 12 hours of inactivity.
"ipConfiguration": { # IP Management configuration. # The settings for IP Management. This allows to enable or disable the
# instance IP and manage which external networks can connect to the instance.
# The IPv4 address cannot be disabled for Second Generation instances.
- "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
- # accessible for private IP. For example,
- # <code>/projects/myProject/global/networks/default</code>. This setting can
- # be updated, but it cannot be removed after it is set.
- "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
"authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
# using the IP. In <a
# href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
# notation</a>, also known as 'slash' notation (e.g.
# <code>192.168.100.0/24</code>).
{ # An entry for an Access Control list.
+ "kind": "A String", # This is always <code>sql#aclEntry</code>.
"value": "A String", # The whitelisted value for the access control list.
"expirationTime": "A String", # The time when this access control entry expires in <a
# href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
# <code>2012-11-15T16:19:00.094Z</code>.
"name": "A String", # Optional. A label to identify this entry.
- "kind": "A String", # This is always <code>sql#aclEntry</code>.
},
],
"requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
+ "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
+ # accessible for private IP. For example,
+ # <code>/projects/myProject/global/networks/default</code>. This setting can
+ # be updated, but it cannot be removed after it is set.
+ "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
},
"availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
# <br><code>ZONAL</code>: The instance serves data from only one zone.
@@ -1666,27 +1664,27 @@
# to update this value.
"databaseFlags": [ # The database flags passed to the instance at startup.
{ # Database flags for Cloud SQL instances.
- "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
- # and <code>off</code> for false. This field must be omitted if the flag
- # doesn't take a value.
"name": "A String", # The name of the flag. These flags are passed at instance startup, so
# include both server options and system variables for MySQL. Flags should be
# specified with underscores, not hyphens. For more information, see <a
# href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
# SQL documentation.
+ "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
+ # and <code>off</code> for false. This field must be omitted if the flag
+ # doesn't take a value.
},
],
"maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
# can be restarted for maintenance purposes. Not used for First Generation
# instances.
# preferably be restarted for system maintenance purposes.
+ "hour": 42, # hour of day - 0 to 23.
+ "day": 42, # day of week (1-7), starting on Monday.
+ "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
"updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
# <code>stable</code> (Later). <br /><a
# href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
# Learn more</a>.
- "hour": 42, # hour of day - 0 to 23.
- "day": 42, # day of week (1-7), starting on Monday.
- "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
},
"pricingPlan": "A String", # The pricing plan for this instance. This can be either <code>PER_USE</code>
# or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
@@ -1715,64 +1713,21 @@
"crashSafeReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether
# database flags for crash-safe replication are enabled. This property is
# only applicable to First Generation instances.
- "backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
- "pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
- "startTime": "A String", # Start time for the daily backup configuration in UTC timezone in the 24
- # hour format - <code>HH:MM</code>.
- "kind": "A String", # This is always <code>sql#backupConfiguration</code>.
- "enabled": True or False, # Whether this configuration is enabled.
- "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
- # disabled, binarylog must be disabled as well.
- "replicationLogArchivingEnabled": True or False, # Reserved for future use.
- "location": "A String", # Location of the backup
- },
- "userLabels": { # User-provided labels, represented as a dictionary where each label is a
- # single key value pair.
- "a_key": "A String",
- },
- "locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # The location preference settings. This allows the instance to be located as
- # near as possible to either an App Engine app or Compute Engine zone for
- # better performance. App Engine co-location is only applicable to First
- # Generation instances.
- # preferably be located, either in a specific Compute Engine zone, or
- # co-located with an App Engine application. Note that if the preferred
- # location is not available, the instance will be located as close as possible
- # within the region. Only one location may be specified.
- "followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
- # Cloud SQL instance.
- "kind": "A String", # This is always <code>sql#locationPreference</code>.
- "zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
- # etc.).
- },
- "kind": "A String", # This is always <code>sql#settings</code>.
- "replicationType": "A String", # The type of replication this instance uses. This can be either
- # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
- # only applicable to First Generation instances.
- "activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
- # applicable only when the instance state is <code>RUNNABLE</code>. Valid
- # values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
- # the absence of connection requests. <br><code>NEVER</code>: The instance is
- # off; it is not activated, even if a connection request arrives.
- # <br><code>ON_DEMAND</code>: First Generation instances only. The instance
- # responds to incoming requests, and turns itself off when not in use.
- # Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
- # inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
- # 12 hours of inactivity.
},
"replicaNames": [ # The replicas of the instance.
"A String",
],
"diskEncryptionConfiguration": { # Disk encryption configuration for an instance. # Disk encryption configuration specific to an instance.
# Applies only to Second Generation instances.
- "kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
"kmsKeyName": "A String", # Resource name of KMS key for disk encryption
+ "kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
},
- "rootPassword": "A String", # Initial root password. Use only on creation.
"scheduledMaintenance": { # Any scheduled maintenancce for this instance. # The start time of any upcoming scheduled maintenance for this instance.
"canReschedule": True or False, # If the scheduled maintenance can be rescheduled.
"canDefer": True or False,
"startTime": "A String", # The start time of any upcoming scheduled maintenance for this instance.
},
+ "rootPassword": "A String", # Initial root password. Use only on creation.
"etag": "A String", # This field is deprecated and will be removed from a future version of the
# API. Use the <code>settings.settingsVersion</code> field instead.
"serverCaCert": { # SslCerts Resource # SSL configuration.
@@ -1809,7 +1764,6 @@
# href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
# announcement</a> for details.
"replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to failover replicas and read replicas.
- "kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
"mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises
# master. Replication configuration information such as the username,
# password, certificates, and keys are not stored in the instance metadata.
@@ -1841,32 +1795,78 @@
# the new master instance. <p>Only one replica can be specified as failover
# target, and the replica has to be in different zone with the master
# instance.
+ "kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
},
"connectionName": "A String", # Connection name of the Cloud SQL instance used in connection strings.
"failoverReplica": { # The name and status of the failover replica. This property is applicable
# only to Second Generation instances.
- "available": True or False, # The availability status of the failover replica. A false status indicates
- # that the failover replica is out of sync. The master can only failover to
- # the failover replica when the status is true.
"name": "A String", # The name of the failover replica. If specified at instance creation, a
# failover replica is created for the instance. The name
# doesn't include the project ID. This property is applicable only to
# Second Generation instances.
+ "available": True or False, # The availability status of the failover replica. A false status indicates
+ # that the failover replica is out of sync. The master can only failover to
+ # the failover replica when the status is true.
},
"ipAddresses": [ # The assigned IP addresses for the instance.
{ # Database instance IP Mapping.
- "timeToRetire": "A String", # The due time for this IP to be retired in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>. This field is only available when
- # the IP is scheduled to be retired.
"type": "A String", # The type of this IP address. A <code>PRIMARY</code> address is a public
# address that can accept incoming connections. A <code>PRIVATE</code>
# address is a private address that can accept incoming connections. An
# <code>OUTGOING</code> address is the source address of connections
# originating from the instance, if supported.
"ipAddress": "A String", # The IP address assigned.
+ "timeToRetire": "A String", # The due time for this IP to be retired in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>. This field is only available when
+ # the IP is scheduled to be retired.
},
],
+ "ipv6Address": "A String", # The IPv6 address assigned to the instance. This property is applicable only
+ # to First Generation instances.
+ "selfLink": "A String", # The URI of this resource.
+ "diskEncryptionStatus": { # Disk encryption status for an instance. # Disk encryption status specific to an instance.
+ # Applies only to Second Generation instances.
+ "kmsKeyVersionName": "A String", # KMS key version used to encrypt the Cloud SQL instance resource
+ "kind": "A String", # This is always <code>sql#diskEncryptionStatus</code>.
+ },
+ "kind": "A String", # This is always <code>sql#instance</code>.
+ "region": "A String", # The geographical region. Can be <code>us-central</code>
+ # (<code>FIRST_GEN</code> instances only), <code>us-central1</code>
+ # (<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
+ # <code>europe-west1</code>. Defaults to <code>us-central</code> or
+ # <code>us-central1</code> depending on the instance type (First Generation
+ # or Second Generation). The region can not be changed after instance
+ # creation.
+ "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the
+ # following. <br><code>RUNNABLE</code>: The instance is running, or is ready
+ # to run when accessed. <br><code>SUSPENDED</code>: The instance is not
+ # available, for example due to problems with billing.
+ # <br><code>PENDING_CREATE</code>: The instance is being created.
+ # <br><code>MAINTENANCE</code>: The instance is down for maintenance.
+ # <br><code>FAILED</code>: The instance creation failed.
+ # <br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.
+ "backendType": "A String", # <code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
+ # /><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
+ # instance. <br /><code>EXTERNAL</code>: A database server that is not
+ # managed by Google. <br>This property is read-only; use the
+ # <code>tier</code> property in the <code>settings</code> object to determine
+ # the database type and Second or First Generation.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for connecting to on-premises instance.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
+ "password": "A String", # The password for connecting to on-premises instance.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate.
+ },
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
+ # apps domain is prefixed if applicable.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
+ # is applicable only to Second Generation instances.
}
x__xgafv: string, V1 error format.
@@ -1880,6 +1880,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -1894,15 +1949,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -1910,7 +1966,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -1939,61 +1994,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -2024,54 +2024,8 @@
An object of the form:
{ # Database instances list response.
- "kind": "A String", # This is always <code>sql#instancesList</code>.
"items": [ # List of database instance resources.
{ # A Cloud SQL instance resource.
- "ipv6Address": "A String", # The IPv6 address assigned to the instance. This property is applicable only
- # to First Generation instances.
- "selfLink": "A String", # The URI of this resource.
- "diskEncryptionStatus": { # Disk encryption status for an instance. # Disk encryption status specific to an instance.
- # Applies only to Second Generation instances.
- "kmsKeyVersionName": "A String", # KMS key version used to encrypt the Cloud SQL instance resource
- "kind": "A String", # This is always <code>sql#diskEncryptionStatus</code>.
- },
- "kind": "A String", # This is always <code>sql#instance</code>.
- "region": "A String", # The geographical region. Can be <code>us-central</code>
- # (<code>FIRST_GEN</code> instances only), <code>us-central1</code>
- # (<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
- # <code>europe-west1</code>. Defaults to <code>us-central</code> or
- # <code>us-central1</code> depending on the instance type (First Generation
- # or Second Generation). The region can not be changed after instance
- # creation.
- "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the
- # following. <br><code>RUNNABLE</code>: The instance is running, or is ready
- # to run when accessed. <br><code>SUSPENDED</code>: The instance is not
- # available, for example due to problems with billing.
- # <br><code>PENDING_CREATE</code>: The instance is being created.
- # <br><code>MAINTENANCE</code>: The instance is down for maintenance.
- # <br><code>FAILED</code>: The instance creation failed.
- # <br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.
- "backendType": "A String", # <code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
- # /><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
- # instance. <br /><code>EXTERNAL</code>: A database server that is not
- # managed by Google. <br>This property is read-only; use the
- # <code>tier</code> property in the <code>settings</code> object to determine
- # the database type and Second or First Generation.
- "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
- "hostPort": "A String", # The host and port of the on-premises instance in host:port format
- "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for connecting to on-premises instance.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
- "password": "A String", # The password for connecting to on-premises instance.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate.
- },
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
- # apps domain is prefixed if applicable.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
- # is applicable only to Second Generation instances.
"databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
# field can not be changed after instance creation. MySQL Second Generation
# instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
@@ -2082,29 +2036,72 @@
"A String",
],
"settings": { # Database instance settings. # The user settings.
+ "backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
+ "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
+ # disabled, binarylog must be disabled as well.
+ "replicationLogArchivingEnabled": True or False, # Reserved for future use.
+ "location": "A String", # Location of the backup
+ "pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
+ "startTime": "A String", # Start time for the daily backup configuration in UTC timezone in the 24
+ # hour format - <code>HH:MM</code>.
+ "kind": "A String", # This is always <code>sql#backupConfiguration</code>.
+ "enabled": True or False, # Whether this configuration is enabled.
+ },
+ "userLabels": { # User-provided labels, represented as a dictionary where each label is a
+ # single key value pair.
+ "a_key": "A String",
+ },
+ "locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # The location preference settings. This allows the instance to be located as
+ # near as possible to either an App Engine app or Compute Engine zone for
+ # better performance. App Engine co-location is only applicable to First
+ # Generation instances.
+ # preferably be located, either in a specific Compute Engine zone, or
+ # co-located with an App Engine application. Note that if the preferred
+ # location is not available, the instance will be located as close as possible
+ # within the region. Only one location may be specified.
+ "kind": "A String", # This is always <code>sql#locationPreference</code>.
+ "zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
+ # etc.).
+ "followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
+ # Cloud SQL instance.
+ },
+ "kind": "A String", # This is always <code>sql#settings</code>.
+ "replicationType": "A String", # The type of replication this instance uses. This can be either
+ # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
+ # only applicable to First Generation instances.
+ "activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
+ # applicable only when the instance state is <code>RUNNABLE</code>. Valid
+ # values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
+ # the absence of connection requests. <br><code>NEVER</code>: The instance is
+ # off; it is not activated, even if a connection request arrives.
+ # <br><code>ON_DEMAND</code>: First Generation instances only. The instance
+ # responds to incoming requests, and turns itself off when not in use.
+ # Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
+ # inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
+ # 12 hours of inactivity.
"ipConfiguration": { # IP Management configuration. # The settings for IP Management. This allows to enable or disable the
# instance IP and manage which external networks can connect to the instance.
# The IPv4 address cannot be disabled for Second Generation instances.
- "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
- # accessible for private IP. For example,
- # <code>/projects/myProject/global/networks/default</code>. This setting can
- # be updated, but it cannot be removed after it is set.
- "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
"authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
# using the IP. In <a
# href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
# notation</a>, also known as 'slash' notation (e.g.
# <code>192.168.100.0/24</code>).
{ # An entry for an Access Control list.
+ "kind": "A String", # This is always <code>sql#aclEntry</code>.
"value": "A String", # The whitelisted value for the access control list.
"expirationTime": "A String", # The time when this access control entry expires in <a
# href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
# <code>2012-11-15T16:19:00.094Z</code>.
"name": "A String", # Optional. A label to identify this entry.
- "kind": "A String", # This is always <code>sql#aclEntry</code>.
},
],
"requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
+ "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
+ # accessible for private IP. For example,
+ # <code>/projects/myProject/global/networks/default</code>. This setting can
+ # be updated, but it cannot be removed after it is set.
+ "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
},
"availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
# <br><code>ZONAL</code>: The instance serves data from only one zone.
@@ -2119,27 +2116,27 @@
# to update this value.
"databaseFlags": [ # The database flags passed to the instance at startup.
{ # Database flags for Cloud SQL instances.
- "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
- # and <code>off</code> for false. This field must be omitted if the flag
- # doesn't take a value.
"name": "A String", # The name of the flag. These flags are passed at instance startup, so
# include both server options and system variables for MySQL. Flags should be
# specified with underscores, not hyphens. For more information, see <a
# href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
# SQL documentation.
+ "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
+ # and <code>off</code> for false. This field must be omitted if the flag
+ # doesn't take a value.
},
],
"maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
# can be restarted for maintenance purposes. Not used for First Generation
# instances.
# preferably be restarted for system maintenance purposes.
+ "hour": 42, # hour of day - 0 to 23.
+ "day": 42, # day of week (1-7), starting on Monday.
+ "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
"updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
# <code>stable</code> (Later). <br /><a
# href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
# Learn more</a>.
- "hour": 42, # hour of day - 0 to 23.
- "day": 42, # day of week (1-7), starting on Monday.
- "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
},
"pricingPlan": "A String", # The pricing plan for this instance. This can be either <code>PER_USE</code>
# or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
@@ -2168,64 +2165,21 @@
"crashSafeReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether
# database flags for crash-safe replication are enabled. This property is
# only applicable to First Generation instances.
- "backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
- "pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
- "startTime": "A String", # Start time for the daily backup configuration in UTC timezone in the 24
- # hour format - <code>HH:MM</code>.
- "kind": "A String", # This is always <code>sql#backupConfiguration</code>.
- "enabled": True or False, # Whether this configuration is enabled.
- "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
- # disabled, binarylog must be disabled as well.
- "replicationLogArchivingEnabled": True or False, # Reserved for future use.
- "location": "A String", # Location of the backup
- },
- "userLabels": { # User-provided labels, represented as a dictionary where each label is a
- # single key value pair.
- "a_key": "A String",
- },
- "locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # The location preference settings. This allows the instance to be located as
- # near as possible to either an App Engine app or Compute Engine zone for
- # better performance. App Engine co-location is only applicable to First
- # Generation instances.
- # preferably be located, either in a specific Compute Engine zone, or
- # co-located with an App Engine application. Note that if the preferred
- # location is not available, the instance will be located as close as possible
- # within the region. Only one location may be specified.
- "followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
- # Cloud SQL instance.
- "kind": "A String", # This is always <code>sql#locationPreference</code>.
- "zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
- # etc.).
- },
- "kind": "A String", # This is always <code>sql#settings</code>.
- "replicationType": "A String", # The type of replication this instance uses. This can be either
- # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
- # only applicable to First Generation instances.
- "activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
- # applicable only when the instance state is <code>RUNNABLE</code>. Valid
- # values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
- # the absence of connection requests. <br><code>NEVER</code>: The instance is
- # off; it is not activated, even if a connection request arrives.
- # <br><code>ON_DEMAND</code>: First Generation instances only. The instance
- # responds to incoming requests, and turns itself off when not in use.
- # Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
- # inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
- # 12 hours of inactivity.
},
"replicaNames": [ # The replicas of the instance.
"A String",
],
"diskEncryptionConfiguration": { # Disk encryption configuration for an instance. # Disk encryption configuration specific to an instance.
# Applies only to Second Generation instances.
- "kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
"kmsKeyName": "A String", # Resource name of KMS key for disk encryption
+ "kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
},
- "rootPassword": "A String", # Initial root password. Use only on creation.
"scheduledMaintenance": { # Any scheduled maintenancce for this instance. # The start time of any upcoming scheduled maintenance for this instance.
"canReschedule": True or False, # If the scheduled maintenance can be rescheduled.
"canDefer": True or False,
"startTime": "A String", # The start time of any upcoming scheduled maintenance for this instance.
},
+ "rootPassword": "A String", # Initial root password. Use only on creation.
"etag": "A String", # This field is deprecated and will be removed from a future version of the
# API. Use the <code>settings.settingsVersion</code> field instead.
"serverCaCert": { # SslCerts Resource # SSL configuration.
@@ -2262,7 +2216,6 @@
# href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
# announcement</a> for details.
"replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to failover replicas and read replicas.
- "kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
"mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises
# master. Replication configuration information such as the username,
# password, certificates, and keys are not stored in the instance metadata.
@@ -2294,32 +2247,78 @@
# the new master instance. <p>Only one replica can be specified as failover
# target, and the replica has to be in different zone with the master
# instance.
+ "kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
},
"connectionName": "A String", # Connection name of the Cloud SQL instance used in connection strings.
"failoverReplica": { # The name and status of the failover replica. This property is applicable
# only to Second Generation instances.
- "available": True or False, # The availability status of the failover replica. A false status indicates
- # that the failover replica is out of sync. The master can only failover to
- # the failover replica when the status is true.
"name": "A String", # The name of the failover replica. If specified at instance creation, a
# failover replica is created for the instance. The name
# doesn't include the project ID. This property is applicable only to
# Second Generation instances.
+ "available": True or False, # The availability status of the failover replica. A false status indicates
+ # that the failover replica is out of sync. The master can only failover to
+ # the failover replica when the status is true.
},
"ipAddresses": [ # The assigned IP addresses for the instance.
{ # Database instance IP Mapping.
- "timeToRetire": "A String", # The due time for this IP to be retired in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>. This field is only available when
- # the IP is scheduled to be retired.
"type": "A String", # The type of this IP address. A <code>PRIMARY</code> address is a public
# address that can accept incoming connections. A <code>PRIVATE</code>
# address is a private address that can accept incoming connections. An
# <code>OUTGOING</code> address is the source address of connections
# originating from the instance, if supported.
"ipAddress": "A String", # The IP address assigned.
+ "timeToRetire": "A String", # The due time for this IP to be retired in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>. This field is only available when
+ # the IP is scheduled to be retired.
},
],
+ "ipv6Address": "A String", # The IPv6 address assigned to the instance. This property is applicable only
+ # to First Generation instances.
+ "selfLink": "A String", # The URI of this resource.
+ "diskEncryptionStatus": { # Disk encryption status for an instance. # Disk encryption status specific to an instance.
+ # Applies only to Second Generation instances.
+ "kmsKeyVersionName": "A String", # KMS key version used to encrypt the Cloud SQL instance resource
+ "kind": "A String", # This is always <code>sql#diskEncryptionStatus</code>.
+ },
+ "kind": "A String", # This is always <code>sql#instance</code>.
+ "region": "A String", # The geographical region. Can be <code>us-central</code>
+ # (<code>FIRST_GEN</code> instances only), <code>us-central1</code>
+ # (<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
+ # <code>europe-west1</code>. Defaults to <code>us-central</code> or
+ # <code>us-central1</code> depending on the instance type (First Generation
+ # or Second Generation). The region can not be changed after instance
+ # creation.
+ "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the
+ # following. <br><code>RUNNABLE</code>: The instance is running, or is ready
+ # to run when accessed. <br><code>SUSPENDED</code>: The instance is not
+ # available, for example due to problems with billing.
+ # <br><code>PENDING_CREATE</code>: The instance is being created.
+ # <br><code>MAINTENANCE</code>: The instance is down for maintenance.
+ # <br><code>FAILED</code>: The instance creation failed.
+ # <br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.
+ "backendType": "A String", # <code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
+ # /><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
+ # instance. <br /><code>EXTERNAL</code>: A database server that is not
+ # managed by Google. <br>This property is read-only; use the
+ # <code>tier</code> property in the <code>settings</code> object to determine
+ # the database type and Second or First Generation.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for connecting to on-premises instance.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
+ "password": "A String", # The password for connecting to on-premises instance.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate.
+ },
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
+ # apps domain is prefixed if applicable.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
+ # is applicable only to Second Generation instances.
},
],
"warnings": [ # List of warnings that occurred while handling the request.
@@ -2330,6 +2329,7 @@
],
"nextPageToken": "A String", # The continuation token, used to page through large result sets. Provide
# this value in a subsequent request to return the next page of results.
+ "kind": "A String", # This is always <code>sql#instancesList</code>.
}</pre>
</div>
@@ -2401,51 +2401,6 @@
The object takes the form of:
{ # A Cloud SQL instance resource.
- "ipv6Address": "A String", # The IPv6 address assigned to the instance. This property is applicable only
- # to First Generation instances.
- "selfLink": "A String", # The URI of this resource.
- "diskEncryptionStatus": { # Disk encryption status for an instance. # Disk encryption status specific to an instance.
- # Applies only to Second Generation instances.
- "kmsKeyVersionName": "A String", # KMS key version used to encrypt the Cloud SQL instance resource
- "kind": "A String", # This is always <code>sql#diskEncryptionStatus</code>.
- },
- "kind": "A String", # This is always <code>sql#instance</code>.
- "region": "A String", # The geographical region. Can be <code>us-central</code>
- # (<code>FIRST_GEN</code> instances only), <code>us-central1</code>
- # (<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
- # <code>europe-west1</code>. Defaults to <code>us-central</code> or
- # <code>us-central1</code> depending on the instance type (First Generation
- # or Second Generation). The region can not be changed after instance
- # creation.
- "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the
- # following. <br><code>RUNNABLE</code>: The instance is running, or is ready
- # to run when accessed. <br><code>SUSPENDED</code>: The instance is not
- # available, for example due to problems with billing.
- # <br><code>PENDING_CREATE</code>: The instance is being created.
- # <br><code>MAINTENANCE</code>: The instance is down for maintenance.
- # <br><code>FAILED</code>: The instance creation failed.
- # <br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.
- "backendType": "A String", # <code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
- # /><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
- # instance. <br /><code>EXTERNAL</code>: A database server that is not
- # managed by Google. <br>This property is read-only; use the
- # <code>tier</code> property in the <code>settings</code> object to determine
- # the database type and Second or First Generation.
- "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
- "hostPort": "A String", # The host and port of the on-premises instance in host:port format
- "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for connecting to on-premises instance.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
- "password": "A String", # The password for connecting to on-premises instance.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate.
- },
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
- # apps domain is prefixed if applicable.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
- # is applicable only to Second Generation instances.
"databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
# field can not be changed after instance creation. MySQL Second Generation
# instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
@@ -2456,29 +2411,72 @@
"A String",
],
"settings": { # Database instance settings. # The user settings.
+ "backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
+ "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
+ # disabled, binarylog must be disabled as well.
+ "replicationLogArchivingEnabled": True or False, # Reserved for future use.
+ "location": "A String", # Location of the backup
+ "pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
+ "startTime": "A String", # Start time for the daily backup configuration in UTC timezone in the 24
+ # hour format - <code>HH:MM</code>.
+ "kind": "A String", # This is always <code>sql#backupConfiguration</code>.
+ "enabled": True or False, # Whether this configuration is enabled.
+ },
+ "userLabels": { # User-provided labels, represented as a dictionary where each label is a
+ # single key value pair.
+ "a_key": "A String",
+ },
+ "locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # The location preference settings. This allows the instance to be located as
+ # near as possible to either an App Engine app or Compute Engine zone for
+ # better performance. App Engine co-location is only applicable to First
+ # Generation instances.
+ # preferably be located, either in a specific Compute Engine zone, or
+ # co-located with an App Engine application. Note that if the preferred
+ # location is not available, the instance will be located as close as possible
+ # within the region. Only one location may be specified.
+ "kind": "A String", # This is always <code>sql#locationPreference</code>.
+ "zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
+ # etc.).
+ "followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
+ # Cloud SQL instance.
+ },
+ "kind": "A String", # This is always <code>sql#settings</code>.
+ "replicationType": "A String", # The type of replication this instance uses. This can be either
+ # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
+ # only applicable to First Generation instances.
+ "activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
+ # applicable only when the instance state is <code>RUNNABLE</code>. Valid
+ # values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
+ # the absence of connection requests. <br><code>NEVER</code>: The instance is
+ # off; it is not activated, even if a connection request arrives.
+ # <br><code>ON_DEMAND</code>: First Generation instances only. The instance
+ # responds to incoming requests, and turns itself off when not in use.
+ # Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
+ # inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
+ # 12 hours of inactivity.
"ipConfiguration": { # IP Management configuration. # The settings for IP Management. This allows to enable or disable the
# instance IP and manage which external networks can connect to the instance.
# The IPv4 address cannot be disabled for Second Generation instances.
- "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
- # accessible for private IP. For example,
- # <code>/projects/myProject/global/networks/default</code>. This setting can
- # be updated, but it cannot be removed after it is set.
- "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
"authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
# using the IP. In <a
# href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
# notation</a>, also known as 'slash' notation (e.g.
# <code>192.168.100.0/24</code>).
{ # An entry for an Access Control list.
+ "kind": "A String", # This is always <code>sql#aclEntry</code>.
"value": "A String", # The whitelisted value for the access control list.
"expirationTime": "A String", # The time when this access control entry expires in <a
# href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
# <code>2012-11-15T16:19:00.094Z</code>.
"name": "A String", # Optional. A label to identify this entry.
- "kind": "A String", # This is always <code>sql#aclEntry</code>.
},
],
"requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
+ "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
+ # accessible for private IP. For example,
+ # <code>/projects/myProject/global/networks/default</code>. This setting can
+ # be updated, but it cannot be removed after it is set.
+ "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
},
"availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
# <br><code>ZONAL</code>: The instance serves data from only one zone.
@@ -2493,27 +2491,27 @@
# to update this value.
"databaseFlags": [ # The database flags passed to the instance at startup.
{ # Database flags for Cloud SQL instances.
- "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
- # and <code>off</code> for false. This field must be omitted if the flag
- # doesn't take a value.
"name": "A String", # The name of the flag. These flags are passed at instance startup, so
# include both server options and system variables for MySQL. Flags should be
# specified with underscores, not hyphens. For more information, see <a
# href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
# SQL documentation.
+ "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
+ # and <code>off</code> for false. This field must be omitted if the flag
+ # doesn't take a value.
},
],
"maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
# can be restarted for maintenance purposes. Not used for First Generation
# instances.
# preferably be restarted for system maintenance purposes.
+ "hour": 42, # hour of day - 0 to 23.
+ "day": 42, # day of week (1-7), starting on Monday.
+ "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
"updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
# <code>stable</code> (Later). <br /><a
# href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
# Learn more</a>.
- "hour": 42, # hour of day - 0 to 23.
- "day": 42, # day of week (1-7), starting on Monday.
- "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
},
"pricingPlan": "A String", # The pricing plan for this instance. This can be either <code>PER_USE</code>
# or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
@@ -2542,64 +2540,21 @@
"crashSafeReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether
# database flags for crash-safe replication are enabled. This property is
# only applicable to First Generation instances.
- "backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
- "pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
- "startTime": "A String", # Start time for the daily backup configuration in UTC timezone in the 24
- # hour format - <code>HH:MM</code>.
- "kind": "A String", # This is always <code>sql#backupConfiguration</code>.
- "enabled": True or False, # Whether this configuration is enabled.
- "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
- # disabled, binarylog must be disabled as well.
- "replicationLogArchivingEnabled": True or False, # Reserved for future use.
- "location": "A String", # Location of the backup
- },
- "userLabels": { # User-provided labels, represented as a dictionary where each label is a
- # single key value pair.
- "a_key": "A String",
- },
- "locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # The location preference settings. This allows the instance to be located as
- # near as possible to either an App Engine app or Compute Engine zone for
- # better performance. App Engine co-location is only applicable to First
- # Generation instances.
- # preferably be located, either in a specific Compute Engine zone, or
- # co-located with an App Engine application. Note that if the preferred
- # location is not available, the instance will be located as close as possible
- # within the region. Only one location may be specified.
- "followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
- # Cloud SQL instance.
- "kind": "A String", # This is always <code>sql#locationPreference</code>.
- "zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
- # etc.).
- },
- "kind": "A String", # This is always <code>sql#settings</code>.
- "replicationType": "A String", # The type of replication this instance uses. This can be either
- # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
- # only applicable to First Generation instances.
- "activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
- # applicable only when the instance state is <code>RUNNABLE</code>. Valid
- # values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
- # the absence of connection requests. <br><code>NEVER</code>: The instance is
- # off; it is not activated, even if a connection request arrives.
- # <br><code>ON_DEMAND</code>: First Generation instances only. The instance
- # responds to incoming requests, and turns itself off when not in use.
- # Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
- # inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
- # 12 hours of inactivity.
},
"replicaNames": [ # The replicas of the instance.
"A String",
],
"diskEncryptionConfiguration": { # Disk encryption configuration for an instance. # Disk encryption configuration specific to an instance.
# Applies only to Second Generation instances.
- "kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
"kmsKeyName": "A String", # Resource name of KMS key for disk encryption
+ "kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
},
- "rootPassword": "A String", # Initial root password. Use only on creation.
"scheduledMaintenance": { # Any scheduled maintenancce for this instance. # The start time of any upcoming scheduled maintenance for this instance.
"canReschedule": True or False, # If the scheduled maintenance can be rescheduled.
"canDefer": True or False,
"startTime": "A String", # The start time of any upcoming scheduled maintenance for this instance.
},
+ "rootPassword": "A String", # Initial root password. Use only on creation.
"etag": "A String", # This field is deprecated and will be removed from a future version of the
# API. Use the <code>settings.settingsVersion</code> field instead.
"serverCaCert": { # SslCerts Resource # SSL configuration.
@@ -2636,7 +2591,6 @@
# href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
# announcement</a> for details.
"replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to failover replicas and read replicas.
- "kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
"mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises
# master. Replication configuration information such as the username,
# password, certificates, and keys are not stored in the instance metadata.
@@ -2668,32 +2622,78 @@
# the new master instance. <p>Only one replica can be specified as failover
# target, and the replica has to be in different zone with the master
# instance.
+ "kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
},
"connectionName": "A String", # Connection name of the Cloud SQL instance used in connection strings.
"failoverReplica": { # The name and status of the failover replica. This property is applicable
# only to Second Generation instances.
- "available": True or False, # The availability status of the failover replica. A false status indicates
- # that the failover replica is out of sync. The master can only failover to
- # the failover replica when the status is true.
"name": "A String", # The name of the failover replica. If specified at instance creation, a
# failover replica is created for the instance. The name
# doesn't include the project ID. This property is applicable only to
# Second Generation instances.
+ "available": True or False, # The availability status of the failover replica. A false status indicates
+ # that the failover replica is out of sync. The master can only failover to
+ # the failover replica when the status is true.
},
"ipAddresses": [ # The assigned IP addresses for the instance.
{ # Database instance IP Mapping.
- "timeToRetire": "A String", # The due time for this IP to be retired in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>. This field is only available when
- # the IP is scheduled to be retired.
"type": "A String", # The type of this IP address. A <code>PRIMARY</code> address is a public
# address that can accept incoming connections. A <code>PRIVATE</code>
# address is a private address that can accept incoming connections. An
# <code>OUTGOING</code> address is the source address of connections
# originating from the instance, if supported.
"ipAddress": "A String", # The IP address assigned.
+ "timeToRetire": "A String", # The due time for this IP to be retired in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>. This field is only available when
+ # the IP is scheduled to be retired.
},
],
+ "ipv6Address": "A String", # The IPv6 address assigned to the instance. This property is applicable only
+ # to First Generation instances.
+ "selfLink": "A String", # The URI of this resource.
+ "diskEncryptionStatus": { # Disk encryption status for an instance. # Disk encryption status specific to an instance.
+ # Applies only to Second Generation instances.
+ "kmsKeyVersionName": "A String", # KMS key version used to encrypt the Cloud SQL instance resource
+ "kind": "A String", # This is always <code>sql#diskEncryptionStatus</code>.
+ },
+ "kind": "A String", # This is always <code>sql#instance</code>.
+ "region": "A String", # The geographical region. Can be <code>us-central</code>
+ # (<code>FIRST_GEN</code> instances only), <code>us-central1</code>
+ # (<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
+ # <code>europe-west1</code>. Defaults to <code>us-central</code> or
+ # <code>us-central1</code> depending on the instance type (First Generation
+ # or Second Generation). The region can not be changed after instance
+ # creation.
+ "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the
+ # following. <br><code>RUNNABLE</code>: The instance is running, or is ready
+ # to run when accessed. <br><code>SUSPENDED</code>: The instance is not
+ # available, for example due to problems with billing.
+ # <br><code>PENDING_CREATE</code>: The instance is being created.
+ # <br><code>MAINTENANCE</code>: The instance is down for maintenance.
+ # <br><code>FAILED</code>: The instance creation failed.
+ # <br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.
+ "backendType": "A String", # <code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
+ # /><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
+ # instance. <br /><code>EXTERNAL</code>: A database server that is not
+ # managed by Google. <br>This property is read-only; use the
+ # <code>tier</code> property in the <code>settings</code> object to determine
+ # the database type and Second or First Generation.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for connecting to on-premises instance.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
+ "password": "A String", # The password for connecting to on-premises instance.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate.
+ },
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
+ # apps domain is prefixed if applicable.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
+ # is applicable only to Second Generation instances.
}
x__xgafv: string, V1 error format.
@@ -2707,6 +2707,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -2721,15 +2776,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -2737,7 +2793,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -2766,61 +2821,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -2843,6 +2843,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -2857,15 +2912,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -2873,7 +2929,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -2902,61 +2957,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -2979,6 +2979,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -2993,15 +3048,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -3009,7 +3065,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3038,61 +3093,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -3114,6 +3114,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -3128,15 +3183,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -3144,7 +3200,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3173,61 +3228,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -3263,6 +3263,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -3277,15 +3332,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -3293,7 +3349,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3322,61 +3377,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -3410,6 +3410,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -3424,15 +3479,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -3440,7 +3496,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3469,61 +3524,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -3545,6 +3545,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -3559,15 +3614,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -3575,7 +3631,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3604,61 +3659,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -3680,6 +3680,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -3694,15 +3749,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -3710,7 +3766,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3739,61 +3794,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -3826,6 +3826,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -3840,15 +3895,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -3856,7 +3912,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -3885,61 +3940,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>
@@ -3955,51 +3955,6 @@
The object takes the form of:
{ # A Cloud SQL instance resource.
- "ipv6Address": "A String", # The IPv6 address assigned to the instance. This property is applicable only
- # to First Generation instances.
- "selfLink": "A String", # The URI of this resource.
- "diskEncryptionStatus": { # Disk encryption status for an instance. # Disk encryption status specific to an instance.
- # Applies only to Second Generation instances.
- "kmsKeyVersionName": "A String", # KMS key version used to encrypt the Cloud SQL instance resource
- "kind": "A String", # This is always <code>sql#diskEncryptionStatus</code>.
- },
- "kind": "A String", # This is always <code>sql#instance</code>.
- "region": "A String", # The geographical region. Can be <code>us-central</code>
- # (<code>FIRST_GEN</code> instances only), <code>us-central1</code>
- # (<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
- # <code>europe-west1</code>. Defaults to <code>us-central</code> or
- # <code>us-central1</code> depending on the instance type (First Generation
- # or Second Generation). The region can not be changed after instance
- # creation.
- "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the
- # following. <br><code>RUNNABLE</code>: The instance is running, or is ready
- # to run when accessed. <br><code>SUSPENDED</code>: The instance is not
- # available, for example due to problems with billing.
- # <br><code>PENDING_CREATE</code>: The instance is being created.
- # <br><code>MAINTENANCE</code>: The instance is down for maintenance.
- # <br><code>FAILED</code>: The instance creation failed.
- # <br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.
- "backendType": "A String", # <code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
- # /><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
- # instance. <br /><code>EXTERNAL</code>: A database server that is not
- # managed by Google. <br>This property is read-only; use the
- # <code>tier</code> property in the <code>settings</code> object to determine
- # the database type and Second or First Generation.
- "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
- "hostPort": "A String", # The host and port of the on-premises instance in host:port format
- "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
- "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
- "username": "A String", # The username for connecting to on-premises instance.
- "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
- "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
- "password": "A String", # The password for connecting to on-premises instance.
- "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
- # is encoded in the client's certificate.
- },
- "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
- # apps domain is prefixed if applicable.
- "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
- # is applicable only to Second Generation instances.
"databaseVersion": "A String", # The database engine type and version. The <code>databaseVersion</code>
# field can not be changed after instance creation. MySQL Second Generation
# instances: <code>MYSQL_5_7</code> (default) or <code>MYSQL_5_6</code>.
@@ -4010,29 +3965,72 @@
"A String",
],
"settings": { # Database instance settings. # The user settings.
+ "backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
+ "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
+ # disabled, binarylog must be disabled as well.
+ "replicationLogArchivingEnabled": True or False, # Reserved for future use.
+ "location": "A String", # Location of the backup
+ "pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
+ "startTime": "A String", # Start time for the daily backup configuration in UTC timezone in the 24
+ # hour format - <code>HH:MM</code>.
+ "kind": "A String", # This is always <code>sql#backupConfiguration</code>.
+ "enabled": True or False, # Whether this configuration is enabled.
+ },
+ "userLabels": { # User-provided labels, represented as a dictionary where each label is a
+ # single key value pair.
+ "a_key": "A String",
+ },
+ "locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # The location preference settings. This allows the instance to be located as
+ # near as possible to either an App Engine app or Compute Engine zone for
+ # better performance. App Engine co-location is only applicable to First
+ # Generation instances.
+ # preferably be located, either in a specific Compute Engine zone, or
+ # co-located with an App Engine application. Note that if the preferred
+ # location is not available, the instance will be located as close as possible
+ # within the region. Only one location may be specified.
+ "kind": "A String", # This is always <code>sql#locationPreference</code>.
+ "zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
+ # etc.).
+ "followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
+ # Cloud SQL instance.
+ },
+ "kind": "A String", # This is always <code>sql#settings</code>.
+ "replicationType": "A String", # The type of replication this instance uses. This can be either
+ # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
+ # only applicable to First Generation instances.
+ "activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
+ # applicable only when the instance state is <code>RUNNABLE</code>. Valid
+ # values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
+ # the absence of connection requests. <br><code>NEVER</code>: The instance is
+ # off; it is not activated, even if a connection request arrives.
+ # <br><code>ON_DEMAND</code>: First Generation instances only. The instance
+ # responds to incoming requests, and turns itself off when not in use.
+ # Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
+ # inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
+ # 12 hours of inactivity.
"ipConfiguration": { # IP Management configuration. # The settings for IP Management. This allows to enable or disable the
# instance IP and manage which external networks can connect to the instance.
# The IPv4 address cannot be disabled for Second Generation instances.
- "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
- # accessible for private IP. For example,
- # <code>/projects/myProject/global/networks/default</code>. This setting can
- # be updated, but it cannot be removed after it is set.
- "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
"authorizedNetworks": [ # The list of external networks that are allowed to connect to the instance
# using the IP. In <a
# href="http://en.wikipedia.org/wiki/CIDR_notation#CIDR_notation">CIDR
# notation</a>, also known as 'slash' notation (e.g.
# <code>192.168.100.0/24</code>).
{ # An entry for an Access Control list.
+ "kind": "A String", # This is always <code>sql#aclEntry</code>.
"value": "A String", # The whitelisted value for the access control list.
"expirationTime": "A String", # The time when this access control entry expires in <a
# href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
# <code>2012-11-15T16:19:00.094Z</code>.
"name": "A String", # Optional. A label to identify this entry.
- "kind": "A String", # This is always <code>sql#aclEntry</code>.
},
],
"requireSsl": True or False, # Whether SSL connections over IP should be enforced or not.
+ "privateNetwork": "A String", # The resource link for the VPC network from which the Cloud SQL instance is
+ # accessible for private IP. For example,
+ # <code>/projects/myProject/global/networks/default</code>. This setting can
+ # be updated, but it cannot be removed after it is set.
+ "ipv4Enabled": True or False, # Whether the instance should be assigned an IP address or not.
},
"availabilityType": "A String", # Availability type (PostgreSQL and MySQL instances only). Potential values:
# <br><code>ZONAL</code>: The instance serves data from only one zone.
@@ -4047,27 +4045,27 @@
# to update this value.
"databaseFlags": [ # The database flags passed to the instance at startup.
{ # Database flags for Cloud SQL instances.
- "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
- # and <code>off</code> for false. This field must be omitted if the flag
- # doesn't take a value.
"name": "A String", # The name of the flag. These flags are passed at instance startup, so
# include both server options and system variables for MySQL. Flags should be
# specified with underscores, not hyphens. For more information, see <a
# href="/sql/docs/mysql/flags">Configuring Database Flags</a> in the Cloud
# SQL documentation.
+ "value": "A String", # The value of the flag. Booleans should be set to <code>on</code> for true
+ # and <code>off</code> for false. This field must be omitted if the flag
+ # doesn't take a value.
},
],
"maintenanceWindow": { # Maintenance window. This specifies when a v2 Cloud SQL instance should # The maintenance window for this instance. This specifies when the instance
# can be restarted for maintenance purposes. Not used for First Generation
# instances.
# preferably be restarted for system maintenance purposes.
+ "hour": 42, # hour of day - 0 to 23.
+ "day": 42, # day of week (1-7), starting on Monday.
+ "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
"updateTrack": "A String", # Maintenance timing setting: <code>canary</code> (Earlier) or
# <code>stable</code> (Later). <br /><a
# href="/sql/docs/db_path/instance-settings#maintenance-timing-2ndgen">
# Learn more</a>.
- "hour": 42, # hour of day - 0 to 23.
- "day": 42, # day of week (1-7), starting on Monday.
- "kind": "A String", # This is always <code>sql#maintenanceWindow</code>.
},
"pricingPlan": "A String", # The pricing plan for this instance. This can be either <code>PER_USE</code>
# or <code>PACKAGE</code>. Only <code>PER_USE</code> is supported for Second
@@ -4096,64 +4094,21 @@
"crashSafeReplicationEnabled": True or False, # Configuration specific to read replica instances. Indicates whether
# database flags for crash-safe replication are enabled. This property is
# only applicable to First Generation instances.
- "backupConfiguration": { # Database instance backup configuration. # The daily backup configuration for the instance.
- "pointInTimeRecoveryEnabled": True or False, # Reserved for future use.
- "startTime": "A String", # Start time for the daily backup configuration in UTC timezone in the 24
- # hour format - <code>HH:MM</code>.
- "kind": "A String", # This is always <code>sql#backupConfiguration</code>.
- "enabled": True or False, # Whether this configuration is enabled.
- "binaryLogEnabled": True or False, # (MySQL only) Whether binary log is enabled. If backup configuration is
- # disabled, binarylog must be disabled as well.
- "replicationLogArchivingEnabled": True or False, # Reserved for future use.
- "location": "A String", # Location of the backup
- },
- "userLabels": { # User-provided labels, represented as a dictionary where each label is a
- # single key value pair.
- "a_key": "A String",
- },
- "locationPreference": { # Preferred location. This specifies where a Cloud SQL instance should # The location preference settings. This allows the instance to be located as
- # near as possible to either an App Engine app or Compute Engine zone for
- # better performance. App Engine co-location is only applicable to First
- # Generation instances.
- # preferably be located, either in a specific Compute Engine zone, or
- # co-located with an App Engine application. Note that if the preferred
- # location is not available, the instance will be located as close as possible
- # within the region. Only one location may be specified.
- "followGaeApplication": "A String", # The AppEngine application to follow, it must be in the same region as the
- # Cloud SQL instance.
- "kind": "A String", # This is always <code>sql#locationPreference</code>.
- "zone": "A String", # The preferred Compute Engine zone (e.g. us-central1-a, us-central1-b,
- # etc.).
- },
- "kind": "A String", # This is always <code>sql#settings</code>.
- "replicationType": "A String", # The type of replication this instance uses. This can be either
- # <code>ASYNCHRONOUS</code> or <code>SYNCHRONOUS</code>. This property is
- # only applicable to First Generation instances.
- "activationPolicy": "A String", # The activation policy specifies when the instance is activated; it is
- # applicable only when the instance state is <code>RUNNABLE</code>. Valid
- # values: <br><code>ALWAYS</code>: The instance is on, and remains so even in
- # the absence of connection requests. <br><code>NEVER</code>: The instance is
- # off; it is not activated, even if a connection request arrives.
- # <br><code>ON_DEMAND</code>: First Generation instances only. The instance
- # responds to incoming requests, and turns itself off when not in use.
- # Instances with <code>PER_USE</code> pricing turn off after 15 minutes of
- # inactivity. Instances with <code>PER_PACKAGE</code> pricing turn off after
- # 12 hours of inactivity.
},
"replicaNames": [ # The replicas of the instance.
"A String",
],
"diskEncryptionConfiguration": { # Disk encryption configuration for an instance. # Disk encryption configuration specific to an instance.
# Applies only to Second Generation instances.
- "kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
"kmsKeyName": "A String", # Resource name of KMS key for disk encryption
+ "kind": "A String", # This is always <code>sql#diskEncryptionConfiguration</code>.
},
- "rootPassword": "A String", # Initial root password. Use only on creation.
"scheduledMaintenance": { # Any scheduled maintenancce for this instance. # The start time of any upcoming scheduled maintenance for this instance.
"canReschedule": True or False, # If the scheduled maintenance can be rescheduled.
"canDefer": True or False,
"startTime": "A String", # The start time of any upcoming scheduled maintenance for this instance.
},
+ "rootPassword": "A String", # Initial root password. Use only on creation.
"etag": "A String", # This field is deprecated and will be removed from a future version of the
# API. Use the <code>settings.settingsVersion</code> field instead.
"serverCaCert": { # SslCerts Resource # SSL configuration.
@@ -4190,7 +4145,6 @@
# href="https://groups.google.com/d/msg/google-cloud-sql-announce/I_7-F9EBhT0/BtvFtdFeAgAJ">this
# announcement</a> for details.
"replicaConfiguration": { # Read-replica configuration for connecting to the master. # Configuration specific to failover replicas and read replicas.
- "kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
"mysqlReplicaConfiguration": { # Read-replica configuration specific to MySQL databases. # MySQL specific configuration when replicating from a MySQL on-premises
# master. Replication configuration information such as the username,
# password, certificates, and keys are not stored in the instance metadata.
@@ -4222,32 +4176,78 @@
# the new master instance. <p>Only one replica can be specified as failover
# target, and the replica has to be in different zone with the master
# instance.
+ "kind": "A String", # This is always <code>sql#replicaConfiguration</code>.
},
"connectionName": "A String", # Connection name of the Cloud SQL instance used in connection strings.
"failoverReplica": { # The name and status of the failover replica. This property is applicable
# only to Second Generation instances.
- "available": True or False, # The availability status of the failover replica. A false status indicates
- # that the failover replica is out of sync. The master can only failover to
- # the failover replica when the status is true.
"name": "A String", # The name of the failover replica. If specified at instance creation, a
# failover replica is created for the instance. The name
# doesn't include the project ID. This property is applicable only to
# Second Generation instances.
+ "available": True or False, # The availability status of the failover replica. A false status indicates
+ # that the failover replica is out of sync. The master can only failover to
+ # the failover replica when the status is true.
},
"ipAddresses": [ # The assigned IP addresses for the instance.
{ # Database instance IP Mapping.
- "timeToRetire": "A String", # The due time for this IP to be retired in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>. This field is only available when
- # the IP is scheduled to be retired.
"type": "A String", # The type of this IP address. A <code>PRIMARY</code> address is a public
# address that can accept incoming connections. A <code>PRIVATE</code>
# address is a private address that can accept incoming connections. An
# <code>OUTGOING</code> address is the source address of connections
# originating from the instance, if supported.
"ipAddress": "A String", # The IP address assigned.
+ "timeToRetire": "A String", # The due time for this IP to be retired in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>. This field is only available when
+ # the IP is scheduled to be retired.
},
],
+ "ipv6Address": "A String", # The IPv6 address assigned to the instance. This property is applicable only
+ # to First Generation instances.
+ "selfLink": "A String", # The URI of this resource.
+ "diskEncryptionStatus": { # Disk encryption status for an instance. # Disk encryption status specific to an instance.
+ # Applies only to Second Generation instances.
+ "kmsKeyVersionName": "A String", # KMS key version used to encrypt the Cloud SQL instance resource
+ "kind": "A String", # This is always <code>sql#diskEncryptionStatus</code>.
+ },
+ "kind": "A String", # This is always <code>sql#instance</code>.
+ "region": "A String", # The geographical region. Can be <code>us-central</code>
+ # (<code>FIRST_GEN</code> instances only), <code>us-central1</code>
+ # (<code>SECOND_GEN</code> instances only), <code>asia-east1</code> or
+ # <code>europe-west1</code>. Defaults to <code>us-central</code> or
+ # <code>us-central1</code> depending on the instance type (First Generation
+ # or Second Generation). The region can not be changed after instance
+ # creation.
+ "state": "A String", # The current serving state of the Cloud SQL instance. This can be one of the
+ # following. <br><code>RUNNABLE</code>: The instance is running, or is ready
+ # to run when accessed. <br><code>SUSPENDED</code>: The instance is not
+ # available, for example due to problems with billing.
+ # <br><code>PENDING_CREATE</code>: The instance is being created.
+ # <br><code>MAINTENANCE</code>: The instance is down for maintenance.
+ # <br><code>FAILED</code>: The instance creation failed.
+ # <br><code>UNKNOWN_STATE</code>: The state of the instance is unknown.
+ "backendType": "A String", # <code>FIRST_GEN</code>: First Generation instance. MySQL only. <br
+ # /><code>SECOND_GEN</code>: Second Generation instance or PostgreSQL
+ # instance. <br /><code>EXTERNAL</code>: A database server that is not
+ # managed by Google. <br>This property is read-only; use the
+ # <code>tier</code> property in the <code>settings</code> object to determine
+ # the database type and Second or First Generation.
+ "onPremisesConfiguration": { # On-premises instance configuration. # Configuration specific to on-premises instances.
+ "dumpFilePath": "A String", # The dump file to create the Cloud SQL replica.
+ "hostPort": "A String", # The host and port of the on-premises instance in host:port format
+ "clientCertificate": "A String", # PEM representation of the slave's x509 certificate.
+ "username": "A String", # The username for connecting to on-premises instance.
+ "caCertificate": "A String", # PEM representation of the trusted CA's x509 certificate.
+ "kind": "A String", # This is always <code>sql#onPremisesConfiguration</code>.
+ "password": "A String", # The password for connecting to on-premises instance.
+ "clientKey": "A String", # PEM representation of the slave's private key. The corresponsing public key
+ # is encoded in the client's certificate.
+ },
+ "project": "A String", # The project ID of the project containing the Cloud SQL instance. The Google
+ # apps domain is prefixed if applicable.
+ "serviceAccountEmailAddress": "A String", # The service account email address assigned to the instance. This property
+ # is applicable only to Second Generation instances.
}
x__xgafv: string, V1 error format.
@@ -4261,6 +4261,61 @@
{ # An Operation resource.&nbsp;For successful operations that return an
# Operation resource, only the fields relevant to the operation are populated
# in the resource.
+ "name": "A String", # An identifier that uniquely identifies the operation. You can use this
+ # identifier to retrieve the Operations resource that has information about
+ # the operation.
+ "exportContext": { # Database instance export context. # The context for export operation, if applicable.
+ "kind": "A String", # This is always <code>sql#exportContext</code>.
+ "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
+ # <code>fileType</code> is <code>SQL</code> and no database is specified, all
+ # databases are exported, except for the <code>mysql</code> system database.
+ # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
+ # either by using this property or by using the
+ # <code>csvExportOptions.selectQuery</code> property, which takes precedence
+ # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
+ # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
+ # this database must match the one specified in the
+ # <code>csvExportOptions.selectQuery</code> property.
+ "A String",
+ ],
+ "sqlExportOptions": { # Options for exporting data as SQL statements.
+ "schemaOnly": True or False, # Export only schemas.
+ "mysqlExportOptions": { # Options for exporting from MySQL.
+ "masterData": 42, # Option to include SQL statement required to set up replication.
+ # If set to <code>1</code>, the dump file includes
+ # a CHANGE MASTER TO statement with the binary log coordinates.
+ # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
+ # a SQL comment, and has no effect.
+ # All other values are ignored.
+ },
+ "tables": [ # 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.
+ "A String",
+ ],
+ },
+ "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
+ # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
+ "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
+ # stored. The URI is in the form <code>gs:
+ # //bucketName/fileName</code>. If the file already exists, the requests
+ # // succeeds, but the operation fails. If <code>fileType</code> is
+ # // <code>SQL</code> and the filename ends with .gz, the contents are
+ # // compressed.
+ "csvExportOptions": { # Options for exporting data as CSV.
+ "selectQuery": "A String", # The select query used to extract the data.
+ },
+ },
+ "targetId": "A String", # Name of the database instance related to this operation.
+ "endTime": "A String", # The time this operation finished in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "startTime": "A String", # The time this operation actually started in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
+ "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
+ # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
+ # <code>2012-11-15T16:19:00.094Z</code>.
"user": "A String", # The email address of the user who initiated this operation.
"targetProject": "A String", # The project ID of the target instance related to this operation.
"selfLink": "A String", # The URI of this resource.
@@ -4275,15 +4330,16 @@
# populated.
"errors": [ # The list of errors encountered while processing this operation.
{ # Database instance operation error.
+ "kind": "A String", # This is always <code>sql#operationError</code>.
"code": "A String", # Identifies the specific error that occurred.
"message": "A String", # Additional information about the error encountered.
- "kind": "A String", # This is always <code>sql#operationError</code>.
},
],
"kind": "A String", # This is always <code>sql#operationErrors</code>.
},
"kind": "A String", # This is always <code>sql#operation</code>.
"importContext": { # Database instance import context. # The context for import operation, if applicable.
+ "kind": "A String", # This is always <code>sql#importContext</code>.
"csvImportOptions": { # Options for importing data as CSV.
"columns": [ # The columns to which CSV data is imported. If not specified, all columns
# of the database table are loaded with CSV data.
@@ -4291,7 +4347,6 @@
],
"table": "A String", # The table to which CSV data is imported.
},
- "kind": "A String", # This is always <code>sql#importContext</code>.
"database": "A String", # The target database for the import. If <code>fileType</code> is
# <code>SQL</code>, this field is required only if the import file does not
# specify a database, and is overridden by any database specification in the
@@ -4320,61 +4375,6 @@
"status": "A String", # The status of an operation. Valid values are <code>PENDING</code>,
# <code>RUNNING</code>, <code>DONE</code>,
# <code>SQL_OPERATION_STATUS_UNSPECIFIED</code>.
- "name": "A String", # An identifier that uniquely identifies the operation. You can use this
- # identifier to retrieve the Operations resource that has information about
- # the operation.
- "exportContext": { # Database instance export context. # The context for export operation, if applicable.
- "databases": [ # Databases to be exported. <br /> <b>MySQL instances:</b> If
- # <code>fileType</code> is <code>SQL</code> and no database is specified, all
- # databases are exported, except for the <code>mysql</code> system database.
- # If <code>fileType</code> is <code>CSV</code>, you can specify one database,
- # either by using this property or by using the
- # <code>csvExportOptions.selectQuery</code> property, which takes precedence
- # over this property. <br /> <b>PostgreSQL instances:</b> You must specify
- # one database to be exported. If <code>fileType</code> is <code>CSV</code>,
- # this database must match the one specified in the
- # <code>csvExportOptions.selectQuery</code> property.
- "A String",
- ],
- "sqlExportOptions": { # Options for exporting data as SQL statements.
- "tables": [ # 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.
- "A String",
- ],
- "schemaOnly": True or False, # Export only schemas.
- "mysqlExportOptions": { # Options for exporting from MySQL.
- "masterData": 42, # Option to include SQL statement required to set up replication.
- # If set to <code>1</code>, the dump file includes
- # a CHANGE MASTER TO statement with the binary log coordinates.
- # If set to <code>2</code>, the CHANGE MASTER TO statement is written as
- # a SQL comment, and has no effect.
- # All other values are ignored.
- },
- },
- "fileType": "A String", # The file type for the specified uri. <br><code>SQL</code>: The file
- # contains SQL statements. <br><code>CSV</code>: The file contains CSV data.
- "uri": "A String", # The path to the file in Google Cloud Storage where the export will be
- # stored. The URI is in the form <code>gs:
- # //bucketName/fileName</code>. If the file already exists, the requests
- # // succeeds, but the operation fails. If <code>fileType</code> is
- # // <code>SQL</code> and the filename ends with .gz, the contents are
- # // compressed.
- "csvExportOptions": { # Options for exporting data as CSV.
- "selectQuery": "A String", # The select query used to extract the data.
- },
- "kind": "A String", # This is always <code>sql#exportContext</code>.
- },
- "targetId": "A String", # Name of the database instance related to this operation.
- "endTime": "A String", # The time this operation finished in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "startTime": "A String", # The time this operation actually started in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
- "insertTime": "A String", # The time this operation was enqueued in UTC timezone in <a
- # href="https://tools.ietf.org/html/rfc3339">RFC 3339</a> format, for example
- # <code>2012-11-15T16:19:00.094Z</code>.
}</pre>
</div>