ó i4Vdc@s:ddlmZddlmZdefd„ƒYZdS(iÿÿÿÿ(tDatabaseSchemaEditor(t DatabaseErrortSpatialiteSchemaEditorcBs’eZdZdZdZdZdZdZdddd gZd „Z d „Z e d „Z d „Z d„Zd„Zd„Zd„Zd„ZRS(s[SELECT AddGeometryColumn(%(table)s, %(column)s, %(srid)s, %(geom_type)s, %(dim)s, %(null)s)s0SELECT CreateSpatialIndex(%(table)s, %(column)s)s#DROP TABLE idx_%(table)s_%(column)ss3SELECT DiscardGeometryColumn(%(table)s, %(column)s)s9DELETE FROM %(geom_table)s WHERE f_table_name = %(table)ssYUPDATE %(geom_table)s SET f_table_name = %(new_table)s WHERE f_table_name = %(old_table)stgeometry_columnstgeometry_columns_authtgeometry_columns_timetgeometry_columns_statisticscOs&tt|ƒj||Žg|_dS(N(tsuperRt__init__t geometry_sql(tselftargstkwargs((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pyRscCs|jjj|ƒS(N(t connectiontopstgeo_quote_name(R tname((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pyRscCsddlm}t||ƒs;tt|ƒj|||ƒS|jj|ji|j |j j ƒd6|j |j ƒd6|j d6|j |jƒd6|jd6t|j ƒd6ƒ|jrÿ|jj|ji|j|j j ƒd6|j|j ƒd6ƒnd S( Niÿÿÿÿ(t GeometryFieldttabletcolumntsridt geom_typetdimtnull(NN(t#django.contrib.gis.db.models.fieldsRt isinstanceRRt column_sqlR tappendtsql_add_geometry_columnRt_metatdb_tableRRRRtintRt spatial_indextsql_add_spatial_indext quote_nametNone(R tmodeltfieldtinclude_defaultR((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pyR!s"       cCsl|j|ji|j|jjƒd6|j|jƒd6ƒ|j|ji|jjd6|jd6ƒdS(NRR(texecutetsql_remove_geometry_metadataR"RRRtsql_drop_spatial_index(R R$R%((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pytremove_geometry_metadata;s   cCsDtt|ƒj|ƒx|jD]}|j|ƒq Wg|_dS(N(RRt create_modelR R'(R R$tsql((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pyR+IscKsÃddlm}x6|jjD](}t||ƒr|j||ƒqqWxZ|jD]O}y5|j|ji|d6|j |jj ƒd6ƒWqSt k r¡qSXqSWt t |ƒj||dS(Niÿÿÿÿ(Rt geom_tableR(RRRt local_fieldsRR*tgeometry_tablesR'tsql_discard_geometry_columnsR"RRRRt delete_model(R R$R RR%R-((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pyR1Ps  cCsyddlm}t||ƒr\|j||ƒx|jD]}|j|ƒq9Wg|_ntt|ƒj||ƒdS(Niÿÿÿÿ(R( RRRRR R'RRt add_field(R R$R%RR,((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pyR2cs cCsUddlm}t||ƒr8|j|d|gƒntt|ƒj||ƒdS(Niÿÿÿÿ(Rt delete_fields(RRRt _remake_tableRRt remove_field(R R$R%R((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pyR5nscCsòddlm}x]|jjD]O}t||ƒr|j|ji|j|ƒd6|j|jƒd6ƒqqWt t |ƒj |||ƒxd|j D]Y}y?|j|j i|d6|j|ƒd6|j|ƒd6ƒWq–tk rîq–Xq–Wxø|jjD]ê}t||ƒr‡|j|ji|j|ƒd6|j|jƒd6|jd6|j|jƒd 6|jd 6t|j ƒd 6ƒnt|d tƒr|j|ji|jd ||jfƒd6|jd ||jfƒd6ƒqqWdS(Niÿÿÿÿ(RRRR-t old_tablet new_tableRRRRR s idx_%s_%s(RRRR.RR'R(R"RRRtalter_db_tableR/tsql_update_geometry_columnsRRRRRRRRtgetattrtFalsetsql_rename_table(R R$t old_db_tablet new_db_tableRR%R-((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pyR8zs<     (t__name__t __module__RR!R)R(R0R9R/RRR;RR*R+R1R2R5R8(((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pyRs&        N(t!django.db.backends.sqlite3.schemaRtdjango.db.utilsRR(((s~/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/contrib/gis/db/backends/spatialite/schema.pyts