ó TR¹Nc@sàddlZddlZddlmZddlmZddlmZddlm Z ddl m Z ddl m Z ddlmZd „Zd „Zd „Zed „Zd „Zd„Zd„Zd„Zd„ZdS(iÿÿÿÿN(tsettings(tgeneric(t CommandError(t dispatcher(tmodels(t get_models(t truncate_namecCsð|jddkr.tddddƒ‚ntj|dtƒ}g}|jjƒ}tg|jj|ƒD]}||krn|^qnƒ}i}xÉ|D]Á}|j j |||ƒ\} } |j | ƒxa| j ƒD]S\} } |j | gƒj | ƒ| |krÚ|j |j j| ||ƒƒqÚqÚW|j |j j|||ƒƒ|j|ƒqœWt|jƒƒ} | rìg}xD| D]<}|j g|j j|||ƒD]}d|^q«ƒq†W|rì|jd ƒ|j |ƒqìn|S( sDReturns a list of the CREATE TABLE SQL statements for the given app.tENGINEsdjango.db.backends.dummysADjango doesn't know which syntax to use for your SQL statements, sCbecause you haven't specified the ENGINE setting for the database. sSEdit your settings file and change DATBASES['default']['ENGINE'] to something like s='django.db.backends.postgresql' or 'django.db.backends.mysql'tinclude_auto_createds-- sN-- The following references should be added but depend on non-existent tables:(t settings_dictRRRtTruet introspectiont table_namestsettinstalled_modelstcreationtsql_create_modeltextendtitemst setdefaulttsql_for_pending_referencestaddtkeystappend(tapptstylet connectiont app_modelst final_outputttablestmodelt known_modelstpending_referencestoutputt referencestreftotrefstnot_installed_modelst alter_sqltsql((sG/home/panlixing/Python_Projects/gaeseries/django/core/management/sql.pyt sql_create s8  7   &  1 c Csy|jƒ}Wn d}nX|r;|jj|ƒ}ng}g}tƒ}i}tj|dtƒ}x¢|D]š} |rr|jj| j j ƒ|krr| j } xT| j D]I} | j r¯| j j |kr¯|j| j j gƒj| | fƒq¯q¯W|j| ƒqrqrWxN|D]F} |jj| j j ƒ|kr|j|jj| ||ƒƒqqW|r~|jƒ|jƒn|ddd…S(sBReturns a list of the DROP TABLE SQL statements for the given app.RNiÿÿÿÿ(tcursortNoneR tget_table_listR RRR ttable_name_convertert_metatdb_tablet local_fieldstrelttoRRRRRtsql_destroy_modeltclose( RRRR)R R!t to_deletetreferences_to_deleteRRtoptstf((sG/home/panlixing/Python_Projects/gaeseries/django/core/management/sql.pyt sql_delete:s2   $ , &  cCs t|||ƒt|||ƒS(sVReturns a list of the DROP TABLE SQL, then the CREATE TABLE SQL, for the given module.(R8tsql_all(RRR((sG/home/panlixing/Python_Projects/gaeseries/django/core/management/sql.pyt sql_resetfscCsR|r|jjdtƒ}n|jjƒ}|jj|||jjƒƒ}|S(sÐ Returns a list of the SQL statements used to flush the database. If only_django is True, then only table names that have associated Django models and are in INSTALLED_APPS will be included. t only_existing(R tdjango_table_namesR R topst sql_flusht sequence_list(RRt only_djangoRt statements((sG/home/panlixing/Python_Projects/gaeseries/django/core/management/sql.pyR>js !cCspg}t|ƒ}tjjtjjtjj|jƒdƒƒ}x'|D]}|jt|||ƒƒqIW|S(sNReturns a list of the custom table modifying SQL statements for the given app.R'( Rtostpathtnormpathtjointdirnamet__file__Rtcustom_sql_for_model(RRRR!Rtapp_dirR((sG/home/panlixing/Python_Projects/gaeseries/django/core/management/sql.pyt sql_customxs  0 cCs@g}x3tj|ƒD]"}|j|jj||ƒƒqW|S(sRReturns a list of the CREATE INDEX SQL statements for all models in the given app.(RRRRtsql_indexes_for_model(RRRR!R((sG/home/panlixing/Python_Projects/gaeseries/django/core/management/sql.pyt sql_indexes„s cCs0t|||ƒt|||ƒt|||ƒS(sdReturns a list of CREATE TABLE SQL, initial-data inserts, and CREATE INDEX SQL for the given module.(R(RJRL(RRR((sG/home/panlixing/Python_Projects/gaeseries/django/core/management/sql.pyR9‹scCsÒ|j}tjjtjjtjjtj|jjƒj ƒdƒƒ}g}|j rµg|j D]}t |dƒra|^qa}x0|D]%}|j |j||jjƒƒq‰Wntjdtjƒ}|jdjdƒd} tjj|d|jjƒ| fƒtjj|d|jjƒƒg} x| D]•} tjj| ƒr5t| d ƒ} x^|j| jƒjtjƒƒD];} tjd d | ƒ} | jƒr~|j| d ƒq~q~W| j ƒq5q5W|S( NR'tpost_create_sqls;[ \t]*$Rt.iÿÿÿÿs %s.%s.sqls%s.sqltUu--.*([\n\Z]|$)tu;(!R-RBRCRDRERFRtget_appt app_labelRGtmanagedR/thasattrRRMR.tretcompiletMR tsplitt object_nametlowertexiststopentreadtdecodeRt FILE_CHARSETtsubtstripRR3(RRRR6RIR!R7tpost_sql_fieldsRAt backend_namet sql_filestsql_filetfpt statement((sG/home/panlixing/Python_Projects/gaeseries/django/core/management/sql.pyRHs( ? + &%% ( cCs}xvtjƒD]h}|jjdƒd}|dkrAdG|GHntjjjd|d|d|d|d |d |ƒq WdS( NRNiþÿÿÿis*Running post-sync handlers for applicationtsenderRtcreated_modelst verbosityt interactivetdb(Rtget_appst__name__RXtsignalst post_syncdbtsend(RiRjRkRlRtapp_name((sG/home/panlixing/Python_Projects/gaeseries/django/core/management/sql.pytemit_post_sync_signal±s   (RBRUt django.confRtdjango.contrib.contenttypesRtdjango.core.management.baseRtdjango.dispatchRt django.dbRtdjango.db.modelsRtdjango.db.backends.utilRR(R8R:tFalseR>RJRLR9RHRs(((sG/home/panlixing/Python_Projects/gaeseries/django/core/management/sql.pyts"   . ,     "