3 gX@sdZddlZddlZddlZddlZddlmZddlmZddl m Z ddl m Z ddl mZddlmZdd lmZmZdd lmZd d Zed'd(gy ddlZWn.ek rZze deWYddZ[XnXddlmZddlmZddlm Z ddl!m"Z"ddl#m$Z$ddl%m&Z&ddl'm(Z(m)Z)ddl*m+Z+eddZ,GdddZ-Gdd d eZ.Gd!d"d"Z/Gd#d$d$Z0Gd%d&d&Z1dS))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_propertycCstjjjdrxy ddl}Wn.tk rL}ztd|WYdd}~XnX|jd}x*|D]\}}|j||q^Wn t j j |dS)NZCYGWINrz_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.kernel32) platformsystemupper startswithctypes ImportErrorrCDLLZSetEnvironmentVariableAosenvironupdate)rrer namevaluer\/var/www/tester-filtro-web/env/lib/python3.6/site-packages/django/db/backends/oracle/base.py_setup_environments  rNLS_LANG .AL32UTF8ORA_NCHAR_LITERAL_REPLACETRUEz"Error loading cx_Oracle module: %s)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)Oracle_datetimedsn)DatabaseValidationccsy dVWnptjk rz}zR|jd}t|drht|drh|jdkrhd|jksZd|jkrhtt|jWYdd}~XnXdS)Nrcodemessagei+z ORA-02291z ORA-00001)Database DatabaseErrorargshasattrr*r+rtuple)rxrrrwrap_oracle_errors?s     r2c@seZdZdddZdS)!_UninitializedOperatorsDescriptorNcCs&|dkrtd|jj|jdS)Nz*operators not available as class attribute operators)AttributeErrorcursorclose__dict__)selfinstanceclsrrr__get__[s z)_UninitializedOperatorsDescriptor.__get__)N)__name__ __module__ __qualname__r<rrrrr3Ysr3cszeZdZdZdZddddddd d d ddd d dddddd dd d ddd dd dddZdddddddZdMZeZ dddd d!d"d#d$ddd d d% Z e d&d'd&d&d'd'd(Z d)Z d*d+d,d-d.d/d0Z d1d2e jDZd3d2e jDZeZeZeZeZeZeZeZeZfd4d5Z d6d7Z!e"d8d9Z#d:d;Z$e"dNd=d>Z%d?d@Z&dAdBZ'dCdDZ(dOdEdFZ)dGdHZ*e+dIdJZ,e+dKdLZ-Z.S)PDatabaseWrapperoracleZOraclez3NUMBER(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)ZNCLOBz NUMBER(19)z VARCHAR2(15)z VARCHAR2(39)z2NUMBER(5) GENERATED BY DEFAULT ON NULL AS IDENTITYzVARCHAR2(%(max_length)s)z VARCHAR2(32))Z AutoFieldZ BigAutoFieldZ BinaryField BooleanFieldZ CharFieldZ DateFieldZ DateTimeFieldZ DecimalFieldZ DurationFieldZ FileFieldZ FilePathFieldZ FloatFieldZ IntegerField JSONFieldZBigIntegerFieldZIPAddressFieldZGenericIPAddressFieldNullBooleanFieldZ OneToOneFieldPositiveBigIntegerFieldPositiveIntegerFieldPositiveSmallIntegerFieldZ SlugFieldZSmallAutoFieldZSmallIntegerFieldZ TextFieldZ TimeFieldZURLFieldZ UUIDFieldz%(qn_column)s IN (0,1)z%(qn_column)s IS JSONz%(qn_column)s >= 0)rCrDrErFrGrHclobnclobblobz= %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 '\')rMrNrrQrRrSz@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z {} || '%%'zUPPER({}) || '%%'z '%%' || {}z'%%' || UPPER({}))rMrNrrRrQrScCsi|]\}}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)rTrUrVrrrrWscs,tj|||jdjdd}||j_dS)NOPTIONSuse_returning_intoT)super__init__ settings_dictgetfeaturesZcan_return_columns_from_insert)r9r.kwargsrY) __class__rrr[szDatabaseWrapper.__init__cCs |jdj}d|kr|d=|S)NrXrY)r\copy)r9 conn_paramsrrrget_connection_paramssz%DatabaseWrapper.get_connection_paramscCs*tjf|jd|jdt|jd|S)NUSERZPASSWORD)userpasswordr()r,connectr\r()r9rbrrrget_new_connections  z"DatabaseWrapper.get_new_connectionc Cs|j}|jd|jdtjr"dnd|jd|jkr|j}y|jd|jddgWn&tjk r|j |_ |j |_ YnX|j|_ |j |_ |jd |j_|js|jdS) 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 %srMX) create_cursorexecuterUSE_TZr7r8_standard_operatorsr,r-_likec_operatorsr4_likec_pattern_opsZ pattern_ops_standard_pattern_ops connectionZ stmtcachesizeZget_autocommitcommit)r9r6rrrinit_connection_states*    z%DatabaseWrapper.init_connection_stateNcCs t|jS)N)FormatStylePlaceholderCursorrs)r9rrrrrlszDatabaseWrapper.create_cursorc Cs&|jdk r"t |jjSQRXdS)N)rsr2rt)r9rrr_commits zDatabaseWrapper._commitcCs(|jr$|jjd|jj|dddS)Nz-- RELEASE SAVEPOINT %s (faked)z0.000)Zsqltime)Zqueries_loggedZ queries_logappendopsZ quote_name)r9Zsidrrr_savepoint_commitsz!DatabaseWrapper._savepoint_commitc Cs|j||j_WdQRXdS)N)Zwrap_database_errorsrs autocommit)r9r|rrr_set_autocommit&szDatabaseWrapper._set_autocommitc Cs,|j}|jd|jdWdQRXdS)zl Check constraints by setting them to immediate. Return them to deferred afterward. zSET CONSTRAINTS ALL IMMEDIATEzSET CONSTRAINTS ALL DEFERREDN)r6rm)r9Z table_namesr6rrrcheck_constraints*s  z!DatabaseWrapper.check_constraintsc Cs.y|jjWntjk r$dSXdSdS)NFT)rsZpingr,Error)r9rrr is_usable3s zDatabaseWrapper.is_usablecCstddtjjdDS)Ncss|]}t|VqdS)N)int)rTr1rrr =sz4DatabaseWrapper.cx_oracle_version...)r0r,versionsplit)r9rrrcx_oracle_version;sz!DatabaseWrapper.cx_oracle_versionc Cs0|jtdd|jjjdDSQRXdS)Ncss|]}t|VqdS)N)r)rTr1rrrrBsz1DatabaseWrapper.oracle_version..r)Ztemporary_connectionr0rsrr)r9rrroracle_version?s zDatabaseWrapper.oracle_version)rIrJrK)N)N)/r=r>r?vendorZ display_nameZ data_typesZdata_type_check_constraintsZ_limited_data_typesr3r4rorpZ pattern_escZ _pattern_opsitemsrrrqr,r&ZSchemaEditorClassr!Z client_classr"Zcreation_classr#Zfeatures_classr$Zintrospection_classr%Z ops_classr)Zvalidation_classr[rcrrhrurlrwr{r}r~rr rr __classcell__rr)r`rr@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|t r(tj|}d}|dkr:d}n |dkrFd}t|dr^|j||_nHt|t j tj frx||_n.t ||j ||_t|jtrtt||j |}t|dr|j|_n.|dkrt j|_nt|tjrt j|_nd|_dS)NrTr Fbind_parameter input_sizei)rrn isinstancedatetimer' from_datetimer/rrr,Binary timedeltar charsetstrlenrZCLOBrB)r9paramr6Z strings_onlyZ string_sizerrrr[Os,         zOracleParam.__init__N)F)r=r>r?__doc__r[rrrrrEsrc@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)r9rrrrr[{szVariableWrapper.__init__cCs|jS)N)r)r9r6rrrr~szVariableWrapper.bind_parametercCs t|j|S)N)getattrr)r9keyrrr __getattr__szVariableWrapper.__getattr__cCs&|dkr||j|<nt|j||dS)Nr)r8setattrr)r9rrrrr __setattr__s zVariableWrapper.__setattr__N)r=r>r?rr[rrrrrrrrss rc@seZdZdZdZddZeddZeddZed d Z d d Z d dZ ddZ d#ddZ d$ddZd%ddZddZddZddZdd Zd!d"ZdS)&rvz 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|j_dS)N)r6_output_type_handlerZoutputtypehandler)r9rsrrrr[s z%FormatStylePlaceholderCursor.__init__cCsd|krtj|St|S)Nr)decimalDecimalr)rrrr_output_number_convertersz5FormatStylePlaceholderCursor._output_number_convertercs8|dkr tStj|dtjdj| fddS)Nr)precr cstj|jdS)N)context)rrquantize)rV)rquantize_valuerrszEFormatStylePlaceholderCursor._get_decimal_converter..)rrContextrscaleb) precisionscaler)rrr_get_decimal_converters  z3FormatStylePlaceholderCursor._get_decimal_convertercCs^|tjkrZ|dkr(|dkr"tj}qDt}n|dkr>tj||}ntj}|jtjd|j|dSdS)zx Called for each db column fetched from cursors. Return numbers as the appropriate Python type. r)size arraysize outconverterNi) r,NUMBERrvrfloatrrSTRINGr)r6rZ defaultTypelengthrrrrrrrs z1FormatStylePlaceholderCursor._output_type_handlerc sByfdd|jDStk r<tfdd|DSXdS)Ncsi|]\}}t|d|qS)T)r)rTrUrV)r9rrrWsz?FormatStylePlaceholderCursor._format_params..c3s|]}t|dVqdS)TN)r)rTp)r9rrrsz>FormatStylePlaceholderCursor._format_params..)rr5r0)r9paramsr)r9r_format_paramssz+FormatStylePlaceholderCursor._format_paramscCst|ddrXi}x2|D]*}x$|jD]\}}|jr&|j||<q&WqW|r|jf|nTdgt|d}x2|D]*}x$t|D]\}}|jr~|j||<q~WqpW|r|j|dS)Nrkeys)r/rrZ setinputsizesr enumerate)r9Z params_listsizesrrUrirrr_guess_input_sizess  z/FormatStylePlaceholderCursor._guess_input_sizescCs.t|drdd|jDSdd|DSdS)NrcSsi|]\}}|j|qSr)r)rTrUrVrrrrWszAFormatStylePlaceholderCursor._param_generator..cSsg|] }|jqSr)r)rTrrrr szAFormatStylePlaceholderCursor._param_generator..)r/r)r9rrrr_param_generators z-FormatStylePlaceholderCursor._param_generatorFcs|jds|jdr |dd }|dkr.g}nt|drPdd|D}||}nt|r|rddttj|Dfdd |D}d djD}|t|}n"d d tt|D}|t|}||j |fS) N;/r rcSsi|]}d||qS)z:%sr)rTrUrrrrWsz@FormatStylePlaceholderCursor._fix_for_params..cSsi|]\}}d||qS)z:arg%dr)rTrrrrrrWscsg|] }|qSrr)rTr) params_dictrrrsz@FormatStylePlaceholderCursor._fix_for_params..cSsi|]\}}||qSrr)rTrrrrrrWscSsg|] }d|qS)z:arg%dr)rTrrrrrs) rQr/rdictfromkeysrr0rangerr)r9queryrunify_by_valuesr.r)rr_fix_for_paramss     z,FormatStylePlaceholderCursor._fix_for_paramsNc CsF|j||dd\}}|j|gt|jj||j|SQRXdS)NT)r)rrr2r6rmr)r9rrrrrrms z$FormatStylePlaceholderCursor.executec st|sdSt|}j|t|\}}|gfdd|D}j|tjj|fdd|DSQRXdS)Ncsg|]}j|qSr)r)rTr)r9rrrsz.csg|]}j|qSr)r)rTr)r9rrrs)iterrnextrr2r6 executemany)r9rrZ params_iterZ firstparams formattedr)r9rr s z(FormatStylePlaceholderCursor.executemanyc Cs*y|jjWntjk r$YnXdS)N)r6r7r,ZInterfaceError)r9rrrr7sz"FormatStylePlaceholderCursor.closecGst|jj|S)N)rr6r)r9r.rrrr"sz FormatStylePlaceholderCursor.varcGst|jj|S)N)rr6arrayvar)r9r.rrrr%sz%FormatStylePlaceholderCursor.arrayvarcCs t|j|S)N)rr6)r9attrrrrr(sz(FormatStylePlaceholderCursor.__getattr__cCs t|jS)N)rr6)r9rrr__iter__+sz%FormatStylePlaceholderCursor.__iter__)F)N)N)r=r>r?rrr[ staticmethodrrrrrrrrmrr7rrrrrrrrrvs"   ! "  rv)rr)rr)2rrrrr contextlibrZ django.confrZdjango.core.exceptionsrZ django.dbrZdjango.db.backends.base.baserZdjango.utils.asynciorZdjango.utils.encodingrr Zdjango.utils.functionalr rZ cx_Oracler,rrclientr!Zcreationr"r^r#Z introspectionr$ operationsr%Zschemar&utilsr'r(Z validationr)r2r3r@rrrvrrrrsF                 `.