WorkRequest¶

class oci.database_management.models.WorkRequest(**kwargs)¶

Bases: object

A description of the work request status.

Attributes

`OPERATION_TYPE_CHANGE_EXADATA_COMPARTMENT`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_CHANGE_EXTERNAL_DB_SYSTEM_COMPARTMENT`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_CHECK_EXTERNAL_MYSQL_CONNECTION`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_CREATE_DB_MANAGEMENT_PRIVATE_ENDPOINT`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_CREATE_DB_SYSTEM`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_CREATE_DB_SYSTEM_DISCOVERY`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_CREATE_EXTERNAL_MYSQL_CONNECTOR`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DB_SYSTEM_DISABLE_DBMGMT`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DB_SYSTEM_ENABLE_DBMGMT`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DELETE_DB_MANAGEMENT_PRIVATE_ENDPOINT`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DELETE_DB_SYSTEM`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DELETE_EXADATA_INFRASTRUCTURE`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DELETE_EXTERNAL_MYSQL_CONNECTOR`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DELETE_EXTERNAL_MYSQL_DATABASE`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DISABLE_DBLM`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DISABLE_DBMGMT`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DISABLE_EXADATA_INFRASTURCTURE`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_DISABLE_SQL_WATCH`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_ENABLE_DBLM`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_ENABLE_DBMGMT`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_ENABLE_EXADATA_INFRASTRUCTURE`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_ENABLE_SQL_WATCH`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_MODIFY_DBLM`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_MODIFY_DBMGMT`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_MODIFY_SQL_WATCH`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_UPDATE_DB_SYSTEM`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_UPDATE_EXTERNAL_DB_SYSTEM_CONNECTOR`	A constant which can be used with the operation_type property of a WorkRequest.
`OPERATION_TYPE_UPDATE_EXTERNAL_MYSQL_CREDENTIAL`	A constant which can be used with the operation_type property of a WorkRequest.
`STATUS_ACCEPTED`	A constant which can be used with the status property of a WorkRequest.
`STATUS_CANCELED`	A constant which can be used with the status property of a WorkRequest.
`STATUS_CANCELING`	A constant which can be used with the status property of a WorkRequest.
`STATUS_FAILED`	A constant which can be used with the status property of a WorkRequest.
`STATUS_IN_PROGRESS`	A constant which can be used with the status property of a WorkRequest.
`STATUS_SUCCEEDED`	A constant which can be used with the status property of a WorkRequest.
`compartment_id`	[Required] Gets the compartment_id of this WorkRequest.
`id`	[Required] Gets the id of this WorkRequest.
`operation_type`	[Required] Gets the operation_type of this WorkRequest.
`percent_complete`	[Required] Gets the percent_complete of this WorkRequest.
`resources`	[Required] Gets the resources of this WorkRequest.
`status`	[Required] Gets the status of this WorkRequest.
`time_accepted`	[Required] Gets the time_accepted of this WorkRequest.
`time_finished`	Gets the time_finished of this WorkRequest.
`time_started`	Gets the time_started of this WorkRequest.

Methods

__init__(**kwargs) Initializes a new WorkRequest object with values from keyword arguments.

OPERATION_TYPE_CHANGE_EXADATA_COMPARTMENT = 'CHANGE_EXADATA_COMPARTMENT'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “CHANGE_EXADATA_COMPARTMENT”

OPERATION_TYPE_CHANGE_EXTERNAL_DB_SYSTEM_COMPARTMENT = 'CHANGE_EXTERNAL_DB_SYSTEM_COMPARTMENT'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “CHANGE_EXTERNAL_DB_SYSTEM_COMPARTMENT”

OPERATION_TYPE_CHECK_EXTERNAL_MYSQL_CONNECTION = 'CHECK_EXTERNAL_MYSQL_CONNECTION'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “CHECK_EXTERNAL_MYSQL_CONNECTION”

OPERATION_TYPE_CREATE_DB_MANAGEMENT_PRIVATE_ENDPOINT = 'CREATE_DB_MANAGEMENT_PRIVATE_ENDPOINT'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “CREATE_DB_MANAGEMENT_PRIVATE_ENDPOINT”

OPERATION_TYPE_CREATE_DB_SYSTEM = 'CREATE_DB_SYSTEM'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “CREATE_DB_SYSTEM”

OPERATION_TYPE_CREATE_DB_SYSTEM_DISCOVERY = 'CREATE_DB_SYSTEM_DISCOVERY'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “CREATE_DB_SYSTEM_DISCOVERY”

OPERATION_TYPE_CREATE_EXTERNAL_MYSQL_CONNECTOR = 'CREATE_EXTERNAL_MYSQL_CONNECTOR'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “CREATE_EXTERNAL_MYSQL_CONNECTOR”

OPERATION_TYPE_DB_SYSTEM_DISABLE_DBMGMT = 'DB_SYSTEM_DISABLE_DBMGMT'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DB_SYSTEM_DISABLE_DBMGMT”

OPERATION_TYPE_DB_SYSTEM_ENABLE_DBMGMT = 'DB_SYSTEM_ENABLE_DBMGMT'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DB_SYSTEM_ENABLE_DBMGMT”

OPERATION_TYPE_DELETE_DB_MANAGEMENT_PRIVATE_ENDPOINT = 'DELETE_DB_MANAGEMENT_PRIVATE_ENDPOINT'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DELETE_DB_MANAGEMENT_PRIVATE_ENDPOINT”

OPERATION_TYPE_DELETE_DB_SYSTEM = 'DELETE_DB_SYSTEM'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DELETE_DB_SYSTEM”

OPERATION_TYPE_DELETE_EXADATA_INFRASTRUCTURE = 'DELETE_EXADATA_INFRASTRUCTURE'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DELETE_EXADATA_INFRASTRUCTURE”

OPERATION_TYPE_DELETE_EXTERNAL_MYSQL_CONNECTOR = 'DELETE_EXTERNAL_MYSQL_CONNECTOR'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DELETE_EXTERNAL_MYSQL_CONNECTOR”

OPERATION_TYPE_DELETE_EXTERNAL_MYSQL_DATABASE = 'DELETE_EXTERNAL_MYSQL_DATABASE'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DELETE_EXTERNAL_MYSQL_DATABASE”

OPERATION_TYPE_DISABLE_DBLM = 'DISABLE_DBLM'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DISABLE_DBLM”

OPERATION_TYPE_DISABLE_DBMGMT = 'DISABLE_DBMGMT'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DISABLE_DBMGMT”

OPERATION_TYPE_DISABLE_EXADATA_INFRASTURCTURE = 'DISABLE_EXADATA_INFRASTURCTURE'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DISABLE_EXADATA_INFRASTURCTURE”

OPERATION_TYPE_DISABLE_SQL_WATCH = 'DISABLE_SQL_WATCH'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “DISABLE_SQL_WATCH”

OPERATION_TYPE_ENABLE_DBLM = 'ENABLE_DBLM'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “ENABLE_DBLM”

OPERATION_TYPE_ENABLE_DBMGMT = 'ENABLE_DBMGMT'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “ENABLE_DBMGMT”

OPERATION_TYPE_ENABLE_EXADATA_INFRASTRUCTURE = 'ENABLE_EXADATA_INFRASTRUCTURE'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “ENABLE_EXADATA_INFRASTRUCTURE”

OPERATION_TYPE_ENABLE_SQL_WATCH = 'ENABLE_SQL_WATCH'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “ENABLE_SQL_WATCH”

OPERATION_TYPE_MODIFY_DBLM = 'MODIFY_DBLM'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “MODIFY_DBLM”

OPERATION_TYPE_MODIFY_DBMGMT = 'MODIFY_DBMGMT'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “MODIFY_DBMGMT”

OPERATION_TYPE_MODIFY_SQL_WATCH = 'MODIFY_SQL_WATCH'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “MODIFY_SQL_WATCH”

OPERATION_TYPE_UPDATE_DB_SYSTEM = 'UPDATE_DB_SYSTEM'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “UPDATE_DB_SYSTEM”

OPERATION_TYPE_UPDATE_EXTERNAL_DB_SYSTEM_CONNECTOR = 'UPDATE_EXTERNAL_DB_SYSTEM_CONNECTOR'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “UPDATE_EXTERNAL_DB_SYSTEM_CONNECTOR”

OPERATION_TYPE_UPDATE_EXTERNAL_MYSQL_CREDENTIAL = 'UPDATE_EXTERNAL_MYSQL_CREDENTIAL'¶: A constant which can be used with the operation_type property of a WorkRequest. This constant has a value of “UPDATE_EXTERNAL_MYSQL_CREDENTIAL”

STATUS_ACCEPTED = 'ACCEPTED'¶: A constant which can be used with the status property of a WorkRequest. This constant has a value of “ACCEPTED”

STATUS_CANCELED = 'CANCELED'¶: A constant which can be used with the status property of a WorkRequest. This constant has a value of “CANCELED”

STATUS_CANCELING = 'CANCELING'¶: A constant which can be used with the status property of a WorkRequest. This constant has a value of “CANCELING”

STATUS_FAILED = 'FAILED'¶: A constant which can be used with the status property of a WorkRequest. This constant has a value of “FAILED”

STATUS_IN_PROGRESS = 'IN_PROGRESS'¶: A constant which can be used with the status property of a WorkRequest. This constant has a value of “IN_PROGRESS”

STATUS_SUCCEEDED = 'SUCCEEDED'¶: A constant which can be used with the status property of a WorkRequest. This constant has a value of “SUCCEEDED”

__init__(**kwargs)¶

Initializes a new WorkRequest object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

id (str) – The value to assign to the id property of this WorkRequest.
compartment_id (str) – The value to assign to the compartment_id property of this WorkRequest.
operation_type (str) – The value to assign to the operation_type property of this WorkRequest. Allowed values for this property are: “CREATE_DB_MANAGEMENT_PRIVATE_ENDPOINT”, “DELETE_DB_MANAGEMENT_PRIVATE_ENDPOINT”, “CREATE_DB_SYSTEM_DISCOVERY”, “CREATE_DB_SYSTEM”, “UPDATE_DB_SYSTEM”, “DB_SYSTEM_ENABLE_DBMGMT”, “DB_SYSTEM_DISABLE_DBMGMT”, “DELETE_DB_SYSTEM”, “UPDATE_EXTERNAL_DB_SYSTEM_CONNECTOR”, “CHANGE_EXTERNAL_DB_SYSTEM_COMPARTMENT”, “DISABLE_EXADATA_INFRASTURCTURE”, “ENABLE_EXADATA_INFRASTRUCTURE”, “DELETE_EXADATA_INFRASTRUCTURE”, “CHANGE_EXADATA_COMPARTMENT”, “ENABLE_SQL_WATCH”, “DISABLE_SQL_WATCH”, “MODIFY_SQL_WATCH”, “ENABLE_DBLM”, “DISABLE_DBLM”, “MODIFY_DBLM”, “ENABLE_DBMGMT”, “DISABLE_DBMGMT”, “MODIFY_DBMGMT”, “CHECK_EXTERNAL_MYSQL_CONNECTION”, “UPDATE_EXTERNAL_MYSQL_CREDENTIAL”, “CREATE_EXTERNAL_MYSQL_CONNECTOR”, “DELETE_EXTERNAL_MYSQL_CONNECTOR”, “DELETE_EXTERNAL_MYSQL_DATABASE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
status (str) – The value to assign to the status property of this WorkRequest. Allowed values for this property are: “ACCEPTED”, “IN_PROGRESS”, “FAILED”, “SUCCEEDED”, “CANCELING”, “CANCELED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
percent_complete (float) – The value to assign to the percent_complete property of this WorkRequest.
time_accepted (datetime) – The value to assign to the time_accepted property of this WorkRequest.
time_started (datetime) – The value to assign to the time_started property of this WorkRequest.
time_finished (datetime) – The value to assign to the time_finished property of this WorkRequest.
resources (list[oci.database_management.models.WorkRequestResource]) – The value to assign to the resources property of this WorkRequest.

compartment_id¶

[Required] Gets the compartment_id of this WorkRequest. The OCID of the compartment that contains the work request. Work requests should be scoped to the same compartment as the resource the work request affects. If the work request affects multiple resources that are not in the same compartment, then the system picks the primary resource whose compartment should be used.

Returns:	The compartment_id of this WorkRequest.
Return type:	str

id¶

[Required] Gets the id of this WorkRequest. The ID of the work request.

Returns:	The id of this WorkRequest.
Return type:	str

operation_type¶

[Required] Gets the operation_type of this WorkRequest. The type of work request.

Allowed values for this property are: “CREATE_DB_MANAGEMENT_PRIVATE_ENDPOINT”, “DELETE_DB_MANAGEMENT_PRIVATE_ENDPOINT”, “CREATE_DB_SYSTEM_DISCOVERY”, “CREATE_DB_SYSTEM”, “UPDATE_DB_SYSTEM”, “DB_SYSTEM_ENABLE_DBMGMT”, “DB_SYSTEM_DISABLE_DBMGMT”, “DELETE_DB_SYSTEM”, “UPDATE_EXTERNAL_DB_SYSTEM_CONNECTOR”, “CHANGE_EXTERNAL_DB_SYSTEM_COMPARTMENT”, “DISABLE_EXADATA_INFRASTURCTURE”, “ENABLE_EXADATA_INFRASTRUCTURE”, “DELETE_EXADATA_INFRASTRUCTURE”, “CHANGE_EXADATA_COMPARTMENT”, “ENABLE_SQL_WATCH”, “DISABLE_SQL_WATCH”, “MODIFY_SQL_WATCH”, “ENABLE_DBLM”, “DISABLE_DBLM”, “MODIFY_DBLM”, “ENABLE_DBMGMT”, “DISABLE_DBMGMT”, “MODIFY_DBMGMT”, “CHECK_EXTERNAL_MYSQL_CONNECTION”, “UPDATE_EXTERNAL_MYSQL_CREDENTIAL”, “CREATE_EXTERNAL_MYSQL_CONNECTOR”, “DELETE_EXTERNAL_MYSQL_CONNECTOR”, “DELETE_EXTERNAL_MYSQL_DATABASE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The operation_type of this WorkRequest.
Return type:	str

percent_complete¶

[Required] Gets the percent_complete of this WorkRequest. The completed percentage of the operation tracked by the work request.

Returns:	The percent_complete of this WorkRequest.
Return type:	float

resources¶

[Required] Gets the resources of this WorkRequest. The resources affected by this work request.

Returns:	The resources of this WorkRequest.
Return type:	list[oci.database_management.models.WorkRequestResource]

status¶

[Required] Gets the status of this WorkRequest. The status of the current work request.

Allowed values for this property are: “ACCEPTED”, “IN_PROGRESS”, “FAILED”, “SUCCEEDED”, “CANCELING”, “CANCELED”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The status of this WorkRequest.
Return type:	str

time_accepted¶

[Required] Gets the time_accepted of this WorkRequest. The date and time the work request was accepted, as described in RFC 3339. The precision for this time object in milliseconds.

Returns:	The time_accepted of this WorkRequest.
Return type:	datetime

time_finished¶

Gets the time_finished of this WorkRequest. The date and time the work request reached a terminal state, either FAILED or SUCCEEDED, as described in RFC 3339. The precision for this time object is in milliseconds.

Returns:	The time_finished of this WorkRequest.
Return type:	datetime

time_started¶

Gets the time_started of this WorkRequest. The date and time the work request transitioned from ACCEPTED to IN_PROGRESS, as described in RFC 3339. The precision for this time object is in milliseconds.

Returns:	The time_started of this WorkRequest.
Return type:	datetime