Package org.apache.groovy.sql.extensions
Class SqlExtensions
- java.lang.Object
-
- org.apache.groovy.sql.extensions.SqlExtensions
-
public class SqlExtensions extends java.lang.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 Summary
Constructors Constructor Description SqlExtensions()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static boolean
asBoolean(GroovyResultSet grs)
Coerce a GroovyResultSet to a boolean value.static java.util.Iterator<ResultSetMetaDataWrapper>
iterator(java.sql.ResultSetMetaData resultSetMetaData)
Return an Iterator given a ResultSetMetaData.static GroovyRowResult
toRowResult(java.sql.ResultSet rs)
Returns a GroovyRowResult given a ResultSet.static java.sql.Timestamp
toTimestamp(java.util.Date d)
Return a java.sql.Timestamp given a java.util.Date.
-
-
-
Method Detail
-
toRowResult
public static GroovyRowResult toRowResult(java.sql.ResultSet rs) throws java.sql.SQLException
Returns a GroovyRowResult given a ResultSet.- Parameters:
rs
- a ResultSet- Returns:
- the resulting GroovyRowResult
- Throws:
java.sql.SQLException
- if a database error occurs- Since:
- 1.6.0
-
toTimestamp
public static java.sql.Timestamp toTimestamp(java.util.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 java.util.Iterator<ResultSetMetaDataWrapper> iterator(java.sql.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
-
-