0_c@sFdZddlmZddlZddlZddlZddlZddlZddlZddl m Z ddl m Z ddl mZddlmZddlmZmZdd lmZdd lmZmZdd lmZd Zed(d)gyddlZWn#ek r8Ze denXddl m!Z!ddl"m#Z#ddl$m%Z%ddl&m'Z'ddl(m)Z)ddl*m+Z+ddlm,Z,de-fdYZ.defdYZ/de-fdYZ0d e-fd!YZ1d"e-fd#YZ2d$ej3fd%YZ4d&Z5d'Z6dS(*u\ Oracle database backend for Django. Requires cx_Oracle: http://cx-oracle.sourceforge.net/ i(tunicode_literalsN(tsettings(tImproperlyConfigured(tutils(tBaseDatabaseWrapper(tsixttimezone(tRemovedInDjango20Warning(t force_bytest force_text(tcached_propertycCstjjjdryddl}Wn#tk rP}td|nX|jd}x7|D]\}}|j||qgWnt j j |dS(NuCYGWINiu_Error loading ctypes: %s; the Oracle backend requires ctypes to operate correctly under Cygwin.ukernel32( tplatformtsystemtuppert startswithtctypest ImportErrorRtCDLLtSetEnvironmentVariableAtostenvirontupdate(RRtetkernel32tnametvalue((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt_setup_environmentsuNLS_LANGu .AL32UTF8uORA_NCHAR_LITERAL_REPLACEuTRUEu"Error loading cx_Oracle module: %si(tDatabaseClient(tDatabaseCreation(tDatabaseFeatures(tDatabaseIntrospection(tDatabaseOperations(tDatabaseSchemaEditor(tOracle_datetimet!_UninitializedOperatorsDescriptorcBseZddZRS(cCs6|dkrtdn|jj|jdS(Nu*operators not available as class attributeu operators(tNonetAttributeErrortcursortcloset__dict__(tselftinstancetcls((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt__get__Ds N(t__name__t __module__R#R+(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR"BstDatabaseWrappercBseZdZidd6dd6dd6dd6d d 6d d 6d d6dd6dd6dd6d d6d d6dd6dd6dd6dd6dd6dd6dd 6dd!6dd"6d d#6dd$6d%d&6dd'6d d(6d)d*6Zid+d6d,d6d-d!6d-d"6ZeZi d.d/6d0d16d2d36d4d56d6d76d8d96d:d;6d<d=6d2d>6d2d?6d4d@6d4dA6ZejZ e j idBd36dCd56dBd>6dBd?6dCd@6dCdA6dDZ idEd36dFd56dGd>6dHd@6dId?6dJdA6Z dKe j DZdLe j DZeZeZeZeZeZeZeZdMZdNZdOZdPZ dQZ!dZdRZ#dSZ$dTZ%dUZ&dZdVZ'dWZ(e)dXZ*e)dYZ+RS([uoracleu NUMBER(11)u AutoFieldu NUMBER(19)u BigAutoFielduBLOBu BinaryFieldu NUMBER(1)u BooleanFielduNVARCHAR2(%(max_length)s)u CharFielduVARCHAR2(%(max_length)s)uCommaSeparatedIntegerFielduDATEu DateFieldu TIMESTAMPu DateTimeFieldu*NUMBER(%(max_digits)s, %(decimal_places)s)u DecimalFielduINTERVAL DAY(9) TO SECOND(6)u DurationFieldu FileFieldu FilePathFielduDOUBLE PRECISIONu FloatFieldu IntegerFielduBigIntegerFieldu VARCHAR2(15)uIPAddressFieldu VARCHAR2(39)uGenericIPAddressFielduNullBooleanFieldu OneToOneFielduPositiveIntegerFielduPositiveSmallIntegerFieldu SlugFielduSmallIntegerFielduNCLOBu TextFieldu TimeFielduURLFieldu VARCHAR2(32)u UUIDFieldu%(qn_column)s IN (0,1)u3(%(qn_column)s IN (0,1)) OR (%(qn_column)s IS NULL)u%(qn_column)s >= 0u= %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 '\'u@REPLACE(REPLACE(REPLACE({}, '\', '\\'), '%%', '\%%'), '_', '\_')u'%%' || {} || '%%'u'%%' || UPPER({}) || '%%'u {} || '%%'uUPPER({}) || '%%'u '%%' || {}u'%%' || UPPER({})cCs'i|]\}}d|d|qS(uLIKE TRANSLATE( u5 USING NCHAR_CS) ESCAPE TRANSLATE('\' USING NCHAR_CS)((t.0tktv((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pys s cCs'i|]\}}d|d|qS(uLIKEC u ESCAPE '\'((R/R0R1((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pys s cOsBtt|j|||jdjdt}||j_dS(NuOPTIONSuuse_returning_into(tsuperR.t__init__t settings_dicttgettTruetfeaturestcan_return_id_from_insert(R(targstkwargstuse_returning_into((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR3scCs}|j}|djs&d|d|jr:|jjid|jj|d6dd6ndS(Nu-- RELEASE SAVEPOINT %s (faked)usqlu0.000utime(tqueries_loggedt queries_logtappendtopst quote_name(R(tsid((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt_savepoint_commits  cCs |j||j_WdQXdS(N(twrap_database_errorsRRt autocommit(R(Rj((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt_set_autocommits cCs*|jjd|jjddS(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(R%RI(R(t table_names((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pytcheck_constraints scCs1y|jjWntjk r(tSXtSdS(N(RRtpingR=tErrortFalseR6(R(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt is_usable(s cCs!|j|jjSWdQXdS(N(ttemporary_connectionRRtversion(R(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pytoracle_full_version0s cCs7yt|jjddSWntk r2dSXdS(Nu.i(R?Rttsplitt ValueErrorR#(R(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pytoracle_version5s N(,R,R-tvendort data_typestdata_type_check_constraintsR"RNRKRBRMRt pattern_esct _pattern_opstitemsRQROR=R tSchemaEditorClassRt client_classRtcreation_classRtfeatures_classRtintrospection_classRt ops_classR3RARERGRVR#RHRaRhRkRmRqR RtRw(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR.Os           (      t OracleParamcBseZdZedZRS(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. cCstjr}t|tjr}t|t r}tj|rktjdt |j tj j dd}ntj|}nd}|tkrd}n|tkrd}nt|dr|j||_nrt|tjtjfr||_nKt||j||_t|jtjrCtt||j|}nt|dra|j|_nE|dkr|tj|_n*t|tjrtj |_n d|_dS(NuThe 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).ttzinfoiiubind_parameteru input_sizei(!RRJt isinstancetdatetimeR!Rtis_awaretwarningstwarnRt astimezonetutctreplaceR#t from_datetimeR6RpRXtbind_parameterRR=tBinaryt timedeltaR tcharsetRt string_typestlent input_sizetCLOBtdecimaltDecimaltNUMBER(R(tparamR%t strings_onlyt string_size((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR3Gs6!      (R,R-t__doc__RpR3(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR=stVariableWrappercBs2eZdZdZdZdZdZRS(u  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(tvar(R(R((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR3{scCs|jS(N(R(R(R%((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR~scCst|j|S(N(tgetattrR(R(tkey((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt __getattr__scCs3|dkr||j|s c3s!|]}t|tVqdS(N(RR6(R/tp(R((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pys s(R}R$R](R(tparams((R(s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt_format_paramss cCst|ddrpi}xD|D]<}x3|jD]%\}}|jr3|j||s (RXR}R(R(RR((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt_param_generatorscCso|jds|jdr+|d }n|dkrFg}|}n t|drxd|jD}||}n|rt|dkrg|D]}|t|f^q}dtt|D}g|D]}||^q}d|jD}|t |}n9gt t|D]}d |^q*}|t |}t ||j |j |fS( Nu;u/iukeyscSsi|]}d||qS(u:%s((R/R0((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pys s icSs#i|]\}}d||qS(u:arg%d((R/RR((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pys s cSs#i|]\}}|d|qS(i((R/RR((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pys s u:arg%d(tendswithR#RXtkeysRttypeRtsetR}R]trangeR RR(R(tqueryRtunify_by_valuesR9Rt params_dictR((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt_fix_for_paramss"     %)cCsJ|j||dt\}}|j|g|jj||j|S(NR(RR6RR%RIR(R(RR((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyRIscCs|s dSt|}|j|t|\}}|gg|D]}|j|^qA}|j||jj|g|D]}|j|^q}S(N( R#titerRtnextRRR%t executemanyR(R(RRt params_itert firstparamsRt formatted((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyRs ) cCs/|jj}|dkr|St||jS(N(R%tfetchoneR#t _rowfactory(R(trow((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyRs cs>|dkrj}ntfdjj|DS(Nc3s!|]}t|jVqdS(N(RR%(R/tr(R((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pys s(R#RR]R%t fetchmany(R(R((R(s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyRs  cs#tfdjjDS(Nc3s!|]}t|jVqdS(N(RR%(R/R(R((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pys s(R]R%tfetchall(R(((R(s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR scCs,y|jjWntjk r'nXdS(N(R%R&R=tInterfaceError(R(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR&scGst|jj|S(N(RR%R(R(R9((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyRscGst|jj|S(N(RR%tarrayvar(R(R9((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyRscCs.||jkr|j|St|j|SdS(N(R'RR%(R(tattr((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyRs cCs t|jS(N(tCursorIteratorR%(R(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt__iter__!sN(R,R-RRR3t staticmethodRRRRRpRR#RIRRRRR&RRRR(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyRWs$     %        RcBs)eZdZdZdZdZRS(uF Cursor iterator wrapper that invokes our custom row factory. cCs||_t||_dS(N(R%R(R(R%((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR3*s cCs|S(N((R(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR.scCstt|j|jS(N(RRRR%(R(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyt__next__1s(R,R-RR3RR(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR%s  cCsjg}xWt||jD]C\}}|dk r|dtjkr|dpQd}|dpad}|dkr|dkrd|krtj|}qt|}qt|}qO|dkr|dkrt|}qtj|}qOd|krtj|}qOt|}n1|dtj tj tj fkrOt |}n|j |qWt|S(Niiiiiu.(tzipt descriptionR#R=RRRR?tfloatRt FIXED_CHARt LONG_STRINGt to_unicodeRdR](RR%tcastedRtdescRR((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR5s.      cCs t|tjrt|S|S(u] Convert strings to Unicode objects (and return all other data types unchanged). (RRRR (ts((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pyR_s (uNLS_LANGu .AL32UTF8(uORA_NCHAR_LITERAL_REPLACEuTRUE(7Rt __future__RRRRR R^Rt django.confRtdjango.core.exceptionsRt django.dbRtdjango.db.backends.base.baseRt django.utilsRRtdjango.utils.deprecationRtdjango.utils.encodingRR tdjango.utils.functionalR Rt cx_OracleR=RRtclientRtcreationRR7Rt introspectionRt operationsRtschemaR R!tobjectR"R.RRRWtIteratorRRR(((s@/tmp/pip-unpacked-wheel-BAJOf3/django/db/backends/oracle/base.pytsL         6 *