ruạṛ
a ���fpS � @ sD d dl mZ ddlmZmZmZ ddlmZ eG dd� de��ZdS )� )�Job� )�formatted_flat_dict� NONE_SENTINEL�#value_allowed_none_or_none_sentinel)� init_model_state_from_kwargsc @ sj e Zd ZdZdZdZdZdZdZdZ dZ d d � Z e d d � �Z e jd d � �Z e dd� �Zejdd� �Ze dd� �Zejdd� �Ze dd� �Zejdd� �Ze dd� �Zejdd� �Ze dd� �Zejd d� �Ze d d � �Zejd d � �Ze d d!� �Zejd"d!� �Ze d#d$� �Zejd%d$� �Ze d&d'� �Zejd(d'� �Ze d)d*� �Zejd+d*� �Zd,d-� Zd.d/� Zd0d1� Zd2S )3�SqlJobz% The details of the SQL job. �QUERY�DML�DDL�PLSQL� EXECUTE_SQL�NORMAL�SYSDBAc K s2 ddddddddddddddddddddddddddd d d � | _ d d d ddddddddddddddd d d d d d!d"d#d$d%d&d � | _d'| _d'| _d'| _d'| _d'| _d'| _d'| _d'| _ d'| _ d'| _ d'| _ d'| _ d'| _d'| _d'| _d'| _d'| _d'| _d'| _d'| _d'| _d'| _d'| _d'| _d'| _d'| _d'| _ d'| _ d(| _ d'S ))a? Initializes a new SqlJob object with values from keyword arguments. The default value of the :py:attr:`~oci.database_management.models.SqlJob.job_type` attribute of this class is ``SQL`` and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class): :param id: The value to assign to the id property of this SqlJob. :type id: str :param compartment_id: The value to assign to the compartment_id property of this SqlJob. :type compartment_id: str :param name: The value to assign to the name property of this SqlJob. :type name: str :param description: The value to assign to the description property of this SqlJob. :type description: str :param managed_database_group_id: The value to assign to the managed_database_group_id property of this SqlJob. :type managed_database_group_id: str :param managed_database_id: The value to assign to the managed_database_id property of this SqlJob. :type managed_database_id: str :param managed_databases_details: The value to assign to the managed_databases_details property of this SqlJob. :type managed_databases_details: list[oci.database_management.models.JobDatabase] :param database_sub_type: The value to assign to the database_sub_type property of this SqlJob. Allowed values for this property are: "CDB", "PDB", "NON_CDB", "ACD", "ADB", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type database_sub_type: str :param schedule_type: The value to assign to the schedule_type property of this SqlJob. Allowed values for this property are: "IMMEDIATE", "LATER", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type schedule_type: str :param job_type: The value to assign to the job_type property of this SqlJob. Allowed values for this property are: "SQL", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type job_type: str :param lifecycle_state: The value to assign to the lifecycle_state property of this SqlJob. Allowed values for this property are: "ACTIVE", "INACTIVE", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type lifecycle_state: str :param timeout: The value to assign to the timeout property of this SqlJob. :type timeout: str :param result_location: The value to assign to the result_location property of this SqlJob. :type result_location: oci.database_management.models.JobExecutionResultLocation :param schedule_details: The value to assign to the schedule_details property of this SqlJob. :type schedule_details: oci.database_management.models.JobScheduleDetails :param submission_error_message: The value to assign to the submission_error_message property of this SqlJob. :type submission_error_message: str :param time_created: The value to assign to the time_created property of this SqlJob. :type time_created: datetime :param time_updated: The value to assign to the time_updated property of this SqlJob. :type time_updated: datetime :param sql_type: The value to assign to the sql_type property of this SqlJob. Allowed values for this property are: "QUERY", "DML", "DDL", "PLSQL", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type sql_type: str :param sql_text: The value to assign to the sql_text property of this SqlJob. :type sql_text: str :param in_binds: The value to assign to the in_binds property of this SqlJob. :type in_binds: oci.database_management.models.JobInBindsDetails :param out_binds: The value to assign to the out_binds property of this SqlJob. :type out_binds: oci.database_management.models.JobOutBindsDetails :param operation_type: The value to assign to the operation_type property of this SqlJob. Allowed values for this property are: "EXECUTE_SQL", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type operation_type: str :param user_name: The value to assign to the user_name property of this SqlJob. :type user_name: str :param role: The value to assign to the role property of this SqlJob. Allowed values for this property are: "NORMAL", "SYSDBA", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type role: str :param named_credential_id: The value to assign to the named_credential_id property of this SqlJob. :type named_credential_id: str :param freeform_tags: The value to assign to the freeform_tags property of this SqlJob. :type freeform_tags: dict(str, str) :param defined_tags: The value to assign to the defined_tags property of this SqlJob. :type defined_tags: dict(str, dict(str, object)) :param system_tags: The value to assign to the system_tags property of this SqlJob. :type system_tags: dict(str, dict(str, object)) �strzlist[JobDatabase]ZJobExecutionResultLocationZJobScheduleDetailsZdatetimeZJobInBindsDetailsZJobOutBindsDetailszdict(str, str)z dict(str, dict(str, object))) �idZcompartment_id�name� descriptionZmanaged_database_group_idZmanaged_database_idZmanaged_databases_detailsZdatabase_sub_typeZ schedule_typeZjob_typeZlifecycle_state�timeoutZresult_locationZschedule_detailsZsubmission_error_messageZ time_createdZ time_updated�sql_type�sql_text�in_binds� out_binds�operation_type� user_name�role�named_credential_id� freeform_tags� defined_tags� system_tagsr Z compartmentIdr r ZmanagedDatabaseGroupIdZmanagedDatabaseIdZmanagedDatabasesDetailsZdatabaseSubTypeZ scheduleTypeZjobTypeZlifecycleStater ZresultLocationZscheduleDetailsZsubmissionErrorMessageZ timeCreatedZ timeUpdatedZsqlTypeZsqlTextZinBindsZoutBindsZ operationTypeZuserNamer ZnamedCredentialIdZ freeformTagsZ definedTagsZ systemTagsNZSQL) Z swagger_typesZ attribute_mapZ_idZ_compartment_id�_nameZ _descriptionZ_managed_database_group_idZ_managed_database_idZ_managed_databases_detailsZ_database_sub_typeZ_schedule_typeZ _job_typeZ_lifecycle_state�_timeoutZ_result_locationZ_schedule_detailsZ_submission_error_messageZ _time_createdZ _time_updated� _sql_type� _sql_text� _in_binds� _out_binds�_operation_type� _user_name�_role�_named_credential_id�_freeform_tags� _defined_tags� _system_tags)�self�kwargs� r/ �J/usr/lib/python3.9/site-packages/oci/database_management/models/sql_job.py�__init__. s� � � zSqlJob.__init__c C s | j S )a� Gets the sql_type of this SqlJob. The type of SQL. This is a mandatory field for the EXECUTE_SQL operationType. Allowed values for this property are: "QUERY", "DML", "DDL", "PLSQL", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :return: The sql_type of this SqlJob. :rtype: str )r" �r- r/ r/ r0 r s zSqlJob.sql_typec C s g d�}t ||�sd}|| _dS )z� Sets the sql_type of this SqlJob. The type of SQL. This is a mandatory field for the EXECUTE_SQL operationType. :param sql_type: The sql_type of this SqlJob. :type: str )r r r r �UNKNOWN_ENUM_VALUEN)r r" )r- r �allowed_valuesr/ r/ r0 r s c C s | j S )z� Gets the sql_text of this SqlJob. The SQL text to be executed in the job. This is a mandatory field for the EXECUTE_SQL operationType. :return: The sql_text of this SqlJob. :rtype: str �r# r2 r/ r/ r0 r - s zSqlJob.sql_textc C s || _ dS )z� Sets the sql_text of this SqlJob. The SQL text to be executed in the job. This is a mandatory field for the EXECUTE_SQL operationType. :param sql_text: The sql_text of this SqlJob. :type: str Nr5 )r- r r/ r/ r0 r 9 s c C s | j S )z� Gets the in_binds of this SqlJob. :return: The in_binds of this SqlJob. :rtype: oci.database_management.models.JobInBindsDetails �r$ r2 r/ r/ r0 r E s zSqlJob.in_bindsc C s || _ dS )z� Sets the in_binds of this SqlJob. :param in_binds: The in_binds of this SqlJob. :type: oci.database_management.models.JobInBindsDetails Nr6 )r- r r/ r/ r0 r O s c C s | j S )z� Gets the out_binds of this SqlJob. :return: The out_binds of this SqlJob. :rtype: oci.database_management.models.JobOutBindsDetails �r% r2 r/ r/ r0 r Y s zSqlJob.out_bindsc C s || _ dS )z� Sets the out_binds of this SqlJob. :param out_binds: The out_binds of this SqlJob. :type: oci.database_management.models.JobOutBindsDetails Nr7 )r- r r/ r/ r0 r c s c C s | j S )ad **[Required]** Gets the operation_type of this SqlJob. The SQL operation type. Allowed values for this property are: "EXECUTE_SQL", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :return: The operation_type of this SqlJob. :rtype: str )r& r2 r/ r/ r0 r m s zSqlJob.operation_typec C s dg}t ||�sd}|| _dS )z� Sets the operation_type of this SqlJob. The SQL operation type. :param operation_type: The operation_type of this SqlJob. :type: str r r3 N)r r& )r- r r4 r/ r/ r0 r | s c C s | j S )aQ Gets the user_name of this SqlJob. The database user name used to execute the SQL job. If the job is being executed on a Managed Database Group, then the user name should exist on all the databases in the group with the same password. :return: The user_name of this SqlJob. :rtype: str �r' r2 r/ r/ r0 r � s zSqlJob.user_namec C s || _ dS )aY Sets the user_name of this SqlJob. The database user name used to execute the SQL job. If the job is being executed on a Managed Database Group, then the user name should exist on all the databases in the group with the same password. :param user_name: The user_name of this SqlJob. :type: str Nr8 )r- r r/ r/ r0 r � s c C s | j S )a� Gets the role of this SqlJob. The role of the database user. Indicates whether the database user is a normal user or sysdba. Allowed values for this property are: "NORMAL", "SYSDBA", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :return: The role of this SqlJob. :rtype: str )r( r2 r/ r/ r0 r � s z SqlJob.rolec C s ddg}t ||�sd}|| _dS )z� Sets the role of this SqlJob. The role of the database user. Indicates whether the database user is a normal user or sysdba. :param role: The role of this SqlJob. :type: str r r r3 N)r r( )r- r r4 r/ r/ r0 r � s c C s | j S )a* Gets the named_credential_id of this SqlJob. The `OCID`__ of the Named Credentials containing password secret. __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm :return: The named_credential_id of this SqlJob. :rtype: str �r) r2 r/ r/ r0 r � s zSqlJob.named_credential_idc C s || _ dS )a< Sets the named_credential_id of this SqlJob. The `OCID`__ of the Named Credentials containing password secret. __ https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm :param named_credential_id: The named_credential_id of this SqlJob. :type: str Nr9 )r- r r/ r/ r0 r � s c C s | j S )a� Gets the freeform_tags of this SqlJob. Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see `Resource Tags`__. Example: `{"Department": "Finance"}` __ https://docs.cloud.oracle.com/Content/General/Concepts/resourcetags.htm :return: The freeform_tags of this SqlJob. :rtype: dict(str, str) �r* r2 r/ r/ r0 r � s zSqlJob.freeform_tagsc C s || _ dS )a� Sets the freeform_tags of this SqlJob. Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see `Resource Tags`__. Example: `{"Department": "Finance"}` __ https://docs.cloud.oracle.com/Content/General/Concepts/resourcetags.htm :param freeform_tags: The freeform_tags of this SqlJob. :type: dict(str, str) Nr: )r- r r/ r/ r0 r � s c C s | j S )a� Gets the defined_tags of this SqlJob. Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see `Resource Tags`__. Example: `{"Operations": {"CostCenter": "42"}}` __ https://docs.cloud.oracle.com/Content/General/Concepts/resourcetags.htm :return: The defined_tags of this SqlJob. :rtype: dict(str, dict(str, object)) �r+ r2 r/ r/ r0 r � s zSqlJob.defined_tagsc C s || _ dS )a� Sets the defined_tags of this SqlJob. Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see `Resource Tags`__. Example: `{"Operations": {"CostCenter": "42"}}` __ https://docs.cloud.oracle.com/Content/General/Concepts/resourcetags.htm :param defined_tags: The defined_tags of this SqlJob. :type: dict(str, dict(str, object)) Nr; )r- r r/ r/ r0 r s c C s | j S )a Gets the system_tags of this SqlJob. System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see `Resource Tags`__. System tags can be viewed by users, but can only be created by the system. Example: `{"orcl-cloud": {"free-tier-retained": "true"}}` __ https://docs.cloud.oracle.com/Content/General/Concepts/resourcetags.htm :return: The system_tags of this SqlJob. :rtype: dict(str, dict(str, object)) �r, r2 r/ r/ r0 r s zSqlJob.system_tagsc C s || _ dS )a Sets the system_tags of this SqlJob. System tags for this resource. Each key is predefined and scoped to a namespace. For more information, see `Resource Tags`__. System tags can be viewed by users, but can only be created by the system. Example: `{"orcl-cloud": {"free-tier-retained": "true"}}` __ https://docs.cloud.oracle.com/Content/General/Concepts/resourcetags.htm :param system_tags: The system_tags of this SqlJob. :type: dict(str, dict(str, object)) Nr< )r- r r/ r/ r0 r 1 s c C s t | �S �N)r r2 r/ r/ r0 �__repr__C s zSqlJob.__repr__c C s |d u r dS | j |j kS )NF)�__dict__�r- �otherr/ r/ r0 �__eq__F s z SqlJob.__eq__c C s | |k S r= r/ r@ r/ r/ r0 �__ne__L s z SqlJob.__ne__N) �__name__� __module__� __qualname__�__doc__ZSQL_TYPE_QUERYZ SQL_TYPE_DMLZ SQL_TYPE_DDLZSQL_TYPE_PLSQLZOPERATION_TYPE_EXECUTE_SQLZ ROLE_NORMALZ ROLE_SYSDBAr1 �propertyr �setterr r r r r r r r r r r> rB rC r/ r/ r/ r0 r sr b r N) Zjobr Zoci.utilr r r Zoci.decoratorsr r r/ r/ r/ r0 �<module> s
cải xoăn