OracleSpatialDBDefinition.java

  1. /*
  2.  * Copyright 2015 gregorygraham.
  3.  *
  4.  * Licensed under the Apache License, Version 2.0 (the "License");
  5.  * you may not use this file except in compliance with the License.
  6.  * You may obtain a copy of the License at
  7.  *
  8.  *      http://www.apache.org/licenses/LICENSE-2.0
  9.  *
  10.  * Unless required by applicable law or agreed to in writing, software
  11.  * distributed under the License is distributed on an "AS IS" BASIS,
  12.  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  13.  * See the License for the specific language governing permissions and
  14.  * limitations under the License.
  15.  */
  16. package nz.co.gregs.dbvolution.databases.definitions;

  18. import com.vividsolutions.jts.geom.Coordinate;
  19. import com.vividsolutions.jts.geom.LineSegment;
  20. import com.vividsolutions.jts.geom.LineString;
  21. import com.vividsolutions.jts.geom.MultiPoint;
  22. import com.vividsolutions.jts.geom.Point;
  23. import com.vividsolutions.jts.geom.Polygon;
  24. import java.util.ArrayList;
  25. import java.util.List;
  26. import nz.co.gregs.dbvolution.databases.DBDatabase;
  27. import nz.co.gregs.dbvolution.datatypes.QueryableDatatype;
  28. import nz.co.gregs.dbvolution.datatypes.spatial2D.DBLine2D;
  29. import nz.co.gregs.dbvolution.datatypes.spatial2D.DBLineSegment2D;
  30. import nz.co.gregs.dbvolution.datatypes.spatial2D.DBMultiPoint2D;
  31. import nz.co.gregs.dbvolution.datatypes.spatial2D.DBPoint2D;
  32. import nz.co.gregs.dbvolution.datatypes.spatial2D.DBPolygon2D;
  33. import nz.co.gregs.dbvolution.internal.oracle.xe.Line2DFunctions;
  34. import nz.co.gregs.dbvolution.results.Spatial2DResult;
  35. import nz.co.gregs.separatedstring.SeparatedString;
  36. import nz.co.gregs.separatedstring.SeparatedStringBuilder;

  38. /**
  39.  * A subclass of OracleDB that contains definitions of standard Spatial
  40.  * functions shared by Oracle databases with Spatial functions.
  41.  *
  42.  * <p style="color: #F90;">Support DBvolution at
  43.  * <a href="http://patreon.com/dbvolution" target=new>Patreon</a></p>
  44.  *
  45.  * @author gregorygraham
  46.  */
  47. public class OracleSpatialDBDefinition extends OracleDBDefinition {

  49.     public static final long serialVersionUID = 1L;

  51.     @Override
  52.     public String getDatabaseDataTypeOfQueryableDatatype(QueryableDatatype<?> qdt) {
  53.         if (qdt instanceof Spatial2DResult) {
  54.             return " SDO_GEOMETRY ";
  55. //      } else if (qdt instanceof DBLine2D) {
  56. //          return " SDO_GEOMETRY ";
  57. //      } else if (qdt instanceof DBLineSegment2D) {
  58. //          return " SDO_GEOMETRY ";
  59. //      } else if (qdt instanceof DBPolygon2D) {
  60. //          return " SDO_GEOMETRY ";
  61.         } else {
  62.             return super.getDatabaseDataTypeOfQueryableDatatype(qdt);
  63.         }
  64.     }

  66.     @Override
  67.     public String doColumnTransformForSelect(QueryableDatatype<?> qdt, String selectableName) {
  68.         if (qdt instanceof DBPolygon2D) {
  69.             return doPolygon2DAsTextTransform(selectableName);
  70.         } else if (qdt instanceof DBLine2D) {
  71.             return doLine2DAsTextTransform(selectableName);
  72.         } else if (qdt instanceof DBPoint2D) {
  73.             return doPoint2DAsTextTransform(selectableName);
  74.         } else if (qdt instanceof DBLineSegment2D) {
  75.             return doLineSegment2DAsTextTransform(selectableName);
  76.         } else if (qdt instanceof DBMultiPoint2D) {
  77.             return doMultiPoint2DAsTextTransform(selectableName);
  78.         } else {
  79.             return super.doColumnTransformForSelect(qdt, selectableName);
  80.         }
  81.     }

  83.     @Override
  84.     public boolean requiresSpatial2DIndexes() {
  85.         return true;
  86.     }

  88.     @Override
  89.     public List<String> getSpatial2DIndexSQL(DBDatabase aThis, final String formatTableName, final String formatColumnName) {
  90.         return new ArrayList<String>() {
  91.             public static final long serialVersionUID = 1;

  93.             {
  94.                 //add("DROP INDEX " + formatNameForDatabase("DBV_" + formatTableName + "_" + formatColumnName + "_sp2didx")+"");
  95.                 add("delete from USER_SDO_GEOM_METADATA "
  96.                         + "where table_name = '" + formatTableName.toUpperCase() + "' "
  97.                         + "and column_name = '" + formatColumnName.toUpperCase() + "'");
  98.                 add(
  99.                         "INSERT INTO USER_SDO_GEOM_METADATA \n"
  100.                         + "  select \n"
  101.                         + "  '" + formatTableName + "',\n"
  102.                         + "  '" + formatColumnName + "',\n"
  103.                         + "  MDSYS.SDO_DIM_ARRAY(\n"
  104.                         + "    MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  105.                         + "    MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  106.                         + "     ),\n"
  107.                         + "  NULL   -- SRID\n"
  108.                         + " from dual where not exists ("
  109.                         + "select * from USER_SDO_GEOM_METADATA  "
  110.                         + "where table_name = '" + formatTableName.toUpperCase() + "' "
  111.                         + "and column_name = '" + formatColumnName.toUpperCase() + "')");
  112.                 add("CREATE INDEX " + formatNameForDatabase("DBV_" + formatTableName + "_" + formatColumnName + "_sp2didx") + " ON " + formatTableName + " (" + formatColumnName + ") INDEXTYPE IS MDSYS.SPATIAL_INDEX");
  113.             }
  114.         };
  115.     }

  117.     @Override
  118.     public String transformPoint2DIntoDatabaseFormat(Point point) {
  119.         final Coordinate coordinate = point.getCoordinate();
  120.         return transformCoordinatesIntoDatabasePoint2DFormat("" + coordinate.x, "" + coordinate.y);
  121.     }

  123.     @Override
  124.     public String transformCoordinatesIntoDatabasePoint2DFormat(String xValue, String yValue) {
  125.         return "SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(" + xValue + ", " + yValue + ",NULL), NULL, NULL)";
  126. //      return "SDO_UTIL.FROM_WKTGEOMETRY('"+point.toText()+"')";
  127.     }

  129.     @Override
  130.     public String transformLineStringIntoDatabaseLine2DFormat(LineString point) {
  131. //      final Coordinate coordinate = point.getCoordinate();
  132. //      return "SDO_GEOMETRY(2002, NULL, SDO_POINT_TYPE(" + coordinate.x + ", " + coordinate.y + ",NULL), NULL, NULL)";
  133.         return "SDO_UTIL.FROM_WKTGEOMETRY('" + point.toText() + "')";
  134.     }

  136. //  @Override
  137. //  public String OldtransformPolygonIntoDatabasePolygon2DFormat(Polygon point) {
  138. ////        final Coordinate coordinate = point.getCoordinate();
  139. ////        return "SDO_GEOMETRY(2003, NULL, SDO_POINT_TYPE(" + coordinate.x + ", " + coordinate.y + ",NULL), NULL, NULL)";
  140. //      return "SDO_UTIL.FROM_WKTGEOMETRY('" + point.toText() + "')";
  141. //  }
  142.     @Override
  143.     public String transformMultiPoint2DToDatabaseMultiPoint2DValue(MultiPoint point) {
  144. //      final Coordinate coordinate = point.getCoordinate();
  145. //      return "SDO_GEOMETRY(2005, NULL, SDO_POINT_TYPE(" + coordinate.x + ", " + coordinate.y + ",NULL), NULL, NULL)";
  146.         return "SDO_UTIL.FROM_WKTGEOMETRY('" + point.toText() + "')";
  147.     }

  149.     @Override
  150.     public String transformLineSegmentIntoDatabaseLineSegment2DFormat(LineSegment lineSegment) {
  151. //      final Coordinate coordinate = point.p0;
  152. //      final Coordinate otherCoord = point.p1;

  154.         //MDSYS.SDO_GEOMETRY(2002, NULL, NULL,
  155.         //MDSYS.SDO_ELEM_INFO_ARRAY(1,4,2, 1,2,1, 9,2,2),
  156.         //MDSYS.SDO_ORDINATE_ARRAY(15,10, 25,10, 30,5, 38,5, 38,10, 35,15, 25,20))
  157.         return "MDSYS.SDO_GEOMETRY(2002, NULL, NULL,"
  158.                 + "MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1),"
  159.                 + "MDSYS.SDO_ORDINATE_ARRAY(" + lineSegment.p0.x + ", " + lineSegment.p0.y + ", " + lineSegment.p1.x + ", " + lineSegment.p1.y + ")"
  160.                 + ")";
  161.     }

  163.     @Override
  164.     public String doPoint2DDistanceBetweenTransform(String polygon2DSQL, String otherPolygon2DSQL) {
  165.         return "SDO_GEOM.SDO_DISTANCE(" + polygon2DSQL + ", " + otherPolygon2DSQL + ", 0.000001)"; //To change body of generated methods, choose Tools | Templates.
  166.     }

  168.     @Override
  169.     public String transformPoint2DArrayToDatabasePolygon2DFormat(List<String> pointSQL) {
  170.         SeparatedString sepStr;
  171.         sepStr = SeparatedStringBuilder
  172.                 .byCommas()
  173.                 .withPrefix("MDSYS.SDO_GEOMETRY(2003, NULL, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,2003,1),MDSYS.SDO_ORDINATE_ARRAY(")
  174.                 .withSuffix("))")
  175.                 .withClosedLoop()
  176.                 .addAll(
  177.                         (t)->{return doPoint2DGetXTransform(t) + ", " + doPoint2DGetYTransform(t);}, 
  178.                         pointSQL
  179.                 );
  180.         return sepStr.toString();
  181.     }

  183.     @Override
  184.     public String transformCoordinateArrayToDatabasePolygon2DFormat(List<String> pointSQL) {
  185.         StringBuilder ordinateArray = new StringBuilder("MDSYS.SDO_ORDINATE_ARRAY(");
  186.         final String ordinateSep = ", ";
  187.         String pairSep = "";
  188.         String sep = pairSep;
  189.         for (String pointish : pointSQL) {
  190.             ordinateArray
  191.                     .append(sep)
  192.                     .append(pointish);
  193.             pairSep = ", ";
  194.             if (sep.equals(ordinateSep)) {
  195.                 sep = pairSep;
  196.             } else {
  197.                 sep = ordinateSep;
  198.             }
  199.         }
  200.         //+ lineSegment.p0.x + ", " + lineSegment.p0.y + ", " + lineSegment.p1.x + ", " + lineSegment.p1.y 
  201.         ordinateArray.append(")");
  202.         return "MDSYS.SDO_GEOMETRY(2003, NULL, NULL,"
  203.                 + "MDSYS.SDO_ELEM_INFO_ARRAY(1,2003,1),"
  204.                 + ordinateArray
  205.                 + ")";
  206.     }

  208.     @Override
  209.     public String doPoint2DAsTextTransform(String point2DSQL) {
  210.         return "TO_CHAR(SDO_UTIL.TO_WKTGEOMETRY(" + point2DSQL + "))";
  211.     }

  213.     @Override
  214.     public String doPoint2DGetBoundingBoxTransform(String point2DSQL) {
  215.         return "SDO_GEOM.SDO_MBR(" + point2DSQL + ")";
  216.     }

  218.     @Override
  219.     public String doPoint2DMeasurableDimensionsTransform(String point2DSQL) {
  220.         return "0";
  221.         //return "(" + point2DSQL + ").GET_DIMS()"; get_dims() will return 2 as in 2D, whereas we require 0
  222.     }

  224.     @Override
  225.     public String doPoint2DGetYTransform(String point2DSQL) {
  226.         return "(" + point2DSQL + ").SDO_POINT.Y";
  227.     }

  229.     @Override
  230.     public String doPoint2DGetXTransform(String point2DSQL) {
  231.         return "(" + point2DSQL + ").SDO_POINT.X";
  232.     }

  234.     @Override
  235.     public String doPoint2DEqualsTransform(String firstPoint, String secondPoint) {
  236.         return "SDO_GEOM.RELATE(" + firstPoint + ", 'equal', " + secondPoint + ", 0.0000005)='EQUAL'";
  237.     }

  239.     @Override
  240.     public String doLineSegment2DIntersectsLineSegment2DTransform(String firstSQL, String secondSQL) {
  241.         return "SDO_GEOM.RELATE(" + firstSQL + ", 'ANYINTERACT', " + secondSQL + ", 0.0000005)='TRUE'";
  242.     }

  244.     @Override
  245.     public String doLineSegment2DGetMaxXTransform(String lineSegment) {
  246.         return "SDO_GEOM.SDO_MAX_MBR_ORDINATE(" + lineSegment + ", MDSYS.SDO_DIM_ARRAY(\n"
  247.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  248.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  249.                 + "                     ), 1)";
  250.     }

  252.     @Override
  253.     public String doLineSegment2DGetMinXTransform(String lineSegment) {
  254.         return "SDO_GEOM.SDO_MIN_MBR_ORDINATE(" + lineSegment + ", MDSYS.SDO_DIM_ARRAY(\n"
  255.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  256.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  257.                 + "                     ), 1)";
  258.     }

  260.     @Override
  261.     public String doLineSegment2DGetMaxYTransform(String lineSegment) {
  262.         return "SDO_GEOM.SDO_MAX_MBR_ORDINATE(" + lineSegment + ", MDSYS.SDO_DIM_ARRAY(\n"
  263.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  264.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  265.                 + "                     ), 2)";
  266.     }

  268.     @Override
  269.     public String doLineSegment2DGetMinYTransform(String lineSegment) {
  270.         return "SDO_GEOM.SDO_MIN_MBR_ORDINATE(" + lineSegment + ", MDSYS.SDO_DIM_ARRAY(\n"
  271.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  272.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  273.                 + "                     ), 2)";
  274.     }

  276.     @Override
  277.     public String doLineSegment2DGetBoundingBoxTransform(String lineSegment) {
  278.         return "SDO_GEOM.SDO_MBR(" + lineSegment + ")";
  279.     }

  281.     @Override
  282.     public String doLineSegment2DDimensionTransform(String lineSegment) {
  283.         throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
  284.     }

  286.     @Override
  287.     public String doLineSegment2DNotEqualsTransform(String firstLineSegment, String secondLineSegment) {
  288.         return "SDO_GEOM.RELATE(" + firstLineSegment + ", 'equal', " + secondLineSegment + ", 0.0000005)='FALSE'";
  289.     }

  291.     @Override
  292.     public String doLineSegment2DEqualsTransform(String firstLineSegment, String secondLineSegment) {
  293.         return "SDO_GEOM.RELATE(" + firstLineSegment + ", 'equal', " + secondLineSegment + ", 0.0000005)='EQUAL'";
  294.     }

  296.     @Override
  297.     public String doLineSegment2DAsTextTransform(String lineSegment) {
  298.         return "TO_CHAR(SDO_UTIL.TO_WKTGEOMETRY(" + lineSegment + "))";
  299.     }

  301.     @Override
  302.     public String doLineSegment2DIntersectionPointWithLineSegment2DTransform(String firstLineSegment, String secondLineSegment) {
  303.         return "SDO_GEOM.SDO_INTERSECTION(" + firstLineSegment + ", " + secondLineSegment + ", 0.0000005)";
  304.     }

  306.     @Override
  307.     public String doMultiPoint2DEqualsTransform(String first, String second) {
  308.         return "SDO_GEOM.RELATE(" + first + ", 'equal', " + second + ", 0.0000005)='EQUAL'";
  309.     }

  311.     @Override
  312.     public String doMultiPoint2DNotEqualsTransform(String first, String second) {
  313.         return "SDO_GEOM.RELATE(" + first + ", 'equal', " + second + ", 0.0000005)='FALSE'";
  314.     }

  316.     @Override
  317.     public String doMultiPoint2DGetPointAtIndexTransform(String first, String index) {
  318.         return "(" + first + ").SDO_ORDINATES(" + index + ")";
  319.     }

  321.     @Override
  322.     public String doMultiPoint2DGetNumberOfPointsTransform(String multiPoint2D) {
  323.         return "(" + multiPoint2D + ").SDO_ORDINATES.count";
  324.     }

  326.     @Override
  327.     public String doMultiPoint2DMeasurableDimensionsTransform(String multipoint2D) {
  328.         throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
  329.     }

  331.     @Override
  332.     public String doMultiPoint2DGetBoundingBoxTransform(String multiPoint2D) {
  333.         return "SDO_GEOM.SDO_MBR(" + multiPoint2D + ")";
  334.     }

  336.     @Override
  337.     public String doMultiPoint2DAsTextTransform(String multiPoint2D) {
  338.         return "TO_CHAR(SDO_UTIL.TO_WKTGEOMETRY(" + multiPoint2D + "))";
  339.     }

  341.     @Override
  342.     public String doMultiPoint2DToLine2DTransform(String multiPoint2D) {
  343.         throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
  344.     }

  346.     @Override
  347.     public String doMultiPoint2DGetMinYTransform(String multiPoint2D) {
  348.         return "SDO_GEOM.SDO_MIN_MBR_ORDINATE(" + multiPoint2D + ", MDSYS.SDO_DIM_ARRAY(\n"
  349.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  350.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  351.                 + "                     ), 2)";
  352.     }

  354.     @Override
  355.     public String doMultiPoint2DGetMinXTransform(String multiPoint2D) {
  356.         return "SDO_GEOM.SDO_MIN_MBR_ORDINATE(" + multiPoint2D + ", MDSYS.SDO_DIM_ARRAY(\n"
  357.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  358.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  359.                 + "                     ), 1)";
  360.     }

  362.     @Override
  363.     public String doMultiPoint2DGetMaxYTransform(String multiPoint2D) {
  364.         return "SDO_GEOM.SDO_MAX_MBR_ORDINATE(" + multiPoint2D + ", MDSYS.SDO_DIM_ARRAY(\n"
  365.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  366.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  367.                 + "                     ), 2)";
  368.     }

  370.     @Override
  371.     public String doMultiPoint2DGetMaxXTransform(String multiPoint2D) {
  372.         return "SDO_GEOM.SDO_MAX_MBR_ORDINATE(" + multiPoint2D + ", MDSYS.SDO_DIM_ARRAY(\n"
  373.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  374.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  375.                 + "                     ), 1)";
  376.     }

  378.     @Override
  379.     public String doLine2DGetMagnitudeTransform(String line2DSQL) {
  380.         return super.doLine2DGetMagnitudeTransform(line2DSQL); //To change body of generated methods, choose Tools | Templates.
  381.     }

  383.     @Override
  384.     public String doLine2DHasMagnitudeTransform(String line2DSQL) {
  385.         return super.doLine2DHasMagnitudeTransform(line2DSQL); //To change body of generated methods, choose Tools | Templates.
  386.     }

  388.     @Override
  389.     public String doLine2DSpatialDimensionsTransform(String line2DSQL) {
  390.         return "(" + line2DSQL + ").GET_DIMS()";
  391.     }

  393.     @Override
  394.     public String doLine2DAllIntersectionPointsWithLine2DTransform(String firstGeometry, String secondGeometry) {
  395.         return "SDO_GEOM.SDO_INTERSECTION(" + firstGeometry + ", " + secondGeometry + ", 0.0000005)";
  396.     }

  398.     @Override
  399.     public String doLine2DIntersectionPointWithLine2DTransform(String firstLine, String secondLine) {
  400.         return Line2DFunctions.GETPOINTFROMORDARRAY.toString()+"(SDO_GEOM.SDO_INTERSECTION(" + firstLine + ", " + secondLine + ", 0.0000005))";
  401.     }

  403.     @Override
  404.     public String doLine2DIntersectsLine2DTransform(String firstLine, String secondLine) {
  405.         return "SDO_GEOM.RELATE(" + firstLine + ", 'ANYINTERACT', " + secondLine + ", 0.0000005)='TRUE'";
  406.     }

  408.     @Override
  409.     public String doLine2DGetMinYTransform(String line2DSQL) {
  410.         return "SDO_GEOM.SDO_MIN_MBR_ORDINATE(" + line2DSQL + ", MDSYS.SDO_DIM_ARRAY(\n"
  411.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  412.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  413.                 + "                     ), 2)";
  414.     }

  416.     @Override
  417.     public String doLine2DGetMaxYTransform(String line2DSQL) {
  418.         return "SDO_GEOM.SDO_MAX_MBR_ORDINATE(" + line2DSQL + ", MDSYS.SDO_DIM_ARRAY(\n"
  419.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  420.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  421.                 + "                     ), 2)";
  422.     }

  424.     @Override
  425.     public String doLine2DGetMinXTransform(String line2DSQL) {
  426.         return "SDO_GEOM.SDO_MIN_MBR_ORDINATE(" + line2DSQL + ", MDSYS.SDO_DIM_ARRAY(\n"
  427.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  428.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  429.                 + "                     ), 1)";
  430.     }

  432.     @Override
  433.     public String doLine2DGetMaxXTransform(String line2DSQL) {
  434.         return "SDO_GEOM.SDO_MAX_MBR_ORDINATE(" + line2DSQL + ", MDSYS.SDO_DIM_ARRAY(\n"
  435.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  436.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  437.                 + "                     ), 1)";
  438.     }

  440.     @Override
  441.     public String doLine2DGetBoundingBoxTransform(String line2DSQL) {
  442.         return "SDO_GEOM.SDO_MBR(" + line2DSQL + ")";
  443.     }

  445.     @Override
  446.     public String doLine2DMeasurableDimensionsTransform(String line2DSQL) {
  447.         return super.doLine2DMeasurableDimensionsTransform(line2DSQL); //To change body of generated methods, choose Tools | Templates.
  448.     }

  450.     @Override
  451.     public String doLine2DNotEqualsTransform(String line2DSQL, String otherLine2DSQL) {
  452.         return "SDO_GEOM.RELATE(" + line2DSQL + ", 'equal', " + otherLine2DSQL + ", 0.0000005)='FALSE'";
  453.     }

  455.     @Override
  456.     public String doLine2DEqualsTransform(String line2DSQL, String otherLine2DSQL) {
  457.         return "SDO_GEOM.RELATE(" + line2DSQL + ", 'equal', " + otherLine2DSQL + ", 0.0000005)='EQUAL'";
  458.     }

  460.     @Override
  461.     public String doLine2DAsTextTransform(String line2DSQL) {
  462.         return "TO_CHAR(SDO_UTIL.TO_WKTGEOMETRY(" + line2DSQL + "))";
  463.     }

  465.     @Override
  466.     public String doPolygon2DGetMagnitudeTransform(String polygon2DSQL) {
  467.         return super.doPolygon2DGetMagnitudeTransform(polygon2DSQL); //To change body of generated methods, choose Tools | Templates.
  468.     }

  470.     @Override
  471.     public String doPolygon2DSpatialDimensionsTransform(String polygon2DSQL) {
  472.         return "(" + polygon2DSQL + ").GET_DIMS()";
  473.     }

  475.     @Override
  476.     public String doPolygon2DAsTextTransform(String polygonSQL) {
  477.         return "TO_CHAR(SDO_UTIL.TO_WKTGEOMETRY(" + polygonSQL + "))";
  478.     }

  480.     @Override
  481.     public String doPolygon2DContainsPoint2DTransform(String polygon2DSQL, String point2DSQL) {
  482.         return "SDO_GEOM.RELATE(" + polygon2DSQL + ", 'CONTAINS', " + point2DSQL + ", 0.0000005)='CONTAINS'";
  483.     }

  485.     @Override
  486.     public String transformPolygonIntoDatabasePolygon2DFormat(Polygon polygon2D) {
  487.         return "SDO_UTIL.FROM_WKTGEOMETRY(" + polygon2D.toText() + ")";
  488.     }

  490.     @Override
  491.     public String doPolygon2DGetMinYTransform(String polygon2DSQL) {
  492.         return "SDO_GEOM.SDO_MIN_MBR_ORDINATE(" + polygon2DSQL + ", MDSYS.SDO_DIM_ARRAY(\n"
  493.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  494.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  495.                 + "                     ), 2)";
  496.     }

  498.     @Override
  499.     public String doPolygon2DGetMaxYTransform(String polygon2DSQL) {
  500.         return "SDO_GEOM.SDO_MAX_MBR_ORDINATE(" + polygon2DSQL + ", MDSYS.SDO_DIM_ARRAY(\n"
  501.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  502.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  503.                 + "                     ), 2)";
  504.     }

  506.     @Override
  507.     public String doPolygon2DGetMinXTransform(String polygon2DSQL) {
  508.         return "SDO_GEOM.SDO_MIN_MBR_ORDINATE(" + polygon2DSQL + ", MDSYS.SDO_DIM_ARRAY(\n"
  509.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  510.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  511.                 + "                     ), 1)";
  512.     }

  514.     @Override
  515.     public String doPolygon2DGetMaxXTransform(String polygon2DSQL) {
  516.         return "SDO_GEOM.SDO_MAX_MBR_ORDINATE(" + polygon2DSQL + ", MDSYS.SDO_DIM_ARRAY(\n"
  517.                 + "                     MDSYS.SDO_DIM_ELEMENT('X', -9999999999, 9999999999, 0.0000000001),\n"
  518.                 + "                            MDSYS.SDO_DIM_ELEMENT('Y', -9999999999, 9999999999, 0.0000000001)\n"
  519.                 + "                     ), 1)";
  520.     }

  522.     @Override
  523.     public String doPolygon2DGetExteriorRingTransform(String polygon2DSQL) {
  524.         return "SDO_UTIL.POLYGONTOLINE(" + polygon2DSQL + ")";
  525.     }

  527.     @Override
  528.     public String doPolygon2DGetAreaTransform(String polygon2DSQL) {
  529.         return "ABS(SDO_GEOM.SDO_AREA(" + polygon2DSQL + ", 0.0000005))";
  530.     }

  532.     @Override
  533.     public String doPolygon2DGetBoundingBoxTransform(String polygon2DSQL) {
  534.         return "SDO_GEOM.SDO_MBR(" + polygon2DSQL + ")";
  535.     }

  537.     @Override
  538.     public String doPolygon2DMeasurableDimensionsTransform(String toSQLString) {
  539.         return "2";
  540.     }

  542.     @Override
  543.     public String doPolygon2DWithinTransform(String firstGeometry, String secondGeometry) {
  544.         return "SDO_GEOM.RELATE(" + firstGeometry + ", 'COVEREDBY+INSIDE', " + secondGeometry + ", 0.0000005)<>'FALSE'";
  545.     }

  547.     @Override
  548.     public String doPolygon2DTouchesTransform(String firstGeometry, String secondGeometry) {
  549.         return "SDO_GEOM.RELATE(" + firstGeometry + ", 'TOUCH', " + secondGeometry + ", 0.0000005)='TOUCH'";
  550.     }

  552.     @Override
  553.     public String doPolygon2DOverlapsTransform(String firstGeometry, String secondGeometry) {
  554.         return "SDO_GEOM.RELATE(" + firstGeometry + ", 'OVERLAPBDYINTERSECT', " + secondGeometry + ", 0.0000005)='OVERLAPBDYINTERSECT'";
  555.     }

  557.     @Override
  558.     public String doPolygon2DDoesNotIntersectTransform(String firstGeometry, String secondGeometry) {
  559.         return "SDO_GEOM.RELATE(" + firstGeometry + ", 'DISJOINT', " + secondGeometry + ", 0.0000005)='DISJOINT'";
  560.     }

  562.     @Override
  563.     public String doPolygon2DContainsPolygon2DTransform(String firstGeometry, String secondGeometry) {
  564.         return "SDO_GEOM.RELATE(" + firstGeometry + ", 'COVERS+CONTAINS', " + secondGeometry + ", 0.0000005)<>'FALSE'";
  565.     }

  567.     @Override
  568.     public String doPolygon2DIntersectsTransform(String firstGeometry, String secondGeometry) {
  569.         return "SDO_GEOM.RELATE(" + firstGeometry + ", 'ANYINTERACT', " + secondGeometry + ", 0.0000005)='TRUE'";
  570.     }

  572.     @Override
  573.     public String doPolygon2DIntersectionTransform(String firstGeometry, String secondGeometry) {
  574.         return "SDO_GEOM.SDO_INTERSECTION(" + firstGeometry + ", " + secondGeometry + ", 0.0000005)";
  575.     }

  577.     @Override
  578.     public String doPolygon2DEqualsTransform(String firstGeometry, String secondGeometry) {
  579.         return "SDO_GEOM.RELATE(" + firstGeometry + ", 'EQUAL', " + secondGeometry + ", 0.0000005)='EQUAL'";
  580.     }

  582. }
Created with JaCoCo 0.8.2.201808211720