Package oracle.spatial.network.nfe.util

Class NFEUtil

  • public class NFEUtil
extends java.lang.Object
    Provides some utilities functions used by NFE.

    • Constructor Summary

      Constructors 
      Constructor Description
      NFEUtil()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static java.lang.String getCostExpression​(AnalysisCustomizedCost analysisCustomizedCost, NFEFeatureLayer featureLayer, NFEFeatureClass featureClass)
      Returns the customized expression (analysisCustomizedCost.getExpression) if the customized cost applies to the featureLayer and featureClass, null otherwise.
      static double getCustCostOfLink​(java.sql.Connection conn, NFEModel nfeModel, java.util.List<AnalysisCustomizedCost> analysisCustomizedCosts, java.lang.Long linkId, NFEExpressionAnalyzer nfeExpressionAnalyzer)
      Returns the link custom cost.
      static java.lang.String getErrorMessage​(java.lang.String exceptionMessage)
      Extracts the error message from an exception message.
      static byte[] getFileAsByteArray​(java.lang.String fileName)
      Returns the file in path oracle/spatial/network/nfe/images/imageName
      static java.lang.Object getResultSetColumnValue​(java.sql.ResultSet resultSet, java.lang.String columnName, NFEAttributeType expectedType)
      Returns the column value of the result set.
      static java.lang.String getSQLInStringWithLimit​(java.util.List<java.lang.Long> ids, java.lang.String columnToBeUsed, int limit)
      Creates a SQL string in format: columnToBeUsed IN (id[1], id[2],...id[limit]) OR IN (id[x], id[x+1],...id[x+limit])
      static java.lang.String getStringWithoutLastComma​(java.lang.String s)
      Gets a substring from the string start to the first comma.
      static boolean isEmpty​(java.lang.String propertyValue)
      Checks for nulls and empty strings.
      static java.lang.Object toAttributeType​(java.lang.String strValue, NFEAttributeDescriptor attrDesc)
      Returns the string value in the type of the specified attribute.

      • Methods inherited from class java.lang.Object

        clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

    • Constructor Detail

      • NFEUtil

        public NFEUtil()

    • Method Detail

      • isEmpty

        public static boolean isEmpty​(java.lang.String propertyValue)
        Checks for nulls and empty strings.
        Parameters:
        propertyValue - string to be evaluates
        Returns:
        true if propertyValue is null or empty, false otherwise

      • getStringWithoutLastComma

        public static java.lang.String getStringWithoutLastComma​(java.lang.String s)
        Gets a substring from the string start to the first comma.
        Parameters:
        s - string
        Returns:
        substring from the string start to the first comma

      • getResultSetColumnValue

        public static java.lang.Object getResultSetColumnValue​(java.sql.ResultSet resultSet,
                                                       java.lang.String columnName,
                                                       NFEAttributeType expectedType)
                                                throws java.sql.SQLException

        Skip navigation links

        Skip navigation links

        Returns the column value of the result set. The returned result will be on the type expectedType. The mapping is as follows: 
         NUMBER = resultSet.getDouble(columnName)
 INTEGER = resultSet.getLong(columnName)
 VARCHAR2 = resultSet.getString(columnName)
 DATE = resultSet.getDate(columnName)
 TIMESTAMP = resultSet.getTime(columnName)
 SDO_GEOMETRY = resultSet.getObject(columnName)
        Parameters:
        resultSet - result set
        columnName - column name
        expectedType - expected type
        Returns:
        column value
        Throws:
        java.sql.SQLException - if an SQL exception is thrown

      • toAttributeType

        public static java.lang.Object toAttributeType​(java.lang.String strValue,
                                               NFEAttributeDescriptor attrDesc)
        Returns the string value in the type of the specified attribute.
        Parameters:
        strValue - string
        attrDesc - attribute
        Returns:
        the string value in the type of the specified attribute

      • getSQLInStringWithLimit

        public static java.lang.String getSQLInStringWithLimit​(java.util.List<java.lang.Long> ids,
                                                       java.lang.String columnToBeUsed,
                                                       int limit)
        Creates a SQL string in format: columnToBeUsed IN (id[1], id[2],...id[limit]) OR IN (id[x], id[x+1],...id[x+limit])
        Parameters:
        ids - identifiers
        columnToBeUsed - column
        limit - limit
        Returns:
        SQL string

      • getErrorMessage

        public static java.lang.String getErrorMessage​(java.lang.String exceptionMessage)
        Extracts the error message from an exception message.
        Parameters:
        exceptionMessage - Message from an exception. Format expected: "ORA-[error-code]: [error-message] \n[posible-extra-information]"
        Returns:
        the [error-message] contained in the exception Message, or the original string if the exceptionMessage format is not as indicated.

      • getCustCostOfLink

        public static double getCustCostOfLink​(java.sql.Connection conn,
                                       NFEModel nfeModel,
                                       java.util.List<AnalysisCustomizedCost> analysisCustomizedCosts,
                                       java.lang.Long linkId,
                                       NFEExpressionAnalyzer nfeExpressionAnalyzer)
        Returns the link custom cost. This function can be used during the analysis.
        Parameters:
        conn - connection
        nfeModel - model
        analysisCustomizedCosts - customized cost data
        linkId - link identifier
        nfeExpressionAnalyzer - expression analyzer
        Returns:
        link custom cost

      • getCostExpression

        public static java.lang.String getCostExpression​(AnalysisCustomizedCost analysisCustomizedCost,
                                                 NFEFeatureLayer featureLayer,
                                                 NFEFeatureClass featureClass)
        Returns the customized expression (analysisCustomizedCost.getExpression) if the customized cost applies to the featureLayer and featureClass, null otherwise.
        Parameters:
        analysisCustomizedCost - customized cost data
        featureLayer - feature layer
        featureClass - feature class
        Returns:
        customized expression if the customized cost applies to the featureLayer and featureClass, null otherwise

      • getFileAsByteArray

        public static byte[] getFileAsByteArray​(java.lang.String fileName)
        Returns the file in path oracle/spatial/network/nfe/images/imageName
        Parameters:
        fileName - file name
        Returns:
        file in path oracle/spatial/network/nfe/images/imageName