Package oracle.spatial.network.nfe.util

Class WSUtil

  • public class WSUtil
extends java.lang.Object
    Provides static methods related to the workspace management.

    • Field Summary

      Fields 
      Modifier and Type Field Description
      static java.lang.String PARENT_ATTR
      Hierarchy parent attribute name.
      static java.lang.String SHAPE_ATTR
      Shape attribute name.

    • Constructor Summary

      Constructors 
      Constructor Description
      WSUtil()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static void checkConstraintsConsistencies​(java.sql.Connection conn, java.lang.String childWorkspace, java.lang.String parentWorkspace, NFENetworkMetadata nfeNetworkMetadata, NFEEditionMode nfeEditionMode)
      Inserts the nodes that were deleted in the parent workspace and child workspace.
      static void disableVersioning​(java.sql.Connection conn, java.lang.String table, boolean force, boolean ignoreLastError, boolean isTopology)
      Disables versioning with SQL procedure dbms_wm.DisableVersioning.
      static void enableVersioning​(java.sql.Connection conn, java.lang.String dataName, java.lang.String historyMode, boolean isTopology, java.lang.String undoSpace)
      Enables versioning with SQL procedure dbms_wm.EnableVersioning.
      static java.util.List<java.lang.Long> getModifiedLinks​(java.sql.Connection conn, java.lang.String childWorkspace, java.lang.String parentWorkspace, java.lang.String linkTable, NFEEditionMode nfeEditionMode)
      Returns the links that are different in child workspace and parent workspace.
      static NFEConflictsDescriptor getWorkspaceConflicts​(java.sql.Connection conn, java.lang.String childWorkspace, java.lang.String parentWorkspace, NFEModel nfeModel)
      Returns the workspace's conflicts.
      static void gotoWorkspace​(java.sql.Connection conn, java.lang.String workspaceName)
      Goes to a Workspace given (workspaceName) in the DB connection given (conn).
      static void mergeWorkspace​(java.sql.Connection conn, java.lang.String workspace)
      Applies all workspace changes to its parent workspace,.
      static void refreshWorkspace​(java.sql.Connection conn, java.lang.String workspace)
      Applies to a workspace all changes made in its parent workspace.
      static void removeDanglingFeatureElements​(java.sql.Connection conn, java.lang.String workspace, NFEModel model)
      Deletes feature elements that are not referencing existing features.
      static void removeDanglingNetworkElements​(java.sql.Connection conn, java.lang.String workspace, NFENetworkMetadata nfeNetworkMetadata, NFEEditionMode nfeEditionMode)
      Deletes the network elements that are not referenced by any feature in any feature layer.
      static void removeDanglingRulesElements​(java.sql.Connection conn, java.lang.String workspace, NFEModel model)
      Deletes rules elements that are not referencing existing features.
      static void resolveConflicts​(java.sql.Connection conn, java.util.List<FeatureAttributeDescriptor> featureAttributeDescriptorList, java.lang.String childWorkspace, java.lang.String parentWorkspace, java.lang.String choosenWorkspace, NFEModel nfeModel)
      Resolves the specified workspace conflicts.
      static void resolveWSConflicts​(java.sql.Connection conn, java.lang.String childWorkspace, java.lang.String table)
      Resolves the conflicts with child workspace changes using SQL procedure dbms_wm.ResolveConflicts.

      • Methods inherited from class java.lang.Object

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

    • Field Detail

      • SHAPE_ATTR

        public static final java.lang.String SHAPE_ATTR
        Shape attribute name.
        See Also:
        Constant Field Values

      • PARENT_ATTR

        public static final java.lang.String PARENT_ATTR
        Hierarchy parent attribute name.
        See Also:
        Constant Field Values

    • Constructor Detail

      • WSUtil

        public WSUtil()

    • Method Detail

      • gotoWorkspace

        public static void gotoWorkspace​(java.sql.Connection conn,
                                 java.lang.String workspaceName)
                          throws InvalidDBConnectionException
        Goes to a Workspace given (workspaceName) in the DB connection given (conn).
        Parameters:
        conn - connection
        workspaceName - workspace name
        Throws:
        InvalidDBConnectionException - if the connection is not valid.

      • refreshWorkspace

        public static void refreshWorkspace​(java.sql.Connection conn,
                                    java.lang.String workspace)
                             throws java.lang.Exception
        Applies to a workspace all changes made in its parent workspace.
        Parameters:
        conn - connection
        workspace - workspace
        Throws:
        java.lang.Exception - if an exception is thrown

      • mergeWorkspace

        public static void mergeWorkspace​(java.sql.Connection conn,
                                  java.lang.String workspace)
                           throws java.lang.Exception
        Applies all workspace changes to its parent workspace,.
        Parameters:
        conn - connection
        workspace - child workspace
        Throws:
        java.lang.Exception - if an exception is thrown

      • getWorkspaceConflicts

        public static NFEConflictsDescriptor getWorkspaceConflicts​(java.sql.Connection conn,
                                                           java.lang.String childWorkspace,
                                                           java.lang.String parentWorkspace,
                                                           NFEModel nfeModel)
                                                    throws java.lang.Exception
        Returns the workspace's conflicts.
        Parameters:
        conn - connection
        childWorkspace - child workspace
        parentWorkspace - parent workspace
        nfeModel - model
        Returns:
        conflict descriptor
        Throws:
        java.lang.Exception - if an exception is thrown

      • resolveConflicts

        public static void resolveConflicts​(java.sql.Connection conn,
                                    java.util.List<FeatureAttributeDescriptor> featureAttributeDescriptorList,
                                    java.lang.String childWorkspace,
                                    java.lang.String parentWorkspace,
                                    java.lang.String choosenWorkspace,
                                    NFEModel nfeModel)
                             throws java.lang.Exception
        Resolves the specified workspace conflicts.
        Parameters:
        conn - connection
        featureAttributeDescriptorList - attributes in conflict
        childWorkspace - child workspace
        parentWorkspace - parent workspace
        choosenWorkspace - chosen workspace
        nfeModel - model
        Throws:
        java.lang.Exception - if an exception is thrown

      • removeDanglingNetworkElements

        public static void removeDanglingNetworkElements​(java.sql.Connection conn,
                                                 java.lang.String workspace,
                                                 NFENetworkMetadata nfeNetworkMetadata,
                                                 NFEEditionMode nfeEditionMode)
                                          throws java.lang.Exception
        Deletes the network elements that are not referenced by any feature in any feature layer.
        Parameters:
        conn - connection
        workspace - workspace in which to remove the dangling network elements
        nfeNetworkMetadata - network metadata
        nfeEditionMode - model edition mode
        Throws:
        java.lang.Exception - if an exception is thrown

      • removeDanglingRulesElements

        public static void removeDanglingRulesElements​(java.sql.Connection conn,
                                               java.lang.String workspace,
                                               NFEModel model)
                                        throws java.lang.Exception
        Deletes rules elements that are not referencing existing features.
        Parameters:
        conn - connection
        workspace - workspace in which to remove the dangling rules elements
        model - model
        Throws:
        java.lang.Exception - if an exception is thrown

      • removeDanglingFeatureElements

        public static void removeDanglingFeatureElements​(java.sql.Connection conn,
                                                 java.lang.String workspace,
                                                 NFEModel model)
                                          throws java.lang.Exception
        Deletes feature elements that are not referencing existing features.
        Parameters:
        conn - connection
        workspace - workspace in which to remove the dangling feature elements
        model - model
        Throws:
        java.lang.Exception - if an exception is thrown

      • resolveWSConflicts

        public static void resolveWSConflicts​(java.sql.Connection conn,
                                      java.lang.String childWorkspace,
                                      java.lang.String table)
                               throws java.lang.Exception
        Resolves the conflicts with child workspace changes using SQL procedure dbms_wm.ResolveConflicts.
        Parameters:
        conn - connection
        childWorkspace - child workspace
        table - table in which the conflicts will be resolved
        keyList - The key of the map is the key column name and the value is the value of the key. If empty all the conflicts of the tables are resolved.
        Throws:
        java.lang.Exception - if an exception is thrown

      • checkConstraintsConsistencies

        public static void checkConstraintsConsistencies​(java.sql.Connection conn,
                                                 java.lang.String childWorkspace,
                                                 java.lang.String parentWorkspace,
                                                 NFENetworkMetadata nfeNetworkMetadata,
                                                 NFEEditionMode nfeEditionMode)
                                          throws java.lang.Exception
        Inserts the nodes that were deleted in the parent workspace and child workspace. It will avoid links pointing to non existing start or end nodes after to merge workspaces.
        Parameters:
        conn - connection
        childWorkspace - child workspace
        parentWorkspace - parent workspace
        nfeNetworkMetadata - network metadata
        nfeEditionMode - model edition mode
        Throws:
        java.lang.Exception - if an exception is thrown

      • getModifiedLinks

        public static java.util.List<java.lang.Long> getModifiedLinks​(java.sql.Connection conn,
                                                              java.lang.String childWorkspace,
                                                              java.lang.String parentWorkspace,
                                                              java.lang.String linkTable,
                                                              NFEEditionMode nfeEditionMode)
                                                       throws java.lang.Exception
        Returns the links that are different in child workspace and parent workspace. The links are in workspace manager table linkTable_diff.
        Parameters:
        conn - connection
        childWorkspace - child workspace
        parentWorkspace - parent workspace
        linkTable - link table
        nfeEditionMode - model edition mode
        Returns:
        identifiers of the links
        Throws:
        java.lang.Exception - if an exception is thrown

      • enableVersioning

        public static void enableVersioning​(java.sql.Connection conn,
                                    java.lang.String dataName,
                                    java.lang.String historyMode,
                                    boolean isTopology,
                                    java.lang.String undoSpace)
                             throws java.lang.Exception
        Enables versioning with SQL procedure dbms_wm.EnableVersioning. Table must have a primary key in order to be versioned.
        Parameters:
        conn - connection
        dataName - table name or topology name if it is a topology
        historyMode - to store modifications or not: NONE (default), VIEW_W_OVERWRITE, or VIEW_WO_OVERWRITE. If null, then default NONE is used.
        isTopology - if table belongs to topology (TRUE or FALSE).
        undoSpace - number representing the maximum number of bytes available for undo space. For example: "1048576" for 1 megabyte. If not defined, then means UNLIMITED undo space.
        Throws:
        java.lang.Exception - if an exception is thrown

      • disableVersioning

        public static void disableVersioning​(java.sql.Connection conn,
                                     java.lang.String table,
                                     boolean force,
                                     boolean ignoreLastError,
                                     boolean isTopology)
                              throws java.lang.Exception
        Disables versioning with SQL procedure dbms_wm.DisableVersioning.
        Parameters:
        conn - connection
        table - table name or topology name if it is topology
        force - true forces all data in workspaces other than LIVE to be discarded before versioning is disabled. False prevents versioning from being disabled if table_name was modified in any workspace other than LIVE and if the workspace that modified table_name still exists.
        ignoreLastError - true ignores the last error, if any, that occurred during the previous call to the DisableVersioning procedure. Information about the last error is stored in the USER_WM_VT_ERRORS and ALL_WM_VT_ERRORS static data dictionary views. False does not ignore the last error, if any, that occurred during the previous call to the DisableVersioning procedure.
        isTopology - if table belongs to topology (TRUE or FALSE)
        Throws:
        java.lang.Exception - if an exception is thrown