com.inductiveautomation.rm.base

Class RMSQLUtils

java.lang.Object

com.inductiveautomation.rm.base.RMSQLUtils

public class RMSQLUtils
extends java.lang.Object

Utility methods for ResultSet.

Constructor Summary

Constructors

Constructor and Description
RMSQLUtils()

Method Summary

Modifier and Type	Method and 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).