ó ø¢TQc@s´dZddlmZddlZddlZddlZddlZd„ZeddfddfgƒyddlZ Wn3e k r°Z dd l m Z e d e ƒ‚nXdd lmZdd lmZdd lTddlmZddlmZddlmZddlmZddlmZmZddlmZddlm Z e j!Z!e j"Z"e#e j$j%ddƒdƒdkoºe#e j$j%ddƒdƒdkpºe&e dƒ rÆeZ'neZ'de(fd„ƒYZ)de*fd„ƒYZ+de,fd „ƒYZ-d!e.fd"„ƒYZ/d#e,fd$„ƒYZ0d%e,fd&„ƒYZ1d'e,fd(„ƒYZ2d)e,fd*„ƒYZ3d+ej4fd,„ƒYZ5d-„Z6d.„Z7d/„Z8dS(0u\ Oracle database backend for Django. Requires cx_Oracle: http://cx-oracle.sourceforge.net/ iÿÿÿÿ(tunicode_literalsNc CsÆddl}|jƒjƒjdƒr¦yddl}Wn3tk rl}ddlm}|d|ƒ‚nX|jdƒ}xC|D]\}}|j ||ƒqƒWnddl }|j j |ƒdS(NiÿÿÿÿuCYGWIN(tImproperlyConfiguredu_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.ukernel32( tplatformtsystemtuppert startswithtctypest ImportErrortdjango.core.exceptionsRtCDLLtSetEnvironmentVariableAtostenvirontupdate( R RRteRtkernel32tnametvalueR ((s7../Django//lib/python/django/db/backends/oracle/base.pyt_setup_environment s  uNLS_LANGu.UTF8uORA_NCHAR_LITERAL_REPLACEuTRUE(Ru"Error loading cx_Oracle module: %s(tsettings(tutils(t*(tconnection_created(tDatabaseClient(tDatabaseCreation(tDatabaseIntrospection(t force_bytest force_text(tsix(ttimezoneu.iiiiuUNICODEtDatabaseFeaturescBsneZdZeZeZeZeZeZ eZ eZ eZ eZ eZeZeZeZeZeZeZRS(((t__name__t __module__tempty_fetchmany_valuetFalsetneeds_datetime_string_casttTruet!interprets_empty_strings_as_nullstuses_savepointsthas_select_for_updatethas_select_for_update_nowaittcan_return_id_from_inserttallow_sliced_subqueriestsupports_subqueries_in_group_bytsupports_transactionstsupports_timezonestsupports_bitwise_ortcan_defer_constraint_checkst#ignores_nulls_in_unique_constraintsthas_bulk_inserttsupports_tablespacestsupports_sequence_reset(((s7../Django//lib/python/django/db/backends/oracle/base.pyRGs"tDatabaseOperationscBsgeZdZd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z d „Z d „Z d „Z d „Zd „Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z e!d„Z"d „Z#d!„Z$d"„Z%d#„Z&d$„Z'd%„Z(d&„Z)RS('u"django.db.backends.oracle.compilerc Cs`|j|ƒ}|j|ƒ}|j|ƒ}|j|ƒ}dtƒ}dtƒ}||fS(Nuð DECLARE i INTEGER; BEGIN SELECT COUNT(*) INTO i FROM USER_CATALOG WHERE TABLE_NAME = '%(sq_name)s' AND TABLE_TYPE = 'SEQUENCE'; IF i = 0 THEN EXECUTE IMMEDIATE 'CREATE SEQUENCE "%(sq_name)s"'; END IF; END; /u× CREATE OR REPLACE TRIGGER "%(tr_name)s" BEFORE INSERT ON %(tbl_name)s FOR EACH ROW WHEN (new.%(col_name)s IS NULL) BEGIN SELECT "%(sq_name)s".nextval INTO :new.%(col_name)s FROM dual; END; /(t_get_sequence_namet_get_trigger_namet quote_nametlocals( tselfttabletcolumntsq_namettr_namettbl_nametcol_namet sequence_sqlt trigger_sql((s7../Django//lib/python/django/db/backends/oracle/base.pyt autoinc_sql]s cCsdS(Nu  SELECT cache_key FROM (SELECT cache_key, rank() OVER (ORDER BY cache_key) AS rank FROM %s) WHERE rank = %%s + 1 ((R9((s7../Django//lib/python/django/db/backends/oracle/base.pytcache_key_culling_sql{scCs&|dkrd|Sd||fSdS(Nuweek_dayuTO_CHAR(%s, 'D')uEXTRACT(%s FROM %s)((R9t lookup_typet field_name((s7../Django//lib/python/django/db/backends/oracle/base.pytdate_extract_sql‚s c Csqt|jdƒ\}}t|dƒ\}}t|jƒ}t|ƒ}d} | |||||||j|fS(u© Implements the interval functionality for expressions format for Oracle: (datefield + INTERVAL '3 00:03:20.000000' DAY(1) TO SECOND(6)) i<u>(%s %s INTERVAL '%s %02d:%02d:%02d.%06d' DAY(%d) TO SECOND(6))(tdivmodtsecondststrtdaystlent microseconds( R9tsqlt connectort timedeltatminutesRHthoursRJt day_precisiontfmt((s7../Django//lib/python/django/db/backends/oracle/base.pytdate_interval_sqlŠs cCs-|dkrd|}nd||f}|S(Nudayu TRUNC(%s)uTRUNC(%s, '%s')((R9RDRERM((s7../Django//lib/python/django/db/backends/oracle/base.pytdate_trunc_sql˜s  cCst|tjƒrH|jƒ}|rH|jƒdkrHt|ƒ}qHn|dkrl|rl|jrld}n¡|d krŸ|rŸ|jƒdkrŸt|ƒ}nn|dk rÒ|rÒ|jƒdkrÒt |ƒ}n;|dk r|r|jƒdkrt j |j |ƒƒ}nüt|tj ƒr |r>|jƒd kr>q |re|jƒd kre|jƒ}q |r}|jƒd ks®|jd kr½|j|jko©dknr½|jƒ}q |j|jkoö|jkoö|jkoödknr |jƒ}q n|S(Nu TextFielduiiu BooleanFielduNullBooleanFieldu FloatFieldu DecimalFieldu DateTimeFieldu DateFieldu TimeFieldil(ii(u BooleanFielduNullBooleanField(t isinstancetDatabasetLOBtreadtget_internal_typeRtNonetempty_strings_allowedtbooltfloattutilttypecast_decimalt format_numbert Timestamptdatetyeartmonthtdayttimethourtminutetsecondt microsecond(R9Rtfield((s7../Django//lib/python/django/db/backends/oracle/base.pytconvert_values¡s,  $$$ I>cCsdS(Nu,TO_TIMESTAMP(%s, 'YYYY-MM-DD HH24:MI:SS.FF')((R9((s7../Django//lib/python/django/db/backends/oracle/base.pytdatetime_cast_sqlËscCsdS(Nu DEFERRABLE INITIALLY DEFERRED((R9((s7../Django//lib/python/django/db/backends/oracle/base.pytdeferrable_sqlÎscCsd|j|j|ƒƒS(NuDROP SEQUENCE %s;(R7R5(R9R:((s7../Django//lib/python/django/db/backends/oracle/base.pytdrop_sequence_sqlÑscCst|jjƒƒS(N(tintt_insert_id_vartgetvalue(R9tcursor((s7../Django//lib/python/django/db/backends/oracle/base.pytfetch_returned_insert_idÔscCs!|r|jdƒrdSdSdS(NuLOBuDBMS_LOB.SUBSTR(%s)u%s(tendswith(R9tdb_type((s7../Django//lib/python/django/db/backends/oracle/base.pytfield_cast_sql×scCs=tjr|jS|j}t|tƒr,|S|jdƒSdS(Nuutf-8(RtPY3t statementRVtunicodetdecode(R9RtRMtparamstquery((s7../Django//lib/python/django/db/backends/oracle/base.pytlast_executed_queryÝs  cCs.|j|ƒ}|jd|ƒ|jƒdS(NuSELECT "%s".currval FROM duali(R5texecutetfetchone(R9Rtt table_nametpk_nameR<((s7../Django//lib/python/django/db/backends/oracle/base.pytlast_insert_idæscCs|dkrdSdS(Nuiexactu icontainsu istartswithu iendswithu UPPER(%s)u%s(uiexactu icontainsu istartswithu iendswith((R9RD((s7../Django//lib/python/django/db/backends/oracle/base.pyt lookup_castës cCsdS(Niè((R9((s7../Django//lib/python/django/db/backends/oracle/base.pytmax_in_list_sizeðscCsdS(Ni((R9((s7../Django//lib/python/django/db/backends/oracle/base.pytmax_name_lengthóscCs|S(N((R9tx((s7../Django//lib/python/django/db/backends/oracle/base.pytprep_for_iexact_queryöscCs |dkrdSt|jƒƒS(Nu(R[RRY(R9R((s7../Django//lib/python/django/db/backends/oracle/base.pyt process_clobùs cCsa|jdƒ rE|jdƒ rEdtj|jƒ|jƒƒ}n|jddƒ}|jƒS(Nu"u"%s"u%u%%(RRvR_t truncate_nameRR‡treplace(R9R((s7../Django//lib/python/django/db/backends/oracle/base.pyR7þs  cCsdS(NuDBMS_RANDOM.RANDOM((R9((s7../Django//lib/python/django/db/backends/oracle/base.pytrandom_function_sql scCstdƒ‚dS(Nu7Regexes are not supported in Oracle before version 10g.(tNotImplementedError(R9RD((s7../Django//lib/python/django/db/backends/oracle/base.pytregex_lookup_9scCs#|dkrd}nd}d|S(Nuregexu'c'u'i'uREGEXP_LIKE(%%s, %%s, %s)((R9RDt match_option((s7../Django//lib/python/django/db/backends/oracle/base.pytregex_lookup_10s  cCs |jjƒ|jjj|ƒS(N(t connectionRttopst regex_lookup(R9RD((s7../Django//lib/python/django/db/backends/oracle/base.pyR”s cCsdtƒffS(NuRETURNING %s INTO %%s(t InsertIdVar(R9((s7../Django//lib/python/django/db/backends/oracle/base.pytreturn_insert_idscCstd|j|ƒƒS(Nu SAVEPOINT (tconvert_unicodeR7(R9tsid((s7../Django//lib/python/django/db/backends/oracle/base.pytsavepoint_create_sql"scCstd|j|ƒƒS(NuROLLBACK TO SAVEPOINT (R—R7(R9R˜((s7../Django//lib/python/django/db/backends/oracle/base.pytsavepoint_rollback_sql%scCsu|rmg|D]=}d|jdƒ|jdƒ|j|j|ƒƒf^q }|j|j||ƒƒ|SgSdS(Nu %s %s %s;uDELETEuFROM(t SQL_KEYWORDt SQL_FIELDR7textendtsequence_reset_by_name_sql(R9tstylettablest sequencesR:RM((s7../Django//lib/python/django/db/backends/oracle/base.pyt sql_flush(s Gc Cs‰g}x||D]t}|j|dƒ}|j|dƒ}|j|dpLdƒ}tƒi|d6|d6|d6}|j|ƒq W|S(Nutableucolumnuidusequence(R5R7t_get_sequence_reset_sqltappend( R9RŸR¡RMt sequence_infot sequence_nameR‚t column_nameR~((s7../Django//lib/python/django/db/backends/oracle/base.pyRž:s  c CsHddlm}g}tƒ}x"|D]}xŒ|jjD]~}t||jƒr9|j|jjƒ}|j |jjƒ} |j|j ƒ} |j |i| d6|d6| d6ƒPq9q9Wx‚|jj D]t}|j jsÈ|j|jƒƒ}|j |jƒƒ} |jdƒ} |j |i| d6|d6| d6ƒqÈqÈWq&W|S(Niÿÿÿÿ(tmodelsusequenceutableucolumnuid(t django.dbR¨R£t_metat local_fieldsRVt AutoFieldR7tdb_tableR5R;R¤t many_to_manytreltthrought m2m_db_table( R9RŸt model_listR¨toutputR~tmodeltfR‚R¦R§((s7../Django//lib/python/django/db/backends/oracle/base.pytsequence_reset_sqlFs,    cCsdS(Nu((R9((s7../Django//lib/python/django/db/backends/oracle/base.pytstart_transaction_sql`scCs,|rd|j|ƒSd|j|ƒSdS(NuUSING INDEX TABLESPACE %su TABLESPACE %s(R7(R9t tablespacetinline((s7../Django//lib/python/django/db/backends/oracle/base.pyttablespace_sqlcscCse|dkrdStj|ƒrXtjrI|jtjƒjddƒ}qXtdƒ‚nt j |ƒS(NttzinfouNOracle backend does not support timezone-aware datetimes when USE_TZ is False.( R[Rtis_awareRtUSE_TZt astimezonetutcRŒt ValueErrorRt text_type(R9R((s7../Django//lib/python/django/db/backends/oracle/base.pytvalue_to_db_datetimeis  !cCs~|dkrdSt|tjƒr5tjj|dƒStj|ƒrStdƒ‚ntjddd|j |j |j |j ƒS(Nu%H:%M:%Su5Oracle backend does not support timezone-aware times.ili( R[RVRt string_typestdatetimetstrptimeRR¼RÀRhRiRjRk(R9R((s7../Django//lib/python/django/db/backends/oracle/base.pytvalue_to_db_timevs cCsd}d}||||gS(Nu%s-01-01u%s-12-31((R9RtfirstRj((s7../Django//lib/python/django/db/backends/oracle/base.pyt!year_lookup_bounds_for_date_field„scCsn|dkrddj|ƒS|dkr:ddj|ƒS|dkrUtdƒ‚ntt|ƒj||ƒS(uIOracle requires special cases for %% and & operators in query expressionsu%%uMOD(%s)u,u&u BITAND(%s)u|u'Bit-wise or is not supported in Oracle.(tjoinRŽtsuperR4tcombine_expression(R9RNtsub_expressions((s7../Django//lib/python/django/db/backends/oracle/base.pyRˉs   cCs*|jƒd}dtj||ƒjƒS(Niu%s_SQ(R‡R_R‹R(R9R:t name_length((s7../Django//lib/python/django/db/backends/oracle/base.pyR5“scCs*|jƒd}dtj||ƒjƒS(Niu%s_TR(R‡R_R‹R(R9R:RÍ((s7../Django//lib/python/django/db/backends/oracle/base.pyR6—scCs4ddjdgt|ƒƒ}dj|g|ƒS(NuSELECT %s FROM DUALu, u%su UNION ALL (RÉRK(R9tfieldst num_valuest items_sql((s7../Django//lib/python/django/db/backends/oracle/base.pytbulk_insert_sql›s (*RR tcompiler_moduleRBRCRFRTRURmRnRoRpRuRxRR„R…R†R‡R‰RŠR7RRR‘R”R–R™RšR¢RžR¶R·R"RºRÂRÆRÈRËR5R6RÑ(((s7../Django//lib/python/django/db/backends/oracle/base.pyR4ZsN     *                           t!_UninitializedOperatorsDescriptorcBseZd„ZRS(cCs6|dkrtdƒ‚n|jƒjƒ|jdS(Nu*operators not available as class attributeu operators(R[tAttributeErrorRttcloset__dict__(R9tinstancetowner((s7../Django//lib/python/django/db/backends/oracle/base.pyt__get__¢s (RR RÙ(((s7../Django//lib/python/django/db/backends/oracle/base.pyRÓ stDatabaseWrappercBsöeZdZeƒZi dd6dd6dd6dd6d d 6d d 6d d6dd6dd6dd6dd6dd6ZejƒZejidd6dd6dd6dd6dd6dd6ƒd„Z dd„Z d„Z d„Z d„Zd„Zd„ZRS(uoracleu= %suexactu = UPPER(%s)uiexactuFLIKE TRANSLATE(%s USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)ucontainsuMLIKE UPPER(TRANSLATE(%s USING NCHAR_CS)) ESCAPE TRANSLATE('\' USING NCHAR_CS)u icontainsu> %sugtu>= %sugteu< %sultu<= %sulteu startswithuendswithu istartswithu iendswithuLIKEC %s ESCAPE '\'uLIKEC UPPER(%s) ESCAPE '\'cOs¥tt|ƒj||Žd|_t|ƒ|_|jdjdt ƒ}||j_ t |ƒ|_ t |ƒ|_t|ƒ|_t|ƒ|_t|ƒ|_dS(NuOPTIONSuuse_returning_into(RÊRÚt__init__R[toracle_versionRtfeaturest settings_dicttgetR$R)R4R“RtclientRtcreationRt introspectiontBaseDatabaseValidationt validation(R9targstkwargstuse_returning_into((s7../Django//lib/python/django/db/backends/oracle/base.pyRÛÊs  cCs*|jƒjdƒ|jƒjdƒdS(u• To check constraints, we set constraints to immediate. Then, when, we're done we must ensure they are returned to deferred. uSET CONSTRAINTS ALL IMMEDIATEuSET CONSTRAINTS ALL DEFERREDN(RtR€(R9t table_names((s7../Django//lib/python/django/db/backends/oracle/base.pytcheck_constraints×scCs |jdk S(N(R’R[(R9((s7../Django//lib/python/django/db/backends/oracle/base.pyt_valid_connectionßscCsƒ|j}|djƒs&d|d t OracleParamcBseZdZed„ZRS(u¦ 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. cCsDtjr€t|tjƒr€tj|ƒr_tjd|tƒtj ƒ}tj ||ƒ}n|j tj ƒj ddƒ}n|tkr•d}n|tkrªd}nt|dƒrÎ|j|ƒ|_nt||j|ƒ|_t|dƒr|j|_n<t|tjƒr7t|ƒdkr7tj|_n d|_dS(NuHOracle received a naive datetime (%s) while time zone support is active.R»u1u0ubind_parameteru input_sizei (RR½RVRÄRtis_naivetwarningstwarntRuntimeWarningtget_default_timezonet make_awareR¾R¿RŒR[R$R"Rtbind_parameterRR—tcharsett input_sizeRRÃRKRWtCLOB(R9tparamRtt strings_onlytdefault_timezone((s7../Django//lib/python/django/db/backends/oracle/base.pyRÛQs*  !      $(RR t__doc__R"RÛ(((s7../Django//lib/python/django/db/backends/oracle/base.pyR GstVariableWrappercBs2eZdZd„Zd„Zd„Zd„ZRS(u  An adapter class for cursor variables that prevents the wrapped object from being converted into a string when used to instanciate an OracleParam. This can be used generally for any other object that should be passed into Cursor.execute as-is. cCs ||_dS(N(tvar(R9R((s7../Django//lib/python/django/db/backends/oracle/base.pyRÛzscCs|jS(N(R(R9Rt((s7../Django//lib/python/django/db/backends/oracle/base.pyR}scCst|j|ƒS(N(tgetattrR(R9tkey((s7../Django//lib/python/django/db/backends/oracle/base.pyt __getattr__€scCs3|dkr||j| seq_value LOOP SELECT "%(sequence)s".nextval INTO seq_value FROM dual; END LOOP; END; /((((s7../Django//lib/python/django/db/backends/oracle/base.pyR£Ts(9Rt __future__RRÄRBRR Rt cx_OracleRWRRRRt django.confRR©Rtdjango.db.backendstdjango.db.backends.signalsRt django.db.backends.oracle.clientRt"django.db.backends.oracle.creationRt'django.db.backends.oracle.introspectionRtdjango.utils.encodingRRt django.utilsRRRôRRqR÷RøRR—tBaseDatabaseFeaturesRtBaseDatabaseOperationsR4tobjectRÓtBaseDatabaseWrapperRÚR RR•RòtIteratorR;R3RIR£(((s7../Django//lib/python/django/db/backends/oracle/base.pytsX         %% ÿG š+ u /