ó øĒTQc@svddlZddlmZddlmZddlmZddlmZddl m Z de fd„ƒYZ dS( iĸĸĸĸN(tsettings(t get_cache(tBaseDatabaseCache(tImproperlyConfigured(tDatabaseCreationtSpatiaLiteCreationcBs2eZded„Zd„Zd„Zd„ZRS(ic Cs‹ddlm}|jƒ}|dkr_d}|dkrGd|}nd|jj|fGHn|j||ƒ|jjƒ||jjd<|jjj ƒ|j ƒ|d d t |dd ƒd t d |jjdt ƒ|dd t |dd ƒd t d |jjƒddl m}ddlm}xKtjD]@}||ƒ} t| |ƒr4|d| jd |jjƒq4q4W|jjƒ} |S(s$ Creates a test database, prompting the user for confirmation if the database already exists. Returns the name of the test database created. This method is overloaded to load up the SpatiaLite initialization SQL prior to calling the `syncdb` command. iĸĸĸĸ(t call_commanditis ('%s')s*Creating test database for alias '%s'%s...tNAMEtsyncdbt verbosityit interactivetdatabasetload_initial_datatflush(R(Rtcreatecachetable(tdjango.core.managementRt_get_test_db_namet connectiontaliast_create_test_dbtcloset settings_dicttopst#confirm_spatial_components_versionstload_spatialite_sqltmaxtFalsetdjango.core.cacheRtdjango.core.cache.backends.dbRRtCACHESt isinstancet_tabletcursor( tselfR t autoclobberRttest_database_namet test_db_reprRRt cache_aliastcacheR!((sK../Django//lib/python/django/contrib/gis/db/backends/spatialite/creation.pytcreate_test_db s:            #c Cs™ddlm}tt|ƒj|||ƒ}t||ƒr•|jjj}|jjj }|j j }|j |j dƒ|jdƒd|j||ƒƒd|j||jƒƒd|jt|jƒƒd|j||jƒƒd|j t|jƒƒd|j tt|j ƒƒƒdƒ|jr•|j |j dƒ|jdƒd|j||ƒƒd|j||jƒƒdƒq•n|S( s4Return any spatial index creation SQL for the field.iĸĸĸĸ(t GeometryFieldsSELECT tAddGeometryColumnt(s, s);tCreateSpatialIndex(t#django.contrib.gis.db.models.fieldsR)tsuperRtsql_indexes_for_fieldRRRtgeo_quote_namet quote_namet_metatdb_tabletappendt SQL_KEYWORDt SQL_TABLEt SQL_FIELDtcolumntstrtsridt SQL_COLTYPEt geom_typetdimtinttnullt spatial_index( R"tmodeltftstyleR)toutputtgqntqnR3((sK../Django//lib/python/django/contrib/gis/db/backends/spatialite/creation.pyR/Fs đ XcCs§|jjjd dkr8|jjƒ}|jdƒnk|jƒ}tjj|ƒsit d|ƒ‚nt |dƒ)}|jjƒ}|j |j ƒƒWdQXdS(s@ This routine loads up the SpatiaLite SQL file. iisSELECT InitSpatialMetaData()sZCould not find the required SpatiaLite initialization SQL file (necessary for testing): %strN(ii( RRtspatial_versiont_cursortexecutetspatialite_init_filetostpathtisfileRtopent executescripttread(R"tcurtspatialite_sqltsql_fh((sK../Django//lib/python/django/contrib/gis/db/backends/spatialite/creation.pyRcs  cCs!ttdd|jjjd ƒS(NtSPATIALITE_SQLsinit_spatialite-%s.%s.sqli(tgetattrRRRRH(R"((sK../Django//lib/python/django/contrib/gis/db/backends/spatialite/creation.pyRK}s (t__name__t __module__RR(R/RRK(((sK../Django//lib/python/django/contrib/gis/db/backends/spatialite/creation.pyRs<  ( RLt django.confRRRRRtdjango.core.exceptionsRt#django.db.backends.sqlite3.creationRR(((sK../Django//lib/python/django/contrib/gis/db/backends/spatialite/creation.pyts