使用Spock和服务类在Grails中进行数据驱动测试

Question

class MyServiceSpec extends Specification {
    def myService
    def sqlService
    @Shared tsQuery
    @Shared ts

    def setupSpec() {
        tsQuery = "select column1, column2, column3 from table where column1 = ?"
        ts = sqlService.rows(tsQuery, ['someSuch'])
    }

    def "test a feature"() {
        setup:
            def ts = sqlService.rows(tsQuery)
            def results = myService.getTimesheets(thing1, thing2, thing3)
        expect: 
            //some appropriate expectations based on the data here
        where:
            timeSheet << ts
            thing1 = timeSheet.column1
            thing2 = timeSheet.column2
            thing3 = timeSheet.column3
    }
}

Only @Shared and static fields may be accessed from here
       ts = sqlService.rows(tsQuery)
            ^

问题是，如果我使sqlService@shared，Grails依赖项注入不起作用，它只创建一个空对象。如果我尝试将其设置为静态（如static def sqlservice)，情况也是如此。

java.lang.NullPointerException: Cannot invoke method rows() on null object

我尝试将一个新的SqlService实例小型化，就像我的setupSpec块中所示：

    def setupSpec() {
        tsQuery = "select column1, column2, column3 from table where column1 = 'someSuch'"
        def sql = new SqlService()
        ts = sql.rows(tsQuery)
    }

这只是给出了一个错误

有人知道我如何在Spock测试中使用另一个服务类作为数据提供者吗？

Answer 1

所以，这就是我的工作测试类最终的样子：

package edu.missouristate.employee.dts

import spock.lang.*
import static org.junit.Assert.*
import org.junit.*
import groovy.sql.Sql
class MyServiceSpec extends Specification {
    def myService
    def dataSource
    @Shared tsQuery
    @Shared ts

    def setup() {
        tsQuery = '''select column1, column2, column3 
            from table where column1 = ?
            and rownum < 6'''
        def sql = new Sql(dataSource)
        ts = ts ?: sql.rows(tsQuery, ['someSuch'])
        sql.close()
    }

    def "dummy test"() { //This is just to get the spec initialized.
        expect:
            1==1
    }

    def "test a feature"() {
        setup:
            def results = myService.getTimesheets(timeSheet.thing1, timeSheet.thing2, timeSheet.thing3)
        expect: 
            //some appropriate expectations based on the data here, e.g.
            results[0].someProperty == timeSheet.correspondingDatabaseColumn
        where:
            timeSheet << ts
    }
}

简而言之，我放弃了使用自己的sqlService类，而是直接使用Groovy Sql类。

其他注意事项：我在测试方法和迭代中有效地重用了ts对象，因为我只想从数据库中提取一次数据。我还在查询中添加了rownum限制，这样它就只能执行这么多的迭代。