ruạṛ
a ���f g � @ s8 d dl mZmZmZ d dlmZ eG dd� de��ZdS )� )�formatted_flat_dict� NONE_SENTINEL�#value_allowed_none_or_none_sentinel)� init_model_state_from_kwargsc @ s< e Zd ZdZdZdZdZdZdZdZ dZ d Z d Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdZdZdZ dZ dZ dd� Z e dd� �Z!e!j"dd� �Z!e dd� �Z#e#j"dd� �Z#e dd � �Z$e$j"d d � �Z$e d d � �Z%e%j"d d � �Z%e d!d"� �Z&e&j"d#d"� �Z&e d$d%� �Z'e'j"d&d%� �Z'e d'd(� �Z(e(j"d)d(� �Z(e d*d+� �Z)e)j"d,d+� �Z)e d-d.� �Z*e*j"d/d.� �Z*e d0d1� �Z+e+j"d2d1� �Z+e d3d4� �Z,e,j"d5d4� �Z,e d6d7� �Z-e-j"d8d7� �Z-e d9d:� �Z.e.j"d;d:� �Z.e d<d=� �Z/e/j"d>d=� �Z/e d?d@� �Z0e0j"dAd@� �Z0e dBdC� �Z1e1j"dDdC� �Z1dEdF� Z2dGdH� Z3dIdJ� Z4dKS )L�SqlPlanBaselinez- The details of a SQL plan baseline. � ADDM_SQLTUNE� AUTO_CAPTURE� AUTO_SQLTUNE�EVOLVE_AUTO_INDEX_LOAD�EVOLVE_CREATE_FROM_ADAPTIVE�EVOLVE_LOAD_FROM_STS�EVOLVE_LOAD_FROM_AWR� EVOLVE_LOAD_FROM_CURSOR_CACHE� MANUAL_LOAD�MANUAL_LOAD_FROM_AWR� MANUAL_LOAD_FROM_CURSOR_CACHE�MANUAL_LOAD_FROM_STS�MANUAL_SQLTUNE�STORED_OUTLINE�UNKNOWN�YES�NOc K s� ddddddddddddddddd�| _ dddddd d d d d ddddddd�| _d| _d| _d| _d| _d| _d| _d| _d| _ d| _ d| _ d| _ d| _ d| _d| _d| _d| _dS )a� Initializes a new SqlPlanBaseline object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class): :param plan_name: The value to assign to the plan_name property of this SqlPlanBaseline. :type plan_name: str :param sql_handle: The value to assign to the sql_handle property of this SqlPlanBaseline. :type sql_handle: str :param sql_text: The value to assign to the sql_text property of this SqlPlanBaseline. :type sql_text: str :param origin: The value to assign to the origin property of this SqlPlanBaseline. Allowed values for this property are: "ADDM_SQLTUNE", "AUTO_CAPTURE", "AUTO_SQLTUNE", "EVOLVE_AUTO_INDEX_LOAD", "EVOLVE_CREATE_FROM_ADAPTIVE", "EVOLVE_LOAD_FROM_STS", "EVOLVE_LOAD_FROM_AWR", "EVOLVE_LOAD_FROM_CURSOR_CACHE", "MANUAL_LOAD", "MANUAL_LOAD_FROM_AWR", "MANUAL_LOAD_FROM_CURSOR_CACHE", "MANUAL_LOAD_FROM_STS", "MANUAL_SQLTUNE", "STORED_OUTLINE", "UNKNOWN", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type origin: str :param time_created: The value to assign to the time_created property of this SqlPlanBaseline. :type time_created: datetime :param time_last_modified: The value to assign to the time_last_modified property of this SqlPlanBaseline. :type time_last_modified: datetime :param time_last_executed: The value to assign to the time_last_executed property of this SqlPlanBaseline. :type time_last_executed: datetime :param enabled: The value to assign to the enabled property of this SqlPlanBaseline. Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type enabled: str :param accepted: The value to assign to the accepted property of this SqlPlanBaseline. Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type accepted: str :param fixed: The value to assign to the fixed property of this SqlPlanBaseline. Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type fixed: str :param reproduced: The value to assign to the reproduced property of this SqlPlanBaseline. Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type reproduced: str :param auto_purge: The value to assign to the auto_purge property of this SqlPlanBaseline. Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type auto_purge: str :param adaptive: The value to assign to the adaptive property of this SqlPlanBaseline. Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :type adaptive: str :param module: The value to assign to the module property of this SqlPlanBaseline. :type module: str :param action: The value to assign to the action property of this SqlPlanBaseline. :type action: str :param execution_plan: The value to assign to the execution_plan property of this SqlPlanBaseline. :type execution_plan: str �strZdatetime)� plan_name� sql_handle�sql_text�origin� time_created�time_last_modified�time_last_executed�enabled�accepted�fixed� reproduced� auto_purge�adaptive�module�action�execution_planZplanNameZ sqlHandleZsqlTextr Z timeCreatedZtimeLastModifiedZtimeLastExecutedr r! r" r# Z autoPurger% r& r' Z executionPlanN)Z swagger_typesZ attribute_map� _plan_name� _sql_handle� _sql_text�_origin� _time_created�_time_last_modified�_time_last_executed�_enabled� _accepted�_fixed� _reproduced� _auto_purge� _adaptive�_module�_action�_execution_plan)�self�kwargs� r; �T/usr/lib/python3.9/site-packages/oci/database_management/models/sql_plan_baseline.py�__init__~ sd U��zSqlPlanBaseline.__init__c C s | j S )z� **[Required]** Gets the plan_name of this SqlPlanBaseline. The unique plan identifier. :return: The plan_name of this SqlPlanBaseline. :rtype: str �r) �r9 r; r; r< r s zSqlPlanBaseline.plan_namec C s || _ dS )z� Sets the plan_name of this SqlPlanBaseline. The unique plan identifier. :param plan_name: The plan_name of this SqlPlanBaseline. :type: str Nr> )r9 r r; r; r< r s c C s | j S )z� **[Required]** Gets the sql_handle of this SqlPlanBaseline. The unique SQL identifier. :return: The sql_handle of this SqlPlanBaseline. :rtype: str �r* r? r; r; r< r ! s zSqlPlanBaseline.sql_handlec C s || _ dS )z� Sets the sql_handle of this SqlPlanBaseline. The unique SQL identifier. :param sql_handle: The sql_handle of this SqlPlanBaseline. :type: str Nr@ )r9 r r; r; r< r - s c C s | j S )z� **[Required]** Gets the sql_text of this SqlPlanBaseline. The SQL text. :return: The sql_text of this SqlPlanBaseline. :rtype: str �r+ r? r; r; r< r 9 s zSqlPlanBaseline.sql_textc C s || _ dS )z� Sets the sql_text of this SqlPlanBaseline. The SQL text. :param sql_text: The sql_text of this SqlPlanBaseline. :type: str NrA )r9 r r; r; r< r E s c C s | j S )a� Gets the origin of this SqlPlanBaseline. The origin of the SQL plan baseline. Allowed values for this property are: "ADDM_SQLTUNE", "AUTO_CAPTURE", "AUTO_SQLTUNE", "EVOLVE_AUTO_INDEX_LOAD", "EVOLVE_CREATE_FROM_ADAPTIVE", "EVOLVE_LOAD_FROM_STS", "EVOLVE_LOAD_FROM_AWR", "EVOLVE_LOAD_FROM_CURSOR_CACHE", "MANUAL_LOAD", "MANUAL_LOAD_FROM_AWR", "MANUAL_LOAD_FROM_CURSOR_CACHE", "MANUAL_LOAD_FROM_STS", "MANUAL_SQLTUNE", "STORED_OUTLINE", "UNKNOWN", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :return: The origin of this SqlPlanBaseline. :rtype: str )r, r? r; r; r< r Q s zSqlPlanBaseline.originc C s g d�}t ||�sd}|| _dS )z� Sets the origin of this SqlPlanBaseline. The origin of the SQL plan baseline. :param origin: The origin of this SqlPlanBaseline. :type: str )r r r r r r r r r r r r r r r �UNKNOWN_ENUM_VALUEN)r r, )r9 r �allowed_valuesr; r; r< r ` s c C s | j S )z� **[Required]** Gets the time_created of this SqlPlanBaseline. The date and time when the plan baseline was created. :return: The time_created of this SqlPlanBaseline. :rtype: datetime �r- r? r; r; r< r o s z SqlPlanBaseline.time_createdc C s || _ dS )z� Sets the time_created of this SqlPlanBaseline. The date and time when the plan baseline was created. :param time_created: The time_created of this SqlPlanBaseline. :type: datetime NrD )r9 r r; r; r< r { s c C s | j S )z� Gets the time_last_modified of this SqlPlanBaseline. The date and time when the plan baseline was last modified. :return: The time_last_modified of this SqlPlanBaseline. :rtype: datetime �r. r? r; r; r< r � s z"SqlPlanBaseline.time_last_modifiedc C s || _ dS )z� Sets the time_last_modified of this SqlPlanBaseline. The date and time when the plan baseline was last modified. :param time_last_modified: The time_last_modified of this SqlPlanBaseline. :type: datetime NrE )r9 r r; r; r< r � s c C s | j S )a� Gets the time_last_executed of this SqlPlanBaseline. The date and time when the plan baseline was last executed. **Note:** For performance reasons, database does not update this value immediately after each execution of the plan baseline. Therefore, the plan baseline may have been executed more recently than this value indicates. :return: The time_last_executed of this SqlPlanBaseline. :rtype: datetime �r/ r? r; r; r< r � s z"SqlPlanBaseline.time_last_executedc C s || _ dS )a� Sets the time_last_executed of this SqlPlanBaseline. The date and time when the plan baseline was last executed. **Note:** For performance reasons, database does not update this value immediately after each execution of the plan baseline. Therefore, the plan baseline may have been executed more recently than this value indicates. :param time_last_executed: The time_last_executed of this SqlPlanBaseline. :type: datetime NrF )r9 r r; r; r< r � s c C s | j S )a� Gets the enabled of this SqlPlanBaseline. Indicates whether the plan baseline is enabled (`YES`) or disabled (`NO`). Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :return: The enabled of this SqlPlanBaseline. :rtype: str )r0 r? r; r; r< r � s zSqlPlanBaseline.enabledc C s ddg}t ||�sd}|| _dS )z� Sets the enabled of this SqlPlanBaseline. Indicates whether the plan baseline is enabled (`YES`) or disabled (`NO`). :param enabled: The enabled of this SqlPlanBaseline. :type: str r r rB N)r r0 )r9 r rC r; r; r< r � s c C s | j S )a� Gets the accepted of this SqlPlanBaseline. Indicates whether the plan baseline is accepted (`YES`) or not (`NO`). Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :return: The accepted of this SqlPlanBaseline. :rtype: str )r1 r? r; r; r< r! � s zSqlPlanBaseline.acceptedc C s ddg}t ||�sd}|| _dS )z� Sets the accepted of this SqlPlanBaseline. Indicates whether the plan baseline is accepted (`YES`) or not (`NO`). :param accepted: The accepted of this SqlPlanBaseline. :type: str r r rB N)r r1 )r9 r! rC r; r; r< r! � s c C s | j S )a Gets the fixed of this SqlPlanBaseline. Indicates whether the plan baseline is fixed (`YES`) or not (`NO`). Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :return: The fixed of this SqlPlanBaseline. :rtype: str )r2 r? r; r; r< r" � s zSqlPlanBaseline.fixedc C s ddg}t ||�sd}|| _dS )z� Sets the fixed of this SqlPlanBaseline. Indicates whether the plan baseline is fixed (`YES`) or not (`NO`). :param fixed: The fixed of this SqlPlanBaseline. :type: str r r rB N)r r2 )r9 r" rC r; r; r< r" s c C s | j S )a� Gets the reproduced of this SqlPlanBaseline. Indicates whether the optimizer was able to reproduce the plan (`YES`) or not (`NO`). The value is set to `YES` when a plan is initially added to the plan baseline. Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :return: The reproduced of this SqlPlanBaseline. :rtype: str )r3 r? r; r; r< r# s zSqlPlanBaseline.reproducedc C s ddg}t ||�sd}|| _dS )aK Sets the reproduced of this SqlPlanBaseline. Indicates whether the optimizer was able to reproduce the plan (`YES`) or not (`NO`). The value is set to `YES` when a plan is initially added to the plan baseline. :param reproduced: The reproduced of this SqlPlanBaseline. :type: str r r rB N)r r3 )r9 r# rC r; r; r< r# ) s c C s | j S )a� Gets the auto_purge of this SqlPlanBaseline. Indicates whether the plan baseline is auto-purged (`YES`) or not (`NO`). Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :return: The auto_purge of this SqlPlanBaseline. :rtype: str )r4 r? r; r; r< r$ 9 s zSqlPlanBaseline.auto_purgec C s ddg}t ||�sd}|| _dS )z� Sets the auto_purge of this SqlPlanBaseline. Indicates whether the plan baseline is auto-purged (`YES`) or not (`NO`). :param auto_purge: The auto_purge of this SqlPlanBaseline. :type: str r r rB N)r r4 )r9 r$ rC r; r; r< r$ H s c C s | j S )a" Gets the adaptive of this SqlPlanBaseline. Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not. When a new adaptive plan is found for a SQL statement that has an existing SQL plan baseline, that new plan will be added to the SQL plan baseline as an unaccepted plan, and the `ADAPTIVE` property will be marked `YES`. When this new plan is verified (either manually or via the auto evolve task), the plan will be test executed and the final plan determined at execution will become an accepted plan if its performance is better than the existing plan baseline. At this point, the value of the `ADAPTIVE` property is set to `NO` since the plan is no longer adaptive, but resolved. Allowed values for this property are: "YES", "NO", 'UNKNOWN_ENUM_VALUE'. Any unrecognized values returned by a service will be mapped to 'UNKNOWN_ENUM_VALUE'. :return: The adaptive of this SqlPlanBaseline. :rtype: str )r5 r? r; r; r< r% W s zSqlPlanBaseline.adaptivec C s ddg}t ||�sd}|| _dS )ay Sets the adaptive of this SqlPlanBaseline. Indicates whether a plan that is automatically captured by SQL plan management is marked adaptive or not. When a new adaptive plan is found for a SQL statement that has an existing SQL plan baseline, that new plan will be added to the SQL plan baseline as an unaccepted plan, and the `ADAPTIVE` property will be marked `YES`. When this new plan is verified (either manually or via the auto evolve task), the plan will be test executed and the final plan determined at execution will become an accepted plan if its performance is better than the existing plan baseline. At this point, the value of the `ADAPTIVE` property is set to `NO` since the plan is no longer adaptive, but resolved. :param adaptive: The adaptive of this SqlPlanBaseline. :type: str r r rB N)r r5 )r9 r% rC r; r; r< r% m s c C s | j S )z� Gets the module of this SqlPlanBaseline. The application module name. :return: The module of this SqlPlanBaseline. :rtype: str �r6 r? r; r; r< r& � s zSqlPlanBaseline.modulec C s || _ dS )z� Sets the module of this SqlPlanBaseline. The application module name. :param module: The module of this SqlPlanBaseline. :type: str NrG )r9 r& r; r; r< r& � s c C s | j S )z� Gets the action of this SqlPlanBaseline. The application action. :return: The action of this SqlPlanBaseline. :rtype: str �r7 r? r; r; r< r' � s zSqlPlanBaseline.actionc C s || _ dS )z� Sets the action of this SqlPlanBaseline. The application action. :param action: The action of this SqlPlanBaseline. :type: str NrH )r9 r' r; r; r< r' � s c C s | j S )z� **[Required]** Gets the execution_plan of this SqlPlanBaseline. The execution plan for the SQL statement. :return: The execution_plan of this SqlPlanBaseline. :rtype: str �r8 r? r; r; r< r( � s z SqlPlanBaseline.execution_planc C s || _ dS )z� Sets the execution_plan of this SqlPlanBaseline. The execution plan for the SQL statement. :param execution_plan: The execution_plan of this SqlPlanBaseline. :type: str NrI )r9 r( r; r; r< r( � s c C s t | �S �N)r r? r; r; r< �__repr__� s zSqlPlanBaseline.__repr__c C s |d u r dS | j |j kS )NF)�__dict__�r9 �otherr; r; r< �__eq__� s zSqlPlanBaseline.__eq__c C s | |k S rJ r; rM r; r; r< �__ne__� s zSqlPlanBaseline.__ne__N)5�__name__� __module__� __qualname__�__doc__ZORIGIN_ADDM_SQLTUNEZORIGIN_AUTO_CAPTUREZORIGIN_AUTO_SQLTUNEZ ORIGIN_EVOLVE_AUTO_INDEX_LOADZ"ORIGIN_EVOLVE_CREATE_FROM_ADAPTIVEZORIGIN_EVOLVE_LOAD_FROM_STSZORIGIN_EVOLVE_LOAD_FROM_AWRZ$ORIGIN_EVOLVE_LOAD_FROM_CURSOR_CACHEZORIGIN_MANUAL_LOADZORIGIN_MANUAL_LOAD_FROM_AWRZ$ORIGIN_MANUAL_LOAD_FROM_CURSOR_CACHEZORIGIN_MANUAL_LOAD_FROM_STSZORIGIN_MANUAL_SQLTUNEZORIGIN_STORED_OUTLINEZORIGIN_UNKNOWNZ ENABLED_YESZ ENABLED_NOZ ACCEPTED_YESZ ACCEPTED_NOZ FIXED_YESZFIXED_NOZREPRODUCED_YESZ REPRODUCED_NOZAUTO_PURGE_YESZ AUTO_PURGE_NOZ ADAPTIVE_YESZ ADAPTIVE_NOr= �propertyr �setterr r r r r r r r! r" r# r$ r% r& r' r( rK rO rP r; r; r; r< r s� r N)Zoci.utilr r r Zoci.decoratorsr �objectr r; r; r; r< �<module> s
cải xoăn