ó ø¢TQc@s^ddlZddlZddlmZddlmZdZdZdefd„ƒYZdS(iÿÿÿÿN(tBaseDatabaseCreation(tinputttest_tIm_a_lumberjacktDatabaseCreationcBsZeZidd6dd6dd6dd6dd 6d d 6d d 6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd6dd 6d!d"6d d#6dd$6Zd%„Zd&ed'„Zd&d(„Zd)„Zd*„Zd+„Z d,„Z d-„Z d.„Z d/„Z d0„Zd1„Zd2„Zd3„Zd4„Zd5„Zd6„Zd7„ZRS(8s NUMBER(11)t AutoFields(NUMBER(1) CHECK (%(qn_column)s IN (0,1))t BooleanFieldsNVARCHAR2(%(max_length)s)t CharFieldsVARCHAR2(%(max_length)s)tCommaSeparatedIntegerFieldtDATEt DateFieldt TIMESTAMPt DateTimeFields*NUMBER(%(max_digits)s, %(decimal_places)s)t DecimalFieldt FileFieldt FilePathFieldsDOUBLE PRECISIONt FloatFieldt IntegerFields NUMBER(19)tBigIntegerFields VARCHAR2(15)tIPAddressFields VARCHAR2(39)tGenericIPAddressFieldsENUMBER(1) CHECK ((%(qn_column)s IN (0,1)) OR (%(qn_column)s IS NULL))tNullBooleanFieldt OneToOneFields%NUMBER(11) CHECK (%(qn_column)s >= 0)tPositiveIntegerFieldtPositiveSmallIntegerFieldt SlugFieldtSmallIntegerFieldtNCLOBt TextFieldt TimeFieldtURLFieldcCstt|ƒj|ƒdS(N(tsuperRt__init__(tselft connection((s;../Django//lib/python/django/db/backends/oracle/creation.pyR ,sic Cs |jƒ}|jƒ}|jƒ}|jƒ}|jƒ}i|d6|d6|d6|d6|d6}|jjƒ} |jƒrƒy|j| ||ƒWqƒt k r} t j j d| ƒ|sÖt d|ƒ} n|sè| dkrjyH|d kr d |jjGHn|j| ||ƒ|j| ||ƒWq|t k rf} t j j d | ƒt jd ƒq|Xq€d GHt jd ƒqƒXn|jƒr°|d kr£dGHny|j| ||ƒWq°t k r¬} t j j d| ƒ|sùt d|ƒ} n|s | dkr—yR|d kr"dGHn|j| ||ƒ|d krIdGHn|j| ||ƒWq©t k r“} t j j d| ƒt jd ƒq©Xq­d GHt jd ƒq°Xn|jjd|jjd<|jjd|jjd<||jjd<|jjd<||jjd<|jjdS(Ntdbnametusertpasswordttblspacet tblspace_temps,Got an error creating the test database: %s s^It appears the test database, %s, already exists. Type 'yes' to delete it, or 'no' to cancel: tyesis$Destroying old test database '%s'...s.Got an error recreating the test database: %s isTests cancelled.sCreating test user...s(Got an error creating the test user: %s sZIt appears the test user, %s, already exists. Type 'yes' to delete it, or 'no' to cancel: sDestroying old test user...s*Got an error recreating the test user: %s tUSERt SAVED_USERtPASSWORDtSAVED_PASSWORDt TEST_USERtNAME(t_test_database_namet_test_database_usert_test_database_passwdt_test_database_tblspacet_test_database_tblspace_tmpR"tcursort_test_database_createt_execute_test_db_creationt ExceptiontsyststderrtwriteRtaliast_execute_test_db_destructiontexitt_test_user_createt_create_test_usert_destroy_test_usert settings_dict( R!t verbosityt autoclobbert TEST_NAMER-t TEST_PASSWDt TEST_TBLSPACEtTEST_TBLSPACE_TMPt parametersR4tetconfirm((s;../Django//lib/python/django/db/backends/oracle/creation.pyt_create_test_db/sr            c Cs2|jƒ}|jƒ}|jƒ}|jƒ}|jƒ}|jjd|jjd<|jjd|jjdR@R5R<tclose( R!ttest_database_nameRBRDR-RERFRGRHR4((s;../Django//lib/python/django/db/backends/oracle/creation.pyt_destroy_test_dbrs0           cCsB|dkrd|dGHnddg}|j||||ƒdS(Nis_create_test_db(): dbname = %sR#s˜CREATE TABLESPACE %(tblspace)s DATAFILE '%(tblspace)s.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 200M s¬CREATE TEMPORARY TABLESPACE %(tblspace_temp)s TEMPFILE '%(tblspace_temp)s.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 100M (t_execute_statements(R!R4RHRBt statements((s;../Django//lib/python/django/db/backends/oracle/creation.pyR6”s   cCsB|dkrd|dGHnddg}|j||||ƒdS(Nis"_create_test_user(): username = %sR$s°CREATE USER %(user)s IDENTIFIED BY %(password)s DEFAULT TABLESPACE %(tblspace)s TEMPORARY TABLESPACE %(tblspace_temp)s s#GRANT CONNECT, RESOURCE TO %(user)s(RQ(R!R4RHRBRR((s;../Django//lib/python/django/db/backends/oracle/creation.pyR?£s   cCsB|dkrd|dGHnddg}|j||||ƒdS(Nis)_execute_test_db_destruction(): dbname=%sR#sQDROP TABLESPACE %(tblspace)s INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTSsVDROP TABLESPACE %(tblspace_temp)s INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS(RQ(R!R4RHRBRR((s;../Django//lib/python/django/db/backends/oracle/creation.pyR<°s   cCsD|dkr!d|dGHdGHndg}|j||||ƒdS(Nis_destroy_test_user(): user=%sR$s'Be patient. This can take some time...sDROP USER %(user)s CASCADE(RQ(R!R4RHRBRR((s;../Django//lib/python/django/db/backends/oracle/creation.pyR@¹s    cCsqxj|D]b}||}|dkr+|GHny|j|ƒWqtk rh}tjjd|ƒ‚qXqWdS(Nis Failed (%s) (texecuteR7R8R9R:(R!R4RRRHRBttemplatetstmtterr((s;../Django//lib/python/django/db/backends/oracle/creation.pyRQÂs   cCsSt|jjd}y'|jjdr:|jjd}nWntk rNnX|S(NR.RD(tTEST_DATABASE_PREFIXR"RAtAttributeError(R!tname((s;../Django//lib/python/django/db/backends/oracle/creation.pyR/Ís cCs|jjjdtƒS(Nt TEST_CREATE(R"RAtgettTrue(R!((s;../Django//lib/python/django/db/backends/oracle/creation.pyR5ÖscCs|jjjdtƒS(NtTEST_USER_CREATE(R"RAR[R\(R!((s;../Django//lib/python/django/db/backends/oracle/creation.pyR>ÙscCsSt|jjd}y'|jjdr:|jjd}nWntk rNnX|S(NR)R-(RWR"RAtKeyError(R!RY((s;../Django//lib/python/django/db/backends/oracle/creation.pyR0Üs cCsEt}y'|jjdr,|jjd}nWntk r@nX|S(NRE(R+R"RAR^(R!RY((s;../Django//lib/python/django/db/backends/oracle/creation.pyR1ås cCsSt|jjd}y'|jjdr:|jjd}nWntk rNnX|S(NR.RF(RWR"RAR^(R!RY((s;../Django//lib/python/django/db/backends/oracle/creation.pyR2îs cCsWt|jjdd}y'|jjdr>|jjd}nWntk rRnX|S(NR.t_tempRG(RWR"RAR^(R!RY((s;../Django//lib/python/django/db/backends/oracle/creation.pyR3÷s cCs|jjdS(së We need to return the 'production' DB name to get the test DB creation machinery to work. This isn't a great deal in this case because DB names as handled by Django haven't real counterparts in Oracle. R.(R"RA(R!((s;../Django//lib/python/django/db/backends/oracle/creation.pyt_get_test_db_namescCs5|jj}|d|d|d|d|jƒfS(NtHOSTtPORTtENGINER.(R"RAR0(R!RA((s;../Django//lib/python/django/db/backends/oracle/creation.pyttest_db_signatures  cCst|jj_dS(N(R\R"t autocommit(R!((s;../Django//lib/python/django/db/backends/oracle/creation.pytset_autocommits(t__name__t __module__t data_typesR tFalseRKRPR6R?R<R@RQR/R5R>R0R1R2R3R`RdRf(((s;../Django//lib/python/django/db/backends/oracle/creation.pyR sT   C "     ( R8RLtdjango.db.backends.creationRtdjango.utils.six.movesRRWR+R(((s;../Django//lib/python/django/db/backends/oracle/creation.pyts