Index: /Users/jcarnell/groovy_projects/groovy/src/test/groovy/sql/SqlCompleteTest.groovy =================================================================== --- /Users/jcarnell/groovy_projects/groovy/src/test/groovy/sql/SqlCompleteTest.groovy (revision 5718) +++ /Users/jcarnell/groovy_projects/groovy/src/test/groovy/sql/SqlCompleteTest.groovy (working copy) @@ -57,6 +57,35 @@ assert results == expected } + void testDataSetWithRows(){ + def sql = createSql() + + def dataSet = new DataSet(sql,"FOOD") + def rows = dataSet.rows() + + //Expected names of the food items + def expected = ["edam", "brie", "cheddar", "beer", "coffee"] + + //Checking to make sure I got one item back + assert rows.size() == 5 + def results = [] + rows.each{results.add(it.name)} + + //Checking to make sure the results retrieved match the expected results + assert results == expected + } + + void testDataSetWithFirstRow(){ + def sql = createSql() + + def dataSet = new DataSet(sql,"FOOD") + def result = dataSet.firstRow() + + assert result!=null + assert result["name"]=="edam" + } + + void testDataSetWithClosurePredicate() { def sql = createSql()