overmocking.java

import org.hibernate.Session
import org.hibernate.SessionFactory
import org.hibernate.query.NativeQuery
import org.hibernate.query.Query

class SomeRepoSpec extends Specification {

    def sessionFactory = Mock(SessionFactory)

    def repo = new FundingRepository(sessionFactory);

    def 'should list something'() {
        given:
            def sqlQuery = Mock()
            def nativeQuery = Mock()
            def session = Mock()
        when:
            repo.findSomething(...)
        then:
            1 * sessionFactory.getCurrentSession() >> session
            1 * session.createSQLQuery({ it.contains('find_something') } as String) >> nativeQuery
            1 * nativeQuery.setString("criteria", "{\"a\":223,\"criteria\":{\"b\":35},\"c\":\"2019-01-01 00:00:11\"}") >> sqlQuery
        and:
        then:
            1 * sessionFactory.getCurrentSession() >> session
            1 * session.createSQLQuery({ it.contains('get_new_amount_snapshot') } as String) >> nativeQuery
            1 * nativeQuery.setLong('loanId', bean.loanId) >> sqlQuery
            1 * sqlQuery.setLong('x', 1) >> sqlQuery
            1 * sqlQuery.setString('y', 2) >> sqlQuery
            1 * sqlQuery.setString("z", _ as String) >> sqlQuery
    }
}