o uvXjX @szdZddlZddlZddlZddlZddlmZddlmZddl m Z ddl m Z ddl mZddlmZmZdd lmZd d Zed d gzddlZWney`Zze dedZ[wwddlmZddlmZddlmZddlm Z ddl!m"Z"ddl#m$Z$ddl m%Z%ddl&m'Z'eddZ(GdddZ)GdddeZ*GdddZ+Gd d!d!Z,Gd"d#d#Z-dS)$ze Oracle database backend for Django. Requires cx_Oracle: https://oracle.github.io/python-cx_Oracle/ N)contextmanager)settings)ImproperlyConfigured)utils)BaseDatabaseWrapper) force_bytes force_text)cached_propertyc 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)rrer namevaluer[/var/www/html/myproject/venv/lib/python3.10/site-packages/django/db/backends/oracle/base.py_setup_environments   r)NLS_LANGz .AL32UTF8)ORA_NCHAR_LITERAL_REPLACETRUEz"Error loading cx_Oracle module: %s)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)Oracle_datetime)DatabaseValidationc csnzdVWdStjy6}z"|jd}t|dr1t|dr1|jdkr1d|jvr1tjt|jd}~ww)Nrcodemessagei+z ORA-02291) Database DatabaseErrorargshasattrr)r*rIntegrityErrortuple)rxrrrwrap_oracle_errors>s  (r2c@seZdZdddZdS)!_UninitializedOperatorsDescriptorNcCs&|durtd||jdS)Nz*operators not available as class attribute operators)AttributeErrorcursorclose__dict__)selfinstanceclsrrr__get__Rs  z)_UninitializedOperatorsDescriptor.__get__N)__name__ __module__ __qualname__r<rrrrr3Psr3c seZdZdZdZiddddddd d d d d ddddddddd dd dddddddddd d!d dddd dd"dd#d$d% Zd&d&d'd'd(Zd)ZeZ d*d+d,d-d.d/d0d1d,d,d-d-d2 Z ie d3d4d3d3d4d4d5Z d6Z d7d8d9d:d;dd?e DZd@d?e DZeZeZeZeZeZeZeZeZfdAdBZ dCdDZ!dEdFZ"dGdHZ#dIdJZ$dKdLZ%d\dNdOZ&dPdQZ'dRdSZ(dTdUZ)d\dVdWZ*dXdYZ+e,dZd[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)BigIntegerFieldz NUMBER(19)IPAddressFieldz VARCHAR2(15)GenericIPAddressFieldz VARCHAR2(39)NullBooleanFieldNCLOBzVARCHAR2(%(max_length)s)z VARCHAR2(32)) OneToOneFieldPositiveIntegerFieldPositiveSmallIntegerField SlugFieldSmallIntegerField TextField TimeFieldURLField UUIDFieldz%(qn_column)s IN (0,1)z%(qn_column)s >= 0)rHrWrZr[)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 '\')rgrhrrmrnroz@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z {} || '%%'zUPPER({}) || '%%'z '%%' || {}z'%%' || UPPER({}))rgrhrrnrmrocCi|] \}}|d|dqS)zLIKE TRANSLATE( z5 USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)r.0kvrrr szDatabaseWrapper.cCrp)zLIKEC z ESCAPE '\'rrqrrrruscs0tj|i||jddd}||j_dS)NOPTIONSuse_returning_intoT)super__init__ settings_dictgetfeaturescan_return_id_from_insert)r9r-kwargsrw __class__rrrys zDatabaseWrapper.__init__cCsH|j}|ds d|d<|dr t|dt|d|dS|dS)NHOST localhostPORTNAME)rzstripr+makedsnint)r9rzrrr_dsns  zDatabaseWrapper._dsncCsd|jd|jd|fS)Nz %s/"%s"@%sUSERPASSWORD)rzrr9rrr_connect_stringszDatabaseWrapper._connect_stringcCs |jd}d|vr|d=|S)Nrvrw)rzcopyr9 conn_paramsrrrget_connection_paramssz%DatabaseWrapper.get_connection_paramscCs(tjd|jd|jd|d|S)Nrr)userpassworddsnr)r+connectrzrrrrrget_new_connectionsz"DatabaseWrapper.get_new_connectioncCs|}|d|dtjrdnd|d|jvrO|}z|d|jddgWntjyB|j |_ |j |_ Yn w|j|_ |j |_ |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'r4z!SELECT 1 FROM DUAL WHERE DUMMY %srgX) create_cursorexecuterUSE_TZr7r8_standard_operatorsr+r,_likec_operatorsr4_likec_pattern_ops pattern_ops_standard_pattern_ops connection stmtcachesizeget_autocommitcommitr9r6rrrinit_connection_states6     z%DatabaseWrapper.init_connection_stateNcC t|jSr=)FormatStylePlaceholderCursorr)r9rrrrr zDatabaseWrapper.create_cursorcCsB|jdurt |jWdS1swYdSdSr=)rr2rrrrr_commits $zDatabaseWrapper._commitcCs,|jr|jd|j|dddSdS)Nz-- RELEASE SAVEPOINT %s (faked)z0.000)sqltime)queries_logged queries_logappendops quote_name)r9sidrrr_savepoint_commits  z!DatabaseWrapper._savepoint_commitcCs4|j ||j_WddS1swYdSr=)wrap_database_errorsr autocommit)r9rrrr_set_autocommit!s "zDatabaseWrapper._set_autocommitcCs |d|ddS)zl Check constraints by setting them to immediate. Return them to deferred afterward. zSET CONSTRAINTS ALL IMMEDIATEzSET CONSTRAINTS ALL DEFERREDN)r6r)r9 table_namesrrrcheck_constraints%sz!DatabaseWrapper.check_constraintscCs(z|jWdStjyYdSw)NFT)rpingr+Errorrrrr is_usable-s  zDatabaseWrapper.is_usablecCsH|tdd|jjdDWdS1swYdS)Ncss|]}t|VqdSr=)r)rrr1rrr 8sz1DatabaseWrapper.oracle_version...)temporary_connectionr0rversionsplitrrrroracle_version5s $zDatabaseWrapper.oracle_versionr=)/r>r?r@vendor display_name data_typesdata_type_check_constraints_limited_data_typesr3r4rr pattern_esc _pattern_opsitemsrrr+r&SchemaEditorClassr! client_classr"creation_classr#features_classr$introspection_classr% ops_classr(validation_classryrrrrrrrrrrrr r __classcell__rrrrrA]s        ( rAc@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}|durd}n|dur"d}t|dr.|||_n$t|t j tj fr;||_nt ||j ||_t|jtrRtt||j |}t|dr]|j|_dS|dkrgt j|_dSt|tjrst j|_dSd|_dS)NrTr Fbind_parameter input_sizei)rr isinstancedatetimer' from_datetimer.rrr+Binary timedeltarcharsetstrlenrCLOBrM)r9paramr6 strings_only string_sizerrrryEs.         zOracleParam.__init__NF)r>r?r@__doc__ryrrrrr;s 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 ||_dSr=var)r9rrrrryqrzVariableWrapper.__init__cCs|jSr=rrrrrrtszVariableWrapper.bind_parametercC t|j|Sr=)getattrr)r9keyrrr __getattr__w zVariableWrapper.__getattr__cCs(|dkr ||j|<dSt|j||dS)Nr)r8setattrr)r9rrrrr __setattr__zszVariableWrapper.__setattr__N)r>r?r@rryrrrrrrrris  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_dSr=)r6_output_type_handleroutputtypehandler)r9rrrrrys 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)rtrquantize_valuerrzEFormatStylePlaceholderCursor._get_decimal_converter..)rrContextrscaleb) precisionscalerrr_get_decimal_converters  z3FormatStylePlaceholderCursor._get_decimal_convertercCs^|tjkr-|dkr|dkrtj}nt}n|dkrt||}ntj}|jtjd|j|dSdS)zx Called for each db column fetched from cursors. Return numbers as the appropriate Python type. ir)size arraysize outconverterN) r+NUMBERrrfloatrrSTRINGr)r6r defaultTypelengthrrrrrrrs z1FormatStylePlaceholderCursor._output_type_handlercsBz fdd|DWSty tfdd|DYSw)Ncsi|] \}}|t|dqS)Trrqrrrrusz?FormatStylePlaceholderCursor._format_params..c3s|] }t|dVqdS)TNrrrprrrrsz>FormatStylePlaceholderCursor._format_params..)rr5r0r9paramsrrr_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)r.rr setinputsizesr enumerate)r9 params_listsizesr rsrirrr_guess_input_sizess*  z/FormatStylePlaceholderCursor._guess_input_sizescCs*t|drdd|DSdd|DS)NrcSsi|]\}}||jqSrrrqrrrruszAFormatStylePlaceholderCursor._param_generator..cSsg|]}|jqSrrrrrr szAFormatStylePlaceholderCursor._param_generator..)r.rr rrr_param_generators z-FormatStylePlaceholderCursor._param_generatorFcs|ds |dr|dd}|durg}nJt|dr(dd|D}||}n9|rP|rPddtt|Dfdd |D}d dD}|t|}nd d tt|D}|t|}|||fS) N;/r cSsi|]}|d|qS)z:%sr)rrrsrrrruz@FormatStylePlaceholderCursor._fix_for_params..cSsi|] \}}|d|qSz:arg%dr)rrrrrrrruscsg|]}|qSrr)rrr params_dictrrrrz@FormatStylePlaceholderCursor._fix_for_params..cSsi|]\}}||qSrr)rrrrrrrrurcSsg|]}d|qSrr)rrrrrrrr) rmr.rsetrr0rangerr )r9queryr unify_by_valuesr-rrr_fix_for_paramss    z,FormatStylePlaceholderCursor._fix_for_paramsNcCs^|j||dd\}}||gt|j|||WdS1s(wYdS)NT)r!)r"rr2r6rr)r9r r rrrrs  $z$FormatStylePlaceholderCursor.executecs|sdSt|}|t|\}}|gfdd|D}|tj|fdd|DWdS1s?wYdS)Ncg|]}|qSr)r rrrrr rz.cr#r)rrrrrr r)iterr"nextrr2r6 executemany)r9r r  params_iter firstparams formattedrrrr&s $z(FormatStylePlaceholderCursor.executemanycCs(z|jWdStjyYdSwr=)r6r7r+InterfaceErrorrrrrr7s z"FormatStylePlaceholderCursor.closecGt|jj|Sr=)rr6rr9r-rrrrz FormatStylePlaceholderCursor.varcGr+r=)rr6arrayvarr,rrrr.r-z%FormatStylePlaceholderCursor.arrayvarcCrr=)rr6)r9attrrrrrrz(FormatStylePlaceholderCursor.__getattr__cCrr=)r$r6rrrr__iter__rz%FormatStylePlaceholderCursor.__iter__rr=)r>r?r@rrry staticmethodrrrr rrr"rr&r7rr.rr0rrrrrs*        r).rrrrr contextlibr django.confrdjango.core.exceptionsr django.dbrdjango.db.backends.base.baserdjango.utils.encodingrrdjango.utils.functionalr r cx_Oracler+rrclientr!creationr"r|r# introspectionr$ operationsr%schemar&r' validationr(r2r3rArrrrrrrsN                  _.