hhQbSSKrSSKJr SSKJr SSKJr SSKJr SSK J r Sr "SS \5r g) N)settings) DatabaseError)BaseDatabaseCreation)get_random_string)cached_propertytest_c\rSrSr\S5rS$SjrSrSrSr S%Sjr S&Sjr S&S jr S r S rS&S jrS rSrS'SjrSrSrSrSrSrSrSrSrSrSrSrSrSrSr Sr!S r"S!r#S"r$S#r%g)(DatabaseCreation c2[RURRnUR S5=(d USnUR S5=(d USn0UEX#S.En[ UR5nU"XRRS9$)a This is analogous to other backends' `_nodb_connection` property, which allows access to an "administrative" connection which can be used to manage the test databases. For Oracle, the only connection that can be used for that purpose is the main (non-test) connection. SAVED_USERUSERSAVED_PASSWORDPASSWORD)rr)alias)r DATABASES connectionrgettype)self settings_dictuserpasswordDatabaseWrappers T/var/www/html/env/lib/python3.13/site-packages/django/db/backends/oracle/creation.py_maindb_connection#DatabaseCreation._maindb_connection s!**4??+@+@A   .G-2G $$%56S- :SM=M$M t/}OO4I4IJJc "UR5nURR5nUR5(aUR XTX5 UR!5(a*US:aURS 5 UR#XTX5 SSS5 URR'5 UR)U5 URR*S$![ GanS[ U5;a*URSU-5 [R"S5 U(d[SUS-5nU(dWS:XGaDUS:a(URSURR-5 URXTU5 O![aZnS [ U5;aURXTX5 SnAOsURS U-5 [R"S5 SnAODSnAf[ a4nURS U-5 [R"S5 SnAOSnAff=fUR XTX5 SnAGN![ a9nURS U-5 [R"S5 SnASnAGN1SnAff=fURS 5 [R"S5 SnAGNfSnAff=f![ Ga/nS[ U5;a*URSU-5 [R"S5 U(d[SUS-5nU(dWS:XaUS:aURS5 UR%XTU5 US:aURS 5 UR#XTX5 SnAGN![ a9nURSU-5 [R"S5 SnASnAGN/SnAff=fURS 5 [R"S5 SnAGNdSnAff=f!,(df  GNs=f)N ORA-01543z+Got an error creating the test database: %sz^It appears the test database, %s, already exists. Type 'yes' to delete it, or 'no' to cancel: ryes.Destroying old test database for alias '%s'...z ORA-29857z1Got an error destroying the old test database: %sz-Got an error recreating the test database: %szTests cancelled.zCreating test user... ORA-01920z'Got an error creating the test user: %szZIt appears the test user, %s, already exists. Type 'yes' to delete it, or 'no' to cancel: Destroying old test user...z)Got an error recreating the test user: %sNAME)_get_test_db_paramsrcursor_test_database_create_execute_test_db_creation Exceptionstrlogsysexitinputrr_execute_test_db_destructionr)_handle_objects_preventing_db_destruction_test_user_create_create_test_user_destroy_test_userclose_switch_to_test_userr)r verbosity autoclobberkeepdb parametersr)econfirms r_create_test_db DatabaseCreation._create_test_dbs|--/  $ $ + + -))++6$22In%%''>HH45$**6yQ}.v %%' !!*-,,V44o!2$"#a&0!NQR!RS &"'K(01# #g&6$> HH P"&//"7"7!8( == &I - ,*c!f4 $ N N$* !"!" !%$W&'%(!"!$ (( HH SVW W HHQKK ( ( :: &I )( HH ORS S HHQKK ( !34 e2$r!$"#a&0!JQ!NO &"'F(01# #g&6 ((A~ $)F G 33F R(A~ $)@ A 22 &I )( HH%PST%TUHHQKK(!34 5$. -sO?C,O?K J?*B J:8F  J: H+!G*6J:;*G*%J:* H+7*H&!J:&H++J:/IO? J *J;J:?O?J  *J:4O?:J??O? O< AO7,AN>O? O*O8O7<O?O*O71O?7O<<O?? Pc[RURRnURRS=US'URRS'URRS=US'URRS'USnURRSnUS=US'=US'=US'URRS'US=US'URRS'g) aV Switch to the user that's used for creating the test database. Oracle doesn't have the concept of separate databases under the same user, so a separate user is used; see _create_test_db(). The main user is also needed for cleanup when testing is completed, so save its credentials in the SAVED_USER/SAVED_PASSWORD key in the settings dict. rr rrTESTrrN)rrrrr)rr< real_settingsreal_test_settings test_settingss rr8%DatabaseCreation._switch_to_test_user~s !**4??+@+@A OO ) )& 1 l#doo&C&CL&Q OO ) )* 5 6 &'$//*G*G + +6255f=  v  6" ]6%: ]6=R OO ) )& 1 z " j!DOO$A$A*$MrctUSURRS'USURRS'g)zh Set this database up to be used in testing as a mirror of a primary database whose settings are given. rrNrr)rprimary_settings_dicts rset_as_test_mirror#DatabaseCreation.set_as_test_mirrors7 1Ff0M%%f-4I*4U%%j1rcBURS5 UR5(aU(d[SUS-5nU(dWS:XalUS:aURS5 URXU5 US:a(URS URR-5 URXU5 gURS 5 [ R "S5 gURS US-5 URS 5 [ R "S5 g![a4nURSU-5 [ R "S5 SnANSnAff=f![a4nURS U-5 [ R "S5 SnAgSnAff=f) Na There are objects in the old test database which prevent its destruction. If they belong to the test user, deleting the user will allow the test database to be recreated. Otherwise, you will need to find and remove each of these objects, or use a different tablespace. zType 'yes' to delete user %s: rr"r#r&z)Got an error destroying the test user: %sr!r$z-Got an error destroying the test database: %sz5Tests cancelled -- test database cannot be recreated.z[Django is configured to use pre-existing test user '%s', and will not attempt to delete it.) r.r4r1r6r,r/r0rrr2)rr)r<r9r:r>r=s rr3:DatabaseCreation._handle_objects_preventing_db_destructionsd  /   ! ! # # @:fCU UVg.  A~!>?++F J   A~L"oo33455f)T PQ HH68B68JK  HHL M HHQK-! HHH1LMHHQKK ! HHLqPQHHQKK s1 )D7AE  E)*EE F**FFcURRSURRS'URRSURRS'URR5 UR5nURR 5nUR 5(a)US:aURS5 URXCU5 UR5(a)US:aURS5 URXCU5 SSS5 URR5 g!,(df  N)=f) z Destroy a test database, prompting the user for confirmation if the database already exists. Return the name of the test database created. r rrrr#zDestroying test user...z"Destroying test database tables...N) rrr7r(rr)r4r.r6r*r2)rtest_database_namer9r<r)s r_destroy_test_db!DatabaseCreation._destroy_test_dbs 150M0M 1 %%f-59OO4Q4Q 5 %%j1 --/  $ $ + + -%%''>HH67''IF))++>HHAB11&iP. %%'. -s %A=E EcUS:aURSUS-5 UR5(aSS/nOSS/nU(aSOSnURXX#U5 g) Nr!z_create_test_db(): dbname = %srz CREATE TABLESPACE %(tblspace)s DATAFILE SIZE %(size)s AUTOEXTEND ON NEXT %(extsize)s MAXSIZE %(maxsize)s z CREATE TEMPORARY TABLESPACE %(tblspace_temp)s TEMPFILE SIZE %(size_tmp)s AUTOEXTEND ON NEXT %(extsize_tmp)s MAXSIZE %(maxsize_tmp)s z CREATE TABLESPACE %(tblspace)s DATAFILE '%(datafile)s' SIZE %(size)s REUSE AUTOEXTEND ON NEXT %(extsize)s MAXSIZE %(maxsize)s z CREATE TEMPORARY TABLESPACE %(tblspace_temp)s TEMPFILE '%(datafile_tmp)s' SIZE %(size_tmp)s REUSE AUTOEXTEND ON NEXT %(extsize_tmp)s MAXSIZE %(maxsize_tmp)s r )r.#_test_database_oracle_managed_files_execute_allow_fail_statements)rr)r<r9r; statementsacceptable_ora_errs rr+*DatabaseCreation._execute_test_db_creationss > HH5 68JJ K  3 3 5 5  J  J-3[ ++  7I rcnUS:aURSUS-5 SS/nU(aSOSnURXX#U5nU(d'URS5cSnURX/X#5 S HBn S n XS 'URX/X#S 5nU(aM&US:dM.URS U -5 MD g)Nr!z"_create_test_user(): username = %srzCREATE USER %(user)s IDENTIFIED BY "%(password)s" DEFAULT TABLESPACE %(tblspace)s TEMPORARY TABLESPACE %(tblspace_temp)s QUOTA UNLIMITED ON %(tblspace)s zGRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE PROCEDURE, CREATE TRIGGER TO %(user)sr%rz0ALTER USER %(user)s IDENTIFIED BY "%(password)s")VIEWzMATERIALIZED VIEWz(GRANT CREATE %(object_type)s TO %(user)s object_typez ORA-01031zBFailed to grant CREATE %s permission to test user. This may be ok.)r.rT_test_settings_get_execute_statements) rr)r<r9r;rUrVsuccess set_passwordrZextras rr5"DatabaseCreation._create_test_users > HH9JvFML  $ $V^Z S9K>E(3} %99 G7yA~X!"9rcjUS:aURSUS-5 SS/nURXX#5 g)Nr!z)_execute_test_db_destruction(): dbname=%srzQDROP TABLESPACE %(tblspace)s INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTSzVDROP TABLESPACE %(tblspace_temp)s INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTSr.r\rr)r<r9rUs rr2-DatabaseCreation._execute_test_db_destruction.sE > HH@:fCUU V C C   ZKrcUS:a(URSUS-5 URS5 S/nURXX#5 g)Nr!z_destroy_test_user(): user=%srz&Be patient. This can take some time...zDROP USER %(user)s CASCADErbrcs rr6#DatabaseCreation._destroy_test_user9sI > HH4z&7II J HH= > (    ZKrcUH*nXc-nUS:a [U5 URU5 M, g![a'nU(aUS:aURSU-5 eSnAff=f)Nr!z Failed (%s))printexecuter,r.) rr)rUr<r9allow_quiet_failtemplatestmterrs rr\$DatabaseCreation._execute_statementsBsd#H(DA~d  t$ #  (Y!^HH]c23 s2 A#"AA#cUSL=(a [U5S:nURUUUUUS9 g![an[U5nUbXX;aeSnAgSnAff=f)z Execute statements which are allowed to fail silently if the Oracle error code given by `acceptable_ora_err` is raised. Return True if the statements execute without an exception, or False otherwise. Nr)rjTF)lenr\rr-) rr)rUr<r9rVrjrm descriptions rrT/DatabaseCreation._execute_allow_fail_statementsPsz #$.N37I3JQ3N   $ $!1 %  c(K!)-?-R  s,/ AAAcUR5UR5UR5UR5UR 5UR 5UR 5UR5UR5UR5UR5UR5UR5S. $)N) dbnamerrtblspace tblspace_tempdatafile datafile_tmpmaxsize maxsize_tmpsizesize_tmpextsize extsize_tmp) _test_database_name_test_database_user_test_database_passwd_test_database_tblspace_test_database_tblspace_tmp _test_database_tblspace_datafile$_test_database_tblspace_tmp_datafile_test_database_tblspace_maxsize#_test_database_tblspace_tmp_maxsize_test_database_tblspace_size _test_database_tblspace_tmp_size_test_database_tblspace_extsize#_test_database_tblspace_tmp_extsizers rr($DatabaseCreation._get_test_db_paramsks..0,,.224446!==?==? EEG;;=CCE557==?;;=CCE  rNcURRnUSRX5nUcU(a [XC-nU$)zr Return a value from the test settings dict, or a given default, or a prefixed entry from the main settings dict. rBrrrTEST_DATABASE_PREFIX)rkeydefaultprefixedrvals rr[#DatabaseCreation._test_settings_get|sA 55 F#''5 ;8&)@@C rc"URSSS9$)Nr'rr[rs rr$DatabaseCreation._test_database_name&&v&??rc"URSSS9$)N CREATE_DBTrrrs rr*&DatabaseCreation._test_database_creates&&{D&AArc"URSSS9$)N CREATE_USERTrrrs rr4"DatabaseCreation._test_user_creates&&}d&CCrc"URSSS9$)Nrrrrs rr$DatabaseCreation._test_database_userrrcnURS5nUc UR5(a [S5nU$)Nr)r[r4r)rrs rr&DatabaseCreation._test_database_passwds5**:6   6 6 8 8(,Hrc"URSSS9$)NTBLSPACErrrrs rr(DatabaseCreation._test_database_tblspaces&&zF&CCrcrURRnUSRS[US-S-5$)NrB TBLSPACE_TMPr_temprrrs rr,DatabaseCreation._test_database_tblspace_tmps>55 V$(( 0=3HH7R  rcHSUR5-nURSUS9$)N%s.dbfDATAFILEr)rr[rrus rr1DatabaseCreation._test_database_tblspace_datafiles+d::<<&&z8&DDrcHSUR5-nURSUS9$)Nr DATAFILE_TMPr)rr[rs rr5DatabaseCreation._test_database_tblspace_tmp_datafiles+d>>@@&&~x&HHrc"URSSS9$)NDATAFILE_MAXSIZE500Mrrrs rr0DatabaseCreation._test_database_tblspace_maxsizes&&'96&JJrc"URSSS9$)NDATAFILE_TMP_MAXSIZErrrrs rr4DatabaseCreation._test_database_tblspace_tmp_maxsizes&&'=v&NNrc"URSSS9$)N DATAFILE_SIZE50Mrrrs rr-DatabaseCreation._test_database_tblspace_sizes&&&FFrc"URSSS9$)NDATAFILE_TMP_SIZErrrrs rr1DatabaseCreation._test_database_tblspace_tmp_sizes&&':E&JJrc"URSSS9$)NDATAFILE_EXTSIZE25Mrrrs rr0DatabaseCreation._test_database_tblspace_extsizes&&'95&IIrc"URSSS9$)NDATAFILE_TMP_EXTSIZErrrrs rr4DatabaseCreation._test_database_tblspace_tmp_extsize&&'=u&MMrc"URSSS9$)NORACLE_MANAGED_FILESFrrrs rrS4DatabaseCreation._test_database_oracle_managed_filesrrc4URRS$)z 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 don't have real counterparts in Oracle. r'rHrs r_get_test_db_name"DatabaseCreation._get_test_db_names ,,V44rcpURRnUSUSUSUSUR54$)NHOSTPORTENGINEr')rrrrs rtest_db_signature"DatabaseCreation.test_db_signaturesG55 & ! & ! ( # & !  $ $ &   r)r#FF)r#)F)NN)&__name__ __module__ __qualname____firstlineno__rrr?r8rJr3rPr+r5r2r6r\rTr(r[rr*r4rrrrrrrrrrrrrSrr__static_attributes__rrrr r s K K_5B 2V*X(0! F&P LLKP 6 " @BD@D EIKOGKJNN5 rr ) r/ django.confr django.dbr django.db.backends.base.creationrdjango.utils.cryptordjango.utils.functionalrrr rrrrs, #A13D +D r