How to use external postgresql database instead of embedded h2 for JUnit tests (development)

[jonbally]

Hi,

I am currently investigating an issue I observed with the OsvDownloadTask (will create an Issue in this repo when I have more concrete information). I wanted to replicate the scenario as best as possible and thus also use an external postgresql database instead of the embedded h2 database while running a JUnit test within IntelliJ.
I have tried various ways to overwrite the usage of the default h2 database (Editing application.properties, setting the ALPINE_DATABASE_ env variables as JVM options in the run config for the test) but it seems like the test still uses h2.

How can I achieve what I described above?

Edit: I found out why the tests in PersistenceCapableTest / OsvDownloadTaskTest default to h2: init() calls the alpine method Config.enableUnitTests() which in turn means a default h2 PersistanceManagerFactory is used.
Any pointers to how I can create a kind of integration test that uses postgresql? I would like to have a quickly reproducible way of running an OsvDownloadTask with a postgresql datastore, without much else happening. Does my approach make sense?

[nscuro]

Sorry for previously missing this. Now that you closed it, it popped up in my feed again, so here's the response:

I think you could take some inspiration from how we did it in an older Hyades version: https://github.com/DependencyTrack/hyades-apiserver/blob/5.6.0/apiserver/src/test/java/org/dependencytrack/PersistenceCapableTest.java

Here is the most relevant part: https://github.com/DependencyTrack/hyades-apiserver/blob/5bba0d2acd517171e7eced942ae6f8ddcf948cc7/apiserver/src/test/java/org/dependencytrack/PersistenceCapableTest.java#L94-L113

Note that Hyades uses Liquibase to create the database schema so you'll need to change these lines to: https://github.com/stevespringett/Alpine/blob/01134ba3ebde90b86133ef9c8340616d7d4dff97/alpine-server/src/main/java/alpine/server/persistence/PersistenceManagerFactory.java#L67-L71

[jonbally]

Thanks for the reply 👍