groovy.sql
Class DataSet

java.lang.Object
  groovy.sql.Sql
      groovy.sql.DataSet

public class DataSet
extends Sql

Represents an extent of objects

Version:

$Revision: 1197 $

Author:

Chris Stevenson, James Strachan

Field Summary

Fields inherited from class groovy.sql.Sql

ARRAY, BIGINT, BINARY, BIT, BLOB, BOOLEAN, CHAR, CLOB, DATALINK, DATE, DECIMAL, DISTINCT, DOUBLE, FLOAT, INTEGER, JAVA_OBJECT, log, LONGVARBINARY, LONGVARCHAR, NULL, NUMERIC, OTHER, REAL, REF, SMALLINT, STRUCT, TIME, TIMESTAMP, TINYINT, VARBINARY, VARCHAR

Constructor Summary

DataSet(DataSet parent, Closure where)

DataSet(Sql sql, Class type)

DataSet(Sql sql, String table)

Method Summary

void	add(Map values)
DataSet	createView(Closure criteria)
void	each(Closure closure)
DataSet	findAll(Closure where)
List	getParameters()
String	getSql()
protected SqlWhereVisitor	getSqlVisitor()

Methods inherited from class groovy.sql.Sql

ARRAY, asSql, BIGINT, BINARY, BIT, BLOB, BOOLEAN, call, call, call, call, call, CHAR, CLOB, close, closeResources, closeResources, commit, configure, createConnection, DATALINK, dataSet, dataSet, DATE, DECIMAL, DISTINCT, DOUBLE, eachRow, eachRow, eachRow, execute, execute, execute, executeInsert, executeInsert, executeInsert, executeUpdate, executeUpdate, executeUpdate, expand, findWhereKeyword, firstRow, firstRow, FLOAT, getConnection, getDataSource, getParameters, getUpdateCount, in, inout, INTEGER, JAVA_OBJECT, loadDriver, LONGVARBINARY, LONGVARCHAR, newInstance, newInstance, newInstance, newInstance, newInstance, newInstance, NULL, nullify, NUMERIC, OTHER, out, query, query, query, queryEach, queryEach, queryEach, REAL, REF, resultSet, rollback, rows, rows, setObject, setParameters, SMALLINT, STRUCT, TIME, TIMESTAMP, TINYINT, VARBINARY, VARCHAR, withStatement

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DataSet

public DataSet(Sql sql,
               Class type)

DataSet

public DataSet(Sql sql,
               String table)

DataSet

public DataSet(DataSet parent,
               Closure where)

Method Detail

add

public void add(Map values)
         throws SQLException

Throws:

SQLException

findAll

public DataSet findAll(Closure where)

each

public void each(Closure closure)
          throws SQLException

Throws:

SQLException

getSql

public String getSql()

getParameters

public List getParameters()

getSqlVisitor

protected SqlWhereVisitor getSqlVisitor()

createView

public DataSet createView(Closure criteria)