File manager - Edit - /usr/local/CyberPanel/lib/python3.10/site-packages/django/db/backends/oracle/__pycache__/base.cpython-310.pyc
Back
o �hrZ � @ s� d Z ddlZddlZddlZddlZddlmZ ddlmZ ddl m Z ddl m Z ddl mZ ddlmZ dd lmZ dd lmZmZ dd lmZ d d � Zeddg� zddlZW n eyl Z ze de ��dZ [ ww 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�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 �T/usr/local/CyberPanel/lib/python3.10/site-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_errorsD s � �� ��r4 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 r5 ^ s r5 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"�dd ddd d#dd dd$d%d&� �Zd'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!dGdH� Z"e#dIdJ� �Z$� fdKdL�Z%e#d^dNdO��Z&dPdQ� Z'dRdS� Z(dTdU� Z)d^dVdW�Z*dXdY� Z+e,dZd[� �Z-e,d\d]� �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)) � 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)rJ rV 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; r0 �kwargsr{ �� __class__r r r} � s � zDatabaseWrapper.__init__c C � | j S r? )�oracle_version�r; r r r �get_database_version� � z$DatabaseWrapper.get_database_versionc 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 s� t � �� | �� }|�d� |�dtjrdnd � |�� d| jvrT| �� }z|�d| jd dg� W n t j yG | j | _ | j | _Y n w | j| _ | j| _|�� d | j_| �� sb| �� 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'� r6 z!SELECT 1 FROM DUAL WHERE DUMMY %srk �X� )r| �init_connection_state� create_cursor�executer �USE_TZr9 r: �_standard_operatorsr. r/ �_likec_operatorsr6 �_likec_pattern_ops� pattern_ops�_standard_pattern_ops� connection� stmtcachesize�get_autocommit�commit�r; r8 r� r r r� s: �� �� � �z%DatabaseWrapper.init_connection_stateNc C � t | j�S r? )� FormatStylePlaceholderCursorr� )r; r r r r r� 0 s z DatabaseWrapper.create_cursorc C s| | j d ur<t| d��( t� � | j �� W d � W d � S 1 s%w Y W d � d S 1 s5w Y d S d S )N�COMMIT)r� r r4 r� r� r r r �_commit4 s R��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_autocommitD 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)r8 r� )r; � table_namesr8 r r r �check_constraintsH s "�z!DatabaseWrapper.check_constraintsc C s( z| j �� W dS tjy Y dS w )NFT)r� �pingr. �Errorr� r r r � is_usableQ s ��zDatabaseWrapper.is_usablec C s t dd� tj�d�D ��S )Nc s � � | ]}t |�V qd S r? ��int�rv r3 r r r � <genexpr>[ � � z4DatabaseWrapper.cx_oracle_version.<locals>.<genexpr>�.)r2 r. �version�splitr� r r r �cx_oracle_versionY � 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� ` r� z1DatabaseWrapper.oracle_version.<locals>.<genexpr>r� )�temporary_connectionr2 r� r� r� r� r r r r� ] s $�z DatabaseWrapper.oracle_versionr? )0r@ rA rB �vendor� display_name� data_types�data_type_check_constraints�_limited_data_typesr5 r6 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� r� � __classcell__r r r� r rC j s� �������� � � � � ������ � � ��� �� + rC 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_datetimer1 r� r r. �Binary� timedeltar �charset�str�lenr� �CLOBrO )r; �paramr8 � strings_only� string_sizer r r r} m s2 �� zOracleParam.__init__N�F)r@ rA rB �__doc__r} 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)r; r� r r r r} � � zVariableWrapper.__init__c C r� r? r� r� r r r r� � r� 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� )r: �setattrr� )r; r� r r r r � __setattr__� s zVariableWrapper.__setattr__N)r@ rA rB r� r} 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 )%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? )r8 �_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 )r8 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� r7 r2 �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 )r1 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>)r1 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 r1 r �dict�fromkeysr� r2 �ranger� r )r; �queryr �unify_by_valuesr0 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 r4 r8 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 8 r z<FormatStylePlaceholderCursor.executemany.<locals>.<listcomp>c r) r )r r r� r r r < r )�iterr( �nextr r4 r8 � 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? )r8 r9 r. �InterfaceErrorr� r r r r9 ? s �z"FormatStylePlaceholderCursor.closec G � t | jj|� �S r? )r� r8 r� �r; r0 r r r r� F � z FormatStylePlaceholderCursor.varc G r1 r? )r� r8 �arrayvarr2 r r r r4 I r3 z%FormatStylePlaceholderCursor.arrayvarc C r� r? )r� r8 )r; �attrr r r r� L r� z(FormatStylePlaceholderCursor.__getattr__c C r� r? )r* r8 r� r r r �__iter__O r� z%FormatStylePlaceholderCursor.__iter__r� r? )r@ rA rB r� r� r} � staticmethodr� r r� r r r r( r� r, r9 r� r4 r� r6 r r r r r� � s* " ! r� )4r� r� r� r r � contextlibr � django.confr �django.core.exceptionsr � django.dbr � django.db.backends.base.baser �django.db.backends.utilsr �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+ r4 r5 rC r� r� r� r r r r �<module> sT �� �� z0
| ver. 1.4 |
Github
|
.
| PHP 8.2.28 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings