^Q\b@sadZddlmZddlZddlZddlZddlZddlZddlZddl m Z ddl m Z ddl mZddlmZddlmZmZdd lmZdd lmZmZdd lmZd d Zed+d,gyddlZWn5ek rMZze deWYddZ[XnXddl m!Z!ddl"m#Z#ddl$m%Z%ddl&m'Z'ddl(m)Z)ddl*m+Z+ddlm,Z,Gddde-Z.GdddeZ/Gdd d e-Z0Gd!d"d"e-Z1Gd#d$d$e-Z2Gd%d&d&ej3Z4d'd(Z5d)d*Z6dS)-z\ Oracle database backend for Django. Requires cx_Oracle: http://cx-oracle.sourceforge.net/ )unicode_literalsN)settings)ImproperlyConfigured)utils)BaseDatabaseWrapper)sixtimezone)RemovedInDjango20Warning) force_bytes force_text)cached_propertycCstjjjdryddl}Wn5tk rb}ztd|WYdd}~XnX|jd}x7|D]\}}|j||qyWnt j j |dS)NZCYGWINrz_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.kernel32) platformsystemupper startswithctypes ImportErrorrCDLLZSetEnvironmentVariableAosenvironupdate)rrer namevaluerD/var/www/dbchiro/venv/build/Django/django/db/backends/oracle/base.py_setup_environmentsrNLS_LANG .AL32UTF8ORA_NCHAR_LITERAL_REPLACETRUEz"Error loading cx_Oracle module: %s)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)Oracle_datetimec@seZdZdddZdS)!_UninitializedOperatorsDescriptorNcCs6|dkrtdn|jj|jdS)Nz*operators not available as class attribute operators)AttributeErrorcursorclose__dict__)selfinstanceclsrrr__get__Ds z)_UninitializedOperatorsDescriptor.__get__)__name__ __module__ __qualname__r3rrrrr*Bs r*cseZdZdZidd6dd6dd6dd 6d d 6d d 6dd6dd6dd6dd6d d6d d6dd6dd6dd6dd6dd6dd 6dd!6dd"6dd#6d d$6dd%6d&d'6dd(6d d)6d*d+6Zid,d 6d-d 6d.d"6d.d#6ZeZi d/d06d1d26d3d46d5d66d7d86d9d:6d;d<6d=d>6d3d?6d3d@6d5dA6d5dB6Zej Z e j idCd46dDd66dCd?6dCd@6dDdA6dDdB6dEZ idFd46dGd66dHd?6dIdA6dJd@6dKdB6Z dLdMe jDZdNdMe jDZeZeZeZeZeZeZeZfdOdPZdQdRZdSdTZ dUdVZ!dWdXZ"dYdZd[Z#d\d]Z$d^d_Z%d`daZ&dYdbdcZ'dddeZ(e)dfdgZ*e)dhdiZ+S)jDatabaseWrapperZoraclez NUMBER(11)Z AutoFieldz NUMBER(19)Z BigAutoFieldZBLOBZ BinaryFieldz NUMBER(1)Z BooleanFieldzNVARCHAR2(%(max_length)s)Z CharFieldzVARCHAR2(%(max_length)s)ZCommaSeparatedIntegerFieldZDATEZ DateFieldZ TIMESTAMPZ DateTimeFieldz*NUMBER(%(max_digits)s, %(decimal_places)s)Z DecimalFieldzINTERVAL DAY(9) TO SECOND(6)Z DurationFieldZ FileFieldZ FilePathFieldzDOUBLE PRECISIONZ FloatFieldZ IntegerFieldZBigIntegerFieldz VARCHAR2(15)ZIPAddressFieldz VARCHAR2(39)ZGenericIPAddressFieldZNullBooleanFieldZ OneToOneFieldZPositiveIntegerFieldZPositiveSmallIntegerFieldZ SlugFieldZSmallIntegerFieldZNCLOBZ TextFieldZ TimeFieldZURLFieldz VARCHAR2(32)Z UUIDFieldz%(qn_column)s IN (0,1)z3(%(qn_column)s IN (0,1)) OR (%(qn_column)s IS NULL)z%(qn_column)s >= 0z= %sexactz = UPPER(%s)ZiexactzFLIKE TRANSLATE(%s USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)containszMLIKE UPPER(TRANSLATE(%s USING NCHAR_CS)) ESCAPE TRANSLATE('\' USING NCHAR_CS)Z icontainsz> %sgtz>= %sZgtez< %sltz<= %sZlterendswithZ istartswithZ iendswithzLIKEC %s ESCAPE '\'zLIKEC UPPER(%s) ESCAPE '\'z@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')z'%%' || {} || '%%'z'%%' || UPPER({}) || '%%'z {} || '%%'zUPPER({}) || '%%'z '%%' || {}z'%%' || UPPER({})cCs'i|]\}}d|d|qS)zLIKE TRANSLATE( z5 USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)r).0kvrrr s zDatabaseWrapper.cCs'i|]\}}d|d|qS)zLIKEC z ESCAPE '\'r)r=r>r?rrrr@s csBtt|j|||jdjdd}||j_dS)NOPTIONSuse_returning_intoT)superr7__init__ settings_dictgetfeaturesZcan_return_id_from_insert)r0argskwargsrB) __class__rrrDszDatabaseWrapper.__init__cCs}|j}|djs&d|d|jr:|jjid|jj|d6dd6ndS)Nz-- RELEASE SAVEPOINT %s (faked)Zsqlz0.000time)Zqueries_loggedZ queries_logappendopsZ quote_name)r0Zsidrrr_savepoint_commits  z!DatabaseWrapper._savepoint_commitc Cs |j||j_WdQXdS)N)Zwrap_database_errorsrc autocommit)r0rurrr_set_autocommits zDatabaseWrapper._set_autocommitcCs*|jjd|jjddS)z To check constraints, we set constraints to immediate. Then, when, we're done we must ensure they are returned to deferred. zSET CONSTRAINTS ALL IMMEDIATEzSET CONSTRAINTS ALL DEFERREDN)r-r\)r0Z table_namesrrrcheck_constraints sz!DatabaseWrapper.check_constraintsc Cs5y|jjWntjk r,dSYnXdSdS)NFT)rcZpingrOError)r0rrr is_usable(s  zDatabaseWrapper.is_usablecCs!|j|jjSWdQXdS)N)Ztemporary_connectionrcversion)r0rrroracle_full_version0s z#DatabaseWrapper.oracle_full_versionc Cs;yt|jjddSWntk r6dSYnXdS)N.r)rPr{split ValueError)r0rrroracle_version5s zDatabaseWrapper.oracle_version),r4r5r6vendorZ data_typesZdata_type_check_constraintsr*r+r^rSr`rZ pattern_escZ _pattern_opsitemsrbrarOr(ZSchemaEditorClassr#Z client_classr$Zcreation_classr%Zfeatures_classr&Zintrospection_classr'Z ops_classrDrQrUrWrer[rprtrvrwryr r{rrr)rJrr7Os             (    r7c@s%eZdZdZdddZdS) 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|rktjdt |j tj j dd}ntj |}nd}|dkrd}n|dkrd}nt|dr|j||_nrt|tjtjfr||_nKt||j||_t|jtjrCtt||j|}nt|dra|j|_nE|d kr|tj|_n*t|tjrtj|_n d|_dS) NzThe Oracle database adapter received an aware datetime (%s), probably from cursor.execute(). Update your code to pass a naive datetime in the database connection's time zone (UTC by default).tzinforTr"Fbind_parameter input_sizei)rr] isinstancedatetimer)rZis_awarewarningswarnr astimezoneutcreplaceZ from_datetimerjrr rOBinary timedeltar charsetr string_typeslenrZCLOBdecimalDecimalNUMBER)r0paramr-Z strings_onlyZ string_sizerrrrDGs6!      zOracleParam.__init__N)r4r5r6__doc__rDrrrrr=s rc@sFeZdZdZddZddZddZdd 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)r0rrrrrD{szVariableWrapper.__init__cCs|jS)N)r)r0r-rrrr~szVariableWrapper.bind_parametercCst|j|S)N)getattrr)r0keyrrr __getattr__szVariableWrapper.__getattr__cCs3|dkr||j|r?)r0rrr@s z?FormatStylePlaceholderCursor._format_params..c3s!|]}t|dVqdS)TN)r)r=p)r0rr sz>FormatStylePlaceholderCursor._format_params..)rr,rl)r0paramsr)r0r_format_paramss! z+FormatStylePlaceholderCursor._format_paramscCst|ddrpi}xD|D]<}x3|jD]%\}}|jr3|j||rirrr_guess_input_sizess    z/FormatStylePlaceholderCursor._guess_input_sizescCs;t|dr&dd|jDSdd|DSdS)NrcSs"i|]\}}|j|qSr)r )r=r>r?rrrr@s zAFormatStylePlaceholderCursor._param_generator..cSsg|]}|jqSr)r )r=rrrr s zAFormatStylePlaceholderCursor._param_generator..)rjr)r0rrrr_param_generatorsz-FormatStylePlaceholderCursor._param_generatorFcs^|jds|jdr1|dd}n|dkrLg}|}nt|drdd|jD}||}n|rt|dkrdd |D}d dtt|Dfd d |D}d djD}|t|}n/d d tt|D}|t|}t ||j |j |fS)N;/r"rcSsi|]}d||qS)z:%sr)r=r>rrrr@s z@FormatStylePlaceholderCursor._fix_for_params..rcSs"g|]}|t|fqSr)type)r=rrrrrs z@FormatStylePlaceholderCursor._fix_for_params..cSs#i|]\}}d||qS)z:arg%dr)r=rrrrrr@s csg|]}|qSrr)r=r) params_dictrrrs cSs#i|]\}}|d|qS)rr)r=rrrrrr@s cSsg|]}d|qS)z:arg%dr)r=rrrrrs ) r<rjrrrsetrrlranger rr)r0queryrunify_by_valuesrHr)rr_fix_for_paramss"    z,FormatStylePlaceholderCursor._fix_for_paramsNcCsJ|j||dd\}}|j|g|jj||j|S)NrT)rrr-r\r)r0rrrrrr\sz$FormatStylePlaceholderCursor.executecs|s dSt|}j|t|\}}|gfdd|D}j|jj|fdd|DS)Ncsg|]}j|qSr)r)r=r)r0rrrs z.csg|]}j|qSr)r)r=r)r0rrrs )iterrnextrr- executemany)r0rrZ params_iterZ firstparams formattedr)r0rrs   z(FormatStylePlaceholderCursor.executemanycCs/|jj}|dkr|St||jS)N)r-fetchone _rowfactory)r0rowrrrrs z%FormatStylePlaceholderCursor.fetchonecsA|dkrj}ntfddjj|DS)Nc3s!|]}t|jVqdS)N)rr-)r=r)r0rrr sz9FormatStylePlaceholderCursor.fetchmany..)rrlr- fetchmany)r0rr)r0rrs  z&FormatStylePlaceholderCursor.fetchmanycs&tfddjjDS)Nc3s!|]}t|jVqdS)N)rr-)r=r)r0rrr sz8FormatStylePlaceholderCursor.fetchall..)rlr-fetchall)r0r)r0rr sz%FormatStylePlaceholderCursor.fetchallc Cs-y|jjWntjk r(YnXdS)N)r-r.rOZInterfaceError)r0rrrr.sz"FormatStylePlaceholderCursor.closecGst|jj|S)N)rr-r)r0rHrrrrsz FormatStylePlaceholderCursor.varcGst|jj|S)N)rr-arrayvar)r0rHrrrrsz%FormatStylePlaceholderCursor.arrayvarcCs.||jkr|j|St|j|SdS)N)r/rr-)r0attrrrrrs z(FormatStylePlaceholderCursor.__getattr__cCs t|jS)N)CursorIteratorr-)r0rrr__iter__!sz%FormatStylePlaceholderCursor.__iter__)r4r5r6rrrD staticmethodrrrrrr\rrrrr.rrrrrrrrrfs$     %      rfc@s:eZdZdZddZddZddZdS) rzF Cursor iterator wrapper that invokes our custom row factory. cCs||_t||_dS)N)r-r)r0r-rrrrD*s zCursorIterator.__init__cCs|S)Nr)r0rrrr.szCursorIterator.__iter__cCstt|j|jS)N)rrrr-)r0rrr__next__1szCursorIterator.__next__N)r4r5r6rrDrrrrrrr%s   rcCsjg}xWt||jD]C\}}|dk r|dtjkr|dpQd}|dpad}|dkr|dkrd|krtj|}qt|}qt|}qO|dkr|dkrt|}qtj|}qOd|krtj|}qOt|}n1|dtjtj tj fkrOt |}n|j |qWt |S)Nr"rr|i)zip descriptionrOrrrrPfloatrZ FIXED_CHARZ LONG_STRING to_unicoderrrl)rr-Zcastedrdescrrrrrr5s.      rcCs t|tjrt|S|S)z] Convert strings to Unicode objects (and return all other data types unchanged). )rrrr )srrrr_s r)rr)r zTRUE)7r __future__rrrrrrmrZ django.confrZdjango.core.exceptionsrZ django.dbrZdjango.db.backends.base.baserZ django.utilsrrZdjango.utils.deprecationr Zdjango.utils.encodingr r Zdjango.utils.functionalr rZ cx_OraclerOrrclientr#Zcreationr$rGr%Z introspectionr&Z operationsr'Zschemar(r)objectr*r7rrrfIteratorrrrrrrrsL        # 6 *