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

 1"""
 2 The GeometryColumns and SpatialRefSys models for the Oracle spatial
 3 backend.
 4
 5 It should be noted that Oracle Spatial does not have database tables
 6 named according to the OGC standard, so the closest analogs are used.
 7 For example, the `USER_SDO_GEOM_METADATA` is used for the GeometryColumns
 8 model and the `SDO_COORD_REF_SYS` is used for the SpatialRefSys model.
 9"""
10from django.contrib.gis.db import models
11from django.contrib.gis.db.models.fields import GeometryField
12from django.contrib.gis.db.backends.base import SpatialRefSysMixin
13
14class GeometryColumns(models.Model):
15    "Maps to the Oracle USER_SDO_GEOM_METADATA table."
16    table_name = models.CharField(max_length=32)
17    column_name = models.CharField(max_length=1024)
18    srid = models.IntegerField(primary_key=True)
19    # TODO: Add support for `diminfo` column (type MDSYS.SDO_DIM_ARRAY).
20    class Meta:
21        db_table = 'USER_SDO_GEOM_METADATA'
22        managed = False
23
24    @classmethod
25    def table_name_col(cls):
26        """
27        Returns the name of the metadata column used to store the
28        the feature table name.
29        """
30        return 'table_name'
31
32    @classmethod
33    def geom_col_name(cls):
34        """
35        Returns the name of the metadata column used to store the
36        the feature geometry column.
37        """
38        return 'column_name'
39
40    def __unicode__(self):
41        return '%s - %s (SRID: %s)' % (self.table_name, self.column_name, self.srid)
42
43class SpatialRefSys(models.Model, SpatialRefSysMixin):
44    "Maps to the Oracle MDSYS.CS_SRS table."
45    cs_name = models.CharField(max_length=68)
46    srid = models.IntegerField(primary_key=True)
47    auth_srid = models.IntegerField()
48    auth_name = models.CharField(max_length=256)
49    wktext = models.CharField(max_length=2046)
50    # Optional geometry representing the bounds of this coordinate
51    # system.  By default, all are NULL in the table.
52    cs_bounds = models.PolygonField(null=True)
53    objects = models.GeoManager()
54
55    class Meta:
56        db_table = 'CS_SRS'
57        managed = False
58
59    @property
60    def wkt(self):
61        return self.wktext
62
63    @classmethod
64    def wkt_col(cls):
65        return 'wktext'