Index (Groovy 2.5.8)

A B C D E F G H I J K L N O P Q R S T V W
All Classes All Packages

A

AbstractQueryCommand(String) - Constructor for class groovy.sql.Sql.AbstractQueryCommand
add(Map) - Method in interface groovy.sql.GroovyResultSet: Adds a new row to this result set
add(Map) - Method in class groovy.sql.GroovyResultSetExtension: Adds a new row to the result set
add(Map<String, Object>) - Method in class groovy.sql.DataSet: Adds the provided map of key-value pairs as a new row in the table represented by this DataSet.
addBatch(Object[]) - Method in class groovy.sql.BatchingPreparedStatementWrapper
addBatch(String) - Method in class groovy.sql.BatchingStatementWrapper
addBatch(List<Object>) - Method in class groovy.sql.BatchingPreparedStatementWrapper
ALL_RESULT_SETS - Static variable in class groovy.sql.Sql
ARRAY - Static variable in class groovy.sql.Sql
ARRAY(Object) - Static method in class groovy.sql.Sql
asBoolean(GroovyResultSet) - Static method in class org.apache.groovy.sql.extensions.SqlExtensions: Coerce a GroovyResultSet to a boolean value.
asBoolean(GroovyResultSet) - Static method in class org.codehaus.groovy.runtime.SqlGroovyMethods: Deprecated.
asList(String, ResultSet) - Method in class groovy.sql.Sql: Hook to allow derived classes to override list of result collection behavior.
asList(String, ResultSet, int, int, Closure) - Method in class groovy.sql.Sql
asList(String, ResultSet, Closure) - Method in class groovy.sql.Sql: Hook to allow derived classes to override list of result collection behavior.
asSql(GString, List<Object>) - Method in class groovy.sql.Sql: Hook to allow derived classes to override sql generation from GStrings.

B

batchCount - Variable in class groovy.sql.BatchingStatementWrapper
BatchingPreparedStatementWrapper - Class in groovy.sql: Class which delegates to a PreparedStatement but keeps track of a batch count size.
BatchingPreparedStatementWrapper(PreparedStatement, List<Tuple>, int, Logger, Sql) - Constructor for class groovy.sql.BatchingPreparedStatementWrapper
BatchingStatementWrapper - Class in groovy.sql: Class which delegates to a Statement but keeps track of a batch count size.
BatchingStatementWrapper(Statement, int, Logger) - Constructor for class groovy.sql.BatchingStatementWrapper
batchSize - Variable in class groovy.sql.BatchingStatementWrapper
BIGINT - Static variable in class groovy.sql.Sql
BIGINT(Object) - Static method in class groovy.sql.Sql
BINARY - Static variable in class groovy.sql.Sql
BINARY(Object) - Static method in class groovy.sql.Sql
BIT - Static variable in class groovy.sql.Sql
BIT(Object) - Static method in class groovy.sql.Sql
BLOB - Static variable in class groovy.sql.Sql
BLOB(Object) - Static method in class groovy.sql.Sql
BOOLEAN - Static variable in class groovy.sql.Sql
BOOLEAN(Object) - Static method in class groovy.sql.Sql
buildSqlWithIndexedProps(String) - Method in class groovy.sql.Sql: Hook to allow derived classes to override behavior associated with the parsing and indexing of parameters from a given sql statement.

C

cacheConnection(Closure) - Method in class groovy.sql.DataSet
cacheConnection(Closure) - Method in class groovy.sql.Sql: Caches the connection used while the closure is active.
cacheStatements(Closure) - Method in class groovy.sql.Sql: Caches every created preparedStatement in Closure closure Every cached preparedStatement is closed after closure has been called.
call(GString) - Method in class groovy.sql.Sql: Performs a stored procedure call with the given embedded parameters.
call(GString, Closure) - Method in class groovy.sql.Sql: Performs a stored procedure call with the given parameters, calling the closure once with all result objects.
call(String) - Method in class groovy.sql.Sql: Performs a stored procedure call.
call(String, Object[]) - Method in class groovy.sql.Sql: Performs a stored procedure call with the given parameters.
call(String, List<Object>) - Method in class groovy.sql.Sql: Performs a stored procedure call with the given parameters.
call(String, List<Object>, Closure) - Method in class groovy.sql.Sql: Performs a stored procedure call with the given parameters.
callWithAllRows(GString, Closure) - Method in class groovy.sql.Sql: Performs a stored procedure call with the given parameters, calling the closure once with all result objects, and also returning a list of lists with the rows of the ResultSet(s).
callWithAllRows(String, List<Object>, Closure) - Method in class groovy.sql.Sql: Performs a stored procedure call with the given parameters, calling the closure once with all result objects, and also returning a list of lists with the rows of the ResultSet(s).
callWithRows(GString, Closure) - Method in class groovy.sql.Sql: Performs a stored procedure call with the given parameters, calling the closure once with all result objects, and also returning the rows of the ResultSet.
callWithRows(String, List<Object>, int, Closure) - Method in class groovy.sql.Sql: Base internal method for call(), callWithRows(), and callWithAllRows() style of methods.
callWithRows(String, List<Object>, Closure) - Method in class groovy.sql.Sql: Performs a stored procedure call with the given parameters, calling the closure once with all result objects, and also returning the rows of the ResultSet.
CHAR - Static variable in class groovy.sql.Sql
CHAR(Object) - Static method in class groovy.sql.Sql
checkForNamedParams(String, List<Object>) - Method in class groovy.sql.Sql
clear() - Method in class groovy.sql.GroovyRowResult
clearBatch() - Method in class groovy.sql.BatchingStatementWrapper
CLOB - Static variable in class groovy.sql.Sql
CLOB(Object) - Static method in class groovy.sql.Sql
close() - Method in class groovy.sql.BatchingStatementWrapper
close() - Method in class groovy.sql.DataSet
close() - Method in class groovy.sql.Sql: If this SQL object was created with a Connection then this method closes the connection.
closeResources() - Method in class groovy.sql.Sql.AbstractQueryCommand: After performing the execute operation and making use of its return, it's necessary to free the resources allocated for the statement.
closeResources(Connection) - Method in class groovy.sql.Sql: An extension point allowing the behavior of resource closing to be overridden in derived classes.
closeResources(Connection, Statement) - Method in class groovy.sql.DataSet
closeResources(Connection, Statement) - Method in class groovy.sql.Sql: An extension point allowing the behavior of resource closing to be overridden in derived classes.
closeResources(Connection, Statement, ResultSet) - Method in class groovy.sql.DataSet
closeResources(Connection, Statement, ResultSet) - Method in class groovy.sql.Sql: An extension point allowing derived classes to change the behavior of resource closing.
closeResources(ResultSet) - Method in class groovy.sql.Sql.AbstractQueryCommand: After performing the execute operation and making use of its return, it's necessary to free the resources allocated for the statement.
commit() - Method in class groovy.sql.DataSet
commit() - Method in class groovy.sql.Sql: If this SQL object was created with a Connection then this method commits the connection.
configure(Statement) - Method in class groovy.sql.Sql: Provides a hook for derived classes to be able to configure JDBC statements.
containsKey(Object) - Method in class groovy.sql.GroovyRowResult: Checks if the result contains (ignoring case) the given key.
containsValue(Object) - Method in class groovy.sql.GroovyRowResult
createConnection() - Method in class groovy.sql.DataSet
createConnection() - Method in class groovy.sql.Sql: An extension point allowing derived classes to change the behavior of connection creation.
createPreparedQueryCommand(String, List<Object>) - Method in class groovy.sql.Sql: Factory for the PreparedQueryCommand command pattern object allows subclass to supply implementations of the command class.
createQueryCommand(String) - Method in class groovy.sql.Sql: Factory for the QueryCommand command pattern object allows subclasses to supply implementations of the command class.
createView(Closure) - Method in class groovy.sql.DataSet

D

DATALINK - Static variable in class groovy.sql.Sql
DATALINK(Object) - Static method in class groovy.sql.Sql
dataSet(Class<?>) - Method in class groovy.sql.Sql
dataSet(String) - Method in class groovy.sql.Sql
DataSet - Class in groovy.sql: An enhancement of Groovy's Sql class providing support for accessing and querying databases using POGO fields and operators rather than JDBC-level API calls and RDBMS column names.
DataSet(Sql, Class) - Constructor for class groovy.sql.DataSet
DataSet(Sql, String) - Constructor for class groovy.sql.DataSet
DATE - Static variable in class groovy.sql.Sql
DATE(Object) - Static method in class groovy.sql.Sql
DECIMAL - Static variable in class groovy.sql.Sql
DECIMAL(Object) - Static method in class groovy.sql.Sql
DISTINCT - Static variable in class groovy.sql.Sql
DISTINCT(Object) - Static method in class groovy.sql.Sql
DOUBLE - Static variable in class groovy.sql.Sql
DOUBLE(Object) - Static method in class groovy.sql.Sql

E

each(int, int, Closure) - Method in class groovy.sql.DataSet: Calls the provided closure for a "page" of rows from the table represented by this DataSet.
each(Closure) - Method in class groovy.sql.DataSet: Calls the provided closure for each of the rows of the table represented by this DataSet.
eachRow(Closure) - Method in interface groovy.sql.GroovyResultSet: Call the closure once for each row in the result set.
eachRow(Closure) - Method in class groovy.sql.GroovyResultSetExtension: Call the closure once for each row in the result set.
eachRow(GString, int, int, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given closure with each row of the result set starting at the provided offset, and including up to maxRows number of rows.
eachRow(GString, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given Closure with each row of the result set.
eachRow(GString, Closure, int, int, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given closure with each row of the result set starting at the provided offset, and including up to maxRows number of rows.
eachRow(GString, Closure, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given Closure with each row of the result set.
eachRow(String, int, int, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given closure with each row of the result set starting at the provided offset, and including up to maxRows number of rows.
eachRow(String, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given Closure with each row of the result set.
eachRow(String, Closure, int, int, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given rowClosure with each row of the result set starting at the provided offset, and including up to maxRows number of rows.
eachRow(String, Closure, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given rowClosure with each row of the result set.
eachRow(String, List<Object>, int, int, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given closure with each row of the result set starting at the provided offset, and including up to maxRows number of rows.
eachRow(String, List<Object>, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given Closure with each row of the result set.
eachRow(String, List<Object>, Closure, int, int, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given rowClosure with each row of the result set starting at the provided offset, and including up to maxRows number of rows.
eachRow(String, List<Object>, Closure, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query calling the given Closure with each row of the result set.
eachRow(String, Map, int, int, Closure) - Method in class groovy.sql.Sql: A variant of Sql.eachRow(String, java.util.List, int, int, groovy.lang.Closure) useful when providing the named parameters as a map.
eachRow(String, Map, Closure) - Method in class groovy.sql.Sql: A variant of Sql.eachRow(String, java.util.List, groovy.lang.Closure) useful when providing the named parameters as a map.
eachRow(String, Map, Closure, int, int, Closure) - Method in class groovy.sql.Sql: A variant of Sql.eachRow(String, java.util.List, groovy.lang.Closure, int, int, groovy.lang.Closure) allowing the named parameters to be supplied in a map.
eachRow(String, Map, Closure, Closure) - Method in class groovy.sql.Sql: A variant of Sql.eachRow(String, java.util.List, groovy.lang.Closure, groovy.lang.Closure) useful when providing the named parameters as a map.
eachRow(Map, String, int, int, Closure) - Method in class groovy.sql.Sql: A variant of Sql.eachRow(String, java.util.List, int, int, groovy.lang.Closure) useful when providing the named parameters as named arguments.
eachRow(Map, String, Closure) - Method in class groovy.sql.Sql: A variant of Sql.eachRow(String, java.util.List, groovy.lang.Closure) useful when providing the named parameters as named arguments.
eachRow(Map, String, Closure, int, int, Closure) - Method in class groovy.sql.Sql: A variant of Sql.eachRow(String, java.util.List, groovy.lang.Closure, int, int, groovy.lang.Closure) allowing the named parameters to be supplied as named arguments.
eachRow(Map, String, Closure, Closure) - Method in class groovy.sql.Sql: A variant of Sql.eachRow(String, java.util.List, groovy.lang.Closure, groovy.lang.Closure) useful when providing the named parameters as named arguments.
entrySet() - Method in class groovy.sql.GroovyRowResult
equals(Object) - Method in class groovy.sql.GroovyRowResult
execute() - Method in class groovy.sql.Sql.AbstractQueryCommand: Execute the command that's defined by the subclass following the Command pattern.
execute(GString) - Method in class groovy.sql.Sql: Executes the given SQL with embedded expressions inside.
execute(GString, Closure) - Method in class groovy.sql.Sql: Executes the given SQL with embedded expressions inside.
execute(String) - Method in class groovy.sql.Sql: Executes the given piece of SQL.
execute(String, Closure) - Method in class groovy.sql.Sql: Executes the given piece of SQL.
execute(String, Object[]) - Method in class groovy.sql.Sql: Executes the given piece of SQL with parameters.
execute(String, Object[], Closure) - Method in class groovy.sql.Sql: Executes the given piece of SQL with parameters.
execute(String, List<Object>) - Method in class groovy.sql.Sql: Executes the given piece of SQL with parameters.
execute(String, List<Object>, Closure) - Method in class groovy.sql.Sql: Executes the given piece of SQL with parameters.
execute(Map, String) - Method in class groovy.sql.Sql: A variant of Sql.execute(String, java.util.List) useful when providing the named parameters as named arguments.
execute(Map, String, Closure) - Method in class groovy.sql.Sql: A variant of Sql.execute(String, java.util.List, Closure) useful when providing the named parameters as named arguments.
executeBatch() - Method in class groovy.sql.BatchingStatementWrapper
executeInsert(GString) - Method in class groovy.sql.Sql: Executes the given SQL statement (typically an INSERT statement).
executeInsert(GString, List<String>) - Method in class groovy.sql.Sql: Executes the given SQL statement (typically an INSERT statement).
executeInsert(String) - Method in class groovy.sql.Sql: Executes the given SQL statement (typically an INSERT statement).
executeInsert(String, Object[]) - Method in class groovy.sql.Sql: Executes the given SQL statement (typically an INSERT statement).
executeInsert(String, String[]) - Method in class groovy.sql.Sql: Executes the given SQL statement (typically an INSERT statement).
executeInsert(String, String[], Object[]) - Method in class groovy.sql.Sql: Executes the given SQL statement (typically an INSERT statement).
executeInsert(String, List<Object>) - Method in class groovy.sql.Sql: Executes the given SQL statement (typically an INSERT statement).
executeInsert(String, List<Object>, List<String>) - Method in class groovy.sql.Sql: Executes the given SQL statement (typically an INSERT statement).
executeInsert(Map, String) - Method in class groovy.sql.Sql: A variant of Sql.executeInsert(String, java.util.List) useful when providing the named parameters as named arguments.
executeInsert(Map, String, List<String>) - Method in class groovy.sql.Sql: A variant of Sql.executeInsert(String, List, List) useful when providing the named parameters as named arguments.
executePreparedQuery(String, List<Object>) - Method in class groovy.sql.Sql: Useful helper method which handles resource management when executing a prepared query which returns a result set.
executeQuery(String) - Method in class groovy.sql.Sql: Useful helper method which handles resource management when executing a query which returns a result set.
executeUpdate(GString) - Method in class groovy.sql.Sql: Executes the given SQL update with embedded expressions inside.
executeUpdate(String) - Method in class groovy.sql.Sql: Executes the given SQL update.
executeUpdate(String, Object[]) - Method in class groovy.sql.Sql: Executes the given SQL update with parameters.
executeUpdate(String, List<Object>) - Method in class groovy.sql.Sql: Executes the given SQL update with parameters.
executeUpdate(Map, String) - Method in class groovy.sql.Sql: A variant of Sql.executeUpdate(String, java.util.List) useful when providing the named parameters as named arguments.
expand(Object) - Static method in class groovy.sql.Sql: When using GString SQL queries, allows a variable to be expanded in the Sql string rather than representing an sql parameter.
ExpandedVariable - Interface in groovy.sql: Identifies a variable to be expanded into the sql string rather than representing a placeholder.

F

findAll(Closure) - Method in class groovy.sql.DataSet: Return a lazy-implemented filtered view of this DataSet.
findWhereKeyword(String) - Method in class groovy.sql.Sql: Hook to allow derived classes to override where clause sniffing.
FIRST_RESULT_SET - Static variable in class groovy.sql.Sql
firstRow() - Method in class groovy.sql.DataSet: Returns the first row from a DataSet's underlying table
firstRow(GString) - Method in class groovy.sql.Sql: Performs the given SQL query and return the first row of the result set.
firstRow(String) - Method in class groovy.sql.Sql: Performs the given SQL query and return the first row of the result set.
firstRow(String, Object[]) - Method in class groovy.sql.Sql: Performs the given SQL query and return the first row of the result set.
firstRow(String, List<Object>) - Method in class groovy.sql.Sql: Performs the given SQL query and return the first row of the result set.
firstRow(Map, String) - Method in class groovy.sql.Sql: A variant of Sql.firstRow(String, java.util.List) useful when providing the named parameters as named arguments.
FLOAT - Static variable in class groovy.sql.Sql
FLOAT(Object) - Static method in class groovy.sql.Sql

G

get(Object) - Method in class groovy.sql.GroovyRowResult: Find the property value for the given name (ignoring case).
getAt(int) - Method in interface groovy.sql.GroovyResultSet: Supports integer-based subscript operators for accessing at numbered columns starting at zero.
getAt(int) - Method in class groovy.sql.GroovyResultSetExtension: Supports integer based subscript operators for accessing at numbered columns starting at zero.
getAt(int) - Method in class groovy.sql.GroovyRowResult: Retrieve the value of the property by its index.
getAt(String) - Method in interface groovy.sql.GroovyResultSet: Gets the value of the designated column in the current row as an Object.
getConnection() - Method in class groovy.sql.Sql: If this instance was created with a single Connection then the connection is returned.
getDataSource() - Method in class groovy.sql.Sql
getImpl() - Method in class groovy.sql.GroovyResultSetProxy: Gets a proxy instance that can be used as GroovyResultSet.
getMaxRows() - Method in class groovy.sql.Sql.AbstractQueryCommand: Get the maximum number of rows to return in the ResultSet
getObject() - Method in interface groovy.sql.ExpandedVariable
getOrderBy() - Method in class groovy.sql.SqlOrderByVisitor
getParameters() - Method in class groovy.sql.DataSet
getParameters() - Method in class groovy.sql.SqlWhereVisitor
getParameters(GString) - Method in class groovy.sql.Sql: Hook to allow derived classes to override behavior associated with extracting params from a GString.
getParams() - Method in class groovy.sql.SqlWithParams
getProperty(String) - Method in class groovy.sql.GroovyResultSetExtension: Gets the value of the designated column in the current row of as an Object.
getProperty(String) - Method in class groovy.sql.GroovyRowResult: Retrieve the value of the property by its (case-insensitive) name.
getProperty(String) - Method in class groovy.sql.ResultSetMetaDataWrapper
getResultSet() - Method in class groovy.sql.GroovyResultSetExtension: Gets the current result set.
getResultSetConcurrency() - Method in class groovy.sql.Sql: Gets the resultSetConcurrency for statements created using the connection.
getResultSetHoldability() - Method in class groovy.sql.Sql: Gets the resultSetHoldability for statements created using the connection.
getResultSetType() - Method in class groovy.sql.Sql: Gets the resultSetType for statements created using the connection.
getSql() - Method in class groovy.sql.DataSet
getSql() - Method in class groovy.sql.SqlWithParams
getSqlOrderByVisitor() - Method in class groovy.sql.DataSet
getSqlWhereVisitor() - Method in class groovy.sql.DataSet
getType() - Method in interface groovy.sql.InParameter: The JDBC data type.
getType() - Method in interface groovy.sql.OutParameter: Get the JDBC datatype for this parameter.
getUpdateCount() - Method in class groovy.sql.Sql
getUpdatedParams(List<Object>, List<Tuple>) - Method in class groovy.sql.Sql
getValue() - Method in interface groovy.sql.InParameter: The object holding the data value.
getWhere() - Method in class groovy.sql.SqlWhereVisitor
groovy.sql - package groovy.sql
GroovyResultSet - Interface in groovy.sql: Represents an extent of objects
GroovyResultSetExtension - Class in groovy.sql: GroovyResultSetExtension implements additional logic for ResultSet.
GroovyResultSetExtension(ResultSet) - Constructor for class groovy.sql.GroovyResultSetExtension: Creates a GroovyResultSet implementation.
GroovyResultSetProxy - Class in groovy.sql: GroovyResultSetProxy is used to create a proxy for GroovyResultSet.
GroovyResultSetProxy(GroovyResultSetExtension) - Constructor for class groovy.sql.GroovyResultSetProxy: Creates a new proxy instance with a custom extension.
GroovyResultSetProxy(ResultSet) - Constructor for class groovy.sql.GroovyResultSetProxy: Creates a new proxy instance.
GroovyRowResult - Class in groovy.sql: Represents an extent of objects.
GroovyRowResult(Map) - Constructor for class groovy.sql.GroovyRowResult

H

hashCode() - Method in class groovy.sql.GroovyRowResult

I

in(int, Object) - Static method in class groovy.sql.Sql: Create a new InParameter
incrementBatchCount() - Method in class groovy.sql.BatchingStatementWrapper: Increments batch count (after addBatch(..) has been called) and execute delegate.executeBatch() if batchSize has been reached.
inout(InParameter) - Static method in class groovy.sql.Sql: Create an inout parameter using this in parameter.
InOutParameter - Interface in groovy.sql: A typed parameter passed to, and returned from a CallableStatement.
InParameter - Interface in groovy.sql: A typed parameter to pass to a query
INTEGER - Static variable in class groovy.sql.Sql
INTEGER(Object) - Static method in class groovy.sql.Sql
invoke(Object, Method, Object[]) - Method in class groovy.sql.GroovyResultSetProxy: Invokes a method for the GroovyResultSet.
invokeMethod(String, Object) - Method in class groovy.sql.BatchingStatementWrapper
invokeMethod(String, Object) - Method in class groovy.sql.GroovyResultSetExtension
invokeMethod(String, Object) - Method in class groovy.sql.ResultSetMetaDataWrapper
isCacheNamedQueries() - Method in class groovy.sql.Sql
isCacheStatements() - Method in class groovy.sql.Sql
isEmpty() - Method in class groovy.sql.GroovyRowResult
isEnableNamedQueries() - Method in class groovy.sql.Sql
isWithinBatch() - Method in class groovy.sql.Sql: Returns true if the current Sql object is currently executing a withBatch method call.
iterator(ResultSetMetaData) - Static method in class org.apache.groovy.sql.extensions.SqlExtensions: Return an Iterator given a ResultSetMetaData.
iterator(ResultSetMetaData) - Static method in class org.codehaus.groovy.runtime.SqlGroovyMethods: Deprecated.

J

JAVA_OBJECT - Static variable in class groovy.sql.Sql
JAVA_OBJECT(Object) - Static method in class groovy.sql.Sql

K

keySet() - Method in class groovy.sql.GroovyRowResult

L

loadDriver(String) - Static method in class groovy.sql.Sql: Attempts to load the JDBC driver on the thread, current or system class loaders
log - Variable in class groovy.sql.BatchingStatementWrapper
LOG - Static variable in class groovy.sql.Sql: Hook to allow derived classes to access the log
LONGVARBINARY - Static variable in class groovy.sql.Sql
LONGVARBINARY(Object) - Static method in class groovy.sql.Sql
LONGVARCHAR - Static variable in class groovy.sql.Sql
LONGVARCHAR(Object) - Static method in class groovy.sql.Sql

N

newInstance(String) - Static method in class groovy.sql.Sql: Creates a new Sql instance given a JDBC connection URL.
newInstance(String, String) - Static method in class groovy.sql.Sql: Creates a new Sql instance given a JDBC connection URL and a driver class name.
newInstance(String, String, String) - Static method in class groovy.sql.Sql: Creates a new Sql instance given a JDBC connection URL, a username and a password.
newInstance(String, String, String, String) - Static method in class groovy.sql.Sql: Creates a new Sql instance given a JDBC connection URL, a username, a password and a driver class name.
newInstance(String, Properties) - Static method in class groovy.sql.Sql: Creates a new Sql instance given a JDBC connection URL and some properties.
newInstance(String, Properties, String) - Static method in class groovy.sql.Sql: Creates a new Sql instance given a JDBC connection URL, some properties and a driver class name.
newInstance(Map<String, Object>) - Static method in class groovy.sql.Sql: Creates a new Sql instance given parameters in a Map.
next() - Method in class groovy.sql.GroovyResultSetExtension: Moves the cursor down one row from its current position.
NO_RESULT_SETS - Static variable in class groovy.sql.Sql
normalizeIndex(int) - Method in class groovy.sql.GroovyResultSetExtension: Takes a zero based index and convert it into an SQL based 1 based index.
NULL - Static variable in class groovy.sql.Sql
NULL(Object) - Static method in class groovy.sql.Sql
nullify(String) - Method in class groovy.sql.Sql: Hook to allow derived classes to override null handling.
NUMERIC - Static variable in class groovy.sql.Sql
NUMERIC(Object) - Static method in class groovy.sql.Sql

O

org.apache.groovy.sql.extensions - package org.apache.groovy.sql.extensions
org.codehaus.groovy.runtime - package org.codehaus.groovy.runtime
OTHER - Static variable in class groovy.sql.Sql
OTHER(Object) - Static method in class groovy.sql.Sql
out(int) - Static method in class groovy.sql.Sql: Create a new OutParameter
OutParameter - Interface in groovy.sql: A parameter to be returned from a CallableStatement.

P

preCheckForNamedParams(String) - Method in class groovy.sql.Sql: Deprecated.
Use Sql.buildSqlWithIndexedProps(String) instead
previous() - Method in class groovy.sql.GroovyResultSetExtension: Moves the cursor to the previous row in this getResultSet() object.
processResult(int[]) - Method in class groovy.sql.BatchingStatementWrapper
put(Object, Object) - Method in class groovy.sql.GroovyRowResult: Associates the specified value with the specified property name in this result.
putAll(Map) - Method in class groovy.sql.GroovyRowResult: Copies all of the mappings from the specified map to this result.
putAt(int, Object) - Method in interface groovy.sql.GroovyResultSet: Supports integer based subscript operators for updating the values of numbered columns starting at zero.
putAt(int, Object) - Method in class groovy.sql.GroovyResultSetExtension: Supports integer based subscript operators for updating the values of numbered columns starting at zero.
putAt(String, Object) - Method in interface groovy.sql.GroovyResultSet: Updates the designated column with an Object value.

Q

query(GString, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query, which should return a single ResultSet object.
query(String, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query, which should return a single ResultSet object.
query(String, List<Object>, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query, which should return a single ResultSet object.
query(String, Map, Closure) - Method in class groovy.sql.Sql: A variant of Sql.query(String, java.util.List, groovy.lang.Closure) useful when providing the named parameters as a map.
query(Map, String, Closure) - Method in class groovy.sql.Sql: A variant of Sql.query(String, java.util.List, groovy.lang.Closure) useful when providing the named parameters as named arguments.

R

REAL - Static variable in class groovy.sql.Sql
REAL(Object) - Static method in class groovy.sql.Sql
REF - Static variable in class groovy.sql.Sql
REF(Object) - Static method in class groovy.sql.Sql
remove(Object) - Method in class groovy.sql.GroovyRowResult
reset() - Method in class groovy.sql.BatchingStatementWrapper
results - Variable in class groovy.sql.BatchingStatementWrapper
resultSet(int) - Static method in class groovy.sql.Sql: Create a new ResultSetOutParameter
ResultSetMetaDataWrapper - Class in groovy.sql: This class defines a wrapper for accessing a specific column in ResultSetMetaData.
ResultSetMetaDataWrapper(ResultSetMetaData, int) - Constructor for class groovy.sql.ResultSetMetaDataWrapper
ResultSetOutParameter - Interface in groovy.sql: A ResultSet out parameter.
reverse() - Method in class groovy.sql.DataSet: Return a lazy-implemented reverse-ordered view of this DataSet.
rollback() - Method in class groovy.sql.DataSet
rollback() - Method in class groovy.sql.Sql: If this SQL object was created with a Connection then this method rolls back the connection.
rows() - Method in class groovy.sql.DataSet: Returns a List of all of the rows from the table a DataSet represents.
rows(int, int) - Method in class groovy.sql.DataSet: Returns a "page" of the rows from the table a DataSet represents.
rows(GString) - Method in class groovy.sql.Sql: Performs the given SQL query and return the rows of the result set.
rows(GString, int, int) - Method in class groovy.sql.Sql: Performs the given SQL query and return a "page" of rows from the result set.
rows(GString, int, int, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query and return a "page" of rows from the result set.
rows(GString, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query and return the rows of the result set.
rows(String) - Method in class groovy.sql.Sql: Performs the given SQL query and return the rows of the result set.
rows(String, int, int) - Method in class groovy.sql.Sql: Performs the given SQL query and return a "page" of rows from the result set.
rows(String, int, int, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query and return a "page" of rows from the result set.
rows(String, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query and return the rows of the result set.
rows(String, Object[]) - Method in class groovy.sql.Sql: Performs the given SQL query and return the rows of the result set.
rows(String, Object[], int, int) - Method in class groovy.sql.Sql: Performs the given SQL query and return the rows of the result set.
rows(String, List<Object>) - Method in class groovy.sql.Sql: Performs the given SQL query and return the rows of the result set.
rows(String, List<Object>, int, int) - Method in class groovy.sql.Sql: Performs the given SQL query and return a "page" of rows from the result set.
rows(String, List<Object>, int, int, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query and return a "page" of rows from the result set.
rows(String, List<Object>, Closure) - Method in class groovy.sql.Sql: Performs the given SQL query and return the rows of the result set.
rows(String, Map, int, int) - Method in class groovy.sql.Sql: A variant of Sql.rows(String, java.util.List, int, int) useful when providing the named parameters as a map.
rows(String, Map, int, int, Closure) - Method in class groovy.sql.Sql: A variant of Sql.rows(String, java.util.List, int, int, groovy.lang.Closure) useful when providing the named parameters as a map.
rows(String, Map, Closure) - Method in class groovy.sql.Sql: A variant of Sql.rows(String, java.util.List, groovy.lang.Closure) useful when providing the named parameters as a map.
rows(Map, String) - Method in class groovy.sql.Sql: A variant of Sql.rows(String, java.util.List) useful when providing the named parameters as named arguments.
rows(Map, String, int, int) - Method in class groovy.sql.Sql: A variant of Sql.rows(String, java.util.List, int, int) useful when providing the named parameters as named arguments.
rows(Map, String, int, int, Closure) - Method in class groovy.sql.Sql: A variant of Sql.rows(String, java.util.List, int, int, groovy.lang.Closure) useful when providing the named parameters as named arguments.
rows(Map, String, Closure) - Method in class groovy.sql.Sql: A variant of Sql.rows(String, java.util.List, groovy.lang.Closure) useful when providing the named parameters as named arguments.
runQuery(Connection) - Method in class groovy.sql.Sql.AbstractQueryCommand: Perform the query.

S

setCacheNamedQueries(boolean) - Method in class groovy.sql.Sql: Enables named query caching.
if cacheNamedQueries is true, cache is created and processed named queries will be cached.
setCacheStatements(boolean) - Method in class groovy.sql.Sql: Enables statement caching.
if cacheStatements is true, cache is created and all created prepared statements will be cached.
setEnableNamedQueries(boolean) - Method in class groovy.sql.Sql: Enables named query support: if enableNamedQueries is true, queries with ':propname' and '?1.propname' style placeholders will be processed. if enableNamedQueries is false, this feature will be turned off.
setInternalConnection(Connection) - Method in class groovy.sql.Sql: Stub needed for testing.
setMaxRows(int) - Method in class groovy.sql.Sql.AbstractQueryCommand: Set the maximum number of rows to return in the ResultSet
setObject(PreparedStatement, int, Object) - Method in class groovy.sql.Sql: Strategy method allowing derived classes to handle types differently such as for CLOBs etc.
setParameters(List<Object>, PreparedStatement) - Method in class groovy.sql.Sql: Hook to allow derived classes to override behavior associated with setting params for a prepared statement.
setProperty(String, Object) - Method in class groovy.sql.GroovyResultSetExtension: Updates the designated column with an Object value.
setProperty(String, Object) - Method in class groovy.sql.ResultSetMetaDataWrapper
setResultSetConcurrency(int) - Method in class groovy.sql.Sql: Sets the resultSetConcurrency for statements created using the connection.
setResultSetHoldability(int) - Method in class groovy.sql.Sql: Sets the resultSetHoldability for statements created using the connection.
setResultSetType(int) - Method in class groovy.sql.Sql: Sets the resultSetType for statements created using the connection.
size() - Method in class groovy.sql.GroovyRowResult
SMALLINT - Static variable in class groovy.sql.Sql
SMALLINT(Object) - Static method in class groovy.sql.Sql
sort(Closure) - Method in class groovy.sql.DataSet: Return a lazy-implemented re-ordered view of this DataSet.
sql - Variable in class groovy.sql.Sql.AbstractQueryCommand
Sql - Class in groovy.sql: A facade over Java's normal JDBC APIs providing greatly simplified resource management and result set handling.
Sql(Sql) - Constructor for class groovy.sql.Sql
Sql(Connection) - Constructor for class groovy.sql.Sql: Constructs an SQL instance using the given Connection.
Sql(DataSource) - Constructor for class groovy.sql.Sql: Constructs an SQL instance using the given DataSource.
Sql.AbstractQueryCommand - Class in groovy.sql
SqlExtensions - Class in org.apache.groovy.sql.extensions: This class defines all the new SQL-related groovy methods which enhance the normal JDK SQL classes when inside the Groovy environment.
SqlExtensions() - Constructor for class org.apache.groovy.sql.extensions.SqlExtensions
SqlGroovyMethods - Class in org.codehaus.groovy.runtime: Deprecated.
use org.apache.groovy.sql.extensions.SqlExtensions
SqlGroovyMethods() - Constructor for class org.codehaus.groovy.runtime.SqlGroovyMethods: Deprecated.
SqlOrderByVisitor - Class in groovy.sql
SqlOrderByVisitor() - Constructor for class groovy.sql.SqlOrderByVisitor
SqlWhereVisitor - Class in groovy.sql
SqlWhereVisitor() - Constructor for class groovy.sql.SqlWhereVisitor
SqlWithParams - Class in groovy.sql
SqlWithParams(String, List<Object>) - Constructor for class groovy.sql.SqlWithParams
statement - Variable in class groovy.sql.Sql.AbstractQueryCommand
STRUCT - Static variable in class groovy.sql.Sql
STRUCT(Object) - Static method in class groovy.sql.Sql

T

TIME - Static variable in class groovy.sql.Sql
TIME(Object) - Static method in class groovy.sql.Sql
TIMESTAMP - Static variable in class groovy.sql.Sql
TIMESTAMP(Object) - Static method in class groovy.sql.Sql
TINYINT - Static variable in class groovy.sql.Sql
TINYINT(Object) - Static method in class groovy.sql.Sql
tokenAsSql(Token) - Method in class groovy.sql.SqlWhereVisitor
toRowResult(ResultSet) - Static method in class org.apache.groovy.sql.extensions.SqlExtensions: Returns a GroovyRowResult given a ResultSet.
toRowResult(ResultSet) - Static method in class org.codehaus.groovy.runtime.SqlGroovyMethods: Deprecated.
toString() - Method in class groovy.sql.GroovyResultSetExtension
toString() - Method in class groovy.sql.GroovyRowResult
toTimestamp(Date) - Static method in class org.apache.groovy.sql.extensions.SqlExtensions: Return a java.sql.Timestamp given a java.util.Date.
toTimestamp(Date) - Static method in class org.codehaus.groovy.runtime.SqlGroovyMethods: Deprecated.

V

values() - Method in class groovy.sql.GroovyRowResult
VARBINARY - Static variable in class groovy.sql.Sql
VARBINARY(Object) - Static method in class groovy.sql.Sql
VARCHAR - Static variable in class groovy.sql.Sql
VARCHAR(Object) - Static method in class groovy.sql.Sql
visitBinaryExpression(BinaryExpression) - Method in class groovy.sql.SqlWhereVisitor
visitBooleanExpression(BooleanExpression) - Method in class groovy.sql.SqlWhereVisitor
visitConstantExpression(ConstantExpression) - Method in class groovy.sql.SqlWhereVisitor
visitPropertyExpression(PropertyExpression) - Method in class groovy.sql.SqlOrderByVisitor
visitPropertyExpression(PropertyExpression) - Method in class groovy.sql.SqlWhereVisitor
visitReturnStatement(ReturnStatement) - Method in class groovy.sql.SqlOrderByVisitor
visitReturnStatement(ReturnStatement) - Method in class groovy.sql.SqlWhereVisitor
visitVariableExpression(VariableExpression) - Method in class groovy.sql.SqlWhereVisitor

W

withBatch(int, Closure) - Method in class groovy.sql.DataSet: Performs the closure (containing batch operations) within a batch.
withBatch(int, Closure) - Method in class groovy.sql.Sql: Performs the closure (containing batch operations) within a batch using a given batch size.
withBatch(int, String, Closure) - Method in class groovy.sql.Sql: Performs the closure (containing batch operations specific to an associated prepared statement) within a batch using a given batch size.
withBatch(Closure) - Method in class groovy.sql.DataSet: Performs the closure (containing batch operations) within a batch.
withBatch(Closure) - Method in class groovy.sql.Sql: Performs the closure (containing batch operations) within a batch.
withBatch(String, Closure) - Method in class groovy.sql.Sql: Performs the closure (containing batch operations specific to an associated prepared statement) within a batch.
withInstance(String, Closure) - Static method in class groovy.sql.Sql: Invokes a closure passing it a new Sql instance created from the given JDBC connection URL.
withInstance(String, String, Closure) - Static method in class groovy.sql.Sql: Invokes a closure passing it a new Sql instance created from the given JDBC connection URL.
withInstance(String, String, String, Closure) - Static method in class groovy.sql.Sql: Invokes a closure passing it a new Sql instance created from the given JDBC connection URL, user and password.
withInstance(String, String, String, String, Closure) - Static method in class groovy.sql.Sql: Invokes a closure passing it a new Sql instance created from the given JDBC connection URL.
withInstance(String, Properties, Closure) - Static method in class groovy.sql.Sql: Invokes a closure passing it a new Sql instance created from the given JDBC connection URL and properties.
withInstance(String, Properties, String, Closure) - Static method in class groovy.sql.Sql: Invokes a closure passing it a new Sql instance created from the given JDBC connection URL, properties and driver classname.
withInstance(Map<String, Object>, Closure) - Static method in class groovy.sql.Sql: Invokes a closure passing it a new Sql instance created from the given map of arguments.
withStatement(Closure) - Method in class groovy.sql.Sql: Allows a closure to be passed in to configure the JDBC statements before they are executed.
withTransaction(Closure) - Method in class groovy.sql.DataSet
withTransaction(Closure) - Method in class groovy.sql.Sql: Performs the closure within a transaction using a cached connection.

A B C D E F G H I J K L N O P Q R S T V W
All Classes All Packages