Debian Codegraph @

django/contrib/gis/db/backends/oracle/schema.py

raw
1 from django.contrib.gis.db.models import GeometryField
2 from django.db.backends.oracle.schema import DatabaseSchemaEditor
3 from django.db.backends.utils import strip_quotes, truncate_name
4
5
6 class OracleGISSchemaEditor(DatabaseSchemaEditor):
7 sql_add_geometry_metadata = """
8 INSERT INTO USER_SDO_GEOM_METADATA
9 ("TABLE_NAME", "COLUMN_NAME", "DIMINFO", "SRID")
10 VALUES (
11 %(table)s,
12 %(column)s,
13 MDSYS.SDO_DIM_ARRAY(
14 MDSYS.SDO_DIM_ELEMENT('LONG', %(dim0)s, %(dim2)s, %(tolerance)s),
15 MDSYS.SDO_DIM_ELEMENT('LAT', %(dim1)s, %(dim3)s, %(tolerance)s)
16 ),
17 %(srid)s
18 )"""
19 sql_add_spatial_index = (
20 "CREATE INDEX %(index)s ON %(table)s(%(column)s) "
21 "INDEXTYPE IS MDSYS.SPATIAL_INDEX"
22 )
23 sql_clear_geometry_table_metadata = (
24 "DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = %(table)s"
25 )
26 sql_clear_geometry_field_metadata = (
27 "DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = %(table)s "
28 "AND COLUMN_NAME = %(column)s"
29 )
30
31 def __init__(self, *args, **kwargs):
32 super().__init__(*args, **kwargs)
33 self.geometry_sql = []
34
35 def geo_quote_name(self, name):
36 return self.connection.ops.geo_quote_name(name)
37
38 def quote_value(self, value):
39 if isinstance(value, self.connection.ops.Adapter):
40 return super().quote_value(str(value))
41 return super().quote_value(value)
42
43 def _field_indexes_sql(self, model, field):
44 if isinstance(field, GeometryField) and field.spatial_index:
45 return [self._create_spatial_index_sql(model, field)]
46 return super()._field_indexes_sql(model, field)
47
48 def column_sql(self, model, field, include_default=False):
49 column_sql = super().column_sql(model, field, include_default)
50 if isinstance(field, GeometryField):
51 self.geometry_sql.append(
52 self.sql_add_geometry_metadata
53 % {
54 "table": self.geo_quote_name(model._meta.db_table),
55 "column": self.geo_quote_name(field.column),
56 "dim0": field._extent[0],
57 "dim1": field._extent[1],
58 "dim2": field._extent[2],
59 "dim3": field._extent[3],
60 "tolerance": field._tolerance,
61 "srid": field.srid,
62 }
63 )
64 return column_sql
65
66 def create_model(self, model):
67 super().create_model(model)
68 self.run_geometry_sql()
69
70 def delete_model(self, model):
71 super().delete_model(model)
72 self.execute(
73 self.sql_clear_geometry_table_metadata
74 % {
75 "table": self.geo_quote_name(model._meta.db_table),
76 }
77 )
78
79 def add_field(self, model, field):
80 super().add_field(model, field)
81 self.run_geometry_sql()
82
83 def remove_field(self, model, field):
84 if isinstance(field, GeometryField):
85 self.execute(
86 self.sql_clear_geometry_field_metadata
87 % {
88 "table": self.geo_quote_name(model._meta.db_table),
89 "column": self.geo_quote_name(field.column),
90 }
91 )
92 if field.spatial_index:
93 self.execute(self._delete_spatial_index_sql(model, field))
94 super().remove_field(model, field)
95
96 def run_geometry_sql(self):
97 for sql in self.geometry_sql:
98 self.execute(sql)
99 self.geometry_sql = []
100
101 def _alter_field(
102 self,
103 model,
104 old_field,
105 new_field,
106 old_type,
107 new_type,
108 old_db_params,
109 new_db_params,
110 strict=False,
111 ):
112 super()._alter_field(
113 model,
114 old_field,
115 new_field,
116 old_type,
117 new_type,
118 old_db_params,
119 new_db_params,
120 strict=strict,
121 )
122
123 old_field_spatial_index = (
124 isinstance(old_field, GeometryField) and old_field.spatial_index
125 )
126 new_field_spatial_index = (
127 isinstance(new_field, GeometryField) and new_field.spatial_index
128 )
129 if not old_field_spatial_index and new_field_spatial_index:
130 self.execute(self._create_spatial_index_sql(model, new_field))
131 elif old_field_spatial_index and not new_field_spatial_index:
132 self.execute(self._delete_spatial_index_sql(model, old_field))
133
134 def _create_spatial_index_name(self, model, field):
135 # Oracle doesn't allow object names > 30 characters. Use this scheme
136 # instead of self._create_index_name() for backwards compatibility.
137 return truncate_name(
138 "%s_%s_id" % (strip_quotes(model._meta.db_table), field.column), 30
139 )
140
141 def _create_spatial_index_sql(self, model, field):
142 index_name = self._create_spatial_index_name(model, field)
143 return self.sql_add_spatial_index % {
144 "index": self.quote_name(index_name),
145 "table": self.quote_name(model._meta.db_table),
146 "column": self.quote_name(field.column),
147 }
148
149 def _delete_spatial_index_sql(self, model, field):
150 index_name = self._create_spatial_index_name(model, field)
151 return self._delete_index_sql(model, index_name)