summaryrefslogtreecommitdiff
path: root/django/contrib/gis/db/backends/oracle/models.py
diff options
context:
space:
mode:
Diffstat (limited to 'django/contrib/gis/db/backends/oracle/models.py')
-rw-r--r--django/contrib/gis/db/backends/oracle/models.py67
1 files changed, 67 insertions, 0 deletions
diff --git a/django/contrib/gis/db/backends/oracle/models.py b/django/contrib/gis/db/backends/oracle/models.py
new file mode 100644
index 0000000000..3bca5cdf3b
--- /dev/null
+++ b/django/contrib/gis/db/backends/oracle/models.py
@@ -0,0 +1,67 @@
+"""
+ The GeometryColumns and SpatialRefSys models for the Oracle spatial
+ backend.
+
+ It should be noted that Oracle Spatial does not have database tables
+ named according to the OGC standard, so the closest analogs are used.
+ For example, the `USER_SDO_GEOM_METADATA` is used for the GeometryColumns
+ model and the `SDO_COORD_REF_SYS` is used for the SpatialRefSys model.
+"""
+from django.contrib.gis.db import models
+from django.contrib.gis.db.models.fields import GeometryField
+from django.contrib.gis.db.backends.base import SpatialRefSysMixin
+
+class GeometryColumns(models.Model):
+ "Maps to the Oracle USER_SDO_GEOM_METADATA table."
+ table_name = models.CharField(max_length=32)
+ column_name = models.CharField(max_length=1024)
+ srid = models.IntegerField(primary_key=True)
+ # TODO: Add support for `diminfo` column (type MDSYS.SDO_DIM_ARRAY).
+ class Meta:
+ app_label = 'gis'
+ db_table = 'USER_SDO_GEOM_METADATA'
+ managed = False
+
+ @classmethod
+ def table_name_col(cls):
+ """
+ Returns the name of the metadata column used to store the
+ the feature table name.
+ """
+ return 'table_name'
+
+ @classmethod
+ def geom_col_name(cls):
+ """
+ Returns the name of the metadata column used to store the
+ the feature geometry column.
+ """
+ return 'column_name'
+
+ def __unicode__(self):
+ return '%s - %s (SRID: %s)' % (self.table_name, self.column_name, self.srid)
+
+class SpatialRefSys(models.Model, SpatialRefSysMixin):
+ "Maps to the Oracle MDSYS.CS_SRS table."
+ cs_name = models.CharField(max_length=68)
+ srid = models.IntegerField(primary_key=True)
+ auth_srid = models.IntegerField()
+ auth_name = models.CharField(max_length=256)
+ wktext = models.CharField(max_length=2046)
+ # Optional geometry representing the bounds of this coordinate
+ # system. By default, all are NULL in the table.
+ cs_bounds = models.PolygonField(null=True)
+ objects = models.GeoManager()
+
+ class Meta:
+ app_label = 'gis'
+ db_table = 'CS_SRS'
+ managed = False
+
+ @property
+ def wkt(self):
+ return self.wktext
+
+ @classmethod
+ def wkt_col(cls):
+ return 'wktext'