a fpS@sDddlmZddlmZmZmZddlmZeGdddeZdS))Job)formatted_flat_dict NONE_SENTINEL#value_allowed_none_or_none_sentinel)init_model_state_from_kwargsc@sjeZdZdZdZdZdZdZdZdZ dZ d d Z e d d Z e jd d Z e ddZejddZe ddZejddZe ddZejddZe ddZejddZe ddZejddZe ddZejddZe d d!Zejd"d!Ze d#d$Zejd%d$Ze d&d'Zejd(d'Ze d)d*Zejd+d*Zd,d-Zd.d/Zd0d1Zd2S)3SqlJobz% The details of the SQL job. QUERYDMLDDLPLSQL EXECUTE_SQLNORMALSYSDBAcKs2ddddddddddddddddddddddddddd d d |_d d d ddddddddddddddddddd 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)zdict(str, dict(str, object)))idZcompartment_idname descriptionZmanaged_database_group_idZmanaged_database_idZmanaged_databases_detailsZdatabase_sub_typeZ schedule_typeZjob_typeZlifecycle_statetimeoutZresult_locationZschedule_detailsZsubmission_error_messageZ time_createdZ time_updatedsql_typesql_textin_binds out_bindsoperation_type user_namerolenamed_credential_id freeform_tags defined_tags system_tagsrZ compartmentIdrrZmanagedDatabaseGroupIdZmanagedDatabaseIdZmanagedDatabasesDetailsZdatabaseSubTypeZ scheduleTypeZjobTypeZlifecycleStaterZresultLocationZscheduleDetailsZsubmissionErrorMessageZ timeCreatedZ timeUpdatedZsqlTypeZsqlTextZinBindsZoutBindsZ operationTypeZuserNamerZnamedCredentialIdZ 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)selfkwargsr/J/usr/lib/python3.9/site-packages/oci/database_management/models/sql_job.py__init__.s zSqlJob.__init__cCs|jS)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/r0rs zSqlJob.sql_typecCs gd}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)rr")r-rallowed_valuesr/r/r0rs  cCs|jS)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#r2r/r/r0r-s zSqlJob.sql_textcCs ||_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-rr/r/r0r9s cCs|jS)z Gets the in_binds of this SqlJob. :return: The in_binds of this SqlJob. :rtype: oci.database_management.models.JobInBindsDetails r$r2r/r/r0rEszSqlJob.in_bindscCs ||_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-rr/r/r0rOscCs|jS)z Gets the out_binds of this SqlJob. :return: The out_binds of this SqlJob. :rtype: oci.database_management.models.JobOutBindsDetails r%r2r/r/r0rYszSqlJob.out_bindscCs ||_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-rr/r/r0rcscCs|jS)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&r2r/r/r0rms zSqlJob.operation_typecCsdg}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 r3N)rr&)r-rr4r/r/r0r|s  cCs|jS)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'r2r/r/r0rs zSqlJob.user_namecCs ||_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-rr/r/r0rs cCs|jS)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(r2r/r/r0rs z SqlJob.rolecCs 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 rrr3N)rr()r-rr4r/r/r0rs  cCs|jS)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)r2r/r/r0rs zSqlJob.named_credential_idcCs ||_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-rr/r/r0rs cCs|jS)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*r2r/r/r0rszSqlJob.freeform_tagscCs ||_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-rr/r/r0rscCs|jS)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+r2r/r/r0rszSqlJob.defined_tagscCs ||_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-rr/r/r0rscCs|jS)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,r2r/r/r0rszSqlJob.system_tagscCs ||_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-rr/r/r0r1scCst|SN)rr2r/r/r0__repr__CszSqlJob.__repr__cCs|dur dS|j|jkS)NF)__dict__r-otherr/r/r0__eq__Fsz SqlJob.__eq__cCs ||k Sr=r/r@r/r/r0__ne__Lsz SqlJob.__ne__N)__name__ __module__ __qualname____doc__ZSQL_TYPE_QUERYZ SQL_TYPE_DMLZ SQL_TYPE_DDLZSQL_TYPE_PLSQLZOPERATION_TYPE_EXECUTE_SQLZ ROLE_NORMALZ ROLE_SYSDBAr1propertyrsetterrrrrrrrrrrr>rBrCr/r/r/r0r srb                      rN) ZjobrZoci.utilrrrZoci.decoratorsrrr/r/r/r0s