OwlCyberSecurity - MANAGER
Edit File: base.cpython-39.pyc
a ���erZ � @ s� d Z ddlZddlZddlZddlZddlmZ ddlmZ ddl m Z ddl m Z ddl mZ ddlmZ dd lmZ dd lmZmZ dd lmZ d d � Zeddg� z ddlZW n0 ey� Z ze de ��W Y dZ [ n dZ [ 0 0 ddl m Z ddl m Z ddl!m"Z" ddl#m$Z$ ddl%m&Z& ddl'm(Z( ddl)m*Z*m+Z+ ddl,m-Z- edd� �Z.G d d � d �Z/G d d � d e�Z0G d d!� d!�Z1G d"d#� d#�Z2G d$d%� d%�Z3dS )&ze Oracle database backend for Django. Requires cx_Oracle: https://oracle.github.io/python-cx_Oracle/ � N)�contextmanager)�settings)�ImproperlyConfigured)�IntegrityError)�BaseDatabaseWrapper)�debug_transaction)� async_unsafe)� force_bytes� force_str)�cached_propertyc C s� t �� �� �d�rvz dd l}W n0 tyN } ztd| ��W Y d }~n d }~0 0 |�d�}| D ]\}}|�||� q^n t j � | � d S )NZCYGWINr z_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.�kernel32) �platform�system�upper� startswith�ctypes� ImportErrorr �CDLLZSetEnvironmentVariableA�os�environ�update)r r �er �name�value� r �_/home/gouroczh/virtualenv/pat/3.9/lib/python3.9/site-packages/django/db/backends/oracle/base.py�_setup_environment s �� r )ZNLS_LANGz .AL32UTF8)ZORA_NCHAR_LITERAL_REPLACE�TRUEz"Error loading cx_Oracle module: %s� )�DatabaseClient)�DatabaseCreation)�DatabaseFeatures)�DatabaseIntrospection)�DatabaseOperations)�DatabaseSchemaEditor)�Oracle_datetime�dsn)�DatabaseValidationc c s� z d V W nr t jy| } zX| jd }t|d�rft|d�rf|jdkrfd|jv sXd|jv rftt| j�� �� W Y d } ~ n d } ~ 0 0 d S )Nr �code�messagei+ z ORA-02291z ORA-00001)�Database� DatabaseError�args�hasattrr( r) r �tuple)r �xr r r �wrap_oracle_errorsD s �����r0 c @ s e Zd Zddd�ZdS )�!_UninitializedOperatorsDescriptorNc C s& |d u rt d��|�� �� |jd S )Nz*operators not available as class attribute� operators)�AttributeError�cursor�close�__dict__)�self�instance�clsr r r �__get___ s z)_UninitializedOperatorsDescriptor.__get__)N)�__name__� __module__� __qualname__r: r r r r r1 ^ s r1 c s� e Zd ZdZdZddddddd d d ddd d ddddd dd d ddd dd ddd� Zdddddd�ZdZe� Z dd d d d d d!d"d d d d d#� Z i e �d$d%d$d$d%d%d&��Z d'Z d(d)d*d+d,d-d.�Z d/d0� e �� D �Zd1d0� e �� D �ZeZeZeZeZeZeZe Z e Z � fd2d3�Z d4d5� Z!d6d7� Z"e#d8d9� �Z$� fd:d;�Z%e#dMd=d>��Z&d?d@� Z'dAdB� Z(dCdD� Z)dNdEdF�Z*dGdH� Z+e,dIdJ� �Z-e,dKdL� �Z.� Z/S )O�DatabaseWrapper�oracleZOraclez3NUMBER(11) GENERATED BY DEFAULT ON NULL AS IDENTITYz3NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITYZBLOBz NUMBER(1)zNVARCHAR2(%(max_length)s)ZDATE� TIMESTAMPz*NUMBER(%(max_digits)s, %(decimal_places)s)z INTERVAL DAY(9) TO SECOND(6)zDOUBLE PRECISIONz NUMBER(11)ZNCLOBz NUMBER(19)z VARCHAR2(15)z VARCHAR2(39)z2NUMBER(5) GENERATED BY DEFAULT ON NULL AS IDENTITYzVARCHAR2(%(max_length)s)z VARCHAR2(32)) Z AutoFieldZ BigAutoFieldZ BinaryField� BooleanFieldZ CharFieldZ DateFieldZ DateTimeFieldZ DecimalFieldZ DurationFieldZ FileFieldZ FilePathFieldZ FloatFieldZ IntegerField� JSONFieldZBigIntegerFieldZIPAddressFieldZGenericIPAddressFieldZ OneToOneField�PositiveBigIntegerField�PositiveIntegerField�PositiveSmallIntegerFieldZ SlugFieldZSmallAutoFieldZSmallIntegerFieldZ TextFieldZ TimeFieldZURLFieldZ UUIDFieldz%(qn_column)s IN (0,1)z%(qn_column)s IS JSONz%(qn_column)s >= 0)rA rB rC rD rE )ZclobZnclobZblobz= %sz = UPPER(%s)zFLIKE TRANSLATE(%s USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)zMLIKE UPPER(TRANSLATE(%s USING NCHAR_CS)) ESCAPE TRANSLATE('\' USING NCHAR_CS)z> %sz>= %sz< %sz<= %s) �exactZiexact�contains� icontains�gtZgte�ltZlter �endswith� istartswith� iendswithzLIKEC %s ESCAPE '\'zLIKEC UPPER(%s) ESCAPE '\')rG rH r rK rL rM z@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z {} || '%%'zUPPER({}) || '%%'z '%%' || {}z'%%' || UPPER({}))rG rH r rL rK rM c C s i | ]\}}|d | d �qS )zLIKE TRANSLATE( z5 USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)r ��.0�k�vr r r � <dictcomp>� s �zDatabaseWrapper.<dictcomp>c C s i | ]\}}|d | d �qS )zLIKEC z ESCAPE '\'r rN r r r rR � s c s0 t � j|i |�� | jd �dd�}|| j_d S )N�OPTIONS�use_returning_intoT)�super�__init__� settings_dict�get�featuresZ can_return_columns_from_insert)r7 r, �kwargsrT �� __class__r r rV � s �zDatabaseWrapper.__init__c C s | j S �N)�oracle_version�r7 r r r �get_database_version� s z$DatabaseWrapper.get_database_versionc C s | j d �� }d|v r |d= |S )NrS rT )rW �copy�r7 Z conn_paramsr r r �get_connection_params� s z%DatabaseWrapper.get_connection_paramsc C s* t jf | jd | jd t| j�d�|��S )N�USERZPASSWORD)�user�passwordr& )r* �connectrW r& rb r r r �get_new_connection� s ��z"DatabaseWrapper.get_new_connectionc s� t � �� | �� }|�d� |�dtjr,dnd � |�� d| jvr�| �� }z |�d| jd dg� W n$ t j y� | j | _ | j | _Y n0 | j| _ | j| _|�� d | j_| �� s�| �� d S ) Nz+ALTER SESSION SET NLS_TERRITORY = 'AMERICA'zmALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS' NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF'z TIME_ZONE = 'UTC'� r2 z!SELECT 1 FROM DUAL WHERE DUMMY %srG �X� )rU �init_connection_state� create_cursor�executer �USE_TZr5 r6 �_standard_operatorsr* r+ �_likec_operatorsr2 �_likec_pattern_opsZ pattern_ops�_standard_pattern_ops� connectionZ stmtcachesizeZget_autocommit�commit�r7 r4 r[ r r rl s6 �� ��z%DatabaseWrapper.init_connection_stateNc C s t | j�S r] )� FormatStylePlaceholderCursorrt )r7 r r r r rm 0 s z DatabaseWrapper.create_cursorc C sv | j d urrt| d��N t� �( | j �� W d � W d � S 1 sJ0 Y W d � n1 sh0 Y d S )NZCOMMIT)rt r r0 ru r_ r r r �_commit4 s zDatabaseWrapper._commitc C s( | j r$| j�d| j�|� dd�� d S )Nz -- RELEASE SAVEPOINT %s (faked)z0.000)�sql�time)Zqueries_loggedZ queries_log�append�opsZ quote_name)r7 Zsidr r r �_savepoint_commit; s ��z!DatabaseWrapper._savepoint_commitc C s2 | j � || j_W d � n1 s$0 Y d S r] )Zwrap_database_errorsrt � autocommit)r7 r~ r r r �_set_autocommitD s z DatabaseWrapper._set_autocommitc C s@ | � � �$}|�d� |�d� W d � n1 s20 Y dS )zl Check constraints by setting them to immediate. Return them to deferred afterward. z SET CONSTRAINTS ALL IMMEDIATEz SET CONSTRAINTS ALL DEFERREDN)r4 rn )r7 Z table_namesr4 r r r �check_constraintsH s z!DatabaseWrapper.check_constraintsc C s. z| j �� W n tjy$ Y dS 0 dS d S )NFT)rt Zpingr* �Errorr_ r r r � is_usableQ s zDatabaseWrapper.is_usablec C s t dd� tj�d�D ��S )Nc s s | ]}t |�V qd S r] ��int�rO r/ r r r � <genexpr>[ � z4DatabaseWrapper.cx_oracle_version.<locals>.<genexpr>�.)r. r* �version�splitr_ r r r �cx_oracle_versionY s z!DatabaseWrapper.cx_oracle_versionc C sH | � � �, tdd� | jj�d�D ��W d � S 1 s:0 Y d S )Nc s s | ]}t |�V qd S r] r� r� r r r r� ` r� z1DatabaseWrapper.oracle_version.<locals>.<genexpr>r� )Ztemporary_connectionr. rt r� r� r_ r r r r^ ] s z DatabaseWrapper.oracle_version)N)N)0r; r< r= �vendorZ display_name� data_typesZdata_type_check_constraintsZ_limited_data_typesr1 r2 rp rq Z pattern_escZ _pattern_ops�itemsrs rr r* r$ ZSchemaEditorClassr Z client_classr Zcreation_classr! Zfeatures_classr" Zintrospection_classr# Z ops_classr' Zvalidation_classrV r` rc r rh rl rm rx r} r r� r� r r� r^ � __classcell__r r r[ r r> j s� � � � ��� �� + r> c @ s e Zd ZdZddd�ZdS )� OracleParama� Wrapper object for formatting parameters for Oracle. If the string representation of the value is large enough (greater than 4000 characters) the input size needs to be set as CLOB. Alternatively, if the parameter has an `input_size` attribute, then the value of the `input_size` attribute will be used instead. Otherwise, no input size will be set for the parameter when executing the query. Fc C s� t jr&t|tj�r&t|t�s&t�|�}d}|du r8d}n |du rDd}t|d�r\|�|�| _nHt|t j tj f�rv|| _n.t ||j |�| _t| jt�r�tt||j |��}t|d�r�|j| _n.|dkr�t j| _n t|tj�r�t j| _nd | _d S )Nr Tr F�bind_parameter� input_sizei� )r ro � isinstance�datetimer% � from_datetimer- r� r r* �Binary� timedeltar �charset�str�lenr� ZCLOBr@ )r7 �paramr4 Z strings_onlyZ string_sizer r r rV m s2 �� zOracleParam.__init__N)F)r; r< r= �__doc__rV r r r r r� c s r� c @ s0 e Zd ZdZdd� Zdd� Zdd� Zdd � Zd S ) �VariableWrappera An adapter class for cursor variables that prevents the wrapped object from being converted into a string when used to instantiate an OracleParam. This can be used generally for any other object that should be passed into Cursor.execute as-is. c C s || _ d S r] ��var)r7 r� r r r rV � s zVariableWrapper.__init__c C s | j S r] r� rv r r r r� � s z VariableWrapper.bind_parameterc C s t | j|�S r] )�getattrr� )r7 �keyr r r � __getattr__� s zVariableWrapper.__getattr__c C s& |dkr|| j |< nt| j||� d S )Nr� )r6 �setattrr� )r7 r� r r r r � __setattr__� s zVariableWrapper.__setattr__N)r; r< r= r� rV r� r� r� r r r r r� � s r� c @ s� e Zd ZdZdZdd� Zedd� �Zedd� �Zed d � �Z d d � Z d d� Z dd� Z d#dd�Z d$dd�Zd%dd�Zdd� Zdd � Zd d � Zd d � Zd!d"� ZdS )&rw z� Django uses "format" (e.g. '%s') style placeholders, but Oracle uses ":var" style. This fixes it -- but note that if you want to use a literal "%s" in a query, you'll need to use "%%s". zutf-8c C s |� � | _ | j| j _d S r] )r4 �_output_type_handlerZoutputtypehandler)r7 rt r r r rV � s z%FormatStylePlaceholderCursor.__init__c C s d| v rt �| �S t| �S )Nr� )�decimal�Decimalr� )r r r r �_output_number_converter� s z5FormatStylePlaceholderCursor._output_number_converterc s8 |dkr t S tj| d�� t�d��| ��� �fdd�S )Nr )�precr c s t �| �j�� d�S )N)�context)r� r� �quantize)rQ �r� Zquantize_valuer r �<lambda>� r� zEFormatStylePlaceholderCursor._get_decimal_converter.<locals>.<lambda>)r� r� �Contextr� �scaleb)� precision�scaler r� r �_get_decimal_converter� s z3FormatStylePlaceholderCursor._get_decimal_converterc C s^ |t jkrZ|dkr(|dkr"tj}qDt}n |dkr>t�||�}ntj}| jt jd| j|d�S dS )zx Called for each db column fetched from cursors. Return numbers as the appropriate Python type. i����r � )�size� arraysize� outconverterN) r* �NUMBERrw r� �floatr� r� �STRINGr� )r4 r Z defaultType�lengthr� r� r� r r r r� � s ��z1FormatStylePlaceholderCursor._output_type_handlerc sF z� fdd�|� � D �W S ty@ t� fdd�|D �� Y S 0 d S )Nc s i | ]\}}|t |� d ��qS )T�r� rN r_ r r rR � r� z?FormatStylePlaceholderCursor._format_params.<locals>.<dictcomp>c 3 s | ]}t |� d �V qdS )TNr� �rO �pr_ r r r� � r� z>FormatStylePlaceholderCursor._format_params.<locals>.<genexpr>)r� r3 r. �r7 �paramsr r_ r �_format_params� s z+FormatStylePlaceholderCursor._format_paramsc C s� t |d d�rTi }|D ]&}|�� D ]\}}|jr"|j||< q"q|r�| jf i |�� nLd gt|d � }|D ]&}t|�D ]\}}|jrv|j||< qvqj|r�| j|� d S )Nr �keys)r- r� r� Z setinputsizesr� � enumerate)r7 Z params_list�sizesr� rP r �ir r r �_guess_input_sizes� s z/FormatStylePlaceholderCursor._guess_input_sizesc C s. t |d�r dd� |�� D �S dd� |D �S d S )Nr� c S s i | ]\}}||j �qS r �r rN r r r rR r� zAFormatStylePlaceholderCursor._param_generator.<locals>.<dictcomp>c S s g | ] }|j �qS r r� r� r r r � <listcomp> r� zAFormatStylePlaceholderCursor._param_generator.<locals>.<listcomp>)r- r� r� r r r �_param_generator s z-FormatStylePlaceholderCursor._param_generatorFc s� |� d�s|� d�r |d d� }|d u r.g }n�t|d�rPdd� |D �}||; }nt|r�|r�dd� tt�|��D �� � fdd �|D �}d d� � �� D �}|t|�; }n"d d � tt|��D �}|t|�; }|| � |�fS ) N�;�/���r� c S s i | ]}|d | �qS )z:%sr )rO rP r r r rR r� z@FormatStylePlaceholderCursor._fix_for_params.<locals>.<dictcomp>c S s i | ]\}}|d | �qS �z:arg%dr )rO r� r� r r r rR s c s g | ] }� | �qS r r )rO r� �� params_dictr r r� r� z@FormatStylePlaceholderCursor._fix_for_params.<locals>.<listcomp>c S s i | ]\}}||�qS r r )rO r� r r r r rR ! r� c S s g | ] }d | �qS r� r )rO r� r r r r� % r� ) rK r- r� �dict�fromkeysr� r. �ranger� r� )r7 �queryr� �unify_by_valuesr, r r� r �_fix_for_params s" � z,FormatStylePlaceholderCursor._fix_for_paramsNc C s^ | j ||dd�\}}| �|g� t� �$ | j�|| �|��W d � S 1 sP0 Y d S )NT)r� )r� r� r0 r4 rn r� )r7 r� r� r r r rn ) s z$FormatStylePlaceholderCursor.executec s� |sd S t |�}� �|t|��\}}|g� fdd�|D � }� �|� t� �, � j�|� fdd�|D ��W d � S 1 s~0 Y d S )Nc s g | ]}� � |��qS r )r� r� r_ r r r� 8 r� z<FormatStylePlaceholderCursor.executemany.<locals>.<listcomp>c s g | ]}� � |��qS r )r� r� r_ r r r� < r� )�iterr� �nextr� r0 r4 � executemany)r7 r� r� Z params_iterZ firstparams� formattedr r_ r r� / s �z(FormatStylePlaceholderCursor.executemanyc C s( z| j �� W n tjy" Y n0 d S r] )r4 r5 r* ZInterfaceErrorr_ r r r r5 ? s z"FormatStylePlaceholderCursor.closec G s t | jj|� �S r] )r� r4 r� �r7 r, r r r r� F s z FormatStylePlaceholderCursor.varc G s t | jj|� �S r] )r� r4 �arrayvarr� r r r r� I s z%FormatStylePlaceholderCursor.arrayvarc C s t | j|�S r] )r� r4 )r7 �attrr r r r� L s z(FormatStylePlaceholderCursor.__getattr__c C s t | j�S r] )r� r4 r_ r r r �__iter__O s z%FormatStylePlaceholderCursor.__iter__)F)N)N)r; r< r= r� r� rV � staticmethodr� r� r� r� r� r� r� rn r� r5 r� r� r� r� r r r r rw � s( " ! rw )4r� r� r� r r � contextlibr Z django.confr Zdjango.core.exceptionsr Z django.dbr Z django.db.backends.base.baser Zdjango.db.backends.utilsr Zdjango.utils.asyncior Zdjango.utils.encodingr r Zdjango.utils.functionalr r Z cx_Oracler* r r �clientr Zcreationr rY r! Z introspectionr" � operationsr# Zschemar$ �utilsr% r& Z validationr' r0 r1 r> r� r� rw r r r r �<module> sN �� " z0