o "7ht@s<ddlmZddlmZddlmZmZGdddeZdS)) GeometryField)DatabaseSchemaEditor)ColFunccseZdZdZdZdZdZdZddZfdd Z d d fd d Z fddZ dfdd Z ddZ fddZddZZS)PostGISSchemaEditorGISTGIST_GEOMETRY_OPS_NDzST_ConvexHull(%(expressions)s)zLALTER COLUMN %(column)s TYPE %(type)s USING ST_Force3D(%(column)s)::%(type)szLALTER COLUMN %(column)s TYPE %(type)s USING ST_Force2D(%(column)s)::%(type)scCs|jj|SN) connectionopsgeo_quote_name)selfnamer/var/www/epreuve.sigeris.cm/public_html/epreuve/venv/lib/python3.10/site-packages/django/contrib/gis/db/backends/postgis/schema.pyr sz"PostGISSchemaEditor.geo_quote_namecst|ddrdSt||S)N spatial_indexFT)getattrsuper_field_should_be_indexedr modelfield __class__rrrs z,PostGISSchemaEditor._field_should_be_indexedN)fieldsc sR|dust|dkst|ddstj|fd|i|S|j||dfi|S)Nrgeodeticr)lenhasattrr_create_index_sql_create_spatial_index_sql)r rrkwargsrrrrs"z%PostGISSchemaEditor._create_index_sqlcst|dr t|dst||||||S|jdkr#|jdkr#|j}n|jdkr1|jdkr1|j}n|j}|||j|ddgfgfS)z6 Special case when dimension changed. dim)columntype collation) rr_alter_column_type_sqlr"sql_alter_column_to_3dsql_alter_column_to_2dsql_alter_column_type quote_namer&)r table old_field new_fieldnew_type old_collation new_collation sql_alterrrrr) s&   z*PostGISSchemaEditor._alter_column_type_sqlFc stj||||||||dt|to|j} t|to|j} | s-| r-||||dS| r<| s>||||dSdSdS)N)strict)r _alter_field isinstancerrexecuter _delete_spatial_index_sql) r rr/r0old_typer1 old_db_params new_db_paramsr5old_field_spatial_indexnew_field_spatial_indexrrrr6>s&  z PostGISSchemaEditor._alter_fieldcCs||jj|jgdS)N_id)_create_index_name_metadb_tabler&rrrr_create_spatial_index_name_sz.PostGISSchemaEditor._create_spatial_index_namec sd}d}|g}|jdkrttd||jd}d}n |jdkr%|js%|jg}|d}s2|||}t j |||d|j ||dS)NRASTER)templater#rz USING %s)rrusing opclasses expressions) geom_typerrrast_index_templater" geographygeom_index_ops_ndgetrCrrgeom_index_type)r rrr!rHrGrrrrrr bs$  z-PostGISSchemaEditor._create_spatial_index_sqlcCs|||}|||Sr )rC_delete_index_sql)r rr index_namerrrr9zs  z-PostGISSchemaEditor._delete_spatial_index_sql)F)__name__ __module__ __qualname__rNrLrJr*r+r rrr)r6rCr r9 __classcell__rrrrrs"  '! rN)django.contrib.gis.db.modelsr$django.db.backends.postgresql.schemardjango.db.models.expressionsrrrrrrrs