B 0H[nX @sldZddlZddlZddlZddlZddlmZddlmZddl m Z ddl m Z ddl mZmZddlmZd d Zed d gy ddlZWn.ek rZzed eWddZ[XYnXddlmZddlmZddlmZddlmZddlm Z ddl!m"Z"ddl m#Z#ddl$m%Z%GdddZ&Gddde Z'GdddZ(GdddZ)Gdd d Z*dS)!z\ Oracle database backend for Django. Requires cx_Oracle: http://cx-oracle.sourceforge.net/ N)settings)ImproperlyConfigured)utils)BaseDatabaseWrapper) force_bytes force_text)cached_propertyc Cstdrxy ddl}Wn.tk rL}ztd|Wdd}~XYnX|d}x*|D]\}}|||q^Wn t j |dS)NZCYGWINrz_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.kernel32) platformsystemupper startswithctypes ImportErrorrCDLLZSetEnvironmentVariableAosenvironupdate)rrer namevaluerbC:\Users\HIRONO~1\AppData\Local\Temp\pip-install-6bm3nxem\django\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@seZdZdddZdS)!_UninitializedOperatorsDescriptorNcCs&|dkrtd||jdS)Nz*operators not available as class attribute operators)AttributeErrorcursorclose__dict__)selfinstanceclsrrr__get__?s z)_UninitializedOperatorsDescriptor.__get__)N)__name__ __module__ __qualname__r-rrrrr$=sr$cszeZdZdZdZddddddd d d ddd d ddddd d d dd dd dddZdddddZdZeZ dddddddd ddddd! Z e Z e d"d#d"d"d#d#d$d%Zd&d'd(d)d*d+d,Zd-d.eDZd/d.eDZeZeZeZeZeZeZeZe Z!fd0d1Z"d2d3Z#d4d5Z$d6d7Z%d8d9Z&dKd;d<Z'd=d>Z(d?d@Z)dAdBZ*dLdCdDZ+dEdFZ,e-dGdHZ.e-dIdJZ/Z0S)MDatabaseWrapperZoracleZOraclez3NUMBER(11) GENERATED BY DEFAULT ON NULL AS IDENTITYz3NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITYZBLOBz NUMBER(1)zNVARCHAR2(%(max_length)s)ZDATE TIMESTAMPz*NUMBER(%(max_digits)s, %(decimal_places)s)zINTERVAL DAY(9) TO SECOND(6)zDOUBLE PRECISIONz NUMBER(11)z NUMBER(19)z VARCHAR2(15)z VARCHAR2(39)ZNCLOBzVARCHAR2(%(max_length)s)z VARCHAR2(32))Z AutoFieldZ BigAutoFieldZ BinaryField BooleanFieldZ CharFieldZ DateFieldZ DateTimeFieldZ DecimalFieldZ DurationFieldZ FileFieldZ FilePathFieldZ FloatFieldZ IntegerFieldZBigIntegerFieldZIPAddressFieldZGenericIPAddressFieldNullBooleanFieldZ OneToOneFieldPositiveIntegerFieldPositiveSmallIntegerFieldZ SlugFieldZSmallIntegerFieldZ TextFieldZ TimeFieldZURLFieldZ UUIDFieldz%(qn_column)s IN (0,1)z%(qn_column)s >= 0)r3r4r5r6)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 icontainsgtZgteltZlter endswith istartswith iendswithzLIKEC %s ESCAPE '\'zLIKEC UPPER(%s) ESCAPE '\')r8r9r r<r=r>z@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z {} || '%%'zUPPER({}) || '%%'z '%%' || {}z'%%' || UPPER({}))r8r9r r=r<r>cCsi|]\}}d|d|qS)zLIKE TRANSLATE( z5 USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)r).0kvrrr szDatabaseWrapper.cCsi|]\}}d|d|qS)zLIKEC z ESCAPE '\'r)r?r@rArrrrBscs,tj|||jddd}||j_dS)NOPTIONSuse_returning_intoT)super__init__ settings_dictgetfeaturesZcan_return_id_from_insert)r*argskwargsrD) __class__rrrFszDatabaseWrapper.__init__cCs`|j}|dsd|d<|drBt|dt|d|d}n|d}d|d|d|fS)NZHOST localhostZPORTNAMEz%s/%s@%sUSERZPASSWORD)rGstripDatabaseZmakedsnint)r*rGZdsnrrr_connect_strings    zDatabaseWrapper._connect_stringcCs |jd}d|kr|d=|S)NrCrD)rGcopy)r* conn_paramsrrrget_connection_paramssz%DatabaseWrapper.get_connection_paramscCstj|f|S)N)rQconnectrS)r*rUrrrget_new_connectionsz"DatabaseWrapper.get_new_connectioncCs|}|d|dtjr"dnd|d|jkr|}y|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'r%z!SELECT 1 FROM DUAL WHERE DUMMY %sr8X) create_cursorexecuterUSE_TZr(r)_standard_operatorsrQ DatabaseError_likec_operatorsr%_likec_pattern_opsZ pattern_ops_standard_pattern_ops connectionZ stmtcachesizeZget_autocommitcommit)r*r'rrrinit_connection_states*    z%DatabaseWrapper.init_connection_stateNcCs t|jS)N)FormatStylePlaceholderCursorrd)r*rrrrr\szDatabaseWrapper.create_cursorc Cs|jdk r~y |jStjk r|}zH|jd}t|drjt|drj|jdkrjd|jkrjtj t |jWdd}~XYnXdS)Nrcodemessagei+z ORA-02291) rdrerQr`rJhasattrrhrirZIntegrityErrortuple)r*rxrrr_commits   zDatabaseWrapper._commitcCs(|jr$|jd|j|dddS)Nz-- RELEASE SAVEPOINT %s (faked)z0.000)Zsqltime)Zqueries_loggedZ queries_logappendopsZ quote_name)r*Zsidrrr_savepoint_commitsz!DatabaseWrapper._savepoint_commitc Cs|j||j_WdQRXdS)N)Zwrap_database_errorsrd autocommit)r*rrrrr_set_autocommitszDatabaseWrapper._set_autocommitcCs |d|ddS)zl Check constraints by setting them to immediate. Return them to deferred afterward. zSET CONSTRAINTS ALL IMMEDIATEzSET CONSTRAINTS ALL DEFERREDN)r'r])r*Z table_namesrrrcheck_constraintssz!DatabaseWrapper.check_constraintscCs.y|jWntjk r$dSXdSdS)NFT)rdZpingrQError)r*rrr is_usable$s zDatabaseWrapper.is_usablec Cs| |jjSQRXdS)N)Ztemporary_connectionrdversion)r*rrroracle_full_version,s z#DatabaseWrapper.oracle_full_versioncCs.yt|jddStk r(dSXdS)N.r)rRrxsplit ValueError)r*rrroracle_version1szDatabaseWrapper.oracle_version)N)N)1r.r/r0vendorZ display_nameZ data_typesZdata_type_check_constraintsZ_limited_data_typesr$r%r_rTrarZ pattern_escZ _pattern_opsitemsrcrbrQr!ZSchemaEditorClassrZ client_classrZcreation_classrZfeatures_classrZintrospection_classr Z ops_classr#Zvalidation_classrFrSrVrXrfr\rmrqrsrtrvrrxr| __classcell__rr)rLrr1Js      (   r1c@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|_nd|_dS)NrTrFbind_parameter input_sizei)rr^ isinstancedatetimer"Z from_datetimerjrrrQBinary timedeltarcharsetstrlenrZCLOB)r*paramr'Z strings_onlyZ string_sizerrrrFCs(       zOracleParam.__init__N)F)r.r/r0__doc__rFrrrrr9src@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 ||_dS)N)var)r*rrrrrFmszVariableWrapper.__init__cCs|jS)N)r)r*r'rrrrpszVariableWrapper.bind_parametercCs t|j|S)N)getattrr)r*keyrrr __getattr__sszVariableWrapper.__getattr__cCs&|dkr||j|<nt|j||dS)Nr)r)setattrr)r*rrrrr __setattr__vs zVariableWrapper.__setattr__N)r.r/r0rrFrrrrrrrres rc@seZdZdZdZddZeddZeddZd d Z d d Z d dZ d%ddZ d&ddZ d'ddZd(ddZddZddZddZdd Zd!d"Zd#d$ZdS))rgaF 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". We also do automatic conversion between Unicode on the Python side and UTF-8 -- for talking to Oracle -- in here. zutf-8cCs ||_|j|j_d|j_dS)Nd)r'_output_type_handlerZoutputtypehandler arraysize)r*rdrrrrFs  z%FormatStylePlaceholderCursor.__init__cCsd|krt|St|S)Nry)decimalDecimalrR)rrrr_output_number_convertersz5FormatStylePlaceholderCursor._output_number_convertercCsd|tjkr`|dkr(|dkr"tj}qJt}n"|dkrD|dkr.c3s|]}t|dVqdS)TN)r)r?p)r*rr sz>FormatStylePlaceholderCursor._format_params..)r~r&rk)r*paramsr)r*r_format_paramssz+FormatStylePlaceholderCursor._format_paramscCst|ddrTi}x2|D]*}x$|D]\}}|jr&|j||<q&WqW|jf|nPdgt|d}x2|D]*}x$t|D]\}}|jrz|j||<qzWqlW|j|dS)Nrkeys)rjr~rZ setinputsizesr enumerate)r*Z params_listsizesrr@rirrr_guess_input_sizess  z/FormatStylePlaceholderCursor._guess_input_sizescCs.t|drdd|DSdd|DSdS)Nr~cSsi|]\}}|j|qSr)r)r?r@rArrrrBszAFormatStylePlaceholderCursor._param_generator..cSsg|] }|jqSr)r)r?rrrr szAFormatStylePlaceholderCursor._param_generator..)rjr~)r*rrrr_param_generators z-FormatStylePlaceholderCursor._param_generatorFcs|ds|dr |dd}|dkr.g}nt|drPdd|D}||}nz|rt|dkrddtt|Dfd d |D}d dD}|t|}n"d d tt|D}|t|}|||fS) N;/rcSsi|]}d||qS)z:%sr)r?r@rrrrBsz@FormatStylePlaceholderCursor._fix_for_params..rcSsi|]\}}d||qS)z:arg%dr)r?rrrrrrBscsg|] }|qSrr)r?r) params_dictrrrsz@FormatStylePlaceholderCursor._fix_for_params..cSsi|]\}}||qSrr)r?rrrrrrBscSsg|] }d|qS)z:arg%dr)r?rrrrrs) r<rjrrsetr~rkranger)r*queryrunify_by_valuesrJr)rr_fix_for_paramss    z,FormatStylePlaceholderCursor._fix_for_paramsNcCs4|j||dd\}}||g|j|||S)NT)r)rrr'r]r)r*rrrrrr]s z$FormatStylePlaceholderCursor.executecsb|sdSt|}|t|\}}|gfdd|D}|j|fdd|DS)Ncsg|]}|qSr)r)r?r)r*rrrsz.csg|]}|qSr)r)r?r)r*rrrs)iterrnextrr' executemany)r*rrZ params_iterZ firstparams formattedr)r*rrs z(FormatStylePlaceholderCursor.executemanycCs|dkr|j}t|j|S)N)rrkr' fetchmany)r*rrrrrsz&FormatStylePlaceholderCursor.fetchmanycCst|jS)N)rkr'fetchall)r*rrrrsz%FormatStylePlaceholderCursor.fetchallcCs*y|jWntjk r$YnXdS)N)r'r(rQZInterfaceError)r*rrrr( sz"FormatStylePlaceholderCursor.closecGst|jj|S)N)rr'r)r*rJrrrrsz FormatStylePlaceholderCursor.varcGst|jj|S)N)rr'arrayvar)r*rJrrrrsz%FormatStylePlaceholderCursor.arrayvarcCs t|j|S)N)rr')r*attrrrrrsz(FormatStylePlaceholderCursor.__getattr__cCs t|jS)N)rr')r*rrr__iter__sz%FormatStylePlaceholderCursor.__iter__)F)N)N)N)r.r/r0rrrF staticmethodrrrrrrr]rrrr(rrrrrrrrrg}s$  !   rg)+rrrrr Z django.confrZdjango.core.exceptionsrZ django.dbrZdjango.db.backends.base.baserZdjango.utils.encodingrrZdjango.utils.functionalrrZ cx_OraclerQrrclientrZcreationrrIrZ introspectionr operationsr Zschemar!r"Z validationr#r$r1rrrgrrrrs@               p,