o Fh[^@s|dZddlZddlZddlZddlZddlmZddlmZddl m Z ddl m Z ddl mZddlmZdd lmZdd lmZdd lmZmZdd lmZdd lmZddZeddgddlmZddl m!Z!ddl"m#Z#ddl$m%Z%ddl&m'Z'ddl(m)Z)ddl*m+Z+m,Z,ddl-m.Z.eddZ/GdddZ0Gdd d eZ1Gd!d"d"Z2Gd#d$d$Z3Gd%d&d&Z4dS)'zc Oracle database backend for Django. Requires oracledb: https://oracle.github.io/python-oracledb/ N)contextmanager)settings)ImproperlyConfigured)IntegrityError)BaseDatabaseWrapper)oracledb)debug_transaction) async_unsafe) force_bytes force_str)cached_property)get_version_tuplec Cs|tdr6zddl}Wnty!}ztd|d}~ww|d}|D] \}}|||q)dSt j |dS)NCYGWINrz_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.kernel32) platformsystemupper startswithctypes ImportErrorrCDLLSetEnvironmentVariableAosenvironupdate)rrernamevaluerW/var/www/html/loop/nvenv/lib/python3.10/site-packages/django/db/backends/oracle/base.py_setup_environments    r )NLS_LANGz .AL32UTF8)ORA_NCHAR_LITERAL_REPLACETRUE)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)Oracle_datetimedsn)DatabaseValidationc csvzdVWdStjy:}z&|jd}t|dr5t|dr5|jdkr5d|jvs.d|jvr5tt|jd}~ww)Nrcodemessagei+z ORA-02291z ORA-00001)Database DatabaseErrorargshasattrr.r/rtuple)rxrrrwrap_oracle_errorsCs   r6c@seZdZdddZdS)!_UninitializedOperatorsDescriptorNcCs&|durtd||jdS)Nz*operators not available as class attribute operators)AttributeErrorcursorclose__dict__)selfinstanceclsrrr__get__^s  z)_UninitializedOperatorsDescriptor.__get__N)__name__ __module__ __qualname__r@rrrrr7]sr7c seZdZdZdZiddddddd d d d d ddddddddd dd dddddddddd d!d"ddddd d#dddd$d%d& Zd'd(d)d)d)d*Zd+ZeZ d,d-d.d/d0d1d2d3d.d.d/d/d4 Z ie d5d6d5d5d6d6d7Z d8Z d9d:d;dd?Z d@dAe DZdBdAe DZeZeZeZeZeZeZeZeZfdCdDZ dEdFZ!dGdHZ"e#dIdJZ$fdKdLZ%e#d^dNdOZ&dPdQZ'dRdSZ(dTdUZ)d^dVdWZ*dXdYZ+e,dZd[Z-e,d\d]Z.Z/S)_DatabaseWrapperoracleOracle AutoFieldz3NUMBER(11) GENERATED BY DEFAULT ON NULL AS IDENTITY BigAutoFieldz3NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITY BinaryFieldBLOB BooleanFieldz NUMBER(1) CharFieldzNVARCHAR2(%(max_length)s) DateFieldDATE DateTimeField TIMESTAMP DecimalFieldz*NUMBER(%(max_digits)s, %(decimal_places)s) DurationFieldzINTERVAL DAY(9) TO SECOND(6) FileField FilePathField FloatFieldzDOUBLE PRECISION IntegerFieldz NUMBER(11) JSONFieldNCLOBBigIntegerFieldz NUMBER(19)IPAddressFieldz VARCHAR2(15)GenericIPAddressFieldz VARCHAR2(39)z2NUMBER(5) GENERATED BY DEFAULT ON NULL AS IDENTITYzVARCHAR2(%(max_length)s)z VARCHAR2(32)) OneToOneFieldPositiveBigIntegerFieldPositiveIntegerFieldPositiveSmallIntegerField SlugFieldSmallAutoFieldSmallIntegerField TextField TimeFieldURLField UUIDFieldz%(qn_column)s IN (0,1)z%(qn_column)s IS JSONz%(qn_column)s >= 0)rLrXr^r_r`)clobnclobblobz= %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) exactiexactcontains icontainsgtgteltlterendswith istartswith iendswithzLIKEC %s ESCAPE '\'zLIKEC UPPER(%s) ESCAPE '\')rmrnrrsrtruz@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z {} || '%%'zUPPER({}) || '%%'z '%%' || {}z'%%' || UPPER({}))rmrnrrtrsrucCi|] \}}|d|dqS)zLIKE TRANSLATE( z5 USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)r.0kvrrr s zDatabaseWrapper.cCrv)zLIKEC z ESCAPE '\'rrwrrrr{scs0tj|i||jddd}||j_dS)NOPTIONSuse_returning_intoT)super__init__ settings_dictgetfeaturescan_return_columns_from_insert)r=r2kwargsr} __class__rrrs   zDatabaseWrapper.__init__cC|jSrA)oracle_versionr=rrrget_database_versionz$DatabaseWrapper.get_database_versioncCs |jd}d|vr|d=|S)Nr|r})rcopyr= conn_paramsrrrget_connection_paramssz%DatabaseWrapper.get_connection_paramscCs*tjd|jd|jdt|jd|S)NUSERPASSWORD)userpasswordr,r)r0connectrr,rrrrget_new_connectionsz"DatabaseWrapper.get_new_connectioncst|}|d|dtjrdnd|d|jvrT|}z|d|jddgWnt j yG|j |_ |j |_Yn w|j|_ |j|_|d |j_|sb|dSdS) 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'r8z!SELECT 1 FROM DUAL WHERE DUMMY %srmX)r~init_connection_state create_cursorexecuterUSE_TZr;r<_standard_operatorsr0r1_likec_operatorsr8_likec_pattern_ops pattern_ops_standard_pattern_ops connection stmtcachesizeget_autocommitcommitr=r:rrrrs:      z%DatabaseWrapper.init_connection_stateNcCs t|j|SrA)FormatStylePlaceholderCursorr)r=rrrrr/s zDatabaseWrapper.create_cursorc Cs||jdur[sz1DatabaseWrapper.oracle_version...)temporary_connectionr4rversionsplitrrrrrXs $zDatabaseWrapper.oracle_versioncCs ttjSrA)r r0 __version__rrrroracledb_version]s z DatabaseWrapper.oracledb_versionrA)0rBrCrDvendor display_name data_typesdata_type_check_constraints_limited_data_typesr7r8rr pattern_esc _pattern_opsitemsrrr0r*SchemaEditorClassr% client_classr&creation_classr'features_classr(introspection_classr) ops_classr-validation_classrrrr rrrrrrrrr rr __classcell__rrrrrEis          +    rEc@seZdZdZdddZdS) 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. FcCstjrt|tjrt|tst|}d}|jjj}|s)|dur#d}n|dur)d}t |dr5| ||_ n$t|t j tjfrB||_ nt||j||_ t|j trYtt ||j|}t |drd|j|_dS|dkrnt j|_dSt|tjrzt j|_dS|rt|trt j|_dSd|_dS)NrTr$Fbind_parameter input_sizei)rr isinstancedatetimer+ from_datetimedatabaser&supports_boolean_expr_in_select_clauser3rr r0Binary timedeltar charsetstrlenrCLOBrQboolDB_TYPE_BOOLEAN)r=paramr: strings_only string_sizehas_boolean_data_typerrrrls<           zOracleParam.__init__NF)rBrCrD__doc__rrrrrrbs rc@s0eZdZdZddZddZddZdd 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. cCs ||_dSrAvar)r=rrrrr zVariableWrapper.__init__cCrrArrrrrrrzVariableWrapper.bind_parametercC t|j|SrA)getattrr)r=keyrrr __getattr__ zVariableWrapper.__getattr__cCs(|dkr ||j|<dSt|j||dS)Nr)r<setattrr)r=rrrrr __setattr__szVariableWrapper.__setattr__N)rBrCrDrrrrrrrrrrs  rc@seZdZdZdZddZeddZeddZed d Z d d Z d dZ ddZ d#ddZ d$ddZd$ddZddZddZddZdd Zd!d"ZdS)%rz 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-8cCs||_|j|j_||_dSrA)r:_output_type_handleroutputtypehandlerr)r=rrrrrrs   z%FormatStylePlaceholderCursor.__init__cCsd|vr t|St|S)Nr)decimalDecimalr)rrrr_output_number_convertersz5FormatStylePlaceholderCursor._output_number_convertercs8|dkrtStj|dtd| fddS)Nr)precr$cst|jdS)N)context)rrquantize)rzrquantize_valuerrzEFormatStylePlaceholderCursor._get_decimal_converter..)rrContextrscaleb) precisionscalerrr_get_decimal_converters  z3FormatStylePlaceholderCursor._get_decimal_convertercCsz|tjkr-|dkr|dkrtj}nt}n|dkrt||}ntj}|jtjd|j|dS|tj kr;|jtj |jdSdS)z Called for each db column fetched from cursors. Return numbers as the appropriate Python type, and NCLOB with JSON as strings. ir)size arraysize outconverter)rN) r0NUMBERrrfloatrrSTRINGr DB_TYPE_NCLOB)r:r defaultTypelengthrrrrrrrs&  z1FormatStylePlaceholderCursor._output_type_handlercsBz fdd|DWSty tfdd|DYSw)Ncsi|] \}}|t|dqS)Trrwrrrr{sz?FormatStylePlaceholderCursor._format_params..c3s|] }t|dVqdS)TNrrxprrrrsz>FormatStylePlaceholderCursor._format_params..)rr9r4r=paramsrrr_format_paramss  z+FormatStylePlaceholderCursor._format_paramscCst|ddr-i}|D]}|D] \}}|jr|j||<qq |r+|jdi|dSdSdgt|d}|D]}t|D] \}}|jrJ|j||<q>q8|rU|j|dSdS)Nrkeysr)r3rr setinputsizesr enumerate)r= params_listsizesrryrirrr_guess_input_sizess*  z/FormatStylePlaceholderCursor._guess_input_sizescCs*t|drdd|DSdd|DS)NrcSsi|]\}}||jqSrr rwrrrr{zAFormatStylePlaceholderCursor._param_generator..cSsg|]}|jqSrrrrrr szAFormatStylePlaceholderCursor._param_generator..)r3rrrrr_param_generator s z-FormatStylePlaceholderCursor._param_generatorFcs|ds |dr|dd}|durg}nRt|dr(dd|D}||;}nA|rX|rXdd|D}d dtt|Dfd d|D}d dD}|t|;}nd dtt|D}|t|;}|| |fS) N;/rcSsi|]}|d|qS)z:%sr)rxryrrrr{z@FormatStylePlaceholderCursor._fix_for_params..cSsg|]}t||fqSr)type)rxrrrrr-rz@FormatStylePlaceholderCursor._fix_for_params..cSsi|] \}}|d|qSz:arg%dr)rxr param_typerrrr{.scsg|]}|qSrr)rxr& params_dictrrr2rcSsi|] \\}}}||qSrr)rx_r placeholderrrrr{3scSsg|]}d|qSr%r)rxrrrrr9r) rsr3rdictfromkeysrr4rangerr)r=queryrunify_by_valuesr2 param_typesrr'r_fix_for_paramss(     z,FormatStylePlaceholderCursor._fix_for_paramsNcCs^|j||dd\}}||gt|j|||WdS1s(wYdS)NT)r/)r1rr6r:rr)r=r.rrrrr=s  $z$FormatStylePlaceholderCursor.executecs|sdSt|}|t|\}}|gfdd|D}|tj|fdd|DWdS1s?wYdS)Ncg|]}|qSr)rrrrrrLr#z.cr2r)rrrrrrPr#)iterr1nextrr6r: executemany)r=r.r params_iter firstparams formattedrrrr5Cs $z(FormatStylePlaceholderCursor.executemanycCs(z|jWdStjyYdSwrA)r:r;r0InterfaceErrorrrrrr;Ss z"FormatStylePlaceholderCursor.closecGt|jj|SrA)rr:rr=r2rrrrZz FormatStylePlaceholderCursor.varcGr:rA)rr:arrayvarr;rrrr=]r<z%FormatStylePlaceholderCursor.arrayvarcCrrA)rr:)r=attrrrrr`rz(FormatStylePlaceholderCursor.__getattr__cCs t|jSrA)r3r:rrrr__iter__crz%FormatStylePlaceholderCursor.__iter__rrA)rBrCrDrrr staticmethodrrrrrrr1rr5r;rr=rr?rrrrrs*   &  +  r)5rrrrr contextlibr django.confrdjango.core.exceptionsr django.dbrdjango.db.backends.base.baser&django.db.backends.oracle.oracledb_anyrr0django.db.backends.utilsrdjango.utils.asyncior django.utils.encodingr r django.utils.functionalr django.utils.versionr r clientr%creationr&rr' introspectionr( operationsr)schemar*utilsr+r, validationr-r6r7rErrrrrrrsL                  z6