Package com.inductiveautomation.rm.base

Class RMSQLUtils

  • public class RMSQLUtils
extends java.lang.Object
    Utility methods for ResultSet.

    • Constructor Summary

      Constructors 
      Constructor Description
      RMSQLUtils()  

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static java.util.List<java.util.Map> getMaps​(java.sql.ResultSet aResultSet, int aLimit)
      Returns a list of maps for a given ResultSet.
      static java.util.Map getMapsDeep​(java.util.Map aMap, int aDepth)
      Returns map where any ResultSets have been converted to Lists.

      • Methods inherited from class java.lang.Object

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

    • Constructor Detail

      • RMSQLUtils

        public RMSQLUtils()

    • Method Detail

      • getMaps

        public static java.util.List<java.util.Map> getMaps​(java.sql.ResultSet aResultSet,
                                                    int aLimit)
        Returns a list of maps for a given ResultSet.
        Parameters:
        aResultSet - the result set to be converted to a list of maps.
        aLimit - the fetch limit for the list of maps. Use -1, 0 or Integer.MAX_VALUE for unlimited.

      • getMapsDeep

        public static java.util.Map getMapsDeep​(java.util.Map aMap,
                                        int aDepth)
        Returns map where any ResultSets have been converted to Lists. Copies the original Map if ResultSets exist.
        Parameters:
        aMap - the map to be stripped of result sets.
        aDepth - the depth to traverse any nested maps or lists (suggested value: 2).