Mocking the Sql object

[go2toa]

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 = []
sql.eachRow(query) {
results << [ someKey:field1, someValue:field2 ]
}

I'm trying to use mockFor(Sql) and override the sql.eachRow method without much luck. Any ideas?




Steve

[go2toa]

Just this alone causes the test to fail...

def mockSql = MockFor(Sql)