I read a lot about unit and integration tests and how they work with maven and java and how it works with Continuous Integration.
I am using Flyway for db migrations, the schema part is already done.
But it is not clear to me how to get the data for integration tests.
What is the best or most common choice and why? Below some ideas that I had.
A static SQL dump along with integration test code;
A script that makes a dump from Production every time the integration test runs;
Something like @parametrizedTest from JUnit (static code that generates the data);