|
Server : Apache System : Linux iad1-shared-b8-43 6.6.49-grsec-jammy+ #10 SMP Thu Sep 12 23:23:08 UTC 2024 x86_64 User : dh_edsupp ( 6597262) PHP Version : 8.2.26 Disable Function : NONE Directory : /lib/python3/dist-packages/django/db/backends/oracle/__pycache__/ |
Upload File : |
o
3�a�X �
@ s� d Z ddlZddlZddlZddlZddlmZ ddlmZ ddl m
Z
ddl m Z ddl
mZ ddlmZ dd lmZmZ dd
lmZ d d � Zed
dg� zddlZW n eyf Z ze
de ��dZ[ww ddlm 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 dd � d �Z-G d d � d e�Z.G d d � d �Z/G d!d"� d"�Z0G d#d$� d$�Z1dS )%ze
Oracle database backend for Django.
Requires cx_Oracle: https://oracle.github.io/python-cx_Oracle/
� N)�contextmanager)�settings)�ImproperlyConfigured)�IntegrityError)�BaseDatabaseWrapper)� async_unsafe)� force_bytes� force_str)�cached_propertyc
C s| t �� �� �d�r6zdd l}W n ty! } ztd| ��d }~ww |�d�}| D ]
\}}|�||� q)d S t j
� | � d S )N�CYGWINr z_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.�kernel32) �platform�system�upper�
startswith�ctypes� ImportErrorr �CDLL�SetEnvironmentVariableA�os�environ�update)r r �er �name�value� r �@/usr/lib/python3/dist-packages/django/db/backends/oracle/base.py�_setup_environment s ���
�r )�NLS_LANGz .AL32UTF8)�ORA_NCHAR_LITERAL_REPLACE�TRUEz"Error loading cx_Oracle module: %s� )�DatabaseClient)�DatabaseCreation)�DatabaseFeatures)�DatabaseIntrospection)�DatabaseOperations)�DatabaseSchemaEditor)�Oracle_datetime�dsn)�DatabaseValidationc
c sv � zd V W d S t jy: } z&| jd }t|d�r5t|d�r5|jdkr5d|jv s.d|jv r5tt| j�� �� d } ~ ww )Nr �code�messagei+ z ORA-02291z ORA-00001)�Database�
DatabaseError�args�hasattrr+ r, r �tuple)r �xr r r �wrap_oracle_errors? s �
��
��r3 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 r4 Y s r4 c s� e Zd ZdZdZi dd�dd�dd�d d
�d d �d
d�dd�dd�dd�dd �dd �dd�dd�dd �d d �d d �d!d"�d
dd ddd d#dd dd$d%d&� �Zd'd(d'd)d)d)d*�Zd+Ze� Z d,d-d.d/d0d1d2d3d.d.d/d/d4� Z
i e
�d5d6d5d5d6d6d7��Z d8Z d9d:d;d<d=d>d?�Z
d@dA� e
�� D �ZdBdA� e
�� D �ZeZeZeZeZeZeZe Z e Z � fdCdD�Z dEdF� Z!e"dGdH� �Z#dIdJ� Z$e"d\dLdM��Z%dNdO� Z&dPdQ� Z'dRdS� Z(d\dTdU�Z)dVdW� Z*e+dXdY� �Z,e+dZd[� �Z-� Z.S )]�DatabaseWrapper�oracle�Oracle� AutoFieldz3NUMBER(11) GENERATED BY DEFAULT ON NULL AS IDENTITY� BigAutoFieldz3NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITY� BinaryField�BLOB� BooleanFieldz NUMBER(1)� CharFieldzNVARCHAR2(%(max_length)s)� DateField�DATE�
DateTimeField� TIMESTAMP� DecimalFieldz*NUMBER(%(max_digits)s, %(decimal_places)s)�
DurationFieldz INTERVAL DAY(9) TO SECOND(6)� FileField�
FilePathField�
FloatFieldzDOUBLE PRECISION� IntegerFieldz
NUMBER(11)� JSONField�NCLOB�BigIntegerFieldz
NUMBER(19)�IPAddressFieldz VARCHAR2(15)�GenericIPAddressFieldz VARCHAR2(39)z2NUMBER(5) GENERATED BY DEFAULT ON NULL AS IDENTITYzVARCHAR2(%(max_length)s)z VARCHAR2(32)) �NullBooleanField�
OneToOneField�PositiveBigIntegerField�PositiveIntegerField�PositiveSmallIntegerField� SlugField�SmallAutoField�SmallIntegerField� TextField� TimeField�URLField� UUIDFieldz%(qn_column)s IN (0,1)z%(qn_column)s IS JSONz%(qn_column)s >= 0)rI rU rZ r\ r] r^ )�clob�nclob�blobz= %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) �exact�iexact�contains� icontains�gt�gte�lt�lter �endswith� istartswith� iendswithzLIKEC %s ESCAPE '\'zLIKEC UPPER(%s) ESCAPE '\')rk rl r rq rr rs z@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z
{} || '%%'zUPPER({}) || '%%'z
'%%' || {}z'%%' || UPPER({}))rk rl r rr rq rs c C � 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 rt )zLIKEC z ESCAPE '\'r ru r r r ry � s �c s0 t � j|i |�� | jd �dd�}|| j_d S )N�OPTIONS�use_returning_intoT)�super�__init__�
settings_dict�get�features� can_return_columns_from_insert)r: r/ �kwargsr{ �� __class__r r r} � s zDatabaseWrapper.__init__c C s | j d �� }d|v r|d= |S )Nrz r{ )r~ �copy�r: � conn_paramsr r r �get_connection_params� s z%DatabaseWrapper.get_connection_paramsc C s* t jd| jd | jd t| j�d�|��S )N�USER�PASSWORD)�user�passwordr) r )r- �connectr~ r) r� r r r �get_new_connection� s ��z"DatabaseWrapper.get_new_connectionc C s� | � � }|�d� |�dtjrdnd � |�� d| jvrO| � � }z|�d| jd dg� W n tjyB | j | _
| j | _ Y n w | j| _
| j
| _ |�� d | j_| �� s]| �� d 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'� r5 z!SELECT 1 FROM DUAL WHERE DUMMY %srk �X� )�
create_cursor�executer �USE_TZr8 r9 �_standard_operatorsr- r. �_likec_operatorsr5 �_likec_pattern_ops� pattern_ops�_standard_pattern_ops�
connection�
stmtcachesize�get_autocommit�commit�r: r7 r r r �init_connection_state� s6
��
�� � �z%DatabaseWrapper.init_connection_stateNc C �
t | j�S r> )� FormatStylePlaceholderCursorr� )r: r r r r r� s
z DatabaseWrapper.create_cursorc C sB | j d ur t� �
| j �� W d � S 1 sw Y d S d S r> )r� r3 r� �r: r r r �_commit s
$��zDatabaseWrapper._commitc C s, | j r| j�d| j�|� dd�� d S d S )Nz -- RELEASE SAVEPOINT %s (faked)z0.000)�sql�time)�queries_logged� queries_log�append�ops�
quote_name)r: �sidr r r �_savepoint_commit s ��z!DatabaseWrapper._savepoint_commitc C s4 | j �
|| j_W d � d S 1 sw Y d S r> )�wrap_database_errorsr� �
autocommit)r: r� r r r �_set_autocommit& s
"�z DatabaseWrapper._set_autocommitc C sB | � � �}|�d� |�d� W d � dS 1 sw Y dS )zl
Check constraints by setting them to immediate. Return them to deferred
afterward.
z SET CONSTRAINTS ALL IMMEDIATEz SET CONSTRAINTS ALL DEFERREDN)r7 r� )r: � table_namesr7 r r r �check_constraints* s
"�z!DatabaseWrapper.check_constraintsc C s( z| j �� W dS tjy Y dS w )NFT)r� �pingr- �Errorr� r r r � is_usable3 s ��zDatabaseWrapper.is_usablec C s t dd� tj�d�D ��S )Nc s � � | ]}t |�V qd S r> ��int�rv r2 r r r � <genexpr>= � � z4DatabaseWrapper.cx_oracle_version.<locals>.<genexpr>�.)r1 r- �version�splitr� r r r �cx_oracle_version; � z!DatabaseWrapper.cx_oracle_versionc C sH | � � � tdd� | jj�d�D ��W d � S 1 s w Y d S )Nc s r� r> r� r� r r r r� B r� z1DatabaseWrapper.oracle_version.<locals>.<genexpr>r� )�temporary_connectionr1 r� r� r� r� r r r �oracle_version? s
$�z DatabaseWrapper.oracle_versionr> )/r? r@ rA �vendor� display_name�
data_types�data_type_check_constraints�_limited_data_typesr4 r5 r� r� � pattern_esc� _pattern_ops�itemsr� r� r- r' �SchemaEditorClassr" � client_classr# �creation_classr$ �features_classr% �introspection_classr& � ops_classr* �validation_classr} r� r r� r� r� r� r� r� r� r� r
r� r� �
__classcell__r r r� r rB f s� �������� �
� � �
������ �
���� ��
(
rB 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 jrt|tj�rt|t�st�|�}d}|du r d}n|du r"d}t|d�r.|�|�| _n$t|t j
tj f�r;|| _nt ||j
|�| _t| jt�rRtt||j
|��}t|d�r]|j| _d S |dkrgt j| _d S t|tj�rst j| _d S d | _d S )Nr Tr! F�bind_parameter�
input_sizei� )r r� �
isinstance�datetimer( �
from_datetimer0 r� r r- �Binary� timedeltar �charset�str�lenr� �CLOBrN )r: �paramr7 � strings_only� string_sizer r r r} O s. �
zOracleParam.__init__N�F)r? r@ rA �__doc__r} r r r r r� E 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)r: r� r r r r} { �
zVariableWrapper.__init__c C s | j S r> r� r� r r r r� ~ s z VariableWrapper.bind_parameterc C � t | j|�S r> )�getattrr� )r: �keyr r r � __getattr__� � zVariableWrapper.__getattr__c C s( |dkr || j |< d S t| j||� d S )Nr� )r9 �setattrr� )r: r� r r r r � __setattr__� s zVariableWrapper.__setattr__N)r? r@ rA r� r} r� r� r� r r r r r� s 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 )%r� 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> )r7 �_output_type_handler�outputtypehandler)r: r� r r r r} � s
z%FormatStylePlaceholderCursor.__init__c C s d| v r t �| �S t| �S )Nr� )�decimal�Decimalr� )r r r r �_output_number_converter� r� z5FormatStylePlaceholderCursor._output_number_converterc s8 |dkrt S tj| d�� t�d��| ��� �fdd�S )Nr )�precr! c s t �| �j�� d�S )N)�context)r� r� �quantize)rx �r� �quantize_valuer r �<lambda>� � 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 jkr-|dkr|dkrtj}nt}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- �NUMBERr� r� �floatr� r� �STRINGr )r7 r � defaultType�lengthr� r� r r r r r� � s
��z1FormatStylePlaceholderCursor._output_type_handlerc sB z � fdd�|� � D �W S ty t� fdd�|D �� Y S w )Nc s i | ] \}}|t |� d ��qS )T�r� ru r� r r ry � s z?FormatStylePlaceholderCursor._format_params.<locals>.<dictcomp>c 3 s � | ] }t |� d �V qdS )TNr �rv �pr� r r r� � s � z>FormatStylePlaceholderCursor._format_params.<locals>.<genexpr>)r� r6 r1 �r: �paramsr r� r �_format_params� s
�z+FormatStylePlaceholderCursor._format_paramsc C s� t |d d�r-i }|D ]}|�� D ] \}}|jr |j||< qq |r+| jdi |�� d S d S d gt|d � }|D ]}t|�D ] \}}|jrJ|j||< q>q8|rU| j|� d S d S )Nr �keysr )r0 r� r� �
setinputsizesr� � enumerate)r: � params_list�sizesr rw r �ir r r �_guess_input_sizes� s*
���
���z/FormatStylePlaceholderCursor._guess_input_sizesc C s* t |d�rdd� |�� D �S dd� |D �S )Nr� c S s i | ]\}}||j �qS r �r ru r r r ry � s zAFormatStylePlaceholderCursor._param_generator.<locals>.<dictcomp>c S s g | ]}|j �qS r r r r r r �
<listcomp>� s zAFormatStylePlaceholderCursor._param_generator.<locals>.<listcomp>)r0 r� r r r r �_param_generator� s
z-FormatStylePlaceholderCursor._param_generatorFc s� |� d�s
|� d�r|d d� }|d u rg }nKt|d�r(dd� |D �}|| }n:|rQ|rQdd� tt�|��D �� � fdd �|D �}d
d� � �� D �}|t|� }nd d � tt|��D �}|t|� }|| � |�fS ) N�;�/���r c S s i | ]}|d | �qS )z:%sr )rv rw r r r ry � � z@FormatStylePlaceholderCursor._fix_for_params.<locals>.<dictcomp>c S s i | ] \}}|d | �qS �z:arg%dr )rv r r� r r r ry � s ��c s g | ]}� | �qS r r )rv r� �� params_dictr r r � r� z@FormatStylePlaceholderCursor._fix_for_params.<locals>.<listcomp>c S s i | ]\}}||�qS r r )rv r� r r r r ry � r c S s g | ]}d | �qS r r )rv r r r r r r� )
rq r0 r �dict�fromkeysr� r1 �ranger� r
)r: �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 s(w Y d S )NT)r# )r$ r r3 r7 r� r )r: r" r r r r r� s
$�z$FormatStylePlaceholderCursor.executec s� |sd S t |�}� �|t|��\}}|g� fdd�|D � }� �|� t� � � j�|� fdd�|D ��W d � S 1 s?w Y d S )Nc � g | ]}� � |��qS r )r
r r� r r r r z<FormatStylePlaceholderCursor.executemany.<locals>.<listcomp>c r% r )r r r� r r r r )�iterr$ �nextr r3 r7 � executemany)r: r" r � params_iter� firstparams� formattedr r� r r(
s
$�z(FormatStylePlaceholderCursor.executemanyc C s( z| j �� W d S tjy Y d S w r> )r7 r8 r- �InterfaceErrorr� r r r r8 s
�z"FormatStylePlaceholderCursor.closec G � t | jj|� �S r> )r� r7 r� �r: r/ r r r r� " � z FormatStylePlaceholderCursor.varc G r- r> )r� r7 �arrayvarr. r r r r0 % r/ z%FormatStylePlaceholderCursor.arrayvarc C r� r> )r� r7 )r: �attrr r r r� ( r� z(FormatStylePlaceholderCursor.__getattr__c C r� r> )r& r7 r� r r r �__iter__+ r� z%FormatStylePlaceholderCursor.__iter__r� r> )r? r@ rA r� r� r} � staticmethodr� r� r� r
r r r$ r� r( r8 r� r0 r� r2 r r r r r� � s*
"
r� )2r� r� r� r r
�
contextlibr � django.confr �django.core.exceptionsr � django.dbr � django.db.backends.base.baser �django.utils.asyncior �django.utils.encodingr r �django.utils.functionalr
r � cx_Oracler- r r �clientr" �creationr# r� r$ �
introspectionr% �
operationsr& �schemar' �utilsr( r) �
validationr* r3 r4 rB r� r� r� r r r r �<module> sP � ��
`.