Class SqlExtensions

java.lang.Object
org.apache.groovy.sql.extensions.SqlExtensions

public class SqlExtensions
extends Object
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.
  • Constructor Details

    • SqlExtensions

      public SqlExtensions()
  • Method Details

    • toRowResult

      public static GroovyRowResult toRowResult​(ResultSet rs) throws SQLException
      Returns a GroovyRowResult given a ResultSet.
      Parameters:
      rs - a ResultSet
      Returns:
      the resulting GroovyRowResult
      Throws:
      SQLException - if a database error occurs
      Since:
      1.6.0
    • toTimestamp

      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
    • asBoolean

      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
    • iterator

      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