vÅÏ^ ã@sdZddlZddlmZddlmZddlmZddlm Z ddl m Z m Z ddl mZdd lmZdd lmZd ZGd d „d eƒZGdd„deƒZGdd„deƒZGdd„deƒZGdd„deeƒZdS)aU This module contains the spatial lookup types, and the `get_geo_where_clause` routine for Oracle Spatial. Please note that WKT support is broken on the XE version, and thus this backend will not work on such platforms. Specifically, XE lacks support for an internal JVM, and Java libraries are required to use the WKT constructors. éN)ÚBaseSpatialOperations)ÚOracleSpatialAdapter)ÚSpatialOperator)Ú aggregates)Ú GEOSGeometryÚGEOSGeometryBase)Úwkb_r)ÚDistance)ÚDatabaseOperationsz0.05c@seZdZdZdS)Ú SDOOperatorz#%(func)s(%(lhs)s, %(rhs)s) = 'TRUE'N)Ú__name__Ú __module__Ú __qualname__Ú sql_template©rrúR/tmp/pip-build-8lau8j11/django/django/contrib/gis/db/backends/oracle/operations.pyr s r c@seZdZdZdS)Ú SDODWithinz3SDO_WITHIN_DISTANCE(%(lhs)s, %(rhs)s, %%s) = 'TRUE'N)r r rrrrrrrs rc@seZdZdeZdS)Ú SDODisjointz@SDO_GEOM.RELATE(%%(lhs)s, 'DISJOINT', %%(rhs)s, %s) = 'DISJOINT'N)r r rÚDEFAULT_TOLERANCErrrrrr"s rcs4eZdZdZdd„Z‡fdd†Z‡S)Ú SDORelatez6SDO_RELATE(%(lhs)s, %(rhs)s, 'mask=%(mask)s') = 'TRUE'cCsYd}tjd||ftjƒ}t|tƒ sE|j|ƒ rUtd|ƒ‚dS)NzbTOUCH|OVERLAPBDYDISJOINT|OVERLAPBDYINTERSECT|EQUAL|INSIDE|COVEREDBY|CONTAINS|COVERS|ANYINTERACT|ONz^(%s)(\+(%s))*$zInvalid SDO_RELATE mask: "%s")ÚreÚcompileÚIÚ isinstanceÚstrÚmatchÚ ValueError)ÚselfÚargÚmasksZ mask_regexrrrÚcheck_relate_argument)s zSDORelate.check_relate_argumentcs)|jƒ|dd?d@dAdBdCdDdEdFdGdHdIdJh Z‡fdKdL†ZdMdN„ZdOdP„ZdQdR„Z‡fdSdT†ZdUdV„ZdWdX„ZdYdZ„Z‡fd[d\†Zd]d^„Z d_d`„Z!‡S)aÚOracleOperationsÚoracleTZ SDO_AGGR_MBRZSDO_AGGR_UNIONZ SDO_GEOMETRYZAreazSDO_GEOM.SDO_AREAZBoundingCirclezSDO_GEOM.SDO_MBCZCentroidzSDO_GEOM.SDO_CENTROIDZ DifferencezSDO_GEOM.SDO_DIFFERENCEr zSDO_GEOM.SDO_DISTANCEZEnvelopeZ SDO_GEOM_MBRZ IntersectionzSDO_GEOM.SDO_INTERSECTIONZIsValidz'SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXTZLengthzSDO_GEOM.SDO_LENGTHZ NumGeometrieszSDO_UTIL.GETNUMELEMZ NumPointszSDO_UTIL.GETNUMVERTICESZ PerimeterZPointOnSurfacezSDO_GEOM.SDO_POINTONSURFACEZReversezSDO_UTIL.REVERSE_LINESTRINGZ SymDifferencezSDO_GEOM.SDO_XORZ TransformzSDO_CS.TRANSFORMÚUnionzSDO_GEOM.SDO_UNIONzSDO_UTIL.TO_WKBGEOMETRY(%s)ÚcontainsÚfuncZ SDO_CONTAINSZ coveredbyZ SDO_COVEREDBYZcoversZ SDO_COVERSZdisjointZ intersectsZSDO_OVERLAPBDYINTERSECTÚequalsZ SDO_EQUALÚexactÚoverlapsZ SDO_OVERLAPSZsame_asZrelateZtouchesZ SDO_TOUCHZwithinZ SDO_INSIDEÚdwithinZ AsGeoJSONZAsKMLZAsSVGZAzimuthZForcePolygonCWZGeoHashZGeometryDistanceZLineLocatePointZ MakeValidZMemSizeZScaleZ SnapToGridZ Translatecstƒj|ƒjƒS)N)r#Úgeo_quote_nameÚupper)rÚname)r'rrr1rszOracleOperations.geo_quote_namec CsÖ|rÎtt|jƒƒƒ}t|jƒ}|dkrn|j}|ddd…|ddd…}}n8|dkr–|jdd…}|}ntd|ƒ‚|\}}|\} } ||| | fSdSdS)NZPolygonréZPointz0Unexpected geometry type returned for extent: %s)rÚ memoryviewÚreadrZ geom_typeÚshellZcoordsÚ Exception) rZclobZext_geomZgtyper7ZllÚurZxminZyminZxmaxZymaxrrrÚconvert_extentus  ,    zOracleOperations.convert_extentcCsdS)z¹ Return the geometry database type for Oracle. Unlike other spatial backends, no stored procedure is necessary and it's the same for all geometry types. zMDSYS.SDO_GEOMETRYr)rÚfrrrÚ geo_db_type‹szOracleOperations.geo_db_typecCs‹|s gS|d}t|tƒrh|j|jƒrA|j}qnt|tj|j|jƒƒƒ}n|}|dkr„d|}|gS)a Return the distance parameters given the value and the lookup type. On Oracle, geometry columns with a geodetic coordinate system behave implicitly like a geography column, and thus meters will be used as the distance parameter on them. rr0z distance=%s)rr Zgeodeticr%ÚmÚgetattrZ unit_attnameZ units_name)rr;ÚvalueZ lookup_typeZ dist_paramrrrÚ get_distance“s  '  zOracleOperations.get_distancecs&|dkrdStƒj|||ƒS)NÚNULL)r#Úget_geom_placeholder)rr;r?Úcompiler)r'rrrB¬s z%OracleOperations.get_geom_placeholdercCs1|jƒdkrdn |jƒ}t||ƒS)z8 Return the spatial aggregate SQL name. ÚunionÚunionagg)Úlowerr>)rZagg_namerrrÚspatial_aggregate_name±s$z'OracleOperations.spatial_aggregate_namecCsddlm}|S)Nr)ÚOracleGeometryColumns)Ú,django.contrib.gis.db.backends.oracle.modelsrH)rrHrrrÚgeometry_columns¹sz!OracleOperations.geometry_columnscCsddlm}|S)Nr)ÚOracleSpatialRefSys)rIrK)rrKrrrÚspatial_ref_sys½sz OracleOperations.spatial_ref_syscs#|dkrgStƒj||ƒS)zrDrop out insert parameters for NULL placeholder. Needed for Oracle Spatial backend due to #10888. rA)r#Úmodify_insert_params)rÚ placeholderÚparams)r'rrrMÁs z%OracleOperations.modify_insert_paramscsRtƒj‰|jj‰ˆdkr*d‰|jj‰‡‡‡fdd†}|S)NécsD|dk r@tˆt|jƒƒƒˆƒ}ˆr<ˆ|_|SdS)N)rr5r6Úsrid)r?Ú expressionr%Zgeom)Ú geom_classr6rQrrÚ converterÐs  ! z:OracleOperations.get_geometry_converter..converteréÿÿÿÿ)rr6Z output_fieldrQrS)rrRrTr)rSr6rQrÚget_geometry_converterÉs    z'OracleOperations.get_geometry_convertercCsdS)NZsq_mr)rÚfieldrrrÚget_area_att_for_fieldØsz'OracleOperations.get_area_att_for_field)"r r rr3r)rZCollectZExtent3DZMakeLineZdisallowed_aggregatesrZAdapterZextentrEZ from_textZfunction_namesÚselectr rrrZ gis_operatorsZunsupported_functionsr1r:r<r@rBrGrJrLrMrVrXrr)r'rr(4sh            r()Ú__doc__rZ.django.contrib.gis.db.backends.base.operationsrZ-django.contrib.gis.db.backends.oracle.adapterrZ$django.contrib.gis.db.backends.utilsrZdjango.contrib.gis.db.modelsrZ django.contrib.gis.geos.geometryrrZ%django.contrib.gis.geos.prototypes.iorZdjango.contrib.gis.measurer Z$django.db.backends.oracle.operationsr rr rrrr(rrrrÚ s