"""

 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.db import models

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):

    "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)

    #cs_bounds = models.GeometryField() # TODO

    class Meta:

        abstract = True

        db_table = 'CS_SRS'

        managed = False

    @property

    def wkt(self):

        return self.wktext

    @classmethod

    def wkt_col(cls):

        return 'wktext'