Package: org.apache.groovy.sql.extensions

## [Java] Class SqlExtensions

- org.apache.groovy.sql.extensions.SqlExtensions

- This class defines all the new SQL-related groovy methods which enhance the normal JDK SQL classes when inside the Groovy environment. Static methods are used with the first parameter the destination class.

- - ### Methods Summary

    Methods
    Type Params | Return Type | Name and description
    --- | --- | ---
    `` | `static boolean` | `asBoolean(GroovyResultSet grs)` Coerce a GroovyResultSet to a boolean value.
    `` | `static Iterator<ResultSetMetaDataWrapper>` | `iterator(ResultSetMetaData resultSetMetaData)` Return an Iterator given a ResultSetMetaData.
    `` | `static GroovyRowResult` | `toRowResult(ResultSet rs)` Returns a GroovyRowResult given a ResultSet.
    `` | `static Timestamp` | `toTimestamp(Date d)` Return a java.sql.Timestamp given a java.util.Date.

  - ### Inherited Methods Summary

    Inherited Methods
    Methods inherited from class | Name
    --- | ---
    `class Object` | `wait, wait, wait, equals, toString, hashCode, getClass, notify, notifyAll`

- - ### Method Detail

    - #### public static boolean asBoolean(GroovyResultSet grs)

      Coerce a GroovyResultSet to a boolean value. A GroovyResultSet is coerced to false if there are no more rows to iterate over, and to true otherwise.

      Parameters:
        `grs` - the GroovyResultSet
      Returns:
        the boolean value
      Since:
        1.7.0

    - #### public static Iterator<ResultSetMetaDataWrapper> iterator(ResultSetMetaData resultSetMetaData)

      Return an Iterator given a ResultSetMetaData. Enables Groovy collection method syntactic sugar on ResultSetMetaData.

      Parameters:
        `resultSetMetaData` - the ResultSetMetaData to iterate over
      Returns:
        an iterator for the ResultSetMetaData
      Since:
        1.7

    - #### public static GroovyRowResult toRowResult(ResultSet rs)

      Returns a GroovyRowResult given a ResultSet.

      throws:
        java.sql.SQLException if a database error occurs
      Parameters:
        `rs` - a ResultSet
      Returns:
        the resulting GroovyRowResult
      Since:
        1.6.0

    - #### public static Timestamp toTimestamp(Date d)

      Return a java.sql.Timestamp given a java.util.Date.

      Parameters:
        `d` - a date
      Returns:
        the date wrapped as a Timestamp
      Since:
        1.6.6