How to inject property values into a Spock test?

Question

When using a Spock test, i have hardcoded some properties hardcoded into the spock test. The example is a JDBC url. I tried the @Value annotation together with a propertie file, but this seems not to work as my test has no stereotype. Are there any other solutions to inject property values?

@ContextConfiguration(locations = "classpath*:applicationContext-test.xml")
class RepositoryTest extends Specification {

    @Shared sql = Sql.newInstance("jdbc:sqlserver:// - room - for - properties")    

}

score 4 · Answer 1 · edited May 23 '17 at 11:46

To use PropertySourcesPlaceholderConfigurer, add a @Configuration class:

@Configuration
@PropertySource("classpath:database.properties")
public class DatabaseConfig {
    @Bean
    public static PropertySourcesPlaceholderConfigurer propertySourcesPlaceholderConfigurer() {
        return new PropertySourcesPlaceholderConfigurer();
    }
}

Reference is here.

And then, in Spock:

@Value('${foo.bar}') //Use single quote.
String fooBar

The reason to use single quote is here.

And you probably need to add @ContextConfiguration to your Spock class:

@ContextConfiguration(classes = DatabaseConfig .class)
class Test extends Specification {
    ...
}

score 1 · Accepted Answer · answered Jul 03 '11 at 20:13

1

@Shared properties cannot be injected, but something like this should work (with Spring 3):

@Value("#{databaseProperties.jdbcUrl}")
String jdbcUrl

Sql sql

def setup() {
  if (!sql) {
    sql = new Sql(jdbcUrl)
  }
}

This assumes that you have defined "databaseProperties" in your bean definition file:

<util:properties id="databaseProperties" location="classpath:database.properties" />

answered Jul 03 '11 at 20:13

Peter Niederwieser

116,995
20
311
250

Earlier on i tried to do more or less the same with a PropertyPlaceholderConfigurer, but i could not get this to work together with the @Value annotation. Your way of using the util:properties works perfect! – Marco Jul 04 '11 at 09:24
Is it also possible to use the PropertyPlaceholderConfigurer for this? – Marco Jul 04 '11 at 09:37

score 0 · Answer 3 · answered Jun 30 '11 at 22:37

0

use jvm system properties "java -DdbUsername=bbbb"

answered Jun 30 '11 at 22:37

Aravind Yarram

76,625
45
224
313

How to inject property values into a Spock test?

3 Answers3

Linked