X)@s3dZddlZddlmZddlmZddlmZddlm Z ddl m Z ddl m Z dd lmZdd lmZdd lmZd ZGd ddeZGdddeZGdddeZGdddeZGdddeZGdddeeZdS)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)Geometry)Distance)Database)DatabaseOperations)sixz0.05c@seZdZdZdS) SDOOperatorz#%(func)s(%(lhs)s, %(rhs)s) = 'TRUE'N)__name__ __module__ __qualname__ sql_templaterr^/home/ubuntu/projects/ifolica/build/django/django/contrib/gis/db/backends/oracle/operations.pyr s r c@seZdZdeZdS) SDODistancez@SDO_GEOM.SDO_DISTANCE(%%(lhs)s, %%(rhs)s, %s) %%(op)s %%(value)sN)r r rDEFAULT_TOLERANCErrrrrrs rc@seZdZdZdS) SDODWithinz3SDO_WITHIN_DISTANCE(%(lhs)s, %(rhs)s, %%s) = 'TRUE'N)r r rrrrrrr"s rc@seZdZdeZdS) SDODisjointz@SDO_GEOM.RELATE(%%(lhs)s, 'DISJOINT', %%(rhs)s, %s) = 'DISJOINT'N)r r rrrrrrrr&s rcs4eZdZdZddZfddZS) SDORelatez6SDO_RELATE(%(lhs)s, %(rhs)s, 'mask=%(mask)s') = 'TRUE'cCs_d}tjd||ftj}t|tj sH|j| r[td|ndS)NzbTOUCH|OVERLAPBDYDISJOINT|OVERLAPBDYINTERSECT|EQUAL|INSIDE|COVEREDBY|CONTAINS|COVERS|ANYINTERACT|ONz^(%s)(\+(%s))*$zInvalid SDO_RELATE mask: "%s")recompileI isinstancer string_typesmatch ValueError)selfargZmasksZ mask_regexrrrcheck_relate_argument-s#zSDORelate.check_relate_argumentcs/|j|d6e"d8d?d@6e#dA6Z$idBd36Z%dCdDdEdFdGdHdIdJdKdLdMdNdOdPhZ&fdQdRZ'fdSdTZ(dUdVZ)dWdXZ*dYdZZ+d[d\Z,d]d^Z-d_d`Z.dadbZ/dcddZ0dedfZ1fdgdhZ2S)iOracleOperationsoracleTzSDO_GEOM.SDO_AREAzSDO_UTIL.TO_GMLGEOMETRYzSDO_GEOM.SDO_CENTROIDzSDO_GEOM.SDO_DIFFERENCEzSDO_GEOM.SDO_DISTANCEZ SDO_AGGR_MBRzSDO_GEOM.SDO_INTERSECTIONzSDO_GEOM.SDO_LENGTHzSDO_UTIL.GETNUMVERTICESzSDO_GEOM.SDO_POINTONSURFACEzSDO_UTIL.REVERSE_LINESTRINGzSDO_GEOM.SDO_XORzSDO_CS.TRANSFORMzSDO_GEOM.SDO_UNIONZSDO_AGGR_UNIONZ SDO_GEOMETRYZAreaZCentroidZ DifferencerZ IntersectionZLengthzSDO_UTIL.GETNUMELEMZ NumGeometriesZ NumPointsZ PerimeterZPointOnSurfaceZReverseZ SymDifferenceZ TransformUnionzSDO_UTIL.TO_WKTGEOMETRY(%s)funcZ SDO_CONTAINScontainsZ SDO_COVEREDBYZ coveredbyZ SDO_COVERSZcoversZdisjointZSDO_OVERLAPBDYINTERSECTZ intersectsZ SDO_EQUALequalsexactZ SDO_OVERLAPSZoverlapsZsame_asZrelateZ SDO_TOUCHZtouchesZ SDO_INSIDEZwithinop>Z distance_gtz>=Z distance_gter?) r#r(get_db_convertersZ output_fieldZget_internal_typeappendZconvert_textfield_valuehasattrconvert_geometry)r expressionZ convertersZ internal_typeZgeometry_fields)r'rrrAs z"OracleOperations.get_db_converterscCs5|r1t|}d|kr1|d|_q1n|S)NZtransformed_srid)rsrid)rvaluerEr%contextrrrrDs   z!OracleOperations.convert_geometryc Cs|rt|j|}t|j}|dkrk|j}|ddd|ddd}}n8|dkr|jdd}|}ntd||\}} |\} } || | | fSdSdS)NZPolygonrZPointz0Unexpected geometry type returned for extent: %s)rreadstrr@shellZcoords Exception) rZclobrFZext_geomZgtyperLZllurZxminZyminZxmaxZymaxrrrconvert_extents  ,    zOracleOperations.convert_extentcCs?|r7t|tjr'|j}nt||jSdSdS)N)rrZLOBrJrrF)rrGZ geo_fieldrrr convert_geoms zOracleOperations.convert_geomcCsdS)z Returns 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)rfrrr geo_db_typeszOracleOperations.geo_db_typecKs|s gS|d}t|trh|j|jrA|j}qnt|tj|j|j}n|}|dkrd|}n|gS)a Returns 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. rr2z distance=%s)rrZgeodeticr%mgetattrZ unit_attnameZ units_name)rrQrGZ lookup_typekwargsZ dist_paramrrr get_distances  '  zOracleOperations.get_distancecCs|dkrdSdd}t|dry|||jrVd|j|jf}nd}|j|\}}||S|||jrd|j|j|jfSd |jSdS) z Provides a proper substitution value for Geometries that are not in the SRID of the field. Specifically, this routine will substitute in the SDO_CS.TRANSFORM() function call. NNULLcSs |j|kS)N)rF)valrFrrrtransform_valuesz>OracleOperations.get_geom_placeholder..transform_valuer$z %s(%%s, %s)z%sz%s(SDO_GEOMETRY(%%s, %s), %s)zSDO_GEOMETRY(%%s, %s))rCrF transformr)rrQrGcompilerrY placeholderZsql_rrrget_geom_placeholders  z%OracleOperations.get_geom_placeholdercCs1|jdkrdn |j}t||S)z9 Returns the spatial aggregate SQL name. unionunionagg)lowerrT)rZagg_namerrrspatial_aggregate_names$z'OracleOperations.spatial_aggregate_namecCsddlm}|S)Nr)OracleGeometryColumns),django.contrib.gis.db.backends.oracle.modelsrc)rrcrrrgeometry_columnssz!OracleOperations.geometry_columnscCsddlm}|S)Nr)OracleSpatialRefSys)rdrf)rrfrrrspatial_ref_syssz OracleOperations.spatial_ref_syscs)|dkrgStt|j||S)zrDrop out insert parameters for NULL placeholder. Needed for Oracle Spatial backend due to #10888. rW)r#r(modify_insert_params)rr\params)r'rrrh s z%OracleOperations.modify_insert_params)3r r rr5r)rZCollectZExtent3DZMakeLineZdisallowed_aggregatesrZAdapterareaZgmlZcentroid differenceZdistanceZextent intersectionlengthZ num_pointsZ perimeterZpoint_on_surfacereverseZsym_differencerZr_r`Z from_textZfunction_namesselectr rrrrZ gis_operatorsZtruncate_paramsZunsupported_functionsr3rArDrOrPrRrVr^rbrergrhrr)r'rr(8s                 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.geometry.backendrZdjango.contrib.gis.measurerZdjango.db.backends.oracle.baserZ$django.db.backends.oracle.operationsr Z django.utilsr rr rrrrr(rrrr s"