jedZddlZddlZddlZddlZddlmZddlmZddl m Z ddl m Z ddl mZddlmZdd lmZdd lmZdd lmZmZdd lmZdd lmZ ddlmZn#e$rZe dedZ[wwxYwdZ e ddgddl!m"Z"ddl#m$Z$ddl%m&Z&ddl'm(Z(ddl)m*Z*ddl+m,Z,ddl-m.Z.m/Z/ddl0m1Z1edZ2GddZ3Gdd eZ4Gd!d"Z5Gd#d$Z6Gd%d&Z7dS)'zc Oracle database backend for Django. Requires oracledb: https://oracle.github.io/python-oracledb/ N)contextmanager)settings)ImproperlyConfigured)IntegrityError)BaseDatabaseWrapper) is_oracledb)debug_transaction) async_unsafe) force_bytes force_str)cached_property)get_version_tuple)oracledbzError loading oracledb module: crtjdr_ 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 k/var/www/finuniver-perm.ru/html/student/venv/lib/python3.11/site-packages/django/db/backends/oracle/base.py_setup_environmentr"s  ++H55 #  MMMM   &2456   ;;z**" : :KD%  , ,T5 9 9 9 9 : : '"""""s? A  AA )NLS_LANGz .AL32UTF8)ORA_NCHAR_LITERAL_REPLACETRUE)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 DatabaseErrorargshasattrr1r2rtuple)rxs r!wrap_oracle_errorsr9Hs   ! 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__csC   !MNN N!!! --N)__name__ __module__ __qualname__rErFr!r;r;bs(......rFr;c eZdZdZdZiddddddd 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 DZeZeZeZeZeZeZeZeZiZ fdBZ!e"dCZ#e"dDZ$dEZ%dFZ&dGZ'e(dHZ)fdIZ*e(dTdKZ+dLZ,dMZ-dNZ.dTdOZ/dPZ0fdQZ1e2dRZ3e2dSZ4xZ5S)UDatabaseWrapperoracleOracle 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)rTr`rfrgrh)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 '\')rurvrr{r|r}z@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z {} || '%%'zUPPER({}) || '%%'z '%%' || {}z'%%' || UPPER({}))rurvrr|r{r}c&i|]\}}|d|zdzS)zLIKE TRANSLATE( z5 USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)rK.0kvs r! zDatabaseWrapper.s@ Aq  !%1 1rFc&i|]\}}|d|zdzS)zLIKEC z ESCAPE '\'rKrs r!rzDatabaseWrapper.s4-1Q8a<. (rFctj|i||jddd}||j_dS)NOPTIONSuse_returning_intoT)super__init__ settings_dictgetfeaturescan_return_columns_from_insert)rBr5kwargsr __class__s r!rzDatabaseWrapper.__init__sU$)&)))!/ :>> $  8J 444rFcD|jdddS)NrpoolF)rrrBs r!is_poolzDatabaseWrapper.is_pools !),00???rFc|jsdS|jdddkrtd|j|jdf}||jvr|}|d}|dur||tj d |jd|jdt|jd|}|j |||j|S) N CONN_MAX_AGErz/Pooling doesn't support persistent connections.USERrTPASSWORDuserpasswordr.rK) rrrralias_connection_poolsget_connection_paramspoprr3 create_poolr. setdefault)rBpool_keyconnect_kwargs pool_optionsrs r!rzDatabaseWrapper.pools| 4   ! !.! 4 4 9 9&A J 26 :; 41 1 1!7799N)--f55L4''%%l333''/+J7*++! D  " - -h = = =%h//rFc|jr9|jd|j|jdf}|j|=dSdS)NT)forcer)rr@rrr)rBrs r! close_poolzDatabaseWrapper.close_poolsQ 9 1 IOO$O ' ' ' D$6v$>?H&x000 1 1rFc|jSrG)oracle_versionrs r!get_database_versionz$DatabaseWrapper.get_database_versions ""rFc|jrtstd|jd}d|vr|d=|S)NzBPooling isn't supported by cx_Oracle. Use python-oracledb instead.rr)rrrrcopyrB conn_paramss r!rz%DatabaseWrapper.get_connection_params s] <   &T (388:: ; . .01rFc|jr|jStjd|jd|jdt |jd|S)NrrrrK)racquirer3connectrr.rs r!get_new_connectionz"DatabaseWrapper.get_new_connection+sm 9 '9$$&& & #F+' 3D&''      rFct|}|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 %sruX)rinit_connection_state create_cursorexecuterUSE_TZr@rA_standard_operatorsr=_standard_pattern_ops pattern_opsr3r4_likec_operators_likec_pattern_ops connection stmtcachesizeget_autocommitcommit)rBr?rs r!rz%DatabaseWrapper.init_connection_state6sr %%'''##%% DEEE  A'/>##B @     dm + + ''))F >7.z:;E"&!9#'#=  ) ; ; ;!%!6#'#:    ; LLNNN(*%""$$  KKMMMMM  s#%C!!'D  D Nc,t|j|SrG)FormatStylePlaceholderCursorr)rBrs r!rzDatabaseWrapper.create_cursoras+DOTBBBrFc|jvt|d5t5|jcdddcdddS#1swxYwYddddS#1swxYwYdSdS)NCOMMIT)rr r9rrs r!_commitzDatabaseWrapper._commites  ? &"422 0 04F4H4H 0 0--// 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ' &s4A1A A1A A1 A !A11A58A5c|jr:|jd|j|zdddSdS)Nz-- RELEASE SAVEPOINT %s (faked)z0.000)sqltime)queries_logged queries_logappendops quote_name)rBsids r!_savepoint_commitz!DatabaseWrapper._savepoint_commitlsb      # #z1DatabaseWrapper.oracle_version..s(LLAQLLLLLLrF.)temporary_connectionr7rversionsplitrs r!rzDatabaseWrapper.oracle_versions  & & ( ( M MLL)@)F)Fs)K)KLLLLL M M M M M M M M M M M M M M M M M Ms6AAAc4ttjSrG)rr3 __version__rs r!oracledb_versionz DatabaseWrapper.oracledb_versions !5666rFrG)6rHrIrJvendor display_name data_typesdata_type_check_constraints_limited_data_typesr;r=rr pattern_esc _pattern_opsitemsrrr3r,SchemaEditorClassr' client_classr(creation_classr)features_classr*introspection_classr+ ops_classr/validation_classrrpropertyrrrrrr rrrrrrrrrr rr __classcell__)rs@r!rMrMns 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@@X@00X04111 ###     \ )))))VCCC\C000444;;;;66666 MM_M77_77777rFrMceZdZdZddZdS) 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. FcjtjrCt|tjr)t|tst j|}d}|jjj}|s |durd}n|durd}t|dr| ||_ nt|ttj fr||_ nXt||j||_ t|j t r#t#t||j|}t|dr|j|_dS|dkrt&j|_dSt|tjrt&j|_dS|r(t|t,rt&j|_dSd|_dS)NrTr&Fbind_parameter input_sizei)rr isinstancedatetimer- from_datetimedatabaser&supports_boolean_expr_in_select_clauser6rr bytes timedeltar charsetstrlenrr3 DB_TYPE_CLOBDB_TYPE_TIMESTAMPboolDB_TYPE_BOOLEAN)rBparamr? strings_only string_sizehas_boolean_data_types r!rzOracleParam.__init__s ? 9 uh/ 0 0 9uo66 9$1%88E O $ K % }}% 5* + + T$33F;;D   x'9: ; ; T$D   ) MMD $*C00 T!+eV^\"R"RSS 5, ' ' ##.DOOO 4  &3DOOO x0 1 1 #&8DOOO " #z%'>'> #&6DOOO"DOOOrFNF)rHrIrJ__doc__rrKrFr!rrs2)#)#)#)#)#)#rFrc*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||_dSrGvar)rBrs r!rzVariableWrapper.__init__s rFc|jSrGr)rBr?s r!rzVariableWrapper.bind_parameters xrFc,t|j|SrG)getattrr)rBkeys r! __getattr__zVariableWrapper.__getattr__stx%%%rFcV|dkr ||j|<dSt|j||dS)Nr)rAsetattrr)rBrr s r! __setattr__zVariableWrapper.__setattr__s7 %<zEFormatStylePlaceholderCursor._get_decimal_converter..s$++44^W4UUrF)rr'Contextr(scaleb) precisionscaler-r/s @@r!_get_decimal_converterz3FormatStylePlaceholderCursor._get_decimal_convertersU A::J/y111 ++22E6::UUUUUUrFc|tjkrw|dkr|dkr tj}n6t}n.|dkrt||}n tj}|tjd|j|S|tj kr&|tj |jSdS)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)r9N) r3NUMBERrr)floatr5rSTRINGr9 DB_TYPE_NCLOB)r?r defaultTypelengthr3r4r:s r!r$z1FormatStylePlaceholderCursor._output_type_handlers (/ ) )}}>>$@#XLL$)LLQ <RRu    <T :: *)  H2 2 2::h4@P:QQ Q3 2rFc fd|DS#t$rtfd|DcYSwxYw)Nc:i|]\}}|t|dS)Tr)rrrrBs r!rz?FormatStylePlaceholderCursor._format_params..+s+MMMdaA{1dD11MMMrFc3:K|]}t|dVdS)TNrCrprBs r!rz>FormatStylePlaceholderCursor._format_params..-s/DDQd33DDDDDDrF)rr>r7rBparamss` r!_format_paramsz+FormatStylePlaceholderCursor._format_params)ss 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)NrkeysrK)r6rr setinputsizesr  enumerate)rB params_listsizesrHrr is r!_guess_input_sizesz/FormatStylePlaceholderCursor._guess_input_sizes/s" ;q>6 * * +E% 4 4 & 44HAu'4#(#3a4 ,""++U+++++ , ,FSQ000E% 4 4 )& 1 144HAu'4#(#3a4 +""E**** + +rFcvt|drd|DSd|DS)Nrc$i|] \}}||jSrKr rs r!rzAFormatStylePlaceholderCursor._param_generator..Fs @@@AAq}@@@rFcg|] }|j SrKrT)rrFs r! zAFormatStylePlaceholderCursor._param_generator..Hs222aAM222rF)r6rrGs r!_param_generatorz-FormatStylePlaceholderCursor._param_generatorCsD 67 # # 3@@@@@ @226222 2rFFcX|ds|dr |dd}|g}nt|drd|D}||z}n|r~|r|d|D}dtt|Dfd|D}d D}|t |z}n8d tt|D}|t |z}|| |fS) N;/rKci|]}|d|z S)z:%srK)rrs r!rz@FormatStylePlaceholderCursor._fix_for_params..Us111QAuqy111rFc0g|]}t||fSrK)type)rrs r!rVz@FormatStylePlaceholderCursor._fix_for_params..es#DDDEDKK/DDDrFc i|] \}}|d|z Sz:arg%drK)rrP param_types r!rz@FormatStylePlaceholderCursor._fix_for_params..fs2!AzHqLrFc g|] }| SrKrK)rra params_dicts r!rVz@FormatStylePlaceholderCursor._fix_for_params..jsJJJ K +JJJrFc i|] \\}}}|| SrKrK)r_r placeholders r!rz@FormatStylePlaceholderCursor._fix_for_params..ks/'>z5; UrFcg|]}d|zSr`rK)rrPs r!rVz@FormatStylePlaceholderCursor._fix_for_params..qs???qX\???rF) r{r6rMdictfromkeysrr7ranger rI)rBqueryrHunify_by_valuesr5 param_typesrcs @r!_fix_for_paramsz,FormatStylePlaceholderCursor._fix_for_paramsJss >>#   %.."5"5 #2#JE >FF VV $ $ !11&111D TMEE  ! !EDVDDDK%.t}}[/I/I%J%JKKJJJkJJJDBMBSBSBUBUF U4[[ EE@?E#f++,>,>???D U4[[ Ed))&1111rFNc|||d\}}||gt5|j|||cdddS#1swxYwYdS)NT)rl)rnrQr9r?rrW)rBrkrHs r!rz$FormatStylePlaceholderCursor.executeus,,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|]}|SrK)rIrEs r!rVz.s'$Q$Q$QT%8%8%;%;$Q$Q$QrFc:g|]}|SrK)rWrEs r!rVz.s'DDDQ--a00DDDrF)iterrnnextrQr9r? executemany)rBrkrH params_iter firstparams formatteds` r!ruz(FormatStylePlaceholderCursor.executemany{s 46ll !11%k9J9JKK{!M$Q$Q$Q$Q[$Q$Q$QQ   ***  ! !  ;**DDDD)DDD                  s0'B$$B(+B(cf |jdS#tj$rYdSwxYwrG)r?r@r3InterfaceErrorrs r!r@z"FormatStylePlaceholderCursor.closesF  K       &    DD rc:t|jj|SrG)rr?rrBr5s r!rz FormatStylePlaceholderCursor.varst{5666rFc:t|jj|SrG)rr?arrayvarr|s r!r~z%FormatStylePlaceholderCursor.arrayvars3t{3T:;;;rFc,t|j|SrG)rr?)rBattrs r!rz(FormatStylePlaceholderCursor.__getattr__st{D)))rFc*t|jSrG)rsr?rs r!__iter__z%FormatStylePlaceholderCursor.__iter__sDK   rFrrG)rHrIrJrrr staticmethodr)r5r$rIrQrWrnrrur@rr~rrrKrFr!rrsK G!!! FF\FVV\V$R$R\$RLEEE +++(333)2)2)2)2VMMMM  777<<<***!!!!!rFr)8rrr'rr contextlibr django.confrdjango.core.exceptionsr django.dbrdjango.db.backends.base.baser&django.db.backends.oracle.oracledb_anyrdjango.db.backends.utilsr django.utils.asyncior django.utils.encodingr r django.utils.functionalr django.utils.versionrrr3rrr"clientr'creationr(rr) introspectionr* operationsr+schemar,utilsr-r. validationr/r9r;rMrrrrKrFr!rs*  %%%%%% 777777$$$$$$<<<<<<>>>>>>666666------88888888333333222222FKKKKKKKFFF  DDD E EEF###& " . #"""""&&&&&&&&&&&&000000******((((((''''''''******2 . . . . . . . .i7i7i7i7i7)i7i7i7X 3#3#3#3#3#3#3#3#l********0t!t!t!t!t!t!t!t!t!t!sAA7$A22A7