Ńň şl°Mc@sHddkZddkZddklZdZdefd„ƒYZdS(i˙˙˙˙N(tsettingsttest_tBaseDatabaseCreationcBsŕeZdZhZd„Zd„Zeƒd„Zd„Zd„Z d„Z d„Z d„Z d „Z d „Zd „Zd „Zd „Zded„Zd„Zd„Zdd„Zd„Zd„Zd„Zd„ZRS(s This class encapsulates all backend-specific differences that pertain to database *creation*, such as the column types to use for particular Django Fields, the SQL used to create and destroy tables, and the creation and destruction of test databases. cCs ||_dS(N(t connection(tselfR((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyt__init__scGsdtt|ƒƒdS(sx Generates a 32-bit digest of a set of arguments that can be used to shorten identifying names. s%xl(tabsthash(Rtargs((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyt_digestscCs§|i}|i p |io ghfSg}g}h}|iii}x•|iD]Š} | id|iƒ} | ip|i} | djoqTn|i || i ƒƒ|i | ƒg} | i p| i|idƒƒn| io| i|idƒƒn%| io| i|idƒƒn| o0| io&| i|iii| dtƒƒn| io^|i| ||ƒ\} }|o+|i| iigƒi|| fƒ}qČ| i| ƒn|idi| ƒƒqTWxn|iD]c}|i|idƒddig}|D](} ||i ||i| ƒi ƒƒq~ƒƒqěW|id ƒd|i||iƒƒd g}xOt|ƒD]A\}}|id ||t|ƒd jod pdfƒqW|idƒ|io#|i|iii|iƒƒn|idƒ|idi|ƒƒ|i oa|i!i"p |i!i#}|iii$|i|ƒ}|o"x|D]}|i|ƒq~Wqn||fS(s† Returns the SQL required to create a single model, as a tuple of: (list_of_sql, pending_references_dict) RsNOT NULLs PRIMARY KEYtUNIQUEtinlinet s (%s)s, s CREATE TABLEs (s %s%sit,tt)t;s N(%t_metatmanagedtproxyRtopst quote_namet local_fieldstdb_typet db_tablespacetNonet SQL_FIELDtcolumnt SQL_COLTYPEtnulltappendt SQL_KEYWORDt primary_keytuniquettablespace_sqltTruetrelt%sql_for_inline_foreign_key_referencest setdefaultttotextendtjointunique_togethert get_fieldt SQL_TABLEtdb_tablet enumeratetlenthas_auto_fieldt auto_fieldt db_columntnamet autoinc_sql(Rtmodeltstylet known_modelstoptst final_outputt table_outputtpending_referencestqntftcol_typet tablespacet field_outputt ref_outputtpendingtprtfield_constraintst_[1]tfull_statementtitlinet auto_columnR4tstmt((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pytsql_create_modelsd       & + L0 9  #  cCs˝|iii}|ii|jo…|idƒd|i||iiiiƒƒd|i ||iiii |ii ƒi ƒƒd|iii ƒg}t}n g}t}||fS(sEReturn the SQL snippet defining the foreign key reference for a fieldt REFERENCESR s (R(RRRR$R'RR,RR-RR+t field_nameRtdeferrable_sqltFalseR#(RtfieldR7R6R<toutputRB((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyR%[se c CsOddkl}|ii p |iiogS|iii}g}|i}||jođxâ||D]Ö\}} |i} | i} | i } |i} |i | i i ƒi }d| ||i | | ƒf}|i|idƒd|| ƒ||||iiiƒƒƒ|| ƒ|| ƒ||ƒ|iiiƒfƒqfW||=n|S(sEReturns any ALTER TABLE statements to add constraints after the fact.i˙˙˙˙(t truncate_names %s_refs_%s_%ss ALTER TABLEs< %s ADD CONSTRAINT %s FOREIGN KEY (%s) REFERENCES %s (%s)%s;(tdjango.db.backends.utilRRRRRRRRR-RR+R$RMR RRtmax_name_lengthRN(RR5R6R;RRR<R9R8t rel_classR=trel_optstr_tabletr_colttabletcoltr_name((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pytsql_for_pending_referencesms*       ' cCs}ddk}|idtƒg}xT|iiD]F}|iip|iiiio |i|i |||ƒƒq/q/W|S(sTReturn the CREATE TABLE statments for all the many-to-many tables defined on a modeli˙˙˙˙NsdDatabase creation API for m2m tables has been deprecated. M2M models are now automatically generated( twarningstwarntDeprecationWarningRtlocal_many_to_manyRR$R'R(tsql_for_many_to_many_field(RR5R6R]RQR=((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pytsql_for_many_to_many‡s   $c Csddk}|idtƒddkl}ddkl}g}|ioĎ|i}|i i i } |i p|i } | o:|i i i | dtƒ} | od| } qžd} nd} |id ƒd|i| |iƒƒƒd g} | id |i| d ƒƒ|i|id tƒid|i ƒƒ|idƒ| fƒg}|i|||ƒ\}}| i|ƒ| id|idƒ|i| |iƒƒƒ|i| |iƒƒƒ| fƒ| idƒ|i o#| i|i i i |i ƒƒn| idƒ|idi| ƒƒx¨|D] \}}}}d|||i||ƒf}|i|idƒd| |ƒ| |||i i iƒƒƒ| |ƒ| |ƒ| |ƒ|i i iƒfƒq,W|i i i|iƒd ƒ}|o"x|D]}|i|ƒqüWqn|S(s9Return the CREATE TABLE statements for a single m2m fieldi˙˙˙˙NsdDatabase creation API for m2m tables has been deprecated. M2M models are now automatically generated(tmodels(RRR R Rs CREATE TABLEs (s %s %s %s%s,tidR RsNOT NULL PRIMARY KEYs %s (%s, %s)%sR RRs s %s_refs_%s_%ss ALTER TABLEs< %s ADD CONSTRAINT %s FOREIGN KEY (%s) REFERENCES %s (%s)%s;( R]R^R_t django.dbRcRSRRt auto_createdRRRRRR"R#RR,t m2m_db_tableRRRt AutoFieldRt&sql_for_inline_many_to_many_referencesR(tm2m_column_nametm2m_reverse_nameR)R RTRNR4(RR5R=R6R]RcRRRQR8R<R?tsqlR"R:tdeferredt inline_outputRWRXRYRZR[R4RJ((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyRa•sd    3 '        #  c Csˆddk}|idtƒddkl}|i}|iii}d|i ||i ƒƒƒ|i |i |ƒi d|iƒƒ|idƒ|i||iƒƒ|i ||iiƒƒ|iiiƒfd|i ||iƒƒƒ|i |i |iiƒi d|iƒƒ|idƒ|i||iiiiƒƒ|i ||iiiiiƒƒ|iiiƒfg}g} || fS(sFCreate the references to other tables required by a many-to-many tablei˙˙˙˙NsdDatabase creation API for m2m tables has been deprecated. M2M models are now automatically generated(Rcs %s %s %s %s (%s)%s,RsNOT NULL REFERENCES(R]R^R_ReRcRRRRRRjRt ForeignKeyRRR,R-tpkRRNRkR$R'( RR5RPR6R]RcR8R<R:Rm((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyRiÔs.  $ * !cCs]|ii p |iiogSg}x0|iiD]"}|i|i|||ƒƒq3W|S(s:Returns the CREATE INDEX SQL statements for a single model(RRRRR(tsql_indexes_for_field(RR5R6RQR=((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pytsql_indexes_for_modelôs  c CsMddkl}|io)|i o|iii}|ip |ii}|o4|iii |ƒ}|od|}q‹d}nd}d|ii |i |i ƒf} |i dƒd|i||| |iiiƒƒƒƒd|i dƒd|i||ii ƒƒdd|i||i ƒƒd |g} ng} | S( s?Return the CREATE INDEX SQL statements for a single model fieldi˙˙˙˙(RRR Rs%s_%ss CREATE INDEXtONs(%s)s%s;(RSRRtdb_indexR!RRRRRR"R-R RRR,RTR( RR5R=R6RRR<R?RlR"ti_nameRQ((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyRqýs "„cCsŐ|ii p |iiogS|iii}d|idƒ|i||iiƒƒfg}||jo |i |i |||ƒƒn|ii o7|iii |iiƒ}|o|i |ƒqŃn|S(sJReturn the DROP TABLE and restraint dropping statements for a single models%s %s;s DROP TABLE(RRRRRRRR,R-R(tsql_remove_table_constraintsR0tdrop_sequence_sqlR(RR5treferences_to_deleteR6R<RQtds((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pytsql_destroy_models"   c Cs4ddkl}|ii p |iiogSg}|iii}xá||D]Ő\}}|ii} |i } |ii} |ii |i i ƒi } d| | |i | | ƒf} |id|idƒ|i|| ƒƒ|i|iiiƒƒ|i||| |iiiƒƒƒƒfƒqPW||=|S(Ni˙˙˙˙(RRs %s_refs_%s_%ss %s %s %s %s;s ALTER TABLE(RSRRRRRRRRR-RR+R$RMR RRR,tdrop_foreignkey_sqlRRT(RR5RxR6RRRQR<RUR=RYRZRWRXR[((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyRv(s&      3cCs¸ddk}|idtƒ|iii}g}|ioy|id|idƒ|i ||i ƒƒƒfƒ|iii d|i i |ifƒ}|o|i|ƒq´n|S(s8Returns the DROP TABLE statements for a single m2m fieldi˙˙˙˙NsdDatabase creation API for m2m tables has been deprecated. M2M models are now automatically generateds%s %s;s DROP TABLEs%s_%s(R]R^R_RRRRfRRR,RgRwRR-R(RR5R=R6R]R<RQRy((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pytsql_destroy_many_to_many=s   (ic CsEddkl}|iƒ}|djo:d}|djod|}nd|ii|fGHn|i||ƒ|iiƒ||iid<|iii ƒ|d d t |dd ƒd t d |iidt ƒ|dd t |dd ƒd t d |iiƒddk l }dtijon|ddƒ}|dj oN|ii|iiƒiƒdjo)|ii|iiƒidtiƒq’nddkl}ddkl} x}tiD]r} || ƒ} t| | ƒoPddkl} | i|ii| iƒo |d| i d |iiƒq.qźqźW|ii!ƒ} |S(sĽ Creates a test database, prompting the user for confirmation if the database already exists. Returns the name of the test database created. i˙˙˙˙(t call_commandiRis ('%s')s*Creating test database for alias '%s'%s...tNAMEtsyncdbt verbosityit interactivetdatabasetload_initial_datatflush(t get_modelsdjango.contrib.sitestsitestSiteRd(t get_cache(tBaseDatabaseCache(troutertcreatecachetableN("tdjango.core.managementR}t_get_test_db_nameRtaliast_create_test_dbtcloset settings_dicttfeaturestconfirmtmaxROtdjango.db.modelsR…RtINSTALLED_APPSRtobjectstusingtcounttupdatetSITE_IDtdjango.core.cacheRˆtdjango.core.cache.backends.dbR‰tCACHESt isinstanceReRŠt allow_syncdbtcache_model_classt_tabletcursor(RR€t autoclobberR}ttest_database_namet test_db_reprR…R‡RˆR‰t cache_aliastcacheRŠRŁ((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pytcreate_test_dbOsH        2-  (cCs2|iido|iidSt|iidS(s  Internal implementation - returns the name of the test DB that will be created. Only useful when called from create_test_db() and _create_test_db() and when no external munging is done with the 'NAME' or 'TEST_NAME' settings. t TEST_NAMER~(RR‘tTEST_DATABASE_PREFIX(R((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyR’sc Csg|iƒ}|iƒ}|iii}|iiƒ}|iƒy!|id||ƒ|fƒWn˙tj oó}t i i d|ƒ|pt d|ƒ}n|p |djo•yX|djod|ii GHn|id||ƒƒ|id||ƒ|fƒWq^tj o*}t i i d|ƒt id ƒq^Xqcd GHt idƒnX|S( s5Internal implementation - creates the test db tables.sCREATE DATABASE %s %ss,Got an error creating the test database: %s sXType 'yes' if you would like to try deleting the test database '%s', or 'no' to cancel: tyesis$Destroying old test database '%s'...sDROP DATABASE %ss.Got an error recreating the test database: %s isTests cancelled.(tsql_table_creation_suffixRRRRRŁtset_autocommittexecutet Exceptiontsyststderrtwritet raw_inputRŽtexit( RR€R¤tsuffixRĽR<RŁteR“((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyRs.   ! !cCsˆ|iiƒ|iid}|djo:d}|djod|}nd|ii|fGHn||iid<|i||ƒdS(sĽ Destroy a test database, prompting the user for confirmation if the database already exists. Returns the name of the test database created. R~iRis ('%s')s,Destroying test database for alias '%s'%s...N(RRR‘RŽt_destroy_test_db(Rtold_database_nameR€RĽRŚ((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pytdestroy_test_dbżs   cCsW|iiƒ}|iƒtidƒ|id|iii|ƒƒ|iiƒdS(s4Internal implementation - remove the test db tables.isDROP DATABASE %sN( RRŁRŽttimetsleepRŻRRR(RRĽR€RŁ((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyR¸Ďs    cCs‡t|iidƒo@t|iiiƒo|iiitƒqƒt|ii_n.t|iidƒo|iiidƒndS(s-Make sure a connection is in autocommit mode.t autocommittset_isolation_leveliN(thasattrRtcallableR˝R#Rž(R((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyRŽŰs cCsdS(s>SQL to append to the end of the test table creation statementsR((R((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyR­ĺscCs,|ii}|d|d|d|dfS(sČ Returns a tuple with elements of self.connection.settings_dict (a DATABASES setting value) that uniquely identify a database accordingly to the RDBMS particularities. tHOSTtPORTtENGINER~(RR‘(RR‘((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyttest_db_signatureés  (t__name__t __module__t__doc__t data_typesRR tsetRKR%R\RbRaRiRrRqRzRvR|RORŠRRRşR¸RŽR­RÄ(((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyR s.  >    ?    C "  (RąRťt django.confRRŤtobjectR(((sE/usr/local/lib/python2.6/dist-packages/django/db/backends/creation.pyts