a [f>"@sdZddlZddlmZddlmZddlmZddlm Z ddl m Z m Z ddl mZdd lmZdd lmZd ZGd d d e ZGddde ZGddde ZGddde ZGdddeeZdS)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)models)BaseSpatialOperations)OracleSpatialAdapter)SpatialOperator) GEOSGeometryGEOSGeometryBase)wkb_r)Distance)DatabaseOperationsz0.05c@seZdZdZdS) SDOOperatorz#%(func)s(%(lhs)s, %(rhs)s) = 'TRUE'N__name__ __module__ __qualname__ sql_templaterrC:\Users\91910\OneDrive\Desktop\vts_admin_rebuild-master\vts\Lib\site-packages\django/contrib/gis/db/backends/oracle/operations.pyr sr c@seZdZdZdS) SDODWithinz3SDO_WITHIN_DISTANCE(%(lhs)s, %(rhs)s, %%s) = 'TRUE'Nr rrrrrsrc@seZdZdeZdS) SDODisjointz@SDO_GEOM.RELATE(%%(lhs)s, 'DISJOINT', %%(rhs)s, %s) = 'DISJOINT'N)r rrDEFAULT_TOLERANCErrrrrr srcs(eZdZdZddZfddZZS) SDORelatez6SDO_RELATE(%(lhs)s, %(rhs)s, 'mask=%(mask)s') = 'TRUE'cCs>d}td||ftj}t|tr.||s:td|dS)NzbTOUCH|OVERLAPBDYDISJOINT|OVERLAPBDYINTERSECT|EQUAL|INSIDE|COVEREDBY|CONTAINS|COVERS|ANYINTERACT|ONz^(%s)(\+(%s))*$zInvalid SDO_RELATE mask: "%s")recompileI isinstancestrmatch ValueError)selfargmasksZ mask_regexrrrcheck_relate_argument*s zSDORelate.check_relate_argumentcs&|d|d<t||||ddS)Nmask)superas_sql)r connectionlookupZtemplate_paramsZ sql_params __class__rrr%3s zSDORelate.as_sql)r rrrr!r% __classcell__rrr(rr's rcs<eZdZdZdZejejejfZ e Z dZ dZ dZdddd d d d d dddddddddddddddZdZeddedded deed!ded"ded"ded#ded"deed$ded%ded& Zhd'Zfd(d)Zd*d+Zd,d-Zd.d/Zfd0d1Zd2d3Zd4d5Zd6d7Zfd8d9Zd:d;Z dOracleOperationsoracleTZ SDO_AGGR_MBRZSDO_AGGR_UNIONZ SDO_GEOMETRYzSDO_GEOM.SDO_AREAzSDO_UTIL.TO_GEOJSONzSDO_UTIL.TO_WKBGEOMETRYzSDO_UTIL.TO_WKTGEOMETRYzSDO_GEOM.SDO_MBCzSDO_GEOM.SDO_CENTROIDzSDO_GEOM.SDO_DIFFERENCEzSDO_GEOM.SDO_DISTANCEZ SDO_GEOM_MBRzSDO_UTIL.FROM_WKBGEOMETRYzSDO_UTIL.FROM_WKTGEOMETRYzSDO_GEOM.SDO_INTERSECTIONz'SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXTzSDO_GEOM.SDO_LENGTHzSDO_UTIL.GETNUMELEMzSDO_UTIL.GETNUMVERTICESzSDO_GEOM.SDO_POINTONSURFACEzSDO_UTIL.REVERSE_LINESTRINGzSDO_GEOM.SDO_XORzSDO_CS.TRANSFORMzSDO_GEOM.SDO_UNION)ZAreaZ AsGeoJSONZAsWKBZAsWKTZBoundingCircleZCentroidZ Differencer ZEnvelopeZFromWKBZFromWKTZ IntersectionZIsValidZLengthZ NumGeometriesZ NumPointsZ PerimeterZPointOnSurfaceZReverseZ SymDifferenceZ TransformUnionzSDO_UTIL.TO_WKBGEOMETRY(%s)Z SDO_CONTAINS)funcZ SDO_COVEREDBYZ SDO_COVERSZSDO_OVERLAPBDYINTERSECTZ SDO_EQUALZ SDO_OVERLAPSZ SDO_TOUCHZ SDO_INSIDE) containsZ coveredbyZcoversZdisjointZ intersectsequalsexactoverlapsZsame_asZrelateZtouchesZwithindwithin> ZGeoHashZScaleZ SnapToGridZIsEmptyZGeometryDistanceZAsSVGZMemSizeZLineLocatePointZForcePolygonCWZAzimuthZ TranslateZ MakeValidZAsKMLcst|SN)r$geo_quote_nameupper)rnamer(rrr5szOracleOperations.geo_quote_namec Cs|rtt|}t|j}|dkrP|j}|ddd|ddd}}n(|dkrl|jdd}|}n td||\}}|\} } ||| | fSdSdS)NZPolygonrZPointz0Unexpected geometry type returned for extent: %s)r memoryviewreadrZ geom_typeshellZcoords Exception) rZclobZext_geomgtyper;llurZxminZyminZxmaxZymaxrrrconvert_extents  $ 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)rfrrr geo_db_typeszOracleOperations.geo_db_typecCsb|sgS|d}t|trH||jr.|j}qLt|t||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. rr3z distance=%s)rr Zgeodeticr&mgetattrZ unit_attnameZ units_name)rrAvalueZ lookup_typeZ dist_paramrrr get_distances  zOracleOperations.get_distancecs|dur dSt|||S)NNULL)r$get_geom_placeholder)rrArEcompilerr(rrrHsz%OracleOperations.get_geom_placeholdercCs"|dkrdn|}t||S)z8 Return the spatial aggregate SQL name. unionunionagg)lowerrD)rZagg_namerrrspatial_aggregate_namesz'OracleOperations.spatial_aggregate_namecCsddlm}|S)Nr)OracleGeometryColumns),django.contrib.gis.db.backends.oracle.modelsrN)rrNrrrgeometry_columnss z!OracleOperations.geometry_columnscCsddlm}|S)Nr)OracleSpatialRefSys)rOrQ)rrQrrrspatial_ref_syss z OracleOperations.spatial_ref_syscs|dkr gSt||S)zrDrop out insert parameters for NULL placeholder. Needed for Oracle Spatial backend due to #10888. rG)r$modify_insert_params)r placeholderparamsr(rrrSsz%OracleOperations.modify_insert_paramscs8tj|jjdkrd|jjfdd}|S)Nr"cs0|dur,tt|}r(|_|SdSr4)rr9r:srid)rE expressionr&Zgeom geom_classr:rVrr converters z:OracleOperations.get_geometry_converter..converter)rr:Z output_fieldrVrY)rrWrZrrXrget_geometry_convertersz'OracleOperations.get_geometry_convertercCsdS)NZsq_mr)rfieldrrrget_area_att_for_fieldsz'OracleOperations.get_area_att_for_field)#r rrr7r,rZCollectZExtent3DZMakeLineZdisallowed_aggregatesrZAdapterZextentrKZ from_textZfunction_namesselectr rrrZ gis_operatorsZunsupported_functionsr5r@rBrFrHrMrPrRrSr[r]r*rrr(rr+8sv   r+)__doc__rZdjango.contrib.gis.dbrZ.django.contrib.gis.db.backends.base.operationsrZ-django.contrib.gis.db.backends.oracle.adapterrZ$django.contrib.gis.db.backends.utilsrZ django.contrib.gis.geos.geometryrrZ%django.contrib.gis.geos.prototypes.iorZdjango.contrib.gis.measurer Z$django.db.backends.oracle.operationsr rr rrrr+rrrrs