hk^SrSSKrSSKrSSKrSSKrSSKJr SSKJr SSK J r SSK J r SSK Jr SSKJr SS KJr SS KJr SS KJrJr SS KJr SS KJr Sr\"SS/5 SSKJr SSK J!r! SSK"J#r# SSK$J%r% SSK&J'r' SSK(J)r) SSK*J+r+J,r, SSK-J.r. \S5r/"SS5r0"SS\5r1"SS 5r2"S!S"5r3"S#S$5r4g)%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_tuplecV[R"5R5RS5(a3SSKnURS5nUHupEURXE5 M g[RRU5 g![ an[ SU-5eSnAff=f)NCYGWINrz_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.kernel32) platformsystemupper startswithctypes ImportErrorrCDLLSetEnvironmentVariableAosenvironupdate)rrernamevalues P/var/www/html/env/lib/python3.13/site-packages/django/db/backends/oracle/base.py_setup_environmentr!s ++H55  ;;z*"KD  , ,T 9# '" &2456  sB B(B##B()NLS_LANGz .AL32UTF8)ORA_NCHAR_LITERAL_REPLACETRUE)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)Oracle_datetimedsn)DatabaseValidationc#H# Sv g![RanURSn[US5(a\[US5(aKURS:Xa;SUR ;dSUR ;a[ [UR56eeSnAff=f7f)Nrcodemessagei+z ORA-02291z ORA-00001)Database DatabaseErrorargshasattrr0r1rtuple)rxs r wrap_oracle_errorsr8Cs  ! ! FF1I Av  9%%$ )[AII-E %-0 0 's%B" B"BA=BBB"c\rSrSrSSjrSrg)!_UninitializedOperatorsDescriptor]NcxUc [S5eUR5R5 URS$)Nz*operators not available as class attribute operators)AttributeErrorcursorclose__dict__)selfinstanceclss r __get__)_UninitializedOperatorsDescriptor.__get__^s:   !MN N!  --N)__name__ __module__ __qualname____firstlineno__rE__static_attributes__rHrGr r:r:]s.rGr:c ^\rSrSrSrSr0SS_SS_SS _S S _S S _SS_SS_SS_SS_SS _SS _SS_SS_SS_SS_S S!_S"S#_SSSSS S$SSSS%S&S'. ErS(S)S*S*S*S+.rS,r\ "5r S-S.S/S0S1S2S3S4S/S/S0S0S5. r 0\ ES6S7S6S6S7S7S8.Er S9r S:S;SS?S@.r\R5VVVs0sHupUSAU-SB-_M snnnr\R5VVVs0sHupUSCU-SD-_M snnnr\r\r\r\r\r\r\r\r U4SEjr!SFr"SGr#\$SH5r%U4SIjr&\$SSSJj5r'SKr(SLr)SMr*SSSNjr+SOr,\-SP5r.\-SQ5r/SRr0U=r1$s snnnfs snnnf)TDatabaseWrapperioracleOracle 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)rXrdrjrkrl)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 '\')ryrzrrrrz@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z {} || '%%'zUPPER({}) || '%%'z '%%' || {}z'%%' || UPPER({}))ryrzrrrrzLIKE TRANSLATE( z5 USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)zLIKEC z ESCAPE '\'c>[TU]"U0UD6 URSRSS5nX0Rlg)NOPTIONSuse_returning_intoT)super__init__ settings_dictgetfeaturescan_return_columns_from_insert)rBr4kwargsr __class__s r rDatabaseWrapper.__init__sC $)&)!// :>> $ 8J 4rGcUR$rI)oracle_versionrBs r get_database_version$DatabaseWrapper.get_database_versions"""rGcRURSR5nSU;aUS U$)Nrr)rcopyrB conn_paramss r get_connection_params%DatabaseWrapper.get_connection_paramss2((388: ; .01rGc[R"SURSURS[UR5S.UD6$)NUSERPASSWORD)userpasswordr-rH)r2connectrr-rs r get_new_connection"DatabaseWrapper.get_new_connectionsN ##F+'' 3D&&'    rGc>[TU]5 UR5nURS5 URS[R (aSOS-5 UR 5 SUR;afUR5nURSURS-S/5 URUl URUl UR 5 S UR lUR%5(dUR'5 gg![Ra% URUl URUl Nf=f) 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 %sryX)rinit_connection_state create_cursorexecuterUSE_TZr@rA_standard_operatorsr=_standard_pattern_ops pattern_opsr2r3_likec_operators_likec_pattern_ops connection stmtcachesizeget_autocommitcommit)rBr?rs r r%DatabaseWrapper.init_connection_states% %'##% DE  A'/#B @   dmm + '')F >7..z:;E"&!9!9#'#=#= LLN(*%""$$ KKM%)) ;!%!6!6#'#:#:  ;s #D6EEc.[URU5$rI)FormatStylePlaceholderCursorr)rBrs r rDatabaseWrapper.create_cursor/s+DOOTBBrGcURbD[US5 [5 URR5sSSS5 sSSS5 $g!,(df  O=fSSS5 g!,(df  g=f)NCOMMIT)rr r8rrs r _commitDatabaseWrapper._commit3sQ ?? &"424F4H--/5I4H22 '4H4H222s! A-A A- A! A-- A;cUR(a;URRSURR U5-SS.5 gg)Nz-- RELEASE SAVEPOINT %s (faked)z0.000)sqltime)queries_logged queries_logappendops quote_name)rBsids r _savepoint_commit!DatabaseWrapper._savepoint_commit:sD       # #1DatabaseWrapper.oracle_version..[sL)KAQ)Ks.)temporary_connectionr6rversionsplitrs r rDatabaseWrapper.oracle_versionXs=  & & (L)@)@)F)Fs)KLL) ( (s 5A Ac4[[R5$rI)rr2 __version__rs r oracledb_version DatabaseWrapper.oracledb_version]s !5!566rG)r=rrI)2rJrKrLrMvendor display_name data_typesdata_type_check_constraints_limited_data_typesr:r=rr pattern_esc _pattern_opsitemsrrr2r+SchemaEditorClassr& client_classr'creation_classr(features_classr)introspection_classr* ops_classr.validation_classrrrr rrrrrrrrr rrrN __classcell__)rkvrs000@r rPrPis FLJM v   0  V   D 7 0 4 (   W < .!" #$&#/ ,%10N) .#9J>1,#7 4%9 #413I U 4 U V 4 43< *2,*42$VK(0"* ( L!&&()DA  !%1 1 1( 6B5G5G5I5ITQ8a<. ((5IH,!L%N%N/"I)J#   )VCC04;MM77M s D> ErPc"\rSrSrSrSSjrSrg) OracleParamiba 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. c[R(aJ[U[R5(a+[U[5(d[R "U5nSnUR RRnU(dUSLaSnOUSLaSn[US5(aURU5Ul O[U[R[R45(aXl OY[XR U5Ul [UR["5(a[%[XR U55n[US5(aUR&UlgUS:a[R(Ulg[U[R5(a[R*UlgU(a+[U[,5(a[R.UlgSUlg)NrTr%Fbind_parameter input_sizei)rr isinstancedatetimer, from_datetimedatabaser&supports_boolean_expr_in_select_clauser5rr r2Binary timedeltar charsetstrlenr DB_TYPE_CLOBDB_TYPE_TIMESTAMPboolDB_TYPE_BOOLEAN)rBparamr? strings_only string_sizehas_boolean_data_types r rOracleParam.__init__lsg ?? uh// 0 0uo66#11%8E OO $ $ K K %}% 5* + +$33F;D  1C1CD E E$  ) MD $**C00!+e^^\"RS 5, ' '#..DO 4 &33DO x00 1 1&88DO "z%'>'>&66DO"DOrG)r rNF)rJrKrLrM__doc__rrNrHrGr rrbs )#rGrc0\rSrSrSrSrSrSrSrSr g) VariableWrapperiz 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. cXlgrIvar)rBrs r rVariableWrapper.__init__srGcUR$rIr)rBr?s r rVariableWrapper.bind_parameters xxrGc.[URU5$rI)getattrr)rBkeys r __getattr__VariableWrapper.__getattr__stxx%%rGcZUS:XaX RU'g[URX5 g)Nr)rAsetattrr)rBrrs r __setattr__VariableWrapper.__setattr__s# %[R"U5RTTS9$)N)context)r&r'quantize)rr-quantize_values r EFormatStylePlaceholderCursor._get_decimal_converter..s+44^W4UrG)rr&Contextr'scaleb) precisionscaler-r/s @@r _get_decimal_converter3FormatStylePlaceholderCursor._get_decimal_converters> A:J//y1 +22E6:UUrGcU[R:XazUS:XaUS:Xa[RnO3[nO,US:a[R XE5nO[RnUR [RSURUS9$U[R:Xa(UR [RURS9$g)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)r;N) r2NUMBERrr(floatr6rSTRINGr; DB_TYPE_NCLOB)r?r defaultTypelengthr4r5r<s r r"1FormatStylePlaceholderCursor._output_type_handlers (// )}>$@#X#XL$)LQ <RR   <TT :: **)  H22 2::h44@P@P:Q Q3rGc ^UR5VVs0sHup#U[UTS5_M snn$s snnf![a [U4SjU55s$f=f)NTc3>># UHn[UTS5v M g7f)TN)r)rprBs r r>FormatStylePlaceholderCursor._format_params..sDVQd33Vs)rrr>r6)rBparamsrrs` r _format_params+FormatStylePlaceholderCursor._format_paramssY E>DllnMndaA{1dD11nM MM EDVDD D Es:4::AAc[USS5(a`0nUH=nUR5H&upEUR(dMURX$'M( M? U(aUR"S0UD6 ggS/[ US5-nUH8n[ U5H&upeUR(dMURX&'M( M: U(aUR"U6 gg)NrkeysrH)r5rr setinputsizesr enumerate)rB params_listsizesrHrris r _guess_input_sizes/FormatStylePlaceholderCursor._guess_input_sizess ;q>6 * *E% & HA'''#(#3#3!/&""+U+FSQ00E% )& 1HA'''#(#3#3!2&""E*rGc[US5(a/UR5VVs0sHup#X#R_M snn$UVs/sHoDRPM sn$s snnfs snf)Nr)r5rr )rBrHrrrFs r _param_generator-FormatStylePlaceholderCursor._param_generator sS 67 # #17@A}}$@ @+126aMM62 2A2s AA#cURS5(dURS5(aUSSnUc/nGO [US5(aUVs0sHoDSU-_M nnX-nOU(aU(aUVs/sHn[U5U4PM nn[[R U55VV s0sH upU SU-_M n nn UV s/sHoU PM nn U R 5V VV s0sH uupoU_M nnn n U[U5-nO5[[U55Vs/sHnSU-PM nnU[U5-nXRU54$s snfs snfs sn nfs sn fs sn nn fs snf)N;/rLz:%sz:arg%d) rr5typerNdictfromkeysrr6rangerrI) rBqueryrHunify_by_valuesrr4r param_typesrQ param_type params_dict_ placeholders r _fix_for_params,FormatStylePlaceholderCursor._fix_for_paramss >>#  %.."5"5#2JE >F VV $ $*01&QuqyL&D1 ME >DDVEDK/VKD&/t}}[/I%J%JMAHqL(%J ?JJk +kDJBMBSBSBUBU'>z;U"BU  U4[ E-2#f+,>?,>qX\,>D? U4[ E))&111=2 EK @s$E6E0E" E(-E-'E4NcURXSS9upURU/5 [5 URR XR U55sSSS5 $!,(df  g=f)NT)r`)rfrRr8r?rrU)rBr_rHs r r$FormatStylePlaceholderCursor.execute=sX,,UD,Q  )  !;;&&u.C.CF.KL" ! !s *A## A1c U(dg[U5nURU[U55upU/UVs/sHoPRU5PM sn-nUR U5 [ 5 UR RXVs/sHoPRU5PM sn5sSSS5 $s snfs snf!,(df  g=frI) iterrfnextrIrRr8r? executemanyrU)rBr_rH params_iter firstparamsrF formatteds r rm(FormatStylePlaceholderCursor.executemanyCs6l !11%k9JK!M[$Q[%8%8%;[$QQ   *  !;;**)D)Q--a0)D" !%RE" !s#B51B? B: %B?:B?? C cnURR5 g![Ra gf=frI)r?r@r2InterfaceErrorrs r r@"FormatStylePlaceholderCursor.closeSs/  KK   &&   rcF[URR"U65$rI)rr?rrBr4s r r FormatStylePlaceholderCursor.varZst{{566rGcF[URR"U65$rI)rr?arrayvarrvs r ry%FormatStylePlaceholderCursor.arrayvar]st{{33T:;;rGc.[URU5$rI)rr?)rBattrs r r(FormatStylePlaceholderCursor.__getattr__`st{{D))rGc,[UR5$rI)rkr?rs r __iter__%FormatStylePlaceholderCursor.__iter__csDKK  rG)r?rr rI)rJrKrLrMrrr staticmethodr(r6r"rIrRrUrfrrmr@rryrrrNrHrGr rrs G! FFVV$R$RLE +(3)2VM  7<*!rGr)5rrr&rr contextlibr django.confrdjango.core.exceptionsr django.dbrdjango.db.backends.base.baser&django.db.backends.oracle.oracledb_anyrr2django.db.backends.utilsr django.utils.asyncior django.utils.encodingr r django.utils.functionalr django.utils.versionrr!clientr&creationr'rr( introspectionr) operationsr*schemar+utilsr,r- validationr.r8r:rPrrrrHrGr rs  % 7$<G6-832#& " . #&&0*('*2 . .v7)v7r3#3#l**0t!t!rG