Xa@sdZddlmZddlZddlZddlZddlZddlZddlZddl m Z ddl m Z ddl mZddlmZddlmZmZdd lmZdd lmZdd lmZmZdd lmZd dZed-d.gyddlZWnEe k rmZ!z%ddl"m#Z#e#de!WYddZ![!XnXddl$m%Z%ddl&m'Z'ddl(m)Z)ddl*m+Z+ddl,m-Z-ddl.m/Z/ddl m0Z0m1Z1ej2Z2ej3Z3Gddde4Z5Gdd d eZ6Gd!d"d"e4Z7Gd#d$d$e4Z8Gd%d&d&e4Z9Gd'd(d(ej:Z;d)d*Z<d+d,Z=dS)/z\ Oracle database backend for Django. Requires cx_Oracle: http://cx-oracle.sourceforge.net/ )unicode_literalsN)settings)utils)BaseDatabaseWrapper)BaseDatabaseValidation)sixtimezone)RemovedInDjango20Warning)duration_string) force_bytes force_text)cached_propertycCstjjjdryddl}WnEtk rr}z%ddlm}|d|WYdd}~XnX|jd}x7|D]\}}|j ||qWnt j j |dS)NZCYGWINr)ImproperlyConfiguredz_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.kernel32) platformsystemupper startswithctypes ImportErrordjango.core.exceptionsrCDLLZSetEnvironmentVariableAosenvironupdate)rrerrnamevaluerL/home/ubuntu/projects/ifolica/build/django/django/db/backends/oracle/base.py_setup_environmentsr NLS_LANG.UTF8ORA_NCHAR_LITERAL_REPLACETRUE)rz"Error loading cx_Oracle module: %s)DatabaseClient)DatabaseCreation)DatabaseFeatures)DatabaseIntrospection)DatabaseOperations)DatabaseSchemaEditor)Oracle_datetimeconvert_unicodec@seZdZdddZdS)!_UninitializedOperatorsDescriptorNcCs6|dkrtdn|jj|jdS)Nz*operators not available as class attribute operators)AttributeErrorcursorclose__dict__)selfinstanceclsrrr__get__Is z)_UninitializedOperatorsDescriptor.__get__)__name__ __module__ __qualname__r7rrrrr.Gs 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 jDZeZeZfdOdPZdQdRZdSdTZdUdVZdWdXZdYdZZd[d\Zd]d^Zd_d`ZdadbdcZdddeZedfdgZ edhdiZ!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)rArBrCrrrrDs cstt|j||t||_|jdjdd}||j_t||_ t ||_ t ||_ t||_t||_dS)NOPTIONSuse_returning_intoT)superr;__init__r(features settings_dictgetZcan_return_id_from_insertr*opsr&clientr'creationr) introspectionrZ validation)r4argskwargsrF) __class__rrrHs zDatabaseWrapper.__init__cCs|j}|djs&d|d|jr:|jjid|jj|d6dd6ndS)Nz-- RELEASE SAVEPOINT %s (faked)Zsqlz0.000time)Zqueries_loggedZ queries_logappendrLZ quote_name)r4Zsidrrr_savepoint_commits  z!DatabaseWrapper._savepoint_commitc Cs |j||j_WdQXdS)N)Zwrap_database_errorsrj autocommit)r4r|rrr_set_autocommit&s zDatabaseWrapper._set_autocommitNcCs*|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)r1rc)r4Z table_namesrrrcheck_constraints*sz!DatabaseWrapper.check_constraintsc Cs5y|jjWntjk r,dSYnXdSdS)NFT)rjZpingrWError)r4rrr is_usable2s  zDatabaseWrapper.is_usablecCs!|j|jjSWdQXdS)N)Ztemporary_connectionrjversion)r4rrroracle_full_version:s z#DatabaseWrapper.oracle_full_versionc Cs;yt|jjddSWntk r6dSYnXdS)N.r)rXrsplit ValueError)r4rrroracle_version?s zDatabaseWrapper.oracle_version)"r8r9r:vendorZ data_typesZdata_type_check_constraintsr.r/rerZrgrZ pattern_escZ _pattern_opsitemsrirhrWr+ZSchemaEditorClassrHrYr\r^rlrbrxr{r}r~rr rrrr)rRrr;Ts              .     r;c@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 |}nt|tjrt|}d|krd|}qnd}|dkrd}n|dkrd}nt|d r |j||_nit|tjr)||_nKt||j||_t|jtjrttt||j|}nt|d r|j|_n$|d krtj|_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).tzinfo z0 rTr%Fbind_parameter input_sizei)rrd isinstancedatetimer,rZis_awarewarningswarnr astimezoneutcreplaceZ from_datetime timedeltar rqrr rWBinaryr-charsetr string_typeslenrZCLOB)r4paramr1Z strings_onlyZ string_sizerrrrHQs:!        zOracleParam.__init__N)r8r9r:__doc__rHrrrrrGs 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)r4rrrrrHszVariableWrapper.__init__cCs|jS)N)r)r4r1rrrrszVariableWrapper.bind_parametercCst|j|S)N)getattrr)r4keyrrr __getattr__szVariableWrapper.__getattr__cCs3|dkr||j|.c3s!|]}t|dVqdS)TN)r)rAp)r4rr sz>FormatStylePlaceholderCursor._format_params..)rr0rt)r4paramsr)r4r_format_paramss! z+FormatStylePlaceholderCursor._format_paramscCst|ddrpi}xD|D]<}x3|jD]%\}}|jr3|j||.cSsg|]}|jqSr)r )rArrrr s zAFormatStylePlaceholderCursor._param_generator..)rqr)r4rrrr_param_generatorsz-FormatStylePlaceholderCursor._param_generatorcCs|jds|jdr1|dd }n|dkrXg}t||j}n|t|drdd|jD}t|||j}n;ddtt|D}t|t||j}||j|fS) N;/r%rcSsi|]}d||qS)z:%sr)rArBrrrrDs z@FormatStylePlaceholderCursor._fix_for_params..cSsg|]}d|qS)z:arg%dr)rArrrrrs z@FormatStylePlaceholderCursor._fix_for_params..) r@r-rrqrrangerrtr)r4queryrrPrrr_fix_for_paramss z,FormatStylePlaceholderCursor._fix_for_paramsNcCs|j||\}}|j|gy |jj||j|SWntjk r}zyt|jddr|jdj dkrt |t  rt j tj tj t|jtjdnWYdd}~XnXdS)Nrrnixrp)rrr1rcrrWrfrqrPrnrrsrrrrrtrurv)r4rrrrrrrcs <5z$FormatStylePlaceholderCursor.executecs.|s dSt|}j|t|\}}|gfdd|D}j|y*jj|fdd|DSWntjk r)}zyt|j ddr|j dj dkrt |t  rt jtj tj t|j tjdnWYdd}~XnXdS)Ncsg|]}j|qSr)r)rAr)r4rrrs z.csg|]}j|qSr)r)rAr)r4rrrs rrnixrp)iterrnextrr1 executemanyrWrfrqrPrnrrsrrrrrtrurv)r4rrZ params_iterZ firstparams formattedrr)r4rrs   *<5z(FormatStylePlaceholderCursor.executemanycCs/|jj}|dkr|St||jS)N)r1fetchone _rowfactory)r4rowrrrrs z%FormatStylePlaceholderCursor.fetchonecsA|dkrj}ntfddjj|DS)Nc3s!|]}t|jVqdS)N)rr1)rAr)r4rrrsz9FormatStylePlaceholderCursor.fetchmany..)rrtr1 fetchmany)r4sizer)r4rrs  z&FormatStylePlaceholderCursor.fetchmanycs&tfddjjDS)Nc3s!|]}t|jVqdS)N)rr1)rAr)r4rrrsz8FormatStylePlaceholderCursor.fetchall..)rtr1fetchall)r4r)r4rrsz%FormatStylePlaceholderCursor.fetchallc Cs-y|jjWntjk r(YnXdS)N)r1r2rWZInterfaceError)r4rrrr2 sz"FormatStylePlaceholderCursor.closecGst|jj|S)N)rr1r)r4rPrrrrsz FormatStylePlaceholderCursor.varcGst|jj|S)N)rr1arrayvar)r4rPrrrrsz%FormatStylePlaceholderCursor.arrayvarcCs.||jkr|j|St|j|SdS)N)r3rr1)r4attrrrrrs z(FormatStylePlaceholderCursor.__getattr__cCs t|jS)N)CursorIteratorr1)r4rrr__iter__sz%FormatStylePlaceholderCursor.__iter__)r8r9r:rrrHrrrrrcrrrrr2rrrrrrrrrms"             rmc@s:eZdZdZddZddZddZdS) rzF Cursor iterator wrapper that invokes our custom row factory. cCs||_t||_dS)N)r1r)r4r1rrrrH%s zCursorIterator.__init__cCs|S)Nr)r4rrrr)szCursorIterator.__iter__cCstt|j|jS)N)rrrr1)r4rrr__next__,szCursorIterator.__next__N)r8r9r:rrHrrrrrrr s   rcCs`g}xMt||jD]9\}}|dk r|dtjkr|dd\}}|dkr|dkrd|krtj|}qt|}qt|}qE|dkr|dkrt|}qtj|}qEd|krtj|}qEt|}n1|dtjtj tj fkrEt |}n|j |qWt |S)Nr%rri)zip descriptionrWNUMBERdecimalZDecimalrXfloatSTRINGZ FIXED_CHARZ LONG_STRING to_unicoderzrt)rr1ZcastedrdescZ precisionZscalerrrr0s,      rcCs t|tjrt|S|S)z] Convert strings to Unicode objects (and return all other data types unchanged). )rrrr )srrrrYs r)r!r")r#zTRUE)>r __future__rrrrrrurZ django.confrZ django.dbrZdjango.db.backends.base.baserZ"django.db.backends.base.validationrZ django.utilsrrZdjango.utils.deprecationr Zdjango.utils.durationr Zdjango.utils.encodingr r Zdjango.utils.functionalr r Z cx_OraclerWrrrrrMr&rNr'rIr(rOr)Z operationsr*Zschemar+r,r-rfrsobjectr.r;rrrmIteratorrrrrrrrsT        #   9 )