Running SQL queries for a specific test

[alexandre-touret]

Hi,
I'm a newcomer to code with Quarkus.

Everything is fine. However, I have one worry with the integration tests against SQL databases.

I would like to run some SQL files only for few integration tests.

Currently I can only inject one file (import.sql) at the startup for all the tests.

For instance, on Spring boot, we can use the @Sql for that purpose.

How can I get the same behaviour (or equivalent) in Quarkus?

Thanks for your help.
Alexandre

[mipo256]

@alexandre-touret There is no easy way out, I'm sorry :)

We used Spring heavily, and the @Sql annotation in Spring is helpful when we wanted to execute an arbitrary SQL before the test execution. What we ended-up doing is using native queries in Hibernate in @BeforeEach/@AfterEach callbacks. The problem is that this solution assumes you're using Hibernate / Panache, which is not always the case.

So, in every individual case the solution looks different, depending on the underlying persistence technology in place.