U 8T_[ @sdZddlZddlZddlZddlZddlmZddlmZddl m Z ddl m Z ddl mZddlmZdd lmZmZdd lmZd d Zed dgz ddlZWn.ek rZze deW5dZ[XYnXddlmZddlmZddlm Z ddl!m"Z"ddl#m$Z$ddl%m&Z&ddl'm(Z(ddl)m*Z*eddZ+GdddZ,GdddeZ-Gdd d Z.Gd!d"d"Z/Gd#d$d$Z0dS)%ze Oracle database backend for Django. Requires cx_Oracle: https://oracle.github.io/python-cx_Oracle/ N)contextmanager)settings)ImproperlyConfigured)IntegrityError)BaseDatabaseWrapper) async_unsafe) force_bytes force_str)cached_propertyc Cstdrtz ddl}Wn.tk rL}ztd|W5d}~XYnX|d}|D]\}}|||q\n t j |dS)NZCYGWINrz_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.kernel32) platformsystemupper startswithctypes ImportErrorrCDLLZSetEnvironmentVariableAosenvironupdate)rrer namevaluerB/tmp/pip-unpacked-wheel-dv63caxw/django/db/backends/oracle/base.py_setup_environments   r)ZNLS_LANGz .AL32UTF8)ZORA_NCHAR_LITERAL_REPLACETRUEz"Error loading cx_Oracle module: %s)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)Oracle_datetime)DatabaseValidationc csz dVWnptjk rz}zP|jd}t|drht|drh|jdkrhd|jksZd|jkrhtt|jW5d}~XYnXdS)Nrcodemessagei+z ORA-02291z ORA-00001)Database DatabaseErrorargshasattrr&r'rtuple)rxrrrwrap_oracle_errors?s   r.c@seZdZdddZdS)!_UninitializedOperatorsDescriptorNcCs&|dkrtd||jdS)Nz*operators not available as class attribute operators)AttributeErrorcursorclose__dict__)selfinstanceclsrrr__get__[s z)_UninitializedOperatorsDescriptor.__get__)N)__name__ __module__ __qualname__r8rrrrr/Ysr/cseZdZdZdZddddddd d d ddd d dddddd dd d ddd dd dddZdddddddZdZeZ dddddd d!d"ddddd# Z e d$d%d$d$d%d%d&Z d'Z d(d)d*d+d,d-d.Z d/d0e DZd1d0e DZeZeZeZeZeZeZeZeZfd2d3Z d4d5Z!d6d7Z"d8d9Z#e$d:d;Z%d= 0)r?r@rArBrCrD)ZclobZnclobZblobz= %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) exactZiexactcontains icontainsgtZgteltZlterendswith istartswith iendswithzLIKEC %s ESCAPE '\'zLIKEC UPPER(%s) ESCAPE '\')rFrGrrJrKrLz@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z {} || '%%'zUPPER({}) || '%%'z '%%' || {}z'%%' || UPPER({}))rFrGrrKrJrLcCsi|]\}}|d|dqS)zLIKE TRANSLATE( z5 USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)r.0kvrrr szDatabaseWrapper.cCsi|]\}}|d|dqS)zLIKEC z ESCAPE '\'rrMrrrrQscs,tj|||jddd}||j_dS)NOPTIONSuse_returning_intoT)super__init__ settings_dictgetfeaturesZcan_return_columns_from_insert)r5r*kwargsrS __class__rrrUszDatabaseWrapper.__init__cCsH|j}|dsd|d<|dr@t|dt|d|dS|dS)NZHOST localhostZPORTNAME)rVstripr(Zmakedsnint)r5rVrrr_dsns  zDatabaseWrapper._dsncCsd|jd|jd|fS)Nz %s/"%s"@%sUSERPASSWORD)rVr`r5rrr_connect_stringszDatabaseWrapper._connect_stringcCs |jd}d|kr|d=|S)NrRrS)rVcopyr5Z conn_paramsrrrget_connection_paramssz%DatabaseWrapper.get_connection_paramscCs(tjf|jd|jd|d|S)Nrarb)userpasswordZdsn)r(connectrVr`rfrrrget_new_connectionsz"DatabaseWrapper.get_new_connectioncCs|}|d|dtjr"dnd|d|jkr|}z|d|jddgWn&tjk r|j |_ |j |_ YnX|j|_ |j |_ |d |j_|s|dS) 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'r0z!SELECT 1 FROM DUAL WHERE DUMMY %srFX) create_cursorexecuterUSE_TZr3r4_standard_operatorsr(r)_likec_operatorsr0_likec_pattern_opsZ pattern_ops_standard_pattern_ops connectionZ stmtcachesizeZget_autocommitcommitr5r2rrrinit_connection_states2   z%DatabaseWrapper.init_connection_stateNcCs t|jSN)FormatStylePlaceholderCursorrv)r5rrrrroszDatabaseWrapper.create_cursorc Cs2|jdk r.t|jW5QRSQRXdSrz)rvr.rwrcrrr_commit#s zDatabaseWrapper._commitcCs(|jr$|jd|j|dddS)Nz-- RELEASE SAVEPOINT %s (faked)z0.000)Zsqltime)Zqueries_loggedZ queries_logappendopsZ quote_name)r5Zsidrrr_savepoint_commit*s z!DatabaseWrapper._savepoint_commitc Cs|j||j_W5QRXdSrz)Zwrap_database_errorsrv autocommit)r5rrrr_set_autocommit1szDatabaseWrapper._set_autocommitc Cs,|}|d|dW5QRXdS)zl Check constraints by setting them to immediate. Return them to deferred afterward. zSET CONSTRAINTS ALL IMMEDIATEzSET CONSTRAINTS ALL DEFERREDN)r2rp)r5Z table_namesr2rrrcheck_constraints5s  z!DatabaseWrapper.check_constraintscCs0z|jWntjk r&YdSXdSdS)NFT)rvZpingr(Errorrcrrr is_usable>s zDatabaseWrapper.is_usablecCstddtjdDS)Ncss|]}t|VqdSrzr_rNr-rrr Hsz4DatabaseWrapper.cx_oracle_version...)r,r(versionsplitrcrrrcx_oracle_versionFsz!DatabaseWrapper.cx_oracle_versionc Cs<|*tdd|jjdDW5QRSQRXdS)Ncss|]}t|VqdSrzrrrrrrMsz1DatabaseWrapper.oracle_version..r)Ztemporary_connectionr,rvrrrcrrroracle_versionJs zDatabaseWrapper.oracle_version)N)N)1r9r:r;vendorZ display_nameZ data_typesZdata_type_check_constraintsZ_limited_data_typesr/r0rrrsZ pattern_escZ _pattern_opsitemsrurtr(r#ZSchemaEditorClassrZ client_classrZcreation_classr Zfeatures_classr!Zintrospection_classr"Z ops_classr%Zvalidation_classrUr`rdrgrrkryror|rrrrr rr __classcell__rrrZrr<fs      (   r<c@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. FcCstjr&t|tjr&t|ts&t|}d}|dkr8d}n |dkrDd}t|dr\|||_nHt|t j tj frv||_n.t ||j ||_t|jtrtt||j |}t|dr|j|_n.|dkrt j|_nt|tjrt j|_nd|_dS)NrTrFbind_parameter input_sizei)rrq isinstancedatetimer$Z from_datetimer+rrr(Binary timedeltar charsetstrlenrZCLOBr>)r5paramr2Z strings_onlyZ string_sizerrrrUZs.        zOracleParam.__init__N)F)r9r:r;__doc__rUrrrrrPs 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 ||_dSrzvar)r5rrrrrUszVariableWrapper.__init__cCs|jSrzrrxrrrrszVariableWrapper.bind_parametercCs t|j|Srz)getattrr)r5keyrrr __getattr__szVariableWrapper.__getattr__cCs&|dkr||j|<nt|j||dS)Nr)r4setattrr)r5rrrrr __setattr__s zVariableWrapper.__setattr__N)r9r:r;rrUrrrrrrrr~s rc@seZdZdZdZddZeddZeddZed d Z d d Z d dZ ddZ d#ddZ d$ddZd%ddZddZddZddZdd Zd!d"ZdS)&r{z 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_dSrz)r2_output_type_handlerZoutputtypehandler)r5rvrrrrUs z%FormatStylePlaceholderCursor.__init__cCsd|krt|St|S)Nr)decimalDecimalr_)rrrr_output_number_convertersz5FormatStylePlaceholderCursor._output_number_convertercs8|dkr tStj|dtd| fddS)Nr)precrcst|jdS)N)context)rrquantize)rPrZquantize_valuerrzEFormatStylePlaceholderCursor._get_decimal_converter..)r_rContextrscaleb) precisionscalerrr_get_decimal_converters  z3FormatStylePlaceholderCursor._get_decimal_convertercCs^|tjkrZ|dkr(|dkr"tj}qDt}n|dkr>t||}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(NUMBERr{rfloatrrSTRINGr)r2rZ defaultTypelengthrrrrrrrs z1FormatStylePlaceholderCursor._output_type_handlercsHzfdd|DWStk rBtfdd|DYSXdS)Ncsi|]\}}|t|dqS)TrrMrcrrrQsz?FormatStylePlaceholderCursor._format_params..c3s|]}t|dVqdS)TNrrNprcrrrsz>FormatStylePlaceholderCursor._format_params..)rr1r,r5paramsrrcr_format_paramssz+FormatStylePlaceholderCursor._format_paramscCst|ddrPi}|D]&}|D]\}}|jr"|j||<q"q|r|jf|nLdgt|d}|D]&}t|D]\}}|jrr|j||<qrqf|r|j|dS)Nrkeys)r+rrZ setinputsizesr enumerate)r5Z params_listZsizesrrOrirrr_guess_input_sizessz/FormatStylePlaceholderCursor._guess_input_sizescCs.t|drdd|DSdd|DSdS)NrcSsi|]\}}||jqSrrrMrrrrQszAFormatStylePlaceholderCursor._param_generator..cSsg|] }|jqSrrrrrr szAFormatStylePlaceholderCursor._param_generator..)r+rrrrr_param_generators z-FormatStylePlaceholderCursor._param_generatorFcs|ds|dr |dd}|dkr.g}nt|drPdd|D}||}nt|r|rddtt|Dfdd |D}d dD}|t|}n"d d tt|D}|t|}|| |fS) N;/rcSsi|]}|d|qS)z:%sr)rNrOrrrrQsz@FormatStylePlaceholderCursor._fix_for_params..cSsi|]\}}|d|qSz:arg%dr)rNrrrrrrQscsg|] }|qSrr)rNr params_dictrrr sz@FormatStylePlaceholderCursor._fix_for_params..cSsi|]\}}||qSrr)rNrrrrrrQ scSsg|] }d|qSrr)rNrrrrrs) rJr+rdictfromkeysrr,rangerr)r5queryrunify_by_valuesr*rrr_fix_for_paramss"     z,FormatStylePlaceholderCursor._fix_for_paramsNc CsR|j||dd\}}||gt"|j|||W5QRSQRXdS)NT)r)rrr.r2rpr)r5rrrrrrps z$FormatStylePlaceholderCursor.executec s|sdSt|}|t|\}}|gfdd|D}|t*j|fdd|DW5QRSQRXdS)Ncsg|]}|qSr)rrrcrrr!sz.csg|]}|qSr)rrrcrrr$s)iterrnextrr.r2 executemany)r5rrZ params_iterZ firstparams formattedrrcrrs z(FormatStylePlaceholderCursor.executemanycCs*z|jWntjk r$YnXdSrz)r2r3r(ZInterfaceErrorrcrrrr3&sz"FormatStylePlaceholderCursor.closecGst|jj|Srz)rr2rr5r*rrrr-sz FormatStylePlaceholderCursor.varcGst|jj|Srz)rr2arrayvarrrrrr0sz%FormatStylePlaceholderCursor.arrayvarcCs t|j|Srz)rr2)r5attrrrrr3sz(FormatStylePlaceholderCursor.__getattr__cCs t|jSrz)rr2rcrrr__iter__6sz%FormatStylePlaceholderCursor.__iter__)F)N)N)r9r:r;rrrU staticmethodrrrrrrrrprr3rrrrrrrrr{s(    "  r{)1rrrrr contextlibrZ django.confrZdjango.core.exceptionsrZ django.dbrZdjango.db.backends.base.baserZdjango.utils.asynciorZdjango.utils.encodingrr Zdjango.utils.functionalr rZ cx_Oracler(rrclientrZcreationrrXr Z introspectionr! operationsr"Zschemar#utilsr$Z validationr%r.r/r<rrr{rrrrsJ                   k.