Spring Boot different data.sql files for different h2 tests

Question

@RunWith(SpringRunner.class)
@SpringBootTest(classes=Application.class)
public class TaskProviderTest {
}

I'm using h2 database configured in property file

spring.datasource.url=jdbc:h2:mem:testdb;MODE=PostgreSQL
spring.datasource.platform=h2
spring.jpa.hibernate.ddl-auto=none
spring.datasource.continue-on-error=true
spring.jpa.generate-ddl=true
spring.jpa.hibernate.ddl-auto=create-drop

And I'm using schema.sql and data.sql files for unit tests. Both scripts are executed on test startup.

Is there anyway to use different data.sql files for different Junit test cases ?

How are you loading data.sql currently ? I mean can you add the code ? — Vasu
– Vasu, Commented Nov 24, 2016 at 14:56

Eugene Ustimenko · Accepted Answer · 2016-11-24 16:25:32Z

1

Try to use EmbeddedDataSource and configure it from method in code. The code below is demonstrates how to create datasource with 2 sql scripts

@Bean
public DataSource dataSource() {
    final EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();

    return builder
            .setType(EmbeddedDatabaseType.HSQL)
            .addScript("sql/create-db.sql")
            .addScript("sql/fill-db.sql")
            .build();
}

answered Nov 24, 2016 at 16:25

Eugene Ustimenko

3324 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ck1 · Accepted Answer · 2016-11-24 16:27:59Z

1

You can use Spring's EmbeddedDatabaseBuilder to construct the database in the setUp() method of your unit tests, providing different data.sql scripts for different tests.

Example:

public EmbeddedDatabase database(String dataScript) {
    return new EmbeddedDatabaseBuilder().
            setType(H2).
            addScript("schema.sql").
            addScript(dataScript).
            build();
}

Reference:

http://docs.spring.io/spring/docs/current/javadoc-api/org/springframework/jdbc/datasource/embedded/EmbeddedDatabaseBuilder.html

answered Nov 24, 2016 at 16:27

ck1

5,4631 gold badge23 silver badges25 bronze badges

Collectives™ on Stack Overflow

Spring Boot different data.sql files for different h2 tests

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related