The proposition consists in keeping 2 tests specifications in cps-ri org/onap/cps/spi/impl package:

• CpsModulePersistenceServiceSpec (defaut unit tests using mocks)
• CpsModulePersistenceServiceIntegrationSpec (integration test using container db instance)

See Gerrit comment https://gerrit.onap.org/r/c/cps/+/121980/4/cps-ri/src/test/groovy/org/onap/cps/spi/impl/CpsModulePersistenceServiceUnitSpec.groovy#36
and wiki documenation: https://wiki.onap.org/pages/viewpage.action?pageId=92998161#Groovy&SpockTestCodeConventions-Namingconventions