I need to mock the results of a Sql query. This is the code being tested.
def query = "select field1, field2 from table1"
def sql = new Sql(dataSource)
def results = 
results << [ someKey:field1, someValue:field2 ]
I'm trying to use mockFor(Sql) and override the sql.eachRow method without much luck. Any ideas?