com.isomorphic.sql

## Class SQLTransform

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

-     public class SQLTransform
      extends java.lang.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

    All Methods Static Methods Concrete Methods
    Modifier and Type | Method and Description
    --- | ---
    `static java.util.List` | `toListOfMaps(java.sql.ResultSet rs)` Converts all rows of a `ResultSet` object to return a `List` of `Map` objects.
    `static java.util.List` | `toListOfMaps(java.sql.ResultSet rs, long numRows)` Converts a `ResultSet` object to return a `List` of `Map` objects for the number of rows given by `numRows`.

- - ### Method Detail

    - #### toListOfMaps

          public static java.util.List toListOfMaps(java.sql.ResultSet rs)
                                             throws java.lang.Exception

      Converts all rows of a `ResultSet` object to return a `List` of `Map` objects.

      Parameters:
        `rs` - `ResultSet` object to be converted
      Returns:
        `java.util.List` containing the result as a `java.util.Map` of name-value pairs
      Throws:
        ``java.sql.SQLException`` - propagates any errors encountered in connecting to the data source
        `java.lang.Exception`

    - #### toListOfMaps

          public static java.util.List toListOfMaps(java.sql.ResultSet rs,
                                                    long numRows)
                                             throws java.lang.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` - `ResultSet` object to be converted
        `numRows` - the number of rows to convert
      Returns:
        `java.util.List` containing the result as a `java.util.Map` of name-value pairs
      Throws:
        ``java.sql.SQLException`` - propagates any errors encountered in connecting to the data source
        `java.lang.Exception`