ó Ý*µPc@sZddlmZddlmZddlmZddlmZdefd„ƒYZdS(iÿÿÿÿ(tsettings(tImproperlyConfigured(tDatabaseCreation(tcached_propertytPostGISCreationcBsDeZdZdZdZed„ƒZd„Zd„Zd„Z RS(tGISTtGIST_GEOMETRY_OPStGIST_GEOMETRY_OPS_NDcCsHttddƒ}|jjƒ}|jd|fƒ|jƒrD|SdS(NtPOSTGIS_TEMPLATEttemplate_postgiss5SELECT 1 FROM pg_database WHERE datname = %s LIMIT 1;(tgetattrRt connectiontcursortexecutetfetchonetNone(tselfR R ((sH../Django//lib/python/django/contrib/gis/db/backends/postgis/creation.pyR s  c Cs¡ddlm}tt|ƒj|||ƒ}t||ƒr|jjj}|jjj }|j j }|j s‘|jjj r‚n|j|jdƒ|jdƒd|j||ƒƒd|j||jƒƒd|jt|jƒƒd|j||jƒƒd|jt|jƒƒdƒ|js‘|j|jdƒ|j||ƒƒ|jd ƒ|j||jƒƒ|jd ƒd ƒn|jr|j r¬d } nV|jjj rì|jd krãd|j|jƒ} qd } nd|j|jƒ} |j|jdƒ|j|d||jfƒƒ|jdƒ|j||ƒƒ|jdƒ|j|jƒd|j||jƒƒ| dƒqn|S(s4Return any spatial index creation SQL for the field.iÿÿÿÿ(t GeometryFieldsSELECT tAddGeometryColumnt(s, s);s ALTER TABLE s ALTER s SET NOT NULLt;tit s CREATE INDEX s%s_%s_ids ON s USING s ( s );(t#django.contrib.gis.db.models.fieldsRtsuperRtsql_indexes_for_fieldt isinstanceR topstgeo_quote_namet quote_namet_metatdb_tablet geographytgeometrytappendt SQL_KEYWORDt SQL_TABLEt SQL_FIELDtcolumntstrtsridt SQL_COLTYPEt geom_typetdimtnullt spatial_indextgeom_index_ops_ndtgeom_index_opstgeom_index_type( RtmodeltftstyleRtoutputtgqntqnRt index_ops((sH../Django//lib/python/django/contrib/gis/db/backends/postgis/creation.pyRs0   Z    •cCs0|jdk r,d|jjj|jƒfSdS(Ns TEMPLATE %sR(R RR RR(R((sH../Django//lib/python/django/contrib/gis/db/backends/postgis/creation.pytsql_table_creation_suffixPscCswtt|ƒj||ƒ}|jdkrs|jjƒ||jjd<|jjƒ}|j dƒ|jj ƒn|S(NtNAMEsCREATE EXTENSION postgis( RRt_create_test_dbR RR tcloset settings_dictR R tcommit(Rt verbosityt autoclobberttest_database_nameR ((sH../Django//lib/python/django/contrib/gis/db/backends/postgis/creation.pyR:Vs  ( t__name__t __module__R0R/R.RR RR8R:(((sH../Django//lib/python/django/contrib/gis/db/backends/postgis/creation.pyRs ; N( t django.confRtdjango.core.exceptionsRt/django.db.backends.postgresql_psycopg2.creationRtdjango.utils.functionalRR(((sH../Django//lib/python/django/contrib/gis/db/backends/postgis/creation.pyts