groovy.sql
Class DataSet

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

public class DataSet
extends Sql

Represents an extent of objects

Version:
$Revision: 10922 $
Author:
Chris Stevenson, Paul King, James Strachan

Field Summary
private  java.util.List params
           
private  DataSet parent
           
private  boolean reversed
           
private  Closure sort
           
private  SqlOrderByVisitor sortVisitor
           
private  java.lang.String sql
           
private  java.lang.String table
           
private  SqlWhereVisitor visitor
           
private  Closure where
           
 
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, updateCount, VARBINARY, VARCHAR
 
Constructor Summary
private DataSet(DataSet parent)
           
private DataSet(DataSet parent, Closure where)
           
private DataSet(DataSet parent, Closure where, Closure sort)
           
  DataSet(Sql sql, java.lang.Class type)
           
  DataSet(Sql sql, java.lang.String table)
           
 
Method Summary
 void add(java.util.Map values)
           
 DataSet createView(Closure criteria)
           
 void each(Closure closure)
           
 DataSet findAll(Closure where)
           
 java.lang.Object firstRow()
          Returns the first row from a DataSet's underlying table
 java.util.List getParameters()
           
 java.lang.String getSql()
           
private  java.lang.String getSqlOrderBy()
           
protected  SqlOrderByVisitor getSqlOrderByVisitor()
           
private  java.lang.String getSqlWhere()
           
protected  SqlWhereVisitor getSqlWhereVisitor()
           
 DataSet reverse()
           
 java.util.List rows()
          Returns a List of all of the rows from the table a DataSet represents
 DataSet sort(Closure sort)
           
private  void visit(Closure closure, CodeVisitorSupport visitor)
           
 
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, eachRow, execute, execute, execute, executeInsert, executeInsert, executeInsert, executeUpdate, executeUpdate, executeUpdate, expand, findWhereKeyword, firstRow, firstRow, firstRow, FLOAT, getConnection, getDataSource, getParameters, getResultSetConcurrency, getResultSetHoldability, getResultSetType, 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, rows, rows, setObject, setParameters, setResultSetConcurrency, setResultSetHoldability, setResultSetType, 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
 

Field Detail

where

private Closure where

sort

private Closure sort

reversed

private boolean reversed

parent

private DataSet parent

table

private java.lang.String table

visitor

private SqlWhereVisitor visitor

sortVisitor

private SqlOrderByVisitor sortVisitor

sql

private java.lang.String sql

params

private java.util.List params
Constructor Detail

DataSet

public DataSet(Sql sql,
               java.lang.Class type)

DataSet

public DataSet(Sql sql,
               java.lang.String table)

DataSet

private DataSet(DataSet parent,
                Closure where)

DataSet

private DataSet(DataSet parent,
                Closure where,
                Closure sort)

DataSet

private DataSet(DataSet parent)
Method Detail

add

public void add(java.util.Map values)
         throws java.sql.SQLException
Throws:
java.sql.SQLException

findAll

public DataSet findAll(Closure where)

sort

public DataSet sort(Closure sort)

reverse

public DataSet reverse()

each

public void each(Closure closure)
          throws java.sql.SQLException
Throws:
java.sql.SQLException

getSqlWhere

private java.lang.String getSqlWhere()

getSqlOrderBy

private java.lang.String getSqlOrderBy()

getSql

public java.lang.String getSql()

getParameters

public java.util.List getParameters()

getSqlWhereVisitor

protected SqlWhereVisitor getSqlWhereVisitor()

getSqlOrderByVisitor

protected SqlOrderByVisitor getSqlOrderByVisitor()

visit

private void visit(Closure closure,
                   CodeVisitorSupport visitor)

createView

public DataSet createView(Closure criteria)

rows

public java.util.List rows()
                    throws java.sql.SQLException
Returns a List of all of the rows from the table a DataSet represents

Returns:
Returns a list of GroovyRowResult objects from the dataset
Throws:
java.sql.SQLException - if a database error occurs

firstRow

public java.lang.Object firstRow()
                          throws java.sql.SQLException
Returns the first row from a DataSet's underlying table

Returns:
Returns the first GroovyRowResult object from the dataset
Throws:
java.sql.SQLException - if a database error occurs


Copyright © ${year} The Codehaus. All Rights Reserved.