Package com.isomorphic.sql

# Class SQLTransform

java.lang.Object
com.isomorphic.sql.SQLTransform

public class SQLTransform extends Object
`SQLTransform` provides helper methods for converting java.sql.ResultSet objects to desired return data structures. See the DataSource Operations section of the client reference docs for a mapping of operationType to expected data structure.

- ## Method Summary

  Modifier and Type
  Method
  Description
  `static List`
  `toListOfMaps(ResultSet rs)`
  Converts all rows of a `ResultSet` object to return a `List` of `Map` objects.
  `static List`
  `toListOfMaps(ResultSet rs, long numRows)`
  Converts a `ResultSet` object to return a `List` of `Map` objects for the number of rows given by `numRows`.

- ## Method Details

  - ### toListOfMaps

    public static List toListOfMaps(ResultSet rs) throws Exception
    Converts all rows of a `ResultSet` object to return a `List` of `Map` objects.

    Parameters:
      `rs` - object to be converted
    Returns:
      list containing the result as a map of name-value pairs
    Throws:
      `SQLException` - propagates any errors encountered in connecting to the data source
      `Exception`

  - ### toListOfMaps

    public static List toListOfMaps(ResultSet rs, long numRows) throws Exception
    Converts a `ResultSet` object to return a `List` of `Map` objects for the number of rows given by `numRows`. This expanded signature is primarily useful if you're responding to a paged request.
    Parameters:
      `rs` - object to be converted
      `numRows` - the number of rows to convert
    Returns:
      list containing the result as a `java.util.Map` of name-value pairs
    Throws:
      `SQLException` - propagates any errors encountered in connecting to the data source
      `Exception`