hrZdZddlZddlZddlZddlZddlmZddlmZddl m Z ddl m Z ddl mZddlmZdd lmZdd lmZmZdd lmZd Zed dg ddlZn#e$rZe dezdZ[wwxYwddlmZddlm Z ddl!m"Z"ddl#m$Z$ddl%m&Z&ddl'm(Z(ddl)m*Z*m+Z+ddl,m-Z-edZ.GddZ/GddeZ0GddZ1Gd d!Z2Gd"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_propertycrtjdr_ ddl}n$#t $r}t d|zd}~wwxYw|d}|D]\}}|||dStj |dS)NCYGWINrz_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.kernel32) platformsystemupper startswithctypes ImportErrorrCDLLSetEnvironmentVariableAosenvironupdate)rrernamevalues ]/var/www/surfInsights/venv3-11/lib/python3.11/site-packages/django/db/backends/oracle/base.py_setup_environmentrs  ++H55 #  MMMM   &2456   ;;z**" : :KD%  , ,T5 9 9 9 9 : : '"""""s? A  AA )NLS_LANGz .AL32UTF8)ORA_NCHAR_LITERAL_REPLACETRUEz"Error loading cx_Oracle module: %s)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)Oracle_datetimedsn)DatabaseValidationc#K dVdS#tj$rk}|jd}t|drHt|dr8|jdkr-d|jvs d|jvrt t|jd}~wwxYw)Nrcodemessagei+z ORA-02291z ORA-00001)Database DatabaseErrorargshasattrr.r/rtuple)rxs rwrap_oracle_errorsr6Ds   ! F1I Av   19%% 1$ ))[AI-E-E %--0 0 's BA&A??BceZdZddZdS)!_UninitializedOperatorsDescriptorNc|td||jdS)Nz*operators not available as class attribute operators)AttributeErrorcursorclose__dict__)selfinstanceclss r__get__z)_UninitializedOperatorsDescriptor.__get___sC   !MNN N!!! --N)__name__ __module__ __qualname__rBrCrr8r8^s(......rCr8c JeZdZdZdZiddddddd 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@e DZdAe DZeZeZeZeZeZeZeZeZfdBZ dCZ!dDZ"e#dEZ$fdFZ%e#dPdHZ&dIZ'dJZ(dKZ)dPdLZ*dMZ+e,dNZ-e,dOZ.xZ/S)QDatabaseWrapperoracleOracle 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)rQr]rcrdre)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 '\')rrrsrrxryrzz@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z {} || '%%'zUPPER({}) || '%%'z '%%' || {}z'%%' || UPPER({}))rrrsrryrxrzc&i|]\}}|d|zdzS)zLIKE TRANSLATE( z5 USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)rH.0kvs r zDatabaseWrapper.s@ Aq  !%1 1rCc&i|]\}}|d|zdzS)zLIKEC z ESCAPE '\'rHr|s rrzDatabaseWrapper.s4-1Q8a<. (rCctj|i||jddd}||j_dS)NOPTIONSuse_returning_intoT)super__init__ settings_dictgetfeaturescan_return_columns_from_insert)r?r2kwargsr __class__s rrzDatabaseWrapper.__init__sU$)&)))!/ :>> $  8J 444rCc|jSrD)oracle_versionr?s rget_database_versionz$DatabaseWrapper.get_database_versions ""rCcR|jd}d|vr|d=|S)Nrr)rcopyr? conn_paramss rget_connection_paramsz%DatabaseWrapper.get_connection_paramss5(388:: ; . .01rCc|tjd|jd|jdt|jd|S)NUSERPASSWORD)userpasswordr+rH)r0connectrr+rs rget_new_connectionz"DatabaseWrapper.get_new_connectionsO #F+' 3D&''      rCct|}|d|dtjrdndz|d|jvr|} |d|jdzdg|j|_ |j |_ n-#tj $r|j|_ |j|_ YnwxYw|d |j_|s|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'r:z!SELECT 1 FROM DUAL WHERE DUMMY %srrX)rinit_connection_state create_cursorexecuterUSE_TZr=r>_standard_operatorsr:_standard_pattern_ops pattern_opsr0r1_likec_operators_likec_pattern_ops connection stmtcachesizeget_autocommitcommit)r?r<rs rrz%DatabaseWrapper.init_connection_statesr %%'''##%% DEEE  A'/>##B @     dm + + ''))F >7.z:;E"&!9#'#=  ) ; ; ;!%!6#'#:    ; LLNNN(*%""$$  KKMMMMM  s#%C!!'D  D Nc*t|jSrD)FormatStylePlaceholderCursorr)r?rs rrzDatabaseWrapper.create_cursor0s+DO<<z4DatabaseWrapper.cx_oracle_version..[s(AASVVAAAAAArC.)r4r0versionsplitrs rcx_oracle_versionz!DatabaseWrapper.cx_oracle_versionYs0AAX%5%;%;C%@%@AAAAAArCc|5td|jjdDcdddS#1swxYwYdS)Nc34K|]}t|VdSrDrrs rrz1DatabaseWrapper.oracle_version..`s(LLAQLLLLLLrCr)temporary_connectionr4rrrrs rrzDatabaseWrapper.oracle_version]s  & & ( ( M MLL)@)F)Fs)K)KLLLLL M M M M M M M M M M M M M M M M M Ms6AAArD)0rErFrGvendor display_name data_typesdata_type_check_constraints_limited_data_typesr8r:rr pattern_esc _pattern_opsitemsrrr0r)SchemaEditorClassr$ client_classr%creation_classr&features_classr'introspection_classr( ops_classr,validation_classrrrr rrrrrrrrr rr __classcell__)rs@rrJrJjs FLJM v   0  V   D 7 0 4 (   W < .!" #$&#/ ,%10N) .#9J>1,#7 4%9 ##41133I U 4 U V 4 43< *2,*42$VK(0"* ( L!&&(( 5A5G5G5I5IH,!L%N%N/"I)JJJJJ###   \ )))))V===\=000444;;;;BB_BMM_MMMMMrCrJceZdZdZddZdS) 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. FctjrCt|tjr)t|tst j|}d}|durd}n|durd}t |dr|||_nt|tj tj fr||_nXt||j ||_t|jtr#tt||j |}t |dr|j|_dS|dkrtj|_dSt|tjrtj|_dSd|_dS)NrTr#Fbind_parameter input_sizei)rr isinstancedatetimer* from_datetimer3rr r0Binary timedeltar charsetstrlenrCLOBrV)r?paramr< strings_only string_sizes rrzOracleParam.__init__msn ? 9 uh/ 0 0 9uo66 9$1%88E D==EE e^^E 5* + + T$33F;;D   1CD E E T$D   ) MMD $*C00 T!+eV^\"R"RSS 5, ' ' ##.DOOO 4  &mDOOO x0 1 1 #&0DOOO"DOOOrCNF)rErFrG__doc__rrHrCrrrcs2############rCrc*eZdZdZdZdZdZdZdS)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||_dSrDvar)r?rs rrzVariableWrapper.__init__s rCc|jSrDr)r?r<s rrzVariableWrapper.bind_parameters xrCc,t|j|SrD)getattrr)r?keys r __getattr__zVariableWrapper.__getattr__stx%%%rCcV|dkr ||j|<dSt|j||dS)Nr)r>setattrr)r?rrs r __setattr__zVariableWrapper.__setattr__s7 %<zEFormatStylePlaceholderCursor._get_decimal_converter..s$++44^W4UUrC)rr Contextr scaleb) precisionscalerrs @@r_get_decimal_converterz3FormatStylePlaceholderCursor._get_decimal_convertersU A::J/y111 ++22E6::UUUUUUrCc|tjkrw|dkr|dkr tj}n6t}n.|dkrt||}n tj}|tjd|j|SdS)zx Called for each db column fetched from cursors. Return numbers as the appropriate Python type. ir)size arraysize outconverterN) r0NUMBERrr floatrrSTRINGr)r<r defaultTypelengthrrrs rrz1FormatStylePlaceholderCursor._output_type_handlers (/ ) )}}>>$@#XLL$)LLQ <RRu    <T :: *)  - * )rCc fd|DS#t$rtfd|DcYSwxYw)Nc:i|]\}}|t|dS)Tr)r}r~rr?s rrz?FormatStylePlaceholderCursor._format_params..s+MMMdaA{1dD11MMMrCc3:K|]}t|dVdS)TNr&r}pr?s rrz>FormatStylePlaceholderCursor._format_params..s/DDQd33DDDDDDrC)rr;r4r?paramss` r_format_paramsz+FormatStylePlaceholderCursor._format_paramsss EMMMMfllnnMMM M E E EDDDDVDDDDD D D D Es#%A  A c`t|ddrEi}|D]-}|D]\}}|jr |j||<.|r|jdi|dSdSdgt |dz}|D](}t |D]\}}|jr |j||<)|r |j|dSdS)NrkeysrH)r3rr setinputsizesr enumerate)r? params_listsizesr+r~ris r_guess_input_sizesz/FormatStylePlaceholderCursor._guess_input_sizess" ;q>6 * * +E% 4 4 & 44HAu'4#(#3a4 ,""++U+++++ , ,FSQ000E% 4 4 )& 1 144HAu'4#(#3a4 +""E**** + +rCcvt|drd|DSd|DS)Nrc$i|] \}}||jSrHr r|s rrzAFormatStylePlaceholderCursor._param_generator..s @@@AAq}@@@rCcg|] }|j SrHr7)r}r)s r zAFormatStylePlaceholderCursor._param_generator..s222aAM222rC)r3rr*s r_param_generatorz-FormatStylePlaceholderCursor._param_generatorsD 67 # # 3@@@@@ @226222 2rCFc@|ds|dr |dd}|g}nt|drd|D}||z}n|rr|rpdtt|Dfd|D}dD}|t |z}n8d tt|D}|t |z}|| |fS) N;/r.ci|]}|d|z S)z:%srH)r}r~s rrz@FormatStylePlaceholderCursor._fix_for_params..s111QAuqy111rCc i|] \}}|d|z Sz:arg%drH)r}r3rs rrz@FormatStylePlaceholderCursor._fix_for_params..s/(05x!|rCc g|] }| SrHrH)r}r params_dicts rr9z@FormatStylePlaceholderCursor._fix_for_params.. s;;;5K&;;;rCci|]\}}|| SrHrH)r}rrs rrz@FormatStylePlaceholderCursor._fix_for_params..!sGGGZS%eSGGGrCcg|]}d|zSrArH)r}r3s rr9z@FormatStylePlaceholderCursor._fix_for_params..%s???qX\???rC) rxr3r0dictfromkeysrr4rangerr,)r?queryr+unify_by_valuesr2rCs @r_fix_for_paramsz,FormatStylePlaceholderCursor._fix_for_paramssO >>#   %.."5"5 #2#JE >FF VV $ $ !11&111D TMEE  ! !4=dmmF>S>S4T4TK<;;;F;;;DGG;3D3D3F3FGGGF U4[[ EE@?E#f++,>,>???D U4[[ Ed))&1111rCNc|||d\}}||gt5|j|||cdddS#1swxYwYdS)NT)rJ)rKr4r6r<rr:)r?rIr+s rrz$FormatStylePlaceholderCursor.execute)s,,UFD,QQ v )))  ! ! M M;&&ud.C.CF.K.KLL M M M M M M M M M M M M M M M M M Ms.A;;A?A?cb|sdSt|}|t|\}}|gfd|Dz}|t 5j|fd|DcdddS#1swxYwYdS)Nc:g|]}|SrH)r,r(s rr9z.8s'$Q$Q$QT%8%8%;%;$Q$Q$QrCc:g|]}|SrH)r:r(s rr9z.<s'DDDQ--a00DDDrC)iterrKnextr4r6r< executemany)r?rIr+ params_iter firstparams formatteds` rrRz(FormatStylePlaceholderCursor.executemany/s 46ll !11%k9J9JKK{!M$Q$Q$Q$Q[$Q$Q$QQ   ***  ! !  ;**DDDD)DDD                  s0'B$$B(+B(cf |jdS#tj$rYdSwxYwrD)r<r=r0InterfaceErrorrs rr=z"FormatStylePlaceholderCursor.close?sF  K       &    DD rc:t|jj|SrD)rr<rr?r2s rrz FormatStylePlaceholderCursor.varFst{5666rCc:t|jj|SrD)rr<arrayvarrYs rr[z%FormatStylePlaceholderCursor.arrayvarIs3t{3T:;;;rCc,t|j|SrD)rr<)r?attrs rrz(FormatStylePlaceholderCursor.__getattr__Lst{D)))rCc*t|jSrD)rPr<rs r__iter__z%FormatStylePlaceholderCursor.__iter__OsDK   rCrrD)rErFrGrrr staticmethodr rrr,r4r:rKrrRr=rr[rr_rHrCrrrsK GBBBFF\FVV\V  \ DEEE +++(3332222BMMMM  777<<<***!!!!!rCr)4rrr rr contextlibr django.confrdjango.core.exceptionsr django.dbrdjango.db.backends.base.baserdjango.db.backends.utilsrdjango.utils.asyncior django.utils.encodingr r django.utils.functionalr r cx_Oracler0rrclientr$creationr%rr& introspectionr' operationsr(schemar)utilsr*r+ validationr,r6r8rJrrrrHrCrrrs  %%%%%% 777777$$$$$$<<<<<<666666------88888888333333###& " . I     III  CaG H HHI#"""""&&&&&&&&&&&&000000******((((((''''''''******2 . . . . . . . .vMvMvMvMvM)vMvMvMr-#-#-#-#-#-#-#-#`********0e!e!e!e!e!e!e!e!e!e!sA!!A9&A44A9